APPS.GMP_APS_OUTPUT_PKG dependencies on WIP_JOB_SCHEDULE_INTERFACE

Line 13: | Pull out the Information from wip_job_schedule_interface. |

9: | public |
10: | |
11: | DESCRIPTION |
12: | The following procedure inserts into gmp_aps_output_tbl table, |
13: | Pull out the Information from wip_job_schedule_interface. |
14: | Input Parameters |
15: | p_group_id - Group Id |
16: | |
17: | Output Parameters |

Line 36: | gmp_aps_output_dtl table from WIP_JOB_SCHEDULE_INTERFACE |

32: | 7 For cancelled Job |
33: | 21-JAN-02 - Sridhar Modified the Insert statement with new GMD Tables |
34: | |
35: | 05-JAN-05 - Sowmya, B4084230. New column Firm_flag also populated in the|
36: | gmp_aps_output_dtl table from WIP_JOB_SCHEDULE_INTERFACE |
37: | 08-21-06 - Rajesh B5454215 Added parameter of value '0' (Batch Type) |
38: | when calling GMPRELAP |
39: | 12-07-07 - Kaushek B6167305 Added new profile option for implementing |
40: | suggestions as 'FPO' whereby default it is set to'BATCH' |

Line 136: wip_job_schedule_interface w,

132: w.created_by ,
133: w.due_date , /* B3710615 12.0 */
134: w.priority /* B4039225 for 12.0 */
135: FROM
136: wip_job_schedule_interface w,
137: gmp_form_eff gfe,
138: gmd_recipe_validity_rules grv /* B1992371 */
139: WHERE
140: w.group_id = p_group_id

Line 173: wip_job_schedule_interface w,

169: w.created_by ,
170: w.due_date , /* B3710615 12.0 */
171: w.priority /* B4039225 */
172: FROM
173: wip_job_schedule_interface w,
174: mtl_system_items mtl
175: WHERE
176: w.group_id = p_group_id
177: AND w.load_type = 1

Line 260: wip_job_schedule_interface w,

256: w.created_by ,
257: w.due_date , /* B3710615 12.0 */
258: w.priority /* B4039225 */
259: FROM
260: wip_job_schedule_interface w,
261: gme_batch_header gbh /* 1992371 */
262: WHERE
263: w.group_id = p_group_id
264: AND w.load_type = 3 /* Update Discrete Job */

Line 335: wip_job_schedule_interface w,

331: w.created_by ,
332: w.due_date , /* B3710615 12.0 */
333: w.priority /* B4039225 */
334: FROM
335: wip_job_schedule_interface w,
336: gme_batch_header gbh /* 1992371 */
337: WHERE
338: w.group_id = p_group_id
339: AND w.load_type = 3 /* Update Discrete job */

Line 496: /* Following Lines delete the rows wip_job_schedule_interface after the rows are

492: retcode := 1; /* Warning */
493: NULL ;
494: END;
495:
496: /* Following Lines delete the rows wip_job_schedule_interface after the rows are
497: inserted in gmp_aps_output_tbl */
498: BEGIN
499:
500: IF delete_new_flag = 1 THEN

Line 501: DELETE wip_job_schedule_interface

497: inserted in gmp_aps_output_tbl */
498: BEGIN
499:
500: IF delete_new_flag = 1 THEN
501: DELETE wip_job_schedule_interface
502: WHERE group_id = p_group_id
503: AND process_status = 1
504: AND load_type = 1 ;
505: DELETE wip_job_dtls_interface

Line 511: DELETE wip_job_schedule_interface

507: AND process_status = 1 ;
508: END IF;
509:
510: IF delete_rsch_flag = 1 THEN
511: DELETE wip_job_schedule_interface
512: WHERE group_id = p_group_id
513: AND process_status = 1
514: AND nvl(status_type,0 ) <> 7 /* Rescheduled Batch */
515: AND load_type = 3 ;

Line 522: DELETE wip_job_schedule_interface

518: AND process_status = 1 ;
519: END IF;
520:
521: IF delete_cancel_flag = 1 THEN
522: DELETE wip_job_schedule_interface
523: WHERE group_id = p_group_id
524: AND process_status = 1
525: AND nvl(status_type,0 ) = 7 /* Cancelled Batch */
526: AND load_type = 3 ;