APPS.JL_BR_AR_GENERATE_DEBIT_MEMO dependencies on AR_PAYMENT_SCHEDULES

Line 362: FROM ar_payment_schedules

358: Memo transaction number */
359:
360: SELECT trx_number, terms_sequence_number
361: INTO X_trx_number, X_terms_sequence
362: FROM ar_payment_schedules
363: WHERE payment_schedule_id = X_payment_schedule_id;
364:
365: X_trx_number := X_trx_number||'-'||X_terms_sequence||'-NDJ'||X_next_sequence;
366: RETURN X_trx_number;

Line 895: /* Procedure ins_ar_payment_schedules */

891:
892: END ins_ra_cust_trx_line_gl_dist;
893:
894: /************************************************************************/
895: /* Procedure ins_ar_payment_schedules */
896: /* Purpose : Get the fields to insert into ar_payment_schedules */
897: /************************************************************************/
898: PROCEDURE ins_ar_payment_schedules (
899: X_user_id IN NUMBER,

Line 896: /* Purpose : Get the fields to insert into ar_payment_schedules */

892: END ins_ra_cust_trx_line_gl_dist;
893:
894: /************************************************************************/
895: /* Procedure ins_ar_payment_schedules */
896: /* Purpose : Get the fields to insert into ar_payment_schedules */
897: /************************************************************************/
898: PROCEDURE ins_ar_payment_schedules (
899: X_user_id IN NUMBER,
900: X_last_login IN NUMBER,

Line 898: PROCEDURE ins_ar_payment_schedules (

894: /************************************************************************/
895: /* Procedure ins_ar_payment_schedules */
896: /* Purpose : Get the fields to insert into ar_payment_schedules */
897: /************************************************************************/
898: PROCEDURE ins_ar_payment_schedules (
899: X_user_id IN NUMBER,
900: X_last_login IN NUMBER,
901: X_invoice_amount IN NUMBER,
902: X_invoice_currency_code IN VARCHAR2,

Line 913: l_ps_rec ar_payment_schedules%ROWTYPE;

909: X_idm_date IN DATE
910: ) IS
911: X_payment_scheduleid NUMBER(15);
912: l_org_id NUMBER(15);
913: l_ps_rec ar_payment_schedules%ROWTYPE;
914: X_due_date DATE;
915: BEGIN
916: SELECT ar_payment_schedules_s.nextval
917: INTO X_payment_scheduleid

Line 916: SELECT ar_payment_schedules_s.nextval

912: l_org_id NUMBER(15);
913: l_ps_rec ar_payment_schedules%ROWTYPE;
914: X_due_date DATE;
915: BEGIN
916: SELECT ar_payment_schedules_s.nextval
917: INTO X_payment_scheduleid
918: FROM sys.dual;
919:
920:

Line 921: /* INSERT INTO ar_payment_schedules (

917: INTO X_payment_scheduleid
918: FROM sys.dual;
919:
920:
921: /* INSERT INTO ar_payment_schedules (
922: payment_schedule_id,
923: last_update_date,
924: last_updated_by,
925: creation_date,

Line 1026: END ins_ar_payment_schedules;

1022: l_ps_rec.acctd_amount_due_remaining := X_invoice_amount;
1023:
1024: arp_ps_pkg.insert_p(l_ps_rec, X_payment_scheduleid);
1025:
1026: END ins_ar_payment_schedules;
1027:
1028: /************************************************************************/
1029: /* Procedure sla_create_event */
1030: /* Purpose : Call AR procedure to create SLA accounting */

Line 1188: jl_br_ar_generate_debit_memo.ins_ar_payment_schedules (

1184: x_error_msg,
1185: x_token
1186: );
1187:
1188: jl_br_ar_generate_debit_memo.ins_ar_payment_schedules (
1189: X_user_id,
1190: X_last_login,
1191: X_invoice_amount,
1192: X_invoice_currency_code,