50: l_msg_data VARCHAR2(2000);
51: l_return_status VARCHAR2(30);
52: l_release_reason VARCHAR2(30);
53: l_cc_result_out VARCHAR2(30) := 'PASS_NONE';
54: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type := OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
55: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type := OE_HOLDS_PVT.G_MISS_Hold_Release_REC;
56:
57: BEGIN
58: IF G_debug_flag = 'Y' THEN
51: l_return_status VARCHAR2(30);
52: l_release_reason VARCHAR2(30);
53: l_cc_result_out VARCHAR2(30) := 'PASS_NONE';
54: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type := OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
55: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type := OE_HOLDS_PVT.G_MISS_Hold_Release_REC;
56:
57: BEGIN
58: IF G_debug_flag = 'Y' THEN
59: oe_debug_pub.add('In Release_Order_CC_Hold');
162: l_return_status VARCHAR2(30);
163: l_release_reason VARCHAR2(30);
164: l_cc_result_out VARCHAR2(30) := 'PASS_NONE';
165:
166: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
167: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
168: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type :=
169: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;
170: BEGIN
163: l_release_reason VARCHAR2(30);
164: l_cc_result_out VARCHAR2(30) := 'PASS_NONE';
165:
166: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
167: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
168: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type :=
169: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;
170: BEGIN
171: IF G_debug_flag = 'Y'
164: l_cc_result_out VARCHAR2(30) := 'PASS_NONE';
165:
166: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
167: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
168: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type :=
169: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;
170: BEGIN
171: IF G_debug_flag = 'Y'
172: THEN
165:
166: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
167: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
168: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type :=
169: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;
170: BEGIN
171: IF G_debug_flag = 'Y'
172: THEN
173: oe_debug_pub.add(' In Release_Line_CC_Hold');