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.MSC_CL_GMP_UTILITY dependencies on GMP_RESOURCE_AVAIL

Line 16683: INSERT INTO gmp_resource_avail

16679:
16680: ELSIF (p_usage = 'WPS') THEN /* Usage WPS */
16681:
16682: FORALL i IN first_in..last_in
16683: INSERT INTO gmp_resource_avail
16684: (
16685: instance_id, plant_code, resource_id,
16686: calendar_id, resource_instance_id, shift_num,
16687: shift_date, from_time, to_time,

Line 17805: REM| insert_gmp_resource_avail |

17801:
17802: /*
17803: REM+==========================================================================+
17804: REM| PROCEDURE NAME |
17805: REM| insert_gmp_resource_avail |
17806: REM| |
17807: REM| Type |
17808: REM| public |
17809: REM| |

Line 17825: PROCEDURE insert_gmp_resource_avail( errbuf OUT NOCOPY VARCHAR2,

17821: REM| B4309093 - 20-APR-2005 Modified code to TO ADD TIME OR A SHIFT TO A |
17822: REM| PLANT RESOURCE |
17823: REM+==========================================================================+
17824: */
17825: PROCEDURE insert_gmp_resource_avail( errbuf OUT NOCOPY VARCHAR2,
17826: retcode OUT NOCOPY NUMBER ,
17827: p_orgn_code IN VARCHAR2 ,
17828: p_from_rsrc IN VARCHAR2 ,
17829: p_to_rsrc IN VARCHAR2 ,

Line 17914: delete_stmt := 'DELETE FROM gmp_resource_avail '||

17910: FETCH cur_get_cal INTO l_calendar_id, l_calendar_no, l_calendar_desc ;
17911: EXIT WHEN cur_get_cal%NOTFOUND ;
17912:
17913: stmt_no := 1 ;
17914: delete_stmt := 'DELETE FROM gmp_resource_avail '||
17915: ' WHERE calendar_id = :cal_id ' ||
17916: ' AND plant_code = :Plant_code1 ';
17917:
17918: IF (v_from_rsrc IS NOT NULL AND v_to_rsrc IS NOT NULL) THEN

Line 17985: END insert_gmp_resource_avail;

17981: WHEN OTHERS THEN
17982: log_message(sqlerrm);
17983: retcode := 1 ;
17984:
17985: END insert_gmp_resource_avail;
17986:
17987: /*
17988: REM+==========================================================================+
17989: REM| PROCEDURE NAME |

Line 18024: /* For GMP_RESOURCE_AVAIL array definition */

18020: p_db_link IN VARCHAR2,
18021: p_usage IN VARCHAR2, /* OPM-PS */
18022: return_status OUT NOCOPY BOOLEAN) IS
18023:
18024: /* For GMP_RESOURCE_AVAIL array definition */
18025: TYPE interval_typ is RECORD
18026: (
18027: resource_id PLS_INTEGER,
18028: resource_instance_id PLS_INTEGER,

Line 18550: INSERT INTO gmp_resource_avail

18546: END IF; -- Bug: 6030499
18547: ELSIF (p_usage = 'WPS') THEN /* Usage WPS */
18548:
18549: FORALL i IN resource_id.FIRST..resource_id.LAST
18550: INSERT INTO gmp_resource_avail
18551: (
18552: instance_id, plant_code, resource_id,
18553: calendar_id, resource_instance_id, shift_num,
18554: shift_date, from_time, to_time,

Line 18646: INSERT INTO gmp_resource_avail

18642:
18643: ELSIF (p_usage = 'WPS') THEN /* Usage WPS */
18644:
18645: FORALL i IN resource_id.FIRST..resource_id.LAST
18646: INSERT INTO gmp_resource_avail
18647: (
18648: instance_id, plant_code, resource_id,
18649: calendar_id, resource_instance_id, shift_num,
18650: shift_date, from_time, to_time,

Line 18727: || ' FROM gmp_resource_avail'

18723: || ' shift_date, shift_num,from_time,to_time,resource_units) as lead_tt, '
18724: || ' lead(resource_units,1) over(order by resource_id, '
18725: || ' resource_instance_id, '
18726: || ' shift_date, shift_num,from_time,to_time,resource_units) as lead_rc '
18727: || ' FROM gmp_resource_avail'
18728: || ' WHERE plant_code = :orgn_code1 '
18729: || ' AND calendar_id = :cal_id ' ;
18730:
18731: IF (v_from_rsrc IS NOT NULL AND v_to_rsrc IS NOT NULL) THEN

Line 18766: sqlstmt := 'DELETE FROM gmp_resource_avail'

18762: LOOP
18763: FETCH ri_assembly INTO interval_record;
18764: EXIT WHEN ri_assembly%NOTFOUND;
18765:
18766: sqlstmt := 'DELETE FROM gmp_resource_avail'
18767: || ' WHERE plant_code = :Plant_code1 '
18768: || ' AND calendar_id = :cal_id '
18769: || ' AND resource_id = :prid '
18770: || ' AND resource_instance_id = :piid '

Line 18813: sqlupt := 'UPDATE gmp_resource_avail'

18809: log_message('ri_assembly Session pga memory = ' || TO_CHAR(v_dummy) );
18810:
18811:
18812: stmt_no := 69;
18813: sqlupt := 'UPDATE gmp_resource_avail'
18814: ||' SET to_time = 86400 '
18815: ||' WHERE to_time = 86399 '
18816: ||' AND shift_num >= 99999 ' ;
18817:

Line 18820: sqlupt := 'UPDATE gmp_resource_avail'

18816: ||' AND shift_num >= 99999 ' ;
18817:
18818: EXECUTE immediate sqlupt ;
18819: sqlupt := null ;
18820: sqlupt := 'UPDATE gmp_resource_avail'
18821: ||' SET shift_num = (shift_num - 99999) '
18822: ||' WHERE shift_num >= 99999 ' ;
18823:
18824: EXECUTE immediate sqlupt ;

Line 18848: REM| The following procedure inserts rows into gmp_resource_avail |

18844: REM| Type |
18845: REM| public |
18846: REM| |
18847: REM| DESCRIPTION |
18848: REM| The following procedure inserts rows into gmp_resource_avail |
18849: REM| |
18850: REM| Input Parameters |
18851: REM| p_instance_id - Instance Id |
18852: REM| p_orgn_code - Plant Code |

Line 18886: INSERT INTO gmp_resource_avail (

18882: BEGIN
18883: IF nvl(p_from_time,0) = 0 AND nvl(p_to_time,0) = 0 THEN
18884: NULL ;
18885: ELSE
18886: INSERT INTO gmp_resource_avail (
18887: instance_id, plant_code, resource_id,
18888: calendar_id, resource_instance_id, shift_num,
18889: shift_date, from_time, to_time,
18890: resource_units, creation_date, created_by,