APPS.FLM_EXECUTION_UTIL dependencies on FLM_EXE_SERIAL_NUMBERS

Line 1715: from flm_exe_serial_numbers

1711: p_org_id NUMBER,
1712: p_op_seq_num NUMBER,
1713: p_inv_item_id NUMBER) IS
1714: select fm_serial_number, to_serial_number, serial_quantity, lot_number, parent_serial_number, creation_date
1715: from flm_exe_serial_numbers
1716: where organization_id = p_org_id
1717: and wip_entity_id = p_wip_ent_id
1718: and inventory_item_id = p_inv_item_id
1719: and operation_seq_num = p_op_seq_num

Line 1728: from flm_exe_serial_numbers

1724: p_op_seq_num NUMBER,
1725: p_inv_item_id NUMBER,
1726: p_comp_lot_num VARCHAR2) IS
1727: select fm_serial_number, to_serial_number, serial_quantity, lot_number, parent_serial_number, creation_date
1728: from flm_exe_serial_numbers
1729: where organization_id = p_org_id
1730: and wip_entity_id = p_wip_ent_id
1731: and inventory_item_id = p_inv_item_id
1732: and operation_seq_num = p_op_seq_num

Line 1923: from flm_exe_serial_numbers fesn

1919: CURSOR item_serials(p_org_id IN NUMBER, p_wip_entity_id NUMBER,
1920: p_operation_seq_num NUMBER, p_inventory_item_id NUMBER) IS
1921: select organization_id, wip_entity_id, operation_seq_num, inventory_item_id,
1922: fm_serial_number, to_serial_number, parent_serial_number, lot_number
1923: from flm_exe_serial_numbers fesn
1924: where organization_id = p_org_id
1925: and wip_entity_id = p_wip_entity_id
1926: and operation_seq_num = p_operation_seq_num
1927: and inventory_item_id = p_inventory_item_id;

Line 1980: insert into flm_exe_serial_numbers(

1976:
1977: -- concatenate the serial number to be inserted
1978: l_cur_serial_number := SUBSTR(p_fm_serial, 1, LENGTH(p_fm_serial) - LENGTH(l_cur_ser_number))
1979: || l_cur_ser_number;
1980: insert into flm_exe_serial_numbers(
1981: requirement_serial_id,
1982: organization_id,
1983: wip_entity_id,
1984: operation_seq_num,

Line 1999: flm_exe_serial_numbers_s.nextval,

1995: last_update_date,
1996: last_updated_by)
1997: values
1998: (
1999: flm_exe_serial_numbers_s.nextval,
2000: p_org_id,
2001: p_wip_entity_id,
2002: p_operation_seq_num,
2003: p_inventory_item_id,

Line 2018: delete from flm_exe_serial_numbers

2014: l_user_id
2015: );
2016: END LOOP;
2017: --now delete the original range row
2018: delete from flm_exe_serial_numbers
2019: where organization_id = p_org_id
2020: and wip_entity_id = p_wip_entity_id
2021: and operation_seq_num = p_operation_seq_num
2022: and inventory_item_id = p_inventory_item_id