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.JAI_PAN_UPDATE_PKG dependencies on JAI_AP_TDS_VENDOR_HDRS

Line 41: P_old_pan_num IN JAI_AP_TDS_VENDOR_HDRS.pan_no%TYPE,

37:
38: Procedure pan_update ( P_errbuf OUT NOCOPY varchar2,
39: P_return_code OUT NOCOPY varchar2,
40: P_vendor_id IN PO_VENDORS.vendor_id%TYPE,
41: P_old_pan_num IN JAI_AP_TDS_VENDOR_HDRS.pan_no%TYPE,
42: P_new_pan_num IN JAI_AP_TDS_VENDOR_HDRS.pan_no%TYPE,
43: P_debug_flag IN varchar2) is
44:
45:

Line 42: P_new_pan_num IN JAI_AP_TDS_VENDOR_HDRS.pan_no%TYPE,

38: Procedure pan_update ( P_errbuf OUT NOCOPY varchar2,
39: P_return_code OUT NOCOPY varchar2,
40: P_vendor_id IN PO_VENDORS.vendor_id%TYPE,
41: P_old_pan_num IN JAI_AP_TDS_VENDOR_HDRS.pan_no%TYPE,
42: P_new_pan_num IN JAI_AP_TDS_VENDOR_HDRS.pan_no%TYPE,
43: P_debug_flag IN varchar2) is
44:
45:
46: /* Cursor to lock the jai_ap_tds_thhold_grps */

Line 181: -- Update the JAI_AP_TDS_VENDOR_HDRS

177:
178: end loop;
179:
180:
181: -- Update the JAI_AP_TDS_VENDOR_HDRS
182: lv_debug_msg := ' 5. Update JAI_AP_TDS_VENDOR_HDRS';
183:
184: If lv_debug_flag = 'Y' then
185: Print_log(lv_debug_flag, lv_debug_msg);

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

178: end loop;
179:
180:
181: -- Update the JAI_AP_TDS_VENDOR_HDRS
182: lv_debug_msg := ' 5. Update JAI_AP_TDS_VENDOR_HDRS';
183:
184: If lv_debug_flag = 'Y' then
185: Print_log(lv_debug_flag, lv_debug_msg);
186: End if;

Line 189: from JAI_AP_TDS_VENDOR_HDRS vthdr

185: Print_log(lv_debug_flag, lv_debug_msg);
186: End if;
187:
188: for vndr_tds_hdr in (select vthdr.*
189: from JAI_AP_TDS_VENDOR_HDRS vthdr
190: where vthdr.vendor_id = P_vendor_id
191: and vthdr.pan_no = P_old_pan_num)
192: loop
193:

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

190: where vthdr.vendor_id = P_vendor_id
191: and vthdr.pan_no = P_old_pan_num)
192: loop
193:
194: lv_debug_msg := ' 6. Going to update JAI_AP_TDS_VENDOR_HDRS';
195:
196: If lv_debug_flag = 'Y' then
197: Print_log(lv_debug_flag, lv_debug_msg);
198: End if;

Line 200: update JAI_AP_TDS_VENDOR_HDRS

196: If lv_debug_flag = 'Y' then
197: Print_log(lv_debug_flag, lv_debug_msg);
198: End if;
199:
200: update JAI_AP_TDS_VENDOR_HDRS
201: set pan_no = P_new_pan_num
202: where vendor_id = vndr_tds_hdr.vendor_id
203: and vendor_site_id = vndr_tds_hdr.vendor_site_id
204: and pan_no = P_old_pan_num;