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_SC_GEN_001 dependencies on FND_DSQL

Line 241: fnd_dsql.init;

237: lv_obj_constant varchar2(4000);
238:
239: BEGIN
240:
241: fnd_dsql.init;
242:
243: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
244: l_label := 'igs.plsql.igs_sc_gen_001.check_ins_security';
245: l_debug_str := P_ATTRIB_TAB.ADVISOR||','||

Line 282: fnd_dsql.add_text('SELECT 1 FROM DUAL WHERE ');

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.
285: FOR grants_rec IN c_get_grant(p_object_name,l_user_id)
286: LOOP

Line 753: fnd_dsql.add_text(' OR ');

749:
750: IF l_found_pos >1 THEN
751: --IF l_statment IS NOT NULL THEN -- not first grant, we need to add OR
752: --l_statment := l_statment||' OR ';
753: fnd_dsql.add_text(' OR ');
754: --END IF;
755: END IF;
756:
757: LOOP

Line 769: fnd_dsql.add_text('1 = 1');

765: END IF;
766:
767: --added by mmkumar
768: IF l_grant_cond(l_cur_num).z_typ_flag = 'Z' AND onlyZTypeAttributes THEN
769: fnd_dsql.add_text('1 = 1');
770: --l_statment := l_statment || '1 = 1';
771: EXIT;
772: END IF;
773: --added by mmkumar

Line 779: fnd_dsql.add_text(SUBSTR(l_bodmas_grant_text,l_cur_pos, (l_found_pos - l_cur_pos)));

775: -- Find number of predicate - total numbers is limited to 9 so far.
776:
777: l_cur_num := SUBSTR(l_bodmas_grant_text,l_found_pos+1,1); --Just one character
778: --l_statment := l_statment||SUBSTR(grants_rec.grant_text,l_cur_pos, (l_found_pos - l_cur_pos));
779: fnd_dsql.add_text(SUBSTR(l_bodmas_grant_text,l_cur_pos, (l_found_pos - l_cur_pos)));
780: -- Add condition from found grant number to statement
781: --l_statment := l_statment || l_grant_cond(l_cur_num).cond_text;
782: fnd_dsql.add_text(l_grant_cond(l_cur_num).cond_text);
783:

Line 782: fnd_dsql.add_text(l_grant_cond(l_cur_num).cond_text);

778: --l_statment := l_statment||SUBSTR(grants_rec.grant_text,l_cur_pos, (l_found_pos - l_cur_pos));
779: fnd_dsql.add_text(SUBSTR(l_bodmas_grant_text,l_cur_pos, (l_found_pos - l_cur_pos)));
780: -- Add condition from found grant number to statement
781: --l_statment := l_statment || l_grant_cond(l_cur_num).cond_text;
782: fnd_dsql.add_text(l_grant_cond(l_cur_num).cond_text);
783:
784: if l_grant_cond(l_cur_num).obj_const is not null then
785:
786: lv_obj_constant := l_grant_cond(l_cur_num).obj_const;

Line 790: fnd_dsql.add_bind(l_grant_cond(l_cur_num).obj_const);

786: lv_obj_constant := l_grant_cond(l_cur_num).obj_const;
787: l_grant_cond(l_cur_num).obj_const := replace(l_grant_cond(l_cur_num).obj_const,'''','');
788:
789:
790: fnd_dsql.add_bind(l_grant_cond(l_cur_num).obj_const);
791: fnd_dsql.add_text(l_grant_cond(l_cur_num).close_part);
792: end if;
793:
794: l_cur_pos := l_found_pos + 2;

Line 791: fnd_dsql.add_text(l_grant_cond(l_cur_num).close_part);

787: l_grant_cond(l_cur_num).obj_const := replace(l_grant_cond(l_cur_num).obj_const,'''','');
788:
789:
790: fnd_dsql.add_bind(l_grant_cond(l_cur_num).obj_const);
791: fnd_dsql.add_text(l_grant_cond(l_cur_num).close_part);
792: end if;
793:
794: l_cur_pos := l_found_pos + 2;
795:

Line 806: fnd_dsql.add_text(substr(l_bodmas_grant_text,l_cur_pos));

802:
803: -- Add last part of condition
804: IF NOT (l_grant_cond(l_cur_num).z_typ_flag = 'Z' AND onlyZTypeAttributes) THEN
805: --l_statment := l_statment||substr(grants_rec.grant_text,l_cur_pos);
806: fnd_dsql.add_text(substr(l_bodmas_grant_text,l_cur_pos));
807: END IF;
808: --** Statement level logging.
809: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
810: l_label := 'igs.plsql.igs_sc_gen_001.check_ins_security';

Line 811: l_debug_str := 'Final Select: '|| fnd_dsql.get_text(); --l_statment;

807: END IF;
808: --** Statement level logging.
809: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
810: l_label := 'igs.plsql.igs_sc_gen_001.check_ins_security';
811: l_debug_str := 'Final Select: '|| fnd_dsql.get_text(); --l_statment;
812: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
813: END IF;
814: --**
815: ---now evaluate the grant, as this is pre-evaulation

Line 818: l_SelectStatement := fnd_dsql.get_text(FALSE);

814: --**
815: ---now evaluate the grant, as this is pre-evaulation
816: BEGIN
817: l_val :=0;
818: l_SelectStatement := fnd_dsql.get_text(FALSE);
819:
820: --** Statement level logging.
821: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
822: l_label := 'igs.plsql.igs_sc_gen_001.check_ins_security';

Line 829: fnd_dsql.set_cursor(l_ext_cursor);

825: END IF;
826: --**
827:
828: l_ext_cursor := DBMS_SQL.OPEN_CURSOR;
829: fnd_dsql.set_cursor(l_ext_cursor);
830: DBMS_SQL.PARSE (l_ext_cursor, l_SelectStatement, DBMS_SQL.V7);
831: fnd_dsql.do_binds;
832: dbms_sql.define_column(l_ext_cursor, 1, l_output);
833: lnRows := DBMS_SQL.EXECUTE (l_ext_cursor);

Line 831: fnd_dsql.do_binds;

827:
828: l_ext_cursor := DBMS_SQL.OPEN_CURSOR;
829: fnd_dsql.set_cursor(l_ext_cursor);
830: DBMS_SQL.PARSE (l_ext_cursor, l_SelectStatement, DBMS_SQL.V7);
831: fnd_dsql.do_binds;
832: dbms_sql.define_column(l_ext_cursor, 1, l_output);
833: lnRows := DBMS_SQL.EXECUTE (l_ext_cursor);
834: IF dbms_sql.fetch_rows(l_ext_cursor) > 0 THEN
835: dbms_sql.column_value(l_ext_cursor, 1, l_output);