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,
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,
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,
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
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: );
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:
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,
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,
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,
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,
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
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: );
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:
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: );
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: