[Home] [Help]
PACKAGE: APPS.FUN_NET_ARAP_PKG
Source
1 PACKAGE FUN_NET_ARAP_PKG AUTHID CURRENT_USER AS
2 /* $Header: funnttxs.pls 120.8.12010000.3 2009/04/18 07:17:32 ychandra ship $ */
3
4 PROCEDURE get_functional_currency;
5
6 FUNCTION get_batch_details RETURN BOOLEAN;
7
8 FUNCTION get_agreement_details RETURN BOOLEAN;
9
10 FUNCTION update_batch_status(p_status VARCHAR2) RETURN BOOLEAN;
11
12 FUNCTION prepare_ar_transactions RETURN BOOLEAN;
13
14 FUNCTION prepare_ap_transactions RETURN BOOLEAN;
15
16 PROCEDURE insert_transactions(p_inv_cur VARCHAR2,
17 p_currency_code VARCHAR2,
18 p_appln VARCHAR2);
19
20 PROCEDURE calculate_AP_AR_balances(p_amt_to_net OUT NOCOPY NUMBER,
21 p_status_flag OUT NOCOPY VARCHAR2);
22
23 PROCEDURE validate_AP_AR_balances(p_ar_bal OUT NOCOPY NUMBER,
24 p_ap_bal OUT NOCOPY NUMBER,
25 p_status_flag OUT NOCOPY VARCHAR2);
26
27 PROCEDURE insert_batch_record(p_currency_code VARCHAR2);
28
29 FUNCTION batch_exists(p_currency_code VARCHAR2) RETURN BOOLEAN;
30
31 PROCEDURE update_net_balances(p_sql_stmt VARCHAR2,
32 p_amt_to_net NUMBER,
33 p_appln VARCHAR2);
34
35 PROCEDURE Update_Net_Amounts(p_batch_id NUMBER,
36 p_amt_to_net NUMBER,
37 p_appln VARCHAR2);
38
39 PROCEDURE create_net_batch(
40 -- ***** Standard API Parameters *****
41 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
42 p_commit IN VARCHAR2 := FND_API.G_FALSE,
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2,
46
47 -- ***** Netting batch input parameters *****
48 p_batch_id IN NUMBER);
49
50 PROCEDURE submit_net_batch (
51 -- ***** Standard API Parameters *****
52 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
53 p_commit IN VARCHAR2 := FND_API.G_FALSE,
54 x_return_status OUT NOCOPY VARCHAR2,
55 x_msg_count OUT NOCOPY NUMBER,
56 x_msg_data OUT NOCOPY VARCHAR2,
57 -- ***** Netting batch input parameters *****
58 p_batch_id IN NUMBER);
59
60 FUNCTION Validate_Netting_Dates(
61 -- ***** Standard API Parameters *****
62 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
63 p_commit IN VARCHAR2 := FND_API.G_FALSE,
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_msg_count OUT NOCOPY NUMBER,
66 x_msg_data OUT NOCOPY VARCHAR2,
67 -- ***** Netting batch input parameters *****
68 p_batch_id IN NUMBER,
69 p_net_settle_date IN DATE,
70 p_response_date IN DATE) RETURN VARCHAR2;
71
72 PROCEDURE settle_ap_invs(
73 p_bank_acct_use_id IN ce_bank_acct_uses_all.bank_acct_use_id%TYPE,
74 p_bank_acct_name IN ce_bank_accounts.bank_account_name%TYPE,
75 p_bank_acct_num IN ce_bank_accounts.bank_account_num%TYPE,
76 p_le_id IN xle_entity_profiles.legal_entity_id%TYPE,
77 p_bank_num IN ce_banks_v.bank_number%TYPE,
78 x_return_status OUT NOCOPY VARCHAR2);
79
80 FUNCTION Calculate_AR_Txn_Open_Amt(
81 p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
82 p_inv_currency_code IN ra_customer_trx.invoice_currency_code%TYPE,
83 p_exchange_rate IN ra_customer_trx.exchange_rate%TYPE)
84 RETURN NUMBER;
85
86 PROCEDURE settle_net_batch (
87 -- ***** Standard API Parameters *****
88 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
89 p_commit IN VARCHAR2 := FND_API.G_FALSE,
90 x_return_status OUT NOCOPY VARCHAR2,
91 x_msg_count OUT NOCOPY NUMBER,
92 x_msg_data OUT NOCOPY VARCHAR2,
93 -- ***** Netting batch input parameters *****
94 p_batch_id IN NUMBER);
95
96 PROCEDURE Get_Netting_Bank_Details(
97 p_bank_acct_use_id OUT NOCOPY NUMBER,
98 p_bank_acct_name OUT NOCOPY VARCHAR2,
99 p_bank_acct_num OUT NOCOPY ce_bank_accounts.bank_account_num%TYPE,
100 p_le_id OUT NOCOPY NUMBER,
101 p_bank_num OUT NOCOPY VARCHAR2,
102 p_return_status OUT NOCOPY VARCHAR2);
103
104 PROCEDURE Get_Customer_Details (
105 p_cust_acct_id OUT NOCOPY NUMBER,
106 p_cust_site_use_id OUT NOCOPY NUMBER,
107 p_return_status OUT NOCOPY VARCHAR2);
108
109
110 FUNCTION Derive_Net_Exchg_Rate(
111 x_from_currency IN VARCHAR2,
112 x_to_currency IN VARCHAR2)
113 RETURN NUMBER;
114
115 FUNCTION Derive_Conv_Amt(
116 p_batch_id NUMBER,
117 p_trx_id NUMBER,
118 p_amount NUMBER,
119 ap_ar VARCHAR2)
120 RETURN NUMBER;
121
122
123 FUNCTION calculate_ar_trx_amt(
124 p_customer_trx_id NUMBER)
125 RETURN NUMBER;
126
127 PROCEDURE unlock_ap_pymt_schedules(
128 p_batch_id IN fun_net_batches.batch_id%TYPE,
129 x_return_status OUT NOCOPY VARCHAR2);
130
131 PROCEDURE Set_Agreement_Status(
132 x_batch_id IN fun_net_batches.batch_id%TYPE,
133 x_agreement_id IN fun_net_agreements.agreement_id%TYPE,
134 x_mode IN VARCHAR2,
135 x_return_status OUT NOCOPY VARCHAR2);
136
137 PROCEDURE Validate_Settlement_Period(
138 x_appln_id IN fnd_application.application_id%TYPE,
139 x_period_name OUT NOCOPY VARCHAR2,
140 x_return_status OUT NOCOPY VARCHAR2,
141 x_return_msg OUT NOCOPY VARCHAR2);
142
143 FUNCTION get_ap_discount(
144 p_batch_id NUMBER,
145 p_invoice_id NUMBER,
146 p_amt_to_net NUMBER,
147 p_txn_due_date DATE
148 ) RETURN NUMBER;
149
150 FUNCTION get_ar_discount(
151 p_batch_id NUMBER,
152 p_cust_txn_id NUMBER,
153 p_amt_to_net NUMBER,
154 p_txn_due_date DATE
155 ) RETURN NUMBER;
156
157 FUNCTION get_esd_flag(
158 p_batch_id NUMBER
159 ) RETURN VARCHAR2;
160
161 END FUN_NET_ARAP_PKG; -- Package spec