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.

APPS.GMO_CBR_GRP dependencies on GMO_BATCH_PROGRESSION

Line 269: UPDATE gmo_batch_progression

265: -- Update event details based on parameters
266: --
267: IF P_ERECORD_ID IS NOT NULL
268: THEN
269: UPDATE gmo_batch_progression
270: SET STATUS = P_STATUS,
271: EVENT_DATE = p_EVENT_DATE
272: WHERE ERECORD_ID = p_ERECORD_ID;
273: END IF;

Line 276: UPDATE gmo_batch_progression

272: WHERE ERECORD_ID = p_ERECORD_ID;
273: END IF;
274: IF P_BATCH_PROGRESSION_ID IS NOT NULL
275: THEN
276: UPDATE gmo_batch_progression
277: SET STATUS = P_STATUS,
278: EVENT_DATE = p_EVENT_DATE
279: WHERE PROGRESSION_ID = P_BATCH_PROGRESSION_ID;
280: END IF;

Line 283: PROCEDURE INSERT_EVENT(P_BATCH_PROG_REC GMO_BATCH_PROGRESSION%ROWTYPE,P_BATCH_PROGRESSION_ID OUT NOCOPY NUMBER) IS

279: WHERE PROGRESSION_ID = P_BATCH_PROGRESSION_ID;
280: END IF;
281: END UPDATE_EVENT ;
282:
283: PROCEDURE INSERT_EVENT(P_BATCH_PROG_REC GMO_BATCH_PROGRESSION%ROWTYPE,P_BATCH_PROGRESSION_ID OUT NOCOPY NUMBER) IS
284: CURSOR get_progression_ID is
285: SELECT GMO_BATCH_PROGRESSION_S.nextval
286: FROM DUAL;
287: BEGIN

Line 285: SELECT GMO_BATCH_PROGRESSION_S.nextval

281: END UPDATE_EVENT ;
282:
283: PROCEDURE INSERT_EVENT(P_BATCH_PROG_REC GMO_BATCH_PROGRESSION%ROWTYPE,P_BATCH_PROGRESSION_ID OUT NOCOPY NUMBER) IS
284: CURSOR get_progression_ID is
285: SELECT GMO_BATCH_PROGRESSION_S.nextval
286: FROM DUAL;
287: BEGIN
288: OPEN get_progression_ID;
289: FETCH get_progression_ID INTO P_BATCH_PROGRESSION_ID;

Line 295: INSERT INTO GMO_BATCH_PROGRESSION (

291:
292: --
293: -- insert into Batch Progression Table
294: --
295: INSERT INTO GMO_BATCH_PROGRESSION (
296: PROGRESSION_ID
297: ,BATCH_ID
298: ,BATCHSTEP_ID
299: ,MATERIAL_LINE_ID

Line 390: CURSOR GMO_BATCH_PROGRESSION_CUR IS

386: -- cursor declarations
387: -- This cursor is used to modify Progression row status for a given batch
388: -- from inprogress to complete status based on e-record status
389:
390: CURSOR GMO_BATCH_PROGRESSION_CUR IS
391: SELECT PROGRESSION_ID,ERECORD_ID,BATCH_ID ,BATCHSTEP_ID,
392: MATERIAL_LINE_ID,BATCHACTIVITY_ID,BATCHRSRC_ID
393: FROM GMO_BATCH_PROGRESSION
394: WHERE BATCH_ID = P_BATCH_ID

Line 393: FROM GMO_BATCH_PROGRESSION

389:
390: CURSOR GMO_BATCH_PROGRESSION_CUR IS
391: SELECT PROGRESSION_ID,ERECORD_ID,BATCH_ID ,BATCHSTEP_ID,
392: MATERIAL_LINE_ID,BATCHACTIVITY_ID,BATCHRSRC_ID
393: FROM GMO_BATCH_PROGRESSION
394: WHERE BATCH_ID = P_BATCH_ID
395: AND STATUS = 'INPROGRESS'
396: AND ERECORD_ID IS NOT NULL;
397:

Line 401: CURSOR GMO_BATCH_PROGRESSION_CUR2 IS

397:
398: -- This cursor is used to populate missing information for batch progression table
399: -- this can occur for SSWA based events.
400:
401: CURSOR GMO_BATCH_PROGRESSION_CUR2 IS
402: SELECT PROGRESSION_ID,EVENT,EVENT_KEY,dispense_id
403: FROM GMO_BATCH_PROGRESSION
404: WHERE BATCH_ID IS NULL
405: AND STATUS = 'INPROGRESS'

Line 403: FROM GMO_BATCH_PROGRESSION

399: -- this can occur for SSWA based events.
400:
401: CURSOR GMO_BATCH_PROGRESSION_CUR2 IS
402: SELECT PROGRESSION_ID,EVENT,EVENT_KEY,dispense_id
403: FROM GMO_BATCH_PROGRESSION
404: WHERE BATCH_ID IS NULL
405: AND STATUS = 'INPROGRESS'
406: AND ERECORD_ID IS NOT NULL
407: AND event in ('oracle.apps.gmo.mtl.dispense',

Line 426: OPEN GMO_BATCH_PROGRESSION_CUR2;

422: where label_id = l_event_key;
423: BEGIN
424: -- Following code is to populate missing data values in batch progression for SSWA events
425:
426: OPEN GMO_BATCH_PROGRESSION_CUR2;
427: LOOP
428: FETCH GMO_BATCH_PROGRESSION_CUR2 INTO l_progression_id,l_event_name,l_event_key,l_dispense_id;
429: EXIT WHEN GMO_BATCH_PROGRESSION_CUR2%NOTFOUND;
430: IF l_event_name in ('oracle.apps.gmo.mtl.dispense','oracle.apps.gmo.labelprint') THEN

Line 428: FETCH GMO_BATCH_PROGRESSION_CUR2 INTO l_progression_id,l_event_name,l_event_key,l_dispense_id;

424: -- Following code is to populate missing data values in batch progression for SSWA events
425:
426: OPEN GMO_BATCH_PROGRESSION_CUR2;
427: LOOP
428: FETCH GMO_BATCH_PROGRESSION_CUR2 INTO l_progression_id,l_event_name,l_event_key,l_dispense_id;
429: EXIT WHEN GMO_BATCH_PROGRESSION_CUR2%NOTFOUND;
430: IF l_event_name in ('oracle.apps.gmo.mtl.dispense','oracle.apps.gmo.labelprint') THEN
431: IF l_event_name in ('oracle.apps.gmo.mtl.dispense') THEN
432: l_dispense_id := l_event_key ;

Line 429: EXIT WHEN GMO_BATCH_PROGRESSION_CUR2%NOTFOUND;

425:
426: OPEN GMO_BATCH_PROGRESSION_CUR2;
427: LOOP
428: FETCH GMO_BATCH_PROGRESSION_CUR2 INTO l_progression_id,l_event_name,l_event_key,l_dispense_id;
429: EXIT WHEN GMO_BATCH_PROGRESSION_CUR2%NOTFOUND;
430: IF l_event_name in ('oracle.apps.gmo.mtl.dispense','oracle.apps.gmo.labelprint') THEN
431: IF l_event_name in ('oracle.apps.gmo.mtl.dispense') THEN
432: l_dispense_id := l_event_key ;
433: END IF;

Line 437: UPDATE GMO_BATCH_PROGRESSION

433: END IF;
434: OPEN get_dispense_Details;
435: FETCH get_dispense_Details into l_batch_id, l_batchstep_id ,l_material_detail_id;
436: CLOSE get_dispense_Details;
437: UPDATE GMO_BATCH_PROGRESSION
438: SET batch_id = l_batch_id,
439: batchstep_id = l_batchstep_id,
440: material_line_id = l_material_detail_id
441: WHERE PROGRESSION_ID = l_progression_id;

Line 446: UPDATE GMO_BATCH_PROGRESSION

442: ELSIF l_event_name in ('oracle.apps.gmo.mtl.revdisp') THEN
443: OPEN get_rev_dispense_Details;
444: FETCH get_rev_dispense_Details into l_batch_id, l_batchstep_id ,l_material_detail_id,l_dispense_id;
445: CLOSE get_rev_dispense_Details;
446: UPDATE GMO_BATCH_PROGRESSION
447: SET batch_id = l_batch_id,
448: batchstep_id = l_batchstep_id,
449: material_line_id = l_material_detail_id,
450: dispense_id = l_dispense_id

Line 461: FOR GMO_BATCH_PROGRESSION_REC IN GMO_BATCH_PROGRESSION_CUR

457: -- to mark as completed. This is required as when event is raised
458: -- rows will be in 'INPROGRESS' state and we do not have any hook from where
459: -- we can mark row as completed once ERES is success.
460: --
461: FOR GMO_BATCH_PROGRESSION_REC IN GMO_BATCH_PROGRESSION_CUR
462: LOOP
463: edr_psig.getdocumentdetails(GMO_BATCH_PROGRESSION_REC.ERECORD_ID,l_document,l_docparams,l_signatures,l_error,l_error_msg);
464: IF l_document.PSIG_STATUS = 'ERROR' THEN
465: DELETE FROM GMO_BATCH_PROGRESSION WHERE PROGRESSION_ID = GMO_BATCH_PROGRESSION_REC.PROGRESSION_ID;

Line 463: edr_psig.getdocumentdetails(GMO_BATCH_PROGRESSION_REC.ERECORD_ID,l_document,l_docparams,l_signatures,l_error,l_error_msg);

459: -- we can mark row as completed once ERES is success.
460: --
461: FOR GMO_BATCH_PROGRESSION_REC IN GMO_BATCH_PROGRESSION_CUR
462: LOOP
463: edr_psig.getdocumentdetails(GMO_BATCH_PROGRESSION_REC.ERECORD_ID,l_document,l_docparams,l_signatures,l_error,l_error_msg);
464: IF l_document.PSIG_STATUS = 'ERROR' THEN
465: DELETE FROM GMO_BATCH_PROGRESSION WHERE PROGRESSION_ID = GMO_BATCH_PROGRESSION_REC.PROGRESSION_ID;
466: ELSIF l_document.PSIG_STATUS in ('COMPLETE','REJECTED','TIMEDOUT') then
467: UPDATE GMO_BATCH_PROGRESSION

Line 465: DELETE FROM GMO_BATCH_PROGRESSION WHERE PROGRESSION_ID = GMO_BATCH_PROGRESSION_REC.PROGRESSION_ID;

461: FOR GMO_BATCH_PROGRESSION_REC IN GMO_BATCH_PROGRESSION_CUR
462: LOOP
463: edr_psig.getdocumentdetails(GMO_BATCH_PROGRESSION_REC.ERECORD_ID,l_document,l_docparams,l_signatures,l_error,l_error_msg);
464: IF l_document.PSIG_STATUS = 'ERROR' THEN
465: DELETE FROM GMO_BATCH_PROGRESSION WHERE PROGRESSION_ID = GMO_BATCH_PROGRESSION_REC.PROGRESSION_ID;
466: ELSIF l_document.PSIG_STATUS in ('COMPLETE','REJECTED','TIMEDOUT') then
467: UPDATE GMO_BATCH_PROGRESSION
468: SET STATUS = 'COMPLETE'
469: WHERE PROGRESSION_ID = GMO_BATCH_PROGRESSION_REC.PROGRESSION_ID;

Line 467: UPDATE GMO_BATCH_PROGRESSION

463: edr_psig.getdocumentdetails(GMO_BATCH_PROGRESSION_REC.ERECORD_ID,l_document,l_docparams,l_signatures,l_error,l_error_msg);
464: IF l_document.PSIG_STATUS = 'ERROR' THEN
465: DELETE FROM GMO_BATCH_PROGRESSION WHERE PROGRESSION_ID = GMO_BATCH_PROGRESSION_REC.PROGRESSION_ID;
466: ELSIF l_document.PSIG_STATUS in ('COMPLETE','REJECTED','TIMEDOUT') then
467: UPDATE GMO_BATCH_PROGRESSION
468: SET STATUS = 'COMPLETE'
469: WHERE PROGRESSION_ID = GMO_BATCH_PROGRESSION_REC.PROGRESSION_ID;
470: IF l_document.EVENT_NAME in ('oracle.apps.qa.disp.create'
471: ,'oracle.apps.qa.disp.detail.approve'

Line 469: WHERE PROGRESSION_ID = GMO_BATCH_PROGRESSION_REC.PROGRESSION_ID;

465: DELETE FROM GMO_BATCH_PROGRESSION WHERE PROGRESSION_ID = GMO_BATCH_PROGRESSION_REC.PROGRESSION_ID;
466: ELSIF l_document.PSIG_STATUS in ('COMPLETE','REJECTED','TIMEDOUT') then
467: UPDATE GMO_BATCH_PROGRESSION
468: SET STATUS = 'COMPLETE'
469: WHERE PROGRESSION_ID = GMO_BATCH_PROGRESSION_REC.PROGRESSION_ID;
470: IF l_document.EVENT_NAME in ('oracle.apps.qa.disp.create'
471: ,'oracle.apps.qa.disp.detail.approve'
472: ,'oracle.apps.qa.disp.header.approve'
473: ,'oracle.apps.qa.disp.update'

Line 481: '||GMO_BATCH_PROGRESSION_REC.ERECORD_ID ||'

477: ,'oracle.apps.qa.ncm.update')
478: THEN
479: DBMS_LOB.CREATETEMPORARY(l_PROG_EREC,TRUE,DBMS_LOB.SESSION);
480: l_QA_XML :='
481: '||GMO_BATCH_PROGRESSION_REC.ERECORD_ID ||'
482:
483: ';
484: DBMS_LOB.append(l_PROG_EREC,l_QA_XML);
485: DBMS_LOB.append(l_PROG_EREC,l_document.PSIG_DOCUMENT);

Line 492: IF GMO_BATCH_PROGRESSION_REC.BATCHRSRC_ID is not null

488: ');
489:
490: -- add code for constructing XML for E-Record Object.
491: -- IF l_document.EVENT_NAME = 'oracle.apps.qa.ncm.create' THEN
492: IF GMO_BATCH_PROGRESSION_REC.BATCHRSRC_ID is not null
493: THEN
494: l_parent_node := 'RESOURCE_REQUIREMENTS';
495: l_parent_key_node := 'STEP_RESOURCE_ID';
496: l_parent_key_val := GMO_BATCH_PROGRESSION_REC.BATCHRSRC_ID;

Line 496: l_parent_key_val := GMO_BATCH_PROGRESSION_REC.BATCHRSRC_ID;

492: IF GMO_BATCH_PROGRESSION_REC.BATCHRSRC_ID is not null
493: THEN
494: l_parent_node := 'RESOURCE_REQUIREMENTS';
495: l_parent_key_node := 'STEP_RESOURCE_ID';
496: l_parent_key_val := GMO_BATCH_PROGRESSION_REC.BATCHRSRC_ID;
497: l_curr_node_key := 'ERECORD_ID';
498: l_curr_key_val := GMO_BATCH_PROGRESSION_REC.ERECORD_ID;
499: ELSIF GMO_BATCH_PROGRESSION_REC.BATCHACTIVITY_ID is not null
500: THEN

Line 498: l_curr_key_val := GMO_BATCH_PROGRESSION_REC.ERECORD_ID;

494: l_parent_node := 'RESOURCE_REQUIREMENTS';
495: l_parent_key_node := 'STEP_RESOURCE_ID';
496: l_parent_key_val := GMO_BATCH_PROGRESSION_REC.BATCHRSRC_ID;
497: l_curr_node_key := 'ERECORD_ID';
498: l_curr_key_val := GMO_BATCH_PROGRESSION_REC.ERECORD_ID;
499: ELSIF GMO_BATCH_PROGRESSION_REC.BATCHACTIVITY_ID is not null
500: THEN
501: l_parent_node := 'ACTIVITIES';
502: l_parent_key_node := 'STEP_ACTIVITY_ID';

Line 499: ELSIF GMO_BATCH_PROGRESSION_REC.BATCHACTIVITY_ID is not null

495: l_parent_key_node := 'STEP_RESOURCE_ID';
496: l_parent_key_val := GMO_BATCH_PROGRESSION_REC.BATCHRSRC_ID;
497: l_curr_node_key := 'ERECORD_ID';
498: l_curr_key_val := GMO_BATCH_PROGRESSION_REC.ERECORD_ID;
499: ELSIF GMO_BATCH_PROGRESSION_REC.BATCHACTIVITY_ID is not null
500: THEN
501: l_parent_node := 'ACTIVITIES';
502: l_parent_key_node := 'STEP_ACTIVITY_ID';
503: l_parent_key_val := GMO_BATCH_PROGRESSION_REC.BATCHACTIVITY_ID;

Line 503: l_parent_key_val := GMO_BATCH_PROGRESSION_REC.BATCHACTIVITY_ID;

499: ELSIF GMO_BATCH_PROGRESSION_REC.BATCHACTIVITY_ID is not null
500: THEN
501: l_parent_node := 'ACTIVITIES';
502: l_parent_key_node := 'STEP_ACTIVITY_ID';
503: l_parent_key_val := GMO_BATCH_PROGRESSION_REC.BATCHACTIVITY_ID;
504: l_curr_node_key := 'ERECORD_ID';
505: l_curr_key_val := GMO_BATCH_PROGRESSION_REC.ERECORD_ID;
506: ELSIF GMO_BATCH_PROGRESSION_REC.MATERIAL_LINE_ID is not null
507: THEN

Line 505: l_curr_key_val := GMO_BATCH_PROGRESSION_REC.ERECORD_ID;

501: l_parent_node := 'ACTIVITIES';
502: l_parent_key_node := 'STEP_ACTIVITY_ID';
503: l_parent_key_val := GMO_BATCH_PROGRESSION_REC.BATCHACTIVITY_ID;
504: l_curr_node_key := 'ERECORD_ID';
505: l_curr_key_val := GMO_BATCH_PROGRESSION_REC.ERECORD_ID;
506: ELSIF GMO_BATCH_PROGRESSION_REC.MATERIAL_LINE_ID is not null
507: THEN
508: l_parent_node := 'MATERIAL_REQUIREMENTS';
509: l_parent_key_node := 'MATERIAL_DETAIL_ID';

Line 506: ELSIF GMO_BATCH_PROGRESSION_REC.MATERIAL_LINE_ID is not null

502: l_parent_key_node := 'STEP_ACTIVITY_ID';
503: l_parent_key_val := GMO_BATCH_PROGRESSION_REC.BATCHACTIVITY_ID;
504: l_curr_node_key := 'ERECORD_ID';
505: l_curr_key_val := GMO_BATCH_PROGRESSION_REC.ERECORD_ID;
506: ELSIF GMO_BATCH_PROGRESSION_REC.MATERIAL_LINE_ID is not null
507: THEN
508: l_parent_node := 'MATERIAL_REQUIREMENTS';
509: l_parent_key_node := 'MATERIAL_DETAIL_ID';
510: l_parent_key_val := GMO_BATCH_PROGRESSION_REC.MATERIAL_LINE_ID;

Line 510: l_parent_key_val := GMO_BATCH_PROGRESSION_REC.MATERIAL_LINE_ID;

506: ELSIF GMO_BATCH_PROGRESSION_REC.MATERIAL_LINE_ID is not null
507: THEN
508: l_parent_node := 'MATERIAL_REQUIREMENTS';
509: l_parent_key_node := 'MATERIAL_DETAIL_ID';
510: l_parent_key_val := GMO_BATCH_PROGRESSION_REC.MATERIAL_LINE_ID;
511: l_curr_node_key := 'ERECORD_ID';
512: l_curr_key_val := GMO_BATCH_PROGRESSION_REC.ERECORD_ID;
513:
514: ELSIF GMO_BATCH_PROGRESSION_REC.BATCHSTEP_ID is not null

Line 512: l_curr_key_val := GMO_BATCH_PROGRESSION_REC.ERECORD_ID;

508: l_parent_node := 'MATERIAL_REQUIREMENTS';
509: l_parent_key_node := 'MATERIAL_DETAIL_ID';
510: l_parent_key_val := GMO_BATCH_PROGRESSION_REC.MATERIAL_LINE_ID;
511: l_curr_node_key := 'ERECORD_ID';
512: l_curr_key_val := GMO_BATCH_PROGRESSION_REC.ERECORD_ID;
513:
514: ELSIF GMO_BATCH_PROGRESSION_REC.BATCHSTEP_ID is not null
515: THEN
516: l_parent_node := 'ROUTING_STEPS';

Line 514: ELSIF GMO_BATCH_PROGRESSION_REC.BATCHSTEP_ID is not null

510: l_parent_key_val := GMO_BATCH_PROGRESSION_REC.MATERIAL_LINE_ID;
511: l_curr_node_key := 'ERECORD_ID';
512: l_curr_key_val := GMO_BATCH_PROGRESSION_REC.ERECORD_ID;
513:
514: ELSIF GMO_BATCH_PROGRESSION_REC.BATCHSTEP_ID is not null
515: THEN
516: l_parent_node := 'ROUTING_STEPS';
517: l_parent_key_node := 'STEP_ID';
518: l_parent_key_val := GMO_BATCH_PROGRESSION_REC.BATCHSTEP_ID;

Line 518: l_parent_key_val := GMO_BATCH_PROGRESSION_REC.BATCHSTEP_ID;

514: ELSIF GMO_BATCH_PROGRESSION_REC.BATCHSTEP_ID is not null
515: THEN
516: l_parent_node := 'ROUTING_STEPS';
517: l_parent_key_node := 'STEP_ID';
518: l_parent_key_val := GMO_BATCH_PROGRESSION_REC.BATCHSTEP_ID;
519: l_curr_node_key := 'ERECORD_ID';
520: l_curr_key_val := GMO_BATCH_PROGRESSION_REC.ERECORD_ID;
521:
522: ELSIF GMO_BATCH_PROGRESSION_REC.BATCH_ID is not null

Line 520: l_curr_key_val := GMO_BATCH_PROGRESSION_REC.ERECORD_ID;

516: l_parent_node := 'ROUTING_STEPS';
517: l_parent_key_node := 'STEP_ID';
518: l_parent_key_val := GMO_BATCH_PROGRESSION_REC.BATCHSTEP_ID;
519: l_curr_node_key := 'ERECORD_ID';
520: l_curr_key_val := GMO_BATCH_PROGRESSION_REC.ERECORD_ID;
521:
522: ELSIF GMO_BATCH_PROGRESSION_REC.BATCH_ID is not null
523: THEN
524: l_parent_node := 'HEADER_INFORMATION';

Line 522: ELSIF GMO_BATCH_PROGRESSION_REC.BATCH_ID is not null

518: l_parent_key_val := GMO_BATCH_PROGRESSION_REC.BATCHSTEP_ID;
519: l_curr_node_key := 'ERECORD_ID';
520: l_curr_key_val := GMO_BATCH_PROGRESSION_REC.ERECORD_ID;
521:
522: ELSIF GMO_BATCH_PROGRESSION_REC.BATCH_ID is not null
523: THEN
524: l_parent_node := 'HEADER_INFORMATION';
525: l_parent_key_node := 'BATCH_ID';
526: l_parent_key_val := GMO_BATCH_PROGRESSION_REC.BATCH_ID;

Line 526: l_parent_key_val := GMO_BATCH_PROGRESSION_REC.BATCH_ID;

522: ELSIF GMO_BATCH_PROGRESSION_REC.BATCH_ID is not null
523: THEN
524: l_parent_node := 'HEADER_INFORMATION';
525: l_parent_key_node := 'BATCH_ID';
526: l_parent_key_val := GMO_BATCH_PROGRESSION_REC.BATCH_ID;
527: l_curr_node_key := 'ERECORD_ID';
528: l_curr_key_val := GMO_BATCH_PROGRESSION_REC.ERECORD_ID;
529: END IF;
530: -- END IF;

Line 528: l_curr_key_val := GMO_BATCH_PROGRESSION_REC.ERECORD_ID;

524: l_parent_node := 'HEADER_INFORMATION';
525: l_parent_key_node := 'BATCH_ID';
526: l_parent_key_val := GMO_BATCH_PROGRESSION_REC.BATCH_ID;
527: l_curr_node_key := 'ERECORD_ID';
528: l_curr_key_val := GMO_BATCH_PROGRESSION_REC.ERECORD_ID;
529: END IF;
530: -- END IF;
531: UPDATE GMO_BATCH_PROGRESSION
532: SET XML_EREC = l_PROG_EREC,

Line 531: UPDATE GMO_BATCH_PROGRESSION

527: l_curr_node_key := 'ERECORD_ID';
528: l_curr_key_val := GMO_BATCH_PROGRESSION_REC.ERECORD_ID;
529: END IF;
530: -- END IF;
531: UPDATE GMO_BATCH_PROGRESSION
532: SET XML_EREC = l_PROG_EREC,
533: PARENT_NODE = l_parent_node,
534: PARENT_KEY_NODE = l_parent_key_node,
535: PARENT_KEY_VAL = l_parent_key_val,

Line 538: WHERE PROGRESSION_ID = GMO_BATCH_PROGRESSION_REC.PROGRESSION_ID;

534: PARENT_KEY_NODE = l_parent_key_node,
535: PARENT_KEY_VAL = l_parent_key_val,
536: CURR_NODE_KEY = l_curr_node_key,
537: CURR_KEY_VAL = l_curr_key_val
538: WHERE PROGRESSION_ID = GMO_BATCH_PROGRESSION_REC.PROGRESSION_ID;
539: l_parent_node := null;
540: l_parent_key_node := null;
541: l_parent_key_val := null;
542: l_curr_node_key := null;

Line 559: UPDATE GMO_BATCH_PROGRESSION

555:
556: PROCEDURE UPDATE_PROGRESSION_STATUS(P_BATCH_ID IN NUMBER ,P_BATCHSTEP_ID IN NUMBER,P_EVENT_NAME IN VARCHAR2) IS
557: BEGIN
558: IF P_EVENT_NAME='oracle.apps.gme.batch.complete' THEN
559: UPDATE GMO_BATCH_PROGRESSION
560: SET STATUS='BYPASSED'
561: WHERE BATCH_ID = P_BATCH_ID
562: AND STATUS='PENDING'
563: AND EVENT IN ('oracle.apps.gme.batch.release'

Line 568: UPDATE GMO_BATCH_PROGRESSION

564: ,'oracle.apps.gme.batchstep.release'
565: ,'oracle.apps.gme.batchstep.complete');
566: ELSIF P_EVENT_NAME='oracle.apps.gme.batch.cancel' THEN
567: -- Bug 5499897 : rvsingh : start
568: UPDATE GMO_BATCH_PROGRESSION
569: SET STATUS='CANCEL'
570: WHERE BATCH_ID = P_BATCH_ID
571: AND STATUS IN ('PENDING','INPROGRESS');
572: -- Bug 5499897 : rvsingh : End

Line 574: UPDATE GMO_BATCH_PROGRESSION

570: WHERE BATCH_ID = P_BATCH_ID
571: AND STATUS IN ('PENDING','INPROGRESS');
572: -- Bug 5499897 : rvsingh : End
573: ELSIF P_EVENT_NAME='oracle.apps.gme.batch.reroute' THEN
574: UPDATE GMO_BATCH_PROGRESSION
575: SET STATUS='CANCEL'
576: WHERE BATCH_ID = P_BATCH_ID
577: AND STATUS='PENDING'
578: AND EVENT IN ('oracle.apps.gme.batchstep.complete'

Line 582: UPDATE GMO_BATCH_PROGRESSION

578: AND EVENT IN ('oracle.apps.gme.batchstep.complete'
579: ,'oracle.apps.gme.batchstep.release'
580: ,'oracle.apps.gme.batchstep.close');
581: -- Bug 5499897 : rvsingh : start
582: UPDATE GMO_BATCH_PROGRESSION
583: SET STATUS='CANCEL'
584: WHERE BATCH_ID = P_BATCH_ID
585: AND STATUS='INPROGRESS'
586: AND EVENT = 'oracle.apps.gmo.instrset.update';

Line 590: UPDATE GMO_BATCH_PROGRESSION

586: AND EVENT = 'oracle.apps.gmo.instrset.update';
587: -- Bug 5499897 : rvsingh : End
588: ELSIF P_EVENT_NAME='oracle.apps.gme.batch.terminate' THEN
589: -- Bug 5499897 : rvsingh : start
590: UPDATE GMO_BATCH_PROGRESSION
591: SET STATUS='TERMINATE'
592: WHERE BATCH_ID = P_BATCH_ID
593: AND STATUS IN ('PENDING','INPROGRESS');
594: -- Bug 5499897 : rvsingh : End

Line 596: UPDATE GMO_BATCH_PROGRESSION

592: WHERE BATCH_ID = P_BATCH_ID
593: AND STATUS IN ('PENDING','INPROGRESS');
594: -- Bug 5499897 : rvsingh : End
595: ELSIF P_EVENT_NAME='oracle.apps.gme.batch.close' THEN
596: UPDATE GMO_BATCH_PROGRESSION
597: SET STATUS='BYPASSED'
598: WHERE BATCH_ID = P_BATCH_ID
599: AND STATUS='PENDING'
600: AND EVENT ='oracle.apps.gme.batchstep.close';

Line 602: UPDATE GMO_BATCH_PROGRESSION

598: WHERE BATCH_ID = P_BATCH_ID
599: AND STATUS='PENDING'
600: AND EVENT ='oracle.apps.gme.batchstep.close';
601: -- Bug 5499897 : rvsingh : start
602: UPDATE GMO_BATCH_PROGRESSION
603: SET STATUS='OPTIONAL_ACK'
604: WHERE BATCH_ID = P_BATCH_ID
605: AND STATUS='INPROGRESS'
606: AND EVENT = 'oracle.apps.gmo.instrset.update';

Line 609: UPDATE GMO_BATCH_PROGRESSION

605: AND STATUS='INPROGRESS'
606: AND EVENT = 'oracle.apps.gmo.instrset.update';
607: -- Bug 5499897 : rvsingh : End
608: ELSIF P_EVENT_NAME='oracle.apps.gme.batchstep.complete' THEN
609: UPDATE GMO_BATCH_PROGRESSION
610: SET STATUS='BYPASSED'
611: WHERE BATCH_ID = P_BATCH_ID
612: AND BATCHSTEP_ID = P_BATCHSTEP_ID
613: AND STATUS='PENDING'

Line 617: UPDATE GMO_BATCH_PROGRESSION

613: AND STATUS='PENDING'
614: AND EVENT ='oracle.apps.gme.batchstep.release';
615: ELSIF P_EVENT_NAME='oracle.apps.gme.batchstep.close' THEN
616: -- Bug 5499897 : rvsingh : start
617: UPDATE GMO_BATCH_PROGRESSION
618: SET STATUS='OPTIONAL_ACK'
619: WHERE BATCH_ID = P_BATCH_ID
620: AND BATCHSTEP_ID = P_BATCHSTEP_ID
621: AND STATUS='INPROGRESS'

Line 631: l_batch_prog_rec GMO_BATCH_PROGRESSION%ROWTYPE;

627:
628:
629:
630: FUNCTION PROCESS_EVENT (P_SUBSCRIPTION_GUID IN RAW, P_EVENT IN OUT NOCOPY WF_EVENT_T) RETURN VARCHAR2 IS
631: l_batch_prog_rec GMO_BATCH_PROGRESSION%ROWTYPE;
632: l_batch_progression_id NUMBER := NULL;
633: l_event_name varchar2(80) := NULL;
634: l_event_key varchar2(80) := NULL;
635: l_user_key_label varchar2(80) := NULL;

Line 942: delete GMO_BATCH_PROGRESSION

938: ,'oracle.apps.gme.batchstep.release'
939: ,'oracle.apps.gme.batchstep.close')
940: THEN
941: /* delete progression row created when batch is created */
942: delete GMO_BATCH_PROGRESSION
943: where event = l_event_name
944: AND event_key = l_event_key
945: AND STATUS = 'PENDING';
946: END IF;

Line 996: l_batch_prog_rec GMO_BATCH_PROGRESSION%ROWTYPE;

992: END;
993:
994:
995: PROCEDURE INSERT_BATH_EVENTS(P_BATCH_ID IN NUMBER) IS
996: l_batch_prog_rec GMO_BATCH_PROGRESSION%ROWTYPE;
997: l_batch_progression_id NUMBER;
998: l_step_label VARCHAR2(400);
999: l_step_user_val VARCHAR2(400);
1000: CURSOR Get_BATCH_DETAILS IS

Line 1362: l_batch_prog_rec GMO_BATCH_PROGRESSION%ROWTYPE;

1358: l_parent_key_node VARCHAR2(80) := NULL;
1359: l_parent_key_val VARCHAR2(80) := NULL;
1360: l_curr_node_key VARCHAR2(80) := NULL;
1361: l_curr_key_val VARCHAR2(80) := NULL;
1362: l_batch_prog_rec GMO_BATCH_PROGRESSION%ROWTYPE;
1363: l_batch_progression_id NUMBER := NULL;
1364: l_message_prod VARCHAR2(10) := 'GMO';
1365: l_message_token VARCHAR2(50) := NULL;
1366: l_user_key_label VARCHAR2(80) := NULL;

Line 1384: delete GMO_BATCH_PROGRESSION

1380: CURSOR get_resource_details IS
1381: SELECT BATCH_ID,BATCHSTEP_ID,BATCHSTEP_ACTIVITY_ID FROM GME_BATCH_STEP_RESOURCES
1382: where BATCHSTEP_RESOURCE_ID = p_entity_key;
1383: BEGIN
1384: delete GMO_BATCH_PROGRESSION
1385: where event = P_EVENT_NAME
1386: AND event_key = p_event_key
1387: AND STATUS = 'INPROGRESS';
1388:

Line 1565: from gmo_batch_progression

1561: l_event_name VARCHAR2(240);
1562: l_return_status varchar2(10);
1563: CURSOR get_pending_instr_curr (p_event_name VARCHAR2,p_event_key VARCHAR2) is
1564: select STATUS
1565: from gmo_batch_progression
1566: where event =p_event_name
1567: and EVENT_KEY=p_event_key
1568: and STATUS = 'INPROGRESS' ;
1569: BEGIN

Line 1623: DELETE GMO_BATCH_PROGRESSION

1619: BEGIN
1620:
1621: IF P_BATCH_PROGRESSION_ID IS NOT NULL
1622: THEN
1623: DELETE GMO_BATCH_PROGRESSION
1624: WHERE PROGRESSION_ID = P_BATCH_PROGRESSION_ID;
1625: X_RETURN_STATUS := 'S';
1626: ELSIF P_ERECORD_ID IS NOT NULL
1627: THEN

Line 1628: DELETE GMO_BATCH_PROGRESSION

1624: WHERE PROGRESSION_ID = P_BATCH_PROGRESSION_ID;
1625: X_RETURN_STATUS := 'S';
1626: ELSIF P_ERECORD_ID IS NOT NULL
1627: THEN
1628: DELETE GMO_BATCH_PROGRESSION
1629: WHERE ERECORD_ID = P_ERECORD_ID;
1630: X_RETURN_STATUS := 'S';
1631: ELSIF ((P_EVENT IS NOT NULL) and (P_EVENT_KEY IS NOT NULL))
1632: THEN

Line 1633: DELETE GMO_BATCH_PROGRESSION

1629: WHERE ERECORD_ID = P_ERECORD_ID;
1630: X_RETURN_STATUS := 'S';
1631: ELSIF ((P_EVENT IS NOT NULL) and (P_EVENT_KEY IS NOT NULL))
1632: THEN
1633: DELETE GMO_BATCH_PROGRESSION
1634: WHERE EVENT = P_EVENT
1635: AND EVENT_KEY = P_EVENT_KEY;
1636: X_RETURN_STATUS := 'S';
1637: ELSE