APPS.GMI_APIXML_PKG dependencies on GMI_LOTS_CONV_XML_INTERFACE

Line 54: l_ext_conv_id GMI_LOTS_CONV_XML_INTERFACE.EXT_CONV_ID%TYPE;

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
58: SELECT user_name, item_number

Line 74: FROM gmi_lots_conv_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
74: FROM gmi_lots_conv_xml_interface
75: WHERE conv_interface_id = TO_NUMBER(p_conv_if_id);
76:
77: BEGIN
78:

Line 1410: l_lot_interface_rec gmi_lots_conv_xml_interface%ROWTYPE;

1406: funcmode IN VARCHAR2,
1407: resultout IN OUT NOCOPY VARCHAR2 )
1408: IS
1409:
1410: l_lot_interface_rec gmi_lots_conv_xml_interface%ROWTYPE;
1411: l_trans_rec Gmigapi.conv_rec_typ;
1412:
1413: l_ic_item_cnv_row IC_ITEM_CNV%ROWTYPE;
1414:

Line 1427: FROM gmi_lots_conv_xml_interface

1423: l_record_count NUMBER :=0;
1424:
1425: CURSOR c_if_rec(p_interface_id NUMBER, p_ext_lot_id NUMBER) IS
1426: SELECT *
1427: FROM gmi_lots_conv_xml_interface
1428: WHERE conv_interface_id = p_interface_id
1429: AND ext_conv_id = p_ext_lot_id;
1430:
1431: l_lot_iface_id NUMBER(15);

Line 1559: DELETE FROM gmi_lots_conv_xml_interface

1555: l_confirm_statuslvl,
1556: l_icn,
1557: l_event_key);
1558:
1559: DELETE FROM gmi_lots_conv_xml_interface
1560: WHERE conv_interface_id = l_lot_iface_id
1561: AND ext_conv_id = l_ext_lot_id;
1562:
1563:

Line 1711: UPDATE gmi_lots_conv_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
1711: UPDATE gmi_lots_conv_xml_interface
1712: SET error_text = SUBSTRB(error_text || p_err_msg, 1, 2000),
1713: processed_ind = 3
1714: WHERE conv_interface_id = p_if_id;
1715: END IF;