APPS.JAI_AP_UTILS_PKG dependencies on JAI_AP_TDS_THHOLD_GRPS

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

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 */
1820:
1821: Cursor C_lock_thhold_grps is
1822: select threshold_grp_id,
1823: vendor_id,

Line 1841: from jai_ap_tds_thhold_grps

1837: creation_date,
1838: last_updated_by,
1839: last_update_date,
1840: last_update_login
1841: from jai_ap_tds_thhold_grps
1842: where vendor_id = P_vendor_id
1843: and vendor_pan_num = p_old_pan_num
1844: order by vendor_id,threshold_grp_id
1845: for UPDATE of threshold_grp_id NOWAIT;

Line 1852: (2) jai_ap_tds_thhold_grps

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: */
1856:

Line 1913: -- Update the jai_ap_tds_thhold_grps

1909: If lv_debug_flag = 'Y' then
1910: Print_log(lv_debug_flag, lv_debug_msg);
1911: End if;
1912:
1913: -- Update the jai_ap_tds_thhold_grps
1914:
1915: lv_debug_msg := ' 1. Update jai_ap_tds_thhold_grps';
1916:
1917: If lv_debug_flag = 'Y' then

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

1911: End if;
1912:
1913: -- Update the jai_ap_tds_thhold_grps
1914:
1915: lv_debug_msg := ' 1. Update jai_ap_tds_thhold_grps';
1916:
1917: If lv_debug_flag = 'Y' then
1918: Print_log(lv_debug_flag, lv_debug_msg);
1919: End if;

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

1920:
1921: for thhold_grps in C_lock_thhold_grps
1922: loop
1923:
1924: lv_debug_msg := ' 2. Going to update jai_ap_tds_thhold_grps';
1925:
1926: If lv_debug_flag = 'Y' then
1927: Print_log(lv_debug_flag, lv_debug_msg);
1928: End if;

Line 1930: update jai_ap_tds_thhold_grps

1926: If lv_debug_flag = 'Y' then
1927: Print_log(lv_debug_flag, lv_debug_msg);
1928: End if;
1929:
1930: update jai_ap_tds_thhold_grps
1931: set vendor_pan_num = P_new_pan_num
1932: where vendor_id = P_vendor_id
1933: and vendor_pan_num = P_old_pan_num
1934: and threshold_grp_id = thhold_grps.threshold_grp_id;