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 1458: ( p_x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type

1454:
1455: -- Procedure Complete_Record
1456:
1457: PROCEDURE Complete_Record
1458: ( p_x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
1459: , p_old_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type
1460: )
1461: IS
1462: --

Line 1459: , p_old_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type

1455: -- Procedure Complete_Record
1456:
1457: PROCEDURE Complete_Record
1458: ( p_x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
1459: , p_old_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type
1460: )
1461: IS
1462: --
1463: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1675: ( p_x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type

1671:
1672: -- Procedure Convert_Miss_To_Null
1673:
1674: PROCEDURE Convert_Miss_To_Null
1675: ( p_x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
1676: )
1677: IS
1678:
1679: --

Line 1887: ( p_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type

1883:
1884: -- Procedure Update_Row
1885:
1886: PROCEDURE Update_Row
1887: ( p_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
1888: )
1889: IS
1890: l_lock_control NUMBER;
1891: --added for notification framework

Line 2021: ( p_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type

2017:
2018: -- Procedure Insert_Row
2019:
2020: PROCEDURE Insert_Row
2021: ( p_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
2022: )
2023: IS
2024: l_lock_control NUMBER:= 1;
2025: l_index NUMBER;

Line 2250: l_new_line_Payment_rec OE_Order_PUB.Line_Payment_Rec_Type;

2246: FROM OE_PAYMENTS
2247: WHERE LINE_ID = p_line_id
2248: AND HEADER_ID = p_header_id;
2249: -- added for notification framework
2250: l_new_line_Payment_rec OE_Order_PUB.Line_Payment_Rec_Type;
2251: l_index NUMBER;
2252: --
2253: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2254: --

Line 2635: x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type

2631: ( p_payment_number IN NUMBER,
2632: p_line_id IN NUMBER,
2633: p_header_id IN NUMBER :=
2634: FND_API.G_MISS_NUM,
2635: x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
2636: )
2637: IS
2638: x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2639: CURSOR l_Line_Payment_csr IS

Line 2638: x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

2634: FND_API.G_MISS_NUM,
2635: x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
2636: )
2637: IS
2638: x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2639: CURSOR l_Line_Payment_csr IS
2640: SELECT ATTRIBUTE1
2641: , ATTRIBUTE2
2642: , ATTRIBUTE3

Line 2843: , x_line_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Line_Payment_Tbl_Type

2839: , p_line_id IN NUMBER :=
2840: FND_API.G_MISS_NUM
2841: , p_header_id IN NUMBER :=
2842: FND_API.G_MISS_NUM
2843: , x_line_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Line_Payment_Tbl_Type
2844: )
2845: IS
2846: l_Line_Payment_rec OE_Order_PUB.Line_Payment_Rec_Type;
2847:

Line 2846: l_Line_Payment_rec OE_Order_PUB.Line_Payment_Rec_Type;

2842: FND_API.G_MISS_NUM
2843: , x_line_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Line_Payment_Tbl_Type
2844: )
2845: IS
2846: l_Line_Payment_rec OE_Order_PUB.Line_Payment_Rec_Type;
2847:
2848: CURSOR l_Line_Payment_csr IS
2849: SELECT ATTRIBUTE1
2850: , ATTRIBUTE2

Line 3025: , p_x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type

3021: --
3022:
3023: PROCEDURE Lock_Row
3024: ( x_return_status OUT NOCOPY VARCHAR2
3025: , p_x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
3026: , p_payment_number IN NUMBER
3027: := FND_API.G_MISS_NUM
3028: , p_line_id IN NUMBER
3029: := FND_API.G_MISS_NUM

Line 3035: l_Line_Payment_rec OE_Order_PUB.Line_Payment_Rec_Type;

3031: IS
3032: l_payment_number NUMBER;
3033: l_line_id NUMBER;
3034: l_header_id NUMBER;
3035: l_Line_Payment_rec OE_Order_PUB.Line_Payment_Rec_Type;
3036: l_lock_control NUMBER;
3037: --
3038: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3039: --

Line 3178: , x_line_Payment_tbl OUT NOCOPY OE_Order_PUB.line_Payment_Tbl_Type

3174: , p_line_id IN NUMBER :=
3175: FND_API.G_MISS_NUM
3176: , p_header_id IN NUMBER :=
3177: FND_API.G_MISS_NUM
3178: , x_line_Payment_tbl OUT NOCOPY OE_Order_PUB.line_Payment_Tbl_Type
3179: , x_return_status OUT NOCOPY VARCHAR2
3180: )
3181: IS
3182: CURSOR lock_lin_Payments(p_line_id NUMBER) IS

Line 3311: ( p_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type

3307:
3308: -- Function Get_Values
3309:
3310: FUNCTION Get_Values
3311: ( p_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type
3312: , p_old_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type :=
3313: OE_Order_PUB.G_MISS_LINE_PAYMENT_REC
3314: )RETURN OE_Order_PUB.Line_Payment_Val_Rec_Type
3315: IS

Line 3312: , p_old_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type :=

3308: -- Function Get_Values
3309:
3310: FUNCTION Get_Values
3311: ( p_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type
3312: , p_old_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type :=
3313: OE_Order_PUB.G_MISS_LINE_PAYMENT_REC
3314: )RETURN OE_Order_PUB.Line_Payment_Val_Rec_Type
3315: IS
3316: l_Line_Payment_val_rec OE_Order_PUB.Line_Payment_Val_Rec_Type;

Line 3313: OE_Order_PUB.G_MISS_LINE_PAYMENT_REC

3309:
3310: FUNCTION Get_Values
3311: ( p_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type
3312: , p_old_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type :=
3313: OE_Order_PUB.G_MISS_LINE_PAYMENT_REC
3314: )RETURN OE_Order_PUB.Line_Payment_Val_Rec_Type
3315: IS
3316: l_Line_Payment_val_rec OE_Order_PUB.Line_Payment_Val_Rec_Type;
3317: --

Line 3314: )RETURN OE_Order_PUB.Line_Payment_Val_Rec_Type

3310: FUNCTION Get_Values
3311: ( p_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type
3312: , p_old_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type :=
3313: OE_Order_PUB.G_MISS_LINE_PAYMENT_REC
3314: )RETURN OE_Order_PUB.Line_Payment_Val_Rec_Type
3315: IS
3316: l_Line_Payment_val_rec OE_Order_PUB.Line_Payment_Val_Rec_Type;
3317: --
3318: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 3316: l_Line_Payment_val_rec OE_Order_PUB.Line_Payment_Val_Rec_Type;

3312: , p_old_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type :=
3313: OE_Order_PUB.G_MISS_LINE_PAYMENT_REC
3314: )RETURN OE_Order_PUB.Line_Payment_Val_Rec_Type
3315: IS
3316: l_Line_Payment_val_rec OE_Order_PUB.Line_Payment_Val_Rec_Type;
3317: --
3318: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3319: --
3320: BEGIN

Line 3359: ( p_x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type

3355:
3356: -- Procedure Get_Ids
3357:
3358: PROCEDURE Get_Ids
3359: ( p_x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
3360: , p_Line_Payment_val_rec IN OE_Order_PUB.Line_Payment_Val_Rec_Type
3361: )
3362: IS
3363:

Line 3360: , p_Line_Payment_val_rec IN OE_Order_PUB.Line_Payment_Val_Rec_Type

3356: -- Procedure Get_Ids
3357:
3358: PROCEDURE Get_Ids
3359: ( p_x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
3360: , p_Line_Payment_val_rec IN OE_Order_PUB.Line_Payment_Val_Rec_Type
3361: )
3362: IS
3363:
3364: --

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

3465:
3466: END Get_Ids;
3467:
3468: PROCEDURE Pre_Write_Process
3469: ( p_x_line_Payment_rec IN OUT NOCOPY OE_ORDER_PUB.line_Payment_rec_type,
3470: p_old_line_Payment_rec IN OE_ORDER_PUB.line_Payment_rec_type := OE_ORDER_PUB.G_MISS_LINE_PAYMENT_REC )
3471: IS
3472: l_return_status varchar2(30);
3473: l_ordered_date DATE;

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

3466: END Get_Ids;
3467:
3468: PROCEDURE Pre_Write_Process
3469: ( p_x_line_Payment_rec IN OUT NOCOPY OE_ORDER_PUB.line_Payment_rec_type,
3470: p_old_line_Payment_rec IN OE_ORDER_PUB.line_Payment_rec_type := OE_ORDER_PUB.G_MISS_LINE_PAYMENT_REC )
3471: IS
3472: l_return_status varchar2(30);
3473: l_ordered_date DATE;
3474: l_transactional_curr_code VARCHAR2(30);

Line 4111: p_x_line_rec OE_ORDER_PUB.Line_Rec_Type;

4107: x_return_status out nocopy varchar2,
4108: x_msg_count out nocopy number,
4109: x_msg_data out nocopy varchar2) is
4110: p_count number := -1;
4111: p_x_line_rec OE_ORDER_PUB.Line_Rec_Type;
4112: l_old_line_rec OE_ORDER_PUB.Line_Rec_Type;
4113: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
4114: l_return_status varchar2(30) := NULL;
4115: l_payment_type_code varchar2(30) := null;

Line 4112: l_old_line_rec OE_ORDER_PUB.Line_Rec_Type;

4108: x_msg_count out nocopy number,
4109: x_msg_data out nocopy varchar2) is
4110: p_count number := -1;
4111: p_x_line_rec OE_ORDER_PUB.Line_Rec_Type;
4112: l_old_line_rec OE_ORDER_PUB.Line_Rec_Type;
4113: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
4114: l_return_status varchar2(30) := NULL;
4115: l_payment_type_code varchar2(30) := null;
4116: l_upd_commitment number := 0;

Line 4113: l_line_rec OE_ORDER_PUB.Line_Rec_Type;

4109: x_msg_data out nocopy varchar2) is
4110: p_count number := -1;
4111: p_x_line_rec OE_ORDER_PUB.Line_Rec_Type;
4112: l_old_line_rec OE_ORDER_PUB.Line_Rec_Type;
4113: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
4114: l_return_status varchar2(30) := NULL;
4115: l_payment_type_code varchar2(30) := null;
4116: l_upd_commitment number := 0;
4117: l_upd_payment number := 0;