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

Line 776: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

772: l_rc NUMBER;
773:
774: BEGIN
775: l_download_only := 'N';
776: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
777:
778: l_dml := 'SELECT nvl(download_only,''N'') FROM csm_auto_sync_inq '
779: || ' WHERE clid$$cs = :1 AND tranid$$ = :2 ';
780:

Line 781: DBMS_SQL.PARSE (l_cursor_id, l_dml, DBMS_SQL.v7);

777:
778: l_dml := 'SELECT nvl(download_only,''N'') FROM csm_auto_sync_inq '
779: || ' WHERE clid$$cs = :1 AND tranid$$ = :2 ';
780:
781: DBMS_SQL.PARSE (l_cursor_id, l_dml, DBMS_SQL.v7);
782: DBMS_SQL.BIND_VARIABLE(l_cursor_id ,':1',p_client_id);
783: DBMS_SQL.BIND_VARIABLE(l_cursor_id ,':2',p_tran_id);
784: DBMS_SQL.DEFINE_COLUMN (l_cursor_id, 1,l_download_only,1);
785:

Line 782: DBMS_SQL.BIND_VARIABLE(l_cursor_id ,':1',p_client_id);

778: l_dml := 'SELECT nvl(download_only,''N'') FROM csm_auto_sync_inq '
779: || ' WHERE clid$$cs = :1 AND tranid$$ = :2 ';
780:
781: DBMS_SQL.PARSE (l_cursor_id, l_dml, DBMS_SQL.v7);
782: DBMS_SQL.BIND_VARIABLE(l_cursor_id ,':1',p_client_id);
783: DBMS_SQL.BIND_VARIABLE(l_cursor_id ,':2',p_tran_id);
784: DBMS_SQL.DEFINE_COLUMN (l_cursor_id, 1,l_download_only,1);
785:
786: l_rc := DBMS_SQL.EXECUTE (l_cursor_id);

Line 783: DBMS_SQL.BIND_VARIABLE(l_cursor_id ,':2',p_tran_id);

779: || ' WHERE clid$$cs = :1 AND tranid$$ = :2 ';
780:
781: DBMS_SQL.PARSE (l_cursor_id, l_dml, DBMS_SQL.v7);
782: DBMS_SQL.BIND_VARIABLE(l_cursor_id ,':1',p_client_id);
783: DBMS_SQL.BIND_VARIABLE(l_cursor_id ,':2',p_tran_id);
784: DBMS_SQL.DEFINE_COLUMN (l_cursor_id, 1,l_download_only,1);
785:
786: l_rc := DBMS_SQL.EXECUTE (l_cursor_id);
787:

Line 784: DBMS_SQL.DEFINE_COLUMN (l_cursor_id, 1,l_download_only,1);

780:
781: DBMS_SQL.PARSE (l_cursor_id, l_dml, DBMS_SQL.v7);
782: DBMS_SQL.BIND_VARIABLE(l_cursor_id ,':1',p_client_id);
783: DBMS_SQL.BIND_VARIABLE(l_cursor_id ,':2',p_tran_id);
784: DBMS_SQL.DEFINE_COLUMN (l_cursor_id, 1,l_download_only,1);
785:
786: l_rc := DBMS_SQL.EXECUTE (l_cursor_id);
787:
788: IF ( DBMS_SQL.FETCH_ROWS(l_cursor_id) > 0 ) THEN

Line 786: l_rc := DBMS_SQL.EXECUTE (l_cursor_id);

782: DBMS_SQL.BIND_VARIABLE(l_cursor_id ,':1',p_client_id);
783: DBMS_SQL.BIND_VARIABLE(l_cursor_id ,':2',p_tran_id);
784: DBMS_SQL.DEFINE_COLUMN (l_cursor_id, 1,l_download_only,1);
785:
786: l_rc := DBMS_SQL.EXECUTE (l_cursor_id);
787:
788: IF ( DBMS_SQL.FETCH_ROWS(l_cursor_id) > 0 ) THEN
789: DBMS_SQL.COLUMN_VALUE (l_cursor_id, 1, l_download_only);
790: ELSE

Line 788: IF ( DBMS_SQL.FETCH_ROWS(l_cursor_id) > 0 ) THEN

784: DBMS_SQL.DEFINE_COLUMN (l_cursor_id, 1,l_download_only,1);
785:
786: l_rc := DBMS_SQL.EXECUTE (l_cursor_id);
787:
788: IF ( DBMS_SQL.FETCH_ROWS(l_cursor_id) > 0 ) THEN
789: DBMS_SQL.COLUMN_VALUE (l_cursor_id, 1, l_download_only);
790: ELSE
791: l_download_only := 'N';
792: END IF;

Line 789: DBMS_SQL.COLUMN_VALUE (l_cursor_id, 1, l_download_only);

785:
786: l_rc := DBMS_SQL.EXECUTE (l_cursor_id);
787:
788: IF ( DBMS_SQL.FETCH_ROWS(l_cursor_id) > 0 ) THEN
789: DBMS_SQL.COLUMN_VALUE (l_cursor_id, 1, l_download_only);
790: ELSE
791: l_download_only := 'N';
792: END IF;
793:

Line 794: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);

790: ELSE
791: l_download_only := 'N';
792: END IF;
793:
794: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
795:
796: IF(asg_helper.check_is_log_enabled(g_stmt_level)) THEN
797: asg_helper.log('is_download_only_sync: is: '|| l_download_only ,
798: 'asg_base',g_stmt_level);