DBA Data[Home] [Help]

APPS.OE_LINE_PAYMENT_UTIL dependencies on OE_ORDER_PUB

Line 83: ( p_Line_Payment_rec IN OE_Order_PUB.LINE_PAYMENT_Rec_Type

79:
80: END G_MISS_OE_AK_LPAYMENT_REC;
81:
82: PROCEDURE API_Rec_To_Rowtype_Rec
83: ( p_Line_Payment_rec IN OE_Order_PUB.LINE_PAYMENT_Rec_Type
84: , x_rowtype_rec IN OUT NOCOPY OE_AK_LINE_PAYMENTS_V%ROWTYPE
85: ) IS
86: --
87: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 146: , x_api_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type

142:
143:
144: PROCEDURE Rowtype_Rec_To_API_Rec
145: ( p_record IN OE_AK_LINE_PAYMENTS_V%ROWTYPE
146: , x_api_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
147: ) IS
148: --
149: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
150: --

Line 814: , p_x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type

810: END Clear_Dependent_Attr;
811:
812: PROCEDURE Clear_Dependent_Attr
813: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
814: , p_x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
815: , p_old_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type :=
816: OE_Order_PUB.G_MISS_LINE_PAYMENT_REC
817: )
818: IS

Line 815: , p_old_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type :=

811:
812: PROCEDURE Clear_Dependent_Attr
813: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
814: , p_x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
815: , p_old_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type :=
816: OE_Order_PUB.G_MISS_LINE_PAYMENT_REC
817: )
818: IS
819: l_Line_Payment_rec OE_AK_LINE_PAYMENTS_V%ROWTYPE;

Line 816: OE_Order_PUB.G_MISS_LINE_PAYMENT_REC

812: PROCEDURE Clear_Dependent_Attr
813: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
814: , p_x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
815: , p_old_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type :=
816: OE_Order_PUB.G_MISS_LINE_PAYMENT_REC
817: )
818: IS
819: l_Line_Payment_rec OE_AK_LINE_PAYMENTS_V%ROWTYPE;
820: l_old_Line_Payment_rec OE_AK_LINE_PAYMENTS_V%ROWTYPE;

Line 932: ( p_x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type

928:
929: -- Procedure Apply_Attribute_Changes
930:
931: PROCEDURE Apply_Attribute_Changes
932: ( p_x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
933: , p_old_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type :=
934: OE_Order_PUB.G_MISS_LINE_Payment_REC
935: )
936: IS

Line 933: , p_old_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type :=

929: -- Procedure Apply_Attribute_Changes
930:
931: PROCEDURE Apply_Attribute_Changes
932: ( p_x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
933: , p_old_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type :=
934: OE_Order_PUB.G_MISS_LINE_Payment_REC
935: )
936: IS
937: l_return_status Varchar2(10);

Line 934: OE_Order_PUB.G_MISS_LINE_Payment_REC

930:
931: PROCEDURE Apply_Attribute_Changes
932: ( p_x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
933: , p_old_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type :=
934: OE_Order_PUB.G_MISS_LINE_Payment_REC
935: )
936: IS
937: l_return_status Varchar2(10);
938: --

Line 1380: ( p_x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type

1376:
1377: -- Procedure Complete_Record
1378:
1379: PROCEDURE Complete_Record
1380: ( p_x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
1381: , p_old_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type
1382: )
1383: IS
1384: --

Line 1381: , p_old_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type

1377: -- Procedure Complete_Record
1378:
1379: PROCEDURE Complete_Record
1380: ( p_x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
1381: , p_old_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type
1382: )
1383: IS
1384: --
1385: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1597: ( p_x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type

1593:
1594: -- Procedure Convert_Miss_To_Null
1595:
1596: PROCEDURE Convert_Miss_To_Null
1597: ( p_x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
1598: )
1599: IS
1600:
1601: --

Line 1809: ( p_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type

1805:
1806: -- Procedure Update_Row
1807:
1808: PROCEDURE Update_Row
1809: ( p_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
1810: )
1811: IS
1812: l_lock_control NUMBER;
1813: --added for notification framework

Line 1943: ( p_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type

1939:
1940: -- Procedure Insert_Row
1941:
1942: PROCEDURE Insert_Row
1943: ( p_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
1944: )
1945: IS
1946: l_lock_control NUMBER:= 1;
1947: l_index NUMBER;

Line 2172: l_new_line_Payment_rec OE_Order_PUB.Line_Payment_Rec_Type;

2168: FROM OE_PAYMENTS
2169: WHERE LINE_ID = p_line_id
2170: AND HEADER_ID = p_header_id;
2171: -- added for notification framework
2172: l_new_line_Payment_rec OE_Order_PUB.Line_Payment_Rec_Type;
2173: l_index NUMBER;
2174: --
2175: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2176: --

Line 2557: x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type

2553: ( p_payment_number IN NUMBER,
2554: p_line_id IN NUMBER,
2555: p_header_id IN NUMBER :=
2556: FND_API.G_MISS_NUM,
2557: x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
2558: )
2559: IS
2560: x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2561: CURSOR l_Line_Payment_csr IS

Line 2560: x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

2556: FND_API.G_MISS_NUM,
2557: x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
2558: )
2559: IS
2560: x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2561: CURSOR l_Line_Payment_csr IS
2562: SELECT ATTRIBUTE1
2563: , ATTRIBUTE2
2564: , ATTRIBUTE3

Line 2765: , x_line_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Line_Payment_Tbl_Type

2761: , p_line_id IN NUMBER :=
2762: FND_API.G_MISS_NUM
2763: , p_header_id IN NUMBER :=
2764: FND_API.G_MISS_NUM
2765: , x_line_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Line_Payment_Tbl_Type
2766: )
2767: IS
2768: l_Line_Payment_rec OE_Order_PUB.Line_Payment_Rec_Type;
2769:

Line 2768: l_Line_Payment_rec OE_Order_PUB.Line_Payment_Rec_Type;

2764: FND_API.G_MISS_NUM
2765: , x_line_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Line_Payment_Tbl_Type
2766: )
2767: IS
2768: l_Line_Payment_rec OE_Order_PUB.Line_Payment_Rec_Type;
2769:
2770: CURSOR l_Line_Payment_csr IS
2771: SELECT ATTRIBUTE1
2772: , ATTRIBUTE2

Line 2947: , p_x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type

2943: --
2944:
2945: PROCEDURE Lock_Row
2946: ( x_return_status OUT NOCOPY VARCHAR2
2947: , p_x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
2948: , p_payment_number IN NUMBER
2949: := FND_API.G_MISS_NUM
2950: , p_line_id IN NUMBER
2951: := FND_API.G_MISS_NUM

Line 2957: l_Line_Payment_rec OE_Order_PUB.Line_Payment_Rec_Type;

2953: IS
2954: l_payment_number NUMBER;
2955: l_line_id NUMBER;
2956: l_header_id NUMBER;
2957: l_Line_Payment_rec OE_Order_PUB.Line_Payment_Rec_Type;
2958: l_lock_control NUMBER;
2959: --
2960: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2961: --

Line 3100: , x_line_Payment_tbl OUT NOCOPY OE_Order_PUB.line_Payment_Tbl_Type

3096: , p_line_id IN NUMBER :=
3097: FND_API.G_MISS_NUM
3098: , p_header_id IN NUMBER :=
3099: FND_API.G_MISS_NUM
3100: , x_line_Payment_tbl OUT NOCOPY OE_Order_PUB.line_Payment_Tbl_Type
3101: , x_return_status OUT NOCOPY VARCHAR2
3102: )
3103: IS
3104: CURSOR lock_lin_Payments(p_line_id NUMBER) IS

Line 3233: ( p_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type

3229:
3230: -- Function Get_Values
3231:
3232: FUNCTION Get_Values
3233: ( p_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type
3234: , p_old_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type :=
3235: OE_Order_PUB.G_MISS_LINE_PAYMENT_REC
3236: )RETURN OE_Order_PUB.Line_Payment_Val_Rec_Type
3237: IS

Line 3234: , p_old_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type :=

3230: -- Function Get_Values
3231:
3232: FUNCTION Get_Values
3233: ( p_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type
3234: , p_old_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type :=
3235: OE_Order_PUB.G_MISS_LINE_PAYMENT_REC
3236: )RETURN OE_Order_PUB.Line_Payment_Val_Rec_Type
3237: IS
3238: l_Line_Payment_val_rec OE_Order_PUB.Line_Payment_Val_Rec_Type;

Line 3235: OE_Order_PUB.G_MISS_LINE_PAYMENT_REC

3231:
3232: FUNCTION Get_Values
3233: ( p_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type
3234: , p_old_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type :=
3235: OE_Order_PUB.G_MISS_LINE_PAYMENT_REC
3236: )RETURN OE_Order_PUB.Line_Payment_Val_Rec_Type
3237: IS
3238: l_Line_Payment_val_rec OE_Order_PUB.Line_Payment_Val_Rec_Type;
3239: --

Line 3236: )RETURN OE_Order_PUB.Line_Payment_Val_Rec_Type

3232: FUNCTION Get_Values
3233: ( p_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type
3234: , p_old_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type :=
3235: OE_Order_PUB.G_MISS_LINE_PAYMENT_REC
3236: )RETURN OE_Order_PUB.Line_Payment_Val_Rec_Type
3237: IS
3238: l_Line_Payment_val_rec OE_Order_PUB.Line_Payment_Val_Rec_Type;
3239: --
3240: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 3238: l_Line_Payment_val_rec OE_Order_PUB.Line_Payment_Val_Rec_Type;

3234: , p_old_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type :=
3235: OE_Order_PUB.G_MISS_LINE_PAYMENT_REC
3236: )RETURN OE_Order_PUB.Line_Payment_Val_Rec_Type
3237: IS
3238: l_Line_Payment_val_rec OE_Order_PUB.Line_Payment_Val_Rec_Type;
3239: --
3240: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3241: --
3242: BEGIN

Line 3281: ( p_x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type

3277:
3278: -- Procedure Get_Ids
3279:
3280: PROCEDURE Get_Ids
3281: ( p_x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
3282: , p_Line_Payment_val_rec IN OE_Order_PUB.Line_Payment_Val_Rec_Type
3283: )
3284: IS
3285:

Line 3282: , p_Line_Payment_val_rec IN OE_Order_PUB.Line_Payment_Val_Rec_Type

3278: -- Procedure Get_Ids
3279:
3280: PROCEDURE Get_Ids
3281: ( p_x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
3282: , p_Line_Payment_val_rec IN OE_Order_PUB.Line_Payment_Val_Rec_Type
3283: )
3284: IS
3285:
3286: --

Line 3391: ( p_x_line_Payment_rec IN OUT NOCOPY OE_ORDER_PUB.line_Payment_rec_type,

3387:
3388: END Get_Ids;
3389:
3390: PROCEDURE Pre_Write_Process
3391: ( p_x_line_Payment_rec IN OUT NOCOPY OE_ORDER_PUB.line_Payment_rec_type,
3392: p_old_line_Payment_rec IN OE_ORDER_PUB.line_Payment_rec_type := OE_ORDER_PUB.G_MISS_LINE_PAYMENT_REC )
3393: IS
3394: l_return_status varchar2(30);
3395: l_ordered_date DATE;

Line 3392: p_old_line_Payment_rec IN OE_ORDER_PUB.line_Payment_rec_type := OE_ORDER_PUB.G_MISS_LINE_PAYMENT_REC )

3388: END Get_Ids;
3389:
3390: PROCEDURE Pre_Write_Process
3391: ( p_x_line_Payment_rec IN OUT NOCOPY OE_ORDER_PUB.line_Payment_rec_type,
3392: p_old_line_Payment_rec IN OE_ORDER_PUB.line_Payment_rec_type := OE_ORDER_PUB.G_MISS_LINE_PAYMENT_REC )
3393: IS
3394: l_return_status varchar2(30);
3395: l_ordered_date DATE;
3396: l_transactional_curr_code VARCHAR2(30);

Line 4033: p_x_line_rec OE_ORDER_PUB.Line_Rec_Type;

4029: x_return_status out nocopy varchar2,
4030: x_msg_count out nocopy number,
4031: x_msg_data out nocopy varchar2) is
4032: p_count number := -1;
4033: p_x_line_rec OE_ORDER_PUB.Line_Rec_Type;
4034: l_old_line_rec OE_ORDER_PUB.Line_Rec_Type;
4035: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
4036: l_return_status varchar2(30) := NULL;
4037: l_payment_type_code varchar2(30) := null;

Line 4034: l_old_line_rec OE_ORDER_PUB.Line_Rec_Type;

4030: x_msg_count out nocopy number,
4031: x_msg_data out nocopy varchar2) is
4032: p_count number := -1;
4033: p_x_line_rec OE_ORDER_PUB.Line_Rec_Type;
4034: l_old_line_rec OE_ORDER_PUB.Line_Rec_Type;
4035: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
4036: l_return_status varchar2(30) := NULL;
4037: l_payment_type_code varchar2(30) := null;
4038: l_upd_commitment number := 0;

Line 4035: l_line_rec OE_ORDER_PUB.Line_Rec_Type;

4031: x_msg_data out nocopy varchar2) is
4032: p_count number := -1;
4033: p_x_line_rec OE_ORDER_PUB.Line_Rec_Type;
4034: l_old_line_rec OE_ORDER_PUB.Line_Rec_Type;
4035: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
4036: l_return_status varchar2(30) := NULL;
4037: l_payment_type_code varchar2(30) := null;
4038: l_upd_commitment number := 0;
4039: l_upd_payment number := 0;