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.CS_TP_QUESTIONS_PVT dependencies on DBMS_SQL

Line 617: l_CursorID := dbms_sql.open_cursor;

613: l_statement := l_statement || ' ORDER BY LAST_UPDATE_DATE desc ';
614: else
615: l_statement := l_statement || ' ORDER BY TQ.SEQUENCE_NUMBER ';
616: end if;
617: l_CursorID := dbms_sql.open_cursor;
618:
619: /*
620: IF (FND_API.To_Boolean (DEBUG)) then
621: dbms_output.put_line ('Statement is ' || substr (l_statement, 1, 200));

Line 626: dbms_sql.parse(l_CursorID, l_statement, dbms_sql.NATIVE);

622: dbms_output.put_line ( substr (l_statement, 201, 400));
623: end if;
624: */
625:
626: dbms_sql.parse(l_CursorID, l_statement, dbms_sql.NATIVE);
627:
628: dbms_sql.bind_variable(l_CursorID, 'v_Template_ID', P_Template_ID);
629:
630: dbms_sql.define_column(l_CursorID, 1, L_QUESTION_ID);

Line 628: dbms_sql.bind_variable(l_CursorID, 'v_Template_ID', P_Template_ID);

624: */
625:
626: dbms_sql.parse(l_CursorID, l_statement, dbms_sql.NATIVE);
627:
628: dbms_sql.bind_variable(l_CursorID, 'v_Template_ID', P_Template_ID);
629:
630: dbms_sql.define_column(l_CursorID, 1, L_QUESTION_ID);
631: dbms_sql.define_column(l_CursorID, 2, L_QUESTION_NAME,2000);
632: dbms_sql.define_column(l_CursorID, 3, L_ANSWER_TYPE, 60);

Line 630: dbms_sql.define_column(l_CursorID, 1, L_QUESTION_ID);

626: dbms_sql.parse(l_CursorID, l_statement, dbms_sql.NATIVE);
627:
628: dbms_sql.bind_variable(l_CursorID, 'v_Template_ID', P_Template_ID);
629:
630: dbms_sql.define_column(l_CursorID, 1, L_QUESTION_ID);
631: dbms_sql.define_column(l_CursorID, 2, L_QUESTION_NAME,2000);
632: dbms_sql.define_column(l_CursorID, 3, L_ANSWER_TYPE, 60);
633: dbms_sql.define_column(l_CursorID, 4, L_MANDATORY_FLAG, 60 );
634: dbms_sql.define_column(l_CursorID, 5, L_SCORING_FLAG, 60);

Line 631: dbms_sql.define_column(l_CursorID, 2, L_QUESTION_NAME,2000);

627:
628: dbms_sql.bind_variable(l_CursorID, 'v_Template_ID', P_Template_ID);
629:
630: dbms_sql.define_column(l_CursorID, 1, L_QUESTION_ID);
631: dbms_sql.define_column(l_CursorID, 2, L_QUESTION_NAME,2000);
632: dbms_sql.define_column(l_CursorID, 3, L_ANSWER_TYPE, 60);
633: dbms_sql.define_column(l_CursorID, 4, L_MANDATORY_FLAG, 60 );
634: dbms_sql.define_column(l_CursorID, 5, L_SCORING_FLAG, 60);
635: dbms_sql.define_column(l_CursorID, 6, L_LOOKUP_ID);

Line 632: dbms_sql.define_column(l_CursorID, 3, L_ANSWER_TYPE, 60);

628: dbms_sql.bind_variable(l_CursorID, 'v_Template_ID', P_Template_ID);
629:
630: dbms_sql.define_column(l_CursorID, 1, L_QUESTION_ID);
631: dbms_sql.define_column(l_CursorID, 2, L_QUESTION_NAME,2000);
632: dbms_sql.define_column(l_CursorID, 3, L_ANSWER_TYPE, 60);
633: dbms_sql.define_column(l_CursorID, 4, L_MANDATORY_FLAG, 60 );
634: dbms_sql.define_column(l_CursorID, 5, L_SCORING_FLAG, 60);
635: dbms_sql.define_column(l_CursorID, 6, L_LOOKUP_ID);
636: dbms_sql.define_column(l_CursorID, 7, L_LAST_UPDATED_DATE);

Line 633: dbms_sql.define_column(l_CursorID, 4, L_MANDATORY_FLAG, 60 );

629:
630: dbms_sql.define_column(l_CursorID, 1, L_QUESTION_ID);
631: dbms_sql.define_column(l_CursorID, 2, L_QUESTION_NAME,2000);
632: dbms_sql.define_column(l_CursorID, 3, L_ANSWER_TYPE, 60);
633: dbms_sql.define_column(l_CursorID, 4, L_MANDATORY_FLAG, 60 );
634: dbms_sql.define_column(l_CursorID, 5, L_SCORING_FLAG, 60);
635: dbms_sql.define_column(l_CursorID, 6, L_LOOKUP_ID);
636: dbms_sql.define_column(l_CursorID, 7, L_LAST_UPDATED_DATE);
637:

Line 634: dbms_sql.define_column(l_CursorID, 5, L_SCORING_FLAG, 60);

630: dbms_sql.define_column(l_CursorID, 1, L_QUESTION_ID);
631: dbms_sql.define_column(l_CursorID, 2, L_QUESTION_NAME,2000);
632: dbms_sql.define_column(l_CursorID, 3, L_ANSWER_TYPE, 60);
633: dbms_sql.define_column(l_CursorID, 4, L_MANDATORY_FLAG, 60 );
634: dbms_sql.define_column(l_CursorID, 5, L_SCORING_FLAG, 60);
635: dbms_sql.define_column(l_CursorID, 6, L_LOOKUP_ID);
636: dbms_sql.define_column(l_CursorID, 7, L_LAST_UPDATED_DATE);
637:
638: dbms_sql.define_column(l_CursorID, 8, L_NOTE_TYPE, 30);

Line 635: dbms_sql.define_column(l_CursorID, 6, L_LOOKUP_ID);

631: dbms_sql.define_column(l_CursorID, 2, L_QUESTION_NAME,2000);
632: dbms_sql.define_column(l_CursorID, 3, L_ANSWER_TYPE, 60);
633: dbms_sql.define_column(l_CursorID, 4, L_MANDATORY_FLAG, 60 );
634: dbms_sql.define_column(l_CursorID, 5, L_SCORING_FLAG, 60);
635: dbms_sql.define_column(l_CursorID, 6, L_LOOKUP_ID);
636: dbms_sql.define_column(l_CursorID, 7, L_LAST_UPDATED_DATE);
637:
638: dbms_sql.define_column(l_CursorID, 8, L_NOTE_TYPE, 30);
639: dbms_sql.define_column(l_CursorID, 9, L_SHOW_ON_CREATION_FLAG,1);

Line 636: dbms_sql.define_column(l_CursorID, 7, L_LAST_UPDATED_DATE);

632: dbms_sql.define_column(l_CursorID, 3, L_ANSWER_TYPE, 60);
633: dbms_sql.define_column(l_CursorID, 4, L_MANDATORY_FLAG, 60 );
634: dbms_sql.define_column(l_CursorID, 5, L_SCORING_FLAG, 60);
635: dbms_sql.define_column(l_CursorID, 6, L_LOOKUP_ID);
636: dbms_sql.define_column(l_CursorID, 7, L_LAST_UPDATED_DATE);
637:
638: dbms_sql.define_column(l_CursorID, 8, L_NOTE_TYPE, 30);
639: dbms_sql.define_column(l_CursorID, 9, L_SHOW_ON_CREATION_FLAG,1);
640:

Line 638: dbms_sql.define_column(l_CursorID, 8, L_NOTE_TYPE, 30);

634: dbms_sql.define_column(l_CursorID, 5, L_SCORING_FLAG, 60);
635: dbms_sql.define_column(l_CursorID, 6, L_LOOKUP_ID);
636: dbms_sql.define_column(l_CursorID, 7, L_LAST_UPDATED_DATE);
637:
638: dbms_sql.define_column(l_CursorID, 8, L_NOTE_TYPE, 30);
639: dbms_sql.define_column(l_CursorID, 9, L_SHOW_ON_CREATION_FLAG,1);
640:
641:
642: L_Total_Questions_NotUsed := dbms_sql.execute(l_CursorID);

Line 639: dbms_sql.define_column(l_CursorID, 9, L_SHOW_ON_CREATION_FLAG,1);

635: dbms_sql.define_column(l_CursorID, 6, L_LOOKUP_ID);
636: dbms_sql.define_column(l_CursorID, 7, L_LAST_UPDATED_DATE);
637:
638: dbms_sql.define_column(l_CursorID, 8, L_NOTE_TYPE, 30);
639: dbms_sql.define_column(l_CursorID, 9, L_SHOW_ON_CREATION_FLAG,1);
640:
641:
642: L_Total_Questions_NotUsed := dbms_sql.execute(l_CursorID);
643:

Line 642: L_Total_Questions_NotUsed := dbms_sql.execute(l_CursorID);

638: dbms_sql.define_column(l_CursorID, 8, L_NOTE_TYPE, 30);
639: dbms_sql.define_column(l_CursorID, 9, L_SHOW_ON_CREATION_FLAG,1);
640:
641:
642: L_Total_Questions_NotUsed := dbms_sql.execute(l_CursorID);
643:
644: i:=1;
645: j:=0;
646:

Line 647: while (dbms_sql.fetch_rows(l_CursorID) > 0) loop

643:
644: i:=1;
645: j:=0;
646:
647: while (dbms_sql.fetch_rows(l_CursorID) > 0) loop
648: if (i>= L_Start_Question AND i<=L_End_Question) then
649: dbms_sql.column_value(l_CursorID, 1, L_QUESTION_ID);
650: dbms_sql.column_value(l_CursorID, 2, L_QUESTION_NAME);
651: dbms_sql.column_value(l_CursorID, 3, L_ANSWER_TYPE);

Line 649: dbms_sql.column_value(l_CursorID, 1, L_QUESTION_ID);

645: j:=0;
646:
647: while (dbms_sql.fetch_rows(l_CursorID) > 0) loop
648: if (i>= L_Start_Question AND i<=L_End_Question) then
649: dbms_sql.column_value(l_CursorID, 1, L_QUESTION_ID);
650: dbms_sql.column_value(l_CursorID, 2, L_QUESTION_NAME);
651: dbms_sql.column_value(l_CursorID, 3, L_ANSWER_TYPE);
652: dbms_sql.column_value(l_CursorID, 4, L_MANDATORY_FLAG);
653: dbms_sql.column_value(l_CursorID, 5, L_SCORING_FLAG);

Line 650: dbms_sql.column_value(l_CursorID, 2, L_QUESTION_NAME);

646:
647: while (dbms_sql.fetch_rows(l_CursorID) > 0) loop
648: if (i>= L_Start_Question AND i<=L_End_Question) then
649: dbms_sql.column_value(l_CursorID, 1, L_QUESTION_ID);
650: dbms_sql.column_value(l_CursorID, 2, L_QUESTION_NAME);
651: dbms_sql.column_value(l_CursorID, 3, L_ANSWER_TYPE);
652: dbms_sql.column_value(l_CursorID, 4, L_MANDATORY_FLAG);
653: dbms_sql.column_value(l_CursorID, 5, L_SCORING_FLAG);
654: dbms_sql.column_value(l_CursorID, 6, L_LOOKUP_ID);

Line 651: dbms_sql.column_value(l_CursorID, 3, L_ANSWER_TYPE);

647: while (dbms_sql.fetch_rows(l_CursorID) > 0) loop
648: if (i>= L_Start_Question AND i<=L_End_Question) then
649: dbms_sql.column_value(l_CursorID, 1, L_QUESTION_ID);
650: dbms_sql.column_value(l_CursorID, 2, L_QUESTION_NAME);
651: dbms_sql.column_value(l_CursorID, 3, L_ANSWER_TYPE);
652: dbms_sql.column_value(l_CursorID, 4, L_MANDATORY_FLAG);
653: dbms_sql.column_value(l_CursorID, 5, L_SCORING_FLAG);
654: dbms_sql.column_value(l_CursorID, 6, L_LOOKUP_ID);
655: dbms_sql.column_value(l_CursorID, 7, L_LAST_UPDATED_DATE);

Line 652: dbms_sql.column_value(l_CursorID, 4, L_MANDATORY_FLAG);

648: if (i>= L_Start_Question AND i<=L_End_Question) then
649: dbms_sql.column_value(l_CursorID, 1, L_QUESTION_ID);
650: dbms_sql.column_value(l_CursorID, 2, L_QUESTION_NAME);
651: dbms_sql.column_value(l_CursorID, 3, L_ANSWER_TYPE);
652: dbms_sql.column_value(l_CursorID, 4, L_MANDATORY_FLAG);
653: dbms_sql.column_value(l_CursorID, 5, L_SCORING_FLAG);
654: dbms_sql.column_value(l_CursorID, 6, L_LOOKUP_ID);
655: dbms_sql.column_value(l_CursorID, 7, L_LAST_UPDATED_DATE);
656:

