276: P_ATTRIB_TAB.OTHER_UNIT_MODE;
277: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
278: END IF;
279:
280: l_user_id := FND_GLOBAL.USER_ID;
281: --l_statment := 'SELECT 1 FROM DUAL WHERE ';
282: fnd_dsql.add_text('SELECT 1 FROM DUAL WHERE ');
283:
284: -- For the object, pick up all the grants.
936: BEGIN
937:
938: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
939: l_label := 'igs.plsql.igs_sc_gen_001.set_ctx';
940: l_debug_str := 'Context set User ID: '||FND_GLOBAL.USER_ID||','||'Responsibility ID'||FND_GLOBAL.RESP_ID;
941: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
942: END IF;
943:
944: IF(SYS_CONTEXT('OSS_APP_CTX','SECURITY') IS NULL) THEN
959: ------------------------------------------------------------------
960: BEGIN
961: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
962: l_label := 'igs.plsql.igs_sc_gen_001.unset_ctx';
963: l_debug_str := 'Context UNset User ID: '||FND_GLOBAL.USER_ID||','||'Responsibility ID'||FND_GLOBAL.RESP_ID;
964: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
965: END IF;
966:
967: IF(SYS_CONTEXT('OSS_APP_CTX','SECURITY') IS NOT NULL) THEN
1274: BEGIN
1275:
1276: -- get logged in USER
1277: IF p_user_id IS NULL THEN
1278: l_user_id := FND_GLOBAL.USER_ID;
1279: ELSE
1280: l_user_id := p_user_id;
1281: END IF;
1282: