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

Line 503: l_cursor := DBMS_SQL.OPEN_CURSOR;

499: FROM FND_DOCUMENT_TL
500: WHERE filename=:P_filename
501: AND language=:P_language';
502:
503: l_cursor := DBMS_SQL.OPEN_CURSOR;
504:
505: DBMS_SQL.PARSE( l_cursor, l_sql_stmt , DBMS_SQL.NATIVE );
506:
507: DBMS_SQL.BIND_VARIABLE(l_cursor,'P_text_code' ,P_text_code);

Line 505: DBMS_SQL.PARSE( l_cursor, l_sql_stmt , DBMS_SQL.NATIVE );

501: AND language=:P_language';
502:
503: l_cursor := DBMS_SQL.OPEN_CURSOR;
504:
505: DBMS_SQL.PARSE( l_cursor, l_sql_stmt , DBMS_SQL.NATIVE );
506:
507: DBMS_SQL.BIND_VARIABLE(l_cursor,'P_text_code' ,P_text_code);
508: DBMS_SQL.BIND_VARIABLE(l_cursor,'P_paragraph_code' ,P_paragraph_code );
509: DBMS_SQL.BIND_VARIABLE(l_cursor,'P_sub_paracode' ,P_sub_paracode );

Line 507: DBMS_SQL.BIND_VARIABLE(l_cursor,'P_text_code' ,P_text_code);

503: l_cursor := DBMS_SQL.OPEN_CURSOR;
504:
505: DBMS_SQL.PARSE( l_cursor, l_sql_stmt , DBMS_SQL.NATIVE );
506:
507: DBMS_SQL.BIND_VARIABLE(l_cursor,'P_text_code' ,P_text_code);
508: DBMS_SQL.BIND_VARIABLE(l_cursor,'P_paragraph_code' ,P_paragraph_code );
509: DBMS_SQL.BIND_VARIABLE(l_cursor,'P_sub_paracode' ,P_sub_paracode );
510:
511: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_language,6);

Line 508: DBMS_SQL.BIND_VARIABLE(l_cursor,'P_paragraph_code' ,P_paragraph_code );

504:
505: DBMS_SQL.PARSE( l_cursor, l_sql_stmt , DBMS_SQL.NATIVE );
506:
507: DBMS_SQL.BIND_VARIABLE(l_cursor,'P_text_code' ,P_text_code);
508: DBMS_SQL.BIND_VARIABLE(l_cursor,'P_paragraph_code' ,P_paragraph_code );
509: DBMS_SQL.BIND_VARIABLE(l_cursor,'P_sub_paracode' ,P_sub_paracode );
510:
511: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_language,6);
512: DBMS_SQL.DEFINE_COLUMN(l_cursor, 2, l_paragraph_code,4);

Line 509: DBMS_SQL.BIND_VARIABLE(l_cursor,'P_sub_paracode' ,P_sub_paracode );

505: DBMS_SQL.PARSE( l_cursor, l_sql_stmt , DBMS_SQL.NATIVE );
506:
507: DBMS_SQL.BIND_VARIABLE(l_cursor,'P_text_code' ,P_text_code);
508: DBMS_SQL.BIND_VARIABLE(l_cursor,'P_paragraph_code' ,P_paragraph_code );
509: DBMS_SQL.BIND_VARIABLE(l_cursor,'P_sub_paracode' ,P_sub_paracode );
510:
511: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_language,6);
512: DBMS_SQL.DEFINE_COLUMN(l_cursor, 2, l_paragraph_code,4);
513: DBMS_SQL.DEFINE_COLUMN(l_cursor, 3, l_sub_paracode);

Line 511: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_language,6);

507: DBMS_SQL.BIND_VARIABLE(l_cursor,'P_text_code' ,P_text_code);
508: DBMS_SQL.BIND_VARIABLE(l_cursor,'P_paragraph_code' ,P_paragraph_code );
509: DBMS_SQL.BIND_VARIABLE(l_cursor,'P_sub_paracode' ,P_sub_paracode );
510:
511: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_language,6);
512: DBMS_SQL.DEFINE_COLUMN(l_cursor, 2, l_paragraph_code,4);
513: DBMS_SQL.DEFINE_COLUMN(l_cursor, 3, l_sub_paracode);
514: DBMS_SQL.DEFINE_COLUMN(l_cursor, 4, l_lang_code,4);
515:

Line 512: DBMS_SQL.DEFINE_COLUMN(l_cursor, 2, l_paragraph_code,4);

508: DBMS_SQL.BIND_VARIABLE(l_cursor,'P_paragraph_code' ,P_paragraph_code );
509: DBMS_SQL.BIND_VARIABLE(l_cursor,'P_sub_paracode' ,P_sub_paracode );
510:
511: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_language,6);
512: DBMS_SQL.DEFINE_COLUMN(l_cursor, 2, l_paragraph_code,4);
513: DBMS_SQL.DEFINE_COLUMN(l_cursor, 3, l_sub_paracode);
514: DBMS_SQL.DEFINE_COLUMN(l_cursor, 4, l_lang_code,4);
515:
516: l_rows_processed := DBMS_SQL.EXECUTE(l_cursor);

Line 513: DBMS_SQL.DEFINE_COLUMN(l_cursor, 3, l_sub_paracode);

509: DBMS_SQL.BIND_VARIABLE(l_cursor,'P_sub_paracode' ,P_sub_paracode );
510:
511: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_language,6);
512: DBMS_SQL.DEFINE_COLUMN(l_cursor, 2, l_paragraph_code,4);
513: DBMS_SQL.DEFINE_COLUMN(l_cursor, 3, l_sub_paracode);
514: DBMS_SQL.DEFINE_COLUMN(l_cursor, 4, l_lang_code,4);
515:
516: l_rows_processed := DBMS_SQL.EXECUTE(l_cursor);
517:

Line 514: DBMS_SQL.DEFINE_COLUMN(l_cursor, 4, l_lang_code,4);

510:
511: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_language,6);
512: DBMS_SQL.DEFINE_COLUMN(l_cursor, 2, l_paragraph_code,4);
513: DBMS_SQL.DEFINE_COLUMN(l_cursor, 3, l_sub_paracode);
514: DBMS_SQL.DEFINE_COLUMN(l_cursor, 4, l_lang_code,4);
515:
516: l_rows_processed := DBMS_SQL.EXECUTE(l_cursor);
517:
518: loop

Line 516: l_rows_processed := DBMS_SQL.EXECUTE(l_cursor);

512: DBMS_SQL.DEFINE_COLUMN(l_cursor, 2, l_paragraph_code,4);
513: DBMS_SQL.DEFINE_COLUMN(l_cursor, 3, l_sub_paracode);
514: DBMS_SQL.DEFINE_COLUMN(l_cursor, 4, l_lang_code,4);
515:
516: l_rows_processed := DBMS_SQL.EXECUTE(l_cursor);
517:
518: loop
519:
520: IF ( DBMS_SQL.FETCH_ROWS(l_cursor) > 0 ) THEN

Line 520: IF ( DBMS_SQL.FETCH_ROWS(l_cursor) > 0 ) THEN

516: l_rows_processed := DBMS_SQL.EXECUTE(l_cursor);
517:
518: loop
519:
520: IF ( DBMS_SQL.FETCH_ROWS(l_cursor) > 0 ) THEN
521:
522: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_language);
523: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_paragraph_code);
524: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, l_sub_paracode);

Line 522: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_language);

518: loop
519:
520: IF ( DBMS_SQL.FETCH_ROWS(l_cursor) > 0 ) THEN
521:
522: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_language);
523: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_paragraph_code);
524: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, l_sub_paracode);
525: DBMS_SQL.COLUMN_VALUE(l_cursor, 4, l_lang_code);
526:

Line 523: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_paragraph_code);

519:
520: IF ( DBMS_SQL.FETCH_ROWS(l_cursor) > 0 ) THEN
521:
522: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_language);
523: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_paragraph_code);
524: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, l_sub_paracode);
525: DBMS_SQL.COLUMN_VALUE(l_cursor, 4, l_lang_code);
526:
527: UPDATE FND_LANGUAGES

Line 524: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, l_sub_paracode);

520: IF ( DBMS_SQL.FETCH_ROWS(l_cursor) > 0 ) THEN
521:
522: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_language);
523: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_paragraph_code);
524: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, l_sub_paracode);
525: DBMS_SQL.COLUMN_VALUE(l_cursor, 4, l_lang_code);
526:
527: UPDATE FND_LANGUAGES
528: set installed_flag='I'

Line 525: DBMS_SQL.COLUMN_VALUE(l_cursor, 4, l_lang_code);

521:
522: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_language);
523: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_paragraph_code);
524: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, l_sub_paracode);
525: DBMS_SQL.COLUMN_VALUE(l_cursor, 4, l_lang_code);
526:
527: UPDATE FND_LANGUAGES
528: set installed_flag='I'
529: WHERE

Line 544: DBMS_SQL.CLOSE_CURSOR(l_cursor);

540: END IF;
541:
542: end loop;
543:
544: DBMS_SQL.CLOSE_CURSOR(l_cursor);
545:
546: Exception
547: WHEN OTHERS THEN
548:

Line 556: IF DBMS_SQL.IS_OPEN(l_cursor) THEN

552: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);
553: FND_MSG_PUB.ADD;
554:
555:
556: IF DBMS_SQL.IS_OPEN(l_cursor) THEN
557: DBMS_SQL.CLOSE_CURSOR(l_cursor);
558: END IF;
559:
560: RAISE;

Line 557: DBMS_SQL.CLOSE_CURSOR(l_cursor);

553: FND_MSG_PUB.ADD;
554:
555:
556: IF DBMS_SQL.IS_OPEN(l_cursor) THEN
557: DBMS_SQL.CLOSE_CURSOR(l_cursor);
558: END IF;
559:
560: RAISE;
561:

Line 954: l_cursor := DBMS_SQL.OPEN_CURSOR;

950: l_long_text:=null;
951:
952: l_flag:='FALSE';
953:
954: l_cursor := DBMS_SQL.OPEN_CURSOR;
955:
956: -- Lets define dynamic sql for attachment text
957: l_sql_stmt := 'SELECT text '||
958: ' FROM ' || p_text_tl_table ||

Line 966: DBMS_SQL.PARSE( l_cursor, l_sql_stmt , DBMS_SQL.NATIVE );

962: ' AND language= :x_language '||
963: ' AND line_no>-1' ||
964: ' ORDER BY line_no';
965:
966: DBMS_SQL.PARSE( l_cursor, l_sql_stmt , DBMS_SQL.NATIVE );
967:
968: -- Lets define dynamic sql bind variables
969: DBMS_SQL.BIND_VARIABLE(l_cursor,'x_Text_Code' ,P_text_code);
970: DBMS_SQL.BIND_VARIABLE(l_cursor,'x_paragraph_code' ,P_paragraph_code );

Line 969: DBMS_SQL.BIND_VARIABLE(l_cursor,'x_Text_Code' ,P_text_code);

965:
966: DBMS_SQL.PARSE( l_cursor, l_sql_stmt , DBMS_SQL.NATIVE );
967:
968: -- Lets define dynamic sql bind variables
969: DBMS_SQL.BIND_VARIABLE(l_cursor,'x_Text_Code' ,P_text_code);
970: DBMS_SQL.BIND_VARIABLE(l_cursor,'x_paragraph_code' ,P_paragraph_code );
971: DBMS_SQL.BIND_VARIABLE(l_cursor,'x_sub_paracode', P_sub_paracode );
972: DBMS_SQL.BIND_VARIABLE(l_cursor,'x_language',P_language );
973:

Line 970: DBMS_SQL.BIND_VARIABLE(l_cursor,'x_paragraph_code' ,P_paragraph_code );

966: DBMS_SQL.PARSE( l_cursor, l_sql_stmt , DBMS_SQL.NATIVE );
967:
968: -- Lets define dynamic sql bind variables
969: DBMS_SQL.BIND_VARIABLE(l_cursor,'x_Text_Code' ,P_text_code);
970: DBMS_SQL.BIND_VARIABLE(l_cursor,'x_paragraph_code' ,P_paragraph_code );
971: DBMS_SQL.BIND_VARIABLE(l_cursor,'x_sub_paracode', P_sub_paracode );
972: DBMS_SQL.BIND_VARIABLE(l_cursor,'x_language',P_language );
973:
974: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_text_tl,70);

Line 971: DBMS_SQL.BIND_VARIABLE(l_cursor,'x_sub_paracode', P_sub_paracode );

967:
968: -- Lets define dynamic sql bind variables
969: DBMS_SQL.BIND_VARIABLE(l_cursor,'x_Text_Code' ,P_text_code);
970: DBMS_SQL.BIND_VARIABLE(l_cursor,'x_paragraph_code' ,P_paragraph_code );
971: DBMS_SQL.BIND_VARIABLE(l_cursor,'x_sub_paracode', P_sub_paracode );
972: DBMS_SQL.BIND_VARIABLE(l_cursor,'x_language',P_language );
973:
974: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_text_tl,70);
975:

Line 972: DBMS_SQL.BIND_VARIABLE(l_cursor,'x_language',P_language );

968: -- Lets define dynamic sql bind variables
969: DBMS_SQL.BIND_VARIABLE(l_cursor,'x_Text_Code' ,P_text_code);
970: DBMS_SQL.BIND_VARIABLE(l_cursor,'x_paragraph_code' ,P_paragraph_code );
971: DBMS_SQL.BIND_VARIABLE(l_cursor,'x_sub_paracode', P_sub_paracode );
972: DBMS_SQL.BIND_VARIABLE(l_cursor,'x_language',P_language );
973:
974: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_text_tl,70);
975:
976: l_rows_processed := DBMS_SQL.EXECUTE(l_cursor);

Line 974: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_text_tl,70);

970: DBMS_SQL.BIND_VARIABLE(l_cursor,'x_paragraph_code' ,P_paragraph_code );
971: DBMS_SQL.BIND_VARIABLE(l_cursor,'x_sub_paracode', P_sub_paracode );
972: DBMS_SQL.BIND_VARIABLE(l_cursor,'x_language',P_language );
973:
974: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_text_tl,70);
975:
976: l_rows_processed := DBMS_SQL.EXECUTE(l_cursor);
977:
978: loop

Line 976: l_rows_processed := DBMS_SQL.EXECUTE(l_cursor);

972: DBMS_SQL.BIND_VARIABLE(l_cursor,'x_language',P_language );
973:
974: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_text_tl,70);
975:
976: l_rows_processed := DBMS_SQL.EXECUTE(l_cursor);
977:
978: loop
979:
980: IF ( DBMS_SQL.FETCH_ROWS(l_cursor) > 0 ) THEN

Line 980: IF ( DBMS_SQL.FETCH_ROWS(l_cursor) > 0 ) THEN

976: l_rows_processed := DBMS_SQL.EXECUTE(l_cursor);
977:
978: loop
979:
980: IF ( DBMS_SQL.FETCH_ROWS(l_cursor) > 0 ) THEN
981: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_text_tl);
982: l_long_text:=l_long_text||l_text_tl;
983: l_flag:='TRUE';
984: ELSE

Line 981: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_text_tl);

977:
978: loop
979:
980: IF ( DBMS_SQL.FETCH_ROWS(l_cursor) > 0 ) THEN
981: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_text_tl);
982: l_long_text:=l_long_text||l_text_tl;
983: l_flag:='TRUE';
984: ELSE
985: exit;

Line 990: DBMS_SQL.CLOSE_CURSOR(l_cursor);

986: END IF;
987:
988: end loop;
989:
990: DBMS_SQL.CLOSE_CURSOR(l_cursor);
991:
992: if l_flag='TRUE' then
993: -- if true then insert the attachment into fnd_documents_long_text table
994: INSERT INTO