[Home] [Help]
PACKAGE: APPS.FUN_NET_ARAP_PKG
Source
1 PACKAGE FUN_NET_ARAP_PKG AS
2 /* $Header: funnttxs.pls 120.8 2006/01/06 12:23:23 vgadde noship $ */
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 calculate_ar_trx_amt(
116 p_customer_trx_id NUMBER)
117 RETURN NUMBER;
118
119 PROCEDURE unlock_ap_pymt_schedules(
120 p_batch_id IN fun_net_batches.batch_id%TYPE,
121 x_return_status OUT NOCOPY VARCHAR2);
122
123 PROCEDURE Set_Agreement_Status(
124 x_batch_id IN fun_net_batches.batch_id%TYPE,
125 x_agreement_id IN fun_net_agreements.agreement_id%TYPE,
126 x_mode IN VARCHAR2,
127 x_return_status OUT NOCOPY VARCHAR2);
128
129 PROCEDURE Validate_Settlement_Period(
130 x_appln_id IN fnd_application.application_id%TYPE,
131 x_period_name OUT NOCOPY VARCHAR2,
132 x_return_status OUT NOCOPY VARCHAR2,
133 x_return_msg OUT NOCOPY VARCHAR2);
134
135 END FUN_NET_ARAP_PKG; -- Package spec