DBA Data[Home] [Help]

APPS.CSM_MULTI_MOBQRY_PKG dependencies on CSM_SERIAL_NUMBERS_EVENT_PKG

Line 576: CSM_SERIAL_NUMBERS_EVENT_PKG.RECEIVED_MTL_SERIAL_NUM(r_part_line.destination_organization_id,r_part_line.destination_subinventory

572: ELSE
573: CSM_SYSTEM_ITEM_EVENT_PKG.RECEIVED_MTL_ONHAND(r_part_line.destination_organization_id,r_part_line.destination_subinventory
574: ,r_part_line.INVENTORY_ITEM_ID,l_user_id);
575: IF(r_part_line.serial_number IS NOT NULL) THEN
576: CSM_SERIAL_NUMBERS_EVENT_PKG.RECEIVED_MTL_SERIAL_NUM(r_part_line.destination_organization_id,r_part_line.destination_subinventory
577: ,r_part_line.INVENTORY_ITEM_ID,r_part_line.serial_number,l_user_id);
578: END IF;
579: IF r_part_line.source_type='IO' THEN
580: FOR rec IN (SELECT USER_ID FROM CSP_REQ_LINE_DETAILS rld ,CSM_REQ_LINE_DETAILS_ACC acc

Line 849: CSM_SERIAL_NUMBERS_EVENT_PKG.RECEIVED_MTL_SERIAL_NUM(r_part_line.destination_organization_id,r_part_line.destination_subinventory

845: ELSE
846: CSM_SYSTEM_ITEM_EVENT_PKG.RECEIVED_MTL_ONHAND(r_part_line.destination_organization_id,r_part_line.destination_subinventory
847: ,r_part_line.INVENTORY_ITEM_ID,l_user_id);
848: IF(r_part_line.serial_number IS NOT NULL) THEN
849: CSM_SERIAL_NUMBERS_EVENT_PKG.RECEIVED_MTL_SERIAL_NUM(r_part_line.destination_organization_id,r_part_line.destination_subinventory
850: ,r_part_line.INVENTORY_ITEM_ID,r_part_line.serial_number,l_user_id);
851: END IF;
852: IF r_part_line.source_type='IO' AND NOT l_dummy THEN
853: FOR rec IN (SELECT USER_ID FROM CSP_REQ_LINE_DETAILS rld ,CSM_REQ_LINE_DETAILS_ACC acc