eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PE_VAL_PIGM dependencies on IGS_PE_PRSID_GRP_SEC

Line 30: -- IGS_PE_PRSID_GRP_SEC table with the insert, update and delete

26: -- IGS_PE_PRSID_GRP_MEM records for the IGS_PE_PERSID_GROUP specified by the
27: -- group_id. The application owner has full permissions. The IGS_PE_PERSID_GROUP
28: -- creator identified by IGS_PE_PERSID_GROUP.creator_person_id also has full
29: -- permissions. Any other users must have a record in the
30: -- IGS_PE_PRSID_GRP_SEC table with the insert, update and delete
31: -- permissions specified.
32: DECLARE
33: cst_person_id_group CONSTANT
34: user_synonyms.synonym_name%TYPE := 'IGS_PE_PERSID_GROUP';

Line 40: v_insert_ind IGS_PE_PRSID_GRP_SEC.insert_ind%TYPE;

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;
43:
44: --skpandey, Bug#4937960: Changed c_pig cursor definition to optimize query

Line 41: v_update_ind IGS_PE_PRSID_GRP_SEC.update_ind%TYPE;

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;
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

Line 42: v_delete_ind IGS_PE_PRSID_GRP_SEC.delete_ind%TYPE;

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;
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

Line 53: CURSOR c_pigs(cp_group_id IGS_PE_PRSID_GRP_SEC.group_id%TYPE) IS

49: AND pig.creator_person_id = pe.party_id
50: AND pe.oracle_username = fnd_global.user_name;
51:
52: --skpandey, Bug#4937960: Changed c_pigs cursor definition to optimize query
53: CURSOR c_pigs(cp_group_id IGS_PE_PRSID_GRP_SEC.group_id%TYPE) IS
54: SELECT pigs.insert_ind,
55: pigs.update_ind,
56: pigs.delete_ind
57: FROM IGS_PE_PRSID_GRP_SEC pigs,

Line 57: FROM IGS_PE_PRSID_GRP_SEC pigs,

53: CURSOR c_pigs(cp_group_id IGS_PE_PRSID_GRP_SEC.group_id%TYPE) IS
54: SELECT pigs.insert_ind,
55: pigs.update_ind,
56: pigs.delete_ind
57: FROM IGS_PE_PRSID_GRP_SEC pigs,
58: IGS_PE_HZ_PARTIES pe
59: WHERE pigs.group_id = cp_group_id
60: AND pigs.person_id = pe.party_id
61: AND pe.oracle_username = fnd_global.user_name;