114:
115: ----------------------------------------------------
116: PROCEDURE Apply_hold_and_commit
117: ( p_hold_source_rec IN
118: OE_HOLDS_PVT.Hold_Source_Rec_Type
119: , x_msg_count OUT NOCOPY NUMBER
120: , x_msg_data OUT NOCOPY VARCHAR2
121: , x_return_status OUT NOCOPY VARCHAR2
122: )
177: ----------------------------------------------------
178: -- Procedure to Update Hold Comments And Commit --
179: ----------------------------------------------------
180: PROCEDURE Update_Comments_And_Commit
181: ( p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type
182: , x_msg_count OUT NOCOPY NUMBER
183: , x_msg_data OUT NOCOPY VARCHAR2
184: , x_return_status OUT NOCOPY VARCHAR2
185: )
1476: l_msg_count NUMBER := 0;
1477: l_msg_data VARCHAR2(2000);
1478: l_return_status VARCHAR2(30);
1479: l_hold_comment VARCHAR2(2000);
1480: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
1481: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
1482: BEGIN
1483: IF G_debug_flag = 'Y'
1484: THEN
1477: l_msg_data VARCHAR2(2000);
1478: l_return_status VARCHAR2(30);
1479: l_hold_comment VARCHAR2(2000);
1480: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
1481: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
1482: BEGIN
1483: IF G_debug_flag = 'Y'
1484: THEN
1485: OE_DEBUG_PUB.Add('OEXVCRLB: In Apply_Line_CC_Hold');
1783: l_msg_count NUMBER := 0;
1784: l_msg_data VARCHAR2(2000);
1785: l_return_status VARCHAR2(30);
1786: l_hold_comment VARCHAR2(2000);
1787: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
1788: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
1789: BEGIN
1790: IF G_debug_flag = 'Y'
1791: THEN
1784: l_msg_data VARCHAR2(2000);
1785: l_return_status VARCHAR2(30);
1786: l_hold_comment VARCHAR2(2000);
1787: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
1788: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
1789: BEGIN
1790: IF G_debug_flag = 'Y'
1791: THEN
1792: OE_DEBUG_PUB.Add('OEXVCRLB: In Apply_Order_CC_Hold');
1930: l_msg_data VARCHAR2(2000);
1931: l_return_status VARCHAR2(30);
1932: l_release_reason VARCHAR2(30);
1933: l_cc_result_out VARCHAR2(30) := 'PASS_NONE';
1934: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
1935: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
1936: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type :=
1937: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;
1938: l_calling_activity VARCHAR2(50); --ER#7479609
1931: l_return_status VARCHAR2(30);
1932: l_release_reason VARCHAR2(30);
1933: l_cc_result_out VARCHAR2(30) := 'PASS_NONE';
1934: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
1935: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
1936: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type :=
1937: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;
1938: l_calling_activity VARCHAR2(50); --ER#7479609
1939: BEGIN
1932: l_release_reason VARCHAR2(30);
1933: l_cc_result_out VARCHAR2(30) := 'PASS_NONE';
1934: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
1935: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
1936: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type :=
1937: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;
1938: l_calling_activity VARCHAR2(50); --ER#7479609
1939: BEGIN
1940: IF G_debug_flag = 'Y'
1933: l_cc_result_out VARCHAR2(30) := 'PASS_NONE';
1934: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
1935: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
1936: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type :=
1937: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;
1938: l_calling_activity VARCHAR2(50); --ER#7479609
1939: BEGIN
1940: IF G_debug_flag = 'Y'
1941: THEN
2146: l_return_status VARCHAR2(30);
2147: l_release_reason VARCHAR2(30);
2148: l_cc_result_out VARCHAR2(30) := 'PASS_NONE';
2149:
2150: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
2151: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
2152: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type :=
2153: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;
2154: l_calling_activity VARCHAR2(50); --ER#7479609
2147: l_release_reason VARCHAR2(30);
2148: l_cc_result_out VARCHAR2(30) := 'PASS_NONE';
2149:
2150: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
2151: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
2152: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type :=
2153: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;
2154: l_calling_activity VARCHAR2(50); --ER#7479609
2155:
2148: l_cc_result_out VARCHAR2(30) := 'PASS_NONE';
2149:
2150: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
2151: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
2152: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type :=
2153: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;
2154: l_calling_activity VARCHAR2(50); --ER#7479609
2155:
2156: BEGIN
2149:
2150: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
2151: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
2152: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type :=
2153: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;
2154: l_calling_activity VARCHAR2(50); --ER#7479609
2155:
2156: BEGIN
2157: