APPS.OE_CREDIT_CHECK_ORDER_PVT dependencies on OE_HOLDS_PVT

Line 516: OE_HOLDS_PVT.Hold_Source_Rec_Type

512: ------------------------------------------------
513:
514: PROCEDURE Apply_hold_and_commit
515: ( p_hold_source_rec IN
516: OE_HOLDS_PVT.Hold_Source_Rec_Type
517: , x_msg_count OUT NOCOPY NUMBER
518: , x_msg_data OUT NOCOPY VARCHAR2
519: , x_return_status OUT NOCOPY VARCHAR2
520: )

Line 579: ( p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type

575: ----------------------------------------------------
576: -- Procedure to Update Hold Comments And Commit --
577: ----------------------------------------------------
578: PROCEDURE Update_Comments_And_Commit
579: ( p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type
580: , x_msg_count OUT NOCOPY NUMBER
581: , x_msg_data OUT NOCOPY VARCHAR2
582: , x_return_status OUT NOCOPY VARCHAR2
583: )

Line 687: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=

683: l_msg_count NUMBER := 0;
684: l_msg_data VARCHAR2(2000);
685: l_return_status VARCHAR2(30);
686: l_hold_comment VARCHAR2(2000);
687: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
688: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
689: BEGIN
690: IF G_debug_flag = 'Y'
691: THEN

Line 688: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;

684: l_msg_data VARCHAR2(2000);
685: l_return_status VARCHAR2(30);
686: l_hold_comment VARCHAR2(2000);
687: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
688: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
689: BEGIN
690: IF G_debug_flag = 'Y'
691: THEN
692: OE_DEBUG_PUB.Add('OEXVCRHB: In Apply_Order_CC_Hold');

Line 909: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=

905: l_msg_data VARCHAR2(2000);
906: l_return_status VARCHAR2(30);
907: l_release_reason VARCHAR2(30);
908: l_cc_result_out VARCHAR2(30) := 'PASS_NONE';
909: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
910: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
911: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type :=
912: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;
913: l_calling_activity VARCHAR2(50); --ER#7479609

Line 910: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;

906: l_return_status VARCHAR2(30);
907: l_release_reason VARCHAR2(30);
908: l_cc_result_out VARCHAR2(30) := 'PASS_NONE';
909: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
910: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
911: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type :=
912: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;
913: l_calling_activity VARCHAR2(50); --ER#7479609
914: BEGIN

Line 911: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type :=

907: l_release_reason VARCHAR2(30);
908: l_cc_result_out VARCHAR2(30) := 'PASS_NONE';
909: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
910: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
911: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type :=
912: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;
913: l_calling_activity VARCHAR2(50); --ER#7479609
914: BEGIN
915: IF G_debug_flag = 'Y'

Line 912: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;

908: l_cc_result_out VARCHAR2(30) := 'PASS_NONE';
909: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
910: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
911: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type :=
912: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;
913: l_calling_activity VARCHAR2(50); --ER#7479609
914: BEGIN
915: IF G_debug_flag = 'Y'
916: THEN