بتاريخ: 12 أغسطس 201213 سنة comment_226754 [left]CREATE OR REPLACE PROCEDURE apps.xx_create_xxinvoice_event ( p_xxinvoice_id INTEGER, p_event_type VARCHAR2, p_event_date DATE, p_event_status VARCHAR2 ) IS l_receipt_source_info xla_events_pub_pkg.t_event_source_info; l_security_context xla_events_pub_pkg.t_security; BEGIN --- Perform Product specific checks -- Map generic event API parameter to the product specific columns l_receipt_source_info.source_application_id := 200; -- PLS_INTEGER DEFAULT NULL l_receipt_source_info.application_id := 20127; -- PLS_INTEGER l_receipt_source_info.legal_entity_id := 626; -- PLS_INTEGER --l_legal_entity_id; l_receipt_source_info.source_id_int_1 := p_xxinvoice_id; -- PLS_INTEGER ----------------------------------------------------------------------- l_receipt_source_info.ledger_id := 122; -- PLS_INTEGER l_receipt_source_info.entity_type_code := 'XX_INV'; -- VARCHAR2(30) l_receipt_source_info.transaction_number := 'B'; -- VARCHAR2(240) l_receipt_source_info.source_id_int_2 := 5; -- PLS_INTEGER l_receipt_source_info.source_id_int_3 := 6; -- PLS_INTEGER l_receipt_source_info.source_id_int_4 := 7; -- PLS_INTEGER l_receipt_source_info.source_id_char_1 := ' '; -- VARCHAR2(30) l_receipt_source_info.source_id_char_2 := ' '; -- VARCHAR2(30) l_receipt_source_info.source_id_char_3 := ' '; -- VARCHAR2(30) l_receipt_source_info.source_id_char_4 := ' '; -- VARCHAR2(30) ---------------------------------- apps.xla_events_pub_pkg.create_event (p_event_source_info => l_receipt_source_info, -- xla_events_pub_pkg.t_event_source_info p_event_type_code => p_event_type, -- VARCHAR2 p_event_date => p_event_date, -- DATE p_event_status_code => p_event_status, -- VARCHAR2 p_event_number => NULL, -- INTEGER DEFAULT NULL p_transaction_date => SYSDATE, -- DATE DEFAULT NULL p_referenece_info => NULL, -- xla_events_pub_pkg.t_event_reference_info DEFAULT NULL p_valuation_method => 'A', -- VARCHAR2 p_security_context => l_security_context, -- xla_events_pub_pkg.t_security p_budgetary_control_flag => 'N' ); --EXCEPTIONS END;[/left] تقديم بلاغ
انضم إلى المناقشة
يمكنك المشاركة الآن والتسجيل لاحقاً. إذا كان لديك حساب, سجل دخولك الآن لتقوم بالمشاركة من خلال حسابك.