DBA Data[Home] [Help]

APPS.PA_XLA_INTF_REV_EVENTS dependencies on PA_PLSQL_DATATYPES

Line 23: l_project_id_tab PA_PLSQL_DATATYPES.Num15TabTyp;

19: PROCEDURE create_events (p_request_id NUMBER,
20: p_return_status OUT NOCOPY VARCHAR2)
21: IS
22:
23: l_project_id_tab PA_PLSQL_DATATYPES.Num15TabTyp;
24: l_project_id_tab_tmp PA_PLSQL_DATATYPES.Num15TabTyp;
25: l_revenue_num_tab PA_PLSQL_DATATYPES.Num15TabTyp;
26: l_revenue_num_tab_tmp PA_PLSQL_DATATYPES.Num15TabTyp;
27: l_gl_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

Line 24: l_project_id_tab_tmp PA_PLSQL_DATATYPES.Num15TabTyp;

20: p_return_status OUT NOCOPY VARCHAR2)
21: IS
22:
23: l_project_id_tab PA_PLSQL_DATATYPES.Num15TabTyp;
24: l_project_id_tab_tmp PA_PLSQL_DATATYPES.Num15TabTyp;
25: l_revenue_num_tab PA_PLSQL_DATATYPES.Num15TabTyp;
26: l_revenue_num_tab_tmp PA_PLSQL_DATATYPES.Num15TabTyp;
27: l_gl_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
28: l_event_entity_info XLA_EVENTS_PUB_PKG.t_array_entity_event_info_s;

Line 25: l_revenue_num_tab PA_PLSQL_DATATYPES.Num15TabTyp;

21: IS
22:
23: l_project_id_tab PA_PLSQL_DATATYPES.Num15TabTyp;
24: l_project_id_tab_tmp PA_PLSQL_DATATYPES.Num15TabTyp;
25: l_revenue_num_tab PA_PLSQL_DATATYPES.Num15TabTyp;
26: l_revenue_num_tab_tmp PA_PLSQL_DATATYPES.Num15TabTyp;
27: l_gl_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
28: l_event_entity_info XLA_EVENTS_PUB_PKG.t_array_entity_event_info_s;
29: l_event_entity_info_out XLA_EVENTS_PUB_PKG.t_array_entity_event_info_s;

Line 26: l_revenue_num_tab_tmp PA_PLSQL_DATATYPES.Num15TabTyp;

22:
23: l_project_id_tab PA_PLSQL_DATATYPES.Num15TabTyp;
24: l_project_id_tab_tmp PA_PLSQL_DATATYPES.Num15TabTyp;
25: l_revenue_num_tab PA_PLSQL_DATATYPES.Num15TabTyp;
26: l_revenue_num_tab_tmp PA_PLSQL_DATATYPES.Num15TabTyp;
27: l_gl_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
28: l_event_entity_info XLA_EVENTS_PUB_PKG.t_array_entity_event_info_s;
29: l_event_entity_info_out XLA_EVENTS_PUB_PKG.t_array_entity_event_info_s;
30: l_fetch_complete BOOLEAN DEFAULT FALSE;

Line 27: l_gl_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

23: l_project_id_tab PA_PLSQL_DATATYPES.Num15TabTyp;
24: l_project_id_tab_tmp PA_PLSQL_DATATYPES.Num15TabTyp;
25: l_revenue_num_tab PA_PLSQL_DATATYPES.Num15TabTyp;
26: l_revenue_num_tab_tmp PA_PLSQL_DATATYPES.Num15TabTyp;
27: l_gl_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
28: l_event_entity_info XLA_EVENTS_PUB_PKG.t_array_entity_event_info_s;
29: l_event_entity_info_out XLA_EVENTS_PUB_PKG.t_array_entity_event_info_s;
30: l_fetch_complete BOOLEAN DEFAULT FALSE;
31: l_event_id_tab PA_PLSQL_DATATYPES.Num15TabTyp;

Line 31: l_event_id_tab PA_PLSQL_DATATYPES.Num15TabTyp;

27: l_gl_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
28: l_event_entity_info XLA_EVENTS_PUB_PKG.t_array_entity_event_info_s;
29: l_event_entity_info_out XLA_EVENTS_PUB_PKG.t_array_entity_event_info_s;
30: l_fetch_complete BOOLEAN DEFAULT FALSE;
31: l_event_id_tab PA_PLSQL_DATATYPES.Num15TabTyp;
32: l_commit_size NUMBER DEFAULT 200;
33: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
34: l_ledger_id NUMBER;
35: l_legal_entity_id NUMBER;

Line 38: l_project_num_tab PA_PLSQL_DATATYPES.Char25TabTyp;

34: l_ledger_id NUMBER;
35: l_legal_entity_id NUMBER;
36: l_org_id NUMBER;
37: l_reject_reason VARCHAR2(250);
38: l_project_num_tab PA_PLSQL_DATATYPES.Char25TabTyp;
39:
40: --for Revenue Adjustments
41: l_revenue_num_cr_tab PA_PLSQL_DATATYPES.Num15TabTyp;
42:

Line 41: l_revenue_num_cr_tab PA_PLSQL_DATATYPES.Num15TabTyp;

37: l_reject_reason VARCHAR2(250);
38: l_project_num_tab PA_PLSQL_DATATYPES.Char25TabTyp;
39:
40: --for Revenue Adjustments
41: l_revenue_num_cr_tab PA_PLSQL_DATATYPES.Num15TabTyp;
42:
43: /*Reverted Changes of Bug 5488439 for Bug 5533484
44: --For Bug 5488439
45: l_source_appl_id NUMBER := fnd_profile.value('RESP_APPL_ID'); */