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.

[Home] [Help]

APPS.JAI_AP_UTILS_PKG dependencies on JAI_AP_TDS_VENDOR_HDRS

Line 1814: P_old_pan_num IN JAI_AP_TDS_VENDOR_HDRS.pan_no%TYPE,

1810:
1811: Procedure pan_update ( P_errbuf OUT NOCOPY varchar2,
1812: P_return_code OUT NOCOPY varchar2,
1813: P_vendor_id IN PO_VENDORS.vendor_id%TYPE,
1814: P_old_pan_num IN JAI_AP_TDS_VENDOR_HDRS.pan_no%TYPE,
1815: P_new_pan_num IN JAI_AP_TDS_VENDOR_HDRS.pan_no%TYPE,
1816: P_debug_flag IN varchar2) is
1817:
1818:

Line 1815: P_new_pan_num IN JAI_AP_TDS_VENDOR_HDRS.pan_no%TYPE,

1811: Procedure pan_update ( P_errbuf OUT NOCOPY varchar2,
1812: P_return_code OUT NOCOPY varchar2,
1813: P_vendor_id IN PO_VENDORS.vendor_id%TYPE,
1814: P_old_pan_num IN JAI_AP_TDS_VENDOR_HDRS.pan_no%TYPE,
1815: P_new_pan_num IN JAI_AP_TDS_VENDOR_HDRS.pan_no%TYPE,
1816: P_debug_flag IN varchar2) is
1817:
1818:
1819: /* Cursor to lock the jai_ap_tds_thhold_grps */

Line 1851: (1) JAI_AP_TDS_VENDOR_HDRS

1847:
1848:
1849: /* Update the tables in the following order
1850:
1851: (1) JAI_AP_TDS_VENDOR_HDRS
1852: (2) jai_ap_tds_thhold_grps
1853: (3) jai_ap_tds_thhold_xceps
1854:
1855: */

Line 1954: -- Update the JAI_AP_TDS_VENDOR_HDRS

1950:
1951: end loop;
1952:
1953:
1954: -- Update the JAI_AP_TDS_VENDOR_HDRS
1955: lv_debug_msg := ' 5. Update JAI_AP_TDS_VENDOR_HDRS';
1956:
1957: If lv_debug_flag = 'Y' then
1958: Print_log(lv_debug_flag, lv_debug_msg);

Line 1955: lv_debug_msg := ' 5. Update JAI_AP_TDS_VENDOR_HDRS';

1951: end loop;
1952:
1953:
1954: -- Update the JAI_AP_TDS_VENDOR_HDRS
1955: lv_debug_msg := ' 5. Update JAI_AP_TDS_VENDOR_HDRS';
1956:
1957: If lv_debug_flag = 'Y' then
1958: Print_log(lv_debug_flag, lv_debug_msg);
1959: End if;

Line 1962: from JAI_AP_TDS_VENDOR_HDRS vthdr

1958: Print_log(lv_debug_flag, lv_debug_msg);
1959: End if;
1960:
1961: for vndr_tds_hdr in (select vthdr.*
1962: from JAI_AP_TDS_VENDOR_HDRS vthdr
1963: where vthdr.vendor_id = P_vendor_id
1964: and vthdr.pan_no = P_old_pan_num)
1965: loop
1966:

Line 1967: lv_debug_msg := ' 6. Going to update JAI_AP_TDS_VENDOR_HDRS';

1963: where vthdr.vendor_id = P_vendor_id
1964: and vthdr.pan_no = P_old_pan_num)
1965: loop
1966:
1967: lv_debug_msg := ' 6. Going to update JAI_AP_TDS_VENDOR_HDRS';
1968:
1969: If lv_debug_flag = 'Y' then
1970: Print_log(lv_debug_flag, lv_debug_msg);
1971: End if;

Line 1973: update JAI_AP_TDS_VENDOR_HDRS

1969: If lv_debug_flag = 'Y' then
1970: Print_log(lv_debug_flag, lv_debug_msg);
1971: End if;
1972:
1973: update JAI_AP_TDS_VENDOR_HDRS
1974: set pan_no = P_new_pan_num
1975: where vendor_id = vndr_tds_hdr.vendor_id
1976: and vendor_site_id = vndr_tds_hdr.vendor_site_id
1977: and pan_no = P_old_pan_num;