APPS.GMP_EAM_DOWNTIME_PKG dependencies on GMP_RSRC_UNAVAIL_MAN

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

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

Line 109: FROM gmp_rsrc_unavail_man gmp

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

Line 138: INSERT INTO gmp_rsrc_unavail_man

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