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.GHR_WF_PKG dependencies on WF_ENGINE

Line 38: wf_engine.createProcess( ItemType => l_ItemType,

34:
35: -- Creates a new runtime process for an application item (SF-52)
36: --
37: hr_utility.set_location('l_proc',1);
38: wf_engine.createProcess( ItemType => l_ItemType,
39: ItemKey => l_ItemKey,
40: process => 'SF52_APPROVAL_PROCESS' );
41: --
42: --

Line 44: wf_engine.SetItemAttrNumber ( itemtype => l_ItemType,

40: process => 'SF52_APPROVAL_PROCESS' );
41: --
42: --
43: hr_utility.set_location('l_proc',2);
44: wf_engine.SetItemAttrNumber ( itemtype => l_ItemType,
45: itemkey => l_Itemkey,
46: aname => 'PA_REQUEST_ID',
47: avalue => p_pa_request_id );
48: hr_utility.set_location('l_proc',3);

Line 49: wf_engine.SetItemAttrText( itemtype => l_itemtype,

45: itemkey => l_Itemkey,
46: aname => 'PA_REQUEST_ID',
47: avalue => p_pa_request_id );
48: hr_utility.set_location('l_proc',3);
49: wf_engine.SetItemAttrText( itemtype => l_itemtype,
50: itemkey => l_itemkey,
51: aname => 'FORWARD_TO_NAME',
52: avalue => p_forward_to_name );
53:

Line 56: wf_engine.SetItemAttrText( itemtype => l_itemtype,

52: avalue => p_forward_to_name );
53:
54: hr_utility.set_location('l_proc',4);
55: hr_utility.set_location('l_proc',5);
56: wf_engine.SetItemAttrText( itemtype => l_itemtype,
57: itemkey => l_itemkey,
58: aname => 'FORWARD_FROM_DISPLAY_NAME',
59: avalue => FND_GLOBAL.USER_NAME() );
60:

Line 65: wf_engine.SetItemAttrText( itemtype => l_itemtype,

61: hr_utility.set_location('l_proc',6);
62: l_load_form := 'GHRWS52L:p_pa_request_id=' || l_Itemkey
63: || ' p_inbox_query_only="NO"' || ' WORKFLOW_NAME="GHR US PA REQUEST"'
64: || ' p_wf_notification_id=&#NID';--Bug# 6923642
65: wf_engine.SetItemAttrText( itemtype => l_itemtype,
66: itemkey => l_itemkey,
67: aname => 'LOAD_SF52',
68: avalue => l_load_form
69: );

Line 71: wf_engine.SetItemAttrText( itemtype => l_itemtype,

67: aname => 'LOAD_SF52',
68: avalue => l_load_form
69: );
70: l_load_prh := 'GHRWSPRH:p_pa_request_id=' || l_Itemkey;
71: wf_engine.SetItemAttrText( itemtype => l_itemtype,
72: itemkey => l_itemkey,
73: aname => 'LOAD_PRH',
74: avalue => l_load_prh
75: );

Line 93: wf_engine.SetItemAttrText( itemtype => l_itemtype,

89: );
90: --
91: --
92: --
93: wf_engine.SetItemAttrText( itemtype => l_itemtype,
94: itemkey => l_itemkey,
95: aname => 'SUBJECT_HDR',
96: avalue => l_subject
97: );

Line 98: wf_engine.SetItemAttrText( itemtype => l_itemtype,

94: itemkey => l_itemkey,
95: aname => 'SUBJECT_HDR',
96: avalue => l_subject
97: );
98: wf_engine.SetItemAttrText( itemtype => l_itemtype,
99: itemkey => l_itemkey,
100: aname => 'LINE1',
101: avalue => l_line1
102: );

Line 103: wf_engine.SetItemAttrText( itemtype => l_itemtype,

99: itemkey => l_itemkey,
100: aname => 'LINE1',
101: avalue => l_line1
102: );
103: wf_engine.SetItemAttrText( itemtype => l_itemtype,
104: itemkey => l_itemkey,
105: aname => 'LINE2',
106: avalue => l_line2
107: );

Line 109: wf_engine.SetItemAttrText( itemtype => l_itemtype,

105: aname => 'LINE2',
106: avalue => l_line2
107: );
108: /*
109: wf_engine.SetItemAttrText( itemtype => l_itemtype,
110: itemkey => l_itemkey,
111: aname => 'PROPOSED_EFF_DATE',
112: avalue => l_line2a
113: );

Line 115: wf_engine.SetItemAttrText( itemtype => l_itemtype,

111: aname => 'PROPOSED_EFF_DATE',
112: avalue => l_line2a
113: );
114: */
115: wf_engine.SetItemAttrText( itemtype => l_itemtype,
116: itemkey => l_itemkey,
117: aname => 'LINE3',
118: avalue => l_line3
119: );

Line 120: wf_engine.SetItemAttrText( itemtype => l_itemtype,

116: itemkey => l_itemkey,
117: aname => 'LINE3',
118: avalue => l_line3
119: );
120: wf_engine.SetItemAttrText( itemtype => l_itemtype,
121: itemkey => l_itemkey,
122: aname => 'LINE4',
123: avalue => l_line4
124: );

Line 125: wf_engine.SetItemAttrText( itemtype => l_itemtype,

121: itemkey => l_itemkey,
122: aname => 'LINE4',
123: avalue => l_line4
124: );
125: wf_engine.SetItemAttrText( itemtype => l_itemtype,
126: itemkey => l_itemkey,
127: aname => 'LINE5',
128: avalue => l_line5
129: );

Line 131: wf_engine.SetItemAttrText( itemtype => l_itemtype,

127: aname => 'LINE5',
128: avalue => l_line5
129: );
130: /*
131: wf_engine.SetItemAttrText( itemtype => l_itemtype,
132: itemkey => l_itemkey,
133: aname => 'DATE_INITIATED',
134: avalue => l_line5a
135: );

Line 137: wf_engine.SetItemAttrText( itemtype => l_itemtype,

133: aname => 'DATE_INITIATED',
134: avalue => l_line5a
135: );
136: */
137: wf_engine.SetItemAttrText( itemtype => l_itemtype,
138: itemkey => l_itemkey,
139: aname => 'LINE6',
140: avalue => l_line6
141: );

Line 142: wf_engine.SetItemAttrText( itemtype => l_itemtype,

138: itemkey => l_itemkey,
139: aname => 'LINE6',
140: avalue => l_line6
141: );
142: wf_engine.SetItemAttrText( itemtype => l_itemtype,
143: itemkey => l_itemkey,
144: aname => 'LINE7',
145: avalue => l_line7
146: );

Line 147: wf_engine.SetItemAttrText( itemtype => l_itemtype,

143: itemkey => l_itemkey,
144: aname => 'LINE7',
145: avalue => l_line7
146: );
147: wf_engine.SetItemAttrText( itemtype => l_itemtype,
148: itemkey => l_itemkey,
149: aname => 'LINE8',
150: avalue => l_line8
151: );

Line 155: wf_engine.SetItemAttrText( itemtype => l_itemtype,

151: );
152: if ( CheckItemAttribute ( p_name => 'LINE9',
153: p_itemtype => l_itemtype,
154: p_itemkey => l_itemkey ) ) then
155: wf_engine.SetItemAttrText( itemtype => l_itemtype,
156: itemkey => l_itemkey,
157: aname => 'LINE9',
158: avalue => l_line9
159: );

Line 163: wf_engine.SetItemAttrText(

159: );
160: end if;
161: -- Added for Future Action process
162: if p_error_msg Is Not Null then
163: wf_engine.SetItemAttrText(
164: itemtype => l_itemtype,
165: itemkey => l_itemkey,
166: aname => 'LINE_ERROR',
167: avalue => 'Update HR Error : '

Line 173: wf_engine.StartProcess ( ItemType => l_ItemType,

169: );
170: end if;
171: -- Start the SF-52 workflow process for SF52_APPROVAL_PROCESS
172: --
173: wf_engine.StartProcess ( ItemType => l_ItemType,
174: ItemKey => l_ItemKey );
175: --
176: --
177: hr_utility.set_location('l_proc',10);

Line 291: wf_engine.SetItemAttrText( itemtype => itemtype,

287: --
288: if ( CheckItemAttribute ( p_name => 'APPROVER_NAME',
289: p_itemtype => itemtype,
290: p_itemkey => itemkey ) and (l_approver_name Is Not Null) ) then
291: wf_engine.SetItemAttrText( itemtype => itemtype,
292: itemkey => itemkey,
293: aname => 'APPROVER_NAME',
294: avalue => l_approver_name
295: );

Line 300: wf_engine.SetItemAttrText( itemtype => itemtype,

296: end if;
297: if ( CheckItemAttribute ( p_name => 'PERSON_UPDATE_HR',
298: p_itemtype => itemtype,
299: p_itemkey => itemkey ) and (l_upd_hr_user_name Is Not Null) ) then
300: wf_engine.SetItemAttrText( itemtype => itemtype,
301: itemkey => itemkey,
302: aname => 'PERSON_UPDATE_HR',
303: avalue => l_upd_hr_user_name
304: );

Line 308: -- wf_engine.SetItemAttrText( itemtype => itemtype,

304: );
305: end if;
306: -- Third line of message
307: -- l_line3 := 'Current Status : ' || 'UPDATE_HR_COMPLETE';
308: -- wf_engine.SetItemAttrText( itemtype => itemtype,
309: -- itemkey => itemkey,
310: -- aname => 'LINE3',
311: -- avalue => l_line3
312: -- );

Line 322: wf_engine.SetItemAttrText( itemtype => itemtype,

318:
319: l_load_form := 'GHRWS52L:p_pa_request_id=' || Itemkey
320: || ' p_inbox_query_only="YES"' || ' WORKFLOW_NAME="GHR US PA REQUEST"'
321: || ' p_wf_notification_id=&#NID' ;--Bug# 6923642
322: wf_engine.SetItemAttrText( itemtype => itemtype,
323: itemkey => itemkey,
324: aname => 'PA_REQUEST_RO',
325: avalue => l_load_form
326: );

Line 373: l_approver_name := wf_engine.GetItemAttrText

369: if ( CheckItemAttribute ( p_name => 'APPROVER_NAME',
370: p_itemtype => itemtype,
371: p_itemkey => itemkey ) ) then
372: --
373: l_approver_name := wf_engine.GetItemAttrText
374: (itemtype => itemtype,
375: itemkey => itemkey,
376: aname => 'APPROVER_NAME'
377: );

Line 384: l_upd_hr_user_name := wf_engine.GetItemAttrText

380: if ( CheckItemAttribute ( p_name => 'PERSON_UPDATE_HR',
381: p_itemtype => itemtype,
382: p_itemkey => itemkey ) ) then
383: --
384: l_upd_hr_user_name := wf_engine.GetItemAttrText
385: (itemtype => itemtype,
386: itemkey => itemkey,
387: aname => 'PERSON_UPDATE_HR'
388: );

Line 465: wf_engine.SetItemAttrText( itemtype => itemtype,

461: p_line7 => l_line7,
462: p_line8 => l_line8,
463: p_line9 => l_line9
464: );
465: wf_engine.SetItemAttrText( itemtype => itemtype,
466: itemkey => itemkey,
467: aname => 'SUBJECT_HDR',
468: avalue => l_subject
469: );

Line 470: wf_engine.SetItemAttrText( itemtype => itemtype,

466: itemkey => itemkey,
467: aname => 'SUBJECT_HDR',
468: avalue => l_subject
469: );
470: wf_engine.SetItemAttrText( itemtype => itemtype,
471: itemkey => itemkey,
472: aname => 'LINE1',
473: avalue => l_line1
474: );

Line 475: wf_engine.SetItemAttrText( itemtype => itemtype,

471: itemkey => itemkey,
472: aname => 'LINE1',
473: avalue => l_line1
474: );
475: wf_engine.SetItemAttrText( itemtype => itemtype,
476: itemkey => itemkey,
477: aname => 'LINE2',
478: avalue => l_line2
479: );

Line 481: wf_engine.SetItemAttrText( itemtype => itemtype,

477: aname => 'LINE2',
478: avalue => l_line2
479: );
480: /*
481: wf_engine.SetItemAttrText( itemtype => itemtype,
482: itemkey => itemkey,
483: aname => 'PROPOSED_EFF_DATE',
484: avalue => l_line2a
485: );

Line 487: wf_engine.SetItemAttrText( itemtype => itemtype,

483: aname => 'PROPOSED_EFF_DATE',
484: avalue => l_line2a
485: );
486: */
487: wf_engine.SetItemAttrText( itemtype => itemtype,
488: itemkey => itemkey,
489: aname => 'LINE3',
490: avalue => l_line3
491: );

Line 492: wf_engine.SetItemAttrText( itemtype => itemtype,

488: itemkey => itemkey,
489: aname => 'LINE3',
490: avalue => l_line3
491: );
492: wf_engine.SetItemAttrText( itemtype => itemtype,
493: itemkey => itemkey,
494: aname => 'LINE4',
495: avalue => l_line4
496: );

Line 497: wf_engine.SetItemAttrText( itemtype => itemtype,

493: itemkey => itemkey,
494: aname => 'LINE4',
495: avalue => l_line4
496: );
497: wf_engine.SetItemAttrText( itemtype => itemtype,
498: itemkey => itemkey,
499: aname => 'LINE5',
500: avalue => l_line5
501: );

Line 503: wf_engine.SetItemAttrText( itemtype => itemtype,

499: aname => 'LINE5',
500: avalue => l_line5
501: );
502: /*
503: wf_engine.SetItemAttrText( itemtype => itemtype,
504: itemkey => itemkey,
505: aname => 'DATE_INITIATED',
506: avalue => l_line5a
507: );

Line 509: wf_engine.SetItemAttrText( itemtype => itemtype,

505: aname => 'DATE_INITIATED',
506: avalue => l_line5a
507: );
508: */
509: wf_engine.SetItemAttrText( itemtype => itemtype,
510: itemkey => itemkey,
511: aname => 'LINE6',
512: avalue => l_line6
513: );

Line 514: wf_engine.SetItemAttrText( itemtype => itemtype,

510: itemkey => itemkey,
511: aname => 'LINE6',
512: avalue => l_line6
513: );
514: wf_engine.SetItemAttrText( itemtype => itemtype,
515: itemkey => itemkey,
516: aname => 'LINE7',
517: avalue => l_line7
518: );

Line 519: wf_engine.SetItemAttrText( itemtype => itemtype,

515: itemkey => itemkey,
516: aname => 'LINE7',
517: avalue => l_line7
518: );
519: wf_engine.SetItemAttrText( itemtype => itemtype,
520: itemkey => itemkey,
521: aname => 'LINE8',
522: avalue => l_line8
523: );

Line 527: wf_engine.SetItemAttrText( itemtype => itemtype,

523: );
524: if ( CheckItemAttribute ( p_name => 'LINE9',
525: p_itemtype => itemtype,
526: p_itemkey => itemkey ) ) then
527: wf_engine.SetItemAttrText( itemtype => itemtype,
528: itemkey => itemkey,
529: aname => 'LINE9',
530: avalue => l_line9
531: );

Line 553: wf_engine.SetItemAttrText( itemtype => Itemtype,

549: else
550: --
551: if l_user_name Is Not Null then
552: --
553: wf_engine.SetItemAttrText( itemtype => Itemtype,
554: itemkey => Itemkey,
555: aname => 'FORWARD_TO_NAME',
556: avalue => l_user_name );
557: result := 'COMPLETE:CONTINUE';

Line 561: wf_engine.SetItemAttrText( itemtype => Itemtype,

557: result := 'COMPLETE:CONTINUE';
558: return;
559: else
560:
561: wf_engine.SetItemAttrText( itemtype => Itemtype,
562: itemkey => Itemkey,
563: aname => 'FORWARD_TO_NAME',
564: avalue => l_groupbox_name );
565: result := 'COMPLETE:CONTINUE';

Line 800: l_error_msg := wf_engine.GetItemAttrText

796: begin
797: -- This function will set the Workflow notification message attributes at each hop
798: --
799: -- Get Error message
800: l_error_msg := wf_engine.GetItemAttrText
801: (itemtype => 'GHR_SF52',
802: itemkey => p_pa_request_id,
803: aname => 'LINE_ERROR'
804: );

Line 1031: wf_engine.SetItemAttrText(

1027: ) is
1028: begin
1029: -- Added for Future Action process
1030: if p_error_msg Is Null then
1031: wf_engine.SetItemAttrText(
1032: itemtype => 'GHR_SF52',
1033: itemkey => p_pa_request_id,
1034: aname => 'LINE_ERROR',
1035: avalue => ''

Line 1038: wf_engine.SetItemAttrText(

1034: aname => 'LINE_ERROR',
1035: avalue => ''
1036: );
1037: else
1038: wf_engine.SetItemAttrText(
1039: itemtype => 'GHR_SF52',
1040: itemkey => p_pa_request_id,
1041: aname => 'LINE_ERROR',
1042: avalue => 'Update HR Error : '

Line 1046: wf_engine.CompleteActivity('GHR_SF52', p_pa_request_id, 'GH_NOTIFY_SF52','COMPLETE');

1042: avalue => 'Update HR Error : '
1043: || substr(p_error_msg,1,1000)
1044: );
1045: end if;
1046: wf_engine.CompleteActivity('GHR_SF52', p_pa_request_id, 'GH_NOTIFY_SF52','COMPLETE');
1047: end;
1048: --
1049: --
1050: --

Line 1058: wf_engine.SetItemAttrText(

1054: p_error_msg in varchar2 default null
1055: ) is
1056: begin
1057: if p_error_msg Is Null then
1058: wf_engine.SetItemAttrText(
1059: itemtype => 'GHR_SF52',
1060: itemkey => p_pa_request_id,
1061: aname => 'LINE_ERROR',
1062: avalue => ''

Line 1065: wf_engine.SetItemAttrText(

1061: aname => 'LINE_ERROR',
1062: avalue => ''
1063: );
1064: else
1065: wf_engine.SetItemAttrText(
1066: itemtype => 'GHR_SF52',
1067: itemkey => p_pa_request_id,
1068: aname => 'LINE_ERROR',
1069: avalue => 'Update HR Error : '

Line 1075: wf_engine.CompleteActivity('GHR_SF52', p_pa_request_id, 'BLOCK_FUTURE_ACTION','UPDATE_HR_COMPLETE');

1071: );
1072: end if;
1073: --
1074: if p_action_taken = 'UPDATE_HR_COMPLETE' then
1075: wf_engine.CompleteActivity('GHR_SF52', p_pa_request_id, 'BLOCK_FUTURE_ACTION','UPDATE_HR_COMPLETE');
1076: else
1077: wf_engine.CompleteActivity('GHR_SF52', p_pa_request_id, 'BLOCK_FUTURE_ACTION','CONTINUE');
1078: end if;
1079: --

Line 1077: wf_engine.CompleteActivity('GHR_SF52', p_pa_request_id, 'BLOCK_FUTURE_ACTION','CONTINUE');

1073: --
1074: if p_action_taken = 'UPDATE_HR_COMPLETE' then
1075: wf_engine.CompleteActivity('GHR_SF52', p_pa_request_id, 'BLOCK_FUTURE_ACTION','UPDATE_HR_COMPLETE');
1076: else
1077: wf_engine.CompleteActivity('GHR_SF52', p_pa_request_id, 'BLOCK_FUTURE_ACTION','CONTINUE');
1078: end if;
1079: --
1080: --
1081: end CompleteBlockingOfFutureAction ;

Line 1146: wf_engine.SetItemAttrText( itemtype => itemtype,

1142:
1143: l_load_form := 'GHRWS52L:p_pa_request_id=' || Itemkey
1144: || ' p_inbox_query_only="YES"' || ' WORKFLOW_NAME="GHR US PA REQUEST"'
1145: || ' p_wf_notification_id=&#NID';--Bug# 6923642
1146: wf_engine.SetItemAttrText( itemtype => itemtype,
1147: itemkey => itemkey,
1148: aname => 'PA_REQUEST_RO',
1149: avalue => l_load_form
1150: );

Line 1196: l_text := wf_engine.GetItemAttrText( itemtype => Itemtype,

1192: begin
1193: l_result := result;
1194: --
1195: if funcmode = 'RUN' then
1196: l_text := wf_engine.GetItemAttrText( itemtype => Itemtype,
1197: itemkey => Itemkey,
1198: aname => 'NTFY_UPD_HR_YES_NO');
1199: if l_text = 'NO' then
1200: result := 'COMPLETE:NO';

Line 1242: l_text := wf_engine.GetItemAttrText( itemtype => Itemtype,

1238: begin
1239: l_result := result;
1240: --
1241: if funcmode = 'RUN' then
1242: l_text := wf_engine.GetItemAttrText( itemtype => Itemtype,
1243: itemkey => Itemkey,
1244: aname => 'USE_UPD_HR_ONLY');
1245: if l_text = 'NO' then
1246: result := 'COMPLETE:NO';

Line 1431: l_forward_to_name := WF_ENGINE.context_text;

1427: IF (funcmode in ('FORWARD','TRANSFER')) then
1428: -- Get the current user name
1429: l_current_user_name := FND_GLOBAL.USER_NAME();
1430: -- Get the Forward To Information
1431: l_forward_to_name := WF_ENGINE.context_text;
1432: -- Validate the username
1433: -- a) Get the routing group id
1434: FOR rg_rec in get_par LOOP
1435: l_routing_group_id := rg_rec.routing_group_id;

Line 1567: result := wf_engine.eng_completed||':'||wf_engine.eng_null;

1563: -- Reset IN OUT parameters and set OUT parameters
1564: --
1565: result := l_result;
1566: IF l_exp = 1 then
1567: result := wf_engine.eng_completed||':'||wf_engine.eng_null;
1568: fnd_message.set_name('GHR', 'GHR_38815_WF_INVALID_USER');
1569: app_exception.raise_exception;
1570: ELSIF l_exp = 2 then
1571: result := wf_engine.eng_completed||':'||wf_engine.eng_null;

Line 1571: result := wf_engine.eng_completed||':'||wf_engine.eng_null;

1567: result := wf_engine.eng_completed||':'||wf_engine.eng_null;
1568: fnd_message.set_name('GHR', 'GHR_38815_WF_INVALID_USER');
1569: app_exception.raise_exception;
1570: ELSIF l_exp = 2 then
1571: result := wf_engine.eng_completed||':'||wf_engine.eng_null;
1572: fnd_message.set_name('GHR', 'GHR_38674_NO_REASSIGN');
1573: app_exception.raise_exception;
1574: END IF;
1575: END norout;