eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_HOLDS_PVT dependencies on OE_HOLD_SOURCES

Line 25: p_hold_entity_code IN OE_HOLD_SOURCES_ALL.HOLD_ENTITY_CODE%TYPE

21: /*
22: *
23: */
24: function entity_code_value (
25: p_hold_entity_code IN OE_HOLD_SOURCES_ALL.HOLD_ENTITY_CODE%TYPE
26: )
27: return VARCHAR2
28: IS
29: l_hold_entity_code_value VARCHAR2 (100) := NULL;

Line 119: p_hold_entity_code IN OE_HOLD_SOURCES_ALL.HOLD_ENTITY_CODE%TYPE,

115: END get_user_id;
116:
117:
118: function entity_id_value (
119: p_hold_entity_code IN OE_HOLD_SOURCES_ALL.HOLD_ENTITY_CODE%TYPE,
120: p_hold_entity_id IN OE_HOLD_SOURCES_ALL.HOLD_ENTITY_ID%TYPE )
121: return VARCHAR2
122: IS
123: l_hold_entity_id_value VARCHAR2 (100) := NULL;

Line 120: p_hold_entity_id IN OE_HOLD_SOURCES_ALL.HOLD_ENTITY_ID%TYPE )

116:
117:
118: function entity_id_value (
119: p_hold_entity_code IN OE_HOLD_SOURCES_ALL.HOLD_ENTITY_CODE%TYPE,
120: p_hold_entity_id IN OE_HOLD_SOURCES_ALL.HOLD_ENTITY_ID%TYPE )
121: return VARCHAR2
122: IS
123: l_hold_entity_id_value VARCHAR2 (100) := NULL;
124:

Line 394: p_hold_source_id IN OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE)

390:
391: END entity_id_value;
392: --------------------------
393: function hold_name(
394: p_hold_source_id IN OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE)
395: return varchar2
396: IS
397: l_hold_name oe_hold_definitions.name%type := '';
398: BEGIN

Line 401: from oe_hold_sources hs,

397: l_hold_name oe_hold_definitions.name%type := '';
398: BEGIN
399: select hd.name
400: into l_hold_name
401: from oe_hold_sources hs,
402: oe_hold_definitions hd
403: where hs.HOLD_SOURCE_ID = p_hold_source_id
404: and hs.hold_id = hd.hold_id;
405:

Line 534: oe_hold_sources hs,

530: BEGIN
531: SELECT 'Y'
532: INTO l_release_children
533: FROM oe_order_holds oh,
534: oe_hold_sources hs,
535: oe_hold_definitions hd
536: WHERE hs.hold_source_id = oh.hold_source_id
537: AND hs.hold_id = hd.hold_id
538: AND hd.hold_id = p_hold_id

Line 783: FROM oe_order_holds oh, oe_hold_sources hs

779: CURSOR released_orders_lines
780: IS
781: SELECT NVL(line_id, header_id) entity_id,
782: DECODE(line_id , NULL, 'OEOH', 'OEOL') entity_type
783: FROM oe_order_holds oh, oe_hold_sources hs
784: WHERE hs.hold_source_id = p_hold_source_id
785: AND oh.hold_release_id = hs.hold_release_id
786: AND oh.released_flag = 'Y';
787:

Line 799: FROM oe_hold_definitions hd, oe_hold_sources hs

795: -- Get the activity name on which the hold is defined
796: BEGIN
797: SELECT hd.activity_name
798: INTO l_hold_activity
799: FROM oe_hold_definitions hd, oe_hold_sources hs
800: WHERE hd.hold_id = hs.hold_id
801: AND hs.hold_source_id = p_hold_source_id;
802: EXCEPTION
803: WHEN NO_DATA_FOUND THEN

Line 817: FROM oe_hold_sources

813:
814: BEGIN
815: SELECT hold_entity_code
816: INTO l_hold_entity_code
817: FROM oe_hold_sources
818: WHERE hold_source_id = p_hold_source_id;
819: EXCEPTION
820: WHEN OTHERS THEN
821: Oe_debug_pub.ADD('Source not found.!!');

Line 1039: Procedure InsertTable_OOH_Header (p_hold_source_id OE_HOLD_SOURCES_ALL.hold_source_id%type

1035: -- p_activity_name : Workflow activity name
1036: -- p_activity_status : Workflow activity status
1037: -- p_additional_where_clause : Its derived from the p_item_type and p_activity_name
1038: ---------------------------------------------------------------------------------------------------
1039: Procedure InsertTable_OOH_Header (p_hold_source_id OE_HOLD_SOURCES_ALL.hold_source_id%type
1040: ,p_header_id OE_ORDER_HEADERS_ALL.header_id%type
1041: ,p_org_id OE_ORDER_HEADERS_ALL.org_id%type
1042: ,p_hold_entity_where_clause VARCHAR2
1043: ,p_item_type VARCHAR2

Line 1310: Procedure InsertTable_OOH_Line (p_hold_source_id OE_HOLD_SOURCES_ALL.hold_source_id%type,

1306: -- p_activity_name : Workflow activity name
1307: -- p_activity_status : Workflow activity status
1308: -- p_additional_where_clause : Its derived from the p_item_type and p_activity_name
1309: ---------------------------------------------------------------------------------------------------
1310: Procedure InsertTable_OOH_Line (p_hold_source_id OE_HOLD_SOURCES_ALL.hold_source_id%type,
1311: p_line_id OE_ORDER_LINES_ALL.line_id%type,
1312: p_org_id OE_ORDER_HEADERS_ALL.org_id%type,
1313: p_hold_entity_where_clause VARCHAR2,
1314: p_item_type VARCHAR2,

Line 1862: FROM OE_HOLD_SOURCES HS,

1858: SELECT HS.HOLD_SOURCE_ID,
1859: HS.HOLD_ENTITY_CODE,
1860: hs.hold_id,
1861: oh.order_hold_id
1862: FROM OE_HOLD_SOURCES HS,
1863: OE_ORDER_HOLDS oh
1864: WHERE HS.HOLD_ID = nvl(p_hold_source_rec.hold_id, HS.HOLD_ID)
1865: and hs.hold_entity_code = nvl(p_hold_source_rec.hold_entity_code, hs.hold_entity_code)
1866: and hs.hold_entity_id = nvl(p_hold_source_rec.hold_entity_id, hs.hold_entity_id)

Line 1878: oe_hold_sources ohs,

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,
1880: oe_order_headers_all h,
1881: oe_order_sources oos
1882: WHERE ooh.header_id = h.header_id

Line 1917: l_hold_source_id OE_HOLD_SOURCES.HOLD_SOURCE_ID%TYPE;

1913: -- 16053361
1914:
1915: l_user_id NUMBER;
1916: x_hold_release_id oe_hold_releases.HOLD_RELEASE_ID%type;
1917: l_hold_source_id OE_HOLD_SOURCES.HOLD_SOURCE_ID%TYPE;
1918: x_hold_source_id OE_HOLD_SOURCES.HOLD_SOURCE_ID%TYPE;
1919: l_hold_entity_code OE_HOLD_SOURCES.HOLD_ENTITY_CODE%TYPE;
1920: l_order_hold_id OE_ORDER_HOLDS.ORDER_HOLD_ID%TYPE;
1921: l_hold_id OE_HOLD_DEFINITIONS.hold_id%type;

Line 1918: x_hold_source_id OE_HOLD_SOURCES.HOLD_SOURCE_ID%TYPE;

1914:
1915: l_user_id NUMBER;
1916: x_hold_release_id oe_hold_releases.HOLD_RELEASE_ID%type;
1917: l_hold_source_id OE_HOLD_SOURCES.HOLD_SOURCE_ID%TYPE;
1918: x_hold_source_id OE_HOLD_SOURCES.HOLD_SOURCE_ID%TYPE;
1919: l_hold_entity_code OE_HOLD_SOURCES.HOLD_ENTITY_CODE%TYPE;
1920: l_order_hold_id OE_ORDER_HOLDS.ORDER_HOLD_ID%TYPE;
1921: l_hold_id OE_HOLD_DEFINITIONS.hold_id%type;
1922:

Line 1919: l_hold_entity_code OE_HOLD_SOURCES.HOLD_ENTITY_CODE%TYPE;

1915: l_user_id NUMBER;
1916: x_hold_release_id oe_hold_releases.HOLD_RELEASE_ID%type;
1917: l_hold_source_id OE_HOLD_SOURCES.HOLD_SOURCE_ID%TYPE;
1918: x_hold_source_id OE_HOLD_SOURCES.HOLD_SOURCE_ID%TYPE;
1919: l_hold_entity_code OE_HOLD_SOURCES.HOLD_ENTITY_CODE%TYPE;
1920: l_order_hold_id OE_ORDER_HOLDS.ORDER_HOLD_ID%TYPE;
1921: l_hold_id OE_HOLD_DEFINITIONS.hold_id%type;
1922:
1923: l_hold_source_rec OE_HOLDS_PVT.hold_source_rec_type;

Line 2758: x_hold_source_id OUT NOCOPY /* file.sql.39 change */ OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE,

2754: ---Overload procedure for bug5548778
2755: Procedure Create_Hold_Source (
2756: p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type,
2757: p_org_id IN NUMBER DEFAULT MO_GLOBAL.get_current_org_id, --ER#7479609
2758: x_hold_source_id OUT NOCOPY /* file.sql.39 change */ OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE,
2759: x_hold_exists OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2760: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2761: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
2762: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)

Line 2768: --l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;

2764: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_HOLD_SOURCE';
2765: l_user_id NUMBER;
2766: l_org_id NUMBER;
2767: l_count NUMBER;
2768: --l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;
2769: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
2770: BEGIN
2771: x_return_status := FND_API.G_RET_STS_SUCCESS;
2772: x_hold_exists := 'N';

Line 2790: --ER#7479609 FROM OE_HOLD_SOURCES HS

2786: /* If Line-level hold */
2787: IF p_hold_source_rec.line_id is not null THEN
2788: select count(*)
2789: into l_count
2790: --ER#7479609 FROM OE_HOLD_SOURCES HS
2791: FROM OE_HOLD_SOURCES_ALL HS --ER#7479609
2792: WHERE HS.HOLD_ID = p_hold_source_rec.hold_id
2793: AND HS.HOLD_ENTITY_CODE = p_hold_source_rec.hold_entity_code
2794: AND HS.HOLD_ENTITY_ID = p_hold_source_rec.hold_entity_id

Line 2791: FROM OE_HOLD_SOURCES_ALL HS --ER#7479609

2787: IF p_hold_source_rec.line_id is not null THEN
2788: select count(*)
2789: into l_count
2790: --ER#7479609 FROM OE_HOLD_SOURCES HS
2791: FROM OE_HOLD_SOURCES_ALL HS --ER#7479609
2792: WHERE HS.HOLD_ID = p_hold_source_rec.hold_id
2793: AND HS.HOLD_ENTITY_CODE = p_hold_source_rec.hold_entity_code
2794: AND HS.HOLD_ENTITY_ID = p_hold_source_rec.hold_entity_id
2795: AND HS.HOLD_ENTITY_CODE2 is null

Line 2821: --ER#7479609 FROM OE_HOLD_SOURCES HS

2817: /* If Order Level Hold */
2818: ELSE
2819: select count(*)
2820: into l_count
2821: --ER#7479609 FROM OE_HOLD_SOURCES HS
2822: FROM OE_HOLD_SOURCES_ALL HS --ER#7479609
2823: WHERE HS.HOLD_ID = p_hold_source_rec.hold_id
2824: AND HS.HOLD_ENTITY_CODE = p_hold_source_rec.hold_entity_code
2825: AND HS.HOLD_ENTITY_ID = p_hold_source_rec.hold_entity_id

Line 2822: FROM OE_HOLD_SOURCES_ALL HS --ER#7479609

2818: ELSE
2819: select count(*)
2820: into l_count
2821: --ER#7479609 FROM OE_HOLD_SOURCES HS
2822: FROM OE_HOLD_SOURCES_ALL HS --ER#7479609
2823: WHERE HS.HOLD_ID = p_hold_source_rec.hold_id
2824: AND HS.HOLD_ENTITY_CODE = p_hold_source_rec.hold_entity_code
2825: AND HS.HOLD_ENTITY_ID = p_hold_source_rec.hold_entity_id
2826: AND HS.HOLD_ENTITY_CODE2 is null

Line 2853: --ER#7479609 FROM OE_HOLD_SOURCES HS

2849: END IF; /*If Order Level Hold */
2850: else
2851: select count(*)
2852: into l_count
2853: --ER#7479609 FROM OE_HOLD_SOURCES HS
2854: FROM OE_HOLD_SOURCES_ALL HS --ER#7479609
2855: WHERE HS.HOLD_ID = p_hold_source_rec.hold_id
2856: AND HS.HOLD_ENTITY_CODE = p_hold_source_rec.hold_entity_code
2857: AND HS.HOLD_ENTITY_ID = p_hold_source_rec.hold_entity_id

Line 2854: FROM OE_HOLD_SOURCES_ALL HS --ER#7479609

2850: else
2851: select count(*)
2852: into l_count
2853: --ER#7479609 FROM OE_HOLD_SOURCES HS
2854: FROM OE_HOLD_SOURCES_ALL HS --ER#7479609
2855: WHERE HS.HOLD_ID = p_hold_source_rec.hold_id
2856: AND HS.HOLD_ENTITY_CODE = p_hold_source_rec.hold_entity_code
2857: AND HS.HOLD_ENTITY_ID = p_hold_source_rec.hold_entity_id
2858: AND HS.org_id= p_org_id --ER#7479609

Line 2880: SELECT OE_HOLD_SOURCES_S.NEXTVAL

2876:
2877:
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

Line 2884: INSERT INTO OE_HOLD_SOURCES_ALL

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
2887: , LAST_UPDATED_BY
2888: , CREATION_DATE

Line 3001: x_hold_source_id OUT NOCOPY /* file.sql.39 change */ OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE,

2997: ------
2998: Procedure Create_Hold_Source (
2999: p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type,
3000: p_org_id IN NUMBER DEFAULT MO_GLOBAL.get_current_org_id, --ER#7479609
3001: x_hold_source_id OUT NOCOPY /* file.sql.39 change */ OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE,
3002: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
3003: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
3004: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
3005: IS

Line 3010: --l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;

3006: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_HOLD_SOURCE';
3007: l_user_id NUMBER;
3008: l_org_id NUMBER;
3009: l_count NUMBER;
3010: --l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;
3011: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
3012: l_hold_comment OE_HOLD_SOURCES_ALL.HOLD_COMMENT%TYPE; --ER#7479609
3013: BEGIN
3014: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3012: l_hold_comment OE_HOLD_SOURCES_ALL.HOLD_COMMENT%TYPE; --ER#7479609

3008: l_org_id NUMBER;
3009: l_count NUMBER;
3010: --l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;
3011: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
3012: l_hold_comment OE_HOLD_SOURCES_ALL.HOLD_COMMENT%TYPE; --ER#7479609
3013: BEGIN
3014: x_return_status := FND_API.G_RET_STS_SUCCESS;
3015: l_user_id := OE_HOLDS_PVT.get_user_id;
3016: l_org_id := MO_GLOBAL.get_current_org_id;

Line 3032: --ER#7479609 FROM OE_HOLD_SOURCES HS

3028: /* If Line-level hold */
3029: IF p_hold_source_rec.line_id is not null THEN
3030: select count(*)
3031: into l_count
3032: --ER#7479609 FROM OE_HOLD_SOURCES HS
3033: FROM OE_HOLD_SOURCES_ALL HS --ER#7479609
3034: WHERE HS.HOLD_ID = p_hold_source_rec.hold_id
3035: AND HS.HOLD_ENTITY_CODE = p_hold_source_rec.hold_entity_code
3036: AND HS.HOLD_ENTITY_ID = p_hold_source_rec.hold_entity_id

Line 3033: FROM OE_HOLD_SOURCES_ALL HS --ER#7479609

3029: IF p_hold_source_rec.line_id is not null THEN
3030: select count(*)
3031: into l_count
3032: --ER#7479609 FROM OE_HOLD_SOURCES HS
3033: FROM OE_HOLD_SOURCES_ALL HS --ER#7479609
3034: WHERE HS.HOLD_ID = p_hold_source_rec.hold_id
3035: AND HS.HOLD_ENTITY_CODE = p_hold_source_rec.hold_entity_code
3036: AND HS.HOLD_ENTITY_ID = p_hold_source_rec.hold_entity_id
3037: AND HS.HOLD_ENTITY_CODE2 is null

Line 3061: --ER#7479609 FROM OE_HOLD_SOURCES HS

3057: /* If Order Level Hold */
3058: ELSE
3059: select count(*)
3060: into l_count
3061: --ER#7479609 FROM OE_HOLD_SOURCES HS
3062: FROM OE_HOLD_SOURCES_ALL HS --ER#7479609
3063: WHERE HS.HOLD_ID = p_hold_source_rec.hold_id
3064: AND HS.HOLD_ENTITY_CODE = p_hold_source_rec.hold_entity_code
3065: AND HS.HOLD_ENTITY_ID = p_hold_source_rec.hold_entity_id

Line 3062: FROM OE_HOLD_SOURCES_ALL HS --ER#7479609

3058: ELSE
3059: select count(*)
3060: into l_count
3061: --ER#7479609 FROM OE_HOLD_SOURCES HS
3062: FROM OE_HOLD_SOURCES_ALL HS --ER#7479609
3063: WHERE HS.HOLD_ID = p_hold_source_rec.hold_id
3064: AND HS.HOLD_ENTITY_CODE = p_hold_source_rec.hold_entity_code
3065: AND HS.HOLD_ENTITY_ID = p_hold_source_rec.hold_entity_id
3066: AND HS.HOLD_ENTITY_CODE2 is null

Line 3091: --ER#7479609 FROM OE_HOLD_SOURCES HS

3087: END IF; /*If Order Level Hold */
3088: else
3089: select count(*)
3090: into l_count
3091: --ER#7479609 FROM OE_HOLD_SOURCES HS
3092: FROM OE_HOLD_SOURCES_ALL HS --ER#7479609
3093: WHERE HS.HOLD_ID = p_hold_source_rec.hold_id
3094: AND HS.HOLD_ENTITY_CODE = p_hold_source_rec.hold_entity_code
3095: AND HS.HOLD_ENTITY_ID = p_hold_source_rec.hold_entity_id

Line 3092: FROM OE_HOLD_SOURCES_ALL HS --ER#7479609

3088: else
3089: select count(*)
3090: into l_count
3091: --ER#7479609 FROM OE_HOLD_SOURCES HS
3092: FROM OE_HOLD_SOURCES_ALL HS --ER#7479609
3093: WHERE HS.HOLD_ID = p_hold_source_rec.hold_id
3094: AND HS.HOLD_ENTITY_CODE = p_hold_source_rec.hold_entity_code
3095: AND HS.HOLD_ENTITY_ID = p_hold_source_rec.hold_entity_id
3096: AND nvl(HS.HOLD_ENTITY_CODE2, 'NO_ENTITY_CODE2') =

Line 3127: -- FROM OE_HOLD_SOURCES HS

3123:
3124: -- BEGIN
3125: -- SELECT HOLD_SOURCE_ID
3126: -- INTO l_hold_source_id
3127: -- FROM OE_HOLD_SOURCES HS
3128: -- WHERE HS.HOLD_ID = p_hold_source_rec.hold_id
3129: -- AND HS.HOLD_ENTITY_CODE = p_hold_source_rec.hold_entity_code
3130: -- AND HS.HOLD_ENTITY_ID = p_hold_source_rec.hold_entity_id
3131: -- AND nvl(HS.HOLD_ENTITY_CODE2, 'NO_ENTITY_CODE2') =

Line 3155: SELECT OE_HOLD_SOURCES_S.NEXTVAL

3151:
3152: --ER#7479609 end
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

Line 3159: INSERT INTO OE_HOLD_SOURCES_ALL

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
3162: , LAST_UPDATED_BY
3163: , CREATION_DATE

Line 3300: oe_hold_sources ohs,

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,
3302: oe_order_headers_all h,
3303: oe_order_sources oos
3304: WHERE ohd.activity_name IS NULL

Line 3317: oe_hold_sources ohs,

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,
3319: oe_order_headers_all h,
3320: oe_order_sources oos
3321: WHERE ohd.activity_name IS NULL

Line 3333: FROM oe_hold_sources ohs,

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
3336: AND ohd.hold_id = ohs.hold_id
3337: AND ohs.hold_source_id = p_hld_src_id);

Line 5244: FROM oe_hold_sources ohs,

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
5247: -- AND ohd.activity_name IS NULL Bug 6791587
5248: AND ohs.hold_source_id = p_hld_src_id

Line 5513: oe_debug_pub.add('Updating oe_hold_sources for Release', 1);

5509: );
5510:
5511: -- Flag the hold source as released
5512:
5513: oe_debug_pub.add('Updating oe_hold_sources for Release', 1);
5514: --ER#7479609 UPDATE oe_hold_sources
5515: UPDATE oe_hold_sources_all --ER#7479609
5516: SET hold_release_id = x_hold_release_id
5517: , released_flag = 'Y'

Line 5514: --ER#7479609 UPDATE oe_hold_sources

5510:
5511: -- Flag the hold source as released
5512:
5513: oe_debug_pub.add('Updating oe_hold_sources for Release', 1);
5514: --ER#7479609 UPDATE oe_hold_sources
5515: UPDATE oe_hold_sources_all --ER#7479609
5516: SET hold_release_id = x_hold_release_id
5517: , released_flag = 'Y'
5518: , LAST_UPDATED_BY = l_user_id

Line 5515: UPDATE oe_hold_sources_all --ER#7479609

5511: -- Flag the hold source as released
5512:
5513: oe_debug_pub.add('Updating oe_hold_sources for Release', 1);
5514: --ER#7479609 UPDATE oe_hold_sources
5515: UPDATE oe_hold_sources_all --ER#7479609
5516: SET hold_release_id = x_hold_release_id
5517: , released_flag = 'Y'
5518: , LAST_UPDATED_BY = l_user_id
5519: , LAST_UPDATE_DATE = sysdate

Line 5556: FROM OE_HOLD_SOURCES HS

5552: l_hold_release_id oe_hold_releases.HOLD_RELEASE_ID%type;
5553: --
5554: CURSOR hold_source IS
5555: SELECT HS.HOLD_SOURCE_ID
5556: FROM OE_HOLD_SOURCES HS
5557: WHERE HS.HOLD_ID = p_hold_source_rec.hold_id
5558: AND HS.RELEASED_FLAG = 'N'
5559: --AND NVL(HS.HOLD_UNTIL_DATE, SYSDATE + 1) > SYSDATE
5560: AND HS.HOLD_ENTITY_CODE = p_hold_source_rec.hold_entity_code

Line 5569: FROM OE_HOLD_SOURCES HS

5565: nvl(p_hold_source_rec.hold_entity_id2, -99);
5566:
5567: CURSOR order_hold_source IS
5568: SELECT HS.HOLD_SOURCE_ID
5569: FROM OE_HOLD_SOURCES HS
5570: WHERE HS.HOLD_ID = p_hold_source_rec.hold_id
5571: AND HS.RELEASED_FLAG = 'N'
5572: --AND NVL(HS.HOLD_UNTIL_DATE, SYSDATE + 1) > SYSDATE
5573: AND HS.HOLD_ENTITY_CODE = p_hold_source_rec.hold_entity_code

Line 5768: -- order, deletes hold source records from OE_HOLD_SOURCES.

5764: -- Delete Holds
5765: -- Deletes from OE_ORDER_HOLDS all hold records for an order (p_header_id)
5766: -- or for a line (p_line_id).
5767: -- Also, if there are ORDER hold sources (hold_entity_code = 'O') for this
5768: -- order, deletes hold source records from OE_HOLD_SOURCES.
5769: -- If the hold or hold source was released and the same release record is
5770: -- not used by an existing hold or hold source, then deletes the
5771: -- release record also from OE_HOLD_RELEASES;
5772: ----------------------------------------------------------------------------

Line 5791: FROM OE_HOLD_SOURCES_all

5787: FROM OE_ORDER_HOLDS_all
5788: WHERE HEADER_ID = p_order_rec.header_id;
5789: CURSOR hold_source IS
5790: SELECT hold_source_id, NVL(hold_release_id,0)
5791: FROM OE_HOLD_SOURCES_all
5792: WHERE HOLD_ENTITY_CODE = 'O'
5793: AND HOLD_ENTITY_ID = p_order_rec.header_id;
5794: CURSOR line_hold IS
5795: SELECT order_hold_id, NVL(hold_release_id,0)

Line 5844: FROM OE_HOLD_SOURCES_all

5840: AND HOLD_RELEASE_ID NOT IN (SELECT NVL(HOLD_RELEASE_ID,0)
5841: FROM OE_ORDER_HOLDS_all
5842: UNION
5843: SELECT NVL(HOLD_RELEASE_ID,0)
5844: FROM OE_HOLD_SOURCES_all
5845: );
5846: END LOOP;
5847:
5848: CLOSE order_hold;

Line 5859: DELETE FROM OE_HOLD_SOURCES_all

5855: EXIT;
5856: END IF;
5857: OE_Debug_PUB.Add('Deleting hold source record',1);
5858:
5859: DELETE FROM OE_HOLD_SOURCES_all
5860: WHERE HOLD_SOURCE_ID = l_hold_source_id;
5861:
5862: OE_Debug_PUB.Add('Deleting hold release record',1);
5863: DELETE FROM OE_HOLD_RELEASES

Line 5870: FROM OE_HOLD_SOURCES_all

5866: ( SELECT NVL(HOLD_RELEASE_ID,0)
5867: FROM OE_ORDER_HOLDS_all
5868: UNION
5869: SELECT NVL(HOLD_RELEASE_ID,0)
5870: FROM OE_HOLD_SOURCES_all
5871: );
5872:
5873: END LOOP;
5874:

Line 5903: FROM OE_HOLD_SOURCES_all

5899: (SELECT NVL(HOLD_RELEASE_ID,0)
5900: FROM OE_ORDER_HOLDS_all
5901: UNION
5902: SELECT NVL(HOLD_RELEASE_ID,0)
5903: FROM OE_HOLD_SOURCES_all
5904: );
5905:
5906: END LOOP;
5907:

Line 5960: p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE,

5956: --------------------
5957: Procedure Apply_Holds (
5958: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
5959: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,
5960: p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE,
5961: p_hold_comment IN OE_HOLD_SOURCES.HOLD_COMMENT%TYPE,
5962: p_check_authorization_flag IN VARCHAR2 DEFAULT 'N', -- bug 8477694
5963: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
5964: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 5961: p_hold_comment IN OE_HOLD_SOURCES.HOLD_COMMENT%TYPE,

5957: Procedure Apply_Holds (
5958: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
5959: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,
5960: p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE,
5961: p_hold_comment IN OE_HOLD_SOURCES.HOLD_COMMENT%TYPE,
5962: p_check_authorization_flag IN VARCHAR2 DEFAULT 'N', -- bug 8477694
5963: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
5964: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
5965: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )

Line 5969: l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;

5965: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
5966: IS
5967: j NUMBER;
5968: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
5969: l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;
5970: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
5971: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
5972: l_hold_exists VARCHAR2(1) :='N'; --bug 5548778
5973: l_msg_token VARCHAR2(100); --8477694

Line 6232: l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;

6228: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
6229: IS
6230: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
6231: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
6232: l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;
6233: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
6234: l_hold_exists VARCHAR2(1) :='N'; --bug 5548778
6235: l_msg_token VARCHAR2(100); --8477694
6236: /* Commented OLD Processing and added the lines below for WF_HOLS ER (bug 6449458)*/

Line 6619: UPDATE OE_HOLD_SOURCES

6615:
6616: EXCEPTION
6617: WHEN NO_DATA_FOUND THEN
6618: OE_Debug_PUB.Add('Setting hold source status to released');
6619: UPDATE OE_HOLD_SOURCES
6620: SET RELEASED_FLAG = 'Y'
6621: , HOLD_RELEASE_ID = l_hold_release_id
6622: , LAST_UPDATED_BY = l_user_id
6623: , LAST_UPDATE_DATE = SYSDATE

Line 6688: , p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE

6684: procedure process_apply_holds_lines (
6685: p_num_of_records IN NUMBER
6686: , p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
6687: , p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
6688: , p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE
6689: , p_hold_comment IN OE_HOLD_SOURCES.HOLD_COMMENT%TYPE
6690: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
6691: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
6692: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 6689: , p_hold_comment IN OE_HOLD_SOURCES.HOLD_COMMENT%TYPE

6685: p_num_of_records IN NUMBER
6686: , p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
6687: , p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
6688: , p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE
6689: , p_hold_comment IN OE_HOLD_SOURCES.HOLD_COMMENT%TYPE
6690: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
6691: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
6692: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
6693: )

Line 6942: , p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE

6938: procedure process_apply_holds_orders (
6939: p_num_of_records IN NUMBER
6940: , p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
6941: , p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
6942: , p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE
6943: , p_hold_comment IN OE_HOLD_SOURCES.HOLD_COMMENT%TYPE
6944: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
6945: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
6946: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 6943: , p_hold_comment IN OE_HOLD_SOURCES.HOLD_COMMENT%TYPE

6939: p_num_of_records IN NUMBER
6940: , p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
6941: , p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
6942: , p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE
6943: , p_hold_comment IN OE_HOLD_SOURCES.HOLD_COMMENT%TYPE
6944: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
6945: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
6946: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
6947: )

Line 7541: l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;

7537: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
7538: )
7539: IS
7540: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
7541: l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;
7542: l_hold_release_rec OE_HOLDS_PVT.hold_release_rec_type;
7543: l_hold_release_id oe_hold_releases.HOLD_RELEASE_ID%type;
7544: l_api_name CONSTANT VARCHAR2(30) := 'process_create_holds';
7545: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;

Line 7782: p_hold_source_id IN OE_Hold_Sources_ALL.HOLD_SOURCE_ID%TYPE

7778: /* This procedure gets called when Release Source button is pressed
7779: from the Release Source window.
7780: */
7781: procedure process_release_source(
7782: p_hold_source_id IN OE_Hold_Sources_ALL.HOLD_SOURCE_ID%TYPE
7783: ,p_hold_release_rec IN OE_HOLDS_PVT.Hold_Release_Rec_Type
7784: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
7785: ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
7786: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 7796: l_hold_entity_code OE_HOLD_SOURCES_ALL.HOLD_ENTITY_CODE%TYPE; --ER#7479609

7792: l_hold_id OE_HOLD_DEFINITIONS.HOLD_ID%TYPE;
7793: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
7794: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
7795: --ER#7479609 l_hold_entity_code varchar2(1); /* Added for Bug 1946783 */
7796: l_hold_entity_code OE_HOLD_SOURCES_ALL.HOLD_ENTITY_CODE%TYPE; --ER#7479609
7797: l_msg_token VARCHAR2(100);
7798: BEGIN
7799:
7800: BEGIN

Line 7803: from OE_HOLD_SOURCES_all

7799:
7800: BEGIN
7801: select hold_id, hold_entity_code
7802: into l_hold_id, l_hold_entity_code
7803: from OE_HOLD_SOURCES_all
7804: where hold_source_id = p_hold_source_id;
7805: EXCEPTION
7806: WHEN NO_DATA_FOUND THEN
7807: null;

Line 8374: p_hold_source_id IN OE_Hold_Sources_ALL.HOLD_SOURCE_ID%TYPE

8370: x_return_status Return status
8371: */
8372:
8373: procedure process_release_source(
8374: p_hold_source_id IN OE_Hold_Sources_ALL.HOLD_SOURCE_ID%TYPE
8375: ,p_hold_release_rec IN OE_HOLDS_PVT.Hold_Release_Rec_Type
8376: ,p_wf_release_action IN VARCHAR2
8377: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
8378: ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 8389: l_hold_entity_code OE_HOLD_SOURCES_ALL.HOLD_ENTITY_CODE%TYPE; --ER#7479609

8385: l_hold_id OE_HOLD_DEFINITIONS.HOLD_ID%TYPE;
8386: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
8387: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
8388: --ER#7479609 l_hold_entity_code VARCHAR2(1); /* Added for Bug 1946783 */
8389: l_hold_entity_code OE_HOLD_SOURCES_ALL.HOLD_ENTITY_CODE%TYPE; --ER#7479609
8390: l_msg_token VARCHAR2(100);
8391: BEGIN
8392:
8393:

Line 8397: from OE_HOLD_SOURCES_all

8393:
8394: BEGIN
8395: select hold_id, hold_entity_code
8396: into l_hold_id, l_hold_entity_code
8397: from OE_HOLD_SOURCES_all
8398: where hold_source_id = p_hold_source_id;
8399: EXCEPTION
8400: WHEN NO_DATA_FOUND THEN
8401: null;

Line 8566: l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;

8562: l_org_id NUMBER;
8563: l_api_name CONSTANT VARCHAR2(30) := 'SPLIT_HOLD';
8564:
8565: l_line_number NUMBER;
8566: l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;
8567: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
8568:
8569: CURSOR c_order_holds IS
8570: SELECT oh.HOLD_SOURCE_ID

Line 8594: OE_HOLD_SOURCES_all hs

8590: , hs.ATTRIBUTE14
8591: , hs.ATTRIBUTE15
8592: , oh.org_id
8593: FROM OE_ORDER_HOLDS_all oh,
8594: OE_HOLD_SOURCES_all hs
8595: WHERE oh.line_id = p_split_from_line_id
8596: AND oh.RELEASED_FLAG = 'N'
8597: AND OH.HOLD_SOURCE_ID = HS.HOLD_SOURCE_ID;
8598:

Line 8730: l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;

8726: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE :=
8727: FND_GLOBAL.RESP_APPL_ID;
8728: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE
8729: := FND_GLOBAL.RESP_ID;
8730: l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;
8731: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
8732: l_hold_exists VARCHAR2(1) :='N'; --bug 5548778
8733: l_msg_token VARCHAR2(100); --8477694
8734:

Line 8923: oe_hold_sources ohs,

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,
8925: oe_order_headers_all h,
8926: oe_order_sources oos
8927: WHERE ohd.hold_id = ohs.hold_id

Line 8940: oe_hold_sources ohs,

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,
8942: oe_order_headers_all h,
8943: oe_order_sources oos
8944: WHERE ohd.hold_id = ohs.hold_id

Line 8956: FROM oe_hold_sources ohs,

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
8959: --AND ohd.activity_name IS NULL Bug 6791587
8960: AND ohs.hold_source_id = p_hld_src_id);

Line 8969: oe_hold_sources_all ohs,

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,
8971: oe_order_headers_all h,
8972: oe_order_sources oos
8973: WHERE ohd.hold_id = ohs.hold_id

Line 8988: oe_hold_sources_all ohs,

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,
8990: oe_order_headers_all h,
8991: oe_order_sources oos
8992: WHERE ohd.hold_id = ohs.hold_id

Line 9006: FROM oe_hold_sources_all ohs,

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
9009: AND ohs.org_id = p_org_id
9010: AND ohs.hold_source_id = p_hld_src_id);