[Home] [Help]
PACKAGE: APPS.CS_SR_CUST_CONT_MAINT_PVT
Source
1 PACKAGE CS_SR_CUST_CONT_MAINT_PVT AUTHID CURRENT_USER AS
2 /* $Header: csxvccms.pls 120.5 2009/03/25 11:03:48 sshilpam ship $ */
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 p_do_addr_val IN VARCHAR2, -- 12.1.2 Address Validation
79 x_msg_count OUT NOCOPY NUMBER,
80 x_msg_data OUT NOCOPY VARCHAR2,
81 x_return_status OUT NOCOPY VARCHAR2,
82 x_addr_val_status OUT NOCOPY VARCHAR2, -- 12.1.2 Address Validation
83 x_addr_warn_msg OUT NOCOPY VARCHAR2, -- 12.1.2 Address Validation
84 x_location_id OUT NOCOPY NUMBER);
85
86 PROCEDURE Update_Address (
87 p_address_rec IN ADDRESS_REC_TYPE,
88 p_do_addr_val IN VARCHAR2, -- 12.1.2 Address Validation
89 x_msg_count OUT NOCOPY NUMBER,
90 x_msg_data OUT NOCOPY VARCHAR2,
91 x_object_version_number IN OUT NOCOPY NUMBER,
92 x_return_status OUT NOCOPY VARCHAR2,
93 x_addr_val_status OUT NOCOPY VARCHAR2, -- 12.1.2 Address Validation
94 x_addr_warn_msg OUT NOCOPY VARCHAR2); -- 12.1.2 Address Validation
95
96
97 -- Wrapper for HZ procedure : phone_format for phone number globalization
98 /* FUNCTION phone_format_Wrap( p_phone_country_code IN VARCHAR2,
99 p_phone_area_code IN VARCHAR2,
100 p_phone_number IN VARCHAR2)
101 RETURN varchar2;
102 */
103 PROCEDURE COMMIT_ROLLBACK( COM_ROLL IN VARCHAR2 := 'ROLL') ;
104
105 END CS_SR_CUST_CONT_MAINT_PVT;