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: -- Bug # 8597583 modified parameters to pass with out double quotes

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 166: wf_engine.SetItemAttrText(

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

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

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

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

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

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

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

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

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

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

322:
323: l_load_form := 'GHRWS52L:p_pa_request_id=' || Itemkey
324: || ' p_inbox_query_only=YES' || ' WORKFLOW_NAME=GHR_US_PA_REQUEST'
325: || ' p_wf_notification_id=&#NID' ;--Bug# 6923642
326: wf_engine.SetItemAttrText( itemtype => itemtype,
327: itemkey => itemkey,
328: aname => 'PA_REQUEST_RO',
329: avalue => l_load_form
330: );

Line 377: l_approver_name := wf_engine.GetItemAttrText

373: if ( CheckItemAttribute ( p_name => 'APPROVER_NAME',
374: p_itemtype => itemtype,
375: p_itemkey => itemkey ) ) then
376: --
377: l_approver_name := wf_engine.GetItemAttrText
378: (itemtype => itemtype,
379: itemkey => itemkey,
380: aname => 'APPROVER_NAME'
381: );

Line 388: l_upd_hr_user_name := wf_engine.GetItemAttrText

384: if ( CheckItemAttribute ( p_name => 'PERSON_UPDATE_HR',
385: p_itemtype => itemtype,
386: p_itemkey => itemkey ) ) then
387: --
388: l_upd_hr_user_name := wf_engine.GetItemAttrText
389: (itemtype => itemtype,
390: itemkey => itemkey,
391: aname => 'PERSON_UPDATE_HR'
392: );

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

465: p_line7 => l_line7,
466: p_line8 => l_line8,
467: p_line9 => l_line9
468: );
469: wf_engine.SetItemAttrText( itemtype => itemtype,
470: itemkey => itemkey,
471: aname => 'SUBJECT_HDR',
472: avalue => l_subject
473: );

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

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

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

475: itemkey => itemkey,
476: aname => 'LINE1',
477: avalue => l_line1
478: );
479: wf_engine.SetItemAttrText( itemtype => itemtype,
480: itemkey => itemkey,
481: aname => 'LINE2',
482: avalue => l_line2
483: );

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

481: aname => 'LINE2',
482: avalue => l_line2
483: );
484: /*
485: wf_engine.SetItemAttrText( itemtype => itemtype,
486: itemkey => itemkey,
487: aname => 'PROPOSED_EFF_DATE',
488: avalue => l_line2a
489: );

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

487: aname => 'PROPOSED_EFF_DATE',
488: avalue => l_line2a
489: );
490: */
491: wf_engine.SetItemAttrText( itemtype => itemtype,
492: itemkey => itemkey,
493: aname => 'LINE3',
494: avalue => l_line3
495: );

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

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

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

497: itemkey => itemkey,
498: aname => 'LINE4',
499: avalue => l_line4
500: );
501: wf_engine.SetItemAttrText( itemtype => itemtype,
502: itemkey => itemkey,
503: aname => 'LINE5',
504: avalue => l_line5
505: );

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

503: aname => 'LINE5',
504: avalue => l_line5
505: );
506: /*
507: wf_engine.SetItemAttrText( itemtype => itemtype,
508: itemkey => itemkey,
509: aname => 'DATE_INITIATED',
510: avalue => l_line5a
511: );

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

509: aname => 'DATE_INITIATED',
510: avalue => l_line5a
511: );
512: */
513: wf_engine.SetItemAttrText( itemtype => itemtype,
514: itemkey => itemkey,
515: aname => 'LINE6',
516: avalue => l_line6
517: );

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

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

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

519: itemkey => itemkey,
520: aname => 'LINE7',
521: avalue => l_line7
522: );
523: wf_engine.SetItemAttrText( itemtype => itemtype,
524: itemkey => itemkey,
525: aname => 'LINE8',
526: avalue => l_line8
527: );

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

527: );
528: if ( CheckItemAttribute ( p_name => 'LINE9',
529: p_itemtype => itemtype,
530: p_itemkey => itemkey ) ) then
531: wf_engine.SetItemAttrText( itemtype => itemtype,
532: itemkey => itemkey,
533: aname => 'LINE9',
534: avalue => l_line9
535: );

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

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

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

561: result := 'COMPLETE:CONTINUE';
562: return;
563: else
564:
565: wf_engine.SetItemAttrText( itemtype => Itemtype,
566: itemkey => Itemkey,
567: aname => 'FORWARD_TO_NAME',
568: avalue => l_groupbox_name );
569: result := 'COMPLETE:CONTINUE';

Line 804: l_error_msg := wf_engine.GetItemAttrText

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

Line 1038: wf_engine.SetItemAttrText(

1034:
1035: begin
1036: -- Added for Future Action process
1037: if p_error_msg Is Null then
1038: wf_engine.SetItemAttrText(
1039: itemtype => 'GHR_SF52',
1040: itemkey => p_pa_request_id,
1041: aname => 'LINE_ERROR',
1042: avalue => ''

Line 1045: wf_engine.SetItemAttrText(

1041: aname => 'LINE_ERROR',
1042: avalue => ''
1043: );
1044: else
1045: wf_engine.SetItemAttrText(
1046: itemtype => 'GHR_SF52',
1047: itemkey => p_pa_request_id,
1048: aname => 'LINE_ERROR',
1049: avalue => 'Update HR Error : '

Line 1054: l_forward_from_display_name := wf_engine.GetItemAttrText(itemtype => 'GHR_SF52',

1050: || substr(p_error_msg,1,1000)
1051: );
1052: end if;
1053:
1054: l_forward_from_display_name := wf_engine.GetItemAttrText(itemtype => 'GHR_SF52',
1055: itemkey => p_pa_request_id,
1056: aname => 'FORWARD_FROM_DISPLAY_NAME'
1057: );
1058:

Line 1060: wf_engine.SetItemAttrText(itemtype => 'GHR_SF52',

1056: aname => 'FORWARD_FROM_DISPLAY_NAME'
1057: );
1058:
1059: IF l_forward_from_display_name <> FND_GLOBAL.USER_NAME() THEN
1060: wf_engine.SetItemAttrText(itemtype => 'GHR_SF52',
1061: itemkey => p_pa_request_id,
1062: aname => 'FORWARD_FROM_DISPLAY_NAME',
1063: avalue => FND_GLOBAL.USER_NAME() );
1064: END IF;

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

1062: aname => 'FORWARD_FROM_DISPLAY_NAME',
1063: avalue => FND_GLOBAL.USER_NAME() );
1064: END IF;
1065:
1066: wf_engine.CompleteActivity('GHR_SF52', p_pa_request_id, 'GH_NOTIFY_SF52','COMPLETE');
1067: end;
1068: --
1069: --
1070: --

Line 1078: wf_engine.SetItemAttrText(

1074: p_error_msg in varchar2 default null
1075: ) is
1076: begin
1077: if p_error_msg Is Null then
1078: wf_engine.SetItemAttrText(
1079: itemtype => 'GHR_SF52',
1080: itemkey => p_pa_request_id,
1081: aname => 'LINE_ERROR',
1082: avalue => ''

Line 1085: wf_engine.SetItemAttrText(

1081: aname => 'LINE_ERROR',
1082: avalue => ''
1083: );
1084: else
1085: wf_engine.SetItemAttrText(
1086: itemtype => 'GHR_SF52',
1087: itemkey => p_pa_request_id,
1088: aname => 'LINE_ERROR',
1089: avalue => 'Update HR Error : '

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

1091: );
1092: end if;
1093: --
1094: if p_action_taken = 'UPDATE_HR_COMPLETE' then
1095: wf_engine.CompleteActivity('GHR_SF52', p_pa_request_id, 'BLOCK_FUTURE_ACTION','UPDATE_HR_COMPLETE');
1096: else
1097: wf_engine.CompleteActivity('GHR_SF52', p_pa_request_id, 'BLOCK_FUTURE_ACTION','CONTINUE');
1098: end if;
1099: --

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

1093: --
1094: if p_action_taken = 'UPDATE_HR_COMPLETE' then
1095: wf_engine.CompleteActivity('GHR_SF52', p_pa_request_id, 'BLOCK_FUTURE_ACTION','UPDATE_HR_COMPLETE');
1096: else
1097: wf_engine.CompleteActivity('GHR_SF52', p_pa_request_id, 'BLOCK_FUTURE_ACTION','CONTINUE');
1098: end if;
1099: --
1100: --
1101: end CompleteBlockingOfFutureAction ;

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

1163:
1164: l_load_form := 'GHRWS52L:p_pa_request_id=' || Itemkey
1165: || ' p_inbox_query_only=YES' || ' WORKFLOW_NAME=GHR_US_PA_REQUEST'
1166: || ' p_wf_notification_id=&#NID';--Bug# 6923642
1167: wf_engine.SetItemAttrText( itemtype => itemtype,
1168: itemkey => itemkey,
1169: aname => 'PA_REQUEST_RO',
1170: avalue => l_load_form
1171: );

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

1213: begin
1214: l_result := result;
1215: --
1216: if funcmode = 'RUN' then
1217: l_text := wf_engine.GetItemAttrText( itemtype => Itemtype,
1218: itemkey => Itemkey,
1219: aname => 'NTFY_UPD_HR_YES_NO');
1220: if l_text = 'NO' then
1221: result := 'COMPLETE:NO';

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

1259: begin
1260: l_result := result;
1261: --
1262: if funcmode = 'RUN' then
1263: l_text := wf_engine.GetItemAttrText( itemtype => Itemtype,
1264: itemkey => Itemkey,
1265: aname => 'USE_UPD_HR_ONLY');
1266: if l_text = 'NO' then
1267: result := 'COMPLETE:NO';

Line 1453: l_forward_to_name := WF_ENGINE.context_text;

1449: IF (funcmode in ('FORWARD','TRANSFER')) then
1450: -- Get the current user name
1451: l_current_user_name := FND_GLOBAL.USER_NAME();
1452: -- Get the Forward To Information
1453: l_forward_to_name := WF_ENGINE.context_text;
1454: -- Validate the username
1455: -- a) Get the routing group id
1456: FOR rg_rec in get_par LOOP
1457: l_routing_group_id := rg_rec.routing_group_id;

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

1585: -- Reset IN OUT parameters and set OUT parameters
1586: --
1587: result := l_result;
1588: IF l_exp = 1 then
1589: result := wf_engine.eng_completed||':'||wf_engine.eng_null;
1590: fnd_message.set_name('GHR', 'GHR_38815_WF_INVALID_USER');
1591: app_exception.raise_exception;
1592: ELSIF l_exp = 2 then
1593: result := wf_engine.eng_completed||':'||wf_engine.eng_null;

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

1589: result := wf_engine.eng_completed||':'||wf_engine.eng_null;
1590: fnd_message.set_name('GHR', 'GHR_38815_WF_INVALID_USER');
1591: app_exception.raise_exception;
1592: ELSIF l_exp = 2 then
1593: result := wf_engine.eng_completed||':'||wf_engine.eng_null;
1594: fnd_message.set_name('GHR', 'GHR_38674_NO_REASSIGN');
1595: app_exception.raise_exception;
1596: END IF;
1597: END norout;