APPS.JAI_PAN_UPDATE_PKG dependencies on JAI_AP_TDS_THHOLD_GRPS

Line 46: /* Cursor to lock the jai_ap_tds_thhold_grps */

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 */
47:
48: Cursor C_lock_thhold_grps is
49: select threshold_grp_id,
50: vendor_id,

Line 68: from JAI_AP_TDS_THHOLD_GRPS

64: creation_date,
65: last_updated_by,
66: last_update_date,
67: last_update_login
68: from JAI_AP_TDS_THHOLD_GRPS
69: where vendor_id = P_vendor_id
70: and vendor_pan_num = p_old_pan_num
71: order by vendor_id,threshold_grp_id
72: for UPDATE of threshold_grp_id NOWAIT;

Line 79: (2) jai_ap_tds_thhold_grps

75:
76: /* Update the tables in the following order
77:
78: (1) ja_in_vendor_tds_info_hdr
79: (2) jai_ap_tds_thhold_grps
80: (3) jai_ap_tds_thhold_xceps
81:
82: */
83:

Line 140: -- Update the jai_ap_tds_thhold_grps

136: If lv_debug_flag = 'Y' then
137: Print_log(lv_debug_flag, lv_debug_msg);
138: End if;
139:
140: -- Update the jai_ap_tds_thhold_grps
141:
142: lv_debug_msg := ' 1. Update JAI_AP_TDS_THHOLD_GRPS';
143:
144: If lv_debug_flag = 'Y' then

Line 142: lv_debug_msg := ' 1. Update JAI_AP_TDS_THHOLD_GRPS';

138: End if;
139:
140: -- Update the jai_ap_tds_thhold_grps
141:
142: lv_debug_msg := ' 1. Update JAI_AP_TDS_THHOLD_GRPS';
143:
144: If lv_debug_flag = 'Y' then
145: Print_log(lv_debug_flag, lv_debug_msg);
146: End if;

Line 151: lv_debug_msg := ' 2. Going to update JAI_AP_TDS_THHOLD_GRPS';

147:
148: for thhold_grps in C_lock_thhold_grps
149: loop
150:
151: lv_debug_msg := ' 2. Going to update JAI_AP_TDS_THHOLD_GRPS';
152:
153: If lv_debug_flag = 'Y' then
154: Print_log(lv_debug_flag, lv_debug_msg);
155: End if;

Line 157: update JAI_AP_TDS_THHOLD_GRPS

153: If lv_debug_flag = 'Y' then
154: Print_log(lv_debug_flag, lv_debug_msg);
155: End if;
156:
157: update JAI_AP_TDS_THHOLD_GRPS
158: set vendor_pan_num = P_new_pan_num
159: where vendor_id = P_vendor_id
160: and vendor_pan_num = P_old_pan_num
161: and threshold_grp_id = thhold_grps.threshold_grp_id;