DBA Data[Home] [Help]

APPS.JAI_INV_ITEMS_PKG dependencies on MTL_SYSTEM_ITEMS

Line 136: , pn_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE

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

Line 137: , pn_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE

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

Line 138: , pn_source_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE

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

Line 139: , pn_source_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE

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

Line 144: ( pn_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE

140: , pn_set_process_id IN NUMBER
141: , pv_called_from IN VARCHAR2
142: );
143: PROCEDURE copy_items
144: ( pn_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
145: ,pn_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
146: ,pn_source_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
147: ,pn_source_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
148: ,pn_regime_code JAI_RGM_ITM_REGNS.REGIME_CODE%TYPE DEFAULT 'EXCISE' --added for bug#9191274

Line 145: ,pn_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE

141: , pv_called_from IN VARCHAR2
142: );
143: PROCEDURE copy_items
144: ( pn_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
145: ,pn_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
146: ,pn_source_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
147: ,pn_source_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
148: ,pn_regime_code JAI_RGM_ITM_REGNS.REGIME_CODE%TYPE DEFAULT 'EXCISE' --added for bug#9191274
149: );

Line 146: ,pn_source_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE

142: );
143: PROCEDURE copy_items
144: ( pn_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
145: ,pn_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
146: ,pn_source_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
147: ,pn_source_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
148: ,pn_regime_code JAI_RGM_ITM_REGNS.REGIME_CODE%TYPE DEFAULT 'EXCISE' --added for bug#9191274
149: );
150:

Line 147: ,pn_source_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE

143: PROCEDURE copy_items
144: ( pn_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
145: ,pn_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
146: ,pn_source_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
147: ,pn_source_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
148: ,pn_regime_code JAI_RGM_ITM_REGNS.REGIME_CODE%TYPE DEFAULT 'EXCISE' --added for bug#9191274
149: );
150:
151: PROCEDURE delete_items

Line 152: ( pn_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE

148: ,pn_regime_code JAI_RGM_ITM_REGNS.REGIME_CODE%TYPE DEFAULT 'EXCISE' --added for bug#9191274
149: );
150:
151: PROCEDURE delete_items
152: ( pn_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
153: ,pn_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
154: );
155:
156: /* End of Bug# 4389149 */

Line 153: ,pn_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE

149: );
150:
151: PROCEDURE delete_items
152: ( pn_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
153: ,pn_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
154: );
155:
156: /* End of Bug# 4389149 */
157: