DBA Data[Home] [Help]

APPS.OE_HEADER_PAYMENT_UTIL dependencies on OE_ORDER_PUB

Line 79: ( p_HEADER_Payment_rec IN OE_Order_PUB.HEADER_PAYMENT_Rec_Type

75:
76: END G_MISS_OE_AK_HPAYMENT_REC;
77:
78: PROCEDURE API_Rec_To_Rowtype_Rec
79: ( p_HEADER_Payment_rec IN OE_Order_PUB.HEADER_PAYMENT_Rec_Type
80: , x_rowtype_rec IN OUT NOCOPY OE_AK_HEADER_PAYMENTS_V%ROWTYPE
81: ) IS
82: --
83: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 142: , x_api_rec IN OUT NOCOPY OE_Order_PUB.HEADER_Payment_Rec_Type

138:
139:
140: PROCEDURE Rowtype_Rec_To_API_Rec
141: ( p_record IN OE_AK_HEADER_PaymentS_V%ROWTYPE
142: , x_api_rec IN OUT NOCOPY OE_Order_PUB.HEADER_Payment_Rec_Type
143: ) IS
144: --
145: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
146: --

Line 801: , p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type

797: END Clear_Dependent_Attr;
798:
799: PROCEDURE Clear_Dependent_Attr
800: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
801: , p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
802: , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type :=
803: OE_Order_PUB.G_MISS_HEADER_Payment_REC
804: )
805: IS

Line 802: , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type :=

798:
799: PROCEDURE Clear_Dependent_Attr
800: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
801: , p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
802: , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type :=
803: OE_Order_PUB.G_MISS_HEADER_Payment_REC
804: )
805: IS
806: l_Header_Payment_rec OE_AK_HEADER_PaymentS_V%ROWTYPE;

Line 803: OE_Order_PUB.G_MISS_HEADER_Payment_REC

799: PROCEDURE Clear_Dependent_Attr
800: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
801: , p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
802: , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type :=
803: OE_Order_PUB.G_MISS_HEADER_Payment_REC
804: )
805: IS
806: l_Header_Payment_rec OE_AK_HEADER_PaymentS_V%ROWTYPE;
807: l_old_Header_Payment_rec OE_AK_HEADER_PaymentS_V%ROWTYPE;

Line 917: ( p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type

913:
914: -- Procedure Apply_Attribute_Changes
915:
916: PROCEDURE Apply_Attribute_Changes
917: ( p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
918: , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type :=
919: OE_Order_PUB.G_MISS_HEADER_Payment_REC
920: )
921: IS

Line 918: , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type :=

914: -- Procedure Apply_Attribute_Changes
915:
916: PROCEDURE Apply_Attribute_Changes
917: ( p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
918: , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type :=
919: OE_Order_PUB.G_MISS_HEADER_Payment_REC
920: )
921: IS
922: l_return_status Varchar2(10);

Line 919: OE_Order_PUB.G_MISS_HEADER_Payment_REC

915:
916: PROCEDURE Apply_Attribute_Changes
917: ( p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
918: , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type :=
919: OE_Order_PUB.G_MISS_HEADER_Payment_REC
920: )
921: IS
922: l_return_status Varchar2(10);
923: --

Line 1484: ( p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type

1480:
1481: -- Procedure Complete_Record
1482:
1483: PROCEDURE Complete_Record
1484: ( p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
1485: , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type
1486: )
1487: IS
1488: --

Line 1485: , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type

1481: -- Procedure Complete_Record
1482:
1483: PROCEDURE Complete_Record
1484: ( p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
1485: , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type
1486: )
1487: IS
1488: --
1489: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1700: ( p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type

1696:
1697: -- Procedure Convert_Miss_To_Null
1698:
1699: PROCEDURE Convert_Miss_To_Null
1700: ( p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
1701: )
1702: IS
1703:
1704: --

Line 1912: ( p_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type

1908:
1909: -- Procedure Update_Row
1910:
1911: PROCEDURE Update_Row
1912: ( p_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
1913: )
1914: IS
1915: l_lock_control NUMBER;
1916: --added for notification framework

Line 2046: ( p_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type

2042:
2043: -- Procedure Insert_Row
2044:
2045: PROCEDURE Insert_Row
2046: ( p_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
2047: )
2048: IS
2049: l_lock_control NUMBER:= 1;
2050: l_index NUMBER;

Line 2244: l_new_header_Payment_rec OE_Order_PUB.Header_Payment_Rec_Type;

2240: FROM OE_PAYMENTS
2241: WHERE HEADER_ID = p_header_id
2242: AND line_id is NULL;
2243: -- added for notification framework
2244: l_new_header_Payment_rec OE_Order_PUB.Header_Payment_Rec_Type;
2245: l_index NUMBER;
2246: --
2247: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2248: --R12 CC Encryption

Line 2617: x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type

2613: -- Procedure Query_Row
2614: PROCEDURE Query_Row
2615: ( p_payment_number IN NUMBER,
2616: p_header_id IN NUMBER,
2617: x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
2618: )
2619: IS
2620: x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2621: CURSOR l_Header_Payment_csr IS

Line 2620: x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

2616: p_header_id IN NUMBER,
2617: x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
2618: )
2619: IS
2620: x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2621: CURSOR l_Header_Payment_csr IS
2622: SELECT ATTRIBUTE1
2623: , ATTRIBUTE2
2624: , ATTRIBUTE3

Line 2819: , x_header_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Header_Payment_Tbl_Type

2815: ( p_payment_number IN NUMBER :=
2816: FND_API.G_MISS_NUM
2817: , p_header_id IN NUMBER :=
2818: FND_API.G_MISS_NUM
2819: , x_header_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Header_Payment_Tbl_Type
2820: )
2821: IS
2822: l_Header_Payment_rec OE_Order_PUB.Header_Payment_Rec_Type;
2823:

Line 2822: l_Header_Payment_rec OE_Order_PUB.Header_Payment_Rec_Type;

2818: FND_API.G_MISS_NUM
2819: , x_header_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Header_Payment_Tbl_Type
2820: )
2821: IS
2822: l_Header_Payment_rec OE_Order_PUB.Header_Payment_Rec_Type;
2823:
2824: CURSOR l_Header_Payment_csr IS
2825: SELECT ATTRIBUTE1
2826: , ATTRIBUTE2

Line 3003: , p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type

2999: --
3000:
3001: PROCEDURE Lock_Row
3002: ( x_return_status OUT NOCOPY VARCHAR2
3003: , p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
3004: , p_payment_number IN NUMBER
3005: , p_header_id IN NUMBER
3006: )
3007: IS

Line 3010: l_Header_Payment_rec OE_Order_PUB.Header_Payment_Rec_Type;

3006: )
3007: IS
3008: l_payment_number NUMBER;
3009: l_header_id NUMBER;
3010: l_Header_Payment_rec OE_Order_PUB.Header_Payment_Rec_Type;
3011: l_lock_control NUMBER;
3012: --
3013: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3014: --

Line 3149: , x_header_Payment_tbl OUT NOCOPY OE_Order_PUB.header_Payment_Tbl_Type

3145: ( p_payment_number IN NUMBER :=
3146: FND_API.G_MISS_NUM
3147: , p_header_id IN NUMBER :=
3148: FND_API.G_MISS_NUM
3149: , x_header_Payment_tbl OUT NOCOPY OE_Order_PUB.header_Payment_Tbl_Type
3150: , x_return_status OUT NOCOPY VARCHAR2
3151: )
3152: IS
3153: CURSOR lock_hdr_Payments(p_header_id NUMBER) IS

Line 3282: ( p_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type

3278:
3279: -- Function Get_Values
3280:
3281: FUNCTION Get_Values
3282: ( p_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type
3283: , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type :=
3284: OE_Order_PUB.G_MISS_HEADER_Payment_REC
3285: )RETURN OE_Order_PUB.Header_Payment_Val_Rec_Type
3286: IS

Line 3283: , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type :=

3279: -- Function Get_Values
3280:
3281: FUNCTION Get_Values
3282: ( p_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type
3283: , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type :=
3284: OE_Order_PUB.G_MISS_HEADER_Payment_REC
3285: )RETURN OE_Order_PUB.Header_Payment_Val_Rec_Type
3286: IS
3287: l_Header_Payment_val_rec OE_Order_PUB.Header_Payment_Val_Rec_Type;

Line 3284: OE_Order_PUB.G_MISS_HEADER_Payment_REC

3280:
3281: FUNCTION Get_Values
3282: ( p_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type
3283: , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type :=
3284: OE_Order_PUB.G_MISS_HEADER_Payment_REC
3285: )RETURN OE_Order_PUB.Header_Payment_Val_Rec_Type
3286: IS
3287: l_Header_Payment_val_rec OE_Order_PUB.Header_Payment_Val_Rec_Type;
3288: --

Line 3285: )RETURN OE_Order_PUB.Header_Payment_Val_Rec_Type

3281: FUNCTION Get_Values
3282: ( p_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type
3283: , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type :=
3284: OE_Order_PUB.G_MISS_HEADER_Payment_REC
3285: )RETURN OE_Order_PUB.Header_Payment_Val_Rec_Type
3286: IS
3287: l_Header_Payment_val_rec OE_Order_PUB.Header_Payment_Val_Rec_Type;
3288: --
3289: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 3287: l_Header_Payment_val_rec OE_Order_PUB.Header_Payment_Val_Rec_Type;

3283: , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type :=
3284: OE_Order_PUB.G_MISS_HEADER_Payment_REC
3285: )RETURN OE_Order_PUB.Header_Payment_Val_Rec_Type
3286: IS
3287: l_Header_Payment_val_rec OE_Order_PUB.Header_Payment_Val_Rec_Type;
3288: --
3289: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3290: --
3291: BEGIN

Line 3330: ( p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type

3326:
3327: -- Procedure Get_Ids
3328:
3329: PROCEDURE Get_Ids
3330: ( p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
3331: , p_Header_Payment_val_rec IN OE_Order_PUB.Header_Payment_Val_Rec_Type
3332: )
3333: IS
3334:

Line 3331: , p_Header_Payment_val_rec IN OE_Order_PUB.Header_Payment_Val_Rec_Type

3327: -- Procedure Get_Ids
3328:
3329: PROCEDURE Get_Ids
3330: ( p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
3331: , p_Header_Payment_val_rec IN OE_Order_PUB.Header_Payment_Val_Rec_Type
3332: )
3333: IS
3334:
3335: --

Line 3440: ( p_x_header_Payment_rec IN OUT NOCOPY OE_ORDER_PUB.header_Payment_rec_type,

3436:
3437: END Get_Ids;
3438:
3439: PROCEDURE Pre_Write_Process
3440: ( p_x_header_Payment_rec IN OUT NOCOPY OE_ORDER_PUB.header_Payment_rec_type,
3441: p_old_header_Payment_rec IN OE_ORDER_PUB.header_Payment_rec_type := OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC )
3442: IS
3443: l_return_status varchar2(30);
3444: l_ordered_date DATE;

Line 3441: p_old_header_Payment_rec IN OE_ORDER_PUB.header_Payment_rec_type := OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC )

3437: END Get_Ids;
3438:
3439: PROCEDURE Pre_Write_Process
3440: ( p_x_header_Payment_rec IN OUT NOCOPY OE_ORDER_PUB.header_Payment_rec_type,
3441: p_old_header_Payment_rec IN OE_ORDER_PUB.header_Payment_rec_type := OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC )
3442: IS
3443: l_return_status varchar2(30);
3444: l_ordered_date DATE;
3445: l_transactional_curr_code VARCHAR2(30);

Line 4053: p_x_header_rec OE_ORDER_PUB.Header_Rec_Type;

4049: x_return_status out nocopy varchar2,
4050: x_msg_count out nocopy number,
4051: x_msg_data out nocopy varchar2) is
4052: p_count number := -1;
4053: p_x_header_rec OE_ORDER_PUB.Header_Rec_Type;
4054: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
4055: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
4056: l_return_status varchar2(30) := NULL;
4057:

Line 4054: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;

4050: x_msg_count out nocopy number,
4051: x_msg_data out nocopy varchar2) is
4052: p_count number := -1;
4053: p_x_header_rec OE_ORDER_PUB.Header_Rec_Type;
4054: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
4055: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
4056: l_return_status varchar2(30) := NULL;
4057:
4058: Begin

Line 4055: l_header_rec OE_ORDER_PUB.Header_Rec_Type;

4051: x_msg_data out nocopy varchar2) is
4052: p_count number := -1;
4053: p_x_header_rec OE_ORDER_PUB.Header_Rec_Type;
4054: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
4055: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
4056: l_return_status varchar2(30) := NULL;
4057:
4058: Begin
4059: