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 133: -- This procedure will populate xla_events_gt table

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

Line 149: g_event_type_code xla_events.event_type_code%type;

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

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

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

Line 313: l_event_status_code xla_events.event_status_code%TYPE;

309: x_result_code OUT NOCOPY VARCHAR2) is
310:
311: l_application_id NUMBER;
312: l_rows_found NUMBER;
313: l_event_status_code xla_events.event_status_code%TYPE;
314:
315: BEGIN
316:
317: IF g_debug_mode = 'Y' THEN

Line 327: l_event_status_code := xla_events_pub_pkg.c_event_unprocessed;

323: -- and ledger_id. build pl/sql table of event type info.
324: init(p_calling_module, p_data_set_id);
325:
326: l_application_id := 275;
327: l_event_status_code := xla_events_pub_pkg.c_event_unprocessed;
328:
329:
330:
331: IF (g_entity_code = 'BUDGETS' or p_calling_module = 'FUNDS_CHECK') then

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

366: IF g_debug_mode = 'Y' THEN
367: pa_debug.g_err_stage:= 'Create Events: Event(s) exist for processing ..';
368: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
369:
370: pa_debug.g_err_stage:= 'Create Events: FC: Calling xla_events_pkg.create_event';
371: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
372: END IF;
373: -- -------------------------------------------------------------+
374:

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

372: END IF;
373: -- -------------------------------------------------------------+
374:
375: FOR i in t_event_date.FIRST..t_event_date.LAST LOOP
376: t_event_id(i) := xla_events_pub_pkg.create_event
377: (p_event_source_info => tt_source_info(i)
378: ,p_event_type_code => t_event_type_code(i)
379: ,p_event_date => t_event_date(i)
380: ,p_event_status_code => l_event_status_code

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

405:
406: END IF;
407:
408: -- -------------------------------------------------------------+
409: -- E5. Populate psa_bc_xla_events_gt with the new event_id's ...
410: IF g_debug_mode = 'Y' THEN
411: pa_debug.g_err_stage:= 'Create Events: FC: Populate psa_bc_xla_events_gt';
412: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
413:

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

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

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

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

Line 422: Insert into psa_bc_xla_events_gt(event_id,result_code)

418:
419: END IF;
420: -- -------------------------------------------------------------+
421: forall i in t_event_id.FIRST..t_event_id.LAST
422: Insert into psa_bc_xla_events_gt(event_id,result_code)
423: values(t_event_id(i),'XLA_ERROR');
424:
425: -- -------------------------------------------------------------+
426: -- E6. Delete pl/sql table ..

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

463: goto noprocessing;
464: END IF;
465:
466: IF g_debug_mode = 'Y' THEN
467: pa_debug.g_err_stage:= 'Calling xla_events_pub_pkg to raise events';
468: pa_debug.write('create_events ' || g_debug_module, pa_debug.g_err_stage, g_debug_level5);
469: END IF;
470:
471: FOR i in t_entity_id.first..t_entity_id.last LOOP

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

469: END IF;
470:
471: FOR i in t_entity_id.first..t_entity_id.last LOOP
472: IF t_raise_event(i) = 'Y' THEN
473: t_event_id(i) := xla_events_pub_pkg.create_event
474: (p_event_source_info => tt_source_info(i)
475: ,p_event_type_code => t_event_type_code(i)
476: ,p_event_date => t_event_date(i)
477: ,p_event_status_code => 'U'

Line 774: l_event_status_code := xla_events_pub_pkg.C_EVENT_UNPROCESSED;

770:
771: BEGIN
772:
773: l_application_id := 275;
774: l_event_status_code := xla_events_pub_pkg.C_EVENT_UNPROCESSED;
775:
776: t_tsc := t_tsc;
777: t_cr_ccid := t_cr_ccid;
778: t_sr5 := t_sr5;

Line 1435: from xla_events evt,

1431: t_source_id_char_3,
1432: t_source_id_char_4,
1433: t_security_org_id,
1434: t_source_event_id
1435: from xla_events evt,
1436: xla_transaction_entities txn
1437: where evt.entity_id = txn.entity_id
1438: and evt.event_id in
1439: (Select distinct bc_rev_event_id

Line 1489: from xla_events evt,

1485: t_source_id_char_3,
1486: t_source_id_char_4,
1487: t_security_org_id,
1488: t_source_event_id
1489: from xla_events evt,
1490: xla_transaction_entities txn
1491: where evt.entity_id = txn.entity_id
1492: and evt.event_id in
1493: (select distinct pbc1.bc_event_id

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

1543:
1544: -- D. Call XLA delete API
1545:
1546: IF g_debug_mode = 'Y' THEN
1547: pa_debug.g_err_stage:= 'Delete_xla_event_data:'||'Call xla_events_pub_pkg.delete_event';
1548: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1549: END IF;
1550:
1551: for i in t_source_event_id.FIRST..t_source_event_id.LAST loop

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

1548: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1549: END IF;
1550:
1551: for i in t_source_event_id.FIRST..t_source_event_id.LAST loop
1552: XLA_EVENTS_PUB_PKG.DELETE_EVENT(p_event_source_info => tt_source_info(i)
1553: ,p_event_id => t_source_event_id(i)
1554: ,p_valuation_method => NULL
1555: ,p_security_context => tt_security_info(i));
1556: end loop;

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

1671: End Reset_event_id;
1672:
1673: /*
1674: -- ---------------------------------------------------------------------------+
1675: -- This is the procedure that will get called to populate xla_events_gt
1676: -- ---------------------------------------------------------------------------+
1677: Procedure Populate_enc_events_gt (p_Source_Id_Int1 IN TypeNum,
1678: p_event_type_code IN TypeVarChar,
1679: p_event_date IN TypeDate,

Line 1696: l_event_status_code := xla_events_pub_pkg.c_event_unprocessed;

1692: END IF;
1693:
1694: -- 1. Set variables
1695: l_application_id := 275;
1696: l_event_status_code := xla_events_pub_pkg.c_event_unprocessed;
1697: l_user_id := fnd_global.user_id;
1698: g_enc_create_events_flag := 'Y'; -- accessed in create_events
1699:
1700: -- 2. Insert into xla_events_gt

Line 1700: -- 2. Insert into xla_events_gt

1696: l_event_status_code := xla_events_pub_pkg.c_event_unprocessed;
1697: l_user_id := fnd_global.user_id;
1698: g_enc_create_events_flag := 'Y'; -- accessed in create_events
1699:
1700: -- 2. Insert into xla_events_gt
1701: If p_calling_module = 'BUDGET' then
1702:
1703: forall i in p_Source_Id_Int1.first..p_Source_Id_Int1.last
1704: insert into xla_events_gt ( LINE_NUMBER,

Line 1704: insert into xla_events_gt ( LINE_NUMBER,

1700: -- 2. Insert into xla_events_gt
1701: If p_calling_module = 'BUDGET' then
1702:
1703: forall i in p_Source_Id_Int1.first..p_Source_Id_Int1.last
1704: insert into xla_events_gt ( LINE_NUMBER,
1705: ENTITY_ID,
1706: APPLICATION_ID,
1707: LEDGER_ID,
1708: LEGAL_ENTITY_ID,

Line 1802: -- and populate xla_events_gt

1798: */
1799: -- ---------------------------------------------------------------------------+
1800: -- This procedure will select/identify encumbrance data (for budget baseline,
1801: -- budget check funds,Year-end), Fund check - AP/PO/REQ, Interface - BTC/TBC
1802: -- and populate xla_events_gt
1803: -- ---------------------------------------------------------------------------+
1804: Procedure Populate_enc_event_array
1805: IS
1806:

Line 2056: from xla_events evt,

2052: t_security_org_id,
2053: t_source_event_id,
2054: t_event_type_code,
2055: t_reference_num_1
2056: from xla_events evt,
2057: xla_transaction_entities txn
2058: where evt.entity_id = txn.entity_id
2059: and evt.event_id in
2060: (select distinct source_event_id

Line 2235: l_acct_event_id XLA_Events.Event_ID%TYPE;

2231: l_Source_Distribution_Id_Num_2 XLA_Distribution_Links.Source_Distribution_Id_Num_2%TYPE;
2232: l_predefined_flag PA_Transaction_Sources.Predefined_Flag%TYPE;
2233: l_acct_source_code PA_Transaction_Sources.Acct_Source_Code%TYPE;
2234: l_Program_Code Xla_Post_Acct_Progs_b.Program_Code%TYPE;
2235: l_acct_event_id XLA_Events.Event_ID%TYPE;
2236: l_transfer_status_code PA_Cost_Distribution_Lines_All.transfer_status_code%TYPE;
2237: l_sys_ref5 PA_Cost_Distribution_Lines_All.system_reference5%TYPE;
2238: l_document_distribution_id PA_Expenditure_Items_All.document_distribution_id%TYPE;
2239: l_document_payment_id PA_Expenditure_Items_All.document_payment_id%TYPE;