APPS.JL_AR_AP_WITHHOLDING_PKG dependencies on JL_AR_AP_SUP_AWT_CR_LTS

Line 261: * JL_AR_AP_SUP_AWT_CR_LTS table *

257: /**************************************************************************
258: * *
259: * Name : Insert_Credit_Letter_Amount *
260: * Purpose : Stores current information about credit letters into the *
261: * JL_AR_AP_SUP_AWT_CR_LTS table *
262: * *
263: **************************************************************************/
264: PROCEDURE Insert_Credit_Letter_Amount
265: (P_Vendor_Id IN Number,

Line 4124: FROM jl_ar_ap_sup_awt_cr_lts

4120: ------------------------------------------------------
4121:
4122: SELECT max(seq_num)
4123: INTO l_seq_num
4124: FROM jl_ar_ap_sup_awt_cr_lts
4125: WHERE po_vendor_id = P_Vendor_Id
4126: AND awt_type_code = P_AWT_Type_Code;
4127:
4128: IF (l_seq_num IS NULL) THEN

Line 4134: FROM jl_ar_ap_sup_awt_cr_lts

4130: END IF;
4131:
4132: SELECT balance
4133: INTO l_credit_letter_amount
4134: FROM jl_ar_ap_sup_awt_cr_lts
4135: WHERE po_vendor_id = P_Vendor_Id
4136: AND awt_type_code = P_AWT_Type_Code
4137: AND seq_num = l_seq_num;
4138:

Line 4402: * JL_AR_AP_SUP_AWT_CR_LTS table *

4398: /**************************************************************************
4399: * *
4400: * Name : Insert_Credit_Letter_Amount *
4401: * Purpose : Stores current information about credit letters into the *
4402: * JL_AR_AP_SUP_AWT_CR_LTS table *
4403: * *
4404: **************************************************************************/
4405: PROCEDURE Insert_Credit_Letter_Amount
4406: (P_Vendor_Id IN Number,

Line 4442: -- Inserts record into JL_AR_AP_SUP_AWT_CR_LTS

4438: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Insert_Credit_Letter_Amount(+)');
4439: END IF;
4440:
4441: -----------------------------------------------
4442: -- Inserts record into JL_AR_AP_SUP_AWT_CR_LTS
4443: -----------------------------------------------
4444: INSERT INTO jl_ar_ap_sup_awt_cr_lts
4445: (seq_num,
4446: po_vendor_id,

Line 4444: INSERT INTO jl_ar_ap_sup_awt_cr_lts

4440:
4441: -----------------------------------------------
4442: -- Inserts record into JL_AR_AP_SUP_AWT_CR_LTS
4443: -----------------------------------------------
4444: INSERT INTO jl_ar_ap_sup_awt_cr_lts
4445: (seq_num,
4446: po_vendor_id,
4447: awt_type_code,
4448: tax_id,

Line 4466: (jl_ar_ap_sup_awt_cr_lts_s.nextval,

4462: program_id,
4463: request_id,
4464: status)
4465: VALUES
4466: (jl_ar_ap_sup_awt_cr_lts_s.nextval,
4467: P_Vendor_Id,
4468: P_AWT_Type_Code,
4469: P_Tax_Id,
4470: P_AWT_Date,

Line 4563: FROM jl_ar_ap_sup_awt_cr_lts jlcl

4559: SELECT jlcl.po_vendor_id vendor_id,
4560: jlcl.awt_type_code awt_type_code,
4561: jlcl.calc_wh_amnt calc_wh_amnt,
4562: jlcl.act_wheld_amnt act_wheld_amnt
4563: FROM jl_ar_ap_sup_awt_cr_lts jlcl
4564: WHERE jlcl.status = 'AA'
4565: AND ((P_Check_Id IS NOT NULL AND
4566: jlcl.check_id = P_Check_Id) OR
4567: (P_Selected_Check_Id IS NOT NULL AND

Line 4636: UPDATE jl_ar_ap_sup_awt_cr_lts

4632:
4633: ----------------------------------------------
4634: -- Changes the status of the reversed records
4635: ----------------------------------------------
4636: UPDATE jl_ar_ap_sup_awt_cr_lts
4637: SET status = 'AR'
4638: WHERE CURRENT OF c_credit_letters;
4639:
4640: END LOOP;

Line 5716: UPDATE jl_ar_ap_sup_awt_cr_lts

5712: -- Updates the credit letter information by
5713: -- replacing the selected check ID by the check ID
5714: ---------------------------------------------------
5715: IF (l_check_id IS NOT NULL) THEN
5716: UPDATE jl_ar_ap_sup_awt_cr_lts
5717: SET check_id = l_check_id,
5718: selected_check_id = null
5719: WHERE selected_check_id = l_check_id;
5720: END IF;