Line 653: dbms_sql.column_value(l_CursorID, 5, L_SCORING_FLAG);

649: dbms_sql.column_value(l_CursorID, 1, L_QUESTION_ID);
650: dbms_sql.column_value(l_CursorID, 2, L_QUESTION_NAME);
651: dbms_sql.column_value(l_CursorID, 3, L_ANSWER_TYPE);
652: dbms_sql.column_value(l_CursorID, 4, L_MANDATORY_FLAG);
653: dbms_sql.column_value(l_CursorID, 5, L_SCORING_FLAG);
654: dbms_sql.column_value(l_CursorID, 6, L_LOOKUP_ID);
655: dbms_sql.column_value(l_CursorID, 7, L_LAST_UPDATED_DATE);
656:
657: dbms_sql.column_value(l_CursorID, 8, L_NOTE_TYPE);

Line 654: dbms_sql.column_value(l_CursorID, 6, L_LOOKUP_ID);

650: dbms_sql.column_value(l_CursorID, 2, L_QUESTION_NAME);
651: dbms_sql.column_value(l_CursorID, 3, L_ANSWER_TYPE);
652: dbms_sql.column_value(l_CursorID, 4, L_MANDATORY_FLAG);
653: dbms_sql.column_value(l_CursorID, 5, L_SCORING_FLAG);
654: dbms_sql.column_value(l_CursorID, 6, L_LOOKUP_ID);
655: dbms_sql.column_value(l_CursorID, 7, L_LAST_UPDATED_DATE);
656:
657: dbms_sql.column_value(l_CursorID, 8, L_NOTE_TYPE);
658: dbms_sql.column_value(l_CursorID, 9, L_SHOW_ON_CREATION_FLAG);

Line 655: dbms_sql.column_value(l_CursorID, 7, L_LAST_UPDATED_DATE);

651: dbms_sql.column_value(l_CursorID, 3, L_ANSWER_TYPE);
652: dbms_sql.column_value(l_CursorID, 4, L_MANDATORY_FLAG);
653: dbms_sql.column_value(l_CursorID, 5, L_SCORING_FLAG);
654: dbms_sql.column_value(l_CursorID, 6, L_LOOKUP_ID);
655: dbms_sql.column_value(l_CursorID, 7, L_LAST_UPDATED_DATE);
656:
657: dbms_sql.column_value(l_CursorID, 8, L_NOTE_TYPE);
658: dbms_sql.column_value(l_CursorID, 9, L_SHOW_ON_CREATION_FLAG);
659:

Line 657: dbms_sql.column_value(l_CursorID, 8, L_NOTE_TYPE);

653: dbms_sql.column_value(l_CursorID, 5, L_SCORING_FLAG);
654: dbms_sql.column_value(l_CursorID, 6, L_LOOKUP_ID);
655: dbms_sql.column_value(l_CursorID, 7, L_LAST_UPDATED_DATE);
656:
657: dbms_sql.column_value(l_CursorID, 8, L_NOTE_TYPE);
658: dbms_sql.column_value(l_CursorID, 9, L_SHOW_ON_CREATION_FLAG);
659:
660: X_Question_List_To_Show(j).mQuestionID := L_Question_ID;
661: X_Question_List_To_Show(j).mQuestionName := L_Question_NAME;

Line 658: dbms_sql.column_value(l_CursorID, 9, L_SHOW_ON_CREATION_FLAG);

654: dbms_sql.column_value(l_CursorID, 6, L_LOOKUP_ID);
655: dbms_sql.column_value(l_CursorID, 7, L_LAST_UPDATED_DATE);
656:
657: dbms_sql.column_value(l_CursorID, 8, L_NOTE_TYPE);
658: dbms_sql.column_value(l_CursorID, 9, L_SHOW_ON_CREATION_FLAG);
659:
660: X_Question_List_To_Show(j).mQuestionID := L_Question_ID;
661: X_Question_List_To_Show(j).mQuestionName := L_Question_NAME;
662: X_Question_List_To_Show(j).mAnswerType := L_ANSWER_TYPE;

Line 679: dbms_sql.close_cursor(l_CursorID);

675: end if;
676: i:=i+1;
677: end loop;
678:
679: dbms_sql.close_cursor(l_CursorID);
680: X_Retrieved_Question_Number := j;
681: X_Total_Questions := i-1;
682: -- Standard check of p_commit.
683: IF FND_API.To_Boolean( p_commit) THEN