DBA Data[Home] [Help]

APPS.IGS_SC_DATA_SEC_APIS_PKG dependencies on IGS_SC_GRANT_CONDS

Line 52: p_grant_id IN igs_sc_grant_conds.grant_id%TYPE,

48:
49: PROCEDURE Insert_Grant_Cond (p_api_version IN NUMBER,
50: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
51: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
52: p_grant_id IN igs_sc_grant_conds.grant_id%TYPE,
53: p_obj_attrib_id IN igs_sc_grant_conds.obj_attrib_id%TYPE,
54: p_user_attrib_id IN igs_sc_grant_conds.user_attrib_id%TYPE,
55: p_condition IN igs_sc_grant_conds.condition%TYPE,
56: p_text_value IN igs_sc_grant_conds.text_value%TYPE,

Line 53: p_obj_attrib_id IN igs_sc_grant_conds.obj_attrib_id%TYPE,

49: PROCEDURE Insert_Grant_Cond (p_api_version IN NUMBER,
50: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
51: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
52: p_grant_id IN igs_sc_grant_conds.grant_id%TYPE,
53: p_obj_attrib_id IN igs_sc_grant_conds.obj_attrib_id%TYPE,
54: p_user_attrib_id IN igs_sc_grant_conds.user_attrib_id%TYPE,
55: p_condition IN igs_sc_grant_conds.condition%TYPE,
56: p_text_value IN igs_sc_grant_conds.text_value%TYPE,
57: p_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE,

Line 54: p_user_attrib_id IN igs_sc_grant_conds.user_attrib_id%TYPE,

50: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
51: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
52: p_grant_id IN igs_sc_grant_conds.grant_id%TYPE,
53: p_obj_attrib_id IN igs_sc_grant_conds.obj_attrib_id%TYPE,
54: p_user_attrib_id IN igs_sc_grant_conds.user_attrib_id%TYPE,
55: p_condition IN igs_sc_grant_conds.condition%TYPE,
56: p_text_value IN igs_sc_grant_conds.text_value%TYPE,
57: p_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE,
58: x_return_status OUT NOCOPY VARCHAR2,

Line 55: p_condition IN igs_sc_grant_conds.condition%TYPE,

51: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
52: p_grant_id IN igs_sc_grant_conds.grant_id%TYPE,
53: p_obj_attrib_id IN igs_sc_grant_conds.obj_attrib_id%TYPE,
54: p_user_attrib_id IN igs_sc_grant_conds.user_attrib_id%TYPE,
55: p_condition IN igs_sc_grant_conds.condition%TYPE,
56: p_text_value IN igs_sc_grant_conds.text_value%TYPE,
57: p_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE,
58: x_return_status OUT NOCOPY VARCHAR2,
59: x_return_message OUT NOCOPY VARCHAR2

Line 56: p_text_value IN igs_sc_grant_conds.text_value%TYPE,

52: p_grant_id IN igs_sc_grant_conds.grant_id%TYPE,
53: p_obj_attrib_id IN igs_sc_grant_conds.obj_attrib_id%TYPE,
54: p_user_attrib_id IN igs_sc_grant_conds.user_attrib_id%TYPE,
55: p_condition IN igs_sc_grant_conds.condition%TYPE,
56: p_text_value IN igs_sc_grant_conds.text_value%TYPE,
57: p_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE,
58: x_return_status OUT NOCOPY VARCHAR2,
59: x_return_message OUT NOCOPY VARCHAR2
60: );

Line 57: p_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE,

53: p_obj_attrib_id IN igs_sc_grant_conds.obj_attrib_id%TYPE,
54: p_user_attrib_id IN igs_sc_grant_conds.user_attrib_id%TYPE,
55: p_condition IN igs_sc_grant_conds.condition%TYPE,
56: p_text_value IN igs_sc_grant_conds.text_value%TYPE,
57: p_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE,
58: x_return_status OUT NOCOPY VARCHAR2,
59: x_return_message OUT NOCOPY VARCHAR2
60: );
61:

Line 242: p_grant_id IN igs_sc_grant_conds.grant_id%TYPE,

238:
239: PROCEDURE Update_Grant_Cond (p_api_version IN NUMBER,
240: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
241: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
242: p_grant_id IN igs_sc_grant_conds.grant_id%TYPE,
243: p_obj_attrib_id IN igs_sc_grant_conds.obj_attrib_id%TYPE,
244: p_user_attrib_id IN igs_sc_grant_conds.user_attrib_id%TYPE,
245: p_condition IN igs_sc_grant_conds.condition%TYPE,
246: p_text_value IN igs_sc_grant_conds.text_value%TYPE,

Line 243: p_obj_attrib_id IN igs_sc_grant_conds.obj_attrib_id%TYPE,

239: PROCEDURE Update_Grant_Cond (p_api_version IN NUMBER,
240: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
241: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
242: p_grant_id IN igs_sc_grant_conds.grant_id%TYPE,
243: p_obj_attrib_id IN igs_sc_grant_conds.obj_attrib_id%TYPE,
244: p_user_attrib_id IN igs_sc_grant_conds.user_attrib_id%TYPE,
245: p_condition IN igs_sc_grant_conds.condition%TYPE,
246: p_text_value IN igs_sc_grant_conds.text_value%TYPE,
247: p_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE,

Line 244: p_user_attrib_id IN igs_sc_grant_conds.user_attrib_id%TYPE,

240: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
241: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
242: p_grant_id IN igs_sc_grant_conds.grant_id%TYPE,
243: p_obj_attrib_id IN igs_sc_grant_conds.obj_attrib_id%TYPE,
244: p_user_attrib_id IN igs_sc_grant_conds.user_attrib_id%TYPE,
245: p_condition IN igs_sc_grant_conds.condition%TYPE,
246: p_text_value IN igs_sc_grant_conds.text_value%TYPE,
247: p_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE,
248: p_old_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE DEFAULT 0,

Line 245: p_condition IN igs_sc_grant_conds.condition%TYPE,

241: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
242: p_grant_id IN igs_sc_grant_conds.grant_id%TYPE,
243: p_obj_attrib_id IN igs_sc_grant_conds.obj_attrib_id%TYPE,
244: p_user_attrib_id IN igs_sc_grant_conds.user_attrib_id%TYPE,
245: p_condition IN igs_sc_grant_conds.condition%TYPE,
246: p_text_value IN igs_sc_grant_conds.text_value%TYPE,
247: p_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE,
248: p_old_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE DEFAULT 0,
249: x_return_status OUT NOCOPY VARCHAR2,

Line 246: p_text_value IN igs_sc_grant_conds.text_value%TYPE,

242: p_grant_id IN igs_sc_grant_conds.grant_id%TYPE,
243: p_obj_attrib_id IN igs_sc_grant_conds.obj_attrib_id%TYPE,
244: p_user_attrib_id IN igs_sc_grant_conds.user_attrib_id%TYPE,
245: p_condition IN igs_sc_grant_conds.condition%TYPE,
246: p_text_value IN igs_sc_grant_conds.text_value%TYPE,
247: p_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE,
248: p_old_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE DEFAULT 0,
249: x_return_status OUT NOCOPY VARCHAR2,
250: x_return_message OUT NOCOPY VARCHAR2

Line 247: p_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE,

243: p_obj_attrib_id IN igs_sc_grant_conds.obj_attrib_id%TYPE,
244: p_user_attrib_id IN igs_sc_grant_conds.user_attrib_id%TYPE,
245: p_condition IN igs_sc_grant_conds.condition%TYPE,
246: p_text_value IN igs_sc_grant_conds.text_value%TYPE,
247: p_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE,
248: p_old_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE DEFAULT 0,
249: x_return_status OUT NOCOPY VARCHAR2,
250: x_return_message OUT NOCOPY VARCHAR2
251: );

Line 248: p_old_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE DEFAULT 0,

244: p_user_attrib_id IN igs_sc_grant_conds.user_attrib_id%TYPE,
245: p_condition IN igs_sc_grant_conds.condition%TYPE,
246: p_text_value IN igs_sc_grant_conds.text_value%TYPE,
247: p_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE,
248: p_old_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE DEFAULT 0,
249: x_return_status OUT NOCOPY VARCHAR2,
250: x_return_message OUT NOCOPY VARCHAR2
251: );
252:

Line 419: p_grant_id IN igs_sc_grant_conds.grant_id%TYPE,

415:
416: PROCEDURE Delete_Grant_Cond (p_api_version IN NUMBER,
417: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
418: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
419: p_grant_id IN igs_sc_grant_conds.grant_id%TYPE,
420: p_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE,
421: x_return_status OUT NOCOPY VARCHAR2,
422: x_return_message OUT NOCOPY VARCHAR2
423: );

Line 420: p_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE,

416: PROCEDURE Delete_Grant_Cond (p_api_version IN NUMBER,
417: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
418: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
419: p_grant_id IN igs_sc_grant_conds.grant_id%TYPE,
420: p_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE,
421: x_return_status OUT NOCOPY VARCHAR2,
422: x_return_message OUT NOCOPY VARCHAR2
423: );
424: