[Home] [Help]
PACKAGE: APPS.CS_SR_CUST_CONT_MAINT_PVT
Source
1 PACKAGE CS_SR_CUST_CONT_MAINT_PVT AS
2 /* $Header: csxvccms.pls 120.4 2006/02/13 13:52:15 pskannan noship $ */
3
4 FUNCTION G_MISS_NUM RETURN NUMBER;
5 FUNCTION G_MISS_CHAR RETURN VARCHAR2;
6 FUNCTION G_MISS_DATE RETURN DATE;
7 FUNCTION G_VALID_LEVEL(p_level varchar2) RETURN NUMBER;
8 FUNCTION G_BOOLEAN(p_flag varchar2) RETURN VARCHAR2;
9 FUNCTION GET_ERROR_CONSTANT(err_msg VARCHAR2) RETURN VARCHAR2;
10 FUNCTION G_RET_STS_SUCCESS RETURN VARCHAR2 ;
11 FUNCTION G_RET_STS_ERROR RETURN VARCHAR2 ;
12 FUNCTION G_RET_STS_UNEXP_ERROR RETURN VARCHAR2 ;
13 FUNCTION G_VALID_LEVEL_NONE RETURN NUMBER;
14 FUNCTION G_VALID_LEVEL_FULL RETURN NUMBER;
15 FUNCTION G_VALID_LEVEL_INT RETURN NUMBER;
16 FUNCTION G_TRUE RETURN Varchar2;
17 FUNCTION G_FALSE RETURN Varchar2;
18
19 -- HZ Wrappers
20 FUNCTION GET_PARTY_REC_TYPE RETURN HZ_PARTY_V2PUB.PARTY_REC_TYPE;
21 FUNCTION GET_PERSON_REC_TYPE RETURN HZ_PARTY_V2PUB.PERSON_REC_TYPE;
22 FUNCTION GET_CONTACT_POINTS_REC_TYPE RETURN HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
23 FUNCTION GET_EDI_REC_TYPE RETURN HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
24 FUNCTION GET_PHONE_REC_TYPE RETURN HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
25 FUNCTION GET_EMAIL_REC_TYPE RETURN HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
26 FUNCTION GET_TELEX_REC_TYPE RETURN HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
27 FUNCTION GET_WEB_REC_TYPE RETURN HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;
28 FUNCTION GET_PARTY_REL_REC_TYPE RETURN HZ_RELATIONSHIP_V2PUB.relationship_rec_type;
29 FUNCTION GET_ORG_CONTACT_REC_TYPE RETURN HZ_PARTY_CONTACT_V2PUB.ORG_CONTACT_REC_TYPE;
30 -- FUNCTION GET_CONTACT_RESTRICT_REC_TYPE RETURN HZ_CONTACT_POINT_PUB.CONTACT_RESTRICTION_REC_TYPE;
31 FUNCTION GET_PARTY_SITE_REC_TYPE RETURN HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE;
32 FUNCTION GET_PARTY_SITE_USE_REC_TYPE RETURN HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE;
33
34 -- wh_update_date is addded in the record. This is used as last update date in
35 -- Update address proc. Fix for bug #1567159
36
37 TYPE address_rec_type IS RECORD(
38 location_id NUMBER := FND_API.G_MISS_NUM,
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 address_lines_phonetic VARCHAR2(560) := FND_API.G_MISS_CHAR,
44 city VARCHAR2(60) := FND_API.G_MISS_CHAR,
45 state VARCHAR2(60) := FND_API.G_MISS_CHAR,
46 postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
47 province VARCHAR2(60) := FND_API.G_MISS_CHAR,
48 county VARCHAR2(60) := FND_API.G_MISS_CHAR,
49 country VARCHAR2(60) := FND_API.G_MISS_CHAR,
50 language VARCHAR2(4) := FND_API.G_MISS_CHAR,
51 street VARCHAR2(50) := FND_API.G_MISS_CHAR,
52 house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
53 position VARCHAR2(50) := FND_API.G_MISS_CHAR,
54 po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
55 address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
56 street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
57 street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
58 floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
59 suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
60 postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
61 time_zone VARCHAR2(50) := FND_API.G_MISS_CHAR,
62 location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
63 clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
64 short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
65 description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
66 sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
67 sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
68 timezone_id NUMBER := FND_API.G_MISS_NUM,
69 address_effective_date DATE := FND_API.G_MISS_DATE,
70 address_expiration_date DATE := FND_API.G_MISS_DATE,
71 address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
72 created_by_module VARCHAR2(30) := 'SR');
73
74 FUNCTION GET_ADDRESS_REC_TYPE RETURN CS_SR_CUST_CONT_MAINT_PVT.ADDRESS_REC_TYPE;
75
76 PROCEDURE Create_Address (
77 p_address_rec IN ADDRESS_REC_TYPE,
78 x_msg_count OUT NOCOPY NUMBER,
79 x_msg_data OUT NOCOPY VARCHAR2,
80 x_return_status OUT NOCOPY VARCHAR2,
81 x_location_id OUT NOCOPY NUMBER);
82
83 PROCEDURE Update_Address (
84 p_address_rec IN ADDRESS_REC_TYPE,
85 x_msg_count OUT NOCOPY NUMBER,
86 x_msg_data OUT NOCOPY VARCHAR2,
87 x_object_version_number IN OUT NOCOPY NUMBER,
88 x_return_status OUT NOCOPY VARCHAR2);
89
90 -- Wrapper for HZ procedure : phone_format for phone number globalization
91 /* FUNCTION phone_format_Wrap( p_phone_country_code IN VARCHAR2,
92 p_phone_area_code IN VARCHAR2,
93 p_phone_number IN VARCHAR2)
94 RETURN varchar2;
95 */
96 PROCEDURE COMMIT_ROLLBACK( COM_ROLL IN VARCHAR2 := 'ROLL') ;
97
98 END CS_SR_CUST_CONT_MAINT_PVT;