APPS.JL_BR_AP_PAY_SCHED_GDF_PKG dependencies on AP_PAYMENT_SCHEDULES

Line 182: UPDATE AP_PAYMENT_SCHEDULES

178: JL_ZZ_AP_LIBRARY_1_PKG.Get_Penalty_Type(p_vendor_site_id, v_pnttyp, 1, errcode6);
179: -----------------------------------------------------
180: -- Update payment_schedules with these default values
181: -----------------------------------------------------
182: UPDATE AP_PAYMENT_SCHEDULES
183: SET GLOBAL_ATTRIBUTE1 = v_inttyp,
184: GLOBAL_ATTRIBUTE2 = v_intamt,
185: GLOBAL_ATTRIBUTE3 = v_intprd,
186: GLOBAL_ATTRIBUTE4 = v_intfml,

Line 216: -- Cursor on AP_PAYMENT_SCHEDULES

212: s_associate_flag Varchar2(1);
213: l_rec_count Number;
214: l_new_date_char Varchar2(30);
215: errcode1 Number;
216: -- Cursor on AP_PAYMENT_SCHEDULES
217: CURSOR Payments IS
218: SELECT due_date, discount_date, payment_num
219: FROM ap_payment_schedules
220: WHERE invoice_id = P_Invoice_ID;

Line 219: FROM ap_payment_schedules

215: errcode1 Number;
216: -- Cursor on AP_PAYMENT_SCHEDULES
217: CURSOR Payments IS
218: SELECT due_date, discount_date, payment_num
219: FROM ap_payment_schedules
220: WHERE invoice_id = P_Invoice_ID;
221: BEGIN
222: -------------------------------------------------------------------
223: -- Get Association Method from ap_system_parameters

Line 241: UPDATE ap_payment_schedules

237: IF l_new_date_char IS NOT NULL THEN
238: -----------------------------------------------------
239: -- Update AP_PAYMNET_SCHEDULES.due_date
240: -----------------------------------------------------
241: UPDATE ap_payment_schedules
242: SET due_date = to_date(l_new_date_char,'DD-MM-YYYY')
243: WHERE invoice_id = P_Invoice_ID
244: AND payment_num = db_reg.payment_num;
245: END IF;

Line 257: UPDATE ap_payment_schedules

253: IF l_new_date_char IS NOT NULL THEN
254: -----------------------------------------------------
255: -- Update AP_PAYMNET_SCHEDULES.discount_date
256: -----------------------------------------------------
257: UPDATE ap_payment_schedules
258: SET discount_date = to_date(l_new_date_char ,'DD-MM-YYYY')
259: WHERE invoice_id = P_Invoice_ID
260: AND payment_num = db_reg.payment_num ;
261: END IF;

Line 277: UPDATE ap_payment_schedules

273: s_bank_collection_id,
274: s_associate_flag
275: );
276: IF Upper(nvl(s_associate_flag,'N')) = 'Y' THEN
277: UPDATE ap_payment_schedules
278: SET global_attribute11 = s_bank_collection_id
279: WHERE invoice_id = P_Invoice_ID
280: AND payment_num = db_reg.payment_num;
281: END IF; -- if s_associate = 'Y'

Line 313: -- First fill the AP_Payment_Schedules GDF

309: INTO v_vndstid, l_invoice_type_lookup_code, s_colldoc_assoc
310: FROM ap_invoices
311: WHERE invoice_id = P_Invoice_ID;
312: ------------------------------------------------------------------------------------------
313: -- First fill the AP_Payment_Schedules GDF
314: ------------------------------------------------------------------------------------------
315: APXINWKB_BR_DEF_PS_SEGMENTS
316: ( P_Invoice_ID,
317: v_vndstid

Line 412: ,ap_payment_schedules_all ap

408: IS
409: Cursor Bank_Ref IS
410: Select jl.our_number
411: From jl_br_ap_collection_docs jl
412: ,ap_payment_schedules_all ap
413: ,iby_docs_payable_all iby
414: Where iby.document_payable_id = P_Doc_Payable_ID
415: And iby.calling_app_doc_unique_ref2 = ap.invoice_id
416: And iby.calling_app_doc_unique_ref3 = ap.payment_num