eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_RESOURCE_PUB dependencies on PA_INTERFACE_UTILS_PUB

Line 33: ( resource_list_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

29: -- -------------------------------------------------------------------------------------------------------
30:
31: TYPE resource_list_rec IS RECORD
32:
33: ( resource_list_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
34: description VARCHAR2(255) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
35: group_resource_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
36: start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
37: end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

Line 34: description VARCHAR2(255) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

30:
31: TYPE resource_list_rec IS RECORD
32:
33: ( resource_list_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
34: description VARCHAR2(255) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
35: group_resource_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
36: start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
37: end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
38: resource_list_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 35: group_resource_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

31: TYPE resource_list_rec IS RECORD
32:
33: ( resource_list_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
34: description VARCHAR2(255) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
35: group_resource_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
36: start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
37: end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
38: resource_list_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
39: new_list_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 36: start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

32:
33: ( resource_list_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
34: description VARCHAR2(255) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
35: group_resource_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
36: start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
37: end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
38: resource_list_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
39: new_list_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
40: job_group_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Added for bug 2486405.

Line 37: end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

33: ( resource_list_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
34: description VARCHAR2(255) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
35: group_resource_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
36: start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
37: end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
38: resource_list_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
39: new_list_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
40: job_group_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Added for bug 2486405.
41: );

Line 38: resource_list_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

34: description VARCHAR2(255) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
35: group_resource_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
36: start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
37: end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
38: resource_list_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
39: new_list_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
40: job_group_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Added for bug 2486405.
41: );
42:

Line 39: new_list_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

35: group_resource_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
36: start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
37: end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
38: resource_list_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
39: new_list_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
40: job_group_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Added for bug 2486405.
41: );
42:
43: TYPE resource_list_out_rec IS RECORD

Line 40: job_group_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Added for bug 2486405.

36: start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
37: end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
38: resource_list_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
39: new_list_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
40: job_group_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Added for bug 2486405.
41: );
42:
43: TYPE resource_list_out_rec IS RECORD
44:

Line 45: ( resource_list_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

41: );
42:
43: TYPE resource_list_out_rec IS RECORD
44:
45: ( resource_list_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
46: return_status VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR );
47:
48: TYPE member_rec IS RECORD
49:

Line 46: return_status VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR );

42:
43: TYPE resource_list_out_rec IS RECORD
44:
45: ( resource_list_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
46: return_status VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR );
47:
48: TYPE member_rec IS RECORD
49:
50: ( resource_group_alias VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 50: ( resource_group_alias VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

46: return_status VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR );
47:
48: TYPE member_rec IS RECORD
49:
50: ( resource_group_alias VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
51: resource_group_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
52: resource_type_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
53: resource_attr_value VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
54: resource_alias VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 51: resource_group_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

47:
48: TYPE member_rec IS RECORD
49:
50: ( resource_group_alias VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
51: resource_group_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
52: resource_type_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
53: resource_attr_value VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
54: resource_alias VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
55: sort_order NUMBER := NULL,

Line 52: resource_type_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

48: TYPE member_rec IS RECORD
49:
50: ( resource_group_alias VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
51: resource_group_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
52: resource_type_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
53: resource_attr_value VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
54: resource_alias VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
55: sort_order NUMBER := NULL,
56: resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 53: resource_attr_value VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

49:
50: ( resource_group_alias VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
51: resource_group_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
52: resource_type_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
53: resource_attr_value VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
54: resource_alias VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
55: sort_order NUMBER := NULL,
56: resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
57: new_alias VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 54: resource_alias VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

50: ( resource_group_alias VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
51: resource_group_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
52: resource_type_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
53: resource_attr_value VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
54: resource_alias VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
55: sort_order NUMBER := NULL,
56: resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
57: new_alias VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
58: enabled_flag VARCHAR2(1) := 'Y' );

Line 56: resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

52: resource_type_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
53: resource_attr_value VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
54: resource_alias VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
55: sort_order NUMBER := NULL,
56: resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
57: new_alias VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
58: enabled_flag VARCHAR2(1) := 'Y' );
59:
60: TYPE member_out_rec IS RECORD

Line 57: new_alias VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

53: resource_attr_value VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
54: resource_alias VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
55: sort_order NUMBER := NULL,
56: resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
57: new_alias VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
58: enabled_flag VARCHAR2(1) := 'Y' );
59:
60: TYPE member_out_rec IS RECORD
61:

Line 62: ( resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

58: enabled_flag VARCHAR2(1) := 'Y' );
59:
60: TYPE member_out_rec IS RECORD
61:
62: ( resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
63: return_status VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR );
64:
65: TYPE member_tbl IS TABLE OF member_rec
66: INDEX BY BINARY_INTEGER;

Line 63: return_status VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR );

59:
60: TYPE member_out_rec IS RECORD
61:
62: ( resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
63: return_status VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR );
64:
65: TYPE member_tbl IS TABLE OF member_rec
66: INDEX BY BINARY_INTEGER;
67:

Line 134: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

130: p_member_out_tbl OUT NOCOPY member_out_tbl ); --File.Sql.39 bug 4440895
131:
132: PROCEDURE Process_Members
133: (p_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
134: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
135: p_member_tbl IN member_tbl,
136: p_group_resource_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
137: p_job_group_id IN NUMBER, -- Added for bug 2486405
138: p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 136: p_group_resource_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

132: PROCEDURE Process_Members
133: (p_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
134: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
135: p_member_tbl IN member_tbl,
136: p_group_resource_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
137: p_job_group_id IN NUMBER, -- Added for bug 2486405
138: p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
139: p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
140: p_member_out_tbl OUT NOCOPY member_out_tbl ); --File.Sql.39 bug 4440895

Line 191: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

187: * @rep:compatibility S
188: */
189: PROCEDURE Load_Resource_List
190: ( p_api_version_number IN NUMBER,
191: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
192: p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
193: p_group_resource_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
194: p_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
195: p_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

Line 192: p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

188: */
189: PROCEDURE Load_Resource_List
190: ( p_api_version_number IN NUMBER,
191: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
192: p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
193: p_group_resource_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
194: p_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
195: p_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
196: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 193: p_group_resource_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

189: PROCEDURE Load_Resource_List
190: ( p_api_version_number IN NUMBER,
191: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
192: p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
193: p_group_resource_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
194: p_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
195: p_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
196: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
197: p_new_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 194: p_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

190: ( p_api_version_number IN NUMBER,
191: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
192: p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
193: p_group_resource_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
194: p_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
195: p_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
196: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
197: p_new_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
198: p_job_group_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, -- Added for bug 2486405.

Line 195: p_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

191: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
192: p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
193: p_group_resource_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
194: p_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
195: p_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
196: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
197: p_new_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
198: p_job_group_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, -- Added for bug 2486405.
199: p_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895

Line 196: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

192: p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
193: p_group_resource_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
194: p_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
195: p_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
196: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
197: p_new_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
198: p_job_group_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, -- Added for bug 2486405.
199: p_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
200: /*#

Line 197: p_new_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

193: p_group_resource_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
194: p_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
195: p_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
196: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
197: p_new_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
198: p_job_group_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, -- Added for bug 2486405.
199: p_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
200: /*#
201: * This API loads the resource list member global input structure.

Line 198: p_job_group_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, -- Added for bug 2486405.

194: p_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
195: p_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
196: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
197: p_new_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
198: p_job_group_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, -- Added for bug 2486405.
199: p_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
200: /*#
201: * This API loads the resource list member global input structure.
202: * In order to execute this API the following list of API's should be executed in the following order.

Line 233: p_resource_group_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

229: * @rep:compatibility S
230: */
231: PROCEDURE Load_Members
232: ( p_api_version_number IN NUMBER,
233: p_resource_group_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
234: p_resource_group_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
235: p_resource_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
236: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
237: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 234: p_resource_group_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

230: */
231: PROCEDURE Load_Members
232: ( p_api_version_number IN NUMBER,
233: p_resource_group_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
234: p_resource_group_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
235: p_resource_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
236: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
237: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
238: p_resource_list_member_id IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 235: p_resource_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

231: PROCEDURE Load_Members
232: ( p_api_version_number IN NUMBER,
233: p_resource_group_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
234: p_resource_group_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
235: p_resource_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
236: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
237: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
238: p_resource_list_member_id IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
239: p_new_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 236: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

232: ( p_api_version_number IN NUMBER,
233: p_resource_group_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
234: p_resource_group_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
235: p_resource_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
236: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
237: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
238: p_resource_list_member_id IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
239: p_new_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
240: p_sort_order IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 237: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

233: p_resource_group_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
234: p_resource_group_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
235: p_resource_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
236: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
237: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
238: p_resource_list_member_id IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
239: p_new_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
240: p_sort_order IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
241: p_enabled_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 238: p_resource_list_member_id IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

234: p_resource_group_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
235: p_resource_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
236: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
237: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
238: p_resource_list_member_id IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
239: p_new_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
240: p_sort_order IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
241: p_enabled_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
242: p_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895

Line 239: p_new_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

235: p_resource_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
236: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
237: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
238: p_resource_list_member_id IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
239: p_new_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
240: p_sort_order IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
241: p_enabled_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
242: p_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
243: /*#

Line 240: p_sort_order IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

236: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
237: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
238: p_resource_list_member_id IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
239: p_new_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
240: p_sort_order IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
241: p_enabled_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
242: p_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
243: /*#
244: * This API executes the composite API CREATE_RESOURCE_LIST.

Line 241: p_enabled_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

237: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
238: p_resource_list_member_id IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
239: p_new_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
240: p_sort_order IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
241: p_enabled_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
242: p_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
243: /*#
244: * This API executes the composite API CREATE_RESOURCE_LIST.
245: * In order to execute this API the following list of API's should be executed in the following order.

Line 339: p_member_index IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

335: */
336: PROCEDURE Fetch_Members
337: ( p_api_version_number IN NUMBER,
338: p_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
339: p_member_index IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
340: p_resource_list_member_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
341: p_member_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
342: /*#
343: * This API clears the global data structures created during the initialize process.

Line 396: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

392: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
393: p_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
394: p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
395: p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
396: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
397: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
398: p_new_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
399: p_grouped_by_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
400: p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 397: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

393: p_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
394: p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
395: p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
396: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
397: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
398: p_new_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
399: p_grouped_by_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
400: p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
401: p_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

Line 398: p_new_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

394: p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
395: p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
396: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
397: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
398: p_new_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
399: p_grouped_by_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
400: p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
401: p_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
402: p_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

Line 399: p_grouped_by_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

395: p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
396: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
397: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
398: p_new_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
399: p_grouped_by_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
400: p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
401: p_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
402: p_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
403: p_member_tbl IN member_tbl,

Line 400: p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

396: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
397: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
398: p_new_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
399: p_grouped_by_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
400: p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
401: p_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
402: p_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
403: p_member_tbl IN member_tbl,
404: p_member_out_tbl OUT NOCOPY member_out_tbl --File.Sql.39 bug 4440895

Line 401: p_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

397: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
398: p_new_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
399: p_grouped_by_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
400: p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
401: p_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
402: p_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
403: p_member_tbl IN member_tbl,
404: p_member_out_tbl OUT NOCOPY member_out_tbl --File.Sql.39 bug 4440895
405: );

Line 402: p_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

398: p_new_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
399: p_grouped_by_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
400: p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
401: p_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
402: p_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
403: p_member_tbl IN member_tbl,
404: p_member_out_tbl OUT NOCOPY member_out_tbl --File.Sql.39 bug 4440895
405: );
406:

Line 509: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

505: PROCEDURE Delete_Resource_List
506: ( p_commit IN VARCHAR2 := FND_API.G_FALSE,
507: p_api_version_number IN NUMBER,
508: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
509: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
510: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
511: p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
512: p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
513: p_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 510: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

506: ( p_commit IN VARCHAR2 := FND_API.G_FALSE,
507: p_api_version_number IN NUMBER,
508: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
509: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
510: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
511: p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
512: p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
513: p_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
514: x_err_code IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 552: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

548: PROCEDURE Add_Resource_List_Member
549: (p_commit IN VARCHAR2 := FND_API.G_FALSE,
550: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
551: p_api_version_number IN NUMBER,
552: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
553: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
554: p_resource_group_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
555: p_resource_group_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
556: p_resource_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 553: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

549: (p_commit IN VARCHAR2 := FND_API.G_FALSE,
550: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
551: p_api_version_number IN NUMBER,
552: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
553: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
554: p_resource_group_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
555: p_resource_group_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
556: p_resource_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
557: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 554: p_resource_group_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

550: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
551: p_api_version_number IN NUMBER,
552: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
553: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
554: p_resource_group_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
555: p_resource_group_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
556: p_resource_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
557: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
558: p_resource_alias IN VARCHAR2 ,

Line 555: p_resource_group_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

551: p_api_version_number IN NUMBER,
552: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
553: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
554: p_resource_group_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
555: p_resource_group_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
556: p_resource_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
557: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
558: p_resource_alias IN VARCHAR2 ,
559: p_sort_order IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 556: p_resource_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

552: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
553: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
554: p_resource_group_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
555: p_resource_group_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
556: p_resource_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
557: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
558: p_resource_alias IN VARCHAR2 ,
559: p_sort_order IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
560: p_enabled_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 557: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

553: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
554: p_resource_group_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
555: p_resource_group_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
556: p_resource_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
557: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
558: p_resource_alias IN VARCHAR2 ,
559: p_sort_order IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
560: p_enabled_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
561: p_resource_list_member_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 559: p_sort_order IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

555: p_resource_group_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
556: p_resource_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
557: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
558: p_resource_alias IN VARCHAR2 ,
559: p_sort_order IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
560: p_enabled_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
561: p_resource_list_member_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
562: p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
563: p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 560: p_enabled_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

556: p_resource_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
557: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
558: p_resource_alias IN VARCHAR2 ,
559: p_sort_order IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
560: p_enabled_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
561: p_resource_list_member_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
562: p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
563: p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
564: p_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895

Line 594: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

590: PROCEDURE Update_Resource_List_Member
591: ( p_commit IN VARCHAR2 := FND_API.G_FALSE,
592: p_api_version_number IN NUMBER,
593: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
594: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
595: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
596: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
597: p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
598: p_new_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 595: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

591: ( p_commit IN VARCHAR2 := FND_API.G_FALSE,
592: p_api_version_number IN NUMBER,
593: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
594: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
595: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
596: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
597: p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
598: p_new_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
599: p_sort_order IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 596: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

592: p_api_version_number IN NUMBER,
593: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
594: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
595: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
596: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
597: p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
598: p_new_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
599: p_sort_order IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
600: p_enabled_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 597: p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

593: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
594: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
595: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
596: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
597: p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
598: p_new_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
599: p_sort_order IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
600: p_enabled_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
601: p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 598: p_new_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

594: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
595: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
596: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
597: p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
598: p_new_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
599: p_sort_order IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
600: p_enabled_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
601: p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
602: p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 599: p_sort_order IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

595: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
596: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
597: p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
598: p_new_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
599: p_sort_order IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
600: p_enabled_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
601: p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
602: p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
603: p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 600: p_enabled_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

596: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
597: p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
598: p_new_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
599: p_sort_order IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
600: p_enabled_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
601: p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
602: p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
603: p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
604: ) ;

Line 635: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

631: PROCEDURE Delete_Resource_List_Member
632: ( p_commit IN VARCHAR2 := FND_API.G_FALSE,
633: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
634: p_api_version_number IN NUMBER,
635: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
636: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
637: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
638: p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
639: p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 636: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

632: ( p_commit IN VARCHAR2 := FND_API.G_FALSE,
633: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
634: p_api_version_number IN NUMBER,
635: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
636: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
637: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
638: p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
639: p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
640: p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 637: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

633: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
634: p_api_version_number IN NUMBER,
635: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
636: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
637: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
638: p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
639: p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
640: p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
641: p_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 638: p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

634: p_api_version_number IN NUMBER,
635: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
636: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
637: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
638: p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
639: p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
640: p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
641: p_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
642: x_err_code IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 672: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

668: PROCEDURE Sort_Resource_List_Members
669: ( p_commit IN VARCHAR2 := FND_API.G_FALSE,
670: p_api_version_number IN NUMBER,
671: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
672: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
673: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
674: p_resource_group_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
675: p_sort_by IN VARCHAR2,
676: p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 673: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

669: ( p_commit IN VARCHAR2 := FND_API.G_FALSE,
670: p_api_version_number IN NUMBER,
671: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
672: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
673: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
674: p_resource_group_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
675: p_sort_by IN VARCHAR2,
676: p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
677: p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 674: p_resource_group_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

670: p_api_version_number IN NUMBER,
671: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
672: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
673: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
674: p_resource_group_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
675: p_sort_by IN VARCHAR2,
676: p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
677: p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
678: p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 683: (p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

679: );
680:
681: -- ----------------------------------------------------------
682: PROCEDURE Convert_List_Name_To_Id
683: (p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
684: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
685: p_out_resource_list_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
686: p_return_status OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
687:

Line 684: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

680:
681: -- ----------------------------------------------------------
682: PROCEDURE Convert_List_Name_To_Id
683: (p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
684: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
685: p_out_resource_list_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
686: p_return_status OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
687:
688: PROCEDURE Convert_Alias_To_Id

Line 691: p_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

687:
688: PROCEDURE Convert_Alias_To_Id
689: (
690: p_resource_list_id IN NUMBER,
691: p_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
692: p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
693: p_project_id IN NUMBER DEFAULT NULL,
694: p_out_resource_list_member_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
695: p_return_status OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895

Line 692: p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

688: PROCEDURE Convert_Alias_To_Id
689: (
690: p_resource_list_id IN NUMBER,
691: p_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
692: p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
693: p_project_id IN NUMBER DEFAULT NULL,
694: p_out_resource_list_member_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
695: p_return_status OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
696: