[Home] [Help]
162: SELECT gr.grant_id ,
163: obj.object_id,
164: obj.obj_group_id ,
165: gr.grant_text
166: FROM igs_sc_grants gr,
167: igs_sc_objects obj,
168: fnd_objects fnd,
169: wf_local_user_roles rls
170: WHERE gr.grant_insert_flag='Y'
722: END IF;
723: l_cur_pos := l_found_pos + 2;
724: END LOOP;
725:
726: l_bodmas_grant_text := IGS_SC_GRANTS_PVT.getBodmasCondition(l_grant_text);
727:
728: --** Statement level logging.
729: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
730: l_label := 'igs.plsql.igs_sc_gen_001.check_ins_security';
1026:
1027: EXECUTE IMMEDIATE l_obj_exists_cur INTO l_obj_found USING P_Tab_Name;
1028: IF l_obj_found IS NOT NULL THEN
1029: --get the main security predicate clause
1030: L_WHERE_CLAUSE := IGS_SC_GRANTS_PVT.GENERATE_GRANT(P_Tab_name, P_Action );
1031: ELSE
1032: FND_MESSAGE.SET_NAME('IGS','IGS_SC_TAB_NOT_REG');
1033: FND_MESSAGE.SET_TOKEN('OPERATION',l_operation);
1034: p_msg_data := fnd_message.get;
1034: p_msg_data := fnd_message.get;
1035: RETURN FALSE;
1036: END IF;
1037: ELSE
1038: L_WHERE_CLAUSE := IGS_SC_GRANTS_PVT.GENERATE_GRANT(P_Tab_name, P_Action );
1039: END IF;
1040:
1041: --** Statement level logging.
1042: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1139: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1140: END IF;
1141: --**
1142: CLOSE rowid_cv;
1143: L_WHERE_CLAUSE := IGS_SC_GRANTS_PVT.GENERATE_GRANT(P_Table_Name, P_Action );
1144:
1145: --** Statement level logging.
1146: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1147: l_label := 'igs.plsql.igs_sc_gen_001.check_person_security';
1263: WHERE obj_group_name = cp_bo_name;
1264:
1265: CURSOR c_policy (cp_role_id NUMBER, cp_bo_id NUMBER) IS
1266: SELECT grant_id,locked_flag ,grant_select_flag,grant_update_flag,grant_insert_flag,grant_delete_flag
1267: FROM IGS_SC_GRANTS
1268: WHERE user_group_id = cp_role_id
1269: AND obj_group_id =cp_bo_id
1270: AND locked_flag= 'Y';
1271: