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 138: wip_job_schedule_interface w,

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

Line 175: wip_job_schedule_interface w,

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

Line 262: wip_job_schedule_interface w,

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

Line 337: wip_job_schedule_interface w,

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

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

494: retcode := 1; /* Warning */
495: NULL ;
496: END;
497:
498: /* Following Lines delete the rows wip_job_schedule_interface after the rows are
499: inserted in gmp_aps_output_tbl */
500: BEGIN
501: IF mrp_debug_profile = 'Y' THEN
502: FND_FILE.PUT_LINE ( FND_FILE.LOG,'DO NOT DELETE DATA FROM WIP INTERFACE (Debug Mode)');

Line 506: DELETE wip_job_schedule_interface

502: FND_FILE.PUT_LINE ( FND_FILE.LOG,'DO NOT DELETE DATA FROM WIP INTERFACE (Debug Mode)');
503: ELSE
504: FND_FILE.PUT_LINE ( FND_FILE.LOG,'DELETE DATA FROM WIP INTERFACE ');
505: IF delete_new_flag = 1 THEN
506: DELETE wip_job_schedule_interface
507: WHERE group_id = p_group_id
508: AND process_status = 1
509: AND load_type = 1 ;
510: DELETE wip_job_dtls_interface

Line 516: DELETE wip_job_schedule_interface

512: AND process_status = 1 ;
513: END IF;
514:
515: IF delete_rsch_flag = 1 THEN
516: DELETE wip_job_schedule_interface
517: WHERE group_id = p_group_id
518: AND process_status = 1
519: AND nvl(status_type,0 ) <> 7 /* Rescheduled Batch */
520: AND load_type = 3 ;

Line 527: DELETE wip_job_schedule_interface

523: AND process_status = 1 ;
524: END IF;
525:
526: IF delete_cancel_flag = 1 THEN
527: DELETE wip_job_schedule_interface
528: WHERE group_id = p_group_id
529: AND process_status = 1
530: AND nvl(status_type,0 ) = 7 /* Cancelled Batch */
531: AND load_type = 3 ;