DBA Data[Home] [Help]

APPS.PA_RLMI_RBS_MAP_PUB dependencies on PA_VARCHAR2_30_TBL_TYPE

Line 54: g_TXN_SOURCE_TYPE_CODE_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();

50: g_TXN_PLAN_END_DATE_sqltab PA_PLSQL_DATATYPES.DateTabTyp := PA_PLSQL_DATATYPES.EmptyDateTab;
51: /* declatioin of System Tables */
52: g_txn_Id_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
53: g_TXN_SOURCE_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
54: g_TXN_SOURCE_TYPE_CODE_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();
55: g_PERSON_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
56: g_JOB_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
57: g_ORGANIZATION_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
58: g_VENDOR_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();

Line 59: g_EXPENDITURE_TYPE_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();

55: g_PERSON_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
56: g_JOB_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
57: g_ORGANIZATION_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
58: g_VENDOR_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
59: g_EXPENDITURE_TYPE_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();
60: g_EVENT_TYPE_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();
61: g_NON_LABOR_RESOURCE_systab system.PA_VARCHAR2_20_TBL_TYPE := system.PA_VARCHAR2_20_TBL_TYPE();
62: g_EXPENDITURE_CATEGORY_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();
63: g_EXP_CATEGORY_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();

Line 60: g_EVENT_TYPE_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();

56: g_JOB_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
57: g_ORGANIZATION_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
58: g_VENDOR_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
59: g_EXPENDITURE_TYPE_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();
60: g_EVENT_TYPE_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();
61: g_NON_LABOR_RESOURCE_systab system.PA_VARCHAR2_20_TBL_TYPE := system.PA_VARCHAR2_20_TBL_TYPE();
62: g_EXPENDITURE_CATEGORY_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();
63: g_EXP_CATEGORY_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
64: g_REVENUE_CATEGORY_CODE_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();

Line 62: g_EXPENDITURE_CATEGORY_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();

58: g_VENDOR_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
59: g_EXPENDITURE_TYPE_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();
60: g_EVENT_TYPE_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();
61: g_NON_LABOR_RESOURCE_systab system.PA_VARCHAR2_20_TBL_TYPE := system.PA_VARCHAR2_20_TBL_TYPE();
62: g_EXPENDITURE_CATEGORY_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();
63: g_EXP_CATEGORY_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
64: g_REVENUE_CATEGORY_CODE_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();
65: g_NLR_ORGANIZATION_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
66: g_EVENT_CLASSIFICATION_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();

Line 64: g_REVENUE_CATEGORY_CODE_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();

60: g_EVENT_TYPE_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();
61: g_NON_LABOR_RESOURCE_systab system.PA_VARCHAR2_20_TBL_TYPE := system.PA_VARCHAR2_20_TBL_TYPE();
62: g_EXPENDITURE_CATEGORY_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();
63: g_EXP_CATEGORY_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
64: g_REVENUE_CATEGORY_CODE_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();
65: g_NLR_ORGANIZATION_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
66: g_EVENT_CLASSIFICATION_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();
67: g_SYS_LINK_FUNCTION_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();
68: g_PROJECT_ROLE_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();

Line 66: g_EVENT_CLASSIFICATION_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();

62: g_EXPENDITURE_CATEGORY_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();
63: g_EXP_CATEGORY_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
64: g_REVENUE_CATEGORY_CODE_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();
65: g_NLR_ORGANIZATION_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
66: g_EVENT_CLASSIFICATION_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();
67: g_SYS_LINK_FUNCTION_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();
68: g_PROJECT_ROLE_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
69: g_RESOURCE_CLASS_CODE_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();
70: g_MFC_COST_TYPE_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();

Line 67: g_SYS_LINK_FUNCTION_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();

63: g_EXP_CATEGORY_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
64: g_REVENUE_CATEGORY_CODE_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();
65: g_NLR_ORGANIZATION_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
66: g_EVENT_CLASSIFICATION_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();
67: g_SYS_LINK_FUNCTION_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();
68: g_PROJECT_ROLE_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
69: g_RESOURCE_CLASS_CODE_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();
70: g_MFC_COST_TYPE_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
71: g_RESOURCE_CLASS_FLAG_systab system.PA_VARCHAR2_1_TBL_TYPE := system.PA_VARCHAR2_1_TBL_TYPE();

Line 69: g_RESOURCE_CLASS_CODE_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();

65: g_NLR_ORGANIZATION_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
66: g_EVENT_CLASSIFICATION_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();
67: g_SYS_LINK_FUNCTION_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();
68: g_PROJECT_ROLE_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
69: g_RESOURCE_CLASS_CODE_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();
70: g_MFC_COST_TYPE_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
71: g_RESOURCE_CLASS_FLAG_systab system.PA_VARCHAR2_1_TBL_TYPE := system.PA_VARCHAR2_1_TBL_TYPE();
72: g_FC_RES_TYPE_CODE_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();
73: g_INVENTORY_ITEM_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();

Line 72: g_FC_RES_TYPE_CODE_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();

68: g_PROJECT_ROLE_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
69: g_RESOURCE_CLASS_CODE_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();
70: g_MFC_COST_TYPE_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
71: g_RESOURCE_CLASS_FLAG_systab system.PA_VARCHAR2_1_TBL_TYPE := system.PA_VARCHAR2_1_TBL_TYPE();
72: g_FC_RES_TYPE_CODE_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();
73: g_INVENTORY_ITEM_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
74: g_ITEM_CATEGORY_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
75: g_PERSON_TYPE_CODE_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();
76: g_BOM_RESOURCE_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();

Line 75: g_PERSON_TYPE_CODE_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();

71: g_RESOURCE_CLASS_FLAG_systab system.PA_VARCHAR2_1_TBL_TYPE := system.PA_VARCHAR2_1_TBL_TYPE();
72: g_FC_RES_TYPE_CODE_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();
73: g_INVENTORY_ITEM_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
74: g_ITEM_CATEGORY_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
75: g_PERSON_TYPE_CODE_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();
76: g_BOM_RESOURCE_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
77: g_NAMED_ROLE_systab system.PA_VARCHAR2_80_TBL_TYPE := system.PA_VARCHAR2_80_TBL_TYPE();
78: g_INCURRED_BY_RES_FLAG_systab system.PA_VARCHAR2_1_TBL_TYPE := system.PA_VARCHAR2_1_TBL_TYPE();
79: g_RATE_BASED_FLAG_systab system.PA_VARCHAR2_1_TBL_TYPE := system.PA_VARCHAR2_1_TBL_TYPE();

Line 95: g_res_map_reject_code_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();

91: g_rbs_element_id_sqltab PA_PLSQL_DATATYPES.IdTabTyp := PA_PLSQL_DATATYPES.EmptyIdTab;
92: g_txn_accum_header_id_sqltab PA_PLSQL_DATATYPES.IdTabTyp := PA_PLSQL_DATATYPES.EmptyIdTab;
93: /* OUT System Variables */
94: gx_txn_source_id_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
95: g_res_map_reject_code_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();
96: g_rbs_map_reject_code_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();
97: g_res_list_member_id_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
98: g_rbs_element_id_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
99: g_txn_accum_header_id_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();

Line 96: g_rbs_map_reject_code_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();

92: g_txn_accum_header_id_sqltab PA_PLSQL_DATATYPES.IdTabTyp := PA_PLSQL_DATATYPES.EmptyIdTab;
93: /* OUT System Variables */
94: gx_txn_source_id_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
95: g_res_map_reject_code_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();
96: g_rbs_map_reject_code_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();
97: g_res_list_member_id_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
98: g_rbs_element_id_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
99: g_txn_accum_header_id_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
100:

Line 1533: g_res_map_reject_code_systab := system.pa_varchar2_30_tbl_type ();

1529: l_stage := 'Start of populate_resrbsmap_outTbls Initializing the OUT global plsql tables';
1530: print_msg(g_debug_flag,l_stage);
1531: x_return_status := 'S';
1532: g_res_map_reject_code_sqltab.delete;
1533: g_res_map_reject_code_systab := system.pa_varchar2_30_tbl_type ();
1534: g_res_list_member_id_sqltab.delete;
1535: g_res_list_member_id_systab := system.pa_num_tbl_type();
1536: g_txn_source_id_sqltab.delete;
1537: g_txn_source_id_systab := system.pa_num_tbl_type();

Line 1539: g_rbs_map_reject_code_systab := system.PA_VARCHAR2_30_TBL_TYPE();

1535: g_res_list_member_id_systab := system.pa_num_tbl_type();
1536: g_txn_source_id_sqltab.delete;
1537: g_txn_source_id_systab := system.pa_num_tbl_type();
1538: g_rbs_map_reject_code_sqltab.delete;
1539: g_rbs_map_reject_code_systab := system.PA_VARCHAR2_30_TBL_TYPE();
1540: g_rbs_element_id_sqltab.delete;
1541: g_rbs_element_id_systab := system.PA_NUM_TBL_TYPE();
1542: g_txn_accum_header_id_sqltab.delete;
1543: g_txn_accum_header_id_systab := system.PA_NUM_TBL_TYPE();

