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.OE_HOLDS_PVT dependencies on OE_LOOKUPS

Line 34: from oe_lookups

30:
31:
32: CURSOR hold_entity_code_value IS
33: select meaning
34: from oe_lookups
35: where LOOKUP_TYPE = 'HOLD_ENTITY_DESC'
36: and LOOKUP_CODE = p_hold_entity_code
37: and rownum = 1;
38:

Line 137: from oe_lookups

133: WHERE transaction_type_id = p_hold_entity_id;
134:
135: CURSOR source_type_value_cur IS
136: select meaning
137: from oe_lookups
138: WHERE lookup_code= p_hold_entity_id
139: AND lookup_type = 'SOURCE_TYPE';
140:
141: CURSOR shipping_method_value_cur IS

Line 159: from oe_lookups

155: WHERE salesrep_id = p_hold_entity_id;
156:
157: CURSOR sales_channel_value_cur IS
158: select meaning
159: from oe_lookups
160: WHERE lookup_code= p_hold_entity_id
161: AND lookup_type = 'SALES_CHANNEL';
162:
163: CURSOR project_value_cur IS

Line 952: FROM oe_lookups

948: IF l_sql_rowcount = 0 THEN
949:
950: SELECT meaning
951: INTO l_user_activity_name
952: FROM oe_lookups
953: WHERE lookup_type = DECODE(p_item_type,
954: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
955: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
956: AND lookup_code = p_activity_name;

Line 990: FROM oe_lookups

986: IF l_sql_rowcount < (l_parent_count+l_sql_rowcount) THEN
987:
988: SELECT meaning
989: INTO l_user_activity_name
990: FROM oe_lookups
991: WHERE lookup_type = DECODE(p_item_type,
992: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
993: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
994: AND lookup_code = p_activity_name;

Line 1246: FROM oe_lookups

1242: IF l_sql_rowcount = 0 THEN
1243:
1244: SELECT meaning
1245: INTO l_user_activity_name
1246: FROM oe_lookups
1247: WHERE lookup_type = DECODE(p_item_type,
1248: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
1249: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
1250: AND lookup_code = p_activity_name;

Line 1284: FROM oe_lookups

1280: IF l_sql_rowcount < (l_parent_count+l_sql_rowcount) THEN
1281:
1282: SELECT meaning
1283: INTO l_user_activity_name
1284: FROM oe_lookups
1285: WHERE lookup_type = DECODE(p_item_type,
1286: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
1287: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
1288: AND lookup_code = p_activity_name;

Line 2047: FROM oe_lookups

2043: NULL;
2044: ELSIF p_hold_source_rec.hold_entity_code = 'SC' THEN
2045: SELECT 'Valid Entity'
2046: INTO l_dummy
2047: FROM oe_lookups
2048: WHERE lookup_code = p_hold_source_rec.hold_entity_id
2049: AND lookup_type = 'SALES_CHANNEL';
2050: ELSIF p_hold_source_rec.hold_entity_code = 'PT' THEN
2051: SELECT 'Valid Entity'

Line 2187: FROM oe_lookups

2183: WHERE PROJECT_ID = p_hold_source_rec.hold_entity_id2;
2184: ELSIF p_hold_source_rec.hold_entity_code2 = 'SC' THEN
2185: SELECT 'Valid Entity'
2186: INTO l_dummy
2187: FROM oe_lookups
2188: WHERE lookup_code = p_hold_source_rec.hold_entity_id2
2189: AND lookup_type = 'SALES_CHANNEL';
2190: ELSIF p_hold_source_rec.hold_entity_code2 = 'SM' THEN
2191: SELECT 'Valid Entity'

Line 2199: FROM oe_lookups

2195: AND lookup_type = 'SHIP_METHOD';
2196: ELSIF p_hold_source_rec.hold_entity_code2 = 'ST' THEN
2197: SELECT 'Valid Entity'
2198: INTO l_dummy
2199: FROM oe_lookups
2200: WHERE lookup_code = p_hold_source_rec.hold_entity_id2
2201: AND lookup_type = 'SOURCE_TYPE';
2202: ELSIF p_hold_source_rec.hold_entity_code2 = 'T' THEN
2203: SELECT 'Valid Entity'

Line 4870: FROM OE_LOOKUPS

4866: BEGIN
4867:
4868: SELECT 'x'
4869: INTO l_dummy
4870: FROM OE_LOOKUPS
4871: WHERE LOOKUP_TYPE = 'RELEASE_REASON'
4872: AND LOOKUP_CODE = p_hold_release_rec.release_reason_code;
4873:
4874: EXCEPTION

Line 5556: from oe_lookups

5552: end loop;
5553: /*Added the query and IF Condition below for WF_HOLDS ER (bug 6449458)*/
5554: IF l_wf_item_type is not null and l_wf_activity_name is not null THEN
5555: select meaning into l_user_activity_name
5556: from oe_lookups
5557: where lookup_type = DECODE(l_wf_item_type,
5558: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
5559: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
5560: and lookup_code = l_wf_activity_name;

Line 6104: from oe_lookups

6100: END LOOP;
6101: /*Added the Select query and IF Condition below for WF_HOLDS ER (bug 6449458)*/
6102: IF l_item_type IS NOT NULL AND l_activity_name IS NOT NULL THEN
6103: select meaning into l_user_activity_name
6104: from oe_lookups
6105: where lookup_type = DECODE(l_item_type,
6106: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
6107: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES',
6108: '-XX')

Line 6337: from oe_lookups

6333: END LOOP;
6334: /*Added the Select query and IF Condition below for WF_HOLDS ER (bug 6449458)*/
6335: IF l_item_type IS NOT NULL AND l_activity_name IS NOT NULL THEN
6336: select meaning into l_user_activity_name
6337: from oe_lookups
6338: where lookup_type = DECODE(l_item_type,
6339: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
6340: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES',
6341: '-XX')

Line 8374: from oe_lookups

8370: l_sql_rowcount := sql%rowcount;
8371: IF l_sql_rowcount = 0 THEN
8372:
8373: select meaning into l_user_activity_name
8374: from oe_lookups
8375: where lookup_type = DECODE(p_item_type,
8376: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
8377: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
8378: and lookup_code = p_activity_name;

Line 8407: from oe_lookups

8403:
8404: IF l_sql_rowcount < (l_parent_count+l_sql_rowcount) THEN
8405:
8406: select meaning into l_user_activity_name
8407: from oe_lookups
8408: where lookup_type = DECODE(p_item_type,
8409: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
8410: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
8411: and lookup_code = p_activity_name;

Line 8696: from oe_lookups

8692: l_sql_rowcount := sql%rowcount;
8693: IF l_sql_rowcount = 0 THEN
8694:
8695: select meaning into l_user_activity_name
8696: from oe_lookups
8697: where lookup_type = DECODE(p_item_type,
8698: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
8699: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
8700: and lookup_code = p_activity_name;

Line 8731: from oe_lookups

8727:
8728: IF l_sql_rowcount < (l_parent_count+l_sql_rowcount) THEN
8729:
8730: select meaning into l_user_activity_name
8731: from oe_lookups
8732: where lookup_type = DECODE(p_item_type,
8733: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
8734: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
8735: and lookup_code = p_activity_name;

Line 8913: from oe_lookups

8909: l_sql_rowcount := sql%rowcount;
8910: IF l_sql_rowcount = 0 THEN
8911:
8912: select meaning into l_user_activity_name
8913: from oe_lookups
8914: where lookup_type = DECODE(p_item_type,
8915: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
8916: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
8917: and lookup_code = p_activity_name;

Line 8946: from oe_lookups

8942:
8943: IF l_sql_rowcount < (l_parent_count+l_sql_rowcount) THEN
8944:
8945: select meaning into l_user_activity_name
8946: from oe_lookups
8947: where lookup_type = DECODE(p_item_type,
8948: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
8949: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
8950: and lookup_code = p_activity_name;

Line 9126: from oe_lookups

9122: l_sql_rowcount := sql%rowcount;
9123: IF l_sql_rowcount = 0 THEN
9124:
9125: select meaning into l_user_activity_name
9126: from oe_lookups
9127: where lookup_type = DECODE(p_item_type,
9128: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9129: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9130: and lookup_code = p_activity_name;

Line 9158: from oe_lookups

9154:
9155: IF l_sql_rowcount < (l_parent_count+l_sql_rowcount) THEN
9156:
9157: select meaning into l_user_activity_name
9158: from oe_lookups
9159: where lookup_type = DECODE(p_item_type,
9160: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9161: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9162: and lookup_code = p_activity_name;

Line 9340: from oe_lookups

9336: l_sql_rowcount := sql%rowcount;
9337: IF l_sql_rowcount = 0 THEN
9338:
9339: select meaning into l_user_activity_name
9340: from oe_lookups
9341: where lookup_type = DECODE(p_item_type,
9342: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9343: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9344: and lookup_code = p_activity_name;

Line 9373: from oe_lookups

9369:
9370: IF l_sql_rowcount < (l_parent_count+l_sql_rowcount) THEN
9371:
9372: select meaning into l_user_activity_name
9373: from oe_lookups
9374: where lookup_type = DECODE(p_item_type,
9375: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9376: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9377: and lookup_code = p_activity_name;

Line 9554: from oe_lookups

9550: l_sql_rowcount := sql%rowcount;
9551: IF l_sql_rowcount = 0 THEN
9552:
9553: select meaning into l_user_activity_name
9554: from oe_lookups
9555: where lookup_type = DECODE(p_item_type,
9556: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9557: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9558: and lookup_code = p_activity_name;

Line 9587: from oe_lookups

9583:
9584: IF l_sql_rowcount < (l_parent_count+l_sql_rowcount) THEN
9585:
9586: select meaning into l_user_activity_name
9587: from oe_lookups
9588: where lookup_type = DECODE(p_item_type,
9589: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9590: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9591: and lookup_code = p_activity_name;

Line 9772: from oe_lookups

9768: l_sql_rowcount := sql%rowcount;
9769: IF l_sql_rowcount = 0 THEN
9770:
9771: select meaning into l_user_activity_name
9772: from oe_lookups
9773: where lookup_type = DECODE(p_item_type,
9774: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9775: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9776: and lookup_code = p_activity_name;

Line 9805: from oe_lookups

9801:
9802: IF l_sql_rowcount < (l_parent_count+l_sql_rowcount) THEN
9803:
9804: select meaning into l_user_activity_name
9805: from oe_lookups
9806: where lookup_type = DECODE(p_item_type,
9807: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9808: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9809: and lookup_code = p_activity_name;

Line 10077: from oe_lookups

10073: l_sql_rowcount := sql%rowcount;
10074: IF l_sql_rowcount = 0 THEN
10075:
10076: select meaning into l_user_activity_name
10077: from oe_lookups
10078: where lookup_type = DECODE(p_item_type,
10079: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10080: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10081: and lookup_code = p_activity_name;

Line 10110: from oe_lookups

10106:
10107: IF l_sql_rowcount < (l_parent_count+l_sql_rowcount) THEN
10108:
10109: select meaning into l_user_activity_name
10110: from oe_lookups
10111: where lookup_type = DECODE(p_item_type,
10112: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10113: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10114: and lookup_code = p_activity_name;

Line 10291: from oe_lookups

10287: l_sql_rowcount := sql%rowcount;
10288: IF l_sql_rowcount = 0 THEN
10289:
10290: select meaning into l_user_activity_name
10291: from oe_lookups
10292: where lookup_type = DECODE(p_item_type,
10293: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10294: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10295: and lookup_code = p_activity_name;

Line 10324: from oe_lookups

10320:
10321: IF l_sql_rowcount < (l_parent_count+l_sql_rowcount) THEN
10322:
10323: select meaning into l_user_activity_name
10324: from oe_lookups
10325: where lookup_type = DECODE(p_item_type,
10326: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10327: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10328: and lookup_code = p_activity_name;

Line 10508: from oe_lookups

10504: l_sql_rowcount := sql%rowcount;
10505: IF l_sql_rowcount = 0 THEN
10506:
10507: select meaning into l_user_activity_name
10508: from oe_lookups
10509: where lookup_type = DECODE(p_item_type,
10510: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10511: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10512: and lookup_code = p_activity_name;

Line 10541: from oe_lookups

10537:
10538: IF l_sql_rowcount < (l_parent_count+l_sql_rowcount) THEN
10539:
10540: select meaning into l_user_activity_name
10541: from oe_lookups
10542: where lookup_type = DECODE(p_item_type,
10543: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10544: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10545: and lookup_code = p_activity_name;

Line 10833: from oe_lookups

10829:
10830: IF l_sql_rowcount = 0 THEN
10831:
10832: select meaning into l_user_activity_name
10833: from oe_lookups
10834: where lookup_type = DECODE(p_item_type,
10835: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10836: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10837: and lookup_code = p_activity_name;

Line 10866: from oe_lookups

10862:
10863: IF l_sql_rowcount < (l_parent_count+l_sql_rowcount) THEN
10864:
10865: select meaning into l_user_activity_name
10866: from oe_lookups
10867: where lookup_type = DECODE(p_item_type,
10868: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10869: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10870: and lookup_code = p_activity_name;

Line 11047: from oe_lookups

11043: l_sql_rowcount := sql%rowcount;
11044: IF l_sql_rowcount = 0 THEN
11045:
11046: select meaning into l_user_activity_name
11047: from oe_lookups
11048: where lookup_type = DECODE(p_item_type,
11049: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
11050: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11051: and lookup_code = p_activity_name;

Line 11080: from oe_lookups

11076:
11077: IF l_sql_rowcount < (l_parent_count+l_sql_rowcount) THEN
11078:
11079: select meaning into l_user_activity_name
11080: from oe_lookups
11081: where lookup_type = DECODE(p_item_type,
11082: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
11083: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11084: and lookup_code = p_activity_name;

Line 11261: from oe_lookups

11257: l_sql_rowcount := sql%rowcount;
11258: IF l_sql_rowcount = 0 THEN
11259:
11260: select meaning into l_user_activity_name
11261: from oe_lookups
11262: where lookup_type = DECODE(p_item_type,
11263: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
11264: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11265: and lookup_code = p_activity_name;

Line 11294: from oe_lookups

11290:
11291: IF l_sql_rowcount < (l_parent_count+l_sql_rowcount) THEN
11292:
11293: select meaning into l_user_activity_name
11294: from oe_lookups
11295: where lookup_type = DECODE(p_item_type,
11296: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
11297: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11298: and lookup_code = p_activity_name;

Line 11472: from oe_lookups

11468: l_sql_rowcount := sql%rowcount;
11469: IF l_sql_rowcount = 0 THEN
11470:
11471: select meaning into l_user_activity_name
11472: from oe_lookups
11473: where lookup_type = DECODE(p_item_type,
11474: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
11475: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11476: and lookup_code = p_activity_name;

Line 11504: from oe_lookups

11500:
11501: IF l_sql_rowcount < (l_parent_count+l_sql_rowcount) THEN
11502:
11503: select meaning into l_user_activity_name
11504: from oe_lookups
11505: where lookup_type = DECODE(p_item_type,
11506: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
11507: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11508: and lookup_code = p_activity_name;

Line 11652: from oe_lookups

11648: l_sql_rowcount := sql%rowcount;
11649: IF l_sql_rowcount = 0 THEN
11650:
11651: select meaning into l_user_activity_name
11652: from oe_lookups
11653: where lookup_type = DECODE(p_item_type,
11654: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
11655: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11656: and lookup_code = p_activity_name;

Line 11686: from oe_lookups

11682:
11683: IF l_sql_rowcount < (l_parent_count+l_sql_rowcount) THEN
11684:
11685: select meaning into l_user_activity_name
11686: from oe_lookups
11687: where lookup_type = DECODE(p_item_type,
11688: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
11689: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11690: and lookup_code = p_activity_name;

Line 11845: from oe_lookups

11841: oe_debug_pub.add('l_sql_rowcount - '||l_sql_rowcount);
11842: IF l_sql_rowcount = 0 THEN
11843:
11844: select meaning into l_user_activity_name
11845: from oe_lookups
11846: where lookup_type = DECODE(p_item_type,
11847: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
11848: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11849: and lookup_code = p_activity_name;

Line 11875: from oe_lookups

11871: oe_debug_pub.add('l_parent_count - '||l_parent_count);
11872: IF l_sql_rowcount < (l_parent_count+l_sql_rowcount) THEN
11873:
11874: select meaning into l_user_activity_name
11875: from oe_lookups
11876: where lookup_type = DECODE(p_item_type,
11877: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
11878: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11879: and lookup_code = p_activity_name;

Line 12307: from oe_lookups

12303: l_sql_rowcount := sql%rowcount;
12304: IF l_sql_rowcount = 0 THEN
12305:
12306: select meaning into l_user_activity_name
12307: from oe_lookups
12308: where lookup_type = DECODE(p_item_type,
12309: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12310: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12311: and lookup_code = p_activity_name;

Line 12339: from oe_lookups

12335:
12336: IF l_sql_rowcount < (l_parent_count+l_sql_rowcount) THEN
12337:
12338: select meaning into l_user_activity_name
12339: from oe_lookups
12340: where lookup_type = DECODE(p_item_type,
12341: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12342: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12343: and lookup_code = p_activity_name;

Line 12519: from oe_lookups

12515: l_sql_rowcount := sql%rowcount;
12516: IF l_sql_rowcount = 0 THEN
12517:
12518: select meaning into l_user_activity_name
12519: from oe_lookups
12520: where lookup_type = DECODE(p_item_type,
12521: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12522: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12523: and lookup_code = p_activity_name;

Line 12551: from oe_lookups

12547:
12548: IF l_sql_rowcount < (l_parent_count+l_sql_rowcount) THEN
12549:
12550: select meaning into l_user_activity_name
12551: from oe_lookups
12552: where lookup_type = DECODE(p_item_type,
12553: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12554: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12555: and lookup_code = p_activity_name;

Line 12730: from oe_lookups

12726: l_sql_rowcount := sql%rowcount;
12727: IF l_sql_rowcount = 0 THEN
12728:
12729: select meaning into l_user_activity_name
12730: from oe_lookups
12731: where lookup_type = DECODE(p_item_type,
12732: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12733: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12734: and lookup_code = p_activity_name;

Line 12762: from oe_lookups

12758:
12759: IF l_sql_rowcount < (l_parent_count+l_sql_rowcount) THEN
12760:
12761: select meaning into l_user_activity_name
12762: from oe_lookups
12763: where lookup_type = DECODE(p_item_type,
12764: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12765: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12766: and lookup_code = p_activity_name;

Line 12942: from oe_lookups

12938: l_sql_rowcount := sql%rowcount;
12939: IF l_sql_rowcount = 0 THEN
12940:
12941: select meaning into l_user_activity_name
12942: from oe_lookups
12943: where lookup_type = DECODE(p_item_type,
12944: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12945: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12946: and lookup_code = p_activity_name;

Line 12973: from oe_lookups

12969:
12970: IF l_sql_rowcount < (l_parent_count+l_sql_rowcount) THEN
12971:
12972: select meaning into l_user_activity_name
12973: from oe_lookups
12974: where lookup_type = DECODE(p_item_type,
12975: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12976: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12977: and lookup_code = p_activity_name;