[Home] [Help]
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;
957:
958: FND_MESSAGE.SET_NAME('ONT', 'OE_NO_HOLD_ALL_LINES');
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;
957:
958: FND_MESSAGE.SET_NAME('ONT', 'OE_NO_HOLD_ALL_LINES');
959: FND_MESSAGE.SET_TOKEN('WF_ACT', l_user_activity_name);
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;
995:
996: FND_MESSAGE.SET_NAME('ONT', 'OE_NO_HOLD_FEW_LINES');
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;
995:
996: FND_MESSAGE.SET_NAME('ONT', 'OE_NO_HOLD_FEW_LINES');
997: FND_MESSAGE.SET_TOKEN('WF_ACT', l_user_activity_name);
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;
1251:
1252: FND_MESSAGE.SET_NAME('ONT', 'OE_NO_HOLD_ALL_LINES');
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;
1251:
1252: FND_MESSAGE.SET_NAME('ONT', 'OE_NO_HOLD_ALL_LINES');
1253: FND_MESSAGE.SET_TOKEN('WF_ACT',l_user_activity_name);
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;
1289:
1290: FND_MESSAGE.SET_NAME('ONT', 'OE_NO_HOLD_FEW_LINES');
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;
1289:
1290: FND_MESSAGE.SET_NAME('ONT', 'OE_NO_HOLD_FEW_LINES');
1291: FND_MESSAGE.SET_TOKEN('WF_ACT',l_user_activity_name);
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;
5561:
5562: IF p_order_tbl.COUNT = 1 AND l_count_of_holds_applied = 0 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;
5561:
5562: IF p_order_tbl.COUNT = 1 AND l_count_of_holds_applied = 0 THEN
5563: fnd_message.set_name('ONT', 'OE_NO_HOLD_FOR_ACTIVITY');
5926: END check_system_holds;
5927:
5928: procedure process_apply_holds_lines (
5929: p_num_of_records IN NUMBER
5930: , p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
5931: , p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
5932: , p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE
5933: , p_hold_comment IN OE_HOLD_SOURCES.HOLD_COMMENT%TYPE
5934: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
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')
6109: and lookup_code = l_activity_name;
6110:
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')
6109: and lookup_code = l_activity_name;
6110:
6111: IF p_sel_rec_tbl.COUNT = 1 AND l_count_of_holds_applied = 0
6179:
6180: /*=================================*/
6181: procedure process_apply_holds_orders (
6182: p_num_of_records IN NUMBER
6183: , p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
6184: , p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
6185: , p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE
6186: , p_hold_comment IN OE_HOLD_SOURCES.HOLD_COMMENT%TYPE
6187: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
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')
6342: and lookup_code = l_activity_name;
6343:
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')
6342: and lookup_code = l_activity_name;
6343:
6344: IF p_sel_rec_tbl.COUNT = 1 AND l_count_of_holds_applied = 0
6419: -- called after ER 1373910
6420:
6421: procedure process_release_holds_lines (
6422: p_num_of_records IN NUMBER
6423: , p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
6424: , p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
6425: , p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE
6426: , p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
6427: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
6595: PROCESS_RELEASE_HOLDS_ORDERS
6596: */
6597: procedure process_release_holds_orders (
6598: p_num_of_records IN NUMBER
6599: , p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
6600: , p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
6601: , p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE
6602: , p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
6603: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
7175: */
7176:
7177: procedure process_release_holds_lines (
7178: p_num_of_records IN NUMBER
7179: , p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
7180: , p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
7181: , p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE
7182: , p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
7183: , p_wf_release_action IN VARCHAR2
7384: */
7385:
7386: procedure process_release_holds_orders (
7387: p_num_of_records IN NUMBER
7388: , p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
7389: , p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
7390: , p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE
7391: , p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
7392: , p_wf_release_action IN VARCHAR2
7813: BEGIN
7814: x_return_status := FND_API.G_RET_STS_SUCCESS;
7815:
7816: l_user_id := OE_HOLDS_PVT.get_user_id;
7817: l_org_id := OE_GLOBALS.G_ORG_ID;
7818: if l_org_id IS NULL THEN
7819: OE_GLOBALS.Set_Context;
7820: l_org_id := OE_GLOBALS.G_ORG_ID;
7821: end if;
7815:
7816: l_user_id := OE_HOLDS_PVT.get_user_id;
7817: l_org_id := OE_GLOBALS.G_ORG_ID;
7818: if l_org_id IS NULL THEN
7819: OE_GLOBALS.Set_Context;
7820: l_org_id := OE_GLOBALS.G_ORG_ID;
7821: end if;
7822:
7823: for c_rec IN c_order_holds
7816: l_user_id := OE_HOLDS_PVT.get_user_id;
7817: l_org_id := OE_GLOBALS.G_ORG_ID;
7818: if l_org_id IS NULL THEN
7819: OE_GLOBALS.Set_Context;
7820: l_org_id := OE_GLOBALS.G_ORG_ID;
7821: end if;
7822:
7823: for c_rec IN c_order_holds
7824: loop
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;
8379:
8380: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
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;
8379:
8380: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
8381: fnd_message.set_token('WF_ACT', l_user_activity_name);
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;
8412:
8413: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
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;
8412:
8413: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
8414: fnd_message.set_token('WF_ACT', l_user_activity_name);
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;
8701:
8702: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
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;
8701:
8702: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
8703: fnd_message.set_token('WF_ACT', l_user_activity_name);
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;
8736:
8737: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
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;
8736:
8737: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
8738: fnd_message.set_token('WF_ACT', l_user_activity_name);
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;
8918:
8919: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
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;
8918:
8919: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
8920: fnd_message.set_token('WF_ACT', l_user_activity_name);
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;
8951:
8952: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
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;
8951:
8952: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
8953: fnd_message.set_token('WF_ACT', l_user_activity_name);
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;
9131:
9132: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
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;
9131:
9132: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
9133: fnd_message.set_token('WF_ACT', l_user_activity_name);
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;
9163:
9164: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
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;
9163:
9164: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
9165: fnd_message.set_token('WF_ACT', l_user_activity_name);
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;
9345:
9346: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
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;
9345:
9346: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
9347: fnd_message.set_token('WF_ACT', l_user_activity_name);
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;
9378:
9379: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
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;
9378:
9379: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
9380: fnd_message.set_token('WF_ACT', l_user_activity_name);
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;
9559:
9560: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
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;
9559:
9560: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
9561: fnd_message.set_token('WF_ACT', l_user_activity_name);
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;
9592:
9593: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
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;
9592:
9593: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
9594: fnd_message.set_token('WF_ACT', l_user_activity_name);
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;
9777:
9778: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
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;
9777:
9778: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
9779: fnd_message.set_token('WF_ACT', l_user_activity_name);
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;
9810:
9811: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
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;
9810:
9811: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
9812: fnd_message.set_token('WF_ACT', l_user_activity_name);
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;
10082:
10083: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
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;
10082:
10083: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
10084: fnd_message.set_token('WF_ACT', l_user_activity_name);
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;
10115:
10116: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
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;
10115:
10116: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
10117: fnd_message.set_token('WF_ACT', l_user_activity_name);
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;
10296:
10297: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
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;
10296:
10297: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
10298: fnd_message.set_token('WF_ACT', l_user_activity_name);
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;
10329:
10330: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
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;
10329:
10330: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
10331: fnd_message.set_token('WF_ACT', l_user_activity_name);
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;
10513:
10514: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
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;
10513:
10514: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
10515: fnd_message.set_token('WF_ACT', l_user_activity_name);
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;
10546:
10547: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
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;
10546:
10547: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
10548: fnd_message.set_token('WF_ACT', l_user_activity_name);
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;
10838:
10839: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
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;
10838:
10839: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
10840: fnd_message.set_token('WF_ACT', l_user_activity_name);
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;
10871:
10872: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
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;
10871:
10872: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
10873: fnd_message.set_token('WF_ACT', l_user_activity_name);
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;
11052:
11053: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
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;
11052:
11053: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
11054: fnd_message.set_token('WF_ACT', l_user_activity_name);
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;
11085:
11086: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
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;
11085:
11086: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
11087: fnd_message.set_token('WF_ACT', l_user_activity_name);
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;
11266:
11267: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
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;
11266:
11267: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
11268: fnd_message.set_token('WF_ACT', l_user_activity_name);
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;
11299:
11300: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
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;
11299:
11300: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
11301: fnd_message.set_token('WF_ACT', l_user_activity_name);
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;
11477:
11478: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
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;
11477:
11478: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
11479: fnd_message.set_token('WF_ACT', l_user_activity_name);
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;
11509:
11510: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
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;
11509:
11510: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
11511: fnd_message.set_token('WF_ACT', l_user_activity_name);
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;
11657:
11658: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
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;
11657:
11658: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
11659: fnd_message.set_token('WF_ACT', l_user_activity_name);
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;
11691:
11692: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
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;
11691:
11692: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
11693: fnd_message.set_token('WF_ACT', l_user_activity_name);
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;
11850:
11851: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
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;
11850:
11851: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
11852: fnd_message.set_token('WF_ACT', l_user_activity_name);
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;
11880:
11881: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
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;
11880:
11881: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
11882: fnd_message.set_token('WF_ACT', l_user_activity_name);
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;
12312:
12313: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
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;
12312:
12313: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
12314: fnd_message.set_token('WF_ACT', l_user_activity_name);
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;
12344:
12345: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
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;
12344:
12345: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
12346: fnd_message.set_token('WF_ACT', l_user_activity_name);
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;
12524:
12525: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
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;
12524:
12525: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
12526: fnd_message.set_token('WF_ACT', l_user_activity_name);
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;
12556:
12557: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
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;
12556:
12557: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
12558: fnd_message.set_token('WF_ACT', l_user_activity_name);
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;
12735:
12736: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
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;
12735:
12736: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
12737: fnd_message.set_token('WF_ACT', l_user_activity_name);
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;
12767:
12768: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
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;
12767:
12768: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
12769: fnd_message.set_token('WF_ACT', l_user_activity_name);
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;
12947:
12948: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
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;
12947:
12948: fnd_message.set_name('ONT', 'OE_NO_HOLD_ALL_LINES');
12949: fnd_message.set_token('WF_ACT', l_user_activity_name);
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;
12978:
12979: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
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;
12978:
12979: fnd_message.set_name('ONT', 'OE_NO_HOLD_FEW_LINES');
12980: fnd_message.set_token('WF_ACT', l_user_activity_name);