DBA Data[Home] [Help]

APPS.HZ_CREDIT_REQUEST_PVT dependencies on OE_HOLDS_PVT

Line 54: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type := OE_HOLDS_PVT.G_MISS_Hold_Source_REC;

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

Line 55: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type := OE_HOLDS_PVT.G_MISS_Hold_Release_REC;

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');

Line 166: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=

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

Line 167: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;

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'

Line 168: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type :=

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

Line 169: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;

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');