1 PACKAGE jl_br_ar_generate_debit_memo AUTHID CURRENT_USER AS
2 /*$Header: jlbrrdms.pls 120.9.12010000.4 2010/04/20 10:44:06 mkandula 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_billto_site_use_id IN NUMBER, -- Bug#7718063
51 x_struct_num NUMBER,
52 x_error_code OUT NOCOPY NUMBER,
53 x_error_msg OUT NOCOPY VARCHAR2,
54 x_token OUT NOCOPY VARCHAR2
55 ) RETURN NUMBER;
56
57 PROCEDURE ins_ra_batches (
58 X_batch_source_id IN NUMBER,
59 X_invoice_amount IN NUMBER,
60 X_invoice_currency_code IN VARCHAR2,
61 X_user_id IN NUMBER,
62 X_batch_id IN OUT NOCOPY NUMBER
63 );
64
65 FUNCTION generate_interest_DM_number(
66 X_original_customer_trx_id NUMBER,
67 X_payment_schedule_id NUMBER
68 ) RETURN VARCHAR2;
69
70 PROCEDURE ins_ra_customer_trx (
71 X_inv_cust_trx_id IN NUMBER,
72 X_new_cust_trx_id IN OUT NOCOPY NUMBER,
73 X_set_of_books_id IN OUT NOCOPY NUMBER,
74 X_lastlogin IN OUT NOCOPY NUMBER,
75 X_primary_salesrep_id IN OUT NOCOPY NUMBER,
76 X_billto_customer_id IN OUT NOCOPY NUMBER,
77 X_billto_site_use_id IN OUT NOCOPY NUMBER,
78 X_invoice_currencycode IN OUT NOCOPY VARCHAR2,
79 X_trx_number IN OUT NOCOPY VARCHAR2,
80 X_termid IN OUT NOCOPY NUMBER,
81 X_legal_entity_id IN OUT NOCOPY NUMBER, -- Bug#7835709
82 X_cust_trx_type_id IN NUMBER,
83 X_payment_schedule_id IN NUMBER,
84 X_user_id IN NUMBER,
85 X_batch_source_id IN NUMBER,
86 X_receipt_method_id IN NUMBER,
87 X_batch_id IN NUMBER,
88 X_idm_date IN DATE
89 );
90
91 PROCEDURE ins_ra_customer_trx_lines (
92 X_new_customer_trx_id IN NUMBER,
93 X_invoice_amount IN NUMBER,
94 X_set_of_books_id IN NUMBER,
95 X_user_id IN NUMBER,
96 X_last_login IN NUMBER,
97 X_customertrx_line_id IN OUT NOCOPY NUMBER
98 );
99
100 PROCEDURE ins_ra_cust_trx_line_salesreps (
101 X_new_cust_trx_id IN NUMBER,
102 X_new_cust_trx_line_id IN NUMBER,
103 X_salesrep_id IN NUMBER,
104 X_user_id IN NUMBER,
105 X_last_login IN NUMBER,
106 X_invoice_amount IN NUMBER
107 );
108
109 PROCEDURE ins_ra_cust_trx_line_gl_dist (
110 X_customer_trx_id IN NUMBER,
111 X_customer_trx_line_id IN OUT NOCOPY NUMBER,
112 X_invoice_amount IN NUMBER,
113 X_set_of_books_id IN NUMBER,
114 X_user_id IN NUMBER,
115 X_batch_source_id IN NUMBER,
116 X_last_login IN NUMBER,
117 X_cust_trx_type_id IN NUMBER,
118 X_billto_site_use_id IN NUMBER, -- Bug#7718063
119 X_salesrep_id IN NUMBER,
120 X_account_type IN VARCHAR,
121 X_idm_date IN DATE,
122 x_int_revenue_ccid IN NUMBER,
123 X_invoice_currency_code IN VARCHAR2,
124 X_minimum_accountable_unit IN NUMBER,
125 X_precision IN NUMBER,
126 x_error_code OUT NOCOPY NUMBER,
127 X_error_msg OUT NOCOPY VARCHAR2,
128 x_token OUT NOCOPY VARCHAR2
129 );
130
131 PROCEDURE ins_ar_payment_schedules (
132 X_user_id IN NUMBER,
133 X_last_login IN NUMBER,
134 X_invoice_amount IN NUMBER,
135 X_invoice_currency_code IN VARCHAR2,
136 X_cust_trx_type_id IN NUMBER,
137 X_customer_id IN NUMBER,
138 X_customer_site_use_id IN NUMBER,
139 X_customer_trx_id IN NUMBER,
140 X_term_id IN NUMBER,
141 X_trx_number IN VARCHAR2,
142 X_idm_date IN DATE
143 );
144
145 PROCEDURE sla_create_event (
146 X_customer_trx_id IN NUMBER
147 );
148
149 FUNCTION validate_and_default_gl_date(
150 x_receipt_date IN DATE,
151 x_set_of_books_id IN NUMBER,
152 x_application_id IN NUMBER,
153 x_default_gl_date OUT NOCOPY DATE,
154 x_def_rule OUT NOCOPY VARCHAR2,
155 x_error_msg OUT NOCOPY VARCHAR2) RETURN BOOLEAN ;
156
157
158 END jl_br_ar_generate_debit_memo;