DBA Data[Home] [Help]

APPS.PA_RLMI_RBS_MAP_PUB dependencies on PA_VARCHAR2_30_TBL_TYPE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1316: l_stage := 'Start of populate_resrbsmap_outTbls Initializing the OUT global plsql tables';
1317: print_msg(g_debug_flag,l_stage);
1318: x_return_status := 'S';
1319: g_res_map_reject_code_sqltab.delete;
1320: g_res_map_reject_code_systab := system.pa_varchar2_30_tbl_type ();
1321: g_res_list_member_id_sqltab.delete;
1322: g_res_list_member_id_systab := system.pa_num_tbl_type();
1323: g_txn_source_id_sqltab.delete;
1324: g_txn_source_id_systab := system.pa_num_tbl_type();

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

1322: g_res_list_member_id_systab := system.pa_num_tbl_type();
1323: g_txn_source_id_sqltab.delete;
1324: g_txn_source_id_systab := system.pa_num_tbl_type();
1325: g_rbs_map_reject_code_sqltab.delete;
1326: g_rbs_map_reject_code_systab := system.PA_VARCHAR2_30_TBL_TYPE();
1327: g_rbs_element_id_sqltab.delete;
1328: g_rbs_element_id_systab := system.PA_NUM_TBL_TYPE();
1329: g_txn_accum_header_id_sqltab.delete;
1330: g_txn_accum_header_id_systab := system.PA_NUM_TBL_TYPE();

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

2005: ,p_calling_mode IN Varchar2 Default 'PLSQL_TABLE'
2006: ,p_init_msg_list_flag IN Varchar2 Default 'N'
2007: ,p_commit_flag IN Varchar2 Default 'N'
2008: ,p_TXN_SOURCE_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2009: ,p_TXN_SOURCE_TYPE_CODE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2010: ,p_PERSON_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2011: ,p_JOB_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2012: ,p_ORGANIZATION_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2013: ,p_VENDOR_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()

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

2010: ,p_PERSON_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2011: ,p_JOB_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2012: ,p_ORGANIZATION_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2013: ,p_VENDOR_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2014: ,p_EXPENDITURE_TYPE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2015: ,p_EVENT_TYPE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2016: ,p_NON_LABOR_RESOURCE_tab IN system.PA_VARCHAR2_20_TBL_TYPE Default system.PA_VARCHAR2_20_TBL_TYPE()
2017: ,p_EXPENDITURE_CATEGORY_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2018: ,p_REVENUE_CATEGORY_CODE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()

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

2011: ,p_JOB_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2012: ,p_ORGANIZATION_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2013: ,p_VENDOR_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2014: ,p_EXPENDITURE_TYPE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2015: ,p_EVENT_TYPE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2016: ,p_NON_LABOR_RESOURCE_tab IN system.PA_VARCHAR2_20_TBL_TYPE Default system.PA_VARCHAR2_20_TBL_TYPE()
2017: ,p_EXPENDITURE_CATEGORY_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2018: ,p_REVENUE_CATEGORY_CODE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2019: ,p_NLR_ORGANIZATION_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()

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

2013: ,p_VENDOR_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2014: ,p_EXPENDITURE_TYPE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2015: ,p_EVENT_TYPE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2016: ,p_NON_LABOR_RESOURCE_tab IN system.PA_VARCHAR2_20_TBL_TYPE Default system.PA_VARCHAR2_20_TBL_TYPE()
2017: ,p_EXPENDITURE_CATEGORY_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2018: ,p_REVENUE_CATEGORY_CODE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2019: ,p_NLR_ORGANIZATION_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2020: ,p_EVENT_CLASSIFICATION_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2021: ,p_SYS_LINK_FUNCTION_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()

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

2014: ,p_EXPENDITURE_TYPE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2015: ,p_EVENT_TYPE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2016: ,p_NON_LABOR_RESOURCE_tab IN system.PA_VARCHAR2_20_TBL_TYPE Default system.PA_VARCHAR2_20_TBL_TYPE()
2017: ,p_EXPENDITURE_CATEGORY_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2018: ,p_REVENUE_CATEGORY_CODE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2019: ,p_NLR_ORGANIZATION_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2020: ,p_EVENT_CLASSIFICATION_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2021: ,p_SYS_LINK_FUNCTION_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2022: ,p_PROJECT_ROLE_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()

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

2016: ,p_NON_LABOR_RESOURCE_tab IN system.PA_VARCHAR2_20_TBL_TYPE Default system.PA_VARCHAR2_20_TBL_TYPE()
2017: ,p_EXPENDITURE_CATEGORY_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2018: ,p_REVENUE_CATEGORY_CODE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2019: ,p_NLR_ORGANIZATION_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2020: ,p_EVENT_CLASSIFICATION_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2021: ,p_SYS_LINK_FUNCTION_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2022: ,p_PROJECT_ROLE_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2023: ,p_RESOURCE_CLASS_CODE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2024: ,p_MFC_COST_TYPE_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()

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

2017: ,p_EXPENDITURE_CATEGORY_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2018: ,p_REVENUE_CATEGORY_CODE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2019: ,p_NLR_ORGANIZATION_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2020: ,p_EVENT_CLASSIFICATION_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2021: ,p_SYS_LINK_FUNCTION_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2022: ,p_PROJECT_ROLE_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2023: ,p_RESOURCE_CLASS_CODE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2024: ,p_MFC_COST_TYPE_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2025: ,p_RESOURCE_CLASS_FLAG_tab IN system.PA_VARCHAR2_1_TBL_TYPE Default system.PA_VARCHAR2_1_TBL_TYPE()

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

2019: ,p_NLR_ORGANIZATION_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2020: ,p_EVENT_CLASSIFICATION_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2021: ,p_SYS_LINK_FUNCTION_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2022: ,p_PROJECT_ROLE_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2023: ,p_RESOURCE_CLASS_CODE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2024: ,p_MFC_COST_TYPE_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2025: ,p_RESOURCE_CLASS_FLAG_tab IN system.PA_VARCHAR2_1_TBL_TYPE Default system.PA_VARCHAR2_1_TBL_TYPE()
2026: ,p_FC_RES_TYPE_CODE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2027: ,p_INVENTORY_ITEM_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()

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

2022: ,p_PROJECT_ROLE_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2023: ,p_RESOURCE_CLASS_CODE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2024: ,p_MFC_COST_TYPE_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2025: ,p_RESOURCE_CLASS_FLAG_tab IN system.PA_VARCHAR2_1_TBL_TYPE Default system.PA_VARCHAR2_1_TBL_TYPE()
2026: ,p_FC_RES_TYPE_CODE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2027: ,p_INVENTORY_ITEM_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2028: ,p_ITEM_CATEGORY_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2029: ,p_PERSON_TYPE_CODE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2030: ,p_BOM_RESOURCE_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()

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

2025: ,p_RESOURCE_CLASS_FLAG_tab IN system.PA_VARCHAR2_1_TBL_TYPE Default system.PA_VARCHAR2_1_TBL_TYPE()
2026: ,p_FC_RES_TYPE_CODE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2027: ,p_INVENTORY_ITEM_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2028: ,p_ITEM_CATEGORY_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2029: ,p_PERSON_TYPE_CODE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()
2030: ,p_BOM_RESOURCE_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2031: ,p_NAMED_ROLE_tab IN system.PA_VARCHAR2_80_TBL_TYPE Default system.PA_VARCHAR2_80_TBL_TYPE()
2032: ,p_INCURRED_BY_RES_FLAG_tab IN system.PA_VARCHAR2_1_TBL_TYPE Default system.PA_VARCHAR2_1_TBL_TYPE()
2033: ,p_RATE_BASED_FLAG_tab IN system.PA_VARCHAR2_1_TBL_TYPE Default system.PA_VARCHAR2_1_TBL_TYPE()

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

2075: );
2076: End If;
2077: g_debug_context := p_calling_context;
2078: x_txn_source_id_tab := system.PA_NUM_TBL_TYPE();
2079: --x_res_map_reject_code_tab := system.PA_VARCHAR2_30_TBL_TYPE();
2080: --x_rbs_map_reject_code_tab := system.PA_VARCHAR2_30_TBL_TYPE();
2081: x_res_list_member_id_tab := system.PA_NUM_TBL_TYPE();
2082: x_rbs_element_id_tab := system.PA_NUM_TBL_TYPE();
2083: x_txn_accum_header_id_tab := system.PA_NUM_TBL_TYPE();

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

2076: End If;
2077: g_debug_context := p_calling_context;
2078: x_txn_source_id_tab := system.PA_NUM_TBL_TYPE();
2079: --x_res_map_reject_code_tab := system.PA_VARCHAR2_30_TBL_TYPE();
2080: --x_rbs_map_reject_code_tab := system.PA_VARCHAR2_30_TBL_TYPE();
2081: x_res_list_member_id_tab := system.PA_NUM_TBL_TYPE();
2082: x_rbs_element_id_tab := system.PA_NUM_TBL_TYPE();
2083: x_txn_accum_header_id_tab := system.PA_NUM_TBL_TYPE();
2084: