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

Line 89: wf_engine.CreateProcess ( ItemType => l_ItemType,

85: FROM psb_workflow_processes
86: WHERE item_key = p_item_key ;
87:
88:
89: wf_engine.CreateProcess ( ItemType => l_ItemType,
90: ItemKey => l_ItemKey,
91: Process => 'SUBMIT_WORKSHEET' );
92:
93: --

Line 96: WF_Engine.SetItemUserKey

92:
93: --
94: -- Set worksheet_id as the Item User Key for the process.
95: --
96: WF_Engine.SetItemUserKey
97: (
98: ItemType => l_ItemType ,
99: ItemKey => l_ItemKey ,
100: UserKey => l_worksheet_id

Line 106: wf_engine.SetItemAttrNumber( ItemType => l_ItemType,

102:
103: --
104: -- Populate item type.
105: --
106: wf_engine.SetItemAttrNumber( ItemType => l_ItemType,
107: ItemKey => l_itemkey,
108: aname => 'WORKSHEET_ID',
109: avalue => l_worksheet_id );
110: --

Line 111: wf_engine.SetItemAttrNumber( ItemType => l_ItemType,

107: ItemKey => l_itemkey,
108: aname => 'WORKSHEET_ID',
109: avalue => l_worksheet_id );
110: --
111: wf_engine.SetItemAttrNumber( ItemType => l_ItemType,
112: ItemKey => l_itemkey,
113: aname => 'LOOP_VISITED_COUNTER',
114: avalue => 0 );
115: --

Line 116: wf_engine.SetItemAttrText( ItemType => l_itemtype,

112: ItemKey => l_itemkey,
113: aname => 'LOOP_VISITED_COUNTER',
114: avalue => 0 );
115: --
116: wf_engine.SetItemAttrText( ItemType => l_itemtype,
117: ItemKey => l_itemkey,
118: aname => 'SUBMITTER_ID',
119: avalue => p_submitter_id );
120:

Line 122: wf_engine.SetItemAttrtext( ItemType => l_ItemType,

118: aname => 'SUBMITTER_ID',
119: avalue => p_submitter_id );
120:
121: /* Bug 2576222 Start */
122: wf_engine.SetItemAttrtext( ItemType => l_ItemType,
123: ItemKey => l_itemkey,
124: aname => 'FROM_ROLE',
125: avalue => g_user_name );
126: /* Bug 2576222 End */

Line 129: wf_engine.SetItemAttrText( ItemType => l_itemtype,

125: avalue => g_user_name );
126: /* Bug 2576222 End */
127:
128: --
129: wf_engine.SetItemAttrText( ItemType => l_itemtype,
130: ItemKey => l_itemkey,
131: aname => 'SUBMITTER_NAME',
132: avalue => p_submitter_name );
133: --

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

130: ItemKey => l_itemkey,
131: aname => 'SUBMITTER_NAME',
132: avalue => p_submitter_name );
133: --
134: wf_engine.SetItemAttrText( ItemType => l_itemtype,
135: ItemKey => l_itemkey,
136: aname => 'OPERATION_TYPE',
137: avalue => p_operation_type );
138: --

Line 139: wf_engine.SetItemAttrText( ItemType => l_itemtype,

135: ItemKey => l_itemkey,
136: aname => 'OPERATION_TYPE',
137: avalue => p_operation_type );
138: --
139: wf_engine.SetItemAttrText( ItemType => l_itemtype,
140: ItemKey => l_itemkey,
141: aname => 'REVIEW_GROUP_FLAG',
142: avalue => p_review_group_flag );
143: --

Line 144: wf_engine.SetItemAttrText( ItemType => l_itemtype,

140: ItemKey => l_itemkey,
141: aname => 'REVIEW_GROUP_FLAG',
142: avalue => p_review_group_flag );
143: --
144: wf_engine.SetItemAttrText( ItemType => l_itemtype,
145: ItemKey => l_itemkey,
146: aname => 'ORIG_SYSTEM',
147: avalue => p_orig_system );
148: --

Line 149: wf_engine.SetItemAttrNumber( ItemType => l_itemtype,

145: ItemKey => l_itemkey,
146: aname => 'ORIG_SYSTEM',
147: avalue => p_orig_system );
148: --
149: wf_engine.SetItemAttrNumber( ItemType => l_itemtype,
150: ItemKey => l_itemkey,
151: aname => 'MERGE_TO_WORKSHEET_ID',
152: avalue => p_merge_to_worksheet_id );
153: --

Line 154: wf_engine.SetItemAttrNumber( ItemType => l_itemtype,

150: ItemKey => l_itemkey,
151: aname => 'MERGE_TO_WORKSHEET_ID',
152: avalue => p_merge_to_worksheet_id );
153: --
154: wf_engine.SetItemAttrNumber( ItemType => l_itemtype,
155: ItemKey => l_itemkey,
156: aname => 'OPERATION_ID',
157: avalue => p_operation_id );
158: --

Line 159: wf_engine.SetItemAttrNumber( ItemType => l_itemtype,

155: ItemKey => l_itemkey,
156: aname => 'OPERATION_ID',
157: avalue => p_operation_id );
158: --
159: wf_engine.SetItemAttrNumber( ItemType => l_itemtype,
160: ItemKey => l_itemkey,
161: aname => 'CONSTRAINT_SET_ID',
162: avalue => p_constraint_set_id );
163: --

Line 175: wf_engine.SetItemAttrText( ItemType => l_itemtype,

171: SELECT comments INTO l_comments
172: FROM psb_ws_submit_comments
173: WHERE operation_id = p_operation_id;
174: --
175: wf_engine.SetItemAttrText( ItemType => l_itemtype,
176: ItemKey => l_itemkey,
177: aname => 'COMMENTS',
178: avalue => l_comments );
179: END IF;

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

181:
182: --
183: -- Start the process
184: --
185: wf_engine.StartProcess ( ItemType => l_ItemType,
186: ItemKey => l_ItemKey );
187:
188: --
189: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 236: l_worksheet_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

232: IF ( funcmode = 'RUN' ) THEN
233: --
234: -- Get worksheet_id item_attribute.
235: --
236: l_worksheet_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
237: itemkey => itemkey,
238: aname => 'WORKSHEET_ID');
239:
240: --

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

248: FROM psb_worksheets_v
249: WHERE worksheet_id = l_worksheet_id;
250:
251: --
252: wf_engine.SetItemAttrText ( itemtype => itemtype,
253: itemkey => itemkey,
254: aname => 'WORKSHEET_NAME',
255: avalue => l_worksheet_name );
256: --

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

253: itemkey => itemkey,
254: aname => 'WORKSHEET_NAME',
255: avalue => l_worksheet_name );
256: --
257: wf_engine.SetItemAttrText ( itemtype => itemtype,
258: itemkey => itemkey,
259: aname => 'BUDGET_GROUP_NAME',
260: avalue => l_budget_group_name );
261: --

Line 319: l_worksheet_id := wf_engine.GetItemAttrNumber

315: IF ( funcmode = 'RUN' ) THEN
316: --
317: -- Get operation_type item_attribute.
318: --
319: l_worksheet_id := wf_engine.GetItemAttrNumber
320: ( itemtype => itemtype,
321: itemkey => itemkey,
322: aname => 'WORKSHEET_ID' );
323:

Line 324: l_operation_type := wf_engine.GetItemAttrText

320: ( itemtype => itemtype,
321: itemkey => itemkey,
322: aname => 'WORKSHEET_ID' );
323:
324: l_operation_type := wf_engine.GetItemAttrText
325: ( itemtype => itemtype,
326: itemkey => itemkey,
327: aname => 'OPERATION_TYPE' );
328: --

Line 402: l_operation_type := wf_engine.GetItemAttrText

398: IF ( funcmode = 'RUN' ) THEN
399: --
400: -- Get operation_type item_attribute.
401: --
402: l_operation_type := wf_engine.GetItemAttrText
403: ( itemtype => itemtype,
404: itemkey => itemkey,
405: aname => 'OPERATION_TYPE' );
406:

Line 471: l_worksheet_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

467: IF ( funcmode = 'RUN' ) THEN
468: --
469: -- Get worksheet_id item_attribute.
470: --
471: l_worksheet_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
472: itemkey => itemkey,
473: aname => 'WORKSHEET_ID');
474:
475: l_operation_type := wf_engine.GetItemAttrText

Line 475: l_operation_type := wf_engine.GetItemAttrText

471: l_worksheet_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
472: itemkey => itemkey,
473: aname => 'WORKSHEET_ID');
474:
475: l_operation_type := wf_engine.GetItemAttrText
476: ( itemtype => itemtype,
477: itemkey => itemkey,
478: aname => 'OPERATION_TYPE' );
479:

Line 483: l_constraint_set_id := wf_engine.GetItemAttrNumber

479:
480: --
481: -- Find constraint_set_id optionally needed for validation.
482: --
483: l_constraint_set_id := wf_engine.GetItemAttrNumber
484: ( itemtype => itemtype,
485: itemkey => itemkey,
486: aname => 'CONSTRAINT_SET_ID' );
487:

Line 579: l_worksheet_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

575: IF ( funcmode = 'RUN' ) THEN
576: --
577: -- Get worksheet_id item_attribute.
578: --
579: l_worksheet_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
580: itemkey => itemkey,
581: aname => 'WORKSHEET_ID');
582: --
583: l_operation_type := wf_engine.GetItemAttrText( itemtype => itemtype,

Line 583: l_operation_type := wf_engine.GetItemAttrText( itemtype => itemtype,

579: l_worksheet_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
580: itemkey => itemkey,
581: aname => 'WORKSHEET_ID');
582: --
583: l_operation_type := wf_engine.GetItemAttrText( itemtype => itemtype,
584: itemkey => itemkey,
585: aname => 'OPERATION_TYPE');
586: --
587: -- Operation_type item attribute determines what operation is to

Line 686: l_worksheet_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

682: IF ( funcmode = 'RUN' ) THEN
683: --
684: -- Get worksheet_id item attribute.
685: --
686: l_worksheet_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
687: itemkey => itemkey,
688: aname => 'WORKSHEET_ID');
689:
690: --

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

711:
712: --
713: -- Set COPY_WORKSHEET_ID item attribute.
714: --
715: wf_engine.SetItemAttrNumber( itemtype => itemtype,
716: itemkey => itemkey,
717: aname => 'COPY_WORKSHEET_ID',
718: avalue => l_new_worksheet_id );
719: --

Line 788: l_worksheet_id := wf_engine.GetItemAttrNumber

784: IF ( funcmode = 'RUN' ) THEN
785: --
786: -- Get worksheet_id item attribute.
787: --
788: l_worksheet_id := wf_engine.GetItemAttrNumber
789: (
790: itemtype => itemtype,
791: itemkey => itemkey,
792: aname => 'WORKSHEET_ID'

Line 795: l_merge_to_worksheet_id := wf_engine.GetItemAttrNumber

791: itemkey => itemkey,
792: aname => 'WORKSHEET_ID'
793: );
794: --
795: l_merge_to_worksheet_id := wf_engine.GetItemAttrNumber
796: (
797: itemtype => itemtype,
798: itemkey => itemkey,
799: aname => 'MERGE_TO_WORKSHEET_ID'

Line 892: l_worksheet_id := wf_engine.GetItemAttrNumber

888: IF ( funcmode = 'RUN' ) THEN
889: --
890: -- Get worksheet_id item attribute.
891: --
892: l_worksheet_id := wf_engine.GetItemAttrNumber
893: ( itemtype => itemtype,
894: itemkey => itemkey,
895: aname => 'WORKSHEET_ID');
896: --

Line 897: g_worksheet_name := wf_engine.GetItemAttrText

893: ( itemtype => itemtype,
894: itemkey => itemkey,
895: aname => 'WORKSHEET_ID');
896: --
897: g_worksheet_name := wf_engine.GetItemAttrText
898: ( itemtype => itemtype,
899: itemkey => itemkey,
900: aname => 'WORKSHEET_NAME');
901: --

Line 902: l_submitter_name := wf_engine.GetItemAttrText

898: ( itemtype => itemtype,
899: itemkey => itemkey,
900: aname => 'WORKSHEET_NAME');
901: --
902: l_submitter_name := wf_engine.GetItemAttrText
903: ( itemtype => itemtype,
904: itemkey => itemkey,
905: aname => 'SUBMITTER_NAME' );
906: --

Line 907: l_operation_type := wf_engine.GetItemAttrText

903: ( itemtype => itemtype,
904: itemkey => itemkey,
905: aname => 'SUBMITTER_NAME' );
906: --
907: l_operation_type := wf_engine.GetItemAttrText
908: ( itemtype => itemtype,
909: itemkey => itemkey,
910: aname => 'OPERATION_TYPE' );
911:

Line 1123: l_worksheet_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1119: IF ( funcmode = 'RUN' ) THEN
1120: --
1121: -- Get worksheet_id item_attribute.
1122: --
1123: l_worksheet_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1124: itemkey => itemkey,
1125: aname => 'WORKSHEET_ID');
1126:
1127: l_operation_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 1127: l_operation_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1123: l_worksheet_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1124: itemkey => itemkey,
1125: aname => 'WORKSHEET_ID');
1126:
1127: l_operation_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1128: itemkey => itemkey,
1129: aname => 'OPERATION_ID');
1130:
1131: -- Check if this is a position worksheet.

Line 1360: l_worksheet_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1356: IF ( funcmode = 'RUN' ) THEN
1357: --
1358: -- Get worksheet_id item_attribute.
1359: --
1360: l_worksheet_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1361: itemkey => itemkey,
1362: aname => 'WORKSHEET_ID');
1363:
1364: l_operation_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 1364: l_operation_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1360: l_worksheet_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1361: itemkey => itemkey,
1362: aname => 'WORKSHEET_ID');
1363:
1364: l_operation_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1365: itemkey => itemkey,
1366: aname => 'OPERATION_ID');
1367: --
1368: -- Setting context for the CALLBACK procedure.

Line 1572: l_review_group_flag := wf_engine.GetItemAttrText

1568: --
1569: -- Get value of l_review_group_flag attribute to find whether Review Group
1570: -- approval is needed or not.
1571: --
1572: l_review_group_flag := wf_engine.GetItemAttrText
1573: ( itemtype => itemtype,
1574: itemkey => itemkey,
1575: aname => 'REVIEW_GROUP_FLAG') ;
1576: --

Line 1646: l_worksheet_id := wf_engine.GetItemAttrNumber

1642: IF ( funcmode = 'RUN' ) THEN
1643: --
1644: -- Get worksheet_id item_attribute.
1645: --
1646: l_worksheet_id := wf_engine.GetItemAttrNumber
1647: ( itemtype => itemtype,
1648: itemkey => itemkey,
1649: aname => 'WORKSHEET_ID'
1650: );

Line 1722: wf_engine.SetItemAttrNumber( ItemType => itemtype,

1718:
1719: /* For testing */
1720: -- l_count := 2 ;
1721:
1722: wf_engine.SetItemAttrNumber( ItemType => itemtype,
1723: ItemKey => itemkey,
1724: aname => 'LOOP_SET_COUNTER',
1725: avalue => l_count );
1726: --

Line 1805: l_loop_visited_counter := wf_engine.GetItemAttrNumber

1801: /* ******
1802: -- Start testing.
1803: l_review_group_approver_name := 'PSBTEST' ;
1804:
1805: l_loop_visited_counter := wf_engine.GetItemAttrNumber
1806: ( itemtype => itemtype,
1807: itemkey => itemkey,
1808: aname => 'LOOP_VISITED_COUNTER'
1809: );

Line 1813: wf_engine.SetItemAttrNumber( ItemType => ItemType,

1809: );
1810:
1811: l_loop_visited_counter := l_loop_visited_counter + 1 ;
1812:
1813: wf_engine.SetItemAttrNumber( ItemType => ItemType,
1814: ItemKey => ItemKey,
1815: aname => 'LOOP_VISITED_COUNTER',
1816: avalue => l_loop_visited_counter );
1817:

Line 1820: wf_engine.SetItemAttrText( ItemType => ItemType,

1816: avalue => l_loop_visited_counter );
1817:
1818: IF l_loop_visited_counter = 1 THEN
1819:
1820: wf_engine.SetItemAttrText( ItemType => ItemType,
1821: ItemKey => ItemKey,
1822: aname => 'APPROVAL_OPTION',
1823: avalue => 'N' );
1824: ELSE

Line 1826: wf_engine.SetItemAttrText( ItemType => ItemType,

1822: aname => 'APPROVAL_OPTION',
1823: avalue => 'N' );
1824: ELSE
1825:
1826: wf_engine.SetItemAttrText( ItemType => ItemType,
1827: ItemKey => ItemKey,
1828: aname => 'APPROVAL_OPTION',
1829: avalue => 'Y' );
1830: END IF ;

Line 1833: wf_engine.SetItemAttrText( ItemType => itemtype,

1829: avalue => 'Y' );
1830: END IF ;
1831:
1832: -- Set approver_name item attribute.
1833: wf_engine.SetItemAttrText( ItemType => itemtype,
1834: ItemKey => itemkey,
1835: aname => 'REVIEW_GROUP_APPROVER_NAME',
1836: avalue => l_review_group_approver_name );
1837:

Line 1849: l_worksheet_id := wf_engine.GetItemAttrNumber

1845: --
1846: -- Get item related attribute values.
1847: --
1848:
1849: l_worksheet_id := wf_engine.GetItemAttrNumber
1850: ( itemtype => itemtype,
1851: itemkey => itemkey,
1852: aname => 'WORKSHEET_ID'
1853: );

Line 1855: l_operation_id := wf_engine.GetItemAttrNumber

1851: itemkey => itemkey,
1852: aname => 'WORKSHEET_ID'
1853: );
1854: --
1855: l_operation_id := wf_engine.GetItemAttrNumber
1856: ( itemtype => itemtype,
1857: itemkey => itemkey,
1858: aname => 'OPERATION_ID'
1859: );

Line 1861: l_loop_visited_counter := wf_engine.GetItemAttrNumber

1857: itemkey => itemkey,
1858: aname => 'OPERATION_ID'
1859: );
1860: --
1861: l_loop_visited_counter := wf_engine.GetItemAttrNumber
1862: ( itemtype => itemtype,
1863: itemkey => itemkey,
1864: aname => 'LOOP_VISITED_COUNTER'
1865: );

Line 1904: wf_engine.SetItemAttrNumber( ItemType => ItemType,

1900: -- Update 'LOOP_VISITED_COUNTER', 'APPROVAL_OPTION' and
1901: -- 'REVIEW_GROUP_NAME' item attributes.
1902: --
1903:
1904: wf_engine.SetItemAttrNumber( ItemType => ItemType,
1905: ItemKey => ItemKey,
1906: aname => 'LOOP_VISITED_COUNTER',
1907: avalue => l_loop_visited_counter );
1908:

Line 1909: wf_engine.SetItemAttrText( ItemType => ItemType,

1905: ItemKey => ItemKey,
1906: aname => 'LOOP_VISITED_COUNTER',
1907: avalue => l_loop_visited_counter );
1908:
1909: wf_engine.SetItemAttrText( ItemType => ItemType,
1910: ItemKey => ItemKey,
1911: aname => 'APPROVAL_OPTION',
1912: avalue => l_approval_option );
1913:

Line 1914: wf_engine.SetItemAttrText( ItemType => ItemType,

1910: ItemKey => ItemKey,
1911: aname => 'APPROVAL_OPTION',
1912: avalue => l_approval_option );
1913:
1914: wf_engine.SetItemAttrText( ItemType => ItemType,
1915: ItemKey => ItemKey,
1916: aname => 'REVIEW_GROUP_NAME',
1917: avalue => l_review_budget_group_name );
1918:

Line 2036: wf_engine.SetItemAttrNumber( ItemType => itemtype,

2032: --
2033: -- Set item attributes related to the new worksheet.
2034: --
2035:
2036: wf_engine.SetItemAttrNumber( ItemType => itemtype,
2037: ItemKey => itemkey,
2038: aname => 'NEW_WORKSHEET_ID' ,
2039: avalue => l_new_worksheet_id );
2040:

Line 2041: wf_engine.SetItemAttrText( ItemType => itemtype,

2037: ItemKey => itemkey,
2038: aname => 'NEW_WORKSHEET_ID' ,
2039: avalue => l_new_worksheet_id );
2040:
2041: wf_engine.SetItemAttrText( ItemType => itemtype,
2042: ItemKey => itemkey,
2043: aname => 'NEW_WORKSHEET_NAME' ,
2044: avalue => l_new_worksheet_name );
2045:

Line 2046: wf_engine.SetItemAttrText( ItemType => itemtype,

2042: ItemKey => itemkey,
2043: aname => 'NEW_WORKSHEET_NAME' ,
2044: avalue => l_new_worksheet_name );
2045:
2046: wf_engine.SetItemAttrText( ItemType => itemtype,
2047: ItemKey => itemkey,
2048: aname => 'REVIEW_GROUP_APPROVER_NAME',
2049: avalue => l_review_group_approver_name );
2050: --

Line 2108: l_new_worksheet_id := wf_engine.GetItemAttrNumber

2104: --
2105: -- Get value of 'NEW_WORKSHEET_ID' attribute to find whether a new
2106: -- worksheet was created or not.
2107: --
2108: l_new_worksheet_id := wf_engine.GetItemAttrNumber
2109: ( itemtype => itemtype,
2110: itemkey => itemkey,
2111: aname => 'NEW_WORKSHEET_ID'
2112: ) ;

Line 2176: l_approval_option := wf_engine.GetItemAttrText

2172: --
2173: -- Get value of 'APPROVAL_OPTION' attribute to find whether Review Group
2174: -- approval is needed or not.
2175: --
2176: l_approval_option := wf_engine.GetItemAttrText
2177: ( itemtype => itemtype,
2178: itemkey => itemkey,
2179: aname => 'APPROVAL_OPTION') ;
2180: --

Line 2241: wf_engine.SetItemAttrText( ItemType => itemtype,

2237: BEGIN
2238:
2239: IF ( funcmode = 'RUN' ) THEN
2240:
2241: wf_engine.SetItemAttrText( ItemType => itemtype,
2242: ItemKey => itemkey,
2243: aname => 'REVIEWED_FLAG',
2244: avalue => 'Y' );
2245:

Line 2301: l_reviewed_flag := wf_engine.GetItemAttrText

2297: IF ( funcmode = 'RUN' ) THEN
2298: --
2299: -- Get reviewed_flag item_attribute.
2300: --
2301: l_reviewed_flag := wf_engine.GetItemAttrText
2302: ( itemtype => itemtype,
2303: itemkey => itemkey,
2304: aname => 'REVIEWED_FLAG' );
2305:

Line 2373: l_worksheet_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

2369: IF ( funcmode = 'RUN' ) THEN
2370: --
2371: -- Get worksheet_id item_attribute.
2372: --
2373: l_worksheet_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2374: itemkey => itemkey,
2375: aname => 'WORKSHEET_ID');
2376: --
2377: l_submitter_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 2377: l_submitter_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

2373: l_worksheet_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2374: itemkey => itemkey,
2375: aname => 'WORKSHEET_ID');
2376: --
2377: l_submitter_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2378: itemkey => itemkey,
2379: aname => 'SUBMITTER_ID');
2380:
2381: --

Line 2492: l_worksheet_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

2488: IF ( funcmode = 'RUN' ) THEN
2489: --
2490: -- Get worksheet_id item_attribute.
2491: --
2492: l_worksheet_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2493: itemkey => itemkey,
2494: aname => 'WORKSHEET_ID');
2495: --
2496: -- Setting context for the CALLBACK procedure.

Line 2503: g_budget_group_name := wf_engine.GetItemAttrText

2499: g_itemtype := itemtype ;
2500: g_itemkey := itemkey ;
2501: g_worksheet_id := l_worksheet_id ;
2502:
2503: g_budget_group_name := wf_engine.GetItemAttrText
2504: ( itemtype => itemtype,
2505: itemkey => itemkey,
2506: aname => 'BUDGET_GROUP_NAME'
2507: );

Line 2509: g_worksheet_name := wf_engine.GetItemAttrText

2505: itemkey => itemkey,
2506: aname => 'BUDGET_GROUP_NAME'
2507: );
2508:
2509: g_worksheet_name := wf_engine.GetItemAttrText
2510: ( itemtype => itemtype,
2511: itemkey => itemkey,
2512: aname => 'WORKSHEET_NAME'
2513: );

Line 2610: l_worksheet_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

2606: IF ( funcmode = 'RUN' ) THEN
2607: --
2608: -- Get worksheet_id item_attribute.
2609: --
2610: l_worksheet_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2611: itemkey => itemkey,
2612: aname => 'WORKSHEET_ID');
2613: --
2614: -- Unfreeze only the current worksheet.

Line 2719: wf_engine.SetItemAttrText( ItemType => g_itemtype,

2715: /*
2716: IF ( command = 'SET' ) THEN
2717: --
2718: IF attr_name = 'REPLY' THEN
2719: wf_engine.SetItemAttrText( ItemType => g_itemtype,
2720: ItemKey => g_itemkey,
2721: aname => 'OPERATION_TYPE',
2722: avalue => 'XXX' );
2723: