[Home] [Help]
PACKAGE: APPS.CSC_RESPONSE_CENTER_PKG_V2
Source
1 PACKAGE CSC_RESPONSE_CENTER_PKG_V2 AUTHID CURRENT_USER AS
2 /* $Header: CSCV2RCS.pls 120.4 2011/08/19 05:05:56 spamujul ship $ */
3
4 FUNCTION G_MISS_NUM RETURN NUMBER;
5 FUNCTION G_MISS_CHAR RETURN VARCHAR2;
6 FUNCTION G_MISS_DATE RETURN DATE;
7
8 FUNCTION GET_ACCOUNT_REC_TYPE RETURN HZ_CUST_ACCOUNT_V2PUB.CUST_ACCOUNT_REC_TYPE;
9 FUNCTION GET_CUST_PROFILE_REC_TYPE RETURN HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;
10 FUNCTION GET_PERSON_REC_TYPE RETURN HZ_PARTY_V2PUB.PERSON_REC_TYPE;
11 FUNCTION GET_ORG_REC_TYPE RETURN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE;
12 FUNCTION GET_CUST_ACCT_ROLES_REC_TYPE RETURN HZ_CUST_ACCOUNT_ROLE_V2PUB.CUST_ACCOUNT_ROLE_REC_TYPE;
13 FUNCTION GET_ACCT_SITE_REC_TYPE RETURN HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_ACCT_SITE_REC_TYPE;
14 FUNCTION GET_ACCT_SITE_USES_REC_TYPE RETURN HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_SITE_USE_REC_TYPE;
15 FUNCTION GET_CUST_ACCT_RELATE_REC_TYPE RETURN HZ_CUST_ACCOUNT_V2PUB.CUST_ACCT_RELATE_REC_TYPE;
16 FUNCTION GET_PARTY_REC_TYPE RETURN HZ_PARTY_V2PUB.PARTY_REC_TYPE;
17 FUNCTION GET_PHONE_REC_TYPE RETURN HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
18 FUNCTION GET_EMAIL_REC_TYPE RETURN HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
19 FUNCTION GET_WEB_REC_TYPE RETURN HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;
20 FUNCTION GET_EDI_REC_TYPE RETURN HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
21 FUNCTION GET_TELEX_REC_TYPE RETURN HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
22 FUNCTION GET_CONTACT_POINTS_REC_TYPE RETURN HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
23 FUNCTION GET_CONT_POINTS_PREF_REC_TYPE RETURN HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE;
24 FUNCTION GET_PARTY_SITE_REC_TYPE RETURN HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE;
25 FUNCTION GET_PARTY_SITE_USE_REC_TYPE RETURN HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE;
26 -- hbchung
27 FUNCTION GET_ORG_CONTACT_REC_TYPE RETURN HZ_PARTY_CONTACT_V2PUB.ORG_CONTACT_REC_TYPE;
28 FUNCTION GET_RELATIONSHIP_REC_TYPE RETURN HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE;
29 FUNCTION GET_PER_LANG_REC_TYPE RETURN HZ_PERSON_INFO_V2PUB.PERSON_LANGUAGE_REC_TYPE;
30 FUNCTION GET_EDUCATION_REC_TYPE RETURN HZ_PERSON_INFO_V2PUB.EDUCATION_REC_TYPE;
31 FUNCTION GET_EMP_HISTORY_REC_TYPE RETURN HZ_PERSON_INFO_V2PUB.EMPLOYMENT_HISTORY_REC_TYPE;
32 FUNCTION GET_PER_INTEREST_REC_TYPE RETURN HZ_PERSON_INFO_V2PUB.PERSON_INTEREST_REC_TYPE;
33
34 FUNCTION get_csc_application_id RETURN NUMBER;
35
36 TYPE address_rec_type IS RECORD(
37 location_id NUMBER := FND_API.G_MISS_NUM,
38 country VARCHAR2(60) := FND_API.G_MISS_CHAR,
39 address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
40 address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
41 address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42 address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
43 city VARCHAR2(60) := FND_API.G_MISS_CHAR,
44 postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
45 state VARCHAR2(60) := FND_API.G_MISS_CHAR,
46 province VARCHAR2(60) := FND_API.G_MISS_CHAR,
47 county VARCHAR2(60) := FND_API.G_MISS_CHAR,
48 address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
49 address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
50 address_lines_phonetic VARCHAR2(560) := FND_API.G_MISS_CHAR,
51 po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
52 house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
53 street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
54 street VARCHAR2(50) := FND_API.G_MISS_CHAR,
55 street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
56 floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
57 suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
58 postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
59 position VARCHAR2(50) := FND_API.G_MISS_CHAR,
60 location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
61 address_effective_date DATE := FND_API.G_MISS_DATE,
62 address_expiration_date DATE := FND_API.G_MISS_DATE,
63 clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
64 language VARCHAR2(4) := FND_API.G_MISS_CHAR,
65 short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
66 description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
67 sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
68 sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
69 created_by_module VARCHAR2(150) := FND_API.G_MISS_CHAR,
70 application_id NUMBER := FND_API.G_MISS_NUM,
71 timezone_id NUMBER := FND_API.G_MISS_NUM,
72 delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR
73 ,attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74 attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75 attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76 attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77 attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78 attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79 attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80 attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81 attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82 attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83 attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84 attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85 attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86 attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87 attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88 attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89 attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90 attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91 attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92 attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR
93 );
94
95 FUNCTION GET_ADDRESS_REC_TYPE RETURN CSC_RESPONSE_CENTER_PKG_V2.ADDRESS_REC_TYPE;
96
97 PROCEDURE Create_Address ( p_address_rec IN ADDRESS_REC_TYPE,
98 x_msg_count OUT NOCOPY NUMBER,
99 x_msg_data OUT NOCOPY VARCHAR2,
100 x_return_status OUT NOCOPY VARCHAR2,
101 x_location_id OUT NOCOPY NUMBER,
102 x_addr_val_status OUT NOCOPY VARCHAR2,
103 x_addr_warn_msg OUT NOCOPY VARCHAR2);
104
105 PROCEDURE Update_Address ( p_address_rec IN ADDRESS_REC_TYPE,
106 x_msg_count OUT NOCOPY NUMBER,
107 x_msg_data OUT NOCOPY VARCHAR2,
108 x_object_version_number IN OUT NOCOPY NUMBER,
109 x_return_status OUT NOCOPY VARCHAR2,
110 x_addr_val_status OUT NOCOPY VARCHAR2,
111 x_addr_warn_msg OUT NOCOPY VARCHAR2);
112
113
114 END CSC_RESPONSE_CENTER_PKG_V2;