[Home] [Help]
PACKAGE: APPS.HZP_CUST_PKG
Source
1 PACKAGE hzp_cust_pkg as
2 /* $Header: ARHCUSTS.pls 120.5 2005/06/16 21:10:16 jhuang ship $*/
3 --
4 --
5 procedure check_unique_customer_name(p_rowid in varchar2,
6 p_customer_name in varchar2,
7 p_warning_flag in out NOCOPY varchar2
8 );
9 --
10 --
11 procedure check_unique_customer_number(p_rowid in varchar2,
12 p_customer_number in varchar2
13 );
14 procedure check_unique_party_number(p_rowid in varchar2,
15 p_party_number in varchar2
16 );
17 --
18 --
19 procedure check_unique_orig_system_ref(p_rowid in varchar2,
20 p_orig_system_reference in varchar2
21 );
22 --
23 --
24 procedure delete_customer_alt_names(p_rowid in varchar2,
25 p_status in varchar2,
26 p_customer_id in number
27 );
28 --
29 --
30 FUNCTION get_statement_site (
31 p_customer_id IN hz_cust_accounts.cust_account_id%type
32 ) RETURN NUMBER;
33
34 --
35 --
36
37 FUNCTION get_dunning_site (
38 p_customer_id IN hz_cust_accounts.cust_account_id%type
39 ) RETURN NUMBER;
40
41 --
42 --
43 FUNCTION get_current_dunning_type (
44 p_customer_id in hz_cust_accounts.cust_account_id%type,
45 p_bill_to_site_id in NUMBER DEFAULT NULL
46 ) RETURN VARCHAR2;
47
48 --
49 FUNCTION arxvamai_overall_cr_limit ( p_customer_id NUMBER,
50 p_currency_code VARCHAR2,
51 p_customer_site_use_id NUMBER
52 ) RETURN NUMBER;
53
54 --
55 FUNCTION arxvamai_order_cr_limit ( p_customer_id NUMBER,
56 p_currency_code VARCHAR2,
57 p_customer_site_use_id NUMBER
58 ) RETURN NUMBER;
59
60 --
61 TYPE id_tab IS TABLE OF hz_cust_site_uses.site_use_id%type INDEX BY BINARY_INTEGER;
62 g_site_use_id_tab id_tab;
63 --
64 FUNCTION get_primary_billto_site (
65 p_customer_id IN hz_cust_accounts.cust_account_id%type
66 ) RETURN NUMBER;
67 --
68
69 end;