APPS.FLM_EXECUTION_UTIL dependencies on FLM_EXE_SERIAL_NUMBERS

Line 1495: from flm_exe_serial_numbers

1491: p_org_id NUMBER,
1492: p_op_seq_num NUMBER,
1493: p_inv_item_id NUMBER) IS
1494: select fm_serial_number, to_serial_number, serial_quantity, lot_number, parent_serial_number, creation_date
1495: from flm_exe_serial_numbers
1496: where organization_id = p_org_id
1497: and wip_entity_id = p_wip_ent_id
1498: and inventory_item_id = p_inv_item_id
1499: and operation_seq_num = p_op_seq_num

Line 1508: from flm_exe_serial_numbers

1504: p_op_seq_num NUMBER,
1505: p_inv_item_id NUMBER,
1506: p_comp_lot_num VARCHAR2) IS
1507: select fm_serial_number, to_serial_number, serial_quantity, lot_number, parent_serial_number, creation_date
1508: from flm_exe_serial_numbers
1509: where organization_id = p_org_id
1510: and wip_entity_id = p_wip_ent_id
1511: and inventory_item_id = p_inv_item_id
1512: and operation_seq_num = p_op_seq_num

Line 1703: from flm_exe_serial_numbers fesn

1699: CURSOR item_serials(p_org_id IN NUMBER, p_wip_entity_id NUMBER,
1700: p_operation_seq_num NUMBER, p_inventory_item_id NUMBER) IS
1701: select organization_id, wip_entity_id, operation_seq_num, inventory_item_id,
1702: fm_serial_number, to_serial_number, parent_serial_number, lot_number
1703: from flm_exe_serial_numbers fesn
1704: where organization_id = p_org_id
1705: and wip_entity_id = p_wip_entity_id
1706: and operation_seq_num = p_operation_seq_num
1707: and inventory_item_id = p_inventory_item_id;

Line 1760: insert into flm_exe_serial_numbers(

1756:
1757: -- concatenate the serial number to be inserted
1758: l_cur_serial_number := SUBSTR(p_fm_serial, 1, LENGTH(p_fm_serial) - LENGTH(l_cur_ser_number))
1759: || l_cur_ser_number;
1760: insert into flm_exe_serial_numbers(
1761: requirement_serial_id,
1762: organization_id,
1763: wip_entity_id,
1764: operation_seq_num,

Line 1779: flm_exe_serial_numbers_s.nextval,

1775: last_update_date,
1776: last_updated_by)
1777: values
1778: (
1779: flm_exe_serial_numbers_s.nextval,
1780: p_org_id,
1781: p_wip_entity_id,
1782: p_operation_seq_num,
1783: p_inventory_item_id,

Line 1798: delete from flm_exe_serial_numbers

1794: l_user_id
1795: );
1796: END LOOP;
1797: --now delete the original range row
1798: delete from flm_exe_serial_numbers
1799: where organization_id = p_org_id
1800: and wip_entity_id = p_wip_entity_id
1801: and operation_seq_num = p_operation_seq_num
1802: and inventory_item_id = p_inventory_item_id