Line 2237: ,p_TXN_SOURCE_TYPE_CODE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()

2233: ,p_calling_mode IN Varchar2 Default 'PLSQL_TABLE'
2234: ,p_init_msg_list_flag IN Varchar2 Default 'N'
2235: ,p_commit_flag IN Varchar2 Default 'N'
2236: ,p_TXN_SOURCE_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2237: ,p_TXN_SOURCE_TYPE_CODE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2238: ,p_PERSON_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2239: ,p_JOB_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2240: ,p_ORGANIZATION_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2241: ,p_VENDOR_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()

Line 2242: ,p_EXPENDITURE_TYPE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()

2238: ,p_PERSON_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2239: ,p_JOB_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2240: ,p_ORGANIZATION_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2241: ,p_VENDOR_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2242: ,p_EXPENDITURE_TYPE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2243: ,p_EVENT_TYPE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2244: ,p_NON_LABOR_RESOURCE_tab IN system.PA_VARCHAR2_20_TBL_TYPE Default system.PA_VARCHAR2_20_TBL_TYPE()
2245: ,p_EXPENDITURE_CATEGORY_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2246: ,p_REVENUE_CATEGORY_CODE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()

Line 2243: ,p_EVENT_TYPE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()

2239: ,p_JOB_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2240: ,p_ORGANIZATION_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2241: ,p_VENDOR_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2242: ,p_EXPENDITURE_TYPE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2243: ,p_EVENT_TYPE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2244: ,p_NON_LABOR_RESOURCE_tab IN system.PA_VARCHAR2_20_TBL_TYPE Default system.PA_VARCHAR2_20_TBL_TYPE()
2245: ,p_EXPENDITURE_CATEGORY_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2246: ,p_REVENUE_CATEGORY_CODE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2247: ,p_NLR_ORGANIZATION_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()

Line 2245: ,p_EXPENDITURE_CATEGORY_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()

2241: ,p_VENDOR_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2242: ,p_EXPENDITURE_TYPE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2243: ,p_EVENT_TYPE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2244: ,p_NON_LABOR_RESOURCE_tab IN system.PA_VARCHAR2_20_TBL_TYPE Default system.PA_VARCHAR2_20_TBL_TYPE()
2245: ,p_EXPENDITURE_CATEGORY_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2246: ,p_REVENUE_CATEGORY_CODE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2247: ,p_NLR_ORGANIZATION_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2248: ,p_EVENT_CLASSIFICATION_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2249: ,p_SYS_LINK_FUNCTION_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()

Line 2246: ,p_REVENUE_CATEGORY_CODE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()

2242: ,p_EXPENDITURE_TYPE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2243: ,p_EVENT_TYPE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2244: ,p_NON_LABOR_RESOURCE_tab IN system.PA_VARCHAR2_20_TBL_TYPE Default system.PA_VARCHAR2_20_TBL_TYPE()
2245: ,p_EXPENDITURE_CATEGORY_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2246: ,p_REVENUE_CATEGORY_CODE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2247: ,p_NLR_ORGANIZATION_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2248: ,p_EVENT_CLASSIFICATION_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2249: ,p_SYS_LINK_FUNCTION_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2250: ,p_PROJECT_ROLE_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()

Line 2248: ,p_EVENT_CLASSIFICATION_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()

2244: ,p_NON_LABOR_RESOURCE_tab IN system.PA_VARCHAR2_20_TBL_TYPE Default system.PA_VARCHAR2_20_TBL_TYPE()
2245: ,p_EXPENDITURE_CATEGORY_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2246: ,p_REVENUE_CATEGORY_CODE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2247: ,p_NLR_ORGANIZATION_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2248: ,p_EVENT_CLASSIFICATION_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2249: ,p_SYS_LINK_FUNCTION_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2250: ,p_PROJECT_ROLE_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2251: ,p_RESOURCE_CLASS_CODE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2252: ,p_MFC_COST_TYPE_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()

Line 2249: ,p_SYS_LINK_FUNCTION_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()

