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_RLMI_RBS_MAP_PUB dependencies on PA_NUM_TBL_TYPE

Line 52: g_txn_Id_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();

48: g_CBS_ELEMENT_ID_sqltab PA_PLSQL_DATATYPES.IdTabTyp := PA_PLSQL_DATATYPES.EmptyIdTab; --bug#16827157
49: g_TXN_PLAN_START_DATE_sqltab PA_PLSQL_DATATYPES.DateTabTyp := PA_PLSQL_DATATYPES.EmptyDateTab ;
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();

Line 53: g_TXN_SOURCE_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();

49: g_TXN_PLAN_START_DATE_sqltab PA_PLSQL_DATATYPES.DateTabTyp := PA_PLSQL_DATATYPES.EmptyDateTab ;
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();

Line 55: g_PERSON_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();

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();
59: g_EXPENDITURE_TYPE_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();

Line 56: g_JOB_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();

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();
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();

Line 57: g_ORGANIZATION_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();
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();

Line 58: g_VENDOR_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();
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();

Line 63: g_EXP_CATEGORY_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();
67: g_SYS_LINK_FUNCTION_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();

Line 65: g_NLR_ORGANIZATION_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_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();
69: g_RESOURCE_CLASS_CODE_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();

Line 68: g_PROJECT_ROLE_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();
72: g_FC_RES_TYPE_CODE_systab system.PA_VARCHAR2_30_TBL_TYPE := system.PA_VARCHAR2_30_TBL_TYPE();

Line 70: g_MFC_COST_TYPE_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();
74: g_ITEM_CATEGORY_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();

Line 73: g_INVENTORY_ITEM_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();
77: g_NAMED_ROLE_systab system.PA_VARCHAR2_80_TBL_TYPE := system.PA_VARCHAR2_80_TBL_TYPE();

Line 74: g_ITEM_CATEGORY_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_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();
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();

Line 76: g_BOM_RESOURCE_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_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();
80: g_TXN_TASK_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();

Line 80: g_TXN_TASK_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_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();
80: g_TXN_TASK_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
81: g_TXN_WBS_ELE_VER_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
82: g_TXN_RBS_ELEMENT_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
83: g_CBS_ELEMENT_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE(); --bug#16827157
84: g_TXN_PLAN_START_DATE_systab system.PA_DATE_TBL_TYPE := system.PA_DATE_TBL_TYPE();

Line 81: g_TXN_WBS_ELE_VER_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();
80: g_TXN_TASK_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
81: g_TXN_WBS_ELE_VER_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
82: g_TXN_RBS_ELEMENT_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
83: g_CBS_ELEMENT_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE(); --bug#16827157
84: g_TXN_PLAN_START_DATE_systab system.PA_DATE_TBL_TYPE := system.PA_DATE_TBL_TYPE();
85: g_TXN_PLAN_END_DATE_systab system.PA_DATE_TBL_TYPE := system.PA_DATE_TBL_TYPE();

Line 82: g_TXN_RBS_ELEMENT_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_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();
80: g_TXN_TASK_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
81: g_TXN_WBS_ELE_VER_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
82: g_TXN_RBS_ELEMENT_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
83: g_CBS_ELEMENT_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE(); --bug#16827157
84: g_TXN_PLAN_START_DATE_systab system.PA_DATE_TBL_TYPE := system.PA_DATE_TBL_TYPE();
85: g_TXN_PLAN_END_DATE_systab system.PA_DATE_TBL_TYPE := system.PA_DATE_TBL_TYPE();
86: /* OUT Plsql Variables */

Line 83: g_CBS_ELEMENT_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE(); --bug#16827157

79: g_RATE_BASED_FLAG_systab system.PA_VARCHAR2_1_TBL_TYPE := system.PA_VARCHAR2_1_TBL_TYPE();
80: g_TXN_TASK_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
81: g_TXN_WBS_ELE_VER_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
82: g_TXN_RBS_ELEMENT_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();
83: g_CBS_ELEMENT_ID_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE(); --bug#16827157
84: g_TXN_PLAN_START_DATE_systab system.PA_DATE_TBL_TYPE := system.PA_DATE_TBL_TYPE();
85: g_TXN_PLAN_END_DATE_systab system.PA_DATE_TBL_TYPE := system.PA_DATE_TBL_TYPE();
86: /* OUT Plsql Variables */
87: gx_txn_source_id_sqltab PA_PLSQL_DATATYPES.IdTabTyp := PA_PLSQL_DATATYPES.EmptyIdTab;

Line 94: gx_txn_source_id_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();

90: g_res_list_member_id_sqltab PA_PLSQL_DATATYPES.IdTabTyp := PA_PLSQL_DATATYPES.EmptyIdTab;
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();

Line 97: g_res_list_member_id_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();

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:
101: /**

Line 98: g_rbs_element_id_systab system.PA_NUM_TBL_TYPE := system.PA_NUM_TBL_TYPE();

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:
101: /**
102: procedure calc_log(p_msg varchar2) IS

Line 99: g_txn_accum_header_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:
101: /**
102: procedure calc_log(p_msg varchar2) IS
103:

Line 1535: g_res_list_member_id_systab := system.pa_num_tbl_type();

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();
1538: g_rbs_map_reject_code_sqltab.delete;
1539: g_rbs_map_reject_code_systab := system.PA_VARCHAR2_30_TBL_TYPE();

Line 1537: g_txn_source_id_systab := system.pa_num_tbl_type();

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();
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();

Line 1541: g_rbs_element_id_systab := system.PA_NUM_TBL_TYPE();

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();
1544:
1545: If p_process_code = 'RES_MAP' Then

Line 1543: g_txn_accum_header_id_systab := system.PA_NUM_TBL_TYPE();

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();
1544:
1545: If p_process_code = 'RES_MAP' Then
1546: If NVL(g_debug_flag,'N') = 'Y' Then /* Bug No. 4419245 */
1547: select count(*)

Line 2236: ,p_TXN_SOURCE_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()

2232: ,p_process_code IN varchar2 Default 'RES_MAP'
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()

Line 2238: ,p_PERSON_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()

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()
2242: ,p_EXPENDITURE_TYPE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()

Line 2239: ,p_JOB_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()

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()
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()

Line 2240: ,p_ORGANIZATION_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()

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()
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()

Line 2241: ,p_VENDOR_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()
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()

Line 2247: ,p_NLR_ORGANIZATION_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_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()
2251: ,p_RESOURCE_CLASS_CODE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()

Line 2250: ,p_PROJECT_ROLE_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_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()
2254: ,p_FC_RES_TYPE_CODE_tab IN system.PA_VARCHAR2_30_TBL_TYPE Default system.PA_VARCHAR2_30_TBL_TYPE()

Line 2252: ,p_MFC_COST_TYPE_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()
2256: ,p_ITEM_CATEGORY_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()

Line 2255: ,p_INVENTORY_ITEM_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()
2259: ,p_NAMED_ROLE_tab IN system.PA_VARCHAR2_80_TBL_TYPE Default system.PA_VARCHAR2_80_TBL_TYPE()

Line 2256: ,p_ITEM_CATEGORY_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_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()
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()

Line 2258: ,p_BOM_RESOURCE_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_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()
2262: ,p_TXN_TASK_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()

Line 2262: ,p_TXN_TASK_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_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()
2262: ,p_TXN_TASK_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2263: ,p_TXN_WBS_ELEMENT_VER_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2264: ,p_TXN_RBS_ELEMENT_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2265: ,P_CBS_ELEMENT_ID_TAB IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE() --bug#16827157
2266: ,p_TXN_PLAN_START_DATE_tab IN system.PA_DATE_TBL_TYPE Default system.PA_DATE_TBL_TYPE()

Line 2263: ,p_TXN_WBS_ELEMENT_VER_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()
2262: ,p_TXN_TASK_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2263: ,p_TXN_WBS_ELEMENT_VER_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2264: ,p_TXN_RBS_ELEMENT_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2265: ,P_CBS_ELEMENT_ID_TAB IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE() --bug#16827157
2266: ,p_TXN_PLAN_START_DATE_tab IN system.PA_DATE_TBL_TYPE Default system.PA_DATE_TBL_TYPE()
2267: ,p_TXN_PLAN_END_DATE_tab IN system.PA_DATE_TBL_TYPE Default system.PA_DATE_TBL_TYPE()

Line 2264: ,p_TXN_RBS_ELEMENT_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_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()
2262: ,p_TXN_TASK_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2263: ,p_TXN_WBS_ELEMENT_VER_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2264: ,p_TXN_RBS_ELEMENT_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2265: ,P_CBS_ELEMENT_ID_TAB IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE() --bug#16827157
2266: ,p_TXN_PLAN_START_DATE_tab IN system.PA_DATE_TBL_TYPE Default system.PA_DATE_TBL_TYPE()
2267: ,p_TXN_PLAN_END_DATE_tab IN system.PA_DATE_TBL_TYPE Default system.PA_DATE_TBL_TYPE()
2268: ,x_txn_source_id_tab OUT NOCOPY system.PA_NUM_TBL_TYPE

Line 2265: ,P_CBS_ELEMENT_ID_TAB IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE() --bug#16827157

2261: ,p_RATE_BASED_FLAG_tab IN system.PA_VARCHAR2_1_TBL_TYPE Default system.PA_VARCHAR2_1_TBL_TYPE()
2262: ,p_TXN_TASK_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2263: ,p_TXN_WBS_ELEMENT_VER_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2264: ,p_TXN_RBS_ELEMENT_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2265: ,P_CBS_ELEMENT_ID_TAB IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE() --bug#16827157
2266: ,p_TXN_PLAN_START_DATE_tab IN system.PA_DATE_TBL_TYPE Default system.PA_DATE_TBL_TYPE()
2267: ,p_TXN_PLAN_END_DATE_tab IN system.PA_DATE_TBL_TYPE Default system.PA_DATE_TBL_TYPE()
2268: ,x_txn_source_id_tab OUT NOCOPY system.PA_NUM_TBL_TYPE
2269: ,x_res_list_member_id_tab OUT NOCOPY system.PA_NUM_TBL_TYPE

Line 2268: ,x_txn_source_id_tab OUT NOCOPY system.PA_NUM_TBL_TYPE

2264: ,p_TXN_RBS_ELEMENT_ID_tab IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE()
2265: ,P_CBS_ELEMENT_ID_TAB IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE() --bug#16827157
2266: ,p_TXN_PLAN_START_DATE_tab IN system.PA_DATE_TBL_TYPE Default system.PA_DATE_TBL_TYPE()
2267: ,p_TXN_PLAN_END_DATE_tab IN system.PA_DATE_TBL_TYPE Default system.PA_DATE_TBL_TYPE()
2268: ,x_txn_source_id_tab OUT NOCOPY system.PA_NUM_TBL_TYPE
2269: ,x_res_list_member_id_tab OUT NOCOPY system.PA_NUM_TBL_TYPE
2270: ,x_rbs_element_id_tab OUT NOCOPY system.PA_NUM_TBL_TYPE
2271: ,x_txn_accum_header_id_tab OUT NOCOPY system.PA_NUM_TBL_TYPE
2272: ,x_return_status OUT NOCOPY Varchar2

Line 2269: ,x_res_list_member_id_tab OUT NOCOPY system.PA_NUM_TBL_TYPE

2265: ,P_CBS_ELEMENT_ID_TAB IN system.PA_NUM_TBL_TYPE Default system.PA_NUM_TBL_TYPE() --bug#16827157
2266: ,p_TXN_PLAN_START_DATE_tab IN system.PA_DATE_TBL_TYPE Default system.PA_DATE_TBL_TYPE()
2267: ,p_TXN_PLAN_END_DATE_tab IN system.PA_DATE_TBL_TYPE Default system.PA_DATE_TBL_TYPE()
2268: ,x_txn_source_id_tab OUT NOCOPY system.PA_NUM_TBL_TYPE
2269: ,x_res_list_member_id_tab OUT NOCOPY system.PA_NUM_TBL_TYPE
2270: ,x_rbs_element_id_tab OUT NOCOPY system.PA_NUM_TBL_TYPE
2271: ,x_txn_accum_header_id_tab OUT NOCOPY system.PA_NUM_TBL_TYPE
2272: ,x_return_status OUT NOCOPY Varchar2
2273: ,x_msg_count OUT NOCOPY Number

Line 2270: ,x_rbs_element_id_tab OUT NOCOPY system.PA_NUM_TBL_TYPE

2266: ,p_TXN_PLAN_START_DATE_tab IN system.PA_DATE_TBL_TYPE Default system.PA_DATE_TBL_TYPE()
2267: ,p_TXN_PLAN_END_DATE_tab IN system.PA_DATE_TBL_TYPE Default system.PA_DATE_TBL_TYPE()
2268: ,x_txn_source_id_tab OUT NOCOPY system.PA_NUM_TBL_TYPE
2269: ,x_res_list_member_id_tab OUT NOCOPY system.PA_NUM_TBL_TYPE
2270: ,x_rbs_element_id_tab OUT NOCOPY system.PA_NUM_TBL_TYPE
2271: ,x_txn_accum_header_id_tab OUT NOCOPY system.PA_NUM_TBL_TYPE
2272: ,x_return_status OUT NOCOPY Varchar2
2273: ,x_msg_count OUT NOCOPY Number
2274: ,x_msg_data OUT NOCOPY Varchar2

Line 2271: ,x_txn_accum_header_id_tab OUT NOCOPY system.PA_NUM_TBL_TYPE

2267: ,p_TXN_PLAN_END_DATE_tab IN system.PA_DATE_TBL_TYPE Default system.PA_DATE_TBL_TYPE()
2268: ,x_txn_source_id_tab OUT NOCOPY system.PA_NUM_TBL_TYPE
2269: ,x_res_list_member_id_tab OUT NOCOPY system.PA_NUM_TBL_TYPE
2270: ,x_rbs_element_id_tab OUT NOCOPY system.PA_NUM_TBL_TYPE
2271: ,x_txn_accum_header_id_tab OUT NOCOPY system.PA_NUM_TBL_TYPE
2272: ,x_return_status OUT NOCOPY Varchar2
2273: ,x_msg_count OUT NOCOPY Number
2274: ,x_msg_data OUT NOCOPY Varchar2
2275: ) IS

Line 2307: x_txn_source_id_tab := system.PA_NUM_TBL_TYPE();

2303: ,x_debug_mode => g_debug_flag
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();

Line 2310: x_res_list_member_id_tab := system.PA_NUM_TBL_TYPE();

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:
2314: l_stage := 'Begin of SYSTEM.Map_Rlmi_Rbs IN Params:BdgtVer['||p_budget_version_id||']ReslistId['||p_resource_list_id||

Line 2311: x_rbs_element_id_tab := system.PA_NUM_TBL_TYPE();

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:
2314: l_stage := 'Begin of SYSTEM.Map_Rlmi_Rbs IN Params:BdgtVer['||p_budget_version_id||']ReslistId['||p_resource_list_id||
2315: ']RbsVers['||p_rbs_version_id||']CallingProcess['||p_calling_process||']CallContext['||p_calling_context||

Line 2312: x_txn_accum_header_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:
2314: l_stage := 'Begin of SYSTEM.Map_Rlmi_Rbs IN Params:BdgtVer['||p_budget_version_id||']ReslistId['||p_resource_list_id||
2315: ']RbsVers['||p_rbs_version_id||']CallingProcess['||p_calling_process||']CallContext['||p_calling_context||
2316: ']ProcessCode['||p_process_code||']CallingMode['||p_calling_mode||']InitMsg['||p_init_msg_list_flag||