APPS.GMI_APIXML_PKG dependencies on GMI_LOTS_XML_INTERFACE

Line 52: l_lot_number GMI_LOTS_XML_INTERFACE.LOT_NUMBER%TYPE;

48: l_role_name VARCHAR2(255);
49: l_role_display_name VARCHAR2(255);
50:
51: l_item_number VARCHAR2(32);
52: l_lot_number GMI_LOTS_XML_INTERFACE.LOT_NUMBER%TYPE;
53: l_ext_lot_id GMI_LOTS_XML_INTERFACE.EXT_LOT_ID%TYPE;
54: l_ext_conv_id GMI_LOTS_CONV_XML_INTERFACE.EXT_CONV_ID%TYPE;
55:
56: --Cursors to fetch the user name from the interface record.

Line 53: l_ext_lot_id GMI_LOTS_XML_INTERFACE.EXT_LOT_ID%TYPE;

49: l_role_display_name VARCHAR2(255);
50:
51: l_item_number VARCHAR2(32);
52: l_lot_number GMI_LOTS_XML_INTERFACE.LOT_NUMBER%TYPE;
53: l_ext_lot_id GMI_LOTS_XML_INTERFACE.EXT_LOT_ID%TYPE;
54: l_ext_conv_id GMI_LOTS_CONV_XML_INTERFACE.EXT_CONV_ID%TYPE;
55:
56: --Cursors to fetch the user name from the interface record.
57: CURSOR c_qty_user_name(p_qty_if_id VARCHAR2) IS

Line 69: FROM gmi_lots_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
69: FROM gmi_lots_xml_interface
70: WHERE lot_interface_id = TO_NUMBER(p_lot_if_id);
71:
72: CURSOR c_conv_user_name(p_conv_if_id VARCHAR2) IS
73: SELECT user_name, item_number, lot_number, ext_conv_id

Line 1086: l_interface_rec gmi_lots_xml_interface%ROWTYPE;

1082: funcmode IN VARCHAR2,
1083: resultout IN OUT NOCOPY VARCHAR2 )
1084: IS
1085:
1086: l_interface_rec gmi_lots_xml_interface%ROWTYPE;
1087: l_trans_rec Gmigapi.lot_rec_typ;
1088:
1089: l_ic_lots_mst_row ic_lots_mst%ROWTYPE;
1090: l_ic_lots_cpg_row ic_lots_cpg%ROWTYPE;

Line 1102: FROM gmi_lots_xml_interface

1098: l_record_count NUMBER :=0;
1099:
1100: CURSOR c_if_rec(p_interface_id NUMBER, p_ext_lot_id NUMBER) IS
1101: SELECT *
1102: FROM gmi_lots_xml_interface
1103: WHERE lot_interface_id = p_interface_id
1104: AND ext_lot_id = p_ext_lot_id;
1105:
1106: l_lot_iface_id NUMBER(15);

Line 1291: DELETE FROM gmi_lots_xml_interface

1287: l_confirm_statuslvl,
1288: l_icn,
1289: l_event_key);
1290:
1291: DELETE FROM gmi_lots_xml_interface
1292: WHERE lot_interface_id = l_lot_iface_id
1293: AND ext_lot_id = l_ext_lot_id;
1294:
1295: resultout := 'COMPLETE:Y';

Line 1706: UPDATE gmi_lots_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
1706: UPDATE gmi_lots_xml_interface
1707: SET error_text = SUBSTRB(error_text || p_err_msg, 1, 2000),
1708: processed_ind = 3
1709: WHERE lot_interface_id = p_if_id;
1710: ELSIF p_proc_name = 'create_lot_conv' THEN