APPS.GMI_APIXML_PKG dependencies on GMI_ITEMS_XML_INTERFACE

Line 64: FROM gmi_items_xml_interface

60: WHERE quantity_interface_id = TO_NUMBER(p_qty_if_id);
61:
62: CURSOR c_item_user_name(p_item_if_id VARCHAR2) IS
63: SELECT user_name, item_number
64: FROM gmi_items_xml_interface
65: WHERE item_interface_id = TO_NUMBER(p_item_if_id);
66:
67: CURSOR c_lot_user_name(p_lot_if_id VARCHAR2) IS
68: SELECT user_name, item_number, lot_number, ext_lot_id

Line 720: l_item_interface_rec gmi_items_xml_interface%ROWTYPE;

716: funcmode IN VARCHAR2,
717: resultout IN OUT NOCOPY VARCHAR2 )
718: IS
719:
720: l_item_interface_rec gmi_items_xml_interface%ROWTYPE;
721: l_item_rec Gmigapi.item_rec_typ;
722:
723: l_ic_item_mst_row ic_item_mst%ROWTYPE;
724: l_ic_item_cpg_row ic_item_cpg%ROWTYPE;

Line 736: FROM gmi_items_xml_interface

732: l_record_count NUMBER :=0;
733:
734: CURSOR c_item_rec(p_item_interface_id NUMBER, p_ext_item_id NUMBER) IS
735: SELECT *
736: FROM gmi_items_xml_interface
737: WHERE item_interface_id = p_item_interface_id
738: AND EXT_ITEM_ID = p_ext_item_id;
739:
740: l_item_iface_id NUMBER(15);

Line 966: DELETE FROM gmi_items_xml_interface

962: l_confirm_statuslvl,
963: l_icn,
964: l_event_key);
965:
966: DELETE FROM gmi_items_xml_interface
967: WHERE item_interface_id = l_item_iface_id
968: AND EXT_ITEM_ID = l_ext_item_id;
969:
970: resultout := 'COMPLETE:Y';

Line 1701: UPDATE gmi_items_xml_interface

1697: SET error_text = SUBSTRB(error_text || p_err_msg, 1, 2000),
1698: processed_ind = 3
1699: WHERE quantity_interface_id = p_if_id;
1700: ELSIF p_proc_name = 'create_item' THEN
1701: UPDATE gmi_items_xml_interface
1702: SET error_text = SUBSTRB(error_text || p_err_msg, 1, 2000),
1703: processed_ind = 3
1704: WHERE item_interface_id = p_if_id;
1705: ELSIF p_proc_name = 'create_lot' THEN