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 GME_GANTT_PKG

Line 1: PACKAGE BODY gme_gantt_pkg AS

1: PACKAGE BODY gme_gantt_pkg AS
2: /* $Header: GMEGNTB.pls 120.11.12020000.3 2012/09/20 03:34:08 mtou ship $ */
3: g_pkg_name CONSTANT VARCHAR2 (30) := 'GME_GANTT_PKG';
4: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
5: g_bulk_fetch_limit NUMBER := 45;

Line 3: g_pkg_name CONSTANT VARCHAR2 (30) := 'GME_GANTT_PKG';

1: PACKAGE BODY gme_gantt_pkg AS
2: /* $Header: GMEGNTB.pls 120.11.12020000.3 2012/09/20 03:34:08 mtou ship $ */
3: g_pkg_name CONSTANT VARCHAR2 (30) := 'GME_GANTT_PKG';
4: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
5: g_bulk_fetch_limit NUMBER := 45;
6: g_product_no VARCHAR2 (32);
7: g_ingredient_no VARCHAR2 (32);

Line 677: string_to_exec(3) := ' DECODE(BATCH_STATUS,1, GME_GANTT_PKG.DATE_TO_CLIENTDT(PLAN_START_DATE), GME_GANTT_PKG.DATE_TO_CLIENTDT(ACTUAL_START_DATE)) START_DATE, ';

673: DELETE FROM GME_GANTT_GTMP;
674:
675: string_to_exec(1) := 'INSERT INTO GME_GANTT_GTMP ';
676: string_to_exec(2) := '( SELECT BATCH_ID, BATCH_NO, BATCH_STATUS, BATCH_TYPE, ';
677: string_to_exec(3) := ' DECODE(BATCH_STATUS,1, GME_GANTT_PKG.DATE_TO_CLIENTDT(PLAN_START_DATE), GME_GANTT_PKG.DATE_TO_CLIENTDT(ACTUAL_START_DATE)) START_DATE, ';
678: string_to_exec(4) := ' DECODE(BATCH_STATUS,3, GME_GANTT_PKG.DATE_TO_CLIENTDT(ACTUAL_CMPLT_DATE), GME_GANTT_PKG.DATE_TO_CLIENTDT(PLAN_CMPLT_DATE)) END_DATE, ';
679: string_to_exec(5) := ' GME_GANTT_PKG.DATE_TO_CLIENTDT(PLAN_START_DATE), GME_GANTT_PKG.DATE_TO_CLIENTDT(PLAN_CMPLT_DATE), ';
680: string_to_exec(6) := ' DECODE(GME_GANTT_PKG.DATE_TO_CLIENTDT(ACTUAL_START_DATE), NULL, GME_GANTT_PKG.DATE_TO_CLIENTDT(PLAN_START_DATE), GME_GANTT_PKG.DATE_TO_CLIENTDT(ACTUAL_START_DATE)) ACTUAL_START, ';
681: string_to_exec(7) := ' DECODE(GME_GANTT_PKG.DATE_TO_CLIENTDT(ACTUAL_CMPLT_DATE), NULL , GME_GANTT_PKG.DATE_TO_CLIENTDT(PLAN_CMPLT_DATE), GME_GANTT_PKG.DATE_TO_CLIENTDT(ACTUAL_CMPLT_DATE)) ACTUAL_END, ';

Line 678: string_to_exec(4) := ' DECODE(BATCH_STATUS,3, GME_GANTT_PKG.DATE_TO_CLIENTDT(ACTUAL_CMPLT_DATE), GME_GANTT_PKG.DATE_TO_CLIENTDT(PLAN_CMPLT_DATE)) END_DATE, ';

674:
675: string_to_exec(1) := 'INSERT INTO GME_GANTT_GTMP ';
676: string_to_exec(2) := '( SELECT BATCH_ID, BATCH_NO, BATCH_STATUS, BATCH_TYPE, ';
677: string_to_exec(3) := ' DECODE(BATCH_STATUS,1, GME_GANTT_PKG.DATE_TO_CLIENTDT(PLAN_START_DATE), GME_GANTT_PKG.DATE_TO_CLIENTDT(ACTUAL_START_DATE)) START_DATE, ';
678: string_to_exec(4) := ' DECODE(BATCH_STATUS,3, GME_GANTT_PKG.DATE_TO_CLIENTDT(ACTUAL_CMPLT_DATE), GME_GANTT_PKG.DATE_TO_CLIENTDT(PLAN_CMPLT_DATE)) END_DATE, ';
679: string_to_exec(5) := ' GME_GANTT_PKG.DATE_TO_CLIENTDT(PLAN_START_DATE), GME_GANTT_PKG.DATE_TO_CLIENTDT(PLAN_CMPLT_DATE), ';
680: string_to_exec(6) := ' DECODE(GME_GANTT_PKG.DATE_TO_CLIENTDT(ACTUAL_START_DATE), NULL, GME_GANTT_PKG.DATE_TO_CLIENTDT(PLAN_START_DATE), GME_GANTT_PKG.DATE_TO_CLIENTDT(ACTUAL_START_DATE)) ACTUAL_START, ';
681: string_to_exec(7) := ' DECODE(GME_GANTT_PKG.DATE_TO_CLIENTDT(ACTUAL_CMPLT_DATE), NULL , GME_GANTT_PKG.DATE_TO_CLIENTDT(PLAN_CMPLT_DATE), GME_GANTT_PKG.DATE_TO_CLIENTDT(ACTUAL_CMPLT_DATE)) ACTUAL_END, ';
682: string_to_exec(8) := ' FORMULA_ID, ROUTING_ID, ENFORCE_STEP_DEPENDENCY, TERMINATED_IND, FINITE_SCHEDULED_IND, PARENTLINE_ID FROM (';

Line 679: string_to_exec(5) := ' GME_GANTT_PKG.DATE_TO_CLIENTDT(PLAN_START_DATE), GME_GANTT_PKG.DATE_TO_CLIENTDT(PLAN_CMPLT_DATE), ';

675: string_to_exec(1) := 'INSERT INTO GME_GANTT_GTMP ';
676: string_to_exec(2) := '( SELECT BATCH_ID, BATCH_NO, BATCH_STATUS, BATCH_TYPE, ';
677: string_to_exec(3) := ' DECODE(BATCH_STATUS,1, GME_GANTT_PKG.DATE_TO_CLIENTDT(PLAN_START_DATE), GME_GANTT_PKG.DATE_TO_CLIENTDT(ACTUAL_START_DATE)) START_DATE, ';
678: string_to_exec(4) := ' DECODE(BATCH_STATUS,3, GME_GANTT_PKG.DATE_TO_CLIENTDT(ACTUAL_CMPLT_DATE), GME_GANTT_PKG.DATE_TO_CLIENTDT(PLAN_CMPLT_DATE)) END_DATE, ';
679: string_to_exec(5) := ' GME_GANTT_PKG.DATE_TO_CLIENTDT(PLAN_START_DATE), GME_GANTT_PKG.DATE_TO_CLIENTDT(PLAN_CMPLT_DATE), ';
680: string_to_exec(6) := ' DECODE(GME_GANTT_PKG.DATE_TO_CLIENTDT(ACTUAL_START_DATE), NULL, GME_GANTT_PKG.DATE_TO_CLIENTDT(PLAN_START_DATE), GME_GANTT_PKG.DATE_TO_CLIENTDT(ACTUAL_START_DATE)) ACTUAL_START, ';
681: string_to_exec(7) := ' DECODE(GME_GANTT_PKG.DATE_TO_CLIENTDT(ACTUAL_CMPLT_DATE), NULL , GME_GANTT_PKG.DATE_TO_CLIENTDT(PLAN_CMPLT_DATE), GME_GANTT_PKG.DATE_TO_CLIENTDT(ACTUAL_CMPLT_DATE)) ACTUAL_END, ';
682: string_to_exec(8) := ' FORMULA_ID, ROUTING_ID, ENFORCE_STEP_DEPENDENCY, TERMINATED_IND, FINITE_SCHEDULED_IND, PARENTLINE_ID FROM (';
683:

Line 680: string_to_exec(6) := ' DECODE(GME_GANTT_PKG.DATE_TO_CLIENTDT(ACTUAL_START_DATE), NULL, GME_GANTT_PKG.DATE_TO_CLIENTDT(PLAN_START_DATE), GME_GANTT_PKG.DATE_TO_CLIENTDT(ACTUAL_START_DATE)) ACTUAL_START, ';

676: string_to_exec(2) := '( SELECT BATCH_ID, BATCH_NO, BATCH_STATUS, BATCH_TYPE, ';
677: string_to_exec(3) := ' DECODE(BATCH_STATUS,1, GME_GANTT_PKG.DATE_TO_CLIENTDT(PLAN_START_DATE), GME_GANTT_PKG.DATE_TO_CLIENTDT(ACTUAL_START_DATE)) START_DATE, ';
678: string_to_exec(4) := ' DECODE(BATCH_STATUS,3, GME_GANTT_PKG.DATE_TO_CLIENTDT(ACTUAL_CMPLT_DATE), GME_GANTT_PKG.DATE_TO_CLIENTDT(PLAN_CMPLT_DATE)) END_DATE, ';
679: string_to_exec(5) := ' GME_GANTT_PKG.DATE_TO_CLIENTDT(PLAN_START_DATE), GME_GANTT_PKG.DATE_TO_CLIENTDT(PLAN_CMPLT_DATE), ';
680: string_to_exec(6) := ' DECODE(GME_GANTT_PKG.DATE_TO_CLIENTDT(ACTUAL_START_DATE), NULL, GME_GANTT_PKG.DATE_TO_CLIENTDT(PLAN_START_DATE), GME_GANTT_PKG.DATE_TO_CLIENTDT(ACTUAL_START_DATE)) ACTUAL_START, ';
681: string_to_exec(7) := ' DECODE(GME_GANTT_PKG.DATE_TO_CLIENTDT(ACTUAL_CMPLT_DATE), NULL , GME_GANTT_PKG.DATE_TO_CLIENTDT(PLAN_CMPLT_DATE), GME_GANTT_PKG.DATE_TO_CLIENTDT(ACTUAL_CMPLT_DATE)) ACTUAL_END, ';
682: string_to_exec(8) := ' FORMULA_ID, ROUTING_ID, ENFORCE_STEP_DEPENDENCY, TERMINATED_IND, FINITE_SCHEDULED_IND, PARENTLINE_ID FROM (';
683:
684: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

Line 681: string_to_exec(7) := ' DECODE(GME_GANTT_PKG.DATE_TO_CLIENTDT(ACTUAL_CMPLT_DATE), NULL , GME_GANTT_PKG.DATE_TO_CLIENTDT(PLAN_CMPLT_DATE), GME_GANTT_PKG.DATE_TO_CLIENTDT(ACTUAL_CMPLT_DATE)) ACTUAL_END, ';

677: string_to_exec(3) := ' DECODE(BATCH_STATUS,1, GME_GANTT_PKG.DATE_TO_CLIENTDT(PLAN_START_DATE), GME_GANTT_PKG.DATE_TO_CLIENTDT(ACTUAL_START_DATE)) START_DATE, ';
678: string_to_exec(4) := ' DECODE(BATCH_STATUS,3, GME_GANTT_PKG.DATE_TO_CLIENTDT(ACTUAL_CMPLT_DATE), GME_GANTT_PKG.DATE_TO_CLIENTDT(PLAN_CMPLT_DATE)) END_DATE, ';
679: string_to_exec(5) := ' GME_GANTT_PKG.DATE_TO_CLIENTDT(PLAN_START_DATE), GME_GANTT_PKG.DATE_TO_CLIENTDT(PLAN_CMPLT_DATE), ';
680: string_to_exec(6) := ' DECODE(GME_GANTT_PKG.DATE_TO_CLIENTDT(ACTUAL_START_DATE), NULL, GME_GANTT_PKG.DATE_TO_CLIENTDT(PLAN_START_DATE), GME_GANTT_PKG.DATE_TO_CLIENTDT(ACTUAL_START_DATE)) ACTUAL_START, ';
681: string_to_exec(7) := ' DECODE(GME_GANTT_PKG.DATE_TO_CLIENTDT(ACTUAL_CMPLT_DATE), NULL , GME_GANTT_PKG.DATE_TO_CLIENTDT(PLAN_CMPLT_DATE), GME_GANTT_PKG.DATE_TO_CLIENTDT(ACTUAL_CMPLT_DATE)) ACTUAL_END, ';
682: string_to_exec(8) := ' FORMULA_ID, ROUTING_ID, ENFORCE_STEP_DEPENDENCY, TERMINATED_IND, FINITE_SCHEDULED_IND, PARENTLINE_ID FROM (';
683:
684: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
685: gme_debug.put_line('Calling set_where_clause');