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

Line 691: --vskumar 24-May-2006 xbuild3 performance fix. added a calander type parse code and used fnd_dsql.

687: --
688: --Change History:
689: --Who When What
690: --KUMMA 13-may-2003 2941138, Replaced p_alternate_code with the bind variable
691: --vskumar 24-May-2006 xbuild3 performance fix. added a calander type parse code and used fnd_dsql.
692: ------------------------------------------------------------------ */
693: PROCEDURE get_calendar_instance(
694: p_alternate_cd IN VARCHAR2,
695: p_s_cal_category IN VARCHAR2,

Line 753: fnd_dsql.init;

749: p_ci_sequence_number := NULL;
750: p_start_dt := TO_DATE(NULL);
751: p_end_dt := TO_DATE(NULL);
752:
753: fnd_dsql.init;
754: curr_pos_lv := 1;
755: next_pos_lv := 1;
756:
757: -- Query to get the count of calendar instances for the given alternate code and calendar categories

Line 759: fnd_dsql.add_text('SELECT ci.cal_type,ci.sequence_number,ci.start_dt,ci.end_dt FROM igs_ca_inst_all ci, igs_ca_type ct WHERE alternate_code =');

755: next_pos_lv := 1;
756:
757: -- Query to get the count of calendar instances for the given alternate code and calendar categories
758:
759: fnd_dsql.add_text('SELECT ci.cal_type,ci.sequence_number,ci.start_dt,ci.end_dt FROM igs_ca_inst_all ci, igs_ca_type ct WHERE alternate_code =');
760: fnd_dsql.add_bind(p_alternate_cd);
761: fnd_dsql.add_text(' AND ci.cal_type = ct.cal_type AND ct.s_cal_cat IN (');
762:
763: LOOP

Line 760: fnd_dsql.add_bind(p_alternate_cd);

756:
757: -- Query to get the count of calendar instances for the given alternate code and calendar categories
758:
759: fnd_dsql.add_text('SELECT ci.cal_type,ci.sequence_number,ci.start_dt,ci.end_dt FROM igs_ca_inst_all ci, igs_ca_type ct WHERE alternate_code =');
760: fnd_dsql.add_bind(p_alternate_cd);
761: fnd_dsql.add_text(' AND ci.cal_type = ct.cal_type AND ct.s_cal_cat IN (');
762:
763: LOOP
764: next_pos_lv := INSTR(l_p_s_cal_category, ',', curr_pos_lv);

Line 761: fnd_dsql.add_text(' AND ci.cal_type = ct.cal_type AND ct.s_cal_cat IN (');

757: -- Query to get the count of calendar instances for the given alternate code and calendar categories
758:
759: fnd_dsql.add_text('SELECT ci.cal_type,ci.sequence_number,ci.start_dt,ci.end_dt FROM igs_ca_inst_all ci, igs_ca_type ct WHERE alternate_code =');
760: fnd_dsql.add_bind(p_alternate_cd);
761: fnd_dsql.add_text(' AND ci.cal_type = ct.cal_type AND ct.s_cal_cat IN (');
762:
763: LOOP
764: next_pos_lv := INSTR(l_p_s_cal_category, ',', curr_pos_lv);
765: IF next_pos_lv = 0 THEN

Line 767: fnd_dsql.add_bind(token_lv);

763: LOOP
764: next_pos_lv := INSTR(l_p_s_cal_category, ',', curr_pos_lv);
765: IF next_pos_lv = 0 THEN
766: token_lv := SUBSTR(l_p_s_cal_category,curr_pos_lv);
767: fnd_dsql.add_bind(token_lv);
768: fnd_dsql.add_text(')');
769: EXIT;
770: END IF;
771: token_lv := SUBSTR(l_p_s_cal_category, curr_pos_lv, next_pos_lv-curr_pos_lv);

Line 768: fnd_dsql.add_text(')');

764: next_pos_lv := INSTR(l_p_s_cal_category, ',', curr_pos_lv);
765: IF next_pos_lv = 0 THEN
766: token_lv := SUBSTR(l_p_s_cal_category,curr_pos_lv);
767: fnd_dsql.add_bind(token_lv);
768: fnd_dsql.add_text(')');
769: EXIT;
770: END IF;
771: token_lv := SUBSTR(l_p_s_cal_category, curr_pos_lv, next_pos_lv-curr_pos_lv);
772: fnd_dsql.add_bind(token_lv);

Line 772: fnd_dsql.add_bind(token_lv);

768: fnd_dsql.add_text(')');
769: EXIT;
770: END IF;
771: token_lv := SUBSTR(l_p_s_cal_category, curr_pos_lv, next_pos_lv-curr_pos_lv);
772: fnd_dsql.add_bind(token_lv);
773: fnd_dsql.add_text(',');
774: curr_pos_lv := next_pos_lv + 1;
775: END LOOP;
776:

Line 773: fnd_dsql.add_text(',');

769: EXIT;
770: END IF;
771: token_lv := SUBSTR(l_p_s_cal_category, curr_pos_lv, next_pos_lv-curr_pos_lv);
772: fnd_dsql.add_bind(token_lv);
773: fnd_dsql.add_text(',');
774: curr_pos_lv := next_pos_lv + 1;
775: END LOOP;
776:
777: l_cal_cat_cnt_query := fnd_dsql.get_text(FALSE);

Line 777: l_cal_cat_cnt_query := fnd_dsql.get_text(FALSE);

773: fnd_dsql.add_text(',');
774: curr_pos_lv := next_pos_lv + 1;
775: END LOOP;
776:
777: l_cal_cat_cnt_query := fnd_dsql.get_text(FALSE);
778:
779: l_cursor_id := dbms_sql.open_cursor;
780: fnd_dsql.set_cursor(l_cursor_id);
781: dbms_sql.parse(l_cursor_id, l_cal_cat_cnt_query, dbms_sql.native);

Line 780: fnd_dsql.set_cursor(l_cursor_id);

776:
777: l_cal_cat_cnt_query := fnd_dsql.get_text(FALSE);
778:
779: l_cursor_id := dbms_sql.open_cursor;
780: fnd_dsql.set_cursor(l_cursor_id);
781: dbms_sql.parse(l_cursor_id, l_cal_cat_cnt_query, dbms_sql.native);
782: fnd_dsql.do_binds;
783:
784: dbms_sql.define_column(l_cursor_id, 1, p_cal_type,10);

Line 782: fnd_dsql.do_binds;

778:
779: l_cursor_id := dbms_sql.open_cursor;
780: fnd_dsql.set_cursor(l_cursor_id);
781: dbms_sql.parse(l_cursor_id, l_cal_cat_cnt_query, dbms_sql.native);
782: fnd_dsql.do_binds;
783:
784: dbms_sql.define_column(l_cursor_id, 1, p_cal_type,10);
785: dbms_sql.define_column(l_cursor_id, 2, p_ci_sequence_number);
786: dbms_sql.define_column(l_cursor_id, 3, p_start_dt);