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_ACCT_GENERATOR_PKG dependencies on WF_ENGINE

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

93:
94: /* initialize the workflow item attributes */
95:
96: -- Set set of books id attribute
97: wf_engine.SetItemAttrNumber( itemtype => l_itemtype,
98: itemkey => l_itemkey,
99: aname => 'SOB_ID',
100: avalue => p_sob_id );
101: -- diagn_msg(l_state_level,'start_acct_generator_workflow','Attribute SOB_ID set to' ||(p_sob_id));

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

100: avalue => p_sob_id );
101: -- diagn_msg(l_state_level,'start_acct_generator_workflow','Attribute SOB_ID set to' ||(p_sob_id));
102:
103: -- Set chart of accounts id attribute
104: wf_engine.SetItemAttrNumber( itemtype => l_itemtype,
105: itemkey => l_itemkey,
106: aname => 'COA_ID',
107: avalue => p_coa_id );
108: -- diagn_msg('Attribute COA_ID set to' ||(p_coa_id));

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

108: -- diagn_msg('Attribute COA_ID set to' ||(p_coa_id));
109:
110:
111: -- Set code combination level (header or line)
112: wf_engine.SetItemAttrText( itemtype => l_itemtype,
113: itemkey => l_itemkey,
114: aname => 'ACCT_TYPE',
115: avalue => p_acct_type );
116: -- diagn_msg('Attribute ACCT_TYPE set to' ||(p_acct_type));

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

116: -- diagn_msg('Attribute ACCT_TYPE set to' ||(p_acct_type));
117:
118:
119: -- Set charge_center_id (of preparer)
120: wf_engine.SetItemAttrNumber( itemtype => l_itemtype,
121: itemkey => l_itemkey,
122: aname => 'CHARGE_CENTER_ID',
123: avalue => p_charge_center_id );
124: -- diagn_msg('Attribute CHARGE_CENTER_ID set to' ||to_char(p_charge_center_id));

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

123: avalue => p_charge_center_id );
124: -- diagn_msg('Attribute CHARGE_CENTER_ID set to' ||to_char(p_charge_center_id));
125:
126: -- Set charge_service_id
127: wf_engine.SetItemAttrNumber( itemtype => l_itemtype,
128: itemkey => l_itemkey,
129: aname => 'CHARGE_SERVICE_ID',
130: avalue => p_charge_service_id );
131: -- diagn_msg('Attribute CHARGE_SERVICE_ID set to' ||to_char(p_charge_service_id));

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

130: avalue => p_charge_service_id );
131: -- diagn_msg('Attribute CHARGE_SERVICE_ID set to' ||to_char(p_charge_service_id));
132:
133: -- Set cost_center_value (if chosen by preparer)
134: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
135: itemkey => l_itemkey,
136: aname => 'COST_CENTER_VALUE',
137: avalue => p_cost_center_value );
138: -- diagn_msg('Attribute COST_CENTER_VALUE set to' ||p_cost_center_value);

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

137: avalue => p_cost_center_value );
138: -- diagn_msg('Attribute COST_CENTER_VALUE set to' ||p_cost_center_value);
139:
140: -- Set additional_segment_value (if chosen by preparer)
141: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
142: itemkey => l_itemkey,
143: aname => 'ADDITIONAL_SEG_VALUE',
144: avalue => p_additional_seg_value );
145: -- diagn_msg('Attribute ADDITIONAL_SEG_VALUE set to' ||p_additional_seg_value);

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

144: avalue => p_additional_seg_value );
145: -- diagn_msg('Attribute ADDITIONAL_SEG_VALUE set to' ||p_additional_seg_value);
146:
147: -- Set preparer attribute
148: wf_engine.SetItemAttrNumber( itemtype => l_itemtype,
149: itemkey => l_itemkey,
150: aname => 'PREPARER_ID',
151: avalue => p_preparer_id );
152: -- diagn_msg('Attribute PREPARER_ID set to' ||to_char(p_preparer_id));

