eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_XLA_INTERFACE_PKG dependencies on XLA_EVENTS

Line 83: TYPE t_source_info is table of xla_events_pub_pkg.t_event_source_info index by binary_integer;

79: g_debug_level5 CONSTANT NUMBER := 5;
80:
81: Type CostCurType is REF CURSOR;
82:
83: TYPE t_source_info is table of xla_events_pub_pkg.t_event_source_info index by binary_integer;
84: tt_source_info t_source_info;
85: TYPE t_security_info is table of xla_events_pub_pkg.t_security index by binary_integer;
86: tt_security_info t_security_info;
87:

Line 85: TYPE t_security_info is table of xla_events_pub_pkg.t_security index by binary_integer;

81: Type CostCurType is REF CURSOR;
82:
83: TYPE t_source_info is table of xla_events_pub_pkg.t_event_source_info index by binary_integer;
84: tt_source_info t_source_info;
85: TYPE t_security_info is table of xla_events_pub_pkg.t_security index by binary_integer;
86: tt_security_info t_security_info;
87:
88: -- procedure to populate SLA's array with info required for raising
89: -- accounting events

Line 136: -- This procedure will populate xla_events_gt table

132: -- This procedure builds the pl/sql array for event creation
133:
134: PROCEDURE POPULATE_ENC_EVENT_ARRAY;
135:
136: -- This procedure will populate xla_events_gt table
137:
138: --PROCEDURE POPULATE_ENC_EVENTS_GT (p_Source_Id_Int1 IN TypeNum,
139: -- p_event_type_code IN TypeVarChar,
140: -- p_event_date IN TypeDate,

Line 152: g_event_type_code xla_events.event_type_code%type;

148:
149: PROCEDURE TIEBACK_BUDGET_EVENT;
150:
151: -- 2:0: Global variables
152: g_event_type_code xla_events.event_type_code%type;
153: g_bvid_to_reverse pa_budget_versions.budget_version_id%type;
154: g_enc_create_events_flag Varchar2(1);
155: l_events_to_delete Varchar2(1);
156:

Line 176: TYPE t_reference_info is table of xla_events_pub_pkg.t_event_reference_info index by binary_integer;

172: t_entity_type_code TypeVarChar;
173: t_transaction_number TypeVarChar240;
174: t_bc_rev_event_id TypeNum;
175:
176: TYPE t_reference_info is table of xla_events_pub_pkg.t_event_reference_info index by binary_integer;
177: tt_reference_info t_reference_info;
178:
179: t_reference_num_1 TypeVarChar;
180:

Line 318: l_event_status_code xla_events.event_status_code%TYPE;

314: x_result_code OUT NOCOPY VARCHAR2) is
315:
316: l_application_id NUMBER;
317: l_rows_found NUMBER;
318: l_event_status_code xla_events.event_status_code%TYPE;
319:
320: BEGIN
321:
322: IF g_debug_mode = 'Y' THEN

Line 332: l_event_status_code := xla_events_pub_pkg.c_event_unprocessed;

328: -- and ledger_id. build pl/sql table of event type info.
329: init(p_calling_module, p_data_set_id);
330:
331: l_application_id := 275;
332: l_event_status_code := xla_events_pub_pkg.c_event_unprocessed;
333:
334:
335:
336: IF (g_entity_code = 'BUDGETS' or p_calling_module = 'FUNDS_CHECK') then

Line 375: pa_debug.g_err_stage:= 'Create Events: FC: Calling xla_events_pkg.create_event';

371: IF g_debug_mode = 'Y' THEN
372: pa_debug.g_err_stage:= 'Create Events: Event(s) exist for processing ..';
373: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
374:
375: pa_debug.g_err_stage:= 'Create Events: FC: Calling xla_events_pkg.create_event';
376: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
377: END IF;
378: -- -------------------------------------------------------------+
379:

Line 381: t_event_id(i) := xla_events_pub_pkg.create_event

377: END IF;
378: -- -------------------------------------------------------------+
379:
380: FOR i in t_event_date.FIRST..t_event_date.LAST LOOP
381: t_event_id(i) := xla_events_pub_pkg.create_event
382: (p_event_source_info => tt_source_info(i)
383: ,p_event_type_code => t_event_type_code(i)
384: ,p_event_date => t_event_date(i)
385: ,p_event_status_code => l_event_status_code

Line 414: -- E5. Populate psa_bc_xla_events_gt with the new event_id's ...

410:
411: END IF;
412:
413: -- -------------------------------------------------------------+
414: -- E5. Populate psa_bc_xla_events_gt with the new event_id's ...
415: IF g_debug_mode = 'Y' THEN
416: pa_debug.g_err_stage:= 'Create Events: FC: Populate psa_bc_xla_events_gt';
417: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
418:

Line 416: pa_debug.g_err_stage:= 'Create Events: FC: Populate psa_bc_xla_events_gt';

412:
413: -- -------------------------------------------------------------+
414: -- E5. Populate psa_bc_xla_events_gt with the new event_id's ...
415: IF g_debug_mode = 'Y' THEN
416: pa_debug.g_err_stage:= 'Create Events: FC: Populate psa_bc_xla_events_gt';
417: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
418:
419: -- Events that are being populated into psa_bc_xla_events_gt
420: for x in t_event_id.FIRST..t_event_id.LAST loop

Line 419: -- Events that are being populated into psa_bc_xla_events_gt

415: IF g_debug_mode = 'Y' THEN
416: pa_debug.g_err_stage:= 'Create Events: FC: Populate psa_bc_xla_events_gt';
417: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
418:
419: -- Events that are being populated into psa_bc_xla_events_gt
420: for x in t_event_id.FIRST..t_event_id.LAST loop
421: pa_debug.write('create_events ' || g_debug_module,'Event id is:'||t_event_id(x), g_debug_level5);
422: end loop;
423:

Line 427: Insert into psa_bc_xla_events_gt(event_id,result_code)

423:
424: END IF;
425: -- -------------------------------------------------------------+
426: forall i in t_event_id.FIRST..t_event_id.LAST
427: Insert into psa_bc_xla_events_gt(event_id,result_code)
428: values(t_event_id(i),'XLA_ERROR');
429:
430: -- -------------------------------------------------------------+
431: -- E6. Delete pl/sql table ..

Line 472: pa_debug.g_err_stage:= 'Calling xla_events_pub_pkg to raise events';

468: goto noprocessing;
469: END IF;
470:
471: IF g_debug_mode = 'Y' THEN
472: pa_debug.g_err_stage:= 'Calling xla_events_pub_pkg to raise events';
473: pa_debug.write('create_events ' || g_debug_module, pa_debug.g_err_stage, g_debug_level5);
474: END IF;
475:
476: FOR i in t_entity_id.first..t_entity_id.last LOOP

Line 478: t_event_id(i) := xla_events_pub_pkg.create_event

474: END IF;
475:
476: FOR i in t_entity_id.first..t_entity_id.last LOOP
477: IF t_raise_event(i) = 'Y' THEN
478: t_event_id(i) := xla_events_pub_pkg.create_event
479: (p_event_source_info => tt_source_info(i)
480: ,p_event_type_code => t_event_type_code(i)
481: ,p_event_date => t_event_date(i)
482: ,p_event_status_code => 'U'

Line 782: l_event_status_code := xla_events_pub_pkg.C_EVENT_UNPROCESSED;

778:
779: BEGIN
780:
781: l_application_id := 275;
782: l_event_status_code := xla_events_pub_pkg.C_EVENT_UNPROCESSED;
783:
784: t_tsc := t_tsc;
785: t_cr_ccid := t_cr_ccid;
786: t_sr5 := t_sr5;

Line 1445: from xla_events evt,

1441: t_source_id_char_3,
1442: t_source_id_char_4,
1443: t_security_org_id,
1444: t_source_event_id
1445: from xla_events evt,
1446: xla_transaction_entities txn
1447: where evt.entity_id = txn.entity_id
1448: and evt.event_id in
1449: (Select distinct bc_rev_event_id

Line 1499: from xla_events evt,

1495: t_source_id_char_3,
1496: t_source_id_char_4,
1497: t_security_org_id,
1498: t_source_event_id
1499: from xla_events evt,
1500: xla_transaction_entities txn
1501: where evt.entity_id = txn.entity_id
1502: and evt.event_id in
1503: (select distinct pbc1.bc_event_id

Line 1557: pa_debug.g_err_stage:= 'Delete_xla_event_data:'||'Call xla_events_pub_pkg.delete_event';

1553:
1554: -- D. Call XLA delete API
1555:
1556: IF g_debug_mode = 'Y' THEN
1557: pa_debug.g_err_stage:= 'Delete_xla_event_data:'||'Call xla_events_pub_pkg.delete_event';
1558: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1559: END IF;
1560:
1561: for i in t_source_event_id.FIRST..t_source_event_id.LAST loop

Line 1562: XLA_EVENTS_PUB_PKG.DELETE_EVENT(p_event_source_info => tt_source_info(i)

1558: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1559: END IF;
1560:
1561: for i in t_source_event_id.FIRST..t_source_event_id.LAST loop
1562: XLA_EVENTS_PUB_PKG.DELETE_EVENT(p_event_source_info => tt_source_info(i)
1563: ,p_event_id => t_source_event_id(i)
1564: ,p_valuation_method => NULL
1565: ,p_security_context => tt_security_info(i));
1566: end loop;

Line 1685: -- This is the procedure that will get called to populate xla_events_gt

1681: End Reset_event_id;
1682:
1683: /*
1684: -- ---------------------------------------------------------------------------+
1685: -- This is the procedure that will get called to populate xla_events_gt
1686: -- ---------------------------------------------------------------------------+
1687: Procedure Populate_enc_events_gt (p_Source_Id_Int1 IN TypeNum,
1688: p_event_type_code IN TypeVarChar,
1689: p_event_date IN TypeDate,

Line 1706: l_event_status_code := xla_events_pub_pkg.c_event_unprocessed;

1702: END IF;
1703:
1704: -- 1. Set variables
1705: l_application_id := 275;
1706: l_event_status_code := xla_events_pub_pkg.c_event_unprocessed;
1707: l_user_id := fnd_global.user_id;
1708: g_enc_create_events_flag := 'Y'; -- accessed in create_events
1709:
1710: -- 2. Insert into xla_events_gt

Line 1710: -- 2. Insert into xla_events_gt

1706: l_event_status_code := xla_events_pub_pkg.c_event_unprocessed;
1707: l_user_id := fnd_global.user_id;
1708: g_enc_create_events_flag := 'Y'; -- accessed in create_events
1709:
1710: -- 2. Insert into xla_events_gt
1711: If p_calling_module = 'BUDGET' then
1712:
1713: forall i in p_Source_Id_Int1.first..p_Source_Id_Int1.last
1714: insert into xla_events_gt ( LINE_NUMBER,

Line 1714: insert into xla_events_gt ( LINE_NUMBER,

1710: -- 2. Insert into xla_events_gt
1711: If p_calling_module = 'BUDGET' then
1712:
1713: forall i in p_Source_Id_Int1.first..p_Source_Id_Int1.last
1714: insert into xla_events_gt ( LINE_NUMBER,
1715: ENTITY_ID,
1716: APPLICATION_ID,
1717: LEDGER_ID,
1718: LEGAL_ENTITY_ID,

Line 1812: -- and populate xla_events_gt

1808: */
1809: -- ---------------------------------------------------------------------------+
1810: -- This procedure will select/identify encumbrance data (for budget baseline,
1811: -- budget check funds,Year-end), Fund check - AP/PO/REQ, Interface - BTC/TBC
1812: -- and populate xla_events_gt
1813: -- ---------------------------------------------------------------------------+
1814: Procedure Populate_enc_event_array
1815: IS
1816:

Line 2066: from xla_events evt,

2062: t_security_org_id,
2063: t_source_event_id,
2064: t_event_type_code,
2065: t_reference_num_1
2066: from xla_events evt,
2067: xla_transaction_entities txn
2068: where evt.entity_id = txn.entity_id
2069: and evt.event_id in
2070: (select distinct source_event_id

Line 2245: l_acct_event_id XLA_Events.Event_ID%TYPE;

2241: l_Source_Distribution_Id_Num_2 XLA_Distribution_Links.Source_Distribution_Id_Num_2%TYPE;
2242: l_predefined_flag PA_Transaction_Sources.Predefined_Flag%TYPE;
2243: l_acct_source_code PA_Transaction_Sources.Acct_Source_Code%TYPE;
2244: l_Program_Code Xla_Post_Acct_Progs_b.Program_Code%TYPE;
2245: l_acct_event_id XLA_Events.Event_ID%TYPE;
2246: l_transfer_status_code PA_Cost_Distribution_Lines_All.transfer_status_code%TYPE;
2247: l_sys_ref5 PA_Cost_Distribution_Lines_All.system_reference5%TYPE;
2248: l_document_distribution_id PA_Expenditure_Items_All.document_distribution_id%TYPE;
2249: l_document_payment_id PA_Expenditure_Items_All.document_payment_id%TYPE;