2245: ,p_EXPENDITURE_CATEGORY_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2246: ,p_REVENUE_CATEGORY_CODE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2247: ,p_NLR_ORGANIZATION_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2248: ,p_EVENT_CLASSIFICATION_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2249: ,p_SYS_LINK_FUNCTION_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2250: ,p_PROJECT_ROLE_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2251: ,p_RESOURCE_CLASS_CODE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2252: ,p_MFC_COST_TYPE_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2253: ,p_RESOURCE_CLASS_FLAG_tab IN system.PA_VARCHAR2_1_TBL_TYPE Default system.PA_VARCHAR2_1_TBL_TYPE()

Line 2251: ,p_RESOURCE_CLASS_CODE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()

2247: ,p_NLR_ORGANIZATION_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2248: ,p_EVENT_CLASSIFICATION_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2249: ,p_SYS_LINK_FUNCTION_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2250: ,p_PROJECT_ROLE_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2251: ,p_RESOURCE_CLASS_CODE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2252: ,p_MFC_COST_TYPE_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2253: ,p_RESOURCE_CLASS_FLAG_tab IN system.PA_VARCHAR2_1_TBL_TYPE Default system.PA_VARCHAR2_1_TBL_TYPE()
2254: ,p_FC_RES_TYPE_CODE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2255: ,p_INVENTORY_ITEM_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()

Line 2254: ,p_FC_RES_TYPE_CODE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()

2250: ,p_PROJECT_ROLE_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2251: ,p_RESOURCE_CLASS_CODE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2252: ,p_MFC_COST_TYPE_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2253: ,p_RESOURCE_CLASS_FLAG_tab IN system.PA_VARCHAR2_1_TBL_TYPE Default system.PA_VARCHAR2_1_TBL_TYPE()
2254: ,p_FC_RES_TYPE_CODE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2255: ,p_INVENTORY_ITEM_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2256: ,p_ITEM_CATEGORY_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2257: ,p_PERSON_TYPE_CODE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2258: ,p_BOM_RESOURCE_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()

Line 2257: ,p_PERSON_TYPE_CODE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()

2253: ,p_RESOURCE_CLASS_FLAG_tab IN system.PA_VARCHAR2_1_TBL_TYPE Default system.PA_VARCHAR2_1_TBL_TYPE()
2254: ,p_FC_RES_TYPE_CODE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2255: ,p_INVENTORY_ITEM_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2256: ,p_ITEM_CATEGORY_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2257: ,p_PERSON_TYPE_CODE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2258: ,p_BOM_RESOURCE_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2259: ,p_NAMED_ROLE_tab IN system.PA_VARCHAR2_80_TBL_TYPE Default system.PA_VARCHAR2_80_TBL_TYPE()
2260: ,p_INCURRED_BY_RES_FLAG_tab IN system.PA_VARCHAR2_1_TBL_TYPE Default system.PA_VARCHAR2_1_TBL_TYPE()
2261: ,p_RATE_BASED_FLAG_tab IN system.PA_VARCHAR2_1_TBL_TYPE Default system.PA_VARCHAR2_1_TBL_TYPE()

Line 2308: --x_res_map_reject_code_tab := system.PA_VARCHAR2_30_TBL_TYPE();

2304: );
2305: End If;
2306: g_debug_context := p_calling_context;
2307: x_txn_source_id_tab := system.PA_NUM_TBL_TYPE();
2308: --x_res_map_reject_code_tab := system.PA_VARCHAR2_30_TBL_TYPE();
2309: --x_rbs_map_reject_code_tab := system.PA_VARCHAR2_30_TBL_TYPE();
2310: x_res_list_member_id_tab := system.PA_NUM_TBL_TYPE();
2311: x_rbs_element_id_tab := system.PA_NUM_TBL_TYPE();
2312: x_txn_accum_header_id_tab := system.PA_NUM_TBL_TYPE();

Line 2309: --x_rbs_map_reject_code_tab := system.PA_VARCHAR2_30_TBL_TYPE();

2305: End If;
2306: g_debug_context := p_calling_context;
2307: x_txn_source_id_tab := system.PA_NUM_TBL_TYPE();
2308: --x_res_map_reject_code_tab := system.PA_VARCHAR2_30_TBL_TYPE();
2309: --x_rbs_map_reject_code_tab := system.PA_VARCHAR2_30_TBL_TYPE();
2310: x_res_list_member_id_tab := system.PA_NUM_TBL_TYPE();
2311: x_rbs_element_id_tab := system.PA_NUM_TBL_TYPE();
2312: x_txn_accum_header_id_tab := system.PA_NUM_TBL_TYPE();
2313: