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

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

114: diagn_msg(l_state_level,'start_approval_workflow','Generated User Key = ' ||l_userkey);
115:
116:
117: -- Kick Off workflow process
118: wf_engine.CreateProcess( itemtype => l_itemtype,
119: itemkey => l_itemkey,
120: process => 'ITR_APPROVAL_TOP_PROCESS' );
121: diagn_msg(l_state_level,'start_approval_workflow','Process for ITR_APPROVAL_TOP_PROCESS created');
122:

Line 124: wf_engine.SetItemUserKey( itemtype => l_itemtype,

120: process => 'ITR_APPROVAL_TOP_PROCESS' );
121: diagn_msg(l_state_level,'start_approval_workflow','Process for ITR_APPROVAL_TOP_PROCESS created');
122:
123: -- Set item user key
124: wf_engine.SetItemUserKey( itemtype => l_itemtype,
125: itemkey => l_itemkey,
126: userkey => l_userkey );
127:
128: -- Set cross charge id (IT_HEADER_ID)

Line 129: wf_engine.SetItemAttrNumber( itemtype => l_itemtype,

125: itemkey => l_itemkey,
126: userkey => l_userkey );
127:
128: -- Set cross charge id (IT_HEADER_ID)
129: wf_engine.SetItemAttrNumber( itemtype => l_itemtype,
130: itemkey => l_itemkey,
131: aname => 'CROSS_CHARGE_ID',
132: avalue => p_cc_id );
133: diagn_msg(l_state_level,'start_approval_workflow','Attribute CROSS_CHARGE_ID set to' ||to_char(p_cc_id));

Line 136: wf_engine.SetItemAttrNumber( itemtype => l_itemtype,

132: avalue => p_cc_id );
133: diagn_msg(l_state_level,'start_approval_workflow','Attribute CROSS_CHARGE_ID set to' ||to_char(p_cc_id));
134:
135: -- Set cross charge line num (IT_LINE_NUM)
136: wf_engine.SetItemAttrNumber( itemtype => l_itemtype,
137: itemkey => l_itemkey,
138: aname => 'CC_LINE_NUM',
139: avalue => p_cc_line_num );
140:

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

138: aname => 'CC_LINE_NUM',
139: avalue => p_cc_line_num );
140:
141: -- Set cross charge name (CC_NAME)
142: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
143: itemkey => l_itemkey,
144: aname => 'CC_NAME',
145: avalue => p_cc_name );
146: diagn_msg(l_state_level,'start_approval_workflow','Attribute CC_NAME set to ' ||p_cc_name);

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

145: avalue => p_cc_name );
146: diagn_msg(l_state_level,'start_approval_workflow','Attribute CC_NAME set to ' ||p_cc_name);
147:
148: -- Set the unique item key
149: wf_engine.SetItemAttrText( itemtype => l_itemtype,
150: itemkey => l_itemkey,
151: aname => 'UNIQUE_ITEMKEY',
152: avalue => l_itemkey );
153: diagn_msg(l_state_level,'start_approval_workflow','Set the unique item key: '||l_itemkey);

Line 163: wf_engine.SetItemAttrNumber( itemtype => l_itemtype,

159: FROM fnd_user
160: WHERE user_id = p_preparer_fnd_user_id;
161:
162: -- Set PersonID attribute (HR personID from PER_PERSONS_F)
163: wf_engine.SetItemAttrNumber( itemtype => l_itemtype,
164: itemkey => l_itemkey,
165: aname => 'PREPARER_ID',
166: avalue => l_preparer_id);
167: diagn_msg(l_state_level,'start_approval_workflow','Attribute PREPARER_ID set to ' ||l_preparer_id );

Line 170: wf_engine.SetItemAttrNumber( itemtype => l_itemtype,

166: avalue => l_preparer_id);
167: diagn_msg(l_state_level,'start_approval_workflow','Attribute PREPARER_ID set to ' ||l_preparer_id );
168:
169: -- Set UserID attribute (AOL userID from FND_USER table).
170: wf_engine.SetItemAttrNumber( itemtype => l_itemtype,
171: itemkey => l_itemkey,
172: aname => 'PREPARER_FND_ID',
173: avalue => p_preparer_fnd_user_id);
174:

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

179: p_display_name => l_preparer_display_name );
180: diagn_msg(l_state_level,'start_approval_workflow','Retrieved user name: '||l_preparer_name);
181:
182: -- Copy username to Workflow
183: wf_engine.SetItemAttrText( itemtype => l_itemtype,
184: itemkey => l_itemkey,
185: aname => 'PREPARER_NAME',
186: avalue => l_preparer_name );
187: diagn_msg(l_state_level,'start_approval_workflow','Attribute PREPARER_NAME set to' ||l_preparer_name);

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

186: avalue => l_preparer_name );
187: diagn_msg(l_state_level,'start_approval_workflow','Attribute PREPARER_NAME set to' ||l_preparer_name);
188:
189: -- Copy displayed username to Workflow
190: wf_engine.SetItemAttrText( itemtype => l_itemtype,
191: itemkey => l_itemkey,
192: aname => 'PREPARER_DISPLAY_NAME',
193: avalue => l_preparer_display_name );
194: diagn_msg(l_state_level,'start_approval_workflow','Attribute PREPARER_DISPLAY_NAME set to '||l_preparer_display_name);

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

193: avalue => l_preparer_display_name );
194: diagn_msg(l_state_level,'start_approval_workflow','Attribute PREPARER_DISPLAY_NAME set to '||l_preparer_display_name);
195:
196: -- Populate preparer authorised attribute
197: wf_engine.SetItemAttrText( itemtype => l_itemtype,
198: itemkey => l_itemkey,
199: aname => 'PREPARER_AUTH',
200: avalue => p_prep_auth );
201: diagn_msg(l_state_level,'start_approval_workflow','Attribute PREPARER_AUTH set to '||p_prep_auth);

Line 213: wf_engine.SetItemAttrNumber( itemtype => l_itemtype,

209: FROM fnd_user
210: WHERE user_id = p_sec_apprv_fnd_id;
211:
212: -- Set PersonID attribute (HR personID from PER_PERSONS_F)
213: wf_engine.SetItemAttrNumber( itemtype => l_itemtype,
214: itemkey => l_itemkey,
215: aname => 'SEC_APPROVER_ID',
216: avalue => l_sec_approver_id);
217: diagn_msg(l_state_level,'start_approval_workflow','Attribute SEC_APPROVER_ID set to ' ||l_sec_approver_id );

Line 220: wf_engine.SetItemAttrNumber( itemtype => l_itemtype,

216: avalue => l_sec_approver_id);
217: diagn_msg(l_state_level,'start_approval_workflow','Attribute SEC_APPROVER_ID set to ' ||l_sec_approver_id );
218:
219: -- Set UserID attribute (AOL userID from FND_USER table).
220: wf_engine.SetItemAttrNumber( itemtype => l_itemtype,
221: itemkey => l_itemkey,
222: aname => 'SEC_APPROVER_FND_ID',
223: avalue => p_sec_apprv_fnd_id);
224:

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

230: p_display_name => l_sec_approver_display_name );
231: diagn_msg(l_state_level,'start_approval_workflow','Retrieved user name: '||l_sec_approver_name);
232:
233: -- Copy username to Workflow
234: wf_engine.SetItemAttrText( itemtype => l_itemtype,
235: itemkey => l_itemkey,
236: aname => 'SEC_APPROVER_NAME',
237: avalue => l_sec_approver_name );
238: diagn_msg(l_state_level,'start_approval_workflow','Attribute SEC_APPROVER_NAME set to' ||l_sec_approver_name);

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

237: avalue => l_sec_approver_name );
238: diagn_msg(l_state_level,'start_approval_workflow','Attribute SEC_APPROVER_NAME set to' ||l_sec_approver_name);
239:
240: -- Copy displayed username to Workflow
241: wf_engine.SetItemAttrText( itemtype => l_itemtype,
242: itemkey => l_itemkey,
243: aname => 'SEC_APPROVER_DISPLAY_NAME',
244: avalue => l_sec_approver_display_name );
245: diagn_msg(l_state_level,'start_approval_workflow','Attribute SEC_APPROVER_DISPLAY_NAME set to '||

Line 251: wf_engine.StartProcess( itemtype => l_itemtype,

247:
248: END IF;
249:
250: -- Finally, start the process
251: wf_engine.StartProcess( itemtype => l_itemtype,
252: itemkey => l_itemkey );
253:
254: diagn_msg(l_state_level,'start_approval_workflow','Process ITR_APPROVAL_PROCESS started');
255:

Line 316: l_cross_charge_id := wf_engine.GetItemAttrNumber(

312: BEGIN
313:
314: IF ( funcmode = 'RUN' ) THEN
315: -- Get Cross Charge ID
316: l_cross_charge_id := wf_engine.GetItemAttrNumber(
317: itemtype => itemtype,
318: itemkey => itemkey,
319: aname => 'CROSS_CHARGE_ID');
320:

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

345:
346: diagn_msg(l_state_level,'get_sob_attributes','SOB Attributes retrieved from db');
347:
348: -- Set the corresponding attributes in workflow
349: wf_engine.SetItemAttrText ( itemtype => itemtype,
350: itemkey => itemkey,
351: aname => 'FUNC_CURRENCY',
352: avalue => l_func_currency );
353: diagn_msg(l_state_level,'get_sob_attributes','Get_SOB_Attributes: Func currency = '||l_func_currency);

Line 355: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

351: aname => 'FUNC_CURRENCY',
352: avalue => l_func_currency );
353: diagn_msg(l_state_level,'get_sob_attributes','Get_SOB_Attributes: Func currency = '||l_func_currency);
354:
355: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
356: itemkey => itemkey,
357: aname => 'SET_OF_BOOKS_ID',
358: avalue => l_set_of_books_id );
359: diagn_msg(l_state_level,'get_sob_attributes','Get_SOB_Attributes: Set of books id : ' ||to_char(l_set_of_books_id ));

Line 361: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

357: aname => 'SET_OF_BOOKS_ID',
358: avalue => l_set_of_books_id );
359: diagn_msg(l_state_level,'get_sob_attributes','Get_SOB_Attributes: Set of books id : ' ||to_char(l_set_of_books_id ));
360:
361: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
362: itemkey => itemkey,
363: aname => 'TIMEOUT_DAYS',
364: avalue => l_timeout_days );
365: diagn_msg(l_state_level,'get_sob_attributes','Get_SOB_Attributes: timeout days: ' ||to_char(l_timeout_days));

Line 367: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

363: aname => 'TIMEOUT_DAYS',
364: avalue => l_timeout_days );
365: diagn_msg(l_state_level,'get_sob_attributes','Get_SOB_Attributes: timeout days: ' ||to_char(l_timeout_days));
366:
367: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
368: itemkey => itemkey,
369: aname => 'TIMEOUT_MINS',
370: avalue => l_timeout_mins );
371: diagn_msg(l_state_level,'get_sob_attributes','Get_SOB_Attributes: timeout mins: ' ||to_char(l_timeout_mins));

Line 413: l_cross_charge_id := wf_engine.GetItemAttrNumber(

409:
410: IF ( funcmode = 'RUN' ) THEN
411:
412: -- Get cross charge ID (primary key)
413: l_cross_charge_id := wf_engine.GetItemAttrNumber(
414: itemtype => itemtype,
415: itemkey => itemkey,
416: aname => 'CROSS_CHARGE_ID');
417:

Line 419: l_cc_line_num := wf_engine.GetItemAttrNumber(

415: itemkey => itemkey,
416: aname => 'CROSS_CHARGE_ID');
417:
418: -- Get cross charge line num
419: l_cc_line_num := wf_engine.GetItemAttrNumber(
420: itemtype => itemtype,
421: itemkey => itemkey,
422: aname => 'CC_LINE_NUM');
423:

Line 458: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

454: --
455: diagn_msg(l_state_level,'get_cc_attributes','CC Attributes retrieved from db');
456: --
457: -- Copy cross charge total to corresponding item attribute in workflow
458: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
459: itemkey => itemkey,
460: aname => 'CC_LINE_AMOUNT',
461: avalue => l_cc_line_tot );
462: diagn_msg(l_state_level,'get_cc_attributes','get_cc_attributes: Cross Charge Line Amount = ' ||to_char(l_cc_line_tot));

Line 466: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

462: diagn_msg(l_state_level,'get_cc_attributes','get_cc_attributes: Cross Charge Line Amount = ' ||to_char(l_cc_line_tot));
463:
464:
465: -- Copy service line id to corresponding item attribute in workflow
466: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
467: itemkey => itemkey,
468: aname => 'SERVICE_LINE_ID',
469: avalue => l_service_line_id );
470: diagn_msg(l_state_level,'get_cc_attributes','get_cc_attributes: Service Line Id = ' ||to_char(l_service_line_id));

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

469: avalue => l_service_line_id );
470: diagn_msg(l_state_level,'get_cc_attributes','get_cc_attributes: Service Line Id = ' ||to_char(l_service_line_id));
471:
472: -- Copy charge center name to corresponding item attribute in workflow
473: wf_engine.SetItemAttrText ( itemtype => itemtype,
474: itemkey => itemkey,
475: aname => 'RECV_CHARGE_CENTER',
476: avalue => l_charge_center_name);
477: diagn_msg(l_state_level,'get_cc_attributes','get_cc_attributes: Charge Center Name = ' ||l_charge_center_name);

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

476: avalue => l_charge_center_name);
477: diagn_msg(l_state_level,'get_cc_attributes','get_cc_attributes: Charge Center Name = ' ||l_charge_center_name);
478:
479: -- Copy charge service name to corresponding item attribute in workflow
480: wf_engine.SetItemAttrText ( itemtype => itemtype,
481: itemkey => itemkey,
482: aname => 'CHARGE_SERVICE_NAME',
483: avalue => l_charge_service_name);
484: diagn_msg(l_state_level,'get_cc_attributes','get_cc_attributes: Charge Service Name = ' ||l_charge_service_name);

Line 519: l_preparer_auth := wf_engine.GetItemAttrText( itemtype => itemtype,

515: result OUT NOCOPY VARCHAR2 ) IS
516: l_preparer_auth VARCHAR2(1);
517: BEGIN
518: IF ( funcmode = 'RUN') THEN
519: l_preparer_auth := wf_engine.GetItemAttrText( itemtype => itemtype,
520: itemkey => itemkey,
521: aname => 'PREPARER_AUTH');
522: diagn_msg(l_state_level,'did_preparer_approve','Preparer authorised to approve = '||l_preparer_auth);
523:

Line 565: l_preparer_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

561: l_preparer_name VARCHAR2(240);
562: l_preparer_display_name VARCHAR2(240);
563: BEGIN
564: IF ( funcmode = 'RUN') THEN
565: l_preparer_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
566: itemkey => itemkey,
567: aname => 'PREPARER_ID');
568: l_preparer_name := wf_engine.GetItemAttrText( itemtype => itemtype,
569: itemkey => itemkey,

Line 568: l_preparer_name := wf_engine.GetItemAttrText( itemtype => itemtype,

564: IF ( funcmode = 'RUN') THEN
565: l_preparer_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
566: itemkey => itemkey,
567: aname => 'PREPARER_ID');
568: l_preparer_name := wf_engine.GetItemAttrText( itemtype => itemtype,
569: itemkey => itemkey,
570: aname => 'PREPARER_NAME');
571: l_preparer_display_name := wf_engine.GetItemAttrText( itemtype => itemtype,
572: itemkey => itemkey,

Line 571: l_preparer_display_name := wf_engine.GetItemAttrText( itemtype => itemtype,

567: aname => 'PREPARER_ID');
568: l_preparer_name := wf_engine.GetItemAttrText( itemtype => itemtype,
569: itemkey => itemkey,
570: aname => 'PREPARER_NAME');
571: l_preparer_display_name := wf_engine.GetItemAttrText( itemtype => itemtype,
572: itemkey => itemkey,
573: aname => 'PREPARER_DISPLAY_NAME');
574: wf_engine.SetItemAttrNumber( itemtype => itemtype,
575: itemkey => itemkey,

Line 574: wf_engine.SetItemAttrNumber( itemtype => itemtype,

570: aname => 'PREPARER_NAME');
571: l_preparer_display_name := wf_engine.GetItemAttrText( itemtype => itemtype,
572: itemkey => itemkey,
573: aname => 'PREPARER_DISPLAY_NAME');
574: wf_engine.SetItemAttrNumber( itemtype => itemtype,
575: itemkey => itemkey,
576: aname => 'APPROVER_ID',
577: avalue => l_preparer_id );
578: wf_engine.SetItemAttrText( itemtype => itemtype,

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

574: wf_engine.SetItemAttrNumber( itemtype => itemtype,
575: itemkey => itemkey,
576: aname => 'APPROVER_ID',
577: avalue => l_preparer_id );
578: wf_engine.SetItemAttrText( itemtype => itemtype,
579: itemkey => itemkey,
580: aname => 'APPROVER_NAME',
581: avalue => l_preparer_name );
582: wf_engine.SetItemAttrText( itemtype => itemtype,

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

578: wf_engine.SetItemAttrText( itemtype => itemtype,
579: itemkey => itemkey,
580: aname => 'APPROVER_NAME',
581: avalue => l_preparer_name );
582: wf_engine.SetItemAttrText( itemtype => itemtype,
583: itemkey => itemkey,
584: aname => 'APPROVER_DISPLAY_NAME',
585: avalue => l_preparer_display_name );
586: diagn_msg(l_state_level,'set_approver_name_to_prep','Approver name set for cross charge line ');

Line 618: l_sec_approver_fnd_id := wf_engine.GetItemAttrText( itemtype => itemtype,

614: result OUT NOCOPY VARCHAR2 ) IS
615: l_sec_approver_fnd_id NUMBER;
616: BEGIN
617: IF ( funcmode = 'RUN') THEN
618: l_sec_approver_fnd_id := wf_engine.GetItemAttrText( itemtype => itemtype,
619: itemkey => itemkey,
620: aname => 'SEC_APPROVER_FND_ID');
621:
622: IF l_sec_approver_fnd_id is not null THEN

Line 663: l_sec_approver_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

659: l_sec_approver_name VARCHAR2(240);
660: l_sec_approver_display_name VARCHAR2(240);
661: BEGIN
662: IF ( funcmode = 'RUN') THEN
663: l_sec_approver_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
664: itemkey => itemkey,
665: aname => 'SEC_APPROVER_ID');
666: l_sec_approver_name := wf_engine.GetItemAttrText( itemtype => itemtype,
667: itemkey => itemkey,

Line 666: l_sec_approver_name := wf_engine.GetItemAttrText( itemtype => itemtype,

662: IF ( funcmode = 'RUN') THEN
663: l_sec_approver_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
664: itemkey => itemkey,
665: aname => 'SEC_APPROVER_ID');
666: l_sec_approver_name := wf_engine.GetItemAttrText( itemtype => itemtype,
667: itemkey => itemkey,
668: aname => 'SEC_APPROVER_NAME');
669: l_sec_approver_display_name := wf_engine.GetItemAttrText( itemtype => itemtype,
670: itemkey => itemkey,

Line 669: l_sec_approver_display_name := wf_engine.GetItemAttrText( itemtype => itemtype,

665: aname => 'SEC_APPROVER_ID');
666: l_sec_approver_name := wf_engine.GetItemAttrText( itemtype => itemtype,
667: itemkey => itemkey,
668: aname => 'SEC_APPROVER_NAME');
669: l_sec_approver_display_name := wf_engine.GetItemAttrText( itemtype => itemtype,
670: itemkey => itemkey,
671: aname => 'SEC_APPROVER_DISPLAY_NAME');
672: wf_engine.SetItemAttrNumber( itemtype => itemtype,
673: itemkey => itemkey,

Line 672: wf_engine.SetItemAttrNumber( itemtype => itemtype,

668: aname => 'SEC_APPROVER_NAME');
669: l_sec_approver_display_name := wf_engine.GetItemAttrText( itemtype => itemtype,
670: itemkey => itemkey,
671: aname => 'SEC_APPROVER_DISPLAY_NAME');
672: wf_engine.SetItemAttrNumber( itemtype => itemtype,
673: itemkey => itemkey,
674: aname => 'APPROVER_ID',
675: avalue => l_sec_approver_id );
676: wf_engine.SetItemAttrText( itemtype => itemtype,

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

672: wf_engine.SetItemAttrNumber( itemtype => itemtype,
673: itemkey => itemkey,
674: aname => 'APPROVER_ID',
675: avalue => l_sec_approver_id );
676: wf_engine.SetItemAttrText( itemtype => itemtype,
677: itemkey => itemkey,
678: aname => 'APPROVER_NAME',
679: avalue => l_sec_approver_name );
680: wf_engine.SetItemAttrText( itemtype => itemtype,

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

676: wf_engine.SetItemAttrText( itemtype => itemtype,
677: itemkey => itemkey,
678: aname => 'APPROVER_NAME',
679: avalue => l_sec_approver_name );
680: wf_engine.SetItemAttrText( itemtype => itemtype,
681: itemkey => itemkey,
682: aname => 'APPROVER_DISPLAY_NAME',
683: avalue => l_sec_approver_display_name );
684: diagn_msg(l_state_level,'set_approver_name_to_sec_app','Approver name set for cross charge line ');

Line 722: l_service_line_id := wf_engine.GetItemAttrNumber(

718: BEGIN
719: IF funcmode = 'RUN' THEN
720: diagn_msg(l_state_level,'maintain_history','Executing maintain_history');
721:
722: l_service_line_id := wf_engine.GetItemAttrNumber(
723: itemtype => itemtype,
724: itemkey => itemkey,
725: aname => 'SERVICE_LINE_ID' );
726:

Line 732: l_action_code := wf_engine.GetActivityAttrText(

728: INTO l_sequence_num
729: FROM igi_itr_action_history
730: WHERE it_service_line_id = l_service_line_id;
731:
732: l_action_code := wf_engine.GetActivityAttrText(
733: itemtype => itemtype,
734: itemkey => itemkey,
735: actid => actid,
736: aname => 'ACTION_CODE' );

Line 738: l_performer_id := wf_engine.GetActivityAttrText(

734: itemkey => itemkey,
735: actid => actid,
736: aname => 'ACTION_CODE' );
737:
738: l_performer_id := wf_engine.GetActivityAttrText(
739: itemtype => itemtype,
740: itemkey => itemkey,
741: actid => actid,
742: aname => 'PERFORMER_ID' );

Line 802: l_cross_charge_id := wf_engine.GetItemAttrNumber(

798: BEGIN
799: IF funcmode = 'RUN' THEN
800: diagn_msg(l_state_level,'submit_cc_line','Executing Submit_CC_line');
801:
802: l_cross_charge_id := wf_engine.GetItemAttrNumber(
803: itemtype => itemtype,
804: itemkey => itemkey,
805: aname => 'CROSS_CHARGE_ID' );
806:

Line 807: l_cc_line_num := wf_engine.GetItemAttrNumber( itemtype => itemtype,

803: itemtype => itemtype,
804: itemkey => itemkey,
805: aname => 'CROSS_CHARGE_ID' );
806:
807: l_cc_line_num := wf_engine.GetItemAttrNumber( itemtype => itemtype,
808: itemkey => itemkey,
809: aname => 'CC_LINE_NUM');
810:
811: --

Line 857: l_cross_charge_id := wf_engine.GetItemAttrNumber(

853: BEGIN
854: IF funcmode = 'RUN' THEN
855: diagn_msg(l_state_level,'no_submit_cc_line','Executing No_Submit_CC_line');
856:
857: l_cross_charge_id := wf_engine.GetItemAttrNumber(
858: itemtype => itemtype,
859: itemkey => itemkey,
860: aname => 'CROSS_CHARGE_ID' );
861:

Line 862: l_cc_line_num := wf_engine.GetItemAttrNumber( itemtype => itemtype,

858: itemtype => itemtype,
859: itemkey => itemkey,
860: aname => 'CROSS_CHARGE_ID' );
861:
862: l_cc_line_num := wf_engine.GetItemAttrNumber( itemtype => itemtype,
863: itemkey => itemkey,
864: aname => 'CC_LINE_NUM');
865:
866: --

Line 922: l_cross_charge_id := wf_engine.GetItemAttrNumber(

918:
919: IF ( funcmode = 'RUN' ) THEN
920:
921: -- Get cross charge ID (primary key)
922: l_cross_charge_id := wf_engine.GetItemAttrNumber(
923: itemtype => itemtype,
924: itemkey => itemkey,
925: aname => 'CROSS_CHARGE_ID');
926:

Line 928: l_cc_line_num := wf_engine.GetItemAttrNumber(

924: itemkey => itemkey,
925: aname => 'CROSS_CHARGE_ID');
926:
927: -- Get cross charge line num
928: l_cc_line_num := wf_engine.GetItemAttrNumber(
929: itemtype => itemtype,
930: itemkey => itemkey,
931: aname => 'CC_LINE_NUM');
932:

Line 948: wf_engine.SetItemAttrNumber( itemtype => itemtype,

944: AND itrl.charge_range_id = auth.charge_range_id;
945:
946:
947: -- Set Receiver fnd user ID attribute (AOL user ID from FND_USER)
948: wf_engine.SetItemAttrNumber( itemtype => itemtype,
949: itemkey => itemkey,
950: aname => 'RECEIVER_FND_ID',
951: avalue => l_rec_fnd_user_id);
952: diagn_msg(l_state_level,'find_cc_receiver','Attribute RECEIVER_FND_ID set to ' ||l_rec_fnd_user_id );

Line 962: wf_engine.SetItemAttrNumber( itemtype => itemtype,

958: FROM fnd_user
959: WHERE user_id = l_rec_fnd_user_id;
960:
961: -- Set PersonID attribute (HR personID from PER_PERSONS_F)
962: wf_engine.SetItemAttrNumber( itemtype => itemtype,
963: itemkey => itemkey,
964: aname => 'RECEIVER_ID',
965: avalue => l_receiver_id);
966: diagn_msg(l_state_level,'find_cc_receiver','Attribute RECEIVER_ID set to ' ||l_receiver_id );

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

974: diagn_msg(l_state_level,'find_cc_receiver','Retrieved user name: '||l_receiver_name);
975: diagn_msg(l_state_level,'find_cc_receiver','Retrieved user display name: '||l_receiver_display_name);
976:
977: -- Copy username to Workflow
978: wf_engine.SetItemAttrText( itemtype => itemtype,
979: itemkey => itemkey,
980: aname => 'RECEIVER_NAME',
981: avalue => l_receiver_name );
982: diagn_msg(l_state_level,'find_cc_receiver','Attribute RECEIVER_NAME set to' ||l_receiver_name);

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

981: avalue => l_receiver_name );
982: diagn_msg(l_state_level,'find_cc_receiver','Attribute RECEIVER_NAME set to' ||l_receiver_name);
983:
984: -- Copy displayed username to Workflow
985: wf_engine.SetItemAttrText( itemtype => itemtype,
986: itemkey => itemkey,
987: aname => 'RECEIVER_DISPLAY_NAME',
988: avalue => l_receiver_display_name );
989: diagn_msg(l_state_level,'find_cc_receiver','Attribute RECEIVER_DISPLAY_NAME set to '||l_receiver_display_name);

Line 1027: l_receiver_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1023: l_receiver_name VARCHAR2(240);
1024: l_receiver_display_name VARCHAR2(240);
1025: BEGIN
1026: IF ( funcmode = 'RUN') THEN
1027: l_receiver_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1028: itemkey => itemkey,
1029: aname => 'RECEIVER_ID');
1030: l_receiver_name := wf_engine.GetItemAttrText( itemtype => itemtype,
1031: itemkey => itemkey,

Line 1030: l_receiver_name := wf_engine.GetItemAttrText( itemtype => itemtype,

1026: IF ( funcmode = 'RUN') THEN
1027: l_receiver_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1028: itemkey => itemkey,
1029: aname => 'RECEIVER_ID');
1030: l_receiver_name := wf_engine.GetItemAttrText( itemtype => itemtype,
1031: itemkey => itemkey,
1032: aname => 'RECEIVER_NAME');
1033: l_receiver_display_name := wf_engine.GetItemAttrText( itemtype => itemtype,
1034: itemkey => itemkey,

Line 1033: l_receiver_display_name := wf_engine.GetItemAttrText( itemtype => itemtype,

1029: aname => 'RECEIVER_ID');
1030: l_receiver_name := wf_engine.GetItemAttrText( itemtype => itemtype,
1031: itemkey => itemkey,
1032: aname => 'RECEIVER_NAME');
1033: l_receiver_display_name := wf_engine.GetItemAttrText( itemtype => itemtype,
1034: itemkey => itemkey,
1035: aname => 'RECEIVER_DISPLAY_NAME');
1036: wf_engine.SetItemAttrNumber( itemtype => itemtype,
1037: itemkey => itemkey,

Line 1036: wf_engine.SetItemAttrNumber( itemtype => itemtype,

1032: aname => 'RECEIVER_NAME');
1033: l_receiver_display_name := wf_engine.GetItemAttrText( itemtype => itemtype,
1034: itemkey => itemkey,
1035: aname => 'RECEIVER_DISPLAY_NAME');
1036: wf_engine.SetItemAttrNumber( itemtype => itemtype,
1037: itemkey => itemkey,
1038: aname => 'APPROVER_ID',
1039: avalue => l_receiver_id );
1040: wf_engine.SetItemAttrText( itemtype => itemtype,

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

1036: wf_engine.SetItemAttrNumber( itemtype => itemtype,
1037: itemkey => itemkey,
1038: aname => 'APPROVER_ID',
1039: avalue => l_receiver_id );
1040: wf_engine.SetItemAttrText( itemtype => itemtype,
1041: itemkey => itemkey,
1042: aname => 'APPROVER_NAME',
1043: avalue => l_receiver_name );
1044: wf_engine.SetItemAttrText( itemtype => itemtype,

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

1040: wf_engine.SetItemAttrText( itemtype => itemtype,
1041: itemkey => itemkey,
1042: aname => 'APPROVER_NAME',
1043: avalue => l_receiver_name );
1044: wf_engine.SetItemAttrText( itemtype => itemtype,
1045: itemkey => itemkey,
1046: aname => 'APPROVER_DISPLAY_NAME',
1047: avalue => l_receiver_display_name );
1048: diagn_msg(l_state_level,'set_approver_name_to_rec','Approver name set for cross charge line ');

Line 1085: l_set_of_books_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1081: IF ( funcmode = 'RUN') THEN
1082:
1083: diagn_msg(l_state_level,'double_timeout','Double_Timeout');
1084:
1085: l_set_of_books_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1086: itemkey => itemkey,
1087: aname => 'SET_OF_BOOKS_ID');
1088:
1089:

Line 1139: l_approver_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1135: BEGIN
1136: IF ( funcmode = 'RUN') THEN
1137:
1138: diagn_msg(l_state_level,'final_approver','Final_Approver');
1139: l_approver_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1140: itemkey => itemkey,
1141: aname => 'APPROVER_ID');
1142: l_approval_amount := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1143: itemkey => itemkey,

Line 1142: l_approval_amount := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1138: diagn_msg(l_state_level,'final_approver','Final_Approver');
1139: l_approver_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1140: itemkey => itemkey,
1141: aname => 'APPROVER_ID');
1142: l_approval_amount := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1143: itemkey => itemkey,
1144: aname => 'CC_LINE_AMOUNT');
1145: l_set_of_books_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1146: itemkey => itemkey,

Line 1145: l_set_of_books_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1141: aname => 'APPROVER_ID');
1142: l_approval_amount := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1143: itemkey => itemkey,
1144: aname => 'CC_LINE_AMOUNT');
1145: l_set_of_books_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1146: itemkey => itemkey,
1147: aname => 'SET_OF_BOOKS_ID');
1148:
1149: l_approval_limit := get_authorization_limit(l_approver_id,

Line 1193: l_approver_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1189: BEGIN
1190: IF ( funcmode = 'RUN') THEN
1191:
1192: diagn_msg(l_state_level,'is_receiver_final_approver','Is Receiver Final_Approver');
1193: l_approver_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1194: itemkey => itemkey,
1195: aname => 'APPROVER_ID');
1196: l_receiver_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1197: itemkey => itemkey,

Line 1196: l_receiver_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1192: diagn_msg(l_state_level,'is_receiver_final_approver','Is Receiver Final_Approver');
1193: l_approver_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1194: itemkey => itemkey,
1195: aname => 'APPROVER_ID');
1196: l_receiver_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1197: itemkey => itemkey,
1198: aname => 'RECEIVER_ID');
1199:
1200: IF (l_receiver_id = l_approver_id) THEN

Line 1243: l_approver_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1239: BEGIN
1240: IF funcmode = 'RUN' THEN
1241:
1242: diagn_msg(l_state_level,'verify_authority','Executing Verify_Authority');
1243: l_approver_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1244: itemkey => itemkey,
1245: aname => 'APPROVER_ID');
1246: l_approval_amount := wf_engine.GetItemAttrNumber( itemtype,
1247: itemkey,

Line 1246: l_approval_amount := wf_engine.GetItemAttrNumber( itemtype,

1242: diagn_msg(l_state_level,'verify_authority','Executing Verify_Authority');
1243: l_approver_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1244: itemkey => itemkey,
1245: aname => 'APPROVER_ID');
1246: l_approval_amount := wf_engine.GetItemAttrNumber( itemtype,
1247: itemkey,
1248: 'CC_LINE_AMOUNT');
1249: l_set_of_books_id := wf_engine.GetItemAttrNumber(
1250: itemtype => itemtype,

Line 1249: l_set_of_books_id := wf_engine.GetItemAttrNumber(

1245: aname => 'APPROVER_ID');
1246: l_approval_amount := wf_engine.GetItemAttrNumber( itemtype,
1247: itemkey,
1248: 'CC_LINE_AMOUNT');
1249: l_set_of_books_id := wf_engine.GetItemAttrNumber(
1250: itemtype => itemtype,
1251: itemkey => itemkey,
1252: aname => 'SET_OF_BOOKS_ID');
1253:

Line 1295: l_cross_charge_id := wf_engine.GetItemAttrNumber(

1291: BEGIN
1292: IF funcmode = 'RUN' THEN
1293: diagn_msg(l_state_level,'approve_cc_line','Executing Approve_CC_line');
1294:
1295: l_cross_charge_id := wf_engine.GetItemAttrNumber(
1296: itemtype => itemtype,
1297: itemkey => itemkey,
1298: aname => 'CROSS_CHARGE_ID' );
1299:

Line 1300: l_cc_line_num := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1296: itemtype => itemtype,
1297: itemkey => itemkey,
1298: aname => 'CROSS_CHARGE_ID' );
1299:
1300: l_cc_line_num := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1301: itemkey => itemkey,
1302: aname => 'CC_LINE_NUM');
1303:
1304: --

Line 1355: l_cross_charge_id := wf_engine.GetItemAttrNumber(

1351: l_cross_charge_id NUMBER;
1352: l_cc_line_num NUMBER;
1353: BEGIN
1354: IF ( funcmode = 'RUN') THEN
1355: l_cross_charge_id := wf_engine.GetItemAttrNumber(
1356: itemtype => itemtype,
1357: itemkey => itemkey,
1358: aname => 'CROSS_CHARGE_ID');
1359:

Line 1360: l_cc_line_num := wf_engine.GetItemAttrNumber(

1356: itemtype => itemtype,
1357: itemkey => itemkey,
1358: aname => 'CROSS_CHARGE_ID');
1359:
1360: l_cc_line_num := wf_engine.GetItemAttrNumber(
1361: itemtype => itemtype,
1362: itemkey => itemkey,
1363: aname => 'CC_LINE_NUM');
1364:

Line 1450: WF_ENGINE.SetItemAttrText( item_type,

1446: diagn_msg(l_state_level,'setpersonas','setpersonas: manager_display_name = ' ||l_manager_display_name );
1447:
1448: IF ( manager_target = 'MANAGER') THEN
1449:
1450: WF_ENGINE.SetItemAttrText( item_type,
1451: item_key,
1452: 'MANAGER_ID',
1453: manager_id);
1454:

Line 1455: WF_ENGINE.SetItemAttrText( item_type,

1451: item_key,
1452: 'MANAGER_ID',
1453: manager_id);
1454:
1455: WF_ENGINE.SetItemAttrText( item_type,
1456: item_key,
1457: 'MANAGER_NAME',
1458: l_manager_name);
1459:

Line 1460: WF_ENGINE.SetItemAttrText( item_type,

1456: item_key,
1457: 'MANAGER_NAME',
1458: l_manager_name);
1459:
1460: WF_ENGINE.SetItemAttrText( item_type,
1461: item_key,
1462: 'MANAGER_DISPLAY_NAME',
1463: l_manager_display_name);
1464:

Line 1467: WF_ENGINE.SetItemAttrText( item_type,

1463: l_manager_display_name);
1464:
1465: ELSE
1466:
1467: WF_ENGINE.SetItemAttrText( item_type,
1468: item_key,
1469: 'APPROVER_ID',
1470: manager_id);
1471:

Line 1472: WF_ENGINE.SetItemAttrText( item_type,

1468: item_key,
1469: 'APPROVER_ID',
1470: manager_id);
1471:
1472: WF_ENGINE.SetItemAttrText( item_type,
1473: item_key,
1474: 'APPROVER_NAME',
1475: l_manager_name);
1476:

Line 1477: WF_ENGINE.SetItemAttrText( item_type,

1473: item_key,
1474: 'APPROVER_NAME',
1475: l_manager_name);
1476:
1477: WF_ENGINE.SetItemAttrText( item_type,
1478: item_key,
1479: 'APPROVER_DISPLAY_NAME',
1480: l_manager_display_name);
1481:

Line 1577: l_set_of_books_id := wf_engine.GetItemAttrNumber(

1573:
1574: l_next_approver_id_old := next_approver_id;
1575:
1576: -- Get set of books id
1577: l_set_of_books_id := wf_engine.GetItemAttrNumber(
1578: itemtype => item_type,
1579: itemkey => item_key,
1580: aname => 'SET_OF_BOOKS_ID');
1581:

Line 1623: wf_engine.SetItemAttrText( item_type,

1619:
1620: IF( l_error_level >= l_debug_level) THEN
1621: FND_LOG.MESSAGE(l_error_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.getapprover.msg1', FALSE);
1622: END IF;
1623: wf_engine.SetItemAttrText( item_type,
1624: item_key,
1625: 'ERROR_MESSAGE',
1626: l_error_message);
1627: return;

Line 1671: l_employee_id := wf_engine.GetItemAttrNumber( item_type,

1667:
1668: IF ( funmode = 'RUN') THEN
1669: diagn_msg(l_state_level,'find_approver','Entering Find_Approver activity');
1670:
1671: l_employee_id := wf_engine.GetItemAttrNumber( item_type,
1672: item_key,
1673: 'EMPLOYEE_ID');
1674:
1675: l_approval_amount := wf_engine.GetItemAttrNumber( item_type,

Line 1675: l_approval_amount := wf_engine.GetItemAttrNumber( item_type,

1671: l_employee_id := wf_engine.GetItemAttrNumber( item_type,
1672: item_key,
1673: 'EMPLOYEE_ID');
1674:
1675: l_approval_amount := wf_engine.GetItemAttrNumber( item_type,
1676: item_key,
1677: 'CC_LINE_AMOUNT');
1678:
1679:

Line 1680: l_curr_approver_id := wf_engine.GetItemAttrNumber( item_type,

1676: item_key,
1677: 'CC_LINE_AMOUNT');
1678:
1679:
1680: l_curr_approver_id := wf_engine.GetItemAttrNumber( item_type,
1681: item_key,
1682: 'APPROVER_ID');
1683:
1684: l_sob_id := wf_engine.GetItemAttrNumber( item_type,

Line 1684: l_sob_id := wf_engine.GetItemAttrNumber( item_type,

1680: l_curr_approver_id := wf_engine.GetItemAttrNumber( item_type,
1681: item_key,
1682: 'APPROVER_ID');
1683:
1684: l_sob_id := wf_engine.GetItemAttrNumber( item_type,
1685: item_key,
1686: 'SET_OF_BOOKS_ID');
1687:
1688:

Line 1700: l_find_approver_counter := wf_engine.GetItemAttrNumber(

1696: IF (l_find_approver_method IS NULL) THEN
1697: l_find_approver_method := 'S';
1698: END IF;
1699:
1700: l_find_approver_counter := wf_engine.GetItemAttrNumber(
1701: item_type,
1702: item_key,
1703: 'FIND_APPROVER_COUNTER');
1704:

Line 1725: wf_engine.SetItemAttrText( item_type,

1721: l_error_message := FND_MESSAGE.Get;
1722: IF( l_error_level >= l_debug_level) THEN
1723: FND_LOG.MESSAGE(l_error_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.getapprover.msg1', FALSE);
1724: END IF;
1725: wf_engine.SetItemAttrText( item_type,
1726: item_key,
1727: 'ERROR_MESSAGE',
1728: l_error_message);
1729:

Line 1757: WF_ENGINE.SetItemAttrText( item_type,

1753: l_error_message := FND_MESSAGE.Get;
1754: IF( l_error_level >= l_debug_level) THEN
1755: FND_LOG.MESSAGE(l_error_level,'igi.plsql.igiitrwb.IGI_ITR_APPROVAL_PKG.getapprover.msg2', FALSE);
1756: END IF;
1757: WF_ENGINE.SetItemAttrText( item_type,
1758: item_key,
1759: 'ERROR_MESSAGE',
1760: l_error_message);
1761:

Line 1771: WF_ENGINE.SetItemAttrNumber( item_type,

1767: item_type,
1768: item_key,
1769: 'APPROVER');
1770:
1771: WF_ENGINE.SetItemAttrNumber( item_type,
1772: item_key,
1773: 'FIND_APPROVER_COUNTER',
1774: l_find_approver_counter+1);
1775:

Line 1817: l_approver_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

1813: BEGIN
1814:
1815: IF (p_funmode = 'RUN') THEN
1816:
1817: l_approver_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
1818: p_item_key,
1819: 'APPROVER_ID');
1820:
1821: l_approver_name := WF_ENGINE.GetItemAttrText(p_item_type,

Line 1821: l_approver_name := WF_ENGINE.GetItemAttrText(p_item_type,

1817: l_approver_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
1818: p_item_key,
1819: 'APPROVER_ID');
1820:
1821: l_approver_name := WF_ENGINE.GetItemAttrText(p_item_type,
1822: p_item_key,
1823: 'APPROVER_NAME');
1824:
1825: l_approver_display_name := WF_ENGINE.GetItemAttrText(p_item_type,

Line 1825: l_approver_display_name := WF_ENGINE.GetItemAttrText(p_item_type,

1821: l_approver_name := WF_ENGINE.GetItemAttrText(p_item_type,
1822: p_item_key,
1823: 'APPROVER_NAME');
1824:
1825: l_approver_display_name := WF_ENGINE.GetItemAttrText(p_item_type,
1826: p_item_key,
1827: 'APPROVER_DISPLAY_NAME');
1828:
1829: WF_ENGINE.SetItemAttrNumber(p_item_type,

Line 1829: WF_ENGINE.SetItemAttrNumber(p_item_type,

1825: l_approver_display_name := WF_ENGINE.GetItemAttrText(p_item_type,
1826: p_item_key,
1827: 'APPROVER_DISPLAY_NAME');
1828:
1829: WF_ENGINE.SetItemAttrNumber(p_item_type,
1830: p_item_key,
1831: 'FORWARD_FROM_ID',
1832: l_approver_id);
1833:

Line 1834: WF_ENGINE.SetItemAttrText(p_item_type,

1830: p_item_key,
1831: 'FORWARD_FROM_ID',
1832: l_approver_id);
1833:
1834: WF_ENGINE.SetItemAttrText(p_item_type,
1835: p_item_key,
1836: 'FORWARD_FROM_NAME',
1837: l_approver_name);
1838:

Line 1839: WF_ENGINE.SetItemAttrText(p_item_type,

1835: p_item_key,
1836: 'FORWARD_FROM_NAME',
1837: l_approver_name);
1838:
1839: WF_ENGINE.SetItemAttrText(p_item_type,
1840: p_item_key,
1841: 'FORWARD_FROM_DISPLAY_NAME',
1842: l_approver_display_name);
1843:

Line 1879: l_approver_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

1875: BEGIN
1876:
1877: IF (p_funmode = 'RUN') THEN
1878:
1879: l_approver_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
1880: p_item_key,
1881: 'APPROVER_ID');
1882:
1883: l_manager_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

Line 1883: l_manager_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

1879: l_approver_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
1880: p_item_key,
1881: 'APPROVER_ID');
1882:
1883: l_manager_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
1884: p_item_key,
1885: 'MANAGER_ID');
1886:
1887: IF (l_approver_id <> l_manager_id) THEN

Line 1931: l_find_approver_counter := WF_ENGINE.GetItemAttrNumber(p_item_type,

1927: IF (p_funmode = 'RUN') THEN
1928:
1929: diagn_msg(l_state_level,'first_approver','First_Approver: Retrieving Find_Approver_Counter Item Attribute');
1930:
1931: l_find_approver_counter := WF_ENGINE.GetItemAttrNumber(p_item_type,
1932: p_item_key,
1933: 'FIND_APPROVER_COUNTER');
1934:
1935: -- Set the approver comment attribute to null

Line 1936: WF_ENGINE.SetItemAttrText(p_item_type,

1932: p_item_key,
1933: 'FIND_APPROVER_COUNTER');
1934:
1935: -- Set the approver comment attribute to null
1936: WF_ENGINE.SetItemAttrText(p_item_type,
1937: p_item_key,
1938: 'APPROVER_COMMENT',
1939: '');
1940:

Line 1981: l_preparer_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1977: l_preparer_name VARCHAR2(240);
1978: l_preparer_display_name VARCHAR2(240);
1979: BEGIN
1980: IF ( funcmode = 'RUN') THEN
1981: l_preparer_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1982: itemkey => itemkey,
1983: aname => 'PREPARER_ID');
1984: l_preparer_name := wf_engine.GetItemAttrText( itemtype => itemtype,
1985: itemkey => itemkey,

Line 1984: l_preparer_name := wf_engine.GetItemAttrText( itemtype => itemtype,

1980: IF ( funcmode = 'RUN') THEN
1981: l_preparer_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1982: itemkey => itemkey,
1983: aname => 'PREPARER_ID');
1984: l_preparer_name := wf_engine.GetItemAttrText( itemtype => itemtype,
1985: itemkey => itemkey,
1986: aname => 'PREPARER_NAME');
1987: l_preparer_display_name := wf_engine.GetItemAttrText( itemtype => itemtype,
1988: itemkey => itemkey,

Line 1987: l_preparer_display_name := wf_engine.GetItemAttrText( itemtype => itemtype,

1983: aname => 'PREPARER_ID');
1984: l_preparer_name := wf_engine.GetItemAttrText( itemtype => itemtype,
1985: itemkey => itemkey,
1986: aname => 'PREPARER_NAME');
1987: l_preparer_display_name := wf_engine.GetItemAttrText( itemtype => itemtype,
1988: itemkey => itemkey,
1989: aname => 'PREPARER_DISPLAY_NAME');
1990: wf_engine.SetItemAttrNumber( itemtype => itemtype,
1991: itemkey => itemkey,

Line 1990: wf_engine.SetItemAttrNumber( itemtype => itemtype,

1986: aname => 'PREPARER_NAME');
1987: l_preparer_display_name := wf_engine.GetItemAttrText( itemtype => itemtype,
1988: itemkey => itemkey,
1989: aname => 'PREPARER_DISPLAY_NAME');
1990: wf_engine.SetItemAttrNumber( itemtype => itemtype,
1991: itemkey => itemkey,
1992: aname => 'EMPLOYEE_ID',
1993: avalue => l_preparer_id );
1994: wf_engine.SetItemAttrText( itemtype => itemtype,

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

1990: wf_engine.SetItemAttrNumber( itemtype => itemtype,
1991: itemkey => itemkey,
1992: aname => 'EMPLOYEE_ID',
1993: avalue => l_preparer_id );
1994: wf_engine.SetItemAttrText( itemtype => itemtype,
1995: itemkey => itemkey,
1996: aname => 'EMPLOYEE_NAME',
1997: avalue => l_preparer_name );
1998: wf_engine.SetItemAttrText( itemtype => itemtype,

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

1994: wf_engine.SetItemAttrText( itemtype => itemtype,
1995: itemkey => itemkey,
1996: aname => 'EMPLOYEE_NAME',
1997: avalue => l_preparer_name );
1998: wf_engine.SetItemAttrText( itemtype => itemtype,
1999: itemkey => itemkey,
2000: aname => 'EMPLOYEE_DISPLAY_NAME',
2001: avalue => l_preparer_display_name );
2002: diagn_msg(l_state_level,'set_employee_name_to_prep','Employee name set to preparer for cross charge line ');

Line 2035: l_receiver_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

2031: l_receiver_name VARCHAR2(240);
2032: l_receiver_display_name VARCHAR2(240);
2033: BEGIN
2034: IF ( funcmode = 'RUN') THEN
2035: l_receiver_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2036: itemkey => itemkey,
2037: aname => 'RECEIVER_ID');
2038: l_receiver_name := wf_engine.GetItemAttrText( itemtype => itemtype,
2039: itemkey => itemkey,

Line 2038: l_receiver_name := wf_engine.GetItemAttrText( itemtype => itemtype,

2034: IF ( funcmode = 'RUN') THEN
2035: l_receiver_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2036: itemkey => itemkey,
2037: aname => 'RECEIVER_ID');
2038: l_receiver_name := wf_engine.GetItemAttrText( itemtype => itemtype,
2039: itemkey => itemkey,
2040: aname => 'RECEIVER_NAME');
2041: l_receiver_display_name := wf_engine.GetItemAttrText( itemtype => itemtype,
2042: itemkey => itemkey,

Line 2041: l_receiver_display_name := wf_engine.GetItemAttrText( itemtype => itemtype,

2037: aname => 'RECEIVER_ID');
2038: l_receiver_name := wf_engine.GetItemAttrText( itemtype => itemtype,
2039: itemkey => itemkey,
2040: aname => 'RECEIVER_NAME');
2041: l_receiver_display_name := wf_engine.GetItemAttrText( itemtype => itemtype,
2042: itemkey => itemkey,
2043: aname => 'RECEIVER_DISPLAY_NAME');
2044: wf_engine.SetItemAttrNumber( itemtype => itemtype,
2045: itemkey => itemkey,

Line 2044: wf_engine.SetItemAttrNumber( itemtype => itemtype,

2040: aname => 'RECEIVER_NAME');
2041: l_receiver_display_name := wf_engine.GetItemAttrText( itemtype => itemtype,
2042: itemkey => itemkey,
2043: aname => 'RECEIVER_DISPLAY_NAME');
2044: wf_engine.SetItemAttrNumber( itemtype => itemtype,
2045: itemkey => itemkey,
2046: aname => 'EMPLOYEE_ID',
2047: avalue => l_receiver_id );
2048: wf_engine.SetItemAttrText( itemtype => itemtype,

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

2044: wf_engine.SetItemAttrNumber( itemtype => itemtype,
2045: itemkey => itemkey,
2046: aname => 'EMPLOYEE_ID',
2047: avalue => l_receiver_id );
2048: wf_engine.SetItemAttrText( itemtype => itemtype,
2049: itemkey => itemkey,
2050: aname => 'EMPLOYEE_NAME',
2051: avalue => l_receiver_name );
2052: wf_engine.SetItemAttrText( itemtype => itemtype,

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

2048: wf_engine.SetItemAttrText( itemtype => itemtype,
2049: itemkey => itemkey,
2050: aname => 'EMPLOYEE_NAME',
2051: avalue => l_receiver_name );
2052: wf_engine.SetItemAttrText( itemtype => itemtype,
2053: itemkey => itemkey,
2054: aname => 'EMPLOYEE_DISPLAY_NAME',
2055: avalue => l_receiver_display_name );
2056: diagn_msg(l_state_level,'set_employee_name_to_rec','Employee name set to receiver for cross charge line ');

Line 2088: wf_engine.SetItemAttrNumber( itemtype => itemtype,

2084: result OUT NOCOPY VARCHAR2 ) IS
2085: BEGIN
2086: IF ( funcmode = 'RUN') THEN
2087: -- setting manager attributes to null
2088: wf_engine.SetItemAttrNumber( itemtype => itemtype,
2089: itemkey => itemkey,
2090: aname => 'MANAGER_ID',
2091: avalue => '' );
2092: wf_engine.SetItemAttrText( itemtype => itemtype,

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

2088: wf_engine.SetItemAttrNumber( itemtype => itemtype,
2089: itemkey => itemkey,
2090: aname => 'MANAGER_ID',
2091: avalue => '' );
2092: wf_engine.SetItemAttrText( itemtype => itemtype,
2093: itemkey => itemkey,
2094: aname => 'MANAGER_NAME',
2095: avalue => '' );
2096: wf_engine.SetItemAttrText( itemtype => itemtype,

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

2092: wf_engine.SetItemAttrText( itemtype => itemtype,
2093: itemkey => itemkey,
2094: aname => 'MANAGER_NAME',
2095: avalue => '' );
2096: wf_engine.SetItemAttrText( itemtype => itemtype,
2097: itemkey => itemkey,
2098: aname => 'MANAGER_DISPLAY_NAME',
2099: avalue => '' );
2100:

Line 2103: wf_engine.SetItemAttrNumber( itemtype => itemtype,

2099: avalue => '' );
2100:
2101:
2102: -- setting forward_from attributes to null
2103: wf_engine.SetItemAttrNumber( itemtype => itemtype,
2104: itemkey => itemkey,
2105: aname => 'FORWARD_FROM_ID',
2106: avalue => '' );
2107: wf_engine.SetItemAttrText( itemtype => itemtype,

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

2103: wf_engine.SetItemAttrNumber( itemtype => itemtype,
2104: itemkey => itemkey,
2105: aname => 'FORWARD_FROM_ID',
2106: avalue => '' );
2107: wf_engine.SetItemAttrText( itemtype => itemtype,
2108: itemkey => itemkey,
2109: aname => 'FORWARD_FROM_NAME',
2110: avalue => '' );
2111: wf_engine.SetItemAttrText( itemtype => itemtype,

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

2107: wf_engine.SetItemAttrText( itemtype => itemtype,
2108: itemkey => itemkey,
2109: aname => 'FORWARD_FROM_NAME',
2110: avalue => '' );
2111: wf_engine.SetItemAttrText( itemtype => itemtype,
2112: itemkey => itemkey,
2113: aname => 'FORWARD_FROM_DISPLAY_NAME',
2114: avalue => '' );
2115:

Line 2118: wf_engine.SetItemAttrNumber( itemtype => itemtype,

2114: avalue => '' );
2115:
2116:
2117: -- setting approver attributes to null
2118: wf_engine.SetItemAttrNumber( itemtype => itemtype,
2119: itemkey => itemkey,
2120: aname => 'APPROVER_ID',
2121: avalue => '' );
2122: wf_engine.SetItemAttrText( itemtype => itemtype,

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

2118: wf_engine.SetItemAttrNumber( itemtype => itemtype,
2119: itemkey => itemkey,
2120: aname => 'APPROVER_ID',
2121: avalue => '' );
2122: wf_engine.SetItemAttrText( itemtype => itemtype,
2123: itemkey => itemkey,
2124: aname => 'APPROVER_NAME',
2125: avalue => '' );
2126: wf_engine.SetItemAttrText( itemtype => itemtype,

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

2122: wf_engine.SetItemAttrText( itemtype => itemtype,
2123: itemkey => itemkey,
2124: aname => 'APPROVER_NAME',
2125: avalue => '' );
2126: wf_engine.SetItemAttrText( itemtype => itemtype,
2127: itemkey => itemkey,
2128: aname => 'APPROVER_DISPLAY_NAME',
2129: avalue => '' );
2130:

Line 2132: wf_engine.SetItemAttrNumber( itemtype => itemtype,

2128: aname => 'APPROVER_DISPLAY_NAME',
2129: avalue => '' );
2130:
2131: -- setting find approver counter attribute to 0
2132: wf_engine.SetItemAttrNumber( itemtype => itemtype,
2133: itemkey => itemkey,
2134: aname => 'FIND_APPROVER_COUNTER',
2135: avalue => 0 );
2136: