APPS.GMP_EAM_DOWNTIME_PKG dependencies on GMP_RSRC_UNAVAIL_MAN

Line 91: that Delete from gmp_rsrc_unavail_man happens only once for each Plant */

87: p_resources)
88: LOOP
89:
90: /* B3467386 08-Mar-04 Namit Singhi. The following IF condition makes sure
91: that Delete from gmp_rsrc_unavail_man happens only once for each Plant */
92:
93: IF(prev_prod_org_id = eam_unavail_dtl.mtl_organization_id) THEN
94: new_prod_org_flag := 2; -- False
95: ELSE

Line 108: FROM gmp_rsrc_unavail_man gmp

104: had to use the following procedure, which uses sub queries. */
105:
106: IF new_prod_org_flag = 1 THEN
107: DELETE
108: FROM gmp_rsrc_unavail_man gmp
109: WHERE EXISTS (
110: SELECT eam.wip_entity_id
111: FROM
112: eam_workorder_downtime_v eam,

Line 137: INSERT INTO gmp_rsrc_unavail_man

133: i := 0 ;
134: END IF ;
135:
136:
137: INSERT INTO gmp_rsrc_unavail_man
138: (
139: resource_id,
140: from_date,
141: to_date,