DBA Data[Home] [Help]

APPS.JAI_PO_HOOK_PKG dependencies on DUAL

Line 912: SELECT JAI_CMN_LINES_S.NEXTVAL INTO ln_cmn_line_id FROM DUAL;

908:
909: FOR r_txns IN c_txns_interface(p_hdr_intf_id)
910: LOOP
911: /*ln_cmn_line_id := JAI_CMN_LINES_S.nextval;*/
912: SELECT JAI_CMN_LINES_S.NEXTVAL INTO ln_cmn_line_id FROM DUAL;
913:
914: OPEN c_po_line_loc_details(r_txns.po_line_location_id);
915: FETCH c_po_line_loc_details
916: INTO r_line_locations;

Line 1555: SELECT fnd_profile.VALUE(cp_profile_name) FROM DUAL;

1551: END gettax;
1552:
1553: FUNCTION get_profile_value(cp_profile_name VARCHAR2) RETURN VARCHAR2 IS
1554: CURSOR c_iproc_profile IS
1555: SELECT fnd_profile.VALUE(cp_profile_name) FROM DUAL;
1556:
1557: lv_iproc_profile VARCHAR2(100);
1558:
1559: BEGIN