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.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 593: wf_notification.setattrtext(

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

Line 597: wf_notification.respond(

593: wf_notification.setattrtext(
594: notid
595: ,'RESULT'
596: ,p_resultCode);
597: wf_notification.respond(
598: notid
599: ,null
600: ,fnd_global.user_name
601: ,null);

Line 681: wf_notification.setattrtext(

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

Line 694: wf_notification.propagatehistory(

690: ,itemkey
691: ,'APPROVAL_COMMENT_COPY'
692: ,null);
693: ELSE
694: wf_notification.propagatehistory(
695: itemtype
696: ,itemkey
697: ,'APPROVAL_NOTIFICATION'
698: ,fnd_global.user_name

Line 2210: wf_notification.setattrtext(

2206: ,aname => 'WF_NOTE'
2207: ,avalue => NULL );
2208:
2209:
2210: wf_notification.setattrtext(
2211: p_ntfId
2212: ,'RESULT'
2213: ,'RETURNEDFORCORRECTION');
2214: BEGIN

Line 2215: wf_notification.setattrtext(

2211: p_ntfId
2212: ,'RESULT'
2213: ,'RETURNEDFORCORRECTION');
2214: BEGIN
2215: wf_notification.setattrtext(
2216: p_ntfId
2217: ,'WF_NOTE'
2218: ,p_note);
2219: EXCEPTION WHEN OTHERS THEN

Line 2221: wf_notification.propagatehistory(

2217: ,'WF_NOTE'
2218: ,p_note);
2219: EXCEPTION WHEN OTHERS THEN
2220: -- RFC from SFL Other
2221: wf_notification.propagatehistory(
2222: l_itemType
2223: ,l_itemKey
2224: ,'APPROVAL_NOTIFICATION'
2225: ,fnd_global.user_name

Line 2234: wf_notification.respond(

2230: END;
2231:
2232: -- Send Notification
2233:
2234: wf_notification.respond(
2235: p_ntfId
2236: ,null
2237: ,fnd_global.user_name
2238: ,null);

Line 2247: wf_notification.setAttrText(

2243: ,p_itemKey => l_itemKey);
2244:
2245:
2246: -- Set the from attribute for RFC notification.
2247: wf_notification.setAttrText(
2248: nid => l_ntfId
2249: ,aname => '#FROM_ROLE'
2250: ,avalue => fnd_global.user_name );
2251:

Line 2326: FROM wf_notifications wn, wf_message_attributes_vl wma

2322: ,p_itemType in varchar2) return varchar2 IS
2323: --
2324: CURSOR cur_ntf IS
2325: SELECT wma.display_name
2326: FROM wf_notifications wn, wf_message_attributes_vl wma
2327: WHERE wn.notification_id = p_ntfId
2328: AND wn.message_name = wma.message_name
2329: AND wma.message_type = p_itemType
2330: AND wma.name = 'EDIT_TXN_URL';

Line 2377: document_type := wf_notification.doc_html;

2373: WHERE item_type = c_itemType
2374: AND item_key = c_itemKey;
2375: --
2376: BEGIN
2377: document_type := wf_notification.doc_html;
2378: l_ntfId := document_id;
2379:
2380: -- l_ntfId := SUBSTR(document_id,1,INSTR(document_id,':')-1);
2381: -- l_checkProfile := SUBSTR(document_id,INSTR(document_id,':')+1);

Line 2999: document_type := wf_notification.doc_html;

2995: if ( is_notification_closed(document_id) = 'Y') then
2996: return;
2997: end if;
2998: --
2999: document_type := wf_notification.doc_html;
3000:
3001: -- Document will only have the notification id
3002: -- fetch the wf itemType and key from notification
3003: get_item_type_and_key (

Line 3030: lv_ntf_role WF_NOTIFICATIONS.RECIPIENT_ROLE%type;

3026: FUNCTION is_notification_closed (
3027: p_ntfId IN VARCHAR2 ) RETURN VARCHAR2 IS
3028: --
3029: l_isClosed VARCHAR2(10) := 'N';
3030: lv_ntf_role WF_NOTIFICATIONS.RECIPIENT_ROLE%type;
3031: lv_ntf_msg_typ WF_NOTIFICATIONS.MESSAGE_TYPE%type;
3032: lv_ntf_msg_name WF_NOTIFICATIONS.MESSAGE_NAME%type;
3033: lv_ntf_prior WF_NOTIFICATIONS.PRIORITY%type;
3034: lv_ntf_due WF_NOTIFICATIONS.DUE_DATE%type;

Line 3031: lv_ntf_msg_typ WF_NOTIFICATIONS.MESSAGE_TYPE%type;

3027: p_ntfId IN VARCHAR2 ) RETURN VARCHAR2 IS
3028: --
3029: l_isClosed VARCHAR2(10) := 'N';
3030: lv_ntf_role WF_NOTIFICATIONS.RECIPIENT_ROLE%type;
3031: lv_ntf_msg_typ WF_NOTIFICATIONS.MESSAGE_TYPE%type;
3032: lv_ntf_msg_name WF_NOTIFICATIONS.MESSAGE_NAME%type;
3033: lv_ntf_prior WF_NOTIFICATIONS.PRIORITY%type;
3034: lv_ntf_due WF_NOTIFICATIONS.DUE_DATE%type;
3035: lv_ntf_status WF_NOTIFICATIONS.STATUS%type;

Line 3032: lv_ntf_msg_name WF_NOTIFICATIONS.MESSAGE_NAME%type;

3028: --
3029: l_isClosed VARCHAR2(10) := 'N';
3030: lv_ntf_role WF_NOTIFICATIONS.RECIPIENT_ROLE%type;
3031: lv_ntf_msg_typ WF_NOTIFICATIONS.MESSAGE_TYPE%type;
3032: lv_ntf_msg_name WF_NOTIFICATIONS.MESSAGE_NAME%type;
3033: lv_ntf_prior WF_NOTIFICATIONS.PRIORITY%type;
3034: lv_ntf_due WF_NOTIFICATIONS.DUE_DATE%type;
3035: lv_ntf_status WF_NOTIFICATIONS.STATUS%type;
3036: --

Line 3033: lv_ntf_prior WF_NOTIFICATIONS.PRIORITY%type;

3029: l_isClosed VARCHAR2(10) := 'N';
3030: lv_ntf_role WF_NOTIFICATIONS.RECIPIENT_ROLE%type;
3031: lv_ntf_msg_typ WF_NOTIFICATIONS.MESSAGE_TYPE%type;
3032: lv_ntf_msg_name WF_NOTIFICATIONS.MESSAGE_NAME%type;
3033: lv_ntf_prior WF_NOTIFICATIONS.PRIORITY%type;
3034: lv_ntf_due WF_NOTIFICATIONS.DUE_DATE%type;
3035: lv_ntf_status WF_NOTIFICATIONS.STATUS%type;
3036: --
3037: BEGIN

Line 3034: lv_ntf_due WF_NOTIFICATIONS.DUE_DATE%type;

3030: lv_ntf_role WF_NOTIFICATIONS.RECIPIENT_ROLE%type;
3031: lv_ntf_msg_typ WF_NOTIFICATIONS.MESSAGE_TYPE%type;
3032: lv_ntf_msg_name WF_NOTIFICATIONS.MESSAGE_NAME%type;
3033: lv_ntf_prior WF_NOTIFICATIONS.PRIORITY%type;
3034: lv_ntf_due WF_NOTIFICATIONS.DUE_DATE%type;
3035: lv_ntf_status WF_NOTIFICATIONS.STATUS%type;
3036: --
3037: BEGIN
3038: --

Line 3035: lv_ntf_status WF_NOTIFICATIONS.STATUS%type;

3031: lv_ntf_msg_typ WF_NOTIFICATIONS.MESSAGE_TYPE%type;
3032: lv_ntf_msg_name WF_NOTIFICATIONS.MESSAGE_NAME%type;
3033: lv_ntf_prior WF_NOTIFICATIONS.PRIORITY%type;
3034: lv_ntf_due WF_NOTIFICATIONS.DUE_DATE%type;
3035: lv_ntf_status WF_NOTIFICATIONS.STATUS%type;
3036: --
3037: BEGIN
3038: --
3039: -- Get notification recipient and status

Line 3040: 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);

3036: --
3037: BEGIN
3038: --
3039: -- Get notification recipient and status
3040: 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);
3041: if (lv_ntf_status <> 'OPEN') then
3042: l_isClosed := 'Y';
3043: else
3044: l_isClosed := 'N';

Line 3271: * WF_notifications package with some modifications to cater

3267: * to the bottom of approval notifications. It also considers
3268: * RFC notifications and includes the record in building the
3269: * Workflow History.
3270: * This procedure internally uses two procedures copied from
3271: * WF_notifications package with some modifications to cater
3272: * to our specific need
3273: */
3274: PROCEDURE approval_history (
3275: document_id in varchar2,

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

3376: ' cellspacing='||l_table_cellspacing||
3377: ' bgcolor='||l_table_bgcolor||' '||l_dirAttr||'>';
3378:
3379: -- ### implement as generic log in the future
3380: -- if (wf_notification.debug) then
3381: -- dbms_output.put_line(to_char(cells.LAST));
3382: -- end if;
3383:
3384: for i in 1..cells.LAST loop

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

3381: -- dbms_output.put_line(to_char(cells.LAST));
3382: -- end if;
3383:
3384: for i in 1..cells.LAST loop
3385: -- if (wf_notification.debug) then
3386: -- dbms_output.put_line(substrb('('||to_char(i)||')='||cells(i),1,254));
3387: -- end if;
3388: modv := mod(i, col);
3389: if (modv = 1) then

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

3410: else
3411: l_align := 'CENTER';
3412: end if;
3413:
3414: -- if (wf_notification.debug) then
3415: -- dbms_output.put_line('modv = '||to_char(modv));
3416: -- end if;
3417:
3418: colon := instrb(cells(i),':');

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

3469: rs := rs||wf_core.newline||''||wf_core.newline||'';
3470:
3471: exception
3472: when OTHERS then
3473: wf_core.context('Wf_Notification', 'NTF_Table',to_char(col),l_type);
3474: raise;
3475: end NTF_Table;
3476:
3477:

Line 3506: FROM wf_notification_attributes

3502: ,ias.activity_result_code) h_action
3503: ,
3504: (
3505: SELECT text_value
3506: FROM wf_notification_attributes
3507: WHERE notification_id = ias.notification_id
3508: AND name = 'WF_NOTE'
3509: ) h_comment
3510: ,nvl (ias.end_date

Line 3539: FROM wf_notification_attributes

3535: ,ias.activity_result_code) h_action
3536: ,
3537: (
3538: SELECT text_value
3539: FROM wf_notification_attributes
3540: WHERE notification_id = ias.notification_id
3541: AND name = 'WF_NOTE'
3542: ) h_comment
3543: ,nvl (ias.end_date

Line 3617: wf_notification.getNtfActInfo(nid, l_itype, l_ikey, l_actid);

3613: l_delim varchar2(1) := ':';
3614: cells tdType;
3615: result varchar2(32000) := '';
3616: begin
3617: wf_notification.getNtfActInfo(nid, l_itype, l_ikey, l_actid);
3618:
3619: hr_utility.set_location(' kck nid : ' || nid, 666);
3620: hr_utility.set_location(' kck l_itype : ' || l_itype, 666);
3621: hr_utility.set_location(' kck l_ikey : ' || l_ikey, 666);

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

3626:
3627: j := 1;
3628: -- title
3629: cells(j) := wf_core.translate('SEQUENCE');
3630: if (disptype = wf_notification.doc_html) then
3631: cells(j) := 'L10%:'||cells(j);
3632: end if;
3633: j := j+1;
3634: cells(j) := wf_core.translate('WHO');

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

3631: cells(j) := 'L10%:'||cells(j);
3632: end if;
3633: j := j+1;
3634: cells(j) := wf_core.translate('WHO');
3635: if (disptype = wf_notification.doc_html) then
3636: cells(j) := 'L:'||cells(j);
3637: end if;
3638: j := j+1;
3639: cells(j) := wf_core.translate('ACTION');

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

3636: cells(j) := 'L:'||cells(j);
3637: end if;
3638: j := j+1;
3639: cells(j) := wf_core.translate('ACTION');
3640: if (disptype = wf_notification.doc_html) then
3641: cells(j) := 'L:'||cells(j);
3642: end if;
3643: j := j+1;
3644: cells(j) := wf_core.translate('DATE');

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

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

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

3646: cells(j) := 'L:'||cells(j);
3647: end if;
3648: j := j+1;
3649: cells(j) := wf_core.translate('NOTE');
3650: if (disptype = wf_notification.doc_html) then
3651: cells(j) := 'L:'||cells(j);
3652: end if;
3653: j := j+1;
3654:

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

3680: cells(j) := to_char(histr.h_sequence);
3681: j := j+1;
3682: wf_directory.GetRoleInfo2(histr.h_from_role, role_info_tbl);
3683:
3684: if (disptype = wf_notification.doc_html) then
3685: cells(j) := 'L:'||role_info_tbl(1).display_name;
3686: else
3687: cells(j) := role_info_tbl(1).display_name;
3688: end if;

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

3687: cells(j) := role_info_tbl(1).display_name;
3688: end if;
3689: j := j+1;
3690:
3691: if (disptype = wf_notification.doc_html) then
3692: if (histr.h_action is null) then
3693: cells(j) := 'L: ';
3694: else
3695: cells(j) := 'L:'||histr.h_action;

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

3698: cells(j) := histr.h_action;
3699: end if;
3700: j := j+1;
3701:
3702: if (disptype = wf_notification.doc_html) then
3703: cells(j) := 'L:'||to_char(histr.h_action_date);
3704: else
3705: cells(j) := to_char(histr.h_action_date);
3706: end if;

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

3712: when OTHERS then
3713: cells(j) := null;
3714: wf_core.clear;
3715: end;
3716: if (disptype = wf_notification.doc_html) then
3717: if (cells(j) is null) then
3718: cells(j) := 'L: ';
3719: else
3720: cells(j) := 'L:'||cells(j);

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

3729: -- calculate the sequence
3730: -- Only after we know the number of rows, then we can put the squence
3731: -- number on for each row.
3732: for k in 0..i-1 loop
3733: if (disptype = wf_notification.doc_html) then
3734: cells((k+1)*5+1) := 'C:'||to_char(i-k);
3735: else
3736: cells((k+1)*5+1) := to_char(i-k);
3737: end if;

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

3738: end loop;
3739:
3740:
3741:
3742: if (disptype = wf_notification.doc_html) then
3743: table_width := '100%';
3744:
3745: NTF_Table(
3746: cells => cells,

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

3759:
3760: return(result);
3761: exception
3762: when OTHERS then
3763: wf_core.context('Wf_Notification', 'Wf_NTF_History', to_char(nid));
3764: raise;
3765: end wf_ntf_history;
3766:
3767:

Line 3773: document_type := wf_notification.doc_html;

3769:
3770:
3771: hr_utility.set_location('document_id passed : ' || document_id, 666);
3772: --
3773: document_type := wf_notification.doc_html;
3774: document := wf_ntf_history(document_id, document_type);
3775: --
3776: END approval_history;
3777: --

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

3863: l_ntf_err_text VARCHAR2(20000);
3864: BEGIN
3865: l_ntfId := get_notification_id(p_itemType,p_itemKey);
3866: BEGIN
3867: l_ntf_name := WF_NOTIFICATION.getattrtext(l_ntfId,l_ntf_identifier);
3868: EXCEPTION
3869: WHEN OTHERS THEN
3870: NULL;
3871: END;