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.OKE_CHG_REQUESTS_WF dependencies on OKE_CHG_REQUESTS

Line 1: PACKAGE BODY OKE_CHG_REQUESTS_WF AS

1: PACKAGE BODY OKE_CHG_REQUESTS_WF AS
2: /* $Header: OKEWCRQB.pls 120.1 2011/05/27 08:10:43 skuchima ship $ */
3:
4: --
5: -- Private Functions and Procedures

Line 187: WF_Core.Context( 'OKE_CHG_REQUESTS_WF'

183: WHEN OTHERS THEN
184: ResultOut := 'ERROR';
185: WF_Engine.SetItemAttrText
186: ( ItemType => ItemType , ItemKey => ItemKey , AName => 'ERRORTEXT' , AValue => sqlerrm );
187: WF_Core.Context( 'OKE_CHG_REQUESTS_WF'
188: , 'INITIALIZE'
189: , ItemType , ItemKey , to_char(ActID) , FuncMode , ResultOut );
190: RAISE;
191:

Line 284: WF_Core.Context( 'OKE_CHG_REQUESTS_WF'

280: WHEN OTHERS THEN
281: ResultOut := 'ERROR:';
282: WF_Engine.SetItemAttrText
283: ( ItemType => ItemType , ItemKey => ItemKey , AName => 'ERRORTEXT' , AValue => sqlerrm );
284: WF_Core.Context( 'OKE_CHG_REQUESTS_WF'
285: , 'SELECT_NEXT_APPROVER'
286: , ItemType , ItemKey , to_char(ActID) , FuncMode , ResultOut );
287: RAISE;
288:

Line 365: WF_Core.Context( 'OKE_CHG_REQUESTS_WF'

361: WHEN OTHERS THEN
362: ResultOut := 'ERROR:';
363: WF_Engine.SetItemAttrText
364: ( ItemType => ItemType , ItemKey => ItemKey , AName => 'ERRORTEXT' , AValue => sqlerrm );
365: WF_Core.Context( 'OKE_CHG_REQUESTS_WF'
366: , 'SELECT_NEXT_INFORMED'
367: , ItemType , ItemKey , to_char(ActID) , FuncMode , ResultOut );
368: RAISE;
369:

Line 429: WF_Core.Context( 'OKE_CHG_REQUESTS_WF'

425: WHEN OTHERS THEN
426: ResultOut := 'ERROR:';
427: WF_Engine.SetItemAttrText
428: ( ItemType => ItemType , ItemKey => ItemKey , AName => 'ERRORTEXT' , AValue => sqlerrm );
429: WF_Core.Context( 'OKE_CHG_REQUESTS_WF'
430: , 'REJ_NOTE_FILLED'
431: , ItemType , ItemKey , to_char(ActID) , FuncMode , ResultOut );
432: RAISE;
433:

Line 493: WF_Core.Context( 'OKE_CHG_REQUESTS_WF'

489: WHEN OTHERS THEN
490: ResultOut := 'ERROR:';
491: WF_Engine.SetItemAttrText
492: ( ItemType => ItemType , ItemKey => ItemKey , AName => 'ERRORTEXT' , AValue => sqlerrm );
493: WF_Core.Context( 'OKE_CHG_REQUESTS_WF'
494: , 'IMPACT_FUNDING'
495: , ItemType , ItemKey , to_char(ActID) , FuncMode , ResultOut );
496: RAISE;
497:

Line 530: FROM oke_chg_requests

526:
527: CURSOR c(p_Chg_Request_ID IN number )
528: is
529: SELECT *
530: FROM oke_chg_requests
531: WHERE chg_request_id =p_CHG_REQUEST_ID ;
532:
533: BEGIN
534: L_Approved_Status := Default_Chg_Status('APPROVED');

Line 550: OKE_CHG_REQUESTS_PKG.UPDATE_ROW

546:
547: --added this as part of fix 12414859 skuchima
548: FOR c_rec IN c(l_chg_request_id) LOOP
549:
550: OKE_CHG_REQUESTS_PKG.UPDATE_ROW
551: ( X_CHG_REQUEST_ID => L_Chg_Request_ID
552: , X_LAST_UPDATE_DATE => sysdate
553: , X_LAST_UPDATED_BY => c_rec.LAST_UPDATED_BY
554: , X_LAST_UPDATE_LOGIN => c_rec.LAST_UPDATE_LOGIN

Line 592: /* UPDATE oke_chg_requests

588: );
589:
590: END LOOP;
591:
592: /* UPDATE oke_chg_requests
593: SET chg_status_code = L_Approved_Status
594: , last_update_date = sysdate
595: WHERE chg_request_id = L_Chg_Request_ID;*/ --skuchima bug12414859
596:

Line 622: WF_Core.Context( 'OKE_CHG_REQUESTS_WF'

618: ResultOut := 'ERROR:';
619: WF_Engine.SetItemAttrText
620: ( ItemType => ItemType , ItemKey => ItemKey , AName => 'ERRORTEXT'
621: , AValue => FND_MESSAGE.Get_String('OKE' , 'OKE_CHGREQ_NODEF_APPR_STS') );
622: WF_Core.Context( 'OKE_CHG_REQUESTS_WF'
623: , 'SET_APPROVED_STATUS'
624: , ItemType , ItemKey , to_char(ActID) , FuncMode , ResultOut );
625: RAISE;
626:

Line 631: WF_Core.Context( 'OKE_CHG_REQUESTS_WF'

627: WHEN OTHERS THEN
628: ResultOut := 'ERROR:';
629: WF_Engine.SetItemAttrText
630: ( ItemType => ItemType , ItemKey => ItemKey , AName => 'ERRORTEXT' , AValue => sqlerrm );
631: WF_Core.Context( 'OKE_CHG_REQUESTS_WF'
632: , 'SET_APPROVED_STATUS'
633: , ItemType , ItemKey , to_char(ActID) , FuncMode , ResultOut );
634: RAISE;
635:

Line 668: FROM oke_chg_requests

664:
665: CURSOR c(p_Chg_Request_ID IN number )
666: is
667: SELECT *
668: FROM oke_chg_requests
669: WHERE chg_request_id =p_CHG_REQUEST_ID ;
670:
671: BEGIN
672: L_Rejected_Status := Default_Chg_Status('REJECTED');

Line 689: OKE_CHG_REQUESTS_PKG.UPDATE_ROW

685: --added this as part of fix 12414859 skuchima
686:
687: FOR c_rec IN c(l_chg_request_id) LOOP
688:
689: OKE_CHG_REQUESTS_PKG.UPDATE_ROW
690: ( X_CHG_REQUEST_ID => L_Chg_Request_ID
691: , X_LAST_UPDATE_DATE => sysdate
692: , X_LAST_UPDATED_BY => c_rec.LAST_UPDATED_BY
693: , X_LAST_UPDATE_LOGIN => c_rec.LAST_UPDATE_LOGIN

Line 732: /* UPDATE oke_chg_requests

728:
729: END LOOP;
730:
731:
732: /* UPDATE oke_chg_requests
733: SET chg_status_code = L_Rejected_Status
734: , last_update_date = sysdate
735: WHERE chg_request_id = L_Chg_Request_ID;*/ --skuchima bug12414859
736:

Line 762: WF_Core.Context( 'OKE_CHG_REQUESTS_WF'

758: ResultOut := 'ERROR:';
759: WF_Engine.SetItemAttrText
760: ( ItemType => ItemType , ItemKey => ItemKey , AName => 'ERRORTEXT'
761: , AValue => FND_MESSAGE.Get_String('OKE' , 'OKE_CHGREQ_NODEF_REJ_STS') );
762: WF_Core.Context( 'OKE_CHG_REQUESTS_WF'
763: , 'SET_APPROVED_STATUS'
764: , ItemType , ItemKey , to_char(ActID) , FuncMode , ResultOut );
765: RAISE;
766:

Line 771: WF_Core.Context( 'OKE_CHG_REQUESTS_WF'

767: WHEN OTHERS THEN
768: ResultOut := 'ERROR';
769: WF_Engine.SetItemAttrText
770: ( ItemType => ItemType , ItemKey => ItemKey , AName => 'ERRORTEXT' , AValue => sqlerrm );
771: WF_Core.Context( 'OKE_CHG_REQUESTS_WF'
772: , 'SET_REJECTED_STATUS'
773: , ItemType , ItemKey , to_char(ActID) , FuncMode , ResultOut );
774: RAISE;
775:

Line 779: END OKE_CHG_REQUESTS_WF;

775:
776: END Set_Rejected_Status;
777:
778:
779: END OKE_CHG_REQUESTS_WF;