APPS.OE_ORDER_WF_UTIL dependencies on STANDARD

Line 954: RETURN 'STANDARD';

950: END IF;
951:
952: -- Code for Returns
953: IF p_line_rec.line_category_code = 'RETURN' THEN
954: RETURN 'STANDARD';
955: END IF;
956:
957: IF OE_OTA_UTIL.Is_OTA_Line(p_line_rec.order_quantity_uom) THEN
958:

Line 961: --ELSIF ( p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD AND

957: IF OE_OTA_UTIL.Is_OTA_Line(p_line_rec.order_quantity_uom) THEN
958:
959: RETURN 'EDUCATION_ITEM';
960:
961: --ELSIF ( p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD AND
962: -- l_item_rec.replenish_to_order_flag = 'Y') OR
963:
964: -- ## 1820608 ato item under a top pto model should start ato_item flow.
965:

Line 966: ELSIF ( p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR

962: -- l_item_rec.replenish_to_order_flag = 'Y') OR
963:
964: -- ## 1820608 ato item under a top pto model should start ato_item flow.
965:
966: ELSIF ( p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR
967: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION)
968: AND p_line_rec.ato_line_id = p_line_rec.line_id THEN
969: RETURN 'ATO_ITEM';
970:

Line 1002: -- start standard flow.

998:
999:
1000: -- for ato under pto, we want to start ato model flow
1001: -- even if the item_type_code is class. For ato under ato
1002: -- start standard flow.
1003:
1004: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS AND
1005: p_line_rec.ato_line_id IS NOT NULL) THEN
1006:

Line 1018: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD) THEN

1014: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION AND
1015: p_line_rec.ato_line_id IS NOT NULL) THEN
1016:
1017: RETURN 'ATO_OPTION'; --FB bug no 4572207
1018: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD) THEN
1019:
1020: RETURN 'STANDARD';
1021: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE) THEN
1022:

Line 1020: RETURN 'STANDARD';

1016:
1017: RETURN 'ATO_OPTION'; --FB bug no 4572207
1018: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD) THEN
1019:
1020: RETURN 'STANDARD';
1021: ELSIF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE) THEN
1022:
1023: RETURN 'SERVICE';
1024:

Line 3818: l_standard_block varchar2(128) := 'OE_STANDARD_WF.STANDARD_BLOCK';

3814: l_oenh varchar2(8) := 'OENH';
3815: l_oebh varchar2(8) := 'OEBH';
3816: l_oeol varchar2(8) := 'OEOL';
3817: l_oeoh varchar2(8) := 'OEOH';
3818: l_standard_block varchar2(128) := 'OE_STANDARD_WF.STANDARD_BLOCK';
3819: l_eng_notified varchar2(8) := 'NOTIFIED';
3820: l_eng_deferred varchar2(8) := 'DEFERRED';
3821: l_retval VARCHAR2(30);
3822: l_activity VARCHAR2(30);

Line 3848: and act.function = l_standard_block;

3844: and act.name = act2.name)
3845: and upper(s.activity_status) = l_eng_notified
3846: and s.item_type = l_oenh
3847: and s.item_key = p_header_id
3848: and act.function = l_standard_block;
3849:
3850: CURSOR book_eligible IS
3851: SELECT 'Y'
3852: FROM WF_ITEM_ACTIVITY_STATUSES WIAS