14: -- Pre-reqs : None.
15: -- Paramaeters :
16: -- IN : p_api_version_number IN NUMBER Required
17: -- p_init_msg_list IN VARCHAR2 Optional
18: -- Default = FND_API.G_FALSE
19: -- p_simulate IN VARCHAR2 Optional
20: -- Default = FND_API.G_FALSE
21: -- p_commit IN VARCHAR2 Optional
22: -- Default = FND_API.G_FALSE
16: -- IN : p_api_version_number IN NUMBER Required
17: -- p_init_msg_list IN VARCHAR2 Optional
18: -- Default = FND_API.G_FALSE
19: -- p_simulate IN VARCHAR2 Optional
20: -- Default = FND_API.G_FALSE
21: -- p_commit IN VARCHAR2 Optional
22: -- Default = FND_API.G_FALSE
23: -- p_validation_level IN NUMBER Optional
24: -- Default = FND_API.G_VALID_LEVEL_FULL
18: -- Default = FND_API.G_FALSE
19: -- p_simulate IN VARCHAR2 Optional
20: -- Default = FND_API.G_FALSE
21: -- p_commit IN VARCHAR2 Optional
22: -- Default = FND_API.G_FALSE
23: -- p_validation_level IN NUMBER Optional
24: -- Default = FND_API.G_VALID_LEVEL_FULL
25: -- p_user_id IN NUMBER Required
26: -- p_days_needed_by IN NUMBER Optional
20: -- Default = FND_API.G_FALSE
21: -- p_commit IN VARCHAR2 Optional
22: -- Default = FND_API.G_FALSE
23: -- p_validation_level IN NUMBER Optional
24: -- Default = FND_API.G_VALID_LEVEL_FULL
25: -- p_user_id IN NUMBER Required
26: -- p_days_needed_by IN NUMBER Optional
27: -- Default = NULL
28: -- p_req_default_template IN VARCHAR2 Optional
54: -- Pre-reqs : None.
55: -- Paramaeters :
56: -- IN : p_api_version_number IN NUMBER Required
57: -- p_init_msg_list IN VARCHAR2 Optional
58: -- Default = FND_API.G_FALSE
59: -- p_simulate IN VARCHAR2 Optional
60: -- Default = FND_API.G_FALSE
61: -- p_commit IN VARCHAR2 Optional
62: -- Default = FND_API.G_FALSE
56: -- IN : p_api_version_number IN NUMBER Required
57: -- p_init_msg_list IN VARCHAR2 Optional
58: -- Default = FND_API.G_FALSE
59: -- p_simulate IN VARCHAR2 Optional
60: -- Default = FND_API.G_FALSE
61: -- p_commit IN VARCHAR2 Optional
62: -- Default = FND_API.G_FALSE
63: -- p_validation_level IN NUMBER Optional
64: -- Default = FND_API.G_VALID_LEVEL_FULL
58: -- Default = FND_API.G_FALSE
59: -- p_simulate IN VARCHAR2 Optional
60: -- Default = FND_API.G_FALSE
61: -- p_commit IN VARCHAR2 Optional
62: -- Default = FND_API.G_FALSE
63: -- p_validation_level IN NUMBER Optional
64: -- Default = FND_API.G_VALID_LEVEL_FULL
65: -- p_user_id IN NUMBER Required
66: -- p_days_needed_by IN NUMBER Optional
60: -- Default = FND_API.G_FALSE
61: -- p_commit IN VARCHAR2 Optional
62: -- Default = FND_API.G_FALSE
63: -- p_validation_level IN NUMBER Optional
64: -- Default = FND_API.G_VALID_LEVEL_FULL
65: -- p_user_id IN NUMBER Required
66: -- p_days_needed_by IN NUMBER Optional
67: -- Default = FND_API.G_MISS_NUM
68: -- p_req_default_template IN VARCHAR2 Optional
63: -- p_validation_level IN NUMBER Optional
64: -- Default = FND_API.G_VALID_LEVEL_FULL
65: -- p_user_id IN NUMBER Required
66: -- p_days_needed_by IN NUMBER Optional
67: -- Default = FND_API.G_MISS_NUM
68: -- p_req_default_template IN VARCHAR2 Optional
69: -- Default = FND_API.G_MISS_CHAR
70: -- p_req_override_loc_flag IN VARCHAR2 Optional
71: -- Default = FND_API.G_MISS_CHAR
65: -- p_user_id IN NUMBER Required
66: -- p_days_needed_by IN NUMBER Optional
67: -- Default = FND_API.G_MISS_NUM
68: -- p_req_default_template IN VARCHAR2 Optional
69: -- Default = FND_API.G_MISS_CHAR
70: -- p_req_override_loc_flag IN VARCHAR2 Optional
71: -- Default = FND_API.G_MISS_CHAR
72: -- p_req_override_req_code IN VARCHAR2 Optional
73: -- Default = FND_API.G_MISS_CHAR
67: -- Default = FND_API.G_MISS_NUM
68: -- p_req_default_template IN VARCHAR2 Optional
69: -- Default = FND_API.G_MISS_CHAR
70: -- p_req_override_loc_flag IN VARCHAR2 Optional
71: -- Default = FND_API.G_MISS_CHAR
72: -- p_req_override_req_code IN VARCHAR2 Optional
73: -- Default = FND_API.G_MISS_CHAR
74: -- p_last_updated_by IN NUMBER Required
75: -- Default = FND_API.G_MISS_NUM
69: -- Default = FND_API.G_MISS_CHAR
70: -- p_req_override_loc_flag IN VARCHAR2 Optional
71: -- Default = FND_API.G_MISS_CHAR
72: -- p_req_override_req_code IN VARCHAR2 Optional
73: -- Default = FND_API.G_MISS_CHAR
74: -- p_last_updated_by IN NUMBER Required
75: -- Default = FND_API.G_MISS_NUM
76: -- p_last_update_date IN DATE Required
77: -- Default = FND_API.G_MISS_DATE
71: -- Default = FND_API.G_MISS_CHAR
72: -- p_req_override_req_code IN VARCHAR2 Optional
73: -- Default = FND_API.G_MISS_CHAR
74: -- p_last_updated_by IN NUMBER Required
75: -- Default = FND_API.G_MISS_NUM
76: -- p_last_update_date IN DATE Required
77: -- Default = FND_API.G_MISS_DATE
78: -- p_last_update_login IN NUMBER Optional
79: -- Default = FND_API.G_MISS_NUM
73: -- Default = FND_API.G_MISS_CHAR
74: -- p_last_updated_by IN NUMBER Required
75: -- Default = FND_API.G_MISS_NUM
76: -- p_last_update_date IN DATE Required
77: -- Default = FND_API.G_MISS_DATE
78: -- p_last_update_login IN NUMBER Optional
79: -- Default = FND_API.G_MISS_NUM
80: --
81: -- OUT : p_return_status OUT VARCHAR2
75: -- Default = FND_API.G_MISS_NUM
76: -- p_last_update_date IN DATE Required
77: -- Default = FND_API.G_MISS_DATE
78: -- p_last_update_login IN NUMBER Optional
79: -- Default = FND_API.G_MISS_NUM
80: --
81: -- OUT : p_return_status OUT VARCHAR2
82: -- p_msg_count OUT NUMBER
83: -- p_msg_data OUT VARCHAR2
94: -- Pre-reqs : None.
95: -- Paramaeters :
96: -- IN : p_api_version_number IN NUMBER Required
97: -- p_init_msg_list IN VARCHAR2 Optional
98: -- Default = FND_API.G_FALSE
99: -- p_simulate IN VARCHAR2 Optional
100: -- Default = FND_API.G_FALSE
101: -- p_commit IN VARCHAR2 Optional
102: -- Default = FND_API.G_FALSE
96: -- IN : p_api_version_number IN NUMBER Required
97: -- p_init_msg_list IN VARCHAR2 Optional
98: -- Default = FND_API.G_FALSE
99: -- p_simulate IN VARCHAR2 Optional
100: -- Default = FND_API.G_FALSE
101: -- p_commit IN VARCHAR2 Optional
102: -- Default = FND_API.G_FALSE
103: -- p_validation_level IN NUMBER Optional
104: -- Default = FND_API.G_VALID_LEVEL_FULL
98: -- Default = FND_API.G_FALSE
99: -- p_simulate IN VARCHAR2 Optional
100: -- Default = FND_API.G_FALSE
101: -- p_commit IN VARCHAR2 Optional
102: -- Default = FND_API.G_FALSE
103: -- p_validation_level IN NUMBER Optional
104: -- Default = FND_API.G_VALID_LEVEL_FULL
105: -- p_user_id IN NUMBER Required
106: -- OUT : p_return_status OUT VARCHAR2
100: -- Default = FND_API.G_FALSE
101: -- p_commit IN VARCHAR2 Optional
102: -- Default = FND_API.G_FALSE
103: -- p_validation_level IN NUMBER Optional
104: -- Default = FND_API.G_VALID_LEVEL_FULL
105: -- p_user_id IN NUMBER Required
106: -- OUT : p_return_status OUT VARCHAR2
107: -- p_msg_count OUT NUMBER
108: -- p_msg_data OUT VARCHAR2
115: -- End Of Comments
116:
117: PROCEDURE Create_Profile
118: ( p_api_version_number IN NUMBER,
119: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
120: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
121: p_commit IN VARCHAR2 := FND_API.G_FALSE,
122: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
123: p_return_status OUT nocopy VARCHAR2,
116:
117: PROCEDURE Create_Profile
118: ( p_api_version_number IN NUMBER,
119: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
120: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
121: p_commit IN VARCHAR2 := FND_API.G_FALSE,
122: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
123: p_return_status OUT nocopy VARCHAR2,
124: p_msg_count OUT nocopy NUMBER,
117: PROCEDURE Create_Profile
118: ( p_api_version_number IN NUMBER,
119: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
120: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
121: p_commit IN VARCHAR2 := FND_API.G_FALSE,
122: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
123: p_return_status OUT nocopy VARCHAR2,
124: p_msg_count OUT nocopy NUMBER,
125: p_msg_data OUT nocopy VARCHAR2,
118: ( p_api_version_number IN NUMBER,
119: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
120: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
121: p_commit IN VARCHAR2 := FND_API.G_FALSE,
122: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
123: p_return_status OUT nocopy VARCHAR2,
124: p_msg_count OUT nocopy NUMBER,
125: p_msg_data OUT nocopy VARCHAR2,
126: p_user_id IN NUMBER,
137:
138:
139: PROCEDURE Update_Profile
140: ( p_api_version_number IN NUMBER,
141: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
142: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
143: p_commit IN VARCHAR2 := FND_API.G_FALSE,
144: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
145: p_return_status OUT nocopy VARCHAR2,
138:
139: PROCEDURE Update_Profile
140: ( p_api_version_number IN NUMBER,
141: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
142: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
143: p_commit IN VARCHAR2 := FND_API.G_FALSE,
144: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
145: p_return_status OUT nocopy VARCHAR2,
146: p_msg_count OUT nocopy NUMBER,
139: PROCEDURE Update_Profile
140: ( p_api_version_number IN NUMBER,
141: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
142: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
143: p_commit IN VARCHAR2 := FND_API.G_FALSE,
144: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
145: p_return_status OUT nocopy VARCHAR2,
146: p_msg_count OUT nocopy NUMBER,
147: p_msg_data OUT nocopy VARCHAR2,
140: ( p_api_version_number IN NUMBER,
141: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
142: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
143: p_commit IN VARCHAR2 := FND_API.G_FALSE,
144: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
145: p_return_status OUT nocopy VARCHAR2,
146: p_msg_count OUT nocopy NUMBER,
147: p_msg_data OUT nocopy VARCHAR2,
148: p_user_id IN NUMBER,
145: p_return_status OUT nocopy VARCHAR2,
146: p_msg_count OUT nocopy NUMBER,
147: p_msg_data OUT nocopy VARCHAR2,
148: p_user_id IN NUMBER,
149: p_days_needed_by IN NUMBER := FND_API.G_MISS_NUM,
150: p_req_default_template IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_req_override_loc_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
152: p_req_override_req_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
153: p_last_updated_by IN NUMBER,
146: p_msg_count OUT nocopy NUMBER,
147: p_msg_data OUT nocopy VARCHAR2,
148: p_user_id IN NUMBER,
149: p_days_needed_by IN NUMBER := FND_API.G_MISS_NUM,
150: p_req_default_template IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_req_override_loc_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
152: p_req_override_req_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
153: p_last_updated_by IN NUMBER,
154: p_last_update_date IN DATE,
147: p_msg_data OUT nocopy VARCHAR2,
148: p_user_id IN NUMBER,
149: p_days_needed_by IN NUMBER := FND_API.G_MISS_NUM,
150: p_req_default_template IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_req_override_loc_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
152: p_req_override_req_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
153: p_last_updated_by IN NUMBER,
154: p_last_update_date IN DATE,
155: p_last_update_login IN NUMBER
148: p_user_id IN NUMBER,
149: p_days_needed_by IN NUMBER := FND_API.G_MISS_NUM,
150: p_req_default_template IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_req_override_loc_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
152: p_req_override_req_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
153: p_last_updated_by IN NUMBER,
154: p_last_update_date IN DATE,
155: p_last_update_login IN NUMBER
156: );
157:
158:
159: PROCEDURE Delete_Profile
160: ( p_api_version_number IN NUMBER,
161: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
162: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
163: p_commit IN VARCHAR2 := FND_API.G_FALSE,
164: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
165: p_return_status OUT nocopy VARCHAR2,
158:
159: PROCEDURE Delete_Profile
160: ( p_api_version_number IN NUMBER,
161: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
162: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
163: p_commit IN VARCHAR2 := FND_API.G_FALSE,
164: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
165: p_return_status OUT nocopy VARCHAR2,
166: p_msg_count OUT nocopy NUMBER,
159: PROCEDURE Delete_Profile
160: ( p_api_version_number IN NUMBER,
161: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
162: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
163: p_commit IN VARCHAR2 := FND_API.G_FALSE,
164: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
165: p_return_status OUT nocopy VARCHAR2,
166: p_msg_count OUT nocopy NUMBER,
167: p_msg_data OUT nocopy VARCHAR2,
160: ( p_api_version_number IN NUMBER,
161: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
162: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
163: p_commit IN VARCHAR2 := FND_API.G_FALSE,
164: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
165: p_return_status OUT nocopy VARCHAR2,
166: p_msg_count OUT nocopy NUMBER,
167: p_msg_data OUT nocopy VARCHAR2,
168: p_user_id IN NUMBER