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 191: from oe_lookups

187: WHERE transaction_type_id = p_hold_entity_id;
188:
189: CURSOR source_type_value_cur IS
190: select meaning
191: from oe_lookups
192: WHERE lookup_code= p_hold_entity_id
193: AND lookup_type = 'SOURCE_TYPE';
194:
195: CURSOR shipping_method_value_cur IS

Line 213: from oe_lookups

209: WHERE salesrep_id = p_hold_entity_id;
210:
211: CURSOR sales_channel_value_cur IS
212: select meaning
213: from oe_lookups
214: WHERE lookup_code= p_hold_entity_id
215: AND lookup_type = 'SALES_CHANNEL';
216:
217: CURSOR project_value_cur IS

Line 1232: FROM oe_lookups

1228: IF l_sql_rowcount = 0 THEN
1229:
1230: SELECT meaning
1231: INTO l_user_activity_name
1232: FROM oe_lookups
1233: WHERE lookup_type = DECODE(p_item_type,
1234: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
1235: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
1236: AND lookup_code = p_activity_name;

Line 1270: FROM oe_lookups

1266: IF l_sql_rowcount < (l_parent_count+l_sql_rowcount) THEN
1267:
1268: SELECT meaning
1269: INTO l_user_activity_name
1270: FROM oe_lookups
1271: WHERE lookup_type = DECODE(p_item_type,
1272: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
1273: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
1274: AND lookup_code = p_activity_name;

Line 1532: FROM oe_lookups

1528: IF l_sql_rowcount = 0 THEN
1529:
1530: SELECT meaning
1531: INTO l_user_activity_name
1532: FROM oe_lookups
1533: WHERE lookup_type = DECODE(p_item_type,
1534: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
1535: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
1536: AND lookup_code = p_activity_name;

Line 1570: FROM oe_lookups

1566: IF l_sql_rowcount < (l_parent_count+l_sql_rowcount) THEN
1567:
1568: SELECT meaning
1569: INTO l_user_activity_name
1570: FROM oe_lookups
1571: WHERE lookup_type = DECODE(p_item_type,
1572: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
1573: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
1574: AND lookup_code = p_activity_name;

Line 2492: FROM oe_lookups

2488: NULL;
2489: ELSIF p_hold_source_rec.hold_entity_code = 'SC' THEN
2490: SELECT 'Valid Entity'
2491: INTO l_dummy
2492: FROM oe_lookups
2493: WHERE lookup_code = p_hold_source_rec.hold_entity_id
2494: AND lookup_type = 'SALES_CHANNEL';
2495: ELSIF p_hold_source_rec.hold_entity_code = 'PT' THEN
2496: SELECT 'Valid Entity'

Line 2642: FROM oe_lookups

2638: WHERE PROJECT_ID = p_hold_source_rec.hold_entity_id2;
2639: ELSIF p_hold_source_rec.hold_entity_code2 = 'SC' THEN
2640: SELECT 'Valid Entity'
2641: INTO l_dummy
2642: FROM oe_lookups
2643: WHERE lookup_code = p_hold_source_rec.hold_entity_id2
2644: AND lookup_type = 'SALES_CHANNEL';
2645: ELSIF p_hold_source_rec.hold_entity_code2 = 'SM' THEN
2646: SELECT 'Valid Entity'

Line 2654: FROM oe_lookups

2650: AND lookup_type = 'SHIP_METHOD';
2651: ELSIF p_hold_source_rec.hold_entity_code2 = 'ST' THEN
2652: SELECT 'Valid Entity'
2653: INTO l_dummy
2654: FROM oe_lookups
2655: WHERE lookup_code = p_hold_source_rec.hold_entity_id2
2656: AND lookup_type = 'SOURCE_TYPE';
2657: ELSIF p_hold_source_rec.hold_entity_code2 = 'T' THEN
2658: SELECT 'Valid Entity'

Line 5425: FROM OE_LOOKUPS

5421: BEGIN
5422:
5423: SELECT 'x'
5424: INTO l_dummy
5425: FROM OE_LOOKUPS
5426: WHERE LOOKUP_TYPE = 'RELEASE_REASON'
5427: AND LOOKUP_CODE = p_hold_release_rec.release_reason_code;
5428:
5429: EXCEPTION

Line 6181: from oe_lookups

6177: end loop;
6178: /*Added the query and IF Condition below for WF_HOLDS ER (bug 6449458)*/
6179: IF l_wf_item_type is not null and l_wf_activity_name is not null THEN
6180: select meaning into l_user_activity_name
6181: from oe_lookups
6182: where lookup_type = DECODE(l_wf_item_type,
6183: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
6184: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
6185: and lookup_code = l_wf_activity_name;

Line 6861: from oe_lookups

6857: END LOOP;
6858: /*Added the Select query and IF Condition below for WF_HOLDS ER (bug 6449458)*/
6859: IF l_item_type IS NOT NULL AND l_activity_name IS NOT NULL THEN
6860: select meaning into l_user_activity_name
6861: from oe_lookups
6862: where lookup_type = DECODE(l_item_type,
6863: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
6864: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES',
6865: '-XX')

Line 7095: from oe_lookups

7091: END LOOP;
7092: /*Added the Select query and IF Condition below for WF_HOLDS ER (bug 6449458)*/
7093: IF l_item_type IS NOT NULL AND l_activity_name IS NOT NULL THEN
7094: select meaning into l_user_activity_name
7095: from oe_lookups
7096: where lookup_type = DECODE(l_item_type,
7097: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
7098: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES',
7099: '-XX')

Line 9238: from oe_lookups

9234: l_sql_rowcount := sql%rowcount;
9235: IF l_sql_rowcount = 0 THEN
9236:
9237: select meaning into l_user_activity_name
9238: from oe_lookups
9239: where lookup_type = DECODE(p_item_type,
9240: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9241: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9242: and lookup_code = p_activity_name;

Line 9271: from oe_lookups

9267:
9268: IF l_sql_rowcount < (l_parent_count+l_sql_rowcount) THEN
9269:
9270: select meaning into l_user_activity_name
9271: from oe_lookups
9272: where lookup_type = DECODE(p_item_type,
9273: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9274: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9275: and lookup_code = p_activity_name;

Line 9560: from oe_lookups

9556: l_sql_rowcount := sql%rowcount;
9557: IF l_sql_rowcount = 0 THEN
9558:
9559: select meaning into l_user_activity_name
9560: from oe_lookups
9561: where lookup_type = DECODE(p_item_type,
9562: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9563: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9564: and lookup_code = p_activity_name;

Line 9595: from oe_lookups

9591:
9592: IF l_sql_rowcount < (l_parent_count+l_sql_rowcount) THEN
9593:
9594: select meaning into l_user_activity_name
9595: from oe_lookups
9596: where lookup_type = DECODE(p_item_type,
9597: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9598: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9599: and lookup_code = p_activity_name;

Line 9777: from oe_lookups

9773: l_sql_rowcount := sql%rowcount;
9774: IF l_sql_rowcount = 0 THEN
9775:
9776: select meaning into l_user_activity_name
9777: from oe_lookups
9778: where lookup_type = DECODE(p_item_type,
9779: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9780: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9781: and lookup_code = p_activity_name;

Line 9810: from oe_lookups

9806:
9807: IF l_sql_rowcount < (l_parent_count+l_sql_rowcount) THEN
9808:
9809: select meaning into l_user_activity_name
9810: from oe_lookups
9811: where lookup_type = DECODE(p_item_type,
9812: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9813: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9814: and lookup_code = p_activity_name;

Line 9990: from oe_lookups

9986: l_sql_rowcount := sql%rowcount;
9987: IF l_sql_rowcount = 0 THEN
9988:
9989: select meaning into l_user_activity_name
9990: from oe_lookups
9991: where lookup_type = DECODE(p_item_type,
9992: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
9993: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
9994: and lookup_code = p_activity_name;

Line 10022: from oe_lookups

10018:
10019: IF l_sql_rowcount < (l_parent_count+l_sql_rowcount) THEN
10020:
10021: select meaning into l_user_activity_name
10022: from oe_lookups
10023: where lookup_type = DECODE(p_item_type,
10024: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10025: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10026: and lookup_code = p_activity_name;

Line 10204: from oe_lookups

10200: l_sql_rowcount := sql%rowcount;
10201: IF l_sql_rowcount = 0 THEN
10202:
10203: select meaning into l_user_activity_name
10204: from oe_lookups
10205: where lookup_type = DECODE(p_item_type,
10206: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10207: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10208: and lookup_code = p_activity_name;

Line 10237: from oe_lookups

10233:
10234: IF l_sql_rowcount < (l_parent_count+l_sql_rowcount) THEN
10235:
10236: select meaning into l_user_activity_name
10237: from oe_lookups
10238: where lookup_type = DECODE(p_item_type,
10239: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10240: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10241: and lookup_code = p_activity_name;

Line 10439: from oe_lookups

10435: l_sql_rowcount := sql%rowcount;
10436: IF l_sql_rowcount = 0 THEN
10437:
10438: select meaning into l_user_activity_name
10439: from oe_lookups
10440: where lookup_type = DECODE(p_item_type,
10441: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10442: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10443: and lookup_code = p_activity_name;

Line 10472: from oe_lookups

10468:
10469: IF l_sql_rowcount < (l_parent_count+l_sql_rowcount) THEN
10470:
10471: select meaning into l_user_activity_name
10472: from oe_lookups
10473: where lookup_type = DECODE(p_item_type,
10474: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10475: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10476: and lookup_code = p_activity_name;

Line 10952: from oe_lookups

10948: l_sql_rowcount := sql%rowcount;
10949: IF l_sql_rowcount = 0 THEN
10950:
10951: select meaning into l_user_activity_name
10952: from oe_lookups
10953: where lookup_type = DECODE(p_item_type,
10954: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10955: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10956: and lookup_code = p_activity_name;

Line 10985: from oe_lookups

10981:
10982: IF l_sql_rowcount < (l_parent_count+l_sql_rowcount) THEN
10983:
10984: select meaning into l_user_activity_name
10985: from oe_lookups
10986: where lookup_type = DECODE(p_item_type,
10987: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
10988: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
10989: and lookup_code = p_activity_name;

Line 11257: from oe_lookups

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

Line 11290: from oe_lookups

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

Line 11471: from oe_lookups

11467: l_sql_rowcount := sql%rowcount;
11468: IF l_sql_rowcount = 0 THEN
11469:
11470: select meaning into l_user_activity_name
11471: from oe_lookups
11472: where lookup_type = DECODE(p_item_type,
11473: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
11474: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11475: 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 11688: from oe_lookups

11684: l_sql_rowcount := sql%rowcount;
11685: IF l_sql_rowcount = 0 THEN
11686:
11687: select meaning into l_user_activity_name
11688: from oe_lookups
11689: where lookup_type = DECODE(p_item_type,
11690: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
11691: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11692: and lookup_code = p_activity_name;

Line 11721: from oe_lookups

11717:
11718: IF l_sql_rowcount < (l_parent_count+l_sql_rowcount) THEN
11719:
11720: select meaning into l_user_activity_name
11721: from oe_lookups
11722: where lookup_type = DECODE(p_item_type,
11723: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
11724: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
11725: and lookup_code = p_activity_name;

Line 12013: from oe_lookups

12009:
12010: IF l_sql_rowcount = 0 THEN
12011:
12012: select meaning into l_user_activity_name
12013: from oe_lookups
12014: where lookup_type = DECODE(p_item_type,
12015: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12016: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12017: and lookup_code = p_activity_name;

Line 12046: from oe_lookups

12042:
12043: IF l_sql_rowcount < (l_parent_count+l_sql_rowcount) THEN
12044:
12045: select meaning into l_user_activity_name
12046: from oe_lookups
12047: where lookup_type = DECODE(p_item_type,
12048: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12049: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12050: and lookup_code = p_activity_name;

Line 12227: from oe_lookups

12223: l_sql_rowcount := sql%rowcount;
12224: IF l_sql_rowcount = 0 THEN
12225:
12226: select meaning into l_user_activity_name
12227: from oe_lookups
12228: where lookup_type = DECODE(p_item_type,
12229: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12230: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12231: and lookup_code = p_activity_name;

Line 12260: from oe_lookups

12256:
12257: IF l_sql_rowcount < (l_parent_count+l_sql_rowcount) THEN
12258:
12259: select meaning into l_user_activity_name
12260: from oe_lookups
12261: where lookup_type = DECODE(p_item_type,
12262: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12263: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12264: and lookup_code = p_activity_name;

Line 12441: from oe_lookups

12437: l_sql_rowcount := sql%rowcount;
12438: IF l_sql_rowcount = 0 THEN
12439:
12440: select meaning into l_user_activity_name
12441: from oe_lookups
12442: where lookup_type = DECODE(p_item_type,
12443: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12444: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12445: and lookup_code = p_activity_name;

Line 12474: from oe_lookups

12470:
12471: IF l_sql_rowcount < (l_parent_count+l_sql_rowcount) THEN
12472:
12473: select meaning into l_user_activity_name
12474: from oe_lookups
12475: where lookup_type = DECODE(p_item_type,
12476: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12477: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12478: and lookup_code = p_activity_name;

Line 12652: from oe_lookups

12648: l_sql_rowcount := sql%rowcount;
12649: IF l_sql_rowcount = 0 THEN
12650:
12651: select meaning into l_user_activity_name
12652: from oe_lookups
12653: where lookup_type = DECODE(p_item_type,
12654: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12655: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12656: and lookup_code = p_activity_name;

Line 12684: from oe_lookups

12680:
12681: IF l_sql_rowcount < (l_parent_count+l_sql_rowcount) THEN
12682:
12683: select meaning into l_user_activity_name
12684: from oe_lookups
12685: where lookup_type = DECODE(p_item_type,
12686: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12687: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12688: and lookup_code = p_activity_name;

Line 12838: from oe_lookups

12834: l_sql_rowcount := sql%rowcount;
12835: IF l_sql_rowcount = 0 THEN
12836:
12837: select meaning into l_user_activity_name
12838: from oe_lookups
12839: where lookup_type = DECODE(p_item_type,
12840: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12841: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12842: and lookup_code = p_activity_name;

Line 12872: from oe_lookups

12868:
12869: IF l_sql_rowcount < (l_parent_count+l_sql_rowcount) THEN
12870:
12871: select meaning into l_user_activity_name
12872: from oe_lookups
12873: where lookup_type = DECODE(p_item_type,
12874: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
12875: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
12876: and lookup_code = p_activity_name;

Line 13095: from oe_lookups

13091: oe_debug_pub.add('l_sql_rowcount - '||l_sql_rowcount);
13092: IF l_sql_rowcount = 0 THEN
13093:
13094: select meaning into l_user_activity_name
13095: from oe_lookups
13096: where lookup_type = DECODE(p_item_type,
13097: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
13098: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
13099: and lookup_code = p_activity_name;

Line 13125: from oe_lookups

13121: oe_debug_pub.add('l_parent_count - '||l_parent_count);
13122: IF l_sql_rowcount < (l_parent_count+l_sql_rowcount) THEN
13123:
13124: select meaning into l_user_activity_name
13125: from oe_lookups
13126: where lookup_type = DECODE(p_item_type,
13127: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
13128: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
13129: and lookup_code = p_activity_name;

Line 13568: from oe_lookups

13564: l_sql_rowcount := sql%rowcount;
13565: IF l_sql_rowcount = 0 THEN
13566:
13567: select meaning into l_user_activity_name
13568: from oe_lookups
13569: where lookup_type = DECODE(p_item_type,
13570: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
13571: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
13572: and lookup_code = p_activity_name;

Line 13600: from oe_lookups

13596:
13597: IF l_sql_rowcount < (l_parent_count+l_sql_rowcount) THEN
13598:
13599: select meaning into l_user_activity_name
13600: from oe_lookups
13601: where lookup_type = DECODE(p_item_type,
13602: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
13603: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
13604: and lookup_code = p_activity_name;

Line 13780: from oe_lookups

13776: l_sql_rowcount := sql%rowcount;
13777: IF l_sql_rowcount = 0 THEN
13778:
13779: select meaning into l_user_activity_name
13780: from oe_lookups
13781: where lookup_type = DECODE(p_item_type,
13782: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
13783: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
13784: and lookup_code = p_activity_name;

Line 13812: from oe_lookups

13808:
13809: IF l_sql_rowcount < (l_parent_count+l_sql_rowcount) THEN
13810:
13811: select meaning into l_user_activity_name
13812: from oe_lookups
13813: where lookup_type = DECODE(p_item_type,
13814: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
13815: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
13816: and lookup_code = p_activity_name;

Line 13991: from oe_lookups

13987: l_sql_rowcount := sql%rowcount;
13988: IF l_sql_rowcount = 0 THEN
13989:
13990: select meaning into l_user_activity_name
13991: from oe_lookups
13992: where lookup_type = DECODE(p_item_type,
13993: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
13994: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
13995: and lookup_code = p_activity_name;

Line 14023: from oe_lookups

14019:
14020: IF l_sql_rowcount < (l_parent_count+l_sql_rowcount) THEN
14021:
14022: select meaning into l_user_activity_name
14023: from oe_lookups
14024: where lookup_type = DECODE(p_item_type,
14025: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
14026: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
14027: and lookup_code = p_activity_name;

Line 14203: from oe_lookups

14199: l_sql_rowcount := sql%rowcount;
14200: IF l_sql_rowcount = 0 THEN
14201:
14202: select meaning into l_user_activity_name
14203: from oe_lookups
14204: where lookup_type = DECODE(p_item_type,
14205: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
14206: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
14207: and lookup_code = p_activity_name;

Line 14234: from oe_lookups

14230:
14231: IF l_sql_rowcount < (l_parent_count+l_sql_rowcount) THEN
14232:
14233: select meaning into l_user_activity_name
14234: from oe_lookups
14235: where lookup_type = DECODE(p_item_type,
14236: OE_GLOBALS.G_WFI_HDR, 'HOLDABLE_HEADER_ACTIVITIES',
14237: OE_GLOBALS.G_WFI_LIN, 'HOLDABLE_LINE_ACTIVITIES', '-XX')
14238: and lookup_code = p_activity_name;