1 PACKAGE hz_customer_int AS
2 /*$Header: ARHCUSIS.pls 120.9 2006/01/09 15:33:58 nkanbapu ship $*/
3
4 FUNCTION get_cust_account_id(p_orig_system_customer_ref IN VARCHAR2)
5 RETURN NUMBER;
6 /* bug 4454799 - added argument for org_id below. */
7 FUNCTION get_cust_acct_site_id(p_orig_system_address_ref IN VARCHAR2,p_org_id IN NUMBER)
8 RETURN NUMBER;
9 FUNCTION get_cust_account_role_id(p_orig_system_contact_ref IN VARCHAR2)
10 RETURN NUMBER;
11 FUNCTION get_prel_party_id(p_orig_system_contact_ref IN VARCHAR2)
12 RETURN NUMBER;
13 /* bug 4454799 - added argument for org_id below. */
14 FUNCTION get_party_site_id(p_orig_system_address_ref IN VARCHAR2,p_org_id IN NUMBER)
15 RETURN NUMBER;
16 FUNCTION get_party_id(p_orig_system_customer_ref IN VARCHAR2) RETURN NUMBER;
17 FUNCTION validate_contact_ref(p_orig_system_contact_ref IN VARCHAR2)
18 RETURN VARCHAR2;
19 FUNCTION get_language_code(p_language IN VARCHAR2) RETURN VARCHAR2;
20 PROCEDURE validate_ccid(p_request_id NUMBER);
21 FUNCTION validate_ref_party(p_orig_system_customer_ref IN VARCHAR2,
22 p_insert_update_flag IN VARCHAR2)
23 RETURN VARCHAR2;
24 FUNCTION get_cust_party_id(p_orig_system_customer_ref IN VARCHAR2,
25 p_request_id IN NUMBER)
26 RETURN NUMBER;
27 FUNCTION get_subject_id(p_orig_system_contact_ref IN VARCHAR2,
28 p_request_id IN NUMBER)
29 RETURN NUMBER;
30 FUNCTION get_prel_party_id(p_orig_system_contact_ref IN VARCHAR2,
31 p_request_id IN NUMBER)
32 RETURN NUMBER;
33 FUNCTION get_prel_id(p_orig_system_contact_ref IN VARCHAR2,
34 p_request_id IN NUMBER)
35 RETURN NUMBER;
36 /* bug 4454799 - added argument for org_id below. */
37 FUNCTION val_bill_to_orig_address_ref(p_orig_system_customer_ref IN VARCHAR2,
38 p_orig_system_address_ref IN VARCHAR2,
39 p_bill_to_orig_address_ref IN VARCHAR2,
40 p_orig_system_parent_ref IN VARCHAR2,
41 p_org_id IN NUMBER,
42 req_id IN NUMBER) RETURN VARCHAR2;
43
44 FUNCTION val_party_number(p_orig_system_customer_ref IN VARCHAR2,
45 p_orig_system_party_ref IN VARCHAR2,
46 p_party_number IN VARCHAR2,
47 p_rowid IN ROWID,
48 req_id IN NUMBER) RETURN VARCHAR2;
49
50 FUNCTION val_party_numb_ref(p_orig_system_customer_ref IN VARCHAR2,
51 p_orig_system_party_ref IN VARCHAR2,
52 p_party_number IN VARCHAR2,
53 p_rowid IN ROWID,
54 req_id IN NUMBER) RETURN VARCHAR2;
55
56 FUNCTION val_cust_number(p_orig_system_customer_ref IN VARCHAR2,
57 p_customer_number IN VARCHAR2,
58 p_rowid IN ROWID,
59 req_id IN NUMBER) RETURN VARCHAR2;
60
61 /* bug 4454799 - added argument for org_id below. */
62 FUNCTION val_party_site_number(p_orig_system_address_ref IN VARCHAR2,
63 p_party_site_number IN VARCHAR2,
64 p_rowid IN ROWID,
65 p_org_id IN NUMBER,
66 req_id IN NUMBER) RETURN VARCHAR2;
67
68 FUNCTION get_ultimate_parent_party_ref(p_orig_system_customer_ref VARCHAR2)
69 RETURN VARCHAR2;
70 PRAGMA RESTRICT_REFERENCES (get_ultimate_parent_party_ref, WNDS,WNPS,RNPS);
71
72 --This function is created to make the customer interface run
73 --in parallel.
74 FUNCTION check_assigned_worker(p_string VARCHAR2,
75 p_total_workers NUMBER,
76 p_worker NUMBER) RETURN VARCHAR2;
77 PRAGMA RESTRICT_REFERENCES (check_assigned_worker,WNDS,WNPS,RNPS);
78
79 --This procedure has been created for customer interface master
80 --conc program.
81 PROCEDURE conc_main (errbuf OUT NOCOPY VARCHAR2, retcode OUT NOCOPY VARCHAR2);
82
83 -- Bug 2092530 - Overload conc_main such that it can be called with a
84 -- create_reciprocal_flag parameter
85 PROCEDURE conc_main (errbuf OUT NOCOPY VARCHAR2,
86 retcode OUT NOCOPY VARCHAR2,
87 p_create_reciprocal_flag IN VARCHAR2,
88 p_org_id IN NUMBER := 0 );
89 -- Bug 1795019
90
91 /* bug 4454799 - added argument for org_id below. */
92 FUNCTION validate_profile(v_insert_update_flag IN VARCHAR,
93 v_orig_system_customer_ref IN VARCHAR,
94 v_orig_system_address_ref IN VARCHAR,
95 v_org_id IN NUMBER,
96 v_request_id IN NUMBER )
97 RETURN VARCHAR2 ;
98
99 FUNCTION validate_address(p_location_structure_id IN NUMBER,
100 p_creation_date IN DATE,
101 p_state IN VARCHAR2,
102 p_city IN VARCHAR2,
103 p_county IN VARCHAR2,
104 p_postal_code IN VARCHAR2,
105 p_province IN VARCHAR2 default null)
106 RETURN VARCHAR2 ;
107 /* bug 4454799 - added argument for org_id below. */
108 FUNCTION validate_tax_location( p_orig_system_address_ref IN VARCHAR2,
109 p_country IN VARCHAR2,
110 p_city IN VARCHAR2,
111 p_state IN VARCHAR2,
112 p_county IN VARCHAR2,
113 p_province IN VARCHAR2,
114 p_postal_code IN VARCHAR2,
115 p_org_id IN NUMBER
116 )
117 RETURN VARCHAR2 ;
118
119 PROCEDURE update_org_ue_profile (
120 p_request_id IN NUMBER
121 );
122
123 PROCEDURE update_per_ue_profile (
124 p_request_id IN NUMBER
125 );
126
127 FUNCTION get_contact_name(p_orig_system_contact_ref IN VARCHAR2,
128 p_orig_system_customer_ref IN VARCHAR2
129 )
130 RETURN VARCHAR2 ;
131
132 PROCEDURE update_party_prel_name( p_party_id IN NUMBER );
133
134 /* bug 4454799 - added argument for org_id below. */
135 FUNCTION validate_primary_flag( p_orig_system_customer_ref IN VARCHAR2,
136 p_site_use_code IN VARCHAR2,
137 p_org_id IN NUMBER
138 )
139 RETURN VARCHAR2;
140
141 FUNCTION get_account_party_id (p_orig_system_customer_ref IN VARCHAR2,
142 p_person_flag IN VARCHAR2 DEFAULT 'N',
143 p_ref_flag IN VARCHAR2 DEFAULT 'C') RETURN NUMBER;
144
145 PROCEDURE sync_tax_profile(p_request_id IN NUMBER);
146 PROCEDURE insert_ci_party_usages(p_request_id IN NUMBER);
147 PROCEDURE insert_nci_party_usages(p_request_id IN NUMBER);
148 /*Bug: 4588090*/
149 PROCEDURE set_primary_flag( p_orig_system_customer_ref IN VARCHAR2,
150 p_site_use_code IN VARCHAR2,
151 p_org_id IN NUMBER );
152 PRAGMA RESTRICT_REFERENCES (get_account_party_id,WNDS,WNPS,RNPS);
153
154
155 END HZ_CUSTOMER_INT;