eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_AUCTION_PKG dependencies on POS_SUPPLIER_REGISTRATIONS

Line 17490: l_reg_key pos_supplier_registrations.reg_key%TYPE;

17486: -- Function to get prospective supplier registration URL
17487: FUNCTION GET_SUPPLIER_REG_URL(p_supp_reg_id NUMBER) RETURN VARCHAR2
17488: IS
17489:
17490: l_reg_key pos_supplier_registrations.reg_key%TYPE;
17491:
17492: CURSOR l_cur IS
17493: SELECT reg_key
17494: FROM pos_supplier_registrations

Line 17494: FROM pos_supplier_registrations

17490: l_reg_key pos_supplier_registrations.reg_key%TYPE;
17491:
17492: CURSOR l_cur IS
17493: SELECT reg_key
17494: FROM pos_supplier_registrations
17495: WHERE supplier_reg_id = p_supp_reg_id;
17496:
17497: BEGIN
17498:

Line 17562: UPDATE pos_supplier_registrations

17558: PROCEDURE UPDATE_SUPPLIER_REG_STATUS(p_supp_reg_id IN NUMBER)
17559: AS
17560: BEGIN
17561:
17562: UPDATE pos_supplier_registrations
17563: SET registration_status = 'RIF_SUPPLIER'
17564: WHERE supplier_reg_id = p_supp_reg_id
17565: AND registration_status = 'PENDING_APPROVAL';
17566: