DBA Data[Home] [Help]

APPS.OE_CREDIT_CHECK_LINES_PVT dependencies on OE_HOLDS_PVT

Line 118: OE_HOLDS_PVT.Hold_Source_Rec_Type

114:
115: ----------------------------------------------------
116: PROCEDURE Apply_hold_and_commit
117: ( p_hold_source_rec IN
118: OE_HOLDS_PVT.Hold_Source_Rec_Type
119: , x_msg_count OUT NOCOPY NUMBER
120: , x_msg_data OUT NOCOPY VARCHAR2
121: , x_return_status OUT NOCOPY VARCHAR2
122: )

Line 181: ( p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type

177: ----------------------------------------------------
178: -- Procedure to Update Hold Comments And Commit --
179: ----------------------------------------------------
180: PROCEDURE Update_Comments_And_Commit
181: ( p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type
182: , x_msg_count OUT NOCOPY NUMBER
183: , x_msg_data OUT NOCOPY VARCHAR2
184: , x_return_status OUT NOCOPY VARCHAR2
185: )

Line 1480: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=

1476: l_msg_count NUMBER := 0;
1477: l_msg_data VARCHAR2(2000);
1478: l_return_status VARCHAR2(30);
1479: l_hold_comment VARCHAR2(2000);
1480: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
1481: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
1482: BEGIN
1483: IF G_debug_flag = 'Y'
1484: THEN

Line 1481: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;

1477: l_msg_data VARCHAR2(2000);
1478: l_return_status VARCHAR2(30);
1479: l_hold_comment VARCHAR2(2000);
1480: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
1481: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
1482: BEGIN
1483: IF G_debug_flag = 'Y'
1484: THEN
1485: OE_DEBUG_PUB.Add('OEXVCRLB: In Apply_Line_CC_Hold');

Line 1787: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=

1783: l_msg_count NUMBER := 0;
1784: l_msg_data VARCHAR2(2000);
1785: l_return_status VARCHAR2(30);
1786: l_hold_comment VARCHAR2(2000);
1787: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
1788: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
1789: BEGIN
1790: IF G_debug_flag = 'Y'
1791: THEN

Line 1788: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;

1784: l_msg_data VARCHAR2(2000);
1785: l_return_status VARCHAR2(30);
1786: l_hold_comment VARCHAR2(2000);
1787: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
1788: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
1789: BEGIN
1790: IF G_debug_flag = 'Y'
1791: THEN
1792: OE_DEBUG_PUB.Add('OEXVCRLB: In Apply_Order_CC_Hold');

Line 1934: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=

1930: l_msg_data VARCHAR2(2000);
1931: l_return_status VARCHAR2(30);
1932: l_release_reason VARCHAR2(30);
1933: l_cc_result_out VARCHAR2(30) := 'PASS_NONE';
1934: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
1935: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
1936: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type :=
1937: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;
1938: l_calling_activity VARCHAR2(50); --ER#7479609

Line 1935: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;

1931: l_return_status VARCHAR2(30);
1932: l_release_reason VARCHAR2(30);
1933: l_cc_result_out VARCHAR2(30) := 'PASS_NONE';
1934: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
1935: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
1936: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type :=
1937: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;
1938: l_calling_activity VARCHAR2(50); --ER#7479609
1939: BEGIN

Line 1936: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type :=

1932: l_release_reason VARCHAR2(30);
1933: l_cc_result_out VARCHAR2(30) := 'PASS_NONE';
1934: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
1935: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
1936: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type :=
1937: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;
1938: l_calling_activity VARCHAR2(50); --ER#7479609
1939: BEGIN
1940: IF G_debug_flag = 'Y'

Line 1937: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;

1933: l_cc_result_out VARCHAR2(30) := 'PASS_NONE';
1934: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
1935: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
1936: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type :=
1937: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;
1938: l_calling_activity VARCHAR2(50); --ER#7479609
1939: BEGIN
1940: IF G_debug_flag = 'Y'
1941: THEN

Line 2150: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=

2146: l_return_status VARCHAR2(30);
2147: l_release_reason VARCHAR2(30);
2148: l_cc_result_out VARCHAR2(30) := 'PASS_NONE';
2149:
2150: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
2151: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
2152: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type :=
2153: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;
2154: l_calling_activity VARCHAR2(50); --ER#7479609

Line 2151: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;

2147: l_release_reason VARCHAR2(30);
2148: l_cc_result_out VARCHAR2(30) := 'PASS_NONE';
2149:
2150: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
2151: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
2152: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type :=
2153: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;
2154: l_calling_activity VARCHAR2(50); --ER#7479609
2155:

Line 2152: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type :=

2148: l_cc_result_out VARCHAR2(30) := 'PASS_NONE';
2149:
2150: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
2151: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
2152: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type :=
2153: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;
2154: l_calling_activity VARCHAR2(50); --ER#7479609
2155:
2156: BEGIN

Line 2153: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;

2149:
2150: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type :=
2151: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
2152: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type :=
2153: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;
2154: l_calling_activity VARCHAR2(50); --ER#7479609
2155:
2156: BEGIN
2157: