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_CHOICES_PVT dependencies on DBMS_SQL

Line 341: l_CursorID := dbms_sql.open_cursor;

337: else
338: l_statement := l_statement || ' ORDER BY SEQUENCE_NUMBER ';
339: end if;
340:
341: l_CursorID := dbms_sql.open_cursor;
342: dbms_sql.parse (l_CursorID, l_statement, dbms_sql.NATIVE);
343:
344: dbms_sql.bind_variable(l_CursorID, 'v_lookup_id', P_Lookup_ID);
345:

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

338: l_statement := l_statement || ' ORDER BY SEQUENCE_NUMBER ';
339: end if;
340:
341: l_CursorID := dbms_sql.open_cursor;
342: dbms_sql.parse (l_CursorID, l_statement, dbms_sql.NATIVE);
343:
344: dbms_sql.bind_variable(l_CursorID, 'v_lookup_id', P_Lookup_ID);
345:
346: dbms_sql.define_column(l_CursorID, 1, l_CHOICE_ID);

Line 344: dbms_sql.bind_variable(l_CursorID, 'v_lookup_id', P_Lookup_ID);

340:
341: l_CursorID := dbms_sql.open_cursor;
342: dbms_sql.parse (l_CursorID, l_statement, dbms_sql.NATIVE);
343:
344: dbms_sql.bind_variable(l_CursorID, 'v_lookup_id', P_Lookup_ID);
345:
346: dbms_sql.define_column(l_CursorID, 1, l_CHOICE_ID);
347: dbms_sql.define_column(l_CursorID, 2, l_CHOICE_NAME,1000);
348: dbms_sql.define_column(l_CursorID, 3, l_LOOKUP_ID);

Line 346: dbms_sql.define_column(l_CursorID, 1, l_CHOICE_ID);

342: dbms_sql.parse (l_CursorID, l_statement, dbms_sql.NATIVE);
343:
344: dbms_sql.bind_variable(l_CursorID, 'v_lookup_id', P_Lookup_ID);
345:
346: dbms_sql.define_column(l_CursorID, 1, l_CHOICE_ID);
347: dbms_sql.define_column(l_CursorID, 2, l_CHOICE_NAME,1000);
348: dbms_sql.define_column(l_CursorID, 3, l_LOOKUP_ID);
349: dbms_sql.define_column(l_CursorID, 4, l_SCORE);
350: dbms_sql.define_column(l_CursorID, 5, l_LAST_UPDATE_DATE);

Line 347: dbms_sql.define_column(l_CursorID, 2, l_CHOICE_NAME,1000);

343:
344: dbms_sql.bind_variable(l_CursorID, 'v_lookup_id', P_Lookup_ID);
345:
346: dbms_sql.define_column(l_CursorID, 1, l_CHOICE_ID);
347: dbms_sql.define_column(l_CursorID, 2, l_CHOICE_NAME,1000);
348: dbms_sql.define_column(l_CursorID, 3, l_LOOKUP_ID);
349: dbms_sql.define_column(l_CursorID, 4, l_SCORE);
350: dbms_sql.define_column(l_CursorID, 5, l_LAST_UPDATE_DATE);
351:

Line 348: dbms_sql.define_column(l_CursorID, 3, l_LOOKUP_ID);

344: dbms_sql.bind_variable(l_CursorID, 'v_lookup_id', P_Lookup_ID);
345:
346: dbms_sql.define_column(l_CursorID, 1, l_CHOICE_ID);
347: dbms_sql.define_column(l_CursorID, 2, l_CHOICE_NAME,1000);
348: dbms_sql.define_column(l_CursorID, 3, l_LOOKUP_ID);
349: dbms_sql.define_column(l_CursorID, 4, l_SCORE);
350: dbms_sql.define_column(l_CursorID, 5, l_LAST_UPDATE_DATE);
351:
352: dbms_sql.define_column(l_CursorID, 6, l_DEFAULT_CHOICE,1);

Line 349: dbms_sql.define_column(l_CursorID, 4, l_SCORE);

345:
346: dbms_sql.define_column(l_CursorID, 1, l_CHOICE_ID);
347: dbms_sql.define_column(l_CursorID, 2, l_CHOICE_NAME,1000);
348: dbms_sql.define_column(l_CursorID, 3, l_LOOKUP_ID);
349: dbms_sql.define_column(l_CursorID, 4, l_SCORE);
350: dbms_sql.define_column(l_CursorID, 5, l_LAST_UPDATE_DATE);
351:
352: dbms_sql.define_column(l_CursorID, 6, l_DEFAULT_CHOICE,1);
353:

Line 350: dbms_sql.define_column(l_CursorID, 5, l_LAST_UPDATE_DATE);

346: dbms_sql.define_column(l_CursorID, 1, l_CHOICE_ID);
347: dbms_sql.define_column(l_CursorID, 2, l_CHOICE_NAME,1000);
348: dbms_sql.define_column(l_CursorID, 3, l_LOOKUP_ID);
349: dbms_sql.define_column(l_CursorID, 4, l_SCORE);
350: dbms_sql.define_column(l_CursorID, 5, l_LAST_UPDATE_DATE);
351:
352: dbms_sql.define_column(l_CursorID, 6, l_DEFAULT_CHOICE,1);
353:
354: l_total_choices_number:= dbms_sql.execute(l_CursorID);

Line 352: dbms_sql.define_column(l_CursorID, 6, l_DEFAULT_CHOICE,1);

348: dbms_sql.define_column(l_CursorID, 3, l_LOOKUP_ID);
349: dbms_sql.define_column(l_CursorID, 4, l_SCORE);
350: dbms_sql.define_column(l_CursorID, 5, l_LAST_UPDATE_DATE);
351:
352: dbms_sql.define_column(l_CursorID, 6, l_DEFAULT_CHOICE,1);
353:
354: l_total_choices_number:= dbms_sql.execute(l_CursorID);
355:
356: j:=0;

Line 354: l_total_choices_number:= dbms_sql.execute(l_CursorID);

350: dbms_sql.define_column(l_CursorID, 5, l_LAST_UPDATE_DATE);
351:
352: dbms_sql.define_column(l_CursorID, 6, l_DEFAULT_CHOICE,1);
353:
354: l_total_choices_number:= dbms_sql.execute(l_CursorID);
355:
356: j:=0;
357: while (dbms_sql.fetch_rows (l_CursorID) > 0) loop
358:

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

353:
354: l_total_choices_number:= dbms_sql.execute(l_CursorID);
355:
356: j:=0;
357: while (dbms_sql.fetch_rows (l_CursorID) > 0) loop
358:
359: dbms_sql.column_value(l_CursorID, 1, l_CHOICE_ID);
360: dbms_sql.column_value(l_CursorID, 2, l_CHOICE_NAME);
361: dbms_sql.column_value(l_CursorID, 3, l_LOOKUP_ID);

Line 359: dbms_sql.column_value(l_CursorID, 1, l_CHOICE_ID);

355:
356: j:=0;
357: while (dbms_sql.fetch_rows (l_CursorID) > 0) loop
358:
359: dbms_sql.column_value(l_CursorID, 1, l_CHOICE_ID);
360: dbms_sql.column_value(l_CursorID, 2, l_CHOICE_NAME);
361: dbms_sql.column_value(l_CursorID, 3, l_LOOKUP_ID);
362: dbms_sql.column_value(l_CursorID, 4, l_SCORE);
363: dbms_sql.column_value(l_CursorID, 5, l_LAST_UPDATE_DATE);

Line 360: dbms_sql.column_value(l_CursorID, 2, l_CHOICE_NAME);

356: j:=0;
357: while (dbms_sql.fetch_rows (l_CursorID) > 0) loop
358:
359: dbms_sql.column_value(l_CursorID, 1, l_CHOICE_ID);
360: dbms_sql.column_value(l_CursorID, 2, l_CHOICE_NAME);
361: dbms_sql.column_value(l_CursorID, 3, l_LOOKUP_ID);
362: dbms_sql.column_value(l_CursorID, 4, l_SCORE);
363: dbms_sql.column_value(l_CursorID, 5, l_LAST_UPDATE_DATE);
364:

Line 361: dbms_sql.column_value(l_CursorID, 3, l_LOOKUP_ID);

357: while (dbms_sql.fetch_rows (l_CursorID) > 0) loop
358:
359: dbms_sql.column_value(l_CursorID, 1, l_CHOICE_ID);
360: dbms_sql.column_value(l_CursorID, 2, l_CHOICE_NAME);
361: dbms_sql.column_value(l_CursorID, 3, l_LOOKUP_ID);
362: dbms_sql.column_value(l_CursorID, 4, l_SCORE);
363: dbms_sql.column_value(l_CursorID, 5, l_LAST_UPDATE_DATE);
364:
365: dbms_sql.column_value(l_CursorID, 6, l_DEFAULT_CHOICE);

Line 362: dbms_sql.column_value(l_CursorID, 4, l_SCORE);

358:
359: dbms_sql.column_value(l_CursorID, 1, l_CHOICE_ID);
360: dbms_sql.column_value(l_CursorID, 2, l_CHOICE_NAME);
361: dbms_sql.column_value(l_CursorID, 3, l_LOOKUP_ID);
362: dbms_sql.column_value(l_CursorID, 4, l_SCORE);
363: dbms_sql.column_value(l_CursorID, 5, l_LAST_UPDATE_DATE);
364:
365: dbms_sql.column_value(l_CursorID, 6, l_DEFAULT_CHOICE);
366: X_Choice_List_To_Show (j).mChoiceID :=l_CHOICE_ID;

Line 363: dbms_sql.column_value(l_CursorID, 5, l_LAST_UPDATE_DATE);

359: dbms_sql.column_value(l_CursorID, 1, l_CHOICE_ID);
360: dbms_sql.column_value(l_CursorID, 2, l_CHOICE_NAME);
361: dbms_sql.column_value(l_CursorID, 3, l_LOOKUP_ID);
362: dbms_sql.column_value(l_CursorID, 4, l_SCORE);
363: dbms_sql.column_value(l_CursorID, 5, l_LAST_UPDATE_DATE);
364:
365: dbms_sql.column_value(l_CursorID, 6, l_DEFAULT_CHOICE);
366: X_Choice_List_To_Show (j).mChoiceID :=l_CHOICE_ID;
367: X_Choice_List_To_Show (j).mChoiceName :=l_CHOICE_NAME;

Line 365: dbms_sql.column_value(l_CursorID, 6, l_DEFAULT_CHOICE);

361: dbms_sql.column_value(l_CursorID, 3, l_LOOKUP_ID);
362: dbms_sql.column_value(l_CursorID, 4, l_SCORE);
363: dbms_sql.column_value(l_CursorID, 5, l_LAST_UPDATE_DATE);
364:
365: dbms_sql.column_value(l_CursorID, 6, l_DEFAULT_CHOICE);
366: X_Choice_List_To_Show (j).mChoiceID :=l_CHOICE_ID;
367: X_Choice_List_To_Show (j).mChoiceName :=l_CHOICE_NAME;
368: X_Choice_List_To_Show (j).mLookupID:=l_LOOKUP_ID;
369: X_Choice_List_To_Show (j).mScore:=l_SCORE;

Line 376: dbms_sql.close_cursor(l_CursorID);

372: X_Choice_List_To_Show (j).mDefaultChoiceFlag := l_DEFAULT_CHOICE;
373: j:=j+1;
374:
375: end loop;
376: dbms_sql.close_cursor(l_CursorID);
377: -- Standard check of p_commit.
378: IF FND_API.To_Boolean( p_commit) THEN
379: COMMIT WORK;
380: END IF;