[Home] [Help]
1871:
1872: -- GENESIS --
1873: CURSOR check_hold_type_cur(p_ord_hld_id IN NUMBER) IS
1874: SELECT 'Y'
1875: FROM DUAL
1876: WHERE EXISTS (SELECT NULL
1877: FROM oe_order_holds ooh,
1878: oe_hold_sources ohs,
1879: oe_hold_definitions ohd,
1956: --x_hold_source_id := '';
1957:
1958: SELECT OE_HOLD_RELEASES_S.NEXTVAL
1959: INTO x_hold_release_id
1960: FROM DUAL;
1961: /*Bug3042838 Added nvl condition for insertion into CREATED_BY column */
1962: INSERT INTO OE_HOLD_RELEASES
1963: ( HOLD_RELEASE_ID
1964: , CREATION_DATE
2878: -- Inserting a NEW HOLD SOURCE record
2879:
2880: SELECT OE_HOLD_SOURCES_S.NEXTVAL
2881: INTO x_hold_source_id
2882: FROM DUAL;
2883:
2884: INSERT INTO OE_HOLD_SOURCES_ALL
2885: ( HOLD_SOURCE_ID
2886: , LAST_UPDATE_DATE
3153:
3154:
3155: SELECT OE_HOLD_SOURCES_S.NEXTVAL
3156: INTO x_hold_source_id
3157: FROM DUAL;
3158:
3159: INSERT INTO OE_HOLD_SOURCES_ALL
3160: ( HOLD_SOURCE_ID
3161: , LAST_UPDATE_DATE
3293: l_check_hold VARCHAR2(1) := 'N';
3294:
3295: CURSOR check_line_hold_type_cur(p_line_id IN NUMBER) IS
3296: SELECT 'Y'
3297: FROM DUAL
3298: WHERE EXISTS (SELECT NULL
3299: FROM oe_order_holds ooh,
3300: oe_hold_sources ohs,
3301: oe_hold_definitions ohd,
3310: AND ooh.line_id = p_line_id);
3311:
3312: CURSOR check_hdr_hold_type_cur(p_hdr_id IN NUMBER) IS
3313: SELECT 'Y'
3314: FROM DUAL
3315: WHERE EXISTS (SELECT NULL
3316: FROM oe_order_holds ooh,
3317: oe_hold_sources ohs,
3318: oe_hold_definitions ohd,
3327: AND ooh.header_id = p_hdr_id);
3328:
3329: CURSOR check_src_hold_type_cur(p_hld_src_id IN NUMBER) IS
3330: SELECT 'Y'
3331: FROM DUAL
3332: WHERE EXISTS (SELECT NULL
3333: FROM oe_hold_sources ohs,
3334: oe_hold_definitions ohd
3335: WHERE ohd.activity_name IS NULL
5238: IS
5239: -- GENESIS --
5240: CURSOR check_hold_typ_cur(p_hld_src_id IN NUMBER) IS
5241: SELECT 'Y'
5242: FROM DUAL
5243: WHERE EXISTS (SELECT NULL
5244: FROM oe_hold_sources ohs,
5245: oe_hold_definitions ohd
5246: WHERE ohd.hold_id = ohs.hold_id
5440: END; -- Validate Reason Code
5441:
5442: SELECT OE_HOLD_RELEASES_S.NEXTVAL
5443: INTO x_hold_release_id
5444: FROM DUAL;
5445:
5446: oe_debug_pub.add('Creating OE_HOLD_RELEASES record', 1);
5447: /*Bug3042838 Added nvl condition for insertion into CREATED_BY column */
5448: INSERT INTO OE_HOLD_RELEASES
8916:
8917: /*ER#7479609
8918: CURSOR check_line_hold_type_cur(p_line_id IN NUMBER) IS
8919: SELECT 'Y'
8920: FROM DUAL
8921: WHERE EXISTS (SELECT NULL
8922: FROM oe_order_holds ooh,
8923: oe_hold_sources ohs,
8924: oe_hold_definitions ohd,
8933: AND ooh.line_id = p_line_id);
8934:
8935: CURSOR check_hdr_hold_type_cur(p_hdr_id IN NUMBER) IS
8936: SELECT 'Y'
8937: FROM DUAL
8938: WHERE EXISTS (SELECT NULL
8939: FROM oe_order_holds ooh,
8940: oe_hold_sources ohs,
8941: oe_hold_definitions ohd,
8950: AND ooh.header_id = p_hdr_id);
8951:
8952: CURSOR check_src_hold_type_cur(p_hld_src_id IN NUMBER) IS
8953: SELECT 'Y'
8954: FROM DUAL
8955: WHERE EXISTS (SELECT NULL
8956: FROM oe_hold_sources ohs,
8957: oe_hold_definitions ohd
8958: WHERE ohd.hold_id = ohs.hold_id
8962:
8963: --ER#7479609 start
8964: CURSOR check_line_hold_type_cur(p_line_id IN NUMBER) IS
8965: SELECT 'Y'
8966: FROM DUAL
8967: WHERE EXISTS (SELECT NULL
8968: FROM oe_order_holds_all ooh,
8969: oe_hold_sources_all ohs,
8970: oe_hold_definitions ohd,
8981: AND ooh.line_id = p_line_id);
8982:
8983: CURSOR check_hdr_hold_type_cur(p_hdr_id IN NUMBER) IS
8984: SELECT 'Y'
8985: FROM DUAL
8986: WHERE EXISTS (SELECT NULL
8987: FROM oe_order_holds_all ooh,
8988: oe_hold_sources_all ohs,
8989: oe_hold_definitions ohd,
9000: AND ooh.header_id = p_hdr_id);
9001:
9002: CURSOR check_src_hold_type_cur(p_hld_src_id IN NUMBER) IS
9003: SELECT 'Y'
9004: FROM DUAL
9005: WHERE EXISTS (SELECT NULL
9006: FROM oe_hold_sources_all ohs,
9007: oe_hold_definitions ohd
9008: WHERE ohd.hold_id = ohs.hold_id