447:
448:
449: Cursor l_ship_warehouse_csr Is
450: SELECT SHIP_FROM_ORG_ID
451: FROM OE_BLANKET_HEADERS_ALL
452: WHERE HEADER_ID = P_DOC_ID;
453:
454: BEGIN
455:
878: Cursor l_blanket_amount_range_csr Is
879: SELECT BLANKET_MAX_AMOUNT - BLANKET_MIN_AMOUNT
880: FROM OE_BLANKET_HEADERS_EXT
881: WHERE ORDER_NUMBER = (SELECT ORDER_NUMBER
882: FROM OE_BLANKET_HEADERS_ALL
883: WHERE HEADER_ID = P_DOC_ID);
884:
885: BEGIN
886:
1071: IS
1072:
1073: l_api_name CONSTANT VARCHAR2(30) := 'GET_DFF_SA';
1074:
1075: l_attribute4_val OE_BLANKET_HEADERS_ALL.ATTRIBUTE4%TYPE := NULL;
1076:
1077:
1078: Cursor l_attribute4_val_csr Is
1079: SELECT ATTRIBUTE4
1076:
1077:
1078: Cursor l_attribute4_val_csr Is
1079: SELECT ATTRIBUTE4
1080: FROM OE_BLANKET_HEADERS_ALL
1081: WHERE HEADER_ID = P_DOC_ID;
1082:
1083: Cursor l_flex_value_id_csr(p_flex_value varchar2) is
1084: SELECT flex_value_id