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.

[Home] [Help]

APPS.MSC_CL_GMP_UTILITY dependencies on GMP_RESOURCE_AVAIL

Line 15802: INSERT INTO gmp_resource_avail

15798:
15799: ELSIF (p_usage = 'WPS') THEN /* Usage WPS */
15800:
15801: FORALL i IN resource_id.FIRST..resource_id.LAST
15802: INSERT INTO gmp_resource_avail
15803: (
15804: instance_id, plant_code, resource_id,
15805: calendar_id, resource_instance_id, shift_num,
15806: shift_date, from_time, to_time,

Line 15887: INSERT INTO gmp_resource_avail

15883:
15884: ELSIF (p_usage = 'WPS') THEN /* Usage WPS */
15885:
15886: FORALL i IN resource_id.FIRST..resource_id.LAST
15887: INSERT INTO gmp_resource_avail
15888: (
15889: instance_id, plant_code, resource_id,
15890: calendar_id, resource_instance_id, shift_num,
15891: shift_date, from_time, to_time,

Line 16949: REM| insert_gmp_resource_avail |

16945:
16946: /*
16947: REM+==========================================================================+
16948: REM| PROCEDURE NAME |
16949: REM| insert_gmp_resource_avail |
16950: REM| |
16951: REM| Type |
16952: REM| public |
16953: REM| |

Line 16969: PROCEDURE insert_gmp_resource_avail( errbuf OUT NOCOPY VARCHAR2,

16965: REM| B4309093 - 20-APR-2005 Modified code to TO ADD TIME OR A SHIFT TO A |
16966: REM| PLANT RESOURCE |
16967: REM+==========================================================================+
16968: */
16969: PROCEDURE insert_gmp_resource_avail( errbuf OUT NOCOPY VARCHAR2,
16970: retcode OUT NOCOPY NUMBER ,
16971: p_orgn_code IN VARCHAR2 ,
16972: p_from_rsrc IN VARCHAR2 ,
16973: p_to_rsrc IN VARCHAR2 ,

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

17054: FETCH cur_get_cal INTO l_calendar_id, l_calendar_no, l_calendar_desc ;
17055: EXIT WHEN cur_get_cal%NOTFOUND ;
17056:
17057: stmt_no := 1 ;
17058: delete_stmt := 'DELETE FROM gmp_resource_avail '||
17059: ' WHERE calendar_id = :cal_id ' ||
17060: ' AND plant_code = :Plant_code1 ';
17061:
17062: IF (v_from_rsrc IS NOT NULL AND v_to_rsrc IS NOT NULL) THEN

Line 17129: END insert_gmp_resource_avail;

17125: WHEN OTHERS THEN
17126: log_message(sqlerrm);
17127: retcode := 1 ;
17128:
17129: END insert_gmp_resource_avail;
17130:
17131: /*
17132: REM+==========================================================================+
17133: REM| PROCEDURE NAME |

Line 17168: /* For GMP_RESOURCE_AVAIL array definition */

17164: p_db_link IN VARCHAR2,
17165: p_usage IN VARCHAR2, /* OPM-PS */
17166: return_status OUT NOCOPY BOOLEAN) IS
17167:
17168: /* For GMP_RESOURCE_AVAIL array definition */
17169: TYPE interval_typ is RECORD
17170: (
17171: resource_id NUMBER,
17172: resource_instance_id NUMBER,

Line 17691: INSERT INTO gmp_resource_avail

17687:
17688: ELSIF (p_usage = 'WPS') THEN /* Usage WPS */
17689:
17690: FORALL i IN resource_id.FIRST..resource_id.LAST
17691: INSERT INTO gmp_resource_avail
17692: (
17693: instance_id, plant_code, resource_id,
17694: calendar_id, resource_instance_id, shift_num,
17695: shift_date, from_time, to_time,

Line 17777: INSERT INTO gmp_resource_avail

17773:
17774: ELSIF (p_usage = 'WPS') THEN /* Usage WPS */
17775:
17776: FORALL i IN resource_id.FIRST..resource_id.LAST
17777: INSERT INTO gmp_resource_avail
17778: (
17779: instance_id, plant_code, resource_id,
17780: calendar_id, resource_instance_id, shift_num,
17781: shift_date, from_time, to_time,

Line 17858: || ' FROM gmp_resource_avail'

17854: || ' shift_date, shift_num,from_time,to_time,resource_units) as lead_tt, '
17855: || ' lead(resource_units,1) over(order by resource_id, '
17856: || ' resource_instance_id, '
17857: || ' shift_date, shift_num,from_time,to_time,resource_units) as lead_rc '
17858: || ' FROM gmp_resource_avail'
17859: || ' WHERE plant_code = :orgn_code1 '
17860: || ' AND calendar_id = :cal_id ' ;
17861:
17862: IF (v_from_rsrc IS NOT NULL AND v_to_rsrc IS NOT NULL) THEN

Line 17897: sqlstmt := 'DELETE FROM gmp_resource_avail'

17893: LOOP
17894: FETCH ri_assembly INTO interval_record;
17895: EXIT WHEN ri_assembly%NOTFOUND;
17896:
17897: sqlstmt := 'DELETE FROM gmp_resource_avail'
17898: || ' WHERE plant_code = :Plant_code1 '
17899: || ' AND calendar_id = :cal_id '
17900: || ' AND resource_id = :prid '
17901: || ' AND resource_instance_id = :piid '

Line 17937: sqlupt := 'UPDATE gmp_resource_avail'

17933: END LOOP;
17934: CLOSE ri_assembly;
17935:
17936: stmt_no := 69;
17937: sqlupt := 'UPDATE gmp_resource_avail'
17938: ||' SET to_time = 86400 '
17939: ||' WHERE to_time = 86399 '
17940: ||' AND shift_num >= 99999 ' ;
17941:

Line 17944: sqlupt := 'UPDATE gmp_resource_avail'

17940: ||' AND shift_num >= 99999 ' ;
17941:
17942: EXECUTE immediate sqlupt ;
17943: sqlupt := null ;
17944: sqlupt := 'UPDATE gmp_resource_avail'
17945: ||' SET shift_num = (shift_num - 99999) '
17946: ||' WHERE shift_num >= 99999 ' ;
17947:
17948: EXECUTE immediate sqlupt ;

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

17968: REM| Type |
17969: REM| public |
17970: REM| |
17971: REM| DESCRIPTION |
17972: REM| The following procedure inserts rows into gmp_resource_avail |
17973: REM| |
17974: REM| Input Parameters |
17975: REM| p_instance_id - Instance Id |
17976: REM| p_orgn_code - Plant Code |

Line 18010: INSERT INTO gmp_resource_avail (

18006: BEGIN
18007: IF nvl(p_from_time,0) = 0 AND nvl(p_to_time,0) = 0 THEN
18008: NULL ;
18009: ELSE
18010: INSERT INTO gmp_resource_avail (
18011: instance_id, plant_code, resource_id,
18012: calendar_id, resource_instance_id, shift_num,
18013: shift_date, from_time, to_time,
18014: resource_units, creation_date, created_by,