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.

[Home] [Help]

APPS.PQH_SS_WORKFLOW dependencies on WF_NOTIFICATION

Line 245: FROM wf_notifications

241:
242: CURSOR cur_not IS
243: SELECT SUBSTR(context,1,INSTR(context,':',1)-1)
244: ,SUBSTR(context,INSTR(context,':')+1, ( INSTR(context,':',INSTR(context,':')+1 ) - INSTR(context,':')-1) )
245: FROM wf_notifications
246: WHERE notification_id = p_ntfId;
247: BEGIN
248: IF ( cur_ias%ISOPEN ) THEN
249: CLOSE cur_ias;

Line 346: l_ntf_name := WF_NOTIFICATION.getattrtext(l_ntfId,'HR_NTF_IDENTIFIER');

342: l_ntfId NUMBER;
343:
344: BEGIN
345: l_ntfId := get_notification_id(p_itemType,p_itemKey);
346: l_ntf_name := WF_NOTIFICATION.getattrtext(l_ntfId,'HR_NTF_IDENTIFIER');
347:
348: IF (l_ntf_name = 'HR_EMBED_ON_APPR_NTFY_HR_REP') THEN
349: RETURN true;
350: END IF;

Line 590: wf_notification.setattrtext(

586: --
587: --
588: if l_activity_name is not null then
589: if (notid is not null) then
590: wf_notification.setattrtext(
591: notid
592: ,'RESULT'
593: ,p_resultCode);
594: wf_notification.respond(

Line 594: wf_notification.respond(

590: wf_notification.setattrtext(
591: notid
592: ,'RESULT'
593: ,p_resultCode);
594: wf_notification.respond(
595: notid
596: ,null
597: ,fnd_global.user_name
598: ,null);

Line 678: wf_notification.setattrtext(

674: ELSIF (l_initialSFL = 'Y') THEN
675:
676: l_NtfId := get_notification_id(itemtype, itemKey);
677:
678: wf_notification.setattrtext(
679: l_NtfId
680: ,'WF_NOTE'
681: ,wf_engine.GetItemAttrText(
682: itemtype

Line 691: wf_notification.propagatehistory(

687: ,itemkey
688: ,'APPROVAL_COMMENT_COPY'
689: ,null);
690: ELSE
691: wf_notification.propagatehistory(
692: itemtype
693: ,itemkey
694: ,'APPROVAL_NOTIFICATION'
695: ,fnd_global.user_name

Line 2187: wf_notification.setattrtext(

2183: ,aname => 'WF_NOTE'
2184: ,avalue => NULL );
2185:
2186:
2187: wf_notification.setattrtext(
2188: p_ntfId
2189: ,'RESULT'
2190: ,'RETURNEDFORCORRECTION');
2191: BEGIN

Line 2192: wf_notification.setattrtext(

2188: p_ntfId
2189: ,'RESULT'
2190: ,'RETURNEDFORCORRECTION');
2191: BEGIN
2192: wf_notification.setattrtext(
2193: p_ntfId
2194: ,'WF_NOTE'
2195: ,p_note);
2196: EXCEPTION WHEN OTHERS THEN

Line 2198: wf_notification.propagatehistory(

2194: ,'WF_NOTE'
2195: ,p_note);
2196: EXCEPTION WHEN OTHERS THEN
2197: -- RFC from SFL Other
2198: wf_notification.propagatehistory(
2199: l_itemType
2200: ,l_itemKey
2201: ,'APPROVAL_NOTIFICATION'
2202: ,fnd_global.user_name

Line 2211: wf_notification.respond(

2207: END;
2208:
2209: -- Send Notification
2210:
2211: wf_notification.respond(
2212: p_ntfId
2213: ,null
2214: ,fnd_global.user_name
2215: ,null);

Line 2224: wf_notification.setAttrText(

2220: ,p_itemKey => l_itemKey);
2221:
2222:
2223: -- Set the from attribute for RFC notification.
2224: wf_notification.setAttrText(
2225: nid => l_ntfId
2226: ,aname => '#FROM_ROLE'
2227: ,avalue => fnd_global.user_name );
2228:

Line 2303: FROM wf_notifications wn, wf_message_attributes_vl wma

2299: ,p_itemType in varchar2) return varchar2 IS
2300: --
2301: CURSOR cur_ntf IS
2302: SELECT wma.display_name
2303: FROM wf_notifications wn, wf_message_attributes_vl wma
2304: WHERE wn.notification_id = p_ntfId
2305: AND wn.message_name = wma.message_name
2306: AND wma.message_type = p_itemType
2307: AND wma.name = 'EDIT_TXN_URL';

Line 2354: document_type := wf_notification.doc_html;

2350: WHERE item_type = c_itemType
2351: AND item_key = c_itemKey;
2352: --
2353: BEGIN
2354: document_type := wf_notification.doc_html;
2355: l_ntfId := document_id;
2356:
2357: -- l_ntfId := SUBSTR(document_id,1,INSTR(document_id,':')-1);
2358: -- l_checkProfile := SUBSTR(document_id,INSTR(document_id,':')+1);

Line 2967: document_type := wf_notification.doc_html;

2963: if ( is_notification_closed(document_id) = 'Y') then
2964: return;
2965: end if;
2966: --
2967: document_type := wf_notification.doc_html;
2968:
2969: -- Document will only have the notification id
2970: -- fetch the wf itemType and key from notification
2971: get_item_type_and_key (

Line 2998: lv_ntf_role WF_NOTIFICATIONS.RECIPIENT_ROLE%type;

2994: FUNCTION is_notification_closed (
2995: p_ntfId IN VARCHAR2 ) RETURN VARCHAR2 IS
2996: --
2997: l_isClosed VARCHAR2(10) := 'N';
2998: lv_ntf_role WF_NOTIFICATIONS.RECIPIENT_ROLE%type;
2999: lv_ntf_msg_typ WF_NOTIFICATIONS.MESSAGE_TYPE%type;
3000: lv_ntf_msg_name WF_NOTIFICATIONS.MESSAGE_NAME%type;
3001: lv_ntf_prior WF_NOTIFICATIONS.PRIORITY%type;
3002: lv_ntf_due WF_NOTIFICATIONS.DUE_DATE%type;

Line 2999: lv_ntf_msg_typ WF_NOTIFICATIONS.MESSAGE_TYPE%type;

2995: p_ntfId IN VARCHAR2 ) RETURN VARCHAR2 IS
2996: --
2997: l_isClosed VARCHAR2(10) := 'N';
2998: lv_ntf_role WF_NOTIFICATIONS.RECIPIENT_ROLE%type;
2999: lv_ntf_msg_typ WF_NOTIFICATIONS.MESSAGE_TYPE%type;
3000: lv_ntf_msg_name WF_NOTIFICATIONS.MESSAGE_NAME%type;
3001: lv_ntf_prior WF_NOTIFICATIONS.PRIORITY%type;
3002: lv_ntf_due WF_NOTIFICATIONS.DUE_DATE%type;
3003: lv_ntf_status WF_NOTIFICATIONS.STATUS%type;

Line 3000: lv_ntf_msg_name WF_NOTIFICATIONS.MESSAGE_NAME%type;

2996: --
2997: l_isClosed VARCHAR2(10) := 'N';
2998: lv_ntf_role WF_NOTIFICATIONS.RECIPIENT_ROLE%type;
2999: lv_ntf_msg_typ WF_NOTIFICATIONS.MESSAGE_TYPE%type;
3000: lv_ntf_msg_name WF_NOTIFICATIONS.MESSAGE_NAME%type;
3001: lv_ntf_prior WF_NOTIFICATIONS.PRIORITY%type;
3002: lv_ntf_due WF_NOTIFICATIONS.DUE_DATE%type;
3003: lv_ntf_status WF_NOTIFICATIONS.STATUS%type;
3004: --

Line 3001: lv_ntf_prior WF_NOTIFICATIONS.PRIORITY%type;

2997: l_isClosed VARCHAR2(10) := 'N';
2998: lv_ntf_role WF_NOTIFICATIONS.RECIPIENT_ROLE%type;
2999: lv_ntf_msg_typ WF_NOTIFICATIONS.MESSAGE_TYPE%type;
3000: lv_ntf_msg_name WF_NOTIFICATIONS.MESSAGE_NAME%type;
3001: lv_ntf_prior WF_NOTIFICATIONS.PRIORITY%type;
3002: lv_ntf_due WF_NOTIFICATIONS.DUE_DATE%type;
3003: lv_ntf_status WF_NOTIFICATIONS.STATUS%type;
3004: --
3005: BEGIN

Line 3002: lv_ntf_due WF_NOTIFICATIONS.DUE_DATE%type;

2998: lv_ntf_role WF_NOTIFICATIONS.RECIPIENT_ROLE%type;
2999: lv_ntf_msg_typ WF_NOTIFICATIONS.MESSAGE_TYPE%type;
3000: lv_ntf_msg_name WF_NOTIFICATIONS.MESSAGE_NAME%type;
3001: lv_ntf_prior WF_NOTIFICATIONS.PRIORITY%type;
3002: lv_ntf_due WF_NOTIFICATIONS.DUE_DATE%type;
3003: lv_ntf_status WF_NOTIFICATIONS.STATUS%type;
3004: --
3005: BEGIN
3006: --

Line 3003: lv_ntf_status WF_NOTIFICATIONS.STATUS%type;

2999: lv_ntf_msg_typ WF_NOTIFICATIONS.MESSAGE_TYPE%type;
3000: lv_ntf_msg_name WF_NOTIFICATIONS.MESSAGE_NAME%type;
3001: lv_ntf_prior WF_NOTIFICATIONS.PRIORITY%type;
3002: lv_ntf_due WF_NOTIFICATIONS.DUE_DATE%type;
3003: lv_ntf_status WF_NOTIFICATIONS.STATUS%type;
3004: --
3005: BEGIN
3006: --
3007: -- Get notification recipient and status

Line 3008: Wf_Notification.GetInfo(p_ntfId, lv_ntf_role, lv_ntf_msg_typ, lv_ntf_msg_name, lv_ntf_prior, lv_ntf_due, lv_ntf_status);

3004: --
3005: BEGIN
3006: --
3007: -- Get notification recipient and status
3008: Wf_Notification.GetInfo(p_ntfId, lv_ntf_role, lv_ntf_msg_typ, lv_ntf_msg_name, lv_ntf_prior, lv_ntf_due, lv_ntf_status);
3009: if (lv_ntf_status <> 'OPEN') then
3010: l_isClosed := 'Y';
3011: else
3012: l_isClosed := 'N';

Line 3239: * WF_notifications package with some modifications to cater

3235: * to the bottom of approval notifications. It also considers
3236: * RFC notifications and includes the record in building the
3237: * Workflow History.
3238: * This procedure internally uses two procedures copied from
3239: * WF_notifications package with some modifications to cater
3240: * to our specific need
3241: */
3242: PROCEDURE approval_history (
3243: document_id in varchar2,

Line 3348: -- if (wf_notification.debug) then

3344: ' cellspacing='||l_table_cellspacing||
3345: ' bgcolor='||l_table_bgcolor||' '||l_dirAttr||'>';
3346:
3347: -- ### implement as generic log in the future
3348: -- if (wf_notification.debug) then
3349: -- dbms_output.put_line(to_char(cells.LAST));
3350: -- end if;
3351:
3352: for i in 1..cells.LAST loop

Line 3353: -- if (wf_notification.debug) then

3349: -- dbms_output.put_line(to_char(cells.LAST));
3350: -- end if;
3351:
3352: for i in 1..cells.LAST loop
3353: -- if (wf_notification.debug) then
3354: -- dbms_output.put_line(substrb('('||to_char(i)||')='||cells(i),1,254));
3355: -- end if;
3356: modv := mod(i, col);
3357: if (modv = 1) then

Line 3382: -- if (wf_notification.debug) then

3378: else
3379: l_align := 'CENTER';
3380: end if;
3381:
3382: -- if (wf_notification.debug) then
3383: -- dbms_output.put_line('modv = '||to_char(modv));
3384: -- end if;
3385:
3386: colon := instrb(cells(i),':');

Line 3441: wf_core.context('Wf_Notification', 'NTF_Table',to_char(col),l_type);

3437: rs := rs||wf_core.newline||''||wf_core.newline||'';
3438:
3439: exception
3440: when OTHERS then
3441: wf_core.context('Wf_Notification', 'NTF_Table',to_char(col),l_type);
3442: raise;
3443: end NTF_Table;
3444:
3445:

Line 3535: if (disptype = wf_notification.doc_html) then

3531:
3532: j := 1;
3533: -- title
3534: cells(j) := wf_core.translate('SEQUENCE');
3535: if (disptype = wf_notification.doc_html) then
3536: cells(j) := 'L10%:'||cells(j);
3537: end if;
3538: j := j+1;
3539: cells(j) := wf_core.translate('WHO');

Line 3540: if (disptype = wf_notification.doc_html) then

3536: cells(j) := 'L10%:'||cells(j);
3537: end if;
3538: j := j+1;
3539: cells(j) := wf_core.translate('WHO');
3540: if (disptype = wf_notification.doc_html) then
3541: cells(j) := 'L:'||cells(j);
3542: end if;
3543: j := j+1;
3544: cells(j) := wf_core.translate('ACTION');

Line 3545: if (disptype = wf_notification.doc_html) then

3541: cells(j) := 'L:'||cells(j);
3542: end if;
3543: j := j+1;
3544: cells(j) := wf_core.translate('ACTION');
3545: if (disptype = wf_notification.doc_html) then
3546: cells(j) := 'L:'||cells(j);
3547: end if;
3548: j := j+1;
3549: cells(j) := wf_core.translate('DATE');

Line 3550: if (disptype = wf_notification.doc_html) then

3546: cells(j) := 'L:'||cells(j);
3547: end if;
3548: j := j+1;
3549: cells(j) := wf_core.translate('DATE');
3550: if (disptype = wf_notification.doc_html) then
3551: cells(j) := 'L:'||cells(j);
3552: end if;
3553: j := j+1;
3554: cells(j) := wf_core.translate('NOTE');

Line 3555: if (disptype = wf_notification.doc_html) then

3551: cells(j) := 'L:'||cells(j);
3552: end if;
3553: j := j+1;
3554: cells(j) := wf_core.translate('NOTE');
3555: if (disptype = wf_notification.doc_html) then
3556: cells(j) := 'L:'||cells(j);
3557: end if;
3558: j := j+1;
3559:

Line 3580: if (disptype = wf_notification.doc_html) then

3576:
3577: cells(j) := to_char(histr.notification_id);
3578: j := j+1;
3579: wf_directory.GetRoleInfo2(histr.assigned_user, role_info_tbl);
3580: if (disptype = wf_notification.doc_html) then
3581: cells(j) := 'L:'||role_info_tbl(1).display_name;
3582: else
3583: cells(j) := role_info_tbl(1).display_name;
3584: end if;

Line 3593: if (disptype = wf_notification.doc_html) then

3589: l_result_type := histr.result_type;
3590: l_result_code := histr.activity_result_code;
3591: l_action := wf_core.activity_result(l_result_type, l_result_code);
3592: end if;
3593: if (disptype = wf_notification.doc_html) then
3594: if (l_action is null) then
3595: cells(j) := 'L: ';
3596: else
3597: cells(j) := 'L:'||l_action;

Line 3603: if (disptype = wf_notification.doc_html) then

3599: else
3600: cells(j) := l_action;
3601: end if;
3602: j := j+1;
3603: if (disptype = wf_notification.doc_html) then
3604: cells(j) := 'L:'||to_char(histr.begin_date);
3605: else
3606: cells(j) := to_char(histr.begin_date);
3607: end if;

Line 3610: cells(j) := Wf_Notification.GetAttrText(histr.notification_id,'WF_NOTE');

3606: cells(j) := to_char(histr.begin_date);
3607: end if;
3608: j := j+1;
3609: begin
3610: cells(j) := Wf_Notification.GetAttrText(histr.notification_id,'WF_NOTE');
3611: exception
3612: when OTHERS then
3613: cells(j) := null;
3614: wf_core.clear;

Line 3616: if (disptype = wf_notification.doc_html) then

3612: when OTHERS then
3613: cells(j) := null;
3614: wf_core.clear;
3615: end;
3616: if (disptype = wf_notification.doc_html) then
3617: if (cells(j) is null) then
3618: cells(j) := 'L: ';
3619: else
3620: cells(j) := 'L:'||cells(j);

Line 3633: if (disptype = wf_notification.doc_html) then

3629: -- submit row
3630: cells(j) := '0';
3631: j := j+1;
3632: wf_directory.GetRoleInfo2(l_owner_role, role_info_tbl);
3633: if (disptype = wf_notification.doc_html) then
3634: cells(j) := 'L:'||role_info_tbl(1).display_name;
3635: else
3636: cells(j) := role_info_tbl(1).display_name;
3637: end if;

Line 3639: if (disptype = wf_notification.doc_html) then

3635: else
3636: cells(j) := role_info_tbl(1).display_name;
3637: end if;
3638: j := j+1;
3639: if (disptype = wf_notification.doc_html) then
3640: cells(j) := 'L:'||wf_core.translate('SUBMIT');
3641: else
3642: cells(j) := wf_core.translate('SUBMIT');
3643: end if;

Line 3645: if (disptype = wf_notification.doc_html) then

3641: else
3642: cells(j) := wf_core.translate('SUBMIT');
3643: end if;
3644: j := j+1;
3645: if (disptype = wf_notification.doc_html) then
3646: cells(j) := 'L:'||to_char(l_begin_date);
3647: else
3648: cells(j) := to_char(l_begin_date);
3649: end if;

Line 3651: if (disptype = wf_notification.doc_html) then

3647: else
3648: cells(j) := to_char(l_begin_date);
3649: end if;
3650: j := j+1;
3651: if (disptype = wf_notification.doc_html) then
3652: cells(j) := 'L: ';
3653: else
3654: cells(j) := null;
3655: end if;

Line 3658: -- if (wf_notification.debug) then

3654: cells(j) := null;
3655: end if;
3656:
3657: -- ### implement as generic log in the future
3658: -- if (wf_notification.debug) then
3659: -- dbms_output.put_line('j = '||to_char(j));
3660: -- dbms_output.put_line(substrb('last cell = '||cells(j),1,254));
3661: -- end if;
3662:

Line 3667: if (disptype = wf_notification.doc_html) then

3663: -- calculate the sequence
3664: -- Only after we know the number of rows, then we can put the squence
3665: -- number on for each row.
3666: for k in 0..i loop
3667: if (disptype = wf_notification.doc_html) then
3668: cells((k+1)*5+1) := 'C:'||to_char(i-k);
3669: else
3670: cells((k+1)*5+1) := to_char(i-k);
3671: end if;

Line 3674: if (disptype = wf_notification.doc_html) then

3670: cells((k+1)*5+1) := to_char(i-k);
3671: end if;
3672: end loop;
3673:
3674: if (disptype = wf_notification.doc_html) then
3675: table_width := '100%';
3676:
3677: NTF_Table(
3678: cells => cells,

Line 3695: wf_core.context('Wf_Notification', 'Wf_NTF_History', to_char(nid));

3691:
3692: return(result);
3693: exception
3694: when OTHERS then
3695: wf_core.context('Wf_Notification', 'Wf_NTF_History', to_char(nid));
3696: raise;
3697: end wf_ntf_history;
3698:
3699:

Line 3702: document_type := wf_notification.doc_html;

3698:
3699:
3700: BEGIN
3701: --
3702: document_type := wf_notification.doc_html;
3703: document := wf_ntf_history(document_id, document_type);
3704: --
3705: END approval_history;
3706: --

Line 3796: l_ntf_name := WF_NOTIFICATION.getattrtext(l_ntfId,l_ntf_identifier);

3792: l_ntf_err_text VARCHAR2(20000);
3793: BEGIN
3794: l_ntfId := get_notification_id(p_itemType,p_itemKey);
3795: BEGIN
3796: l_ntf_name := WF_NOTIFICATION.getattrtext(l_ntfId,l_ntf_identifier);
3797: EXCEPTION
3798: WHEN OTHERS THEN
3799: NULL;
3800: END;