APPS.INVPCOII dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 63: from mtl_system_items_interface

59: into l_material_sub_elem,
60: l_material_oh_sub_elem,
61: l_organization_id,
62: l_transaction_id
63: from mtl_system_items_interface
64: where transaction_id = I_TRANSID; */
65:
66: l_material_sub_elem := I_MATERIAL_SUB_ELEM;
67: l_material_oh_sub_elem := I_MATERIAL_OH_SUB_ELEM;

Line 116: 'MTL_SYSTEM_ITEMS_INTERFACE',

112: I_REQ_ID,
113: l_transaction_id,
114: l_error_msg,
115: null,
116: 'MTL_SYSTEM_ITEMS_INTERFACE',
117: 'CST_INVALID_MOH_AVE',
118: O_ERR_TEXT);
119: return(1);
120: End if;

Line 123: /* Update mtl_system_items_interface

119: return(1);
120: End if;
121: End if;
122:
123: /* Update mtl_system_items_interface
124: ** NP 06MAY96: Does not require the xset_id since transaction_id
125: ** is unique to each row in MSII even though there may be multiple
126: ** parallel IOI processes
127: */

Line 129: update mtl_system_items_interface

125: ** is unique to each row in MSII even though there may be multiple
126: ** parallel IOI processes
127: */
128: l_location := 130;
129: update mtl_system_items_interface
130: set material_sub_elem_id = decode(l_material_sub_elem_id,
131: 0,NULL,l_material_sub_elem_id),
132: material_oh_sub_elem_id = decode(l_material_oh_sub_elem_id,
133: 0,NULL,l_material_oh_sub_elem_id)

Line 153: 'MTL_SYSTEM_ITEMS_INTERFACE',

149: I_REQ_ID,
150: l_transaction_id,
151: l_error_msg,
152: null,
153: 'MTL_SYSTEM_ITEMS_INTERFACE',
154: 'CST_INVALID_MAT_SUB',
155: O_ERR_TEXT);
156: else
157: l_error_msg := 'CST- Material Overhead Sub Element does not exist in costing org '||

Line 169: 'MTL_SYSTEM_ITEMS_INTERFACE',

165: I_REQ_ID,
166: l_transaction_id,
167: l_error_msg,
168: null,
169: 'MTL_SYSTEM_ITEMS_INTERFACE',
170: 'CST_INVALID_MOH_SUB',
171: O_ERR_TEXT);
172: end if;
173: return (1);

Line 567: from mtl_system_items_interface msii,

563: mp.primary_cost_method,
564: mp.organization_id,
565: mp.master_organization_id,
566: mp.cost_organization_id
567: from mtl_system_items_interface msii,
568: mtl_parameters mp
569: where msii.process_flag = 4
570: and msii.transaction_type = 'CREATE'
571: and msii.costing_enabled_flag = 'Y'

Line 591: from mtl_system_items_interface msii,

587: mp.primary_cost_method,
588: mp.organization_id,
589: mp.master_organization_id,
590: mp.cost_organization_id
591: from mtl_system_items_interface msii,
592: mtl_parameters mp
593: where msii.process_flag = 4
594: and msii.transaction_type = 'CREATE'
595: and msii.costing_enabled_flag = 'Y'

Line 616: from mtl_system_items_interface msii,

612: mp.primary_cost_method,
613: mp.organization_id,
614: mp.master_organization_id,
615: mp.cost_organization_id
616: from mtl_system_items_interface msii,
617: mtl_parameters mp
618: where msii.process_flag = 4
619: and msii.transaction_type = 'CREATE'
620: and msii.costing_enabled_flag = 'Y'

Line 947: 'MTL_SYSTEM_ITEMS_INTERFACE',

943: I_REQ_ID,
944: l_trx_id,
945: l_error_msg,
946: null,
947: 'MTL_SYSTEM_ITEMS_INTERFACE',
948: 'CST_ERR_IN_OI',
949: l_err_out);
950: WHEN OTHERS THEN
951: O_RETURN_CODE := SQLCODE;