DBA Data[Home] [Help]

APPS.JAI_INV_ITEMS_PKG dependencies on MTL_SYSTEM_ITEMS

Line 132: , pn_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE

128: PROCEDURE propagate_item_action
129: (
130: pv_action_type IN VARCHAR2
131: --, pt_item_data IN dbms_utility.uncl_array -- TABLE_ITEMS, Bug# 4496223
132: , pn_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
133: , pn_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
134: , pn_source_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
135: , pn_source_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
136: , pn_set_process_id IN NUMBER

Line 133: , pn_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE

129: (
130: pv_action_type IN VARCHAR2
131: --, pt_item_data IN dbms_utility.uncl_array -- TABLE_ITEMS, Bug# 4496223
132: , pn_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
133: , pn_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
134: , pn_source_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
135: , pn_source_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
136: , pn_set_process_id IN NUMBER
137: , pv_called_from IN VARCHAR2

Line 134: , pn_source_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE

130: pv_action_type IN VARCHAR2
131: --, pt_item_data IN dbms_utility.uncl_array -- TABLE_ITEMS, Bug# 4496223
132: , pn_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
133: , pn_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
134: , pn_source_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
135: , pn_source_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
136: , pn_set_process_id IN NUMBER
137: , pv_called_from IN VARCHAR2
138: );

Line 135: , pn_source_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE

131: --, pt_item_data IN dbms_utility.uncl_array -- TABLE_ITEMS, Bug# 4496223
132: , pn_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
133: , pn_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
134: , pn_source_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
135: , pn_source_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
136: , pn_set_process_id IN NUMBER
137: , pv_called_from IN VARCHAR2
138: );
139: PROCEDURE copy_items

Line 140: ( pn_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE

136: , pn_set_process_id IN NUMBER
137: , pv_called_from IN VARCHAR2
138: );
139: PROCEDURE copy_items
140: ( pn_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
141: ,pn_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
142: ,pn_source_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
143: ,pn_source_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
144: );

Line 141: ,pn_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE

137: , pv_called_from IN VARCHAR2
138: );
139: PROCEDURE copy_items
140: ( pn_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
141: ,pn_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
142: ,pn_source_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
143: ,pn_source_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
144: );
145:

Line 142: ,pn_source_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE

138: );
139: PROCEDURE copy_items
140: ( pn_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
141: ,pn_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
142: ,pn_source_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
143: ,pn_source_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
144: );
145:
146: PROCEDURE delete_items

Line 143: ,pn_source_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE

139: PROCEDURE copy_items
140: ( pn_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
141: ,pn_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
142: ,pn_source_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
143: ,pn_source_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
144: );
145:
146: PROCEDURE delete_items
147: ( pn_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE

Line 147: ( pn_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE

143: ,pn_source_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
144: );
145:
146: PROCEDURE delete_items
147: ( pn_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
148: ,pn_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
149: );
150:
151: /* End of Bug# 4389149 */

Line 148: ,pn_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE

144: );
145:
146: PROCEDURE delete_items
147: ( pn_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
148: ,pn_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
149: );
150:
151: /* End of Bug# 4389149 */
152: