DBA Data[Home] [Help]

APPS.AR_CMGT_WF_ENGINE dependencies on WF_NOTIFICATION

Line 578: WF_NOTIFICATION.send

574: IF l_failure_function = 'CREDIT_POLICY'
575: THEN
576:
577: l_notification_id :=
578: WF_NOTIFICATION.send
579: ( role => wf_engine.context_text,
580: msg_type => 'ARCMGTAP',
581: msg_name => 'MSG_TO_CA_INV_POLICY_SUBMIT',
582: callback => 'WF_ENGINE.CB',

Line 588: WF_NOTIFICATION.send

584:
585: ELSIF l_failure_function = 'SCORING_MODEL'
586: THEN
587: l_notification_id :=
588: WF_NOTIFICATION.send
589: ( role => wf_engine.context_text,
590: msg_type => 'ARCMGTAP',
591: msg_name => 'MSG_CA_NO_SM',
592: callback => 'WF_ENGINE.CB',

Line 597: WF_NOTIFICATION.send

593: context => itemtype||':'||itemkey||':'||to_char(actid));
594: ELSIF l_failure_function = 'SCORING_CURRENCY'
595: THEN
596: l_notification_id :=
597: WF_NOTIFICATION.send
598: ( role => wf_engine.context_text,
599: msg_type => 'ARCMGTAP',
600: msg_name => 'MSG_TO_CA_CURRENCY_NOT_MATCH',
601: callback => 'WF_ENGINE.CB',

Line 606: WF_NOTIFICATION.send

602: context => itemtype||':'||itemkey||':'||to_char(actid));
603: ELSIF l_failure_function = 'MANUAL_ANALYSIS'
604: THEN
605: l_notification_id :=
606: WF_NOTIFICATION.send
607: ( role => wf_engine.context_text,
608: msg_type => 'ARCMGTAP',
609: msg_name => 'MSG_TO_CA_MANUAL_ANALYSIS',
610: callback => 'WF_ENGINE.CB',

Line 615: WF_NOTIFICATION.send

611: context => itemtype||':'||itemkey||':'||to_char(actid));
612: ELSIF l_failure_function = 'SKIP_APPROVAL'
613: THEN
614: l_notification_id :=
615: WF_NOTIFICATION.send
616: ( role => wf_engine.context_text,
617: msg_type => 'ARCMGTAP',
618: msg_name => 'REASG_MSG_TO_CA_SKIP_APPROVAL',
619: callback => 'WF_ENGINE.CB',

Line 624: WF_NOTIFICATION.send

620: context => itemtype||':'||itemkey||':'||to_char(actid));
621: ELSIF l_failure_function = 'GATHER_DATA_POINTS'
622: THEN
623: l_notification_id :=
624: WF_NOTIFICATION.send
625: ( role => wf_engine.context_text,
626: msg_type => 'ARCMGTAP',
627: msg_name => 'MSG_TO_CA_NO_CF_CREATED',
628: callback => 'WF_ENGINE.CB',

Line 633: WF_NOTIFICATION.send

629: context => itemtype||':'||itemkey||':'||to_char(actid));
630: ELSIF l_failure_function = 'GENERATE_RECOMMENDATION'
631: THEN
632: l_notification_id :=
633: WF_NOTIFICATION.send
634: ( role => wf_engine.context_text,
635: msg_type => 'ARCMGTAP',
636: msg_name => 'MSG_TO_CA_NO_RECO',
637: callback => 'WF_ENGINE.CB',

Line 642: WF_NOTIFICATION.send

638: context => itemtype||':'||itemkey||':'||to_char(actid));
639: ELSIF l_failure_function = 'VALIDATE_RECO'
640: THEN
641: l_notification_id :=
642: WF_NOTIFICATION.send
643: ( role => wf_engine.context_text,
644: msg_type => 'ARCMGTAP',
645: msg_name => 'MSG_TO_CA_INVALID_RECO',
646: callback => 'WF_ENGINE.CB',

Line 652: WF_NOTIFICATION.send

648:
649: ELSIF l_failure_function = 'DUPLICATE_CASE_FOLDER'
650: THEN
651: l_notification_id :=
652: WF_NOTIFICATION.send
653: ( role => wf_engine.context_text,
654: msg_type => 'ARCMGTAP',
655: msg_name => 'MESSAGE_APPEAL_INITIATED',
656: callback => 'WF_ENGINE.CB',

Line 3764: FROM wf_item_activity_statuses wfs, wf_notifications wfn

3760: -- Fix for Bug 7167583
3761: -- Cursor to retrieve the notification_id and the current user
3762: CURSOR get_notification_info IS
3763: SELECT wfn.notification_id, wfs.assigned_user
3764: FROM wf_item_activity_statuses wfs, wf_notifications wfn
3765: WHERE wfs.item_type = 'ARCMGTAP'
3766: AND wfs.item_key = p_itemkey
3767: AND wfs.notification_id is not null
3768: AND wfs.notification_id = wfn.notification_id

Line 3805: WF_NOTIFICATION.Transfer(nid => c_get_notification_info.notification_id,

3801:
3802: -- Fix for Bug 7167583
3803: -- Transfer the notification from the current to new credit analyst
3804: FOR c_get_notification_info IN get_notification_info LOOP
3805: WF_NOTIFICATION.Transfer(nid => c_get_notification_info.notification_id,
3806: new_role => l_user_name,
3807: forward_comment => null,
3808: user => c_get_notification_info.assigned_user,
3809: cnt => 0,