[Home] [Help]
PACKAGE: APPS.PON_PROFILE_UTIL_PKG
Source
1 PACKAGE PON_PROFILE_UTIL_PKG AUTHID CURRENT_USER as
2 /*$Header: PONPRUTS.pls 120.4 2006/03/31 05:49:23 rpatel noship $ */
3
4 --This ref cursor type is used for any cursors we need to pass out
5 --to Java. Namely addresses and all the subset preference stuff:
6 --payment methods, credit card types, payment terms, carrier,
7 --freight terms, fob.
8 type refCurTyp is Ref Cursor;
9 HZ_FAIL_EXCEPTION EXCEPTION;
10
11 OWNER_TABLE_NAME CONSTANT HZ_CODE_ASSIGNMENTS.OWNER_TABLE_NAME%TYPE := 'HZ_PARTIES';
12 PON_CLASSIFICATION CONSTANT HZ_CODE_ASSIGNMENTS.CLASS_CATEGORY%TYPE := 'PON_CLASSIFICATION';
13 TRADING_PARTNER CONSTANT HZ_CODE_ASSIGNMENTS.CLASS_CODE%TYPE := 'TRADING_PARTNER';
14 TRADING_PARTNER_USER CONSTANT HZ_CODE_ASSIGNMENTS.CLASS_CODE%TYPE := 'TRADING_PARTNER_USER';
15 PRIMARY_FLAG CONSTANT HZ_CODE_ASSIGNMENTS.PRIMARY_FLAG%TYPE := 'Y';
16 CONTENT_SOURCE_TYPE CONSTANT HZ_CODE_ASSIGNMENTS.CONTENT_SOURCE_TYPE%TYPE := 'USER_ENTERED';
17 APPLICATION_ID CONSTANT HZ_CODE_ASSIGNMENTS.APPLICATION_ID%TYPE := 396;
18 CREATED_BY_MODULE CONSTANT HZ_CODE_ASSIGNMENTS.CREATED_BY_MODULE%TYPE := 'PON';
19 OBJECT_VERSION_NUMBER CONSTANT HZ_CODE_ASSIGNMENTS.OBJECT_VERSION_NUMBER%TYPE := 0;
20 ACTIVE_STATUS CONSTANT HZ_CODE_ASSIGNMENTS.STATUS%TYPE := 'A';
21
22 PROCEDURE update_organization_start_date(
23 p_party_id IN NUMBER
24 , x_status OUT NOCOPY VARCHAR2
25 , x_exception_msg OUT NOCOPY VARCHAR2
26 );
27
28 FUNCTION get_update_date_from_party (
29 p_party_id IN NUMBER
30 ) RETURN DATE;
31
32 FUNCTION get_update_date_from_location (
33 p_location_id IN NUMBER
34 ) RETURN DATE;
35
36 FUNCTION get_update_date_from_contact (
37 p_contact_id IN NUMBER
38 ) RETURN DATE;
39
40 PROCEDURE update_ins_party_pref_cover(
41 p_party_id in NUMBER
42 , p_app_short_name in VARCHAR2
43 , p_pref_name in VARCHAR2
44 , p_pref_value in VARCHAR2 DEFAULT NULL
45 , p_pref_meaning in VARCHAR2 DEFAULT NULL
46 , x_status out nocopy VARCHAR2
47 , x_exception_msg out nocopy VARCHAR2
48 );
49
50 PROCEDURE UPDATE_OR_INSERT_PARTY_PREF(
51 p_party_id in NUMBER
52 , p_app_short_name in VARCHAR2
53 , p_pref_name in VARCHAR2
54 , p_pref_value in VARCHAR2 DEFAULT NULL
55 , p_pref_meaning in VARCHAR2 DEFAULT NULL
56 , p_attribute1 in VARCHAR2 DEFAULT NULL
57 , p_attribute2 in VARCHAR2 DEFAULT NULL
58 , p_attribute3 in VARCHAR2 DEFAULT NULL
59 , p_attribute4 in VARCHAR2 DEFAULT NULL
60 , p_attribute5 in VARCHAR2 DEFAULT NULL
61 , x_status out nocopy VARCHAR2
62 , x_exception_msg out nocopy VARCHAR2
63 );
64
65 PROCEDURE DELETE_PARTY_PREF(
66 p_party_id in NUMBER
67 , p_app_short_name in VARCHAR2
68 , p_pref_name in VARCHAR2
69 , x_status out nocopy VARCHAR2
70 , x_exception_msg out nocopy VARCHAR2
71 );
72
73 PROCEDURE retrieve_party_pref_cover(
74 p_party_id IN NUMBER
75 , p_app_short_name IN VARCHAR2
76 , p_pref_name IN VARCHAR2
77 , x_pref_value OUT NOCOPY VARCHAR2
78 , x_pref_meaning OUT NOCOPY VARCHAR2
79 , x_status OUT NOCOPY VARCHAR2
80 , x_exception_msg OUT NOCOPY VARCHAR2
81 );
82
83 PROCEDURE RETRIEVE_PARTY_PREFERENCE(
84 p_party_id in NUMBER
85 , p_app_short_name in VARCHAR2
86 , p_pref_name in VARCHAR2
87 , x_pref_value out nocopy VARCHAR2
88 , x_pref_meaning out nocopy VARCHAR2
89 , x_attribute1 out nocopy VARCHAR2
90 , x_attribute2 out nocopy VARCHAR2
91 , x_attribute3 out nocopy VARCHAR2
92 , x_attribute4 out nocopy VARCHAR2
93 , x_attribute5 out nocopy VARCHAR2
94 , x_status out nocopy VARCHAR2
95 , x_exception_msg out nocopy VARCHAR2
96 );
97
98 PROCEDURE GET_PARTY_URL(
99 party_id IN NUMBER
100 , url OUT NOCOPY VARCHAR2
101 , x_status OUT NOCOPY VARCHAR2
102 , x_exception_msg OUT NOCOPY VARCHAR2
103 );
104
105 PROCEDURE GET_PARTY_SLOGAN(
106 party_id IN NUMBER
107 , slogan OUT NOCOPY VARCHAR2
108 , x_status OUT NOCOPY VARCHAR2
109 , x_exception_msg OUT NOCOPY VARCHAR2
110 );
111
112 PROCEDURE GET_PARTY_PORT(
113 party_id IN NUMBER
114 , port OUT NOCOPY VARCHAR2
115 , x_status OUT NOCOPY VARCHAR2
116 , x_exception_msg OUT NOCOPY VARCHAR2
117 );
118
119
120 PROCEDURE SET_WF_LANGUAGE(
121 p_user_name IN VARCHAR2,
122 p_language_code IN VARCHAR2
123 );
124
125 PROCEDURE GET_WF_LANGUAGE(
126 p_user_name IN VARCHAR2,
127 x_language_code OUT NOCOPY VARCHAR2
128 );
129
130 PROCEDURE GET_WF_LANGUAGE(
131 p_user_id IN NUMBER,
132 x_language_code OUT NOCOPY VARCHAR2
133 );
134
135 PROCEDURE SET_WF_TERRITORY(
136 p_user_name IN VARCHAR2,
137 p_territory_code IN VARCHAR2
138 );
139
140 PROCEDURE GET_WF_TERRITORY(
141 p_user_name IN VARCHAR2,
142 x_territory_code OUT NOCOPY VARCHAR2
143 );
144
145 PROCEDURE SET_WF_PREFERENCES(
146 p_user_name IN VARCHAR2,
147 p_language_code IN VARCHAR2,
148 p_territory_code IN VARCHAR2
149 );
150
151 PROCEDURE GET_WF_PREFERENCES(
152 p_user_name IN VARCHAR2,
153 x_language_code OUT NOCOPY VARCHAR2,
154 x_territory_code OUT NOCOPY VARCHAR2
155 );
156
157
158 --
159 -- GET_STRING- get a particular translated message
160 -- from the message dictionary database.
161 -- This is a one-call interface for when you just want to get a
162 -- message without doing any token substitution.
163 -- Returns NAMEIN (Msg name) if the message cannot be found.
164 FUNCTION get_string(appin IN VARCHAR2,
165 namein IN VARCHAR2,
166 langin IN VARCHAR2) RETURN VARCHAR2;
167
168 FUNCTION SET_PRINT_OPTIONS RETURN VARCHAR2;
169
170 FUNCTION SAVE_PROFILE_OPTION(p_option_name IN VARCHAR2,
171 p_option_value IN VARCHAR2,
172 p_level_name IN VARCHAR2) RETURN VARCHAR2;
173
174 PROCEDURE LINES_MORE_THAN_THRESHOLD(
175 p_number_of_lines IN NUMBER,
176 p_party_id IN NUMBER,
177 x_is_super_large_neg OUT NOCOPY VARCHAR2);
178
179
180 END PON_PROFILE_UTIL_PKG;