DBA Data[Home] [Help]

APPS.OE_WF_UPGRADE_UTIL dependencies on OE_GLOBALS

Line 1037: (l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR

1033: FROM OE_ORDER_LINES_ALL
1034: WHERE line_id = to_number(itemkey);
1035:
1036: IF l_ato_line_id = to_number(itemkey) AND
1037: (l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
1038: l_item_type_code = OE_GLOBALS.G_ITEM_CLASS)
1039: THEN
1040: update oe_order_lines_all
1041: set flow_status_code = 'BOOKED'

Line 1038: l_item_type_code = OE_GLOBALS.G_ITEM_CLASS)

1034: WHERE line_id = to_number(itemkey);
1035:
1036: IF l_ato_line_id = to_number(itemkey) AND
1037: (l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
1038: l_item_type_code = OE_GLOBALS.G_ITEM_CLASS)
1039: THEN
1040: update oe_order_lines_all
1041: set flow_status_code = 'BOOKED'
1042: where line_id = to_number(itemkey);

Line 1285: (l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR

1281: FROM oe_order_lines_all
1282: WHERE line_id = to_number(itemkey);
1283:
1284: IF l_ato_line_id = to_number(itemkey) AND
1285: (l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
1286: l_item_type_code = OE_GLOBALS.G_ITEM_CLASS)
1287: THEN
1288: resultout := 'COMPLETE:Y';
1289: ELSE

Line 1286: l_item_type_code = OE_GLOBALS.G_ITEM_CLASS)

1282: WHERE line_id = to_number(itemkey);
1283:
1284: IF l_ato_line_id = to_number(itemkey) AND
1285: (l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
1286: l_item_type_code = OE_GLOBALS.G_ITEM_CLASS)
1287: THEN
1288: resultout := 'COMPLETE:Y';
1289: ELSE
1290: resultout := 'COMPLETE:N';