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

Line 328: p_string_to_exec IN OUT NOCOPY DBMS_SQL.VARCHAR2S) AS

324: p_certified_status IN INTEGER,
325: p_from_date IN DATE,
326: p_to_date IN DATE DEFAULT NULL,
327: p_to_batch_no IN VARCHAR2 DEFAULT NULL,
328: p_string_to_exec IN OUT NOCOPY DBMS_SQL.VARCHAR2S) AS
329:
330: l_query_count NUMBER := 0;
331:
332: l_column_select_str1 VARCHAR2(200) := ' SELECT B.BATCH_ID BATCH_ID, B.BATCH_NO BATCH_NO, BATCH_STATUS, BATCH_TYPE, PLAN_START_DATE, ACTUAL_START_DATE, ';

Line 629: string_to_exec DBMS_SQL.VARCHAR2S;

625: ,p_certified_status IN INTEGER)
626: IS
627: l_api_name CONSTANT VARCHAR2 (30) := 'INIT_SESSION';
628:
629: string_to_exec DBMS_SQL.VARCHAR2S;
630: dynamic_cur PLS_INTEGER := dbms_sql.open_cursor;
631: l_ret NUMBER;
632: BEGIN
633: GME_DEBUG.LOG_INITIALIZE('ProdScheduler');

Line 630: dynamic_cur PLS_INTEGER := dbms_sql.open_cursor;

626: IS
627: l_api_name CONSTANT VARCHAR2 (30) := 'INIT_SESSION';
628:
629: string_to_exec DBMS_SQL.VARCHAR2S;
630: dynamic_cur PLS_INTEGER := dbms_sql.open_cursor;
631: l_ret NUMBER;
632: BEGIN
633: GME_DEBUG.LOG_INITIALIZE('ProdScheduler');
634:

Line 716: DBMS_SQL.PARSE(dynamic_cur, string_to_exec, string_to_exec.first, string_to_exec.last, TRUE, DBMS_SQL.NATIVE);

712: end loop;
713: gme_debug.put_line('===============================================================');
714: END IF;
715:
716: DBMS_SQL.PARSE(dynamic_cur, string_to_exec, string_to_exec.first, string_to_exec.last, TRUE, DBMS_SQL.NATIVE);
717:
718: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
719: gme_debug.put_line('After parsing dynamic SQL query');
720: END IF;

Line 735: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_organization_id' , p_organization_id);

731: gme_debug.put_line('p_aux_rsrc_ind = '|| p_aux_rsrc_ind);
732: gme_debug.put_line('p_sec_rsrc_ind = '|| p_sec_rsrc_ind);
733: END IF;
734:
735: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_organization_id' , p_organization_id);
736: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_batch_no' , p_batch_no);
737: IF p_to_batch_no IS NOT NULL THEN
738: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_to_batch_no' , p_to_batch_no);
739: END IF;

Line 736: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_batch_no' , p_batch_no);

732: gme_debug.put_line('p_sec_rsrc_ind = '|| p_sec_rsrc_ind);
733: END IF;
734:
735: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_organization_id' , p_organization_id);
736: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_batch_no' , p_batch_no);
737: IF p_to_batch_no IS NOT NULL THEN
738: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_to_batch_no' , p_to_batch_no);
739: END IF;
740: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_from_date' , p_from_date);

Line 738: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_to_batch_no' , p_to_batch_no);

734:
735: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_organization_id' , p_organization_id);
736: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_batch_no' , p_batch_no);
737: IF p_to_batch_no IS NOT NULL THEN
738: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_to_batch_no' , p_to_batch_no);
739: END IF;
740: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_from_date' , p_from_date);
741: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_resource' , p_resource);
742: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_prim_rsrc_ind' , p_prim_rsrc_ind);

Line 740: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_from_date' , p_from_date);

736: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_batch_no' , p_batch_no);
737: IF p_to_batch_no IS NOT NULL THEN
738: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_to_batch_no' , p_to_batch_no);
739: END IF;
740: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_from_date' , p_from_date);
741: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_resource' , p_resource);
742: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_prim_rsrc_ind' , p_prim_rsrc_ind);
743: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_aux_rsrc_ind' , p_aux_rsrc_ind);
744: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_sec_rsrc_ind' , p_sec_rsrc_ind);

Line 741: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_resource' , p_resource);

737: IF p_to_batch_no IS NOT NULL THEN
738: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_to_batch_no' , p_to_batch_no);
739: END IF;
740: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_from_date' , p_from_date);
741: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_resource' , p_resource);
742: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_prim_rsrc_ind' , p_prim_rsrc_ind);
743: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_aux_rsrc_ind' , p_aux_rsrc_ind);
744: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_sec_rsrc_ind' , p_sec_rsrc_ind);
745:

Line 742: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_prim_rsrc_ind' , p_prim_rsrc_ind);

738: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_to_batch_no' , p_to_batch_no);
739: END IF;
740: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_from_date' , p_from_date);
741: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_resource' , p_resource);
742: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_prim_rsrc_ind' , p_prim_rsrc_ind);
743: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_aux_rsrc_ind' , p_aux_rsrc_ind);
744: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_sec_rsrc_ind' , p_sec_rsrc_ind);
745:
746: IF p_to_date IS NOT NULL THEN

Line 743: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_aux_rsrc_ind' , p_aux_rsrc_ind);

739: END IF;
740: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_from_date' , p_from_date);
741: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_resource' , p_resource);
742: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_prim_rsrc_ind' , p_prim_rsrc_ind);
743: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_aux_rsrc_ind' , p_aux_rsrc_ind);
744: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_sec_rsrc_ind' , p_sec_rsrc_ind);
745:
746: IF p_to_date IS NOT NULL THEN
747: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

Line 744: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_sec_rsrc_ind' , p_sec_rsrc_ind);

740: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_from_date' , p_from_date);
741: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_resource' , p_resource);
742: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_prim_rsrc_ind' , p_prim_rsrc_ind);
743: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_aux_rsrc_ind' , p_aux_rsrc_ind);
744: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_sec_rsrc_ind' , p_sec_rsrc_ind);
745:
746: IF p_to_date IS NOT NULL THEN
747: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
748: gme_debug.put_line('p_to_date = '|| to_char(p_to_date, 'DD-MON-YYYY HH24:MI:SS'));

Line 751: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_to_date', p_to_date);

747: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
748: gme_debug.put_line('p_to_date = '|| to_char(p_to_date, 'DD-MON-YYYY HH24:MI:SS'));
749: END IF;
750:
751: DBMS_SQL.BIND_VARIABLE(dynamic_cur, ':p_to_date', p_to_date);
752: END IF;
753:
754: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
755: gme_debug.put_line('-------------------------------------------');

Line 763: l_ret := dbms_sql.execute(dynamic_cur);

759: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
760: gme_debug.put_line('Executing the dynamic SQL');
761: END IF;
762:
763: l_ret := dbms_sql.execute(dynamic_cur);
764:
765: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
766: gme_debug.put_line('After executing dynamic SQL rows returned := '||l_ret);
767: END IF;