APPS.BOM_IMPORT_PUB dependencies on MTL_SYSTEM_ITEMS_INTERFACE_S

Line 338: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

334: BEGIN
335: update
336: BOM_BILL_OF_MTLS_INTERFACE
337: set
338: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
339: where
340: transaction_id is null
341: and batch_id = p_batch_id
342: and process_flag = 1;

Line 347: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

343:
344: update
345: BOM_INVENTORY_COMPS_INTERFACE
346: set
347: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
348: where
349: transaction_id is null
350: and batch_id = p_batch_id
351: and process_flag = 1;

Line 356: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

352:
353: update
354: BOM_SUB_COMPS_INTERFACE
355: set
356: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
357: where
358: transaction_id is null
359: and batch_id = p_batch_id
360: and process_flag = 1;

Line 365: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

361:
362: update
363: BOM_REF_DESGS_INTERFACE
364: set
365: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
366: where
367: transaction_id is null
368: and batch_id = p_batch_id
369: and process_flag = 1;

Line 4716: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

4712: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id = l_comp_pdh_table(k).component_item_id AND organization_id = l_org_id_table(i)),
4713: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),
4714: l_str_name(i),
4715: l_comp_pdh_table(k).component_item_id,
4716: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
4717: );
4718:
4719: Disable_Refds
4720: (

Line 4849: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

4845: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id =l_comp_pdh_table(k).component_item_id AND organization_id = l_org_id_table(i)),
4846: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id = l_item_id_table(i) AND organization_id = l_org_id_table(i)),
4847: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),
4848: l_str_name(i),
4849: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
4850: );
4851: END IF;
4852: Disable_Refds
4853: (

Line 4915: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

4911: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id = l_comp_pdh_table(j).component_item_id AND organization_id = l_org_id_table(i)),
4912: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),
4913: l_str_name(i),
4914: l_comp_pdh_table(j).component_item_id ,
4915: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
4916: );
4917:
4918: Disable_Refds
4919: (

Line 5036: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

5032: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id =l_comp_pdh_table(j).component_item_id AND organization_id = l_org_id_table(i)),
5033: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id = l_item_id_table(i) AND organization_id = l_org_id_table(i)),
5034: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),
5035: l_str_name(i),
5036: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
5037: );
5038: END IF;
5039: Disable_Refds
5040: (

Line 5100: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

5096: IS
5097: L_NEXT_VALUE NUMBER;
5098: BEGIN
5099: SELECT
5100: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
5101: INTO
5102: L_NEXT_VALUE
5103: FROM DUAL;
5104: RETURN L_NEXT_VALUE;