APPS.BOM_IMPORT_PUB dependencies on MTL_SYSTEM_ITEMS_INTERFACE_S

Line 331: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

327: BEGIN
328: update
329: BOM_BILL_OF_MTLS_INTERFACE
330: set
331: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
332: where
333: transaction_id is null
334: and batch_id = p_batch_id
335: and process_flag = 1;

Line 340: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

336:
337: update
338: BOM_INVENTORY_COMPS_INTERFACE
339: set
340: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
341: where
342: transaction_id is null
343: and batch_id = p_batch_id
344: and process_flag = 1;

Line 349: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

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

Line 358: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

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

Line 4324: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

4320: (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)),
4321: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),
4322: l_str_name(i),
4323: l_comp_pdh_table(k).component_item_id,
4324: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
4325: );
4326:
4327: Disable_Refds
4328: (

Line 4457: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

4453: (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)),
4454: (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)),
4455: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),
4456: l_str_name(i),
4457: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
4458: );
4459: END IF;
4460: Disable_Refds
4461: (

Line 4523: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

4519: (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)),
4520: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),
4521: l_str_name(i),
4522: l_comp_pdh_table(j).component_item_id ,
4523: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
4524: );
4525:
4526: Disable_Refds
4527: (

Line 4644: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

4640: (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)),
4641: (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)),
4642: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),
4643: l_str_name(i),
4644: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
4645: );
4646: END IF;
4647: Disable_Refds
4648: (

Line 4708: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

4704: IS
4705: L_NEXT_VALUE NUMBER;
4706: BEGIN
4707: SELECT
4708: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
4709: INTO
4710: L_NEXT_VALUE
4711: FROM DUAL;
4712: RETURN L_NEXT_VALUE;