DBA Data[Home] [Help]

APPS.OE_CREDIT_CHECK_LINES_PVT dependencies on OE_HOLDS_PVT

Line 84: OE_HOLDS_PVT.Hold_Source_Rec_Type

80:
81: ----------------------------------------------------
82: PROCEDURE Apply_hold_and_commit
83: ( p_hold_source_rec IN
84: OE_HOLDS_PVT.Hold_Source_Rec_Type
85: , x_msg_count OUT NOCOPY NUMBER
86: , x_msg_data OUT NOCOPY VARCHAR2
87: , x_return_status OUT NOCOPY VARCHAR2
88: )

Line 147: ( p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type

143: ----------------------------------------------------
144: -- Procedure to Update Hold Comments And Commit --
145: ----------------------------------------------------
146: PROCEDURE Update_Comments_And_Commit
147: ( p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type
148: , x_msg_count OUT NOCOPY NUMBER
149: , x_msg_data OUT NOCOPY VARCHAR2
150: , x_return_status OUT NOCOPY VARCHAR2
151: )

Line 1353: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=

1349: l_msg_count NUMBER := 0;
1350: l_msg_data VARCHAR2(2000);
1351: l_return_status VARCHAR2(30);
1352: l_hold_comment VARCHAR2(2000);
1353: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
1354: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
1355: BEGIN
1356: IF G_debug_flag = 'Y'
1357: THEN

Line 1354: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;

1350: l_msg_data VARCHAR2(2000);
1351: l_return_status VARCHAR2(30);
1352: l_hold_comment VARCHAR2(2000);
1353: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
1354: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
1355: BEGIN
1356: IF G_debug_flag = 'Y'
1357: THEN
1358: OE_DEBUG_PUB.Add('OEXVCRLB: In Apply_Line_CC_Hold');

Line 1634: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=

1630: l_msg_count NUMBER := 0;
1631: l_msg_data VARCHAR2(2000);
1632: l_return_status VARCHAR2(30);
1633: l_hold_comment VARCHAR2(2000);
1634: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
1635: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
1636: BEGIN
1637: IF G_debug_flag = 'Y'
1638: THEN

Line 1635: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;

1631: l_msg_data VARCHAR2(2000);
1632: l_return_status VARCHAR2(30);
1633: l_hold_comment VARCHAR2(2000);
1634: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
1635: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
1636: BEGIN
1637: IF G_debug_flag = 'Y'
1638: THEN
1639: OE_DEBUG_PUB.Add('OEXVCRLB: In Apply_Order_CC_Hold');

Line 1776: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=

1772: l_msg_data VARCHAR2(2000);
1773: l_return_status VARCHAR2(30);
1774: l_release_reason VARCHAR2(30);
1775: l_cc_result_out VARCHAR2(30) := 'PASS_NONE';
1776: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
1777: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
1778: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type :=
1779: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;
1780: l_calling_activity VARCHAR2(50); --ER#7479609

Line 1777: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;

1773: l_return_status VARCHAR2(30);
1774: l_release_reason VARCHAR2(30);
1775: l_cc_result_out VARCHAR2(30) := 'PASS_NONE';
1776: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
1777: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
1778: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type :=
1779: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;
1780: l_calling_activity VARCHAR2(50); --ER#7479609
1781: BEGIN

Line 1778: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type :=

1774: l_release_reason VARCHAR2(30);
1775: l_cc_result_out VARCHAR2(30) := 'PASS_NONE';
1776: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
1777: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
1778: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type :=
1779: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;
1780: l_calling_activity VARCHAR2(50); --ER#7479609
1781: BEGIN
1782: IF G_debug_flag = 'Y'

Line 1779: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;

1775: l_cc_result_out VARCHAR2(30) := 'PASS_NONE';
1776: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
1777: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
1778: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type :=
1779: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;
1780: l_calling_activity VARCHAR2(50); --ER#7479609
1781: BEGIN
1782: IF G_debug_flag = 'Y'
1783: THEN

Line 1992: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=

1988: l_return_status VARCHAR2(30);
1989: l_release_reason VARCHAR2(30);
1990: l_cc_result_out VARCHAR2(30) := 'PASS_NONE';
1991:
1992: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
1993: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
1994: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type :=
1995: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;
1996: l_calling_activity VARCHAR2(50); --ER#7479609

Line 1993: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;

1989: l_release_reason VARCHAR2(30);
1990: l_cc_result_out VARCHAR2(30) := 'PASS_NONE';
1991:
1992: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
1993: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
1994: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type :=
1995: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;
1996: l_calling_activity VARCHAR2(50); --ER#7479609
1997:

Line 1994: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type :=

1990: l_cc_result_out VARCHAR2(30) := 'PASS_NONE';
1991:
1992: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
1993: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
1994: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type :=
1995: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;
1996: l_calling_activity VARCHAR2(50); --ER#7479609
1997:
1998: BEGIN

Line 1995: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;

1991:
1992: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
1993: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
1994: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type :=
1995: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;
1996: l_calling_activity VARCHAR2(50); --ER#7479609
1997:
1998: BEGIN
1999: