DBA Data[Home] [Help]

APPS.OE_CREDIT_CHECK_ORDER_PVT dependencies on OE_HOLDS_PVT

Line 562: OE_HOLDS_PVT.Hold_Source_Rec_Type

558: ------------------------------------------------
559:
560: PROCEDURE Apply_hold_and_commit
561: ( p_hold_source_rec IN
562: OE_HOLDS_PVT.Hold_Source_Rec_Type
563: , x_msg_count OUT NOCOPY NUMBER
564: , x_msg_data OUT NOCOPY VARCHAR2
565: , x_return_status OUT NOCOPY VARCHAR2
566: )

Line 625: ( p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type

621: --------------------------------------------------------------------------
622: -- Procedure to Update Hold Comments, Credit Profile Level And Commit --
623: --------------------------------------------------------------------------
624: PROCEDURE Update_Comments_And_Commit
625: ( p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type
626: , x_msg_count OUT NOCOPY NUMBER
627: , x_msg_data OUT NOCOPY VARCHAR2
628: , x_return_status OUT NOCOPY VARCHAR2
629: )

Line 752: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=

748: l_msg_count NUMBER := 0;
749: l_msg_data VARCHAR2(2000);
750: l_return_status VARCHAR2(30);
751: l_hold_comment VARCHAR2(2000);
752: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
753: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
754: BEGIN
755: IF G_debug_flag = 'Y'
756: THEN

Line 753: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;

749: l_msg_data VARCHAR2(2000);
750: l_return_status VARCHAR2(30);
751: l_hold_comment VARCHAR2(2000);
752: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
753: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
754: BEGIN
755: IF G_debug_flag = 'Y'
756: THEN
757: OE_DEBUG_PUB.Add('OEXVCRHB: In Apply_Order_CC_Hold');

Line 1011: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=

1007: l_msg_data VARCHAR2(2000);
1008: l_return_status VARCHAR2(30);
1009: l_release_reason VARCHAR2(30);
1010: l_cc_result_out VARCHAR2(30) := 'PASS_NONE';
1011: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
1012: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
1013: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type :=
1014: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;
1015: l_calling_activity VARCHAR2(50); --ER#7479609

Line 1012: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;

1008: l_return_status VARCHAR2(30);
1009: l_release_reason VARCHAR2(30);
1010: l_cc_result_out VARCHAR2(30) := 'PASS_NONE';
1011: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
1012: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
1013: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type :=
1014: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;
1015: l_calling_activity VARCHAR2(50); --ER#7479609
1016: BEGIN

Line 1013: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type :=

1009: l_release_reason VARCHAR2(30);
1010: l_cc_result_out VARCHAR2(30) := 'PASS_NONE';
1011: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
1012: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
1013: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type :=
1014: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;
1015: l_calling_activity VARCHAR2(50); --ER#7479609
1016: BEGIN
1017: IF G_debug_flag = 'Y'

Line 1014: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;

1010: l_cc_result_out VARCHAR2(30) := 'PASS_NONE';
1011: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
1012: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
1013: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type :=
1014: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;
1015: l_calling_activity VARCHAR2(50); --ER#7479609
1016: BEGIN
1017: IF G_debug_flag = 'Y'
1018: THEN