APPS.JL_BR_AR_GENERATE_DEBIT_MEMO dependencies on AR_PAYMENT_SCHEDULES

Line 335: FROM ar_payment_schedules

331: Memo transaction number */
332:
333: SELECT trx_number, terms_sequence_number
334: INTO X_trx_number, X_terms_sequence
335: FROM ar_payment_schedules
336: WHERE payment_schedule_id = X_payment_schedule_id;
337:
338: X_trx_number := X_trx_number||'-'||X_terms_sequence||'-NDJ'||X_next_sequence;
339: RETURN X_trx_number;

Line 856: /* Procedure ins_ar_payment_schedules */

852:
853: END ins_ra_cust_trx_line_gl_dist;
854:
855: /************************************************************************/
856: /* Procedure ins_ar_payment_schedules */
857: /* Purpose : Get the fields to insert into ar_payment_schedules */
858: /************************************************************************/
859: PROCEDURE ins_ar_payment_schedules (
860: X_user_id IN NUMBER,

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

853: END ins_ra_cust_trx_line_gl_dist;
854:
855: /************************************************************************/
856: /* Procedure ins_ar_payment_schedules */
857: /* Purpose : Get the fields to insert into ar_payment_schedules */
858: /************************************************************************/
859: PROCEDURE ins_ar_payment_schedules (
860: X_user_id IN NUMBER,
861: X_last_login IN NUMBER,

Line 859: PROCEDURE ins_ar_payment_schedules (

855: /************************************************************************/
856: /* Procedure ins_ar_payment_schedules */
857: /* Purpose : Get the fields to insert into ar_payment_schedules */
858: /************************************************************************/
859: PROCEDURE ins_ar_payment_schedules (
860: X_user_id IN NUMBER,
861: X_last_login IN NUMBER,
862: X_invoice_amount IN NUMBER,
863: X_invoice_currency_code IN VARCHAR2,

Line 874: l_ps_rec ar_payment_schedules%ROWTYPE;

870: X_idm_date IN DATE
871: ) IS
872: X_payment_scheduleid NUMBER(15);
873: l_org_id NUMBER(15);
874: l_ps_rec ar_payment_schedules%ROWTYPE;
875: X_due_date DATE;
876: BEGIN
877: SELECT ar_payment_schedules_s.nextval
878: INTO X_payment_scheduleid

Line 877: SELECT ar_payment_schedules_s.nextval

873: l_org_id NUMBER(15);
874: l_ps_rec ar_payment_schedules%ROWTYPE;
875: X_due_date DATE;
876: BEGIN
877: SELECT ar_payment_schedules_s.nextval
878: INTO X_payment_scheduleid
879: FROM sys.dual;
880:
881:

Line 882: /* INSERT INTO ar_payment_schedules (

878: INTO X_payment_scheduleid
879: FROM sys.dual;
880:
881:
882: /* INSERT INTO ar_payment_schedules (
883: payment_schedule_id,
884: last_update_date,
885: last_updated_by,
886: creation_date,

Line 987: END ins_ar_payment_schedules;

983: l_ps_rec.acctd_amount_due_remaining := X_invoice_amount;
984:
985: arp_ps_pkg.insert_p(l_ps_rec, X_payment_scheduleid);
986:
987: END ins_ar_payment_schedules;
988:
989: /************************************************************************/
990: /* Procedure sla_create_event */
991: /* Purpose : Call AR procedure to create SLA accounting */

Line 1145: jl_br_ar_generate_debit_memo.ins_ar_payment_schedules (

1141: x_error_msg,
1142: x_token
1143: );
1144:
1145: jl_br_ar_generate_debit_memo.ins_ar_payment_schedules (
1146: X_user_id,
1147: X_last_login,
1148: X_invoice_amount,
1149: X_invoice_currency_code,