1 PACKAGE ar_deposit_lib_pvt AUTHID CURRENT_USER AS
2 /* $Header: ARXDEPLS.pls 115.6 2003/08/27 01:04:07 anukumar noship $ */
3 --These package variables contain the profile option values.
4
5 pg_profile_batch_source NUMBER;
6 pg_profile_trxln_excpt_flag VARCHAR2(240);
7 pg_profile_doc_seq VARCHAR2(240);
8 pg_profile_enable_cc VARCHAR2(240);
9 pg_profile_cc_rate_type VARCHAR2(240);
10 pg_profile_dsp_inv_rate VARCHAR2(240);
11 pg_profile_def_x_rate_type VARCHAR2(240);
12 pg_deposit_date date;
13
14 --*** to get the Id' based on value and entity
15 FUNCTION Get_Id( p_entity IN VARCHAR2,
16 p_value IN VARCHAR2,
17 p_return_status OUT NOCOPY VARCHAR2
18 )
19 RETURN VARCHAR2 ;
20
21
22 FUNCTION Get_Ship_Via( p_bill_to_customer_id IN NUMBER,
23 p_bill_to_location IN VARCHAR2,
24 p_ship_to_customer_id IN NUMBER,
25 p_ship_to_location IN VARCHAR2,
26 p_return_status OUT NOCOPY VARCHAR2
27 )
28 RETURN VARCHAR2 ;
29
30 FUNCTION Get_FOB_POINT( p_bill_to_customer_id IN NUMBER,
31 p_bill_to_location IN VARCHAR2,
32 p_ship_to_customer_id IN NUMBER,
33 p_ship_to_location IN VARCHAR2,
34 p_return_status OUT NOCOPY VARCHAR2
35 )
36 RETURN VARCHAR2;
37
38 FUNCTION Get_Territory_id(p_bill_to_customer_id IN NUMBER,
39 p_bill_to_location IN VARCHAR2,
40 p_ship_to_customer_id IN NUMBER,
41 p_ship_to_location IN VARCHAR2,
42 p_salesrep_id IN NUMBER,
43 p_deposit_date IN Date ,
44 p_return_status OUT NOCOPY VARCHAR2
45 )
46 RETURN NUMBER;
47
48 FUNCTION Get_Cross_Validated_Id( p_entity IN VARCHAR2,
49 p_number_value IN VARCHAR2,
50 p_name_value IN VARCHAR2,
51 p_return_status OUT NOCOPY VARCHAR2
52 )
53 RETURN VARCHAR2 ;
54
55 FUNCTION GET_CONTACT_ID( p_customer_id IN NUMBER,
56 p_person_first_name IN VARCHAR2,
57 p_person_last_name IN VARCHAR2,
58 p_return_status OUT NOCOPY VARCHAR2
59 )
60 RETURN VARCHAR2 ;
61
62
63 FUNCTION Get_Site_Use_Id(
64 p_customer_id IN hz_cust_acct_sites.cust_account_id%TYPE,
65 p_location IN hz_cust_site_uses.location%TYPE,
66 p_site_use_code1 IN hz_cust_site_uses.site_use_code%TYPE DEFAULT NULL,
67 p_site_use_code2 IN hz_cust_site_uses.site_use_code%TYPE DEFAULT NULL,
68 p_return_status OUT NOCOPY VARCHAR2)
69 RETURN hz_cust_site_uses.site_use_id%type ;
70
71 PROCEDURE Default_deposit_ids(
72 x_salesrep_id IN OUT NOCOPY NUMBER,
73 p_salesrep_name IN VARCHAR2 DEFAULT NULL,
74 x_term_id IN OUT NOCOPY NUMBER ,
75 p_term_name IN VARCHAR2 DEFAULT NULL,
76 x_batch_source_id IN OUT NOCOPY NUMBER,
77 p_batch_source_name IN ra_batch_sources.name%type,
78 x_cust_trx_type_id IN OUT NOCOPY NUMBER,
79 p_cust_trx_type IN varchar2,
80 x_bill_to_customer_id IN OUT NOCOPY NUMBER,
81 x_bill_to_customer_site_use_id IN OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
82 p_bill_to_customer_name IN hz_parties.party_name%TYPE,
83 p_bill_to_customer_number IN
84 hz_cust_accounts.account_number%TYPE,
85 p_bill_to_location IN OUT NOCOPY hz_cust_site_uses.location%type,
86 x_bill_to_contact_id IN OUT NOCOPY NUMBER,
87 p_bill_to_contact_first_name IN VARCHAR2,
88 p_bill_to_contact_last_name IN VARCHAR2,
89 x_ship_to_customer_id IN OUT NOCOPY NUMBER,
90 x_ship_to_customer_site_use_id IN OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
91 p_ship_to_customer_name IN hz_parties.party_name%TYPE,
92 p_ship_to_customer_number IN
93 hz_cust_accounts.account_number%TYPE,
94 p_ship_to_location IN OUT NOCOPY hz_cust_site_uses.location%type,
95 x_ship_to_contact_id IN OUT NOCOPY NUMBER,
96 p_ship_to_contact_first_name IN VARCHAR2,
97 p_ship_to_contact_last_name IN VARCHAR2,
98 p_usr_currency_code IN fnd_currencies_vl.name%TYPE,
99 p_usr_exchange_rate_type IN
100 gl_daily_conversion_types.user_conversion_type%TYPE,
101 x_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,
102 x_exchange_rate_type IN OUT NOCOPY
103 ar_cash_receipts.exchange_rate_type%TYPE,
104 x_remit_to_address_id IN OUT NOCOPY NUMBER ,
105 p_cust_location_site_num IN VARCHAR2,
106 x_sold_to_customer_id IN OUT NOCOPY NUMBER,
107 p_sold_to_customer_name IN VARCHAR2,
108 p_sold_to_customer_number IN VARCHAR2,
109 x_paying_customer_id IN OUT NOCOPY NUMBER ,
110 x_paying_customer_site_use_id IN OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
111 p_paying_customer_name IN VARCHAR2,
112 p_paying_customer_number IN VARCHAR2,
113 p_paying_location IN VARCHAR2,
114 x_receipt_method_id IN OUT NOCOPY NUMBER ,
115 p_receipt_method_name IN OUT NOCOPY VARCHAR2,
116 x_cust_bank_account_id IN OUT NOCOPY NUMBER,
117 p_cust_bank_account_name IN VARCHAR2,
118 p_cust_bank_account_number IN VARCHAR2,
119 x_memo_line_id IN OUT NOCOPY NUMBER,
120 p_memo_line_name IN VARCHAR2,
121 x_inventory_id IN OUT NOCOPY NUMBER,
122 p_deposit_number IN VARCHAR2,
123 p_deposit_date IN DATE,
124 p_return_status OUT NOCOPY VARCHAR2
125 );
126
127
128 PROCEDURE Get_deposit_Defaults(
129 p_currency_code IN OUT NOCOPY
130 ra_customer_trx.invoice_currency_code%TYPE,
131 p_exchange_rate_type IN OUT NOCOPY
132 ra_customer_trx.exchange_rate_type%TYPE,
133 p_exchange_rate IN OUT NOCOPY ra_customer_trx.exchange_rate%TYPE,
134 p_exchange_rate_date IN OUT NOCOPY ra_customer_trx.exchange_date%TYPE,
135 p_start_date_commitmenmt IN OUT NOCOPY DATE,
136 p_end_date_commitmenmt IN OUT NOCOPY DATE,
137 p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,
138 p_deposit_date IN OUT NOCOPY DATE,
139 p_gl_date IN OUT NOCOPY DATE,
140 p_bill_to_customer_id IN NUMBER,
141 p_bill_to_site_use_id IN NUMBER,
142 p_ship_to_customer_id IN NUMBER,
143 p_ship_to_site_use_id IN NUMBER,
144 p_salesrep_id OUT NOCOPY NUMBER,
145 p_bill_to_contact_id OUT NOCOPY NUMBER,
146 p_called_from IN VARCHAR2,
147 p_return_status OUT NOCOPY VARCHAR2
148 );
149
150 PROCEDURE get_doc_seq(p_application_id IN NUMBER,
151 p_document_name IN VARCHAR2,
152 p_sob_id IN NUMBER,
153 p_met_code IN CHAR,
154 p_trx_date IN DATE,
155 p_doc_sequence_value IN OUT NOCOPY NUMBER,
156 p_doc_sequence_id OUT NOCOPY NUMBER,
157 p_return_status OUT NOCOPY VARCHAR2
158 );
159
160 PROCEDURE Validate_Desc_Flexfield(
161 p_desc_flex_rec IN OUT NOCOPY ar_deposit_api_pub.attr_rec_type,
162 p_desc_flex_name IN VARCHAR2,
163 p_return_status IN OUT NOCOPY varchar2
164 );
165 END ar_deposit_lib_pvt;