Line 263: l_acct_type := wf_engine.GetItemAttrText(

259: IF ( funcmode = 'RUN' ) THEN
260:
261: diagn_msg(l_state_level,'account_type','Procedure account type being executed');
262: -- Get acct_type
263: l_acct_type := wf_engine.GetItemAttrText(
264: itemtype => itemtype,
265: itemkey => itemkey,
266: aname => 'ACCT_TYPE');
267:

Line 321: l_charge_center_id := wf_engine.GetItemAttrNumber(

317: IF ( funcmode = 'RUN' ) THEN
318: diagn_msg(l_state_level,'account_type','Procedure fetch_creation_account being executed');
319:
320: -- Get charge center ID for the creator
321: l_charge_center_id := wf_engine.GetItemAttrNumber(
322: itemtype => itemtype,
323: itemkey => itemkey,
324: aname => 'CHARGE_CENTER_ID');
325:

Line 327: l_charge_service_id := wf_engine.GetItemAttrNumber(

323: itemkey => itemkey,
324: aname => 'CHARGE_CENTER_ID');
325:
326: -- Get service type ID chosen by the user
327: l_charge_service_id := wf_engine.GetItemAttrNumber(
328: itemtype => itemtype,
329: itemkey => itemkey,
330: aname => 'CHARGE_SERVICE_ID');
331:

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

344: ' for charge center '||to_char(l_charge_center_id)||
345: ' and charge_service_id '||to_char(l_charge_service_id));
346:
347: -- set workflow attribute
348: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
349: itemkey => itemkey,
350: aname => 'CREATION_CCID',
351: avalue => l_creation_ccid);
352:

Line 406: l_coa_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

402:
403:
404: -- fetch the chart of accounts id to be used for finding the number of
405: -- segments
406: l_coa_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
407: itemkey => itemkey,
408: aname => 'COA_ID');
409:
410: -- diagn_msg('Chart of Accounts Id fetched '||to_char(l_coa_id));

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

420:
421: -- diagn_msg('Number of Segments Fetched :'||to_char(l_no_of_segs));
422:
423: -- set the number of segments workflow attribute
424: wf_engine.SetItemAttrNumber( itemtype => itemtype,
425: itemkey => itemkey,
426: aname => 'NO_OF_SEGS',
427: avalue => l_no_of_segs);
428:

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

431: -- set the loop limit to (number of segments - 1)
432: l_loop_limit := l_no_of_segs - 1;
433:
434: -- set the loop limit workflow attribute
435: wf_engine.SetItemAttrNumber( itemtype => itemtype,
436: itemkey => itemkey,
437: aname => 'LOOP_LIMIT',
438: avalue => l_loop_limit);
439:

Line 480: l_counter := wf_engine.GetItemAttrNumber( itemtype => itemtype,

476: IF ( funcmode = 'RUN') THEN
477: -- diagn_msg('Procedure increase_counter being executed');
478:
479: -- fetch the counter value to be increased
480: l_counter := wf_engine.GetItemAttrNumber( itemtype => itemtype,
481: itemkey => itemkey,
482: aname => 'COUNTER');
483:
484: -- diagn_msg('Counter fetched '||to_char(l_counter));

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

486: -- increase counter value by 1
487: l_counter := l_counter + 1;
488:
489: -- set the counter workflow attribute
490: wf_engine.SetItemAttrNumber( itemtype => itemtype,
491: itemkey => itemkey,
492: aname => 'COUNTER',
493: avalue => l_counter);
494:

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

499:
500: -- diagn_msg('segmenti number set to '||l_segmenti_number);
501:
502: -- set the segment number workflow attribute
503: wf_engine.SetItemAttrText( itemtype => itemtype,
504: itemkey => itemkey,
505: aname => 'SEGMENTI_NUMBER',
506: avalue => l_segmenti_number);
507:

Line 550: l_segmenti_number := wf_engine.GetItemAttrText( itemtype => itemtype,

546: -- diagn_msg('Procedure fetch_segmenti_value being executed');
547:
548: -- get the segment number of the segment we want to find a value
549: -- for (from the workflow attribute 'SEGMENTI_NUMBER')
550: l_segmenti_number := wf_engine.GetItemAttrText( itemtype => itemtype,
551: itemkey => itemkey,
552: aname => 'SEGMENTI_NUMBER');
553:
554: -- diagn_msg('Segment i number fetched '||l_segmenti_number);

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

553:
554: -- diagn_msg('Segment i number fetched '||l_segmenti_number);
555:
556: -- get the id of the preparer
557: l_preparer_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
558: itemkey => itemkey,
559: aname => 'PREPARER_ID');
560:
561: -- diagn_msg('Preparer Id fetched '||l_preparer_id);

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

560:
561: -- diagn_msg('Preparer Id fetched '||l_preparer_id);
562:
563: -- get the set of books id
564: l_set_of_books_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
565: itemkey => itemkey,
566: aname => 'SOB_ID');
567:
568: -- diagn_msg('Set of Books Id fetched '||l_set_of_books_id);

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

587:
588: IF l_segmenti_value is not null THEN
589:
590: -- set segmenti_value workflow attribute
591: wf_engine.SetItemAttrText ( itemtype => itemtype,
592: itemkey => itemkey,
593: aname => 'SEGMENTI_VALUE',
594: avalue => l_segmenti_value );
595: diagn_msg(l_state_level,'fetch_segmenti_value','Attribute SEGMENTI_VALUE set to' ||l_segmenti_value||

Line 646: l_segmenti_number := wf_engine.GetItemAttrText( itemtype => itemtype,

642:
643: -- get the segment number of the segment we want to find the segment name
644: -- for (from the workflow attribute 'SEGMENTI_NUMBER')
645:
646: l_segmenti_number := wf_engine.GetItemAttrText( itemtype => itemtype,
647: itemkey => itemkey,
648: aname => 'SEGMENTI_NUMBER');
649:
650: -- diagn_msg('Segment i number fetched '||l_segmenti_number);

Line 653: l_coa_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

649:
650: -- diagn_msg('Segment i number fetched '||l_segmenti_number);
651:
652: -- get the chart of accounts id (from the workflow attribute)
653: l_coa_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
654: itemkey => itemkey,
655: aname => 'COA_ID');
656:
657: -- diagn_msg('Chart of Accounts Id fetched '||l_coa_id);

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

668:
669: -- diagn_msg('Segment name found = '||l_segmenti_name);
670:
671: -- set the segmenti name workflow attribute
672: wf_engine.SetItemAttrText ( itemtype => itemtype,
673: itemkey => itemkey,
674: aname => 'SEGMENTI_NAME',
675: avalue => l_segmenti_name );
676: diagn_msg(l_state_level,'fetch_segmenti_name','Attribute SEGMENTI_NAME set to' ||l_segmenti_name);

Line 714: l_cost_center_value := wf_engine.GetItemAttrText ( itemtype => itemtype,

710: BEGIN
711: IF ( funcmode = 'RUN') THEN
712:
713: diagn_msg(l_state_level,'cost_center_value_chosen','Procedure cost_center_value_chosen being executed');
714: l_cost_center_value := wf_engine.GetItemAttrText ( itemtype => itemtype,
715: itemkey => itemkey,
716: aname => 'COST_CENTER_VALUE');
717: IF l_cost_center_value is not null THEN
718: diagn_msg(l_state_level,'cost_center_value_chosen','Cost center value has been chosen ');

Line 765: l_additional_seg_value := wf_engine.GetItemAttrText ( itemtype => itemtype,

761:
762: IF ( funcmode = 'RUN') THEN
763: diagn_msg(l_state_level,'Additional_Seg_Value_Chosen','Procedure additional_seg_value_chosen being executed');
764:
765: l_additional_seg_value := wf_engine.GetItemAttrText ( itemtype => itemtype,
766: itemkey => itemkey,
767: aname => 'ADDITIONAL_SEG_VALUE');
768:
769:

Line 819: l_sob_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

815: IF ( funcmode = 'RUN') THEN
816:
817: diagn_msg(l_state_level,'Fetch_Additional_Seg_Name','Procedure fetch_additional_seg_name being executed');
818:
819: l_sob_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
820: itemkey => itemkey,
821: aname => 'SOB_ID');
822:
823:

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

829: FROM igi_itr_charge_setup
830: WHERE set_of_books_id = l_sob_id;
831:
832: -- Set additional_segment_name attribute
833: wf_engine.SetItemAttrText ( itemtype => itemtype,
834: itemkey => itemkey,
835: aname => 'ADDITIONAL_SEG_NAME',
836: avalue => l_additional_seg_name );
837: diagn_msg(l_state_level,'Fetch_Additional_Seg_Name','Attribute ADDITIONAL_SEG_NAME set to' ||l_additional_seg_name);

Line 879: l_charge_center_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

875: IF ( funcmode = 'RUN') THEN
876:
877: diagn_msg(l_state_level,'fetch_service_receiving_acct', 'Procedure fetch_service_receiving_acct being executed');
878:
879: l_charge_center_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
880: itemkey => itemkey,
881: aname => 'CHARGE_CENTER_ID');
882:
883: l_charge_service_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 883: l_charge_service_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

879: l_charge_center_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
880: itemkey => itemkey,
881: aname => 'CHARGE_CENTER_ID');
882:
883: l_charge_service_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
884: itemkey => itemkey,
885: aname => 'CHARGE_SERVICE_ID');
886:
887: -- Fetch receiving ccid for service type

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

893: AND sysdate BETWEEN nvl(serv.start_date,sysdate)
894: AND nvl(serv.end_date,sysdate);
895:
896: -- Set service_type_ccid attribute
897: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
898: itemkey => itemkey,
899: aname => 'SERVICE_TYPE_RECEIVING_CCID',
900: avalue => l_service_receiving_ccid );
901: diagn_msg(l_state_level,'fetch_service_receiving_acct','Attribute SERVICE_TYPE_RECEIVING_CCID set to ' ||l_service_receiving_ccid);