DBA Data[Home] [Help]

APPS.OE_ORDER_WF_UTIL dependencies on STANDARD

Line 1063: RETURN 'STANDARD';

1059:
1060: -- Code for Returns
1061: IF p_line_rec.line_category_code = 'RETURN'
1062: THEN
1063: RETURN 'STANDARD';
1064: END IF;
1065:
1066: IF oe_ota_util.is_ota_line (p_line_rec.order_quantity_uom)
1067: THEN

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

1065:
1066: IF oe_ota_util.is_ota_line (p_line_rec.order_quantity_uom)
1067: THEN
1068: RETURN 'EDUCATION_ITEM';
1069: --ELSIF ( p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD AND
1070: -- l_item_rec.replenish_to_order_flag = 'Y') OR
1071:
1072: -- ## 1820608 ato item under a top pto model should start ato_item flow.
1073: ELSIF ( p_line_rec.item_type_code = oe_globals.g_item_standard

Line 1073: ELSIF ( p_line_rec.item_type_code = oe_globals.g_item_standard

1069: --ELSIF ( p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD AND
1070: -- l_item_rec.replenish_to_order_flag = 'Y') OR
1071:
1072: -- ## 1820608 ato item under a top pto model should start ato_item flow.
1073: ELSIF ( p_line_rec.item_type_code = oe_globals.g_item_standard
1074: OR p_line_rec.item_type_code = oe_globals.g_item_option
1075: OR p_line_rec.item_type_code = oe_globals.g_item_included
1076: ) --9775352
1077: AND p_line_rec.ato_line_id = p_line_rec.line_id

Line 1112: -- start standard flow.

1108: THEN
1109: RETURN 'PTO_OPTION';
1110: -- for ato under pto, we want to start ato model flow
1111: -- even if the item_type_code is class. For ato under ato
1112: -- start standard flow.
1113: ELSIF ( p_line_rec.item_type_code = oe_globals.g_item_class
1114: AND p_line_rec.ato_line_id IS NOT NULL
1115: )
1116: THEN

Line 1128: ELSIF (p_line_rec.item_type_code = oe_globals.g_item_standard)

1124: AND p_line_rec.ato_line_id IS NOT NULL
1125: )
1126: THEN
1127: RETURN 'ATO_OPTION'; --FB bug no 4572207
1128: ELSIF (p_line_rec.item_type_code = oe_globals.g_item_standard)
1129: THEN
1130: RETURN 'STANDARD';
1131: ELSIF (p_line_rec.item_type_code = oe_globals.g_item_service)
1132: THEN

Line 1130: RETURN 'STANDARD';

1126: THEN
1127: RETURN 'ATO_OPTION'; --FB bug no 4572207
1128: ELSIF (p_line_rec.item_type_code = oe_globals.g_item_standard)
1129: THEN
1130: RETURN 'STANDARD';
1131: ELSIF (p_line_rec.item_type_code = oe_globals.g_item_service)
1132: THEN
1133: RETURN 'SERVICE';
1134: ELSE

Line 2199: NVL (oe_standard_wf.g_user_id, fnd_global.user_id),

2195: SET flow_status_code = p_flow_status_code,
2196: last_update_date = SYSDATE,
2197: --last_updated_by = FND_GLOBAL.USER_ID,
2198: last_updated_by =
2199: NVL (oe_standard_wf.g_user_id, fnd_global.user_id),
2200: -- For bug 9386040
2201: last_update_login = fnd_global.login_id,
2202: lock_control = lock_control + 1
2203: WHERE line_id = p_line_id;

Line 4967: l_standard_block VARCHAR2 (128)

4963: l_oenh VARCHAR2 (8) := 'OENH';
4964: l_oebh VARCHAR2 (8) := 'OEBH';
4965: l_oeol VARCHAR2 (8) := 'OEOL';
4966: l_oeoh VARCHAR2 (8) := 'OEOH';
4967: l_standard_block VARCHAR2 (128)
4968: := 'OE_STANDARD_WF.STANDARD_BLOCK';
4969: l_eng_notified VARCHAR2 (8) := 'NOTIFIED';
4970: l_eng_deferred VARCHAR2 (8) := 'DEFERRED';
4971: l_retval VARCHAR2 (30);

Line 4968: := 'OE_STANDARD_WF.STANDARD_BLOCK';

4964: l_oebh VARCHAR2 (8) := 'OEBH';
4965: l_oeol VARCHAR2 (8) := 'OEOL';
4966: l_oeoh VARCHAR2 (8) := 'OEOH';
4967: l_standard_block VARCHAR2 (128)
4968: := 'OE_STANDARD_WF.STANDARD_BLOCK';
4969: l_eng_notified VARCHAR2 (8) := 'NOTIFIED';
4970: l_eng_deferred VARCHAR2 (8) := 'DEFERRED';
4971: l_retval VARCHAR2 (30);
4972: l_activity VARCHAR2 (30);

Line 5001: AND act.FUNCTION = l_standard_block;

4997: AND act.NAME = act2.NAME)
4998: AND UPPER (s.activity_status) = l_eng_notified
4999: AND s.item_type = l_oenh
5000: AND s.item_key = p_header_id
5001: AND act.FUNCTION = l_standard_block;
5002:
5003: CURSOR book_eligible
5004: IS
5005: SELECT 'Y'