DBA Data[Home] [Help]

APPS.IGS_SC_DATA_SEC_APIS_PKG dependencies on IGS_SC_USR_ATTRIBS

Line 137: p_user_attrib_id IN OUT NOCOPY igs_sc_usr_attribs.user_attrib_id%TYPE,

133:
134: PROCEDURE Insert_User_Attr (p_api_version IN NUMBER,
135: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
136: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
137: p_user_attrib_id IN OUT NOCOPY igs_sc_usr_attribs.user_attrib_id%TYPE,
138: p_user_attrib_name IN igs_sc_usr_attribs.user_attrib_name%TYPE,
139: p_user_attrib_type IN igs_sc_usr_attribs.user_attrib_type%TYPE,
140: p_static_type IN igs_sc_usr_attribs.static_type%TYPE,
141: p_select_text IN igs_sc_usr_attribs.select_text%TYPE,

Line 138: p_user_attrib_name IN igs_sc_usr_attribs.user_attrib_name%TYPE,

134: PROCEDURE Insert_User_Attr (p_api_version IN NUMBER,
135: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
136: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
137: p_user_attrib_id IN OUT NOCOPY igs_sc_usr_attribs.user_attrib_id%TYPE,
138: p_user_attrib_name IN igs_sc_usr_attribs.user_attrib_name%TYPE,
139: p_user_attrib_type IN igs_sc_usr_attribs.user_attrib_type%TYPE,
140: p_static_type IN igs_sc_usr_attribs.static_type%TYPE,
141: p_select_text IN igs_sc_usr_attribs.select_text%TYPE,
142: p_active_flag IN VARCHAR2 DEFAULT 'Y',

Line 139: p_user_attrib_type IN igs_sc_usr_attribs.user_attrib_type%TYPE,

135: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
136: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
137: p_user_attrib_id IN OUT NOCOPY igs_sc_usr_attribs.user_attrib_id%TYPE,
138: p_user_attrib_name IN igs_sc_usr_attribs.user_attrib_name%TYPE,
139: p_user_attrib_type IN igs_sc_usr_attribs.user_attrib_type%TYPE,
140: p_static_type IN igs_sc_usr_attribs.static_type%TYPE,
141: p_select_text IN igs_sc_usr_attribs.select_text%TYPE,
142: p_active_flag IN VARCHAR2 DEFAULT 'Y',
143: x_return_status OUT NOCOPY VARCHAR2,

Line 140: p_static_type IN igs_sc_usr_attribs.static_type%TYPE,

136: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
137: p_user_attrib_id IN OUT NOCOPY igs_sc_usr_attribs.user_attrib_id%TYPE,
138: p_user_attrib_name IN igs_sc_usr_attribs.user_attrib_name%TYPE,
139: p_user_attrib_type IN igs_sc_usr_attribs.user_attrib_type%TYPE,
140: p_static_type IN igs_sc_usr_attribs.static_type%TYPE,
141: p_select_text IN igs_sc_usr_attribs.select_text%TYPE,
142: p_active_flag IN VARCHAR2 DEFAULT 'Y',
143: x_return_status OUT NOCOPY VARCHAR2,
144: x_return_message OUT NOCOPY VARCHAR2

Line 141: p_select_text IN igs_sc_usr_attribs.select_text%TYPE,

137: p_user_attrib_id IN OUT NOCOPY igs_sc_usr_attribs.user_attrib_id%TYPE,
138: p_user_attrib_name IN igs_sc_usr_attribs.user_attrib_name%TYPE,
139: p_user_attrib_type IN igs_sc_usr_attribs.user_attrib_type%TYPE,
140: p_static_type IN igs_sc_usr_attribs.static_type%TYPE,
141: p_select_text IN igs_sc_usr_attribs.select_text%TYPE,
142: p_active_flag IN VARCHAR2 DEFAULT 'Y',
143: x_return_status OUT NOCOPY VARCHAR2,
144: x_return_message OUT NOCOPY VARCHAR2
145: );

Line 301: p_user_attrib_id IN igs_sc_usr_attribs.user_attrib_id%TYPE,

297:
298: PROCEDURE Update_User_Attr (p_api_version IN NUMBER,
299: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
300: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
301: p_user_attrib_id IN igs_sc_usr_attribs.user_attrib_id%TYPE,
302: p_user_attrib_name IN igs_sc_usr_attribs.user_attrib_name%TYPE,
303: p_user_attrib_type IN igs_sc_usr_attribs.user_attrib_type%TYPE,
304: p_static_type IN igs_sc_usr_attribs.static_type%TYPE,
305: p_select_text IN igs_sc_usr_attribs.select_text%TYPE,

Line 302: p_user_attrib_name IN igs_sc_usr_attribs.user_attrib_name%TYPE,

298: PROCEDURE Update_User_Attr (p_api_version IN NUMBER,
299: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
300: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
301: p_user_attrib_id IN igs_sc_usr_attribs.user_attrib_id%TYPE,
302: p_user_attrib_name IN igs_sc_usr_attribs.user_attrib_name%TYPE,
303: p_user_attrib_type IN igs_sc_usr_attribs.user_attrib_type%TYPE,
304: p_static_type IN igs_sc_usr_attribs.static_type%TYPE,
305: p_select_text IN igs_sc_usr_attribs.select_text%TYPE,
306: p_active_flag IN igs_sc_usr_attribs.active_flag%TYPE,

Line 303: p_user_attrib_type IN igs_sc_usr_attribs.user_attrib_type%TYPE,

299: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
300: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
301: p_user_attrib_id IN igs_sc_usr_attribs.user_attrib_id%TYPE,
302: p_user_attrib_name IN igs_sc_usr_attribs.user_attrib_name%TYPE,
303: p_user_attrib_type IN igs_sc_usr_attribs.user_attrib_type%TYPE,
304: p_static_type IN igs_sc_usr_attribs.static_type%TYPE,
305: p_select_text IN igs_sc_usr_attribs.select_text%TYPE,
306: p_active_flag IN igs_sc_usr_attribs.active_flag%TYPE,
307: x_return_status OUT NOCOPY VARCHAR2,

Line 304: p_static_type IN igs_sc_usr_attribs.static_type%TYPE,

300: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
301: p_user_attrib_id IN igs_sc_usr_attribs.user_attrib_id%TYPE,
302: p_user_attrib_name IN igs_sc_usr_attribs.user_attrib_name%TYPE,
303: p_user_attrib_type IN igs_sc_usr_attribs.user_attrib_type%TYPE,
304: p_static_type IN igs_sc_usr_attribs.static_type%TYPE,
305: p_select_text IN igs_sc_usr_attribs.select_text%TYPE,
306: p_active_flag IN igs_sc_usr_attribs.active_flag%TYPE,
307: x_return_status OUT NOCOPY VARCHAR2,
308: x_return_message OUT NOCOPY VARCHAR2

Line 305: p_select_text IN igs_sc_usr_attribs.select_text%TYPE,

301: p_user_attrib_id IN igs_sc_usr_attribs.user_attrib_id%TYPE,
302: p_user_attrib_name IN igs_sc_usr_attribs.user_attrib_name%TYPE,
303: p_user_attrib_type IN igs_sc_usr_attribs.user_attrib_type%TYPE,
304: p_static_type IN igs_sc_usr_attribs.static_type%TYPE,
305: p_select_text IN igs_sc_usr_attribs.select_text%TYPE,
306: p_active_flag IN igs_sc_usr_attribs.active_flag%TYPE,
307: x_return_status OUT NOCOPY VARCHAR2,
308: x_return_message OUT NOCOPY VARCHAR2
309: );

Line 306: p_active_flag IN igs_sc_usr_attribs.active_flag%TYPE,

302: p_user_attrib_name IN igs_sc_usr_attribs.user_attrib_name%TYPE,
303: p_user_attrib_type IN igs_sc_usr_attribs.user_attrib_type%TYPE,
304: p_static_type IN igs_sc_usr_attribs.static_type%TYPE,
305: p_select_text IN igs_sc_usr_attribs.select_text%TYPE,
306: p_active_flag IN igs_sc_usr_attribs.active_flag%TYPE,
307: x_return_status OUT NOCOPY VARCHAR2,
308: x_return_message OUT NOCOPY VARCHAR2
309: );
310:

Line 394: p_user_attrib_id IN igs_sc_usr_attribs.user_attrib_id%TYPE,

390:
391: PROCEDURE Delete_User_Attr (p_api_version IN NUMBER,
392: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
393: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
394: p_user_attrib_id IN igs_sc_usr_attribs.user_attrib_id%TYPE,
395: x_return_status OUT NOCOPY VARCHAR2,
396: x_return_message OUT NOCOPY VARCHAR2
397: );
398:

Line 402: p_user_attrib_id IN igs_sc_usr_attribs.user_attrib_id%TYPE,

398:
399: PROCEDURE Delete_User_Attr_Val (p_api_version IN NUMBER,
400: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
401: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
402: p_user_attrib_id IN igs_sc_usr_attribs.user_attrib_id%TYPE,
403: p_user_id IN NUMBER,
404: x_return_status OUT NOCOPY VARCHAR2,
405: x_return_message OUT NOCOPY VARCHAR2
406: );