[Home] [Help]
1557:
1558: -- GENESIS --
1559: CURSOR check_hold_type_cur(p_ord_hld_id IN NUMBER) IS
1560: SELECT 'Y'
1561: FROM DUAL
1562: WHERE EXISTS (SELECT NULL
1563: FROM oe_order_holds ooh,
1564: oe_hold_sources ohs,
1565: oe_hold_definitions ohd,
1620: --x_hold_source_id := '';
1621:
1622: SELECT OE_HOLD_RELEASES_S.NEXTVAL
1623: INTO x_hold_release_id
1624: FROM DUAL;
1625: /*Bug3042838 Added nvl condition for insertion into CREATED_BY column */
1626: INSERT INTO OE_HOLD_RELEASES
1627: ( HOLD_RELEASE_ID
1628: , CREATION_DATE
2423: -- Inserting a NEW HOLD SOURCE record
2424:
2425: SELECT OE_HOLD_SOURCES_S.NEXTVAL
2426: INTO x_hold_source_id
2427: FROM DUAL;
2428:
2429: INSERT INTO OE_HOLD_SOURCES_ALL
2430: ( HOLD_SOURCE_ID
2431: , LAST_UPDATE_DATE
2698:
2699:
2700: SELECT OE_HOLD_SOURCES_S.NEXTVAL
2701: INTO x_hold_source_id
2702: FROM DUAL;
2703:
2704: INSERT INTO OE_HOLD_SOURCES_ALL
2705: ( HOLD_SOURCE_ID
2706: , LAST_UPDATE_DATE
2838: l_check_hold VARCHAR2(1) := 'N';
2839:
2840: CURSOR check_line_hold_type_cur(p_line_id IN NUMBER) IS
2841: SELECT 'Y'
2842: FROM DUAL
2843: WHERE EXISTS (SELECT NULL
2844: FROM oe_order_holds ooh,
2845: oe_hold_sources ohs,
2846: oe_hold_definitions ohd,
2855: AND ooh.line_id = p_line_id);
2856:
2857: CURSOR check_hdr_hold_type_cur(p_hdr_id IN NUMBER) IS
2858: SELECT 'Y'
2859: FROM DUAL
2860: WHERE EXISTS (SELECT NULL
2861: FROM oe_order_holds ooh,
2862: oe_hold_sources ohs,
2863: oe_hold_definitions ohd,
2872: AND ooh.header_id = p_hdr_id);
2873:
2874: CURSOR check_src_hold_type_cur(p_hld_src_id IN NUMBER) IS
2875: SELECT 'Y'
2876: FROM DUAL
2877: WHERE EXISTS (SELECT NULL
2878: FROM oe_hold_sources ohs,
2879: oe_hold_definitions ohd
2880: WHERE ohd.activity_name IS NULL
4783: IS
4784: -- GENESIS --
4785: CURSOR check_hold_typ_cur(p_hld_src_id IN NUMBER) IS
4786: SELECT 'Y'
4787: FROM DUAL
4788: WHERE EXISTS (SELECT NULL
4789: FROM oe_hold_sources ohs,
4790: oe_hold_definitions ohd
4791: WHERE ohd.hold_id = ohs.hold_id
4885: END; -- Validate Reason Code
4886:
4887: SELECT OE_HOLD_RELEASES_S.NEXTVAL
4888: INTO x_hold_release_id
4889: FROM DUAL;
4890:
4891: oe_debug_pub.add('Creating OE_HOLD_RELEASES record', 1);
4892: /*Bug3042838 Added nvl condition for insertion into CREATED_BY column */
4893: INSERT INTO OE_HOLD_RELEASES
8060:
8061: /*ER#7479609
8062: CURSOR check_line_hold_type_cur(p_line_id IN NUMBER) IS
8063: SELECT 'Y'
8064: FROM DUAL
8065: WHERE EXISTS (SELECT NULL
8066: FROM oe_order_holds ooh,
8067: oe_hold_sources ohs,
8068: oe_hold_definitions ohd,
8077: AND ooh.line_id = p_line_id);
8078:
8079: CURSOR check_hdr_hold_type_cur(p_hdr_id IN NUMBER) IS
8080: SELECT 'Y'
8081: FROM DUAL
8082: WHERE EXISTS (SELECT NULL
8083: FROM oe_order_holds ooh,
8084: oe_hold_sources ohs,
8085: oe_hold_definitions ohd,
8094: AND ooh.header_id = p_hdr_id);
8095:
8096: CURSOR check_src_hold_type_cur(p_hld_src_id IN NUMBER) IS
8097: SELECT 'Y'
8098: FROM DUAL
8099: WHERE EXISTS (SELECT NULL
8100: FROM oe_hold_sources ohs,
8101: oe_hold_definitions ohd
8102: WHERE ohd.hold_id = ohs.hold_id
8106:
8107: --ER#7479609 start
8108: CURSOR check_line_hold_type_cur(p_line_id IN NUMBER) IS
8109: SELECT 'Y'
8110: FROM DUAL
8111: WHERE EXISTS (SELECT NULL
8112: FROM oe_order_holds_all ooh,
8113: oe_hold_sources_all ohs,
8114: oe_hold_definitions ohd,
8125: AND ooh.line_id = p_line_id);
8126:
8127: CURSOR check_hdr_hold_type_cur(p_hdr_id IN NUMBER) IS
8128: SELECT 'Y'
8129: FROM DUAL
8130: WHERE EXISTS (SELECT NULL
8131: FROM oe_order_holds_all ooh,
8132: oe_hold_sources_all ohs,
8133: oe_hold_definitions ohd,
8144: AND ooh.header_id = p_hdr_id);
8145:
8146: CURSOR check_src_hold_type_cur(p_hld_src_id IN NUMBER) IS
8147: SELECT 'Y'
8148: FROM DUAL
8149: WHERE EXISTS (SELECT NULL
8150: FROM oe_hold_sources_all ohs,
8151: oe_hold_definitions ohd
8152: WHERE ohd.hold_id = ohs.hold_id