APPS.JAI_AP_UTILS_PKG dependencies on JAI_AP_TDS_THHOLD_GRPS

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

2037: P_new_pan_num IN JAI_AP_TDS_VENDOR_HDRS.pan_no%TYPE,
2038: P_debug_flag IN varchar2) is
2039:
2040:
2041: /* Cursor to lock the jai_ap_tds_thhold_grps */
2042:
2043: Cursor C_lock_thhold_grps is
2044: select threshold_grp_id,
2045: vendor_id,

Line 2063: from jai_ap_tds_thhold_grps

2059: creation_date,
2060: last_updated_by,
2061: last_update_date,
2062: last_update_login
2063: from jai_ap_tds_thhold_grps
2064: where vendor_id = P_vendor_id
2065: and vendor_pan_num = p_old_pan_num
2066: order by vendor_id,threshold_grp_id
2067: for UPDATE of threshold_grp_id NOWAIT;

Line 2074: (2) jai_ap_tds_thhold_grps

2070:
2071: /* Update the tables in the following order
2072:
2073: (1) JAI_AP_TDS_VENDOR_HDRS
2074: (2) jai_ap_tds_thhold_grps
2075: (3) jai_ap_tds_thhold_xceps
2076:
2077: */
2078:

Line 2135: -- Update the jai_ap_tds_thhold_grps

2131: If lv_debug_flag = 'Y' then
2132: Print_log(lv_debug_flag, lv_debug_msg);
2133: End if;
2134:
2135: -- Update the jai_ap_tds_thhold_grps
2136:
2137: lv_debug_msg := ' 1. Update jai_ap_tds_thhold_grps';
2138:
2139: If lv_debug_flag = 'Y' then

Line 2137: lv_debug_msg := ' 1. Update jai_ap_tds_thhold_grps';

2133: End if;
2134:
2135: -- Update the jai_ap_tds_thhold_grps
2136:
2137: lv_debug_msg := ' 1. Update jai_ap_tds_thhold_grps';
2138:
2139: If lv_debug_flag = 'Y' then
2140: Print_log(lv_debug_flag, lv_debug_msg);
2141: End if;

Line 2146: lv_debug_msg := ' 2. Going to update jai_ap_tds_thhold_grps';

2142:
2143: for thhold_grps in C_lock_thhold_grps
2144: loop
2145:
2146: lv_debug_msg := ' 2. Going to update jai_ap_tds_thhold_grps';
2147:
2148: If lv_debug_flag = 'Y' then
2149: Print_log(lv_debug_flag, lv_debug_msg);
2150: End if;

Line 2152: update jai_ap_tds_thhold_grps

2148: If lv_debug_flag = 'Y' then
2149: Print_log(lv_debug_flag, lv_debug_msg);
2150: End if;
2151:
2152: update jai_ap_tds_thhold_grps
2153: set vendor_pan_num = P_new_pan_num
2154: where vendor_id = P_vendor_id
2155: and vendor_pan_num = P_old_pan_num
2156: and threshold_grp_id = thhold_grps.threshold_grp_id;