1 PACKAGE jl_br_ar_generate_debit_memo AS
2 /*$Header: jlbrrdms.pls 120.9.12010000.1 2008/07/31 04:22:55 appldev ship $*/
3
4 /*===========================================================================
5 PACKAGE NAME: JL_BR_INT_DEB_MEMO_SV
6
7 DESCRIPTION: This package contains the server side Line level
8 Application Program Interfaces (APIs).
9
10 CLIENT/SERVER: Server
11
12 OWNER: Ana Claudia Cardoso
13
14 FUNCTION/PROCEDURE: jl_br_interest_debit_memo()
15 get_account()
16 ins_ra_batches ()
17 generate_interest_DM_number()
18 ins_ra_customer_trx ()
19 ins_ra_customer_trx_lines ()
20 ins_ra_cust_trx_line_salesreps ()
21 ins_ra_cust_trx_line_gl_dist ()
22 ins_ar_payment_schedules ()
23
24 12-MAR-2004 Included additional parameters as a part of Bug Fix
25 3493840....
26 20-JUN-2005 New procedure sla_create_event (SLA KI - bug 4301543)
27 ===========================================================================*/
28
29 PROCEDURE jl_br_interest_debit_memo (
30 X_original_customer_trx_id IN NUMBER,
31 X_invoice_amount IN NUMBER,
32 X_user_id IN NUMBER,
33 X_cust_trx_type_id IN NUMBER,
34 X_batch_source_id IN NUMBER,
35 X_receipt_method_id IN NUMBER,
36 X_payment_schedule_id IN NUMBER,
37 X_interest_date IN VARCHAR2,
38 X_exit OUT NOCOPY VARCHAR2,
39 x_int_revenue_ccid IN NUMBER,
40 x_error_code OUT NOCOPY NUMBER,
41 X_error_msg OUT NOCOPY VARCHAR2,
42 x_token OUT NOCOPY VARCHAR2
43 );
44
45 FUNCTION get_account(
46 X_account_type VARCHAR2,
47 X_cust_trx_type_id NUMBER,
48 X_salesrep_id NUMBER,
49 x_int_revenue_ccid NUMBER,
50 x_struct_num NUMBER,
51 x_error_code OUT NOCOPY NUMBER,
52 x_error_msg OUT NOCOPY VARCHAR2,
53 x_token OUT NOCOPY VARCHAR2
54 ) RETURN NUMBER;
55
56 PROCEDURE ins_ra_batches (
57 X_batch_source_id IN NUMBER,
58 X_invoice_amount IN NUMBER,
59 X_invoice_currency_code IN VARCHAR2,
60 X_user_id IN NUMBER,
61 X_batch_id IN OUT NOCOPY NUMBER
62 );
63
64 FUNCTION generate_interest_DM_number(
65 X_original_customer_trx_id NUMBER,
66 X_payment_schedule_id NUMBER
67 ) RETURN VARCHAR2;
68
69 PROCEDURE ins_ra_customer_trx (
70 X_inv_cust_trx_id IN NUMBER,
71 X_new_cust_trx_id IN OUT NOCOPY NUMBER,
72 X_set_of_books_id IN OUT NOCOPY NUMBER,
73 X_lastlogin IN OUT NOCOPY NUMBER,
74 X_primary_salesrep_id IN OUT NOCOPY NUMBER,
75 X_billto_customer_id IN OUT NOCOPY NUMBER,
76 X_billto_site_use_id IN OUT NOCOPY NUMBER,
77 X_invoice_currencycode IN OUT NOCOPY VARCHAR2,
78 X_trx_number IN OUT NOCOPY VARCHAR2,
79 X_termid IN OUT NOCOPY NUMBER,
80 X_cust_trx_type_id IN NUMBER,
81 X_payment_schedule_id IN NUMBER,
82 X_user_id IN NUMBER,
83 X_batch_source_id IN NUMBER,
84 X_receipt_method_id IN NUMBER,
85 X_batch_id IN NUMBER,
86 X_idm_date IN DATE
87 );
88
89 PROCEDURE ins_ra_customer_trx_lines (
90 X_new_customer_trx_id IN NUMBER,
91 X_invoice_amount IN NUMBER,
92 X_set_of_books_id IN NUMBER,
93 X_user_id IN NUMBER,
94 X_last_login IN NUMBER,
95 X_customertrx_line_id IN OUT NOCOPY NUMBER
96 );
97
98 PROCEDURE ins_ra_cust_trx_line_salesreps (
99 X_new_cust_trx_id IN NUMBER,
100 X_new_cust_trx_line_id IN NUMBER,
101 X_salesrep_id IN NUMBER,
102 X_user_id IN NUMBER,
103 X_last_login IN NUMBER,
104 X_invoice_amount IN NUMBER
105 );
106
107 PROCEDURE ins_ra_cust_trx_line_gl_dist (
108 X_customer_trx_id IN NUMBER,
109 X_customer_trx_line_id IN OUT NOCOPY NUMBER,
110 X_invoice_amount IN NUMBER,
111 X_set_of_books_id IN NUMBER,
112 X_user_id IN NUMBER,
113 X_batch_source_id IN NUMBER,
114 X_last_login IN NUMBER,
115 X_cust_trx_type_id IN NUMBER,
116 X_salesrep_id IN NUMBER,
117 X_account_type IN VARCHAR,
118 X_idm_date IN DATE,
119 x_int_revenue_ccid IN NUMBER,
120 X_invoice_currency_code IN VARCHAR2,
121 X_minimum_accountable_unit IN NUMBER,
122 X_precision IN NUMBER,
123 x_error_code OUT NOCOPY NUMBER,
124 X_error_msg OUT NOCOPY VARCHAR2,
125 x_token OUT NOCOPY VARCHAR2
126 );
127
128 PROCEDURE ins_ar_payment_schedules (
129 X_user_id IN NUMBER,
130 X_last_login IN NUMBER,
131 X_invoice_amount IN NUMBER,
132 X_invoice_currency_code IN VARCHAR2,
133 X_cust_trx_type_id IN NUMBER,
134 X_customer_id IN NUMBER,
135 X_customer_site_use_id IN NUMBER,
136 X_customer_trx_id IN NUMBER,
137 X_term_id IN NUMBER,
138 X_trx_number IN VARCHAR2,
139 X_idm_date IN DATE
140 );
141
142 PROCEDURE sla_create_event (
143 X_customer_trx_id IN NUMBER
144 );
145
146 END jl_br_ar_generate_debit_memo;