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_CORE

Line 620: Wf_Core.Context(g_package, 'complete_wf_activity', p_itemType, p_itemKey);

616: --
617: EXCEPTION
618: WHEN OTHERS THEN
619: hr_utility.trace(' exception in '||g_package||'.complete_wf_activity : ' || sqlerrm);
620: Wf_Core.Context(g_package, 'complete_wf_activity', p_itemType, p_itemKey);
621: raise;
622: --
623: END complete_wf_activity;
624: --

Line 734: Wf_Core.Context(g_package, 'start_approval_wf', itemType, itemKey);

730: --
731: EXCEPTION
732: WHEN OTHERS THEN
733: hr_utility.trace(' exception in '||g_package||'.start_approval_wf : ' || sqlerrm);
734: Wf_Core.Context(g_package, 'start_approval_wf', itemType, itemKey);
735: raise;
736: --
737: END start_approval_wf;
738: --

Line 1732: Wf_Core.Context(g_package, 'set_txn_approve_status', itemType, itemKey);

1728: --
1729: EXCEPTION
1730: WHEN OTHERS THEN
1731: hr_utility.trace(' exception in '||g_package||'.set_txn_approve_status : ' || sqlerrm);
1732: Wf_Core.Context(g_package, 'set_txn_approve_status', itemType, itemKey);
1733: raise;
1734: --
1735: END set_txn_approve_status;
1736: --

Line 1760: Wf_Core.Context(g_package, 'set_txn_rfc_status', itemType, itemKey);

1756:
1757: EXCEPTION
1758: WHEN OTHERS THEN
1759: hr_utility.trace(' exception in '||g_package||'.set_txn_rfc_status : ' || sqlerrm);
1760: Wf_Core.Context(g_package, 'set_txn_rfc_status', itemType, itemKey);
1761: raise;
1762: --
1763: END set_txn_rfc_status;
1764: --

Line 1793: Wf_Core.Context(g_package, 'set_txn_sfl_status', itemType, itemKey);

1789:
1790: EXCEPTION
1791: WHEN OTHERS THEN
1792: hr_utility.trace(' exception in '||g_package||'.set_txn_sfl_status : ' || sqlerrm);
1793: Wf_Core.Context(g_package, 'set_txn_sfl_status', itemType, itemKey);
1794: raise;
1795: END set_txn_sfl_status;
1796: --
1797:

Line 1981: Wf_Core.Context(g_package, 'reset_txn_current_values', itemType, itemKey);

1977: --
1978: EXCEPTION
1979: WHEN OTHERS THEN
1980: hr_utility.trace(' exception in '||g_package||'.reset_txn_current_values : ' || sqlerrm);
1981: Wf_Core.Context(g_package, 'reset_txn_current_values', itemType, itemKey);
1982: raise;
1983: --
1984: END reset_txn_current_values;
1985:

Line 2039: Wf_Core.Context(g_package, 'check_initial_save_for_later', itemType, itemKey);

2035: --
2036: EXCEPTION
2037: WHEN OTHERS THEN
2038: hr_utility.trace(' exception in '||g_package||'.check_initial_save_for_later : ' || sqlerrm);
2039: Wf_Core.Context(g_package, 'check_initial_save_for_later', itemType, itemKey);
2040: raise;
2041: --
2042: END check_initial_save_for_later;
2043: --

Line 2513: Wf_Core.Context(g_package, 'set_date_if_as_of_approval', itemType, itemKey);

2509: --
2510: EXCEPTION
2511: WHEN OTHERS THEN
2512: hr_utility.trace(' exception in '||g_package||'.set_date_if_as_of_approval : ' || sqlerrm);
2513: Wf_Core.Context(g_package, 'set_date_if_as_of_approval', itemType, itemKey);
2514: raise;
2515: --
2516: END set_date_if_as_of_approval;
2517: --

Line 2974: Wf_Core.Context(g_package, 'validation_on_final_approval', itemType, itemKey);

2970: --
2971: EXCEPTION
2972: WHEN OTHERS THEN
2973: hr_utility.trace(' exception in '||g_package||'.validation_on_final_approval : ' || sqlerrm);
2974: Wf_Core.Context(g_package, 'validation_on_final_approval', itemType, itemKey);
2975: raise;
2976: --
2977: END validation_on_final_approval;
2978: --

Line 3178: Wf_Core.Token('TYPE', itemtype);

3174: ,p_roleName => l_roleName
3175: ,p_roleId => l_roleId );
3176:
3177: /* if l_roleName is null then
3178: Wf_Core.Token('TYPE', itemtype);
3179: Wf_Core.Token('ACTID', to_char(actid));
3180: Wf_Core.Raise('WFENG_NOTIFICATION_PERFORMER');
3181: end if;
3182: */

Line 3179: Wf_Core.Token('ACTID', to_char(actid));

3175: ,p_roleId => l_roleId );
3176:
3177: /* if l_roleName is null then
3178: Wf_Core.Token('TYPE', itemtype);
3179: Wf_Core.Token('ACTID', to_char(actid));
3180: Wf_Core.Raise('WFENG_NOTIFICATION_PERFORMER');
3181: end if;
3182: */
3183: IF ( l_roleId IS NULL ) THEN

Line 3180: Wf_Core.Raise('WFENG_NOTIFICATION_PERFORMER');

3176:
3177: /* if l_roleName is null then
3178: Wf_Core.Token('TYPE', itemtype);
3179: Wf_Core.Token('ACTID', to_char(actid));
3180: Wf_Core.Raise('WFENG_NOTIFICATION_PERFORMER');
3181: end if;
3182: */
3183: IF ( l_roleId IS NULL ) THEN
3184: --

Line 3228: Wf_Core.Context(g_package, 'set_hr_rep_role', itemType, itemKey);

3224: --
3225: EXCEPTION
3226: WHEN OTHERS THEN
3227: hr_utility.trace(' exception in '||g_package||'.set_hr_rep_role : ' || sqlerrm);
3228: Wf_Core.Context(g_package, 'set_hr_rep_role', itemType, itemKey);
3229: raise;
3230:
3231: END set_hr_rep_role;
3232:

Line 3259: Wf_Core.Context(g_package, 'approval_block', itemType, itemKey);

3255: ':'||wf_engine.eng_null;
3256: exception
3257: when others then
3258: hr_utility.trace(' exception in '||g_package||'.approval_block : ' || sqlerrm);
3259: Wf_Core.Context(g_package, 'approval_block', itemType, itemKey);
3260: raise;
3261: end approval_block;
3262: --
3263:

Line 3373: rs := rs||wf_core.newline||' 3372: '>
';
3373: rs := rs||wf_core.newline||'';
Line 3390: rs := rs||wf_core.newline||'
';
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
3390: rs := rs||wf_core.newline||'
';
3391: end if;
3392:
3393: alignv := substrb(cells(i), 1, 1);
3394: if (alignv = 'R') then
Line 3425: rs := rs||wf_core.newline||'
3421:
3422: if ((l_type = 'V' and modv = 1) or (l_type = 'N' and modv = 1)
3423: or (l_type = 'H' and i <= col)) then
3424: if (l_type = 'N') then
3425: rs := rs||wf_core.newline||' 3426: else
3427: -- this is a header
3428: rs := rs||wf_core.newline||' 3429: end if;

Line 3428: rs := rs||wf_core.newline||'
3424: if (l_type = 'N') then
3425: rs := rs||wf_core.newline||' 3426: else
3427: -- this is a header
3428: rs := rs||wf_core.newline||' 3429: end if;
3430: if (l_type = 'V') then
3431: rs := rs||' scope=row';
3432: else

Line 3451: rs := rs||wf_core.newline||'
3447: rs := rs||'';
3448: end if;
3449: else
3450: -- this is regular data
3451: rs := rs||wf_core.newline||' 3452: if (l_width is not null) then
3453: rs := rs||' width='||l_width;
3454: end if;
3455: rs := rs||' align='||l_align||' valign=baseline bgcolor='||

Line 3466: rs := rs||wf_core.newline||'
';
3462: rs := rs||l_text||'';
3463: end if;
3464: end if;
3465: if (modv = 0) then
3466: rs := rs||wf_core.newline||'';
3467: end if;
3468: end loop;
3469: rs := rs||wf_core.newline||'

'||wf_core.newline||'
';
3470:

Line 3469: rs := rs||wf_core.newline||''||wf_core.newline||'';

3465: if (modv = 0) then
3466: rs := rs||wf_core.newline||'';
3467: end if;
3468: end loop;
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);

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 3501: ,wf_core.activity_result (a.result_type

3497: FROM (
3498: SELECT 99999999 h_sequence
3499: ,ias.notification_id h_notification_id
3500: ,ias.assigned_user h_from_role
3501: ,wf_core.activity_result (a.result_type
3502: ,ias.activity_result_code) h_action
3503: ,
3504: (
3505: SELECT text_value

Line 3534: ,wf_core.activity_result (a.result_type

3530: UNION ALL
3531: SELECT 99999999 h_sequence
3532: ,ias.notification_id h_notification_id
3533: ,ias.assigned_user h_from_role
3534: ,wf_core.activity_result (a.result_type
3535: ,ias.activity_result_code) h_action
3536: ,
3537: (
3538: SELECT text_value

Line 3567: ,wf_core.translate (c.action) h_action

3563: UNION ALL
3564: SELECT c.sequence h_sequence
3565: ,c.notification_id h_notification_id
3566: ,c.from_role h_from_role
3567: ,wf_core.translate (c.action) h_action
3568: ,c.user_comment h_comment
3569: ,c.comment_date h_action_date
3570: FROM wf_item_activity_statuses ias
3571: ,wf_comments c

Line 3582: ,wf_core.translate (c.action) h_action

3578: UNION ALL
3579: SELECT c.sequence h_sequence
3580: ,c.notification_id h_notification_id
3581: ,c.from_role h_from_role
3582: ,wf_core.translate (c.action) h_action
3583: ,c.user_comment h_comment
3584: ,c.comment_date h_action_date
3585: FROM wf_item_activity_statuses_h ias
3586: ,wf_comments c

Line 3629: cells(j) := wf_core.translate('SEQUENCE');

3625:
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;

Line 3634: cells(j) := wf_core.translate('WHO');

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');
3635: if (disptype = wf_notification.doc_html) then
3636: cells(j) := 'L:'||cells(j);
3637: end if;
3638: j := j+1;

Line 3639: cells(j) := wf_core.translate('ACTION');

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');
3640: if (disptype = wf_notification.doc_html) then
3641: cells(j) := 'L:'||cells(j);
3642: end if;
3643: j := j+1;

Line 3644: cells(j) := wf_core.translate('DATE');

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');
3645: if (disptype = wf_notification.doc_html) then
3646: cells(j) := 'L:'||cells(j);
3647: end if;
3648: j := j+1;

Line 3649: cells(j) := wf_core.translate('NOTE');

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');
3650: if (disptype = wf_notification.doc_html) then
3651: cells(j) := 'L:'||cells(j);
3652: end if;
3653: j := j+1;

Line 3714: wf_core.clear;

3710: cells(j) := histr.h_comment;
3711: exception
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: ';

Line 3755: result := result||cells(k)||wf_core.newline;

3751: for k in 1..cells.LAST loop
3752: if (mod(k, 5) <> 0) then
3753: result := result||cells(k)||' '||l_delim||' ';
3754: else
3755: result := result||cells(k)||wf_core.newline;
3756: end if;
3757: end loop;
3758: end if;
3759:

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: