[Home] [Help]
15: --sarakshi 27-sep-2001 Added function merged_ind as a part of person Detail build.bug no:2000408
16: ----------------------------------------------------------------------------------------------
17: -- Validate IGS_PE_PERSON id group member ins/upd/del security
18: FUNCTION idgp_val_pigm_iud(
19: p_group_id IN IGS_PE_PERSID_GROUP_ALL.group_id%TYPE ,
20: p_transaction_type IN VARCHAR2 ,
21: p_message_name OUT NOCOPY VARCHAR2 )
22: RETURN BOOLEAN IS
23: gv_other_detail VARCHAR2(255);
34: user_synonyms.synonym_name%TYPE := 'IGS_PE_PERSID_GROUP';
35: cst_insert CONSTANT VARCHAR2(10) := 'INSERT';
36: cst_update CONSTANT VARCHAR2(10) := 'UPDATE';
37: cst_delete CONSTANT VARCHAR2(10) := 'DELETE';
38: v_dummy IGS_PE_PERSID_GROUP_ALL.creator_person_id%TYPE;
39: v_user VARCHAR2(30);
40: v_insert_ind IGS_PE_PRSID_GRP_SEC.insert_ind%TYPE;
41: v_update_ind IGS_PE_PRSID_GRP_SEC.update_ind%TYPE;
42: v_delete_ind IGS_PE_PRSID_GRP_SEC.delete_ind%TYPE;
41: v_update_ind IGS_PE_PRSID_GRP_SEC.update_ind%TYPE;
42: v_delete_ind IGS_PE_PRSID_GRP_SEC.delete_ind%TYPE;
43:
44: --skpandey, Bug#4937960: Changed c_pig cursor definition to optimize query
45: CURSOR c_pig(cp_group_id IGS_PE_PERSID_GROUP_ALL.group_id%TYPE) IS
46: SELECT pig.creator_person_id
47: FROM IGS_PE_PERSID_GROUP_ALL pig, igs_pe_hz_parties pe
48: WHERE pig.group_id = cp_group_id
49: AND pig.creator_person_id = pe.party_id
43:
44: --skpandey, Bug#4937960: Changed c_pig cursor definition to optimize query
45: CURSOR c_pig(cp_group_id IGS_PE_PERSID_GROUP_ALL.group_id%TYPE) IS
46: SELECT pig.creator_person_id
47: FROM IGS_PE_PERSID_GROUP_ALL pig, igs_pe_hz_parties pe
48: WHERE pig.group_id = cp_group_id
49: AND pig.creator_person_id = pe.party_id
50: AND pe.oracle_username = fnd_global.user_name;
51: