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 1525: ( p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type

1521:
1522: -- Procedure Complete_Record
1523:
1524: PROCEDURE Complete_Record
1525: ( p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
1526: , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type
1527: )
1528: IS
1529: --

Line 1526: , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type

1522: -- Procedure Complete_Record
1523:
1524: PROCEDURE Complete_Record
1525: ( p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
1526: , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type
1527: )
1528: IS
1529: --
1530: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1759: ( p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type

1755:
1756: -- Procedure Convert_Miss_To_Null
1757:
1758: PROCEDURE Convert_Miss_To_Null
1759: ( p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
1760: )
1761: IS
1762:
1763: --

Line 1989: ( p_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type

1985:
1986: -- Procedure Update_Row
1987:
1988: PROCEDURE Update_Row
1989: ( p_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
1990: )
1991: IS
1992: l_lock_control NUMBER;
1993: --added for notification framework

Line 2128: ( p_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type

2124:
2125: -- Procedure Insert_Row
2126:
2127: PROCEDURE Insert_Row
2128: ( p_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
2129: )
2130: IS
2131: l_lock_control NUMBER:= 1;
2132: l_index NUMBER;

Line 2330: l_new_header_Payment_rec OE_Order_PUB.Header_Payment_Rec_Type;

2326: FROM OE_PAYMENTS
2327: WHERE HEADER_ID = p_header_id
2328: AND line_id is NULL;
2329: -- added for notification framework
2330: l_new_header_Payment_rec OE_Order_PUB.Header_Payment_Rec_Type;
2331: l_index NUMBER;
2332: --
2333: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2334: --R12 CC Encryption

Line 2703: x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type

2699: -- Procedure Query_Row
2700: PROCEDURE Query_Row
2701: ( p_payment_number IN NUMBER,
2702: p_header_id IN NUMBER,
2703: x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
2704: )
2705: IS
2706: x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2707: CURSOR l_Header_Payment_csr IS

Line 2706: x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

2702: p_header_id IN NUMBER,
2703: x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
2704: )
2705: IS
2706: x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2707: CURSOR l_Header_Payment_csr IS
2708: SELECT ATTRIBUTE1
2709: , ATTRIBUTE2
2710: , ATTRIBUTE3

Line 2907: , x_header_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Header_Payment_Tbl_Type

2903: ( p_payment_number IN NUMBER :=
2904: FND_API.G_MISS_NUM
2905: , p_header_id IN NUMBER :=
2906: FND_API.G_MISS_NUM
2907: , x_header_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Header_Payment_Tbl_Type
2908: )
2909: IS
2910: l_Header_Payment_rec OE_Order_PUB.Header_Payment_Rec_Type;
2911:

Line 2910: l_Header_Payment_rec OE_Order_PUB.Header_Payment_Rec_Type;

2906: FND_API.G_MISS_NUM
2907: , x_header_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Header_Payment_Tbl_Type
2908: )
2909: IS
2910: l_Header_Payment_rec OE_Order_PUB.Header_Payment_Rec_Type;
2911:
2912: CURSOR l_Header_Payment_csr IS
2913: SELECT ATTRIBUTE1
2914: , ATTRIBUTE2

Line 3093: , p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type

3089: --
3090:
3091: PROCEDURE Lock_Row
3092: ( x_return_status OUT NOCOPY VARCHAR2
3093: , p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
3094: , p_payment_number IN NUMBER
3095: , p_header_id IN NUMBER
3096: )
3097: IS

Line 3100: l_Header_Payment_rec OE_Order_PUB.Header_Payment_Rec_Type;

3096: )
3097: IS
3098: l_payment_number NUMBER;
3099: l_header_id NUMBER;
3100: l_Header_Payment_rec OE_Order_PUB.Header_Payment_Rec_Type;
3101: l_lock_control NUMBER;
3102: --
3103: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3104: --

Line 3239: , x_header_Payment_tbl OUT NOCOPY OE_Order_PUB.header_Payment_Tbl_Type

3235: ( p_payment_number IN NUMBER :=
3236: FND_API.G_MISS_NUM
3237: , p_header_id IN NUMBER :=
3238: FND_API.G_MISS_NUM
3239: , x_header_Payment_tbl OUT NOCOPY OE_Order_PUB.header_Payment_Tbl_Type
3240: , x_return_status OUT NOCOPY VARCHAR2
3241: )
3242: IS
3243: CURSOR lock_hdr_Payments(p_header_id NUMBER) IS

Line 3372: ( p_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type

3368:
3369: -- Function Get_Values
3370:
3371: FUNCTION Get_Values
3372: ( p_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type
3373: , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type :=
3374: OE_Order_PUB.G_MISS_HEADER_Payment_REC
3375: )RETURN OE_Order_PUB.Header_Payment_Val_Rec_Type
3376: IS

Line 3373: , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type :=

3369: -- Function Get_Values
3370:
3371: FUNCTION Get_Values
3372: ( p_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type
3373: , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type :=
3374: OE_Order_PUB.G_MISS_HEADER_Payment_REC
3375: )RETURN OE_Order_PUB.Header_Payment_Val_Rec_Type
3376: IS
3377: l_Header_Payment_val_rec OE_Order_PUB.Header_Payment_Val_Rec_Type;

Line 3374: OE_Order_PUB.G_MISS_HEADER_Payment_REC

3370:
3371: FUNCTION Get_Values
3372: ( p_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type
3373: , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type :=
3374: OE_Order_PUB.G_MISS_HEADER_Payment_REC
3375: )RETURN OE_Order_PUB.Header_Payment_Val_Rec_Type
3376: IS
3377: l_Header_Payment_val_rec OE_Order_PUB.Header_Payment_Val_Rec_Type;
3378: --

Line 3375: )RETURN OE_Order_PUB.Header_Payment_Val_Rec_Type

3371: FUNCTION Get_Values
3372: ( p_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type
3373: , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type :=
3374: OE_Order_PUB.G_MISS_HEADER_Payment_REC
3375: )RETURN OE_Order_PUB.Header_Payment_Val_Rec_Type
3376: IS
3377: l_Header_Payment_val_rec OE_Order_PUB.Header_Payment_Val_Rec_Type;
3378: --
3379: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 3377: l_Header_Payment_val_rec OE_Order_PUB.Header_Payment_Val_Rec_Type;

3373: , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type :=
3374: OE_Order_PUB.G_MISS_HEADER_Payment_REC
3375: )RETURN OE_Order_PUB.Header_Payment_Val_Rec_Type
3376: IS
3377: l_Header_Payment_val_rec OE_Order_PUB.Header_Payment_Val_Rec_Type;
3378: --
3379: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3380: --
3381: BEGIN

Line 3420: ( p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type

3416:
3417: -- Procedure Get_Ids
3418:
3419: PROCEDURE Get_Ids
3420: ( p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
3421: , p_Header_Payment_val_rec IN OE_Order_PUB.Header_Payment_Val_Rec_Type
3422: )
3423: IS
3424:

Line 3421: , p_Header_Payment_val_rec IN OE_Order_PUB.Header_Payment_Val_Rec_Type

3417: -- Procedure Get_Ids
3418:
3419: PROCEDURE Get_Ids
3420: ( p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
3421: , p_Header_Payment_val_rec IN OE_Order_PUB.Header_Payment_Val_Rec_Type
3422: )
3423: IS
3424:
3425: --

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

3555:
3556: END Get_Ids;
3557:
3558: PROCEDURE Pre_Write_Process
3559: ( p_x_header_Payment_rec IN OUT NOCOPY OE_ORDER_PUB.header_Payment_rec_type,
3560: p_old_header_Payment_rec IN OE_ORDER_PUB.header_Payment_rec_type := OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC )
3561: IS
3562: l_return_status varchar2(30);
3563: l_ordered_date DATE;

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

3556: END Get_Ids;
3557:
3558: PROCEDURE Pre_Write_Process
3559: ( p_x_header_Payment_rec IN OUT NOCOPY OE_ORDER_PUB.header_Payment_rec_type,
3560: p_old_header_Payment_rec IN OE_ORDER_PUB.header_Payment_rec_type := OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC )
3561: IS
3562: l_return_status varchar2(30);
3563: l_ordered_date DATE;
3564: l_transactional_curr_code VARCHAR2(30);

Line 4174: p_x_header_rec OE_ORDER_PUB.Header_Rec_Type;

4170: x_return_status out nocopy varchar2,
4171: x_msg_count out nocopy number,
4172: x_msg_data out nocopy varchar2) is
4173: p_count number := -1;
4174: p_x_header_rec OE_ORDER_PUB.Header_Rec_Type;
4175: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
4176: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
4177: l_return_status varchar2(30) := NULL;
4178:

Line 4175: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;

4171: x_msg_count out nocopy number,
4172: x_msg_data out nocopy varchar2) is
4173: p_count number := -1;
4174: p_x_header_rec OE_ORDER_PUB.Header_Rec_Type;
4175: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
4176: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
4177: l_return_status varchar2(30) := NULL;
4178:
4179: Begin

Line 4176: l_header_rec OE_ORDER_PUB.Header_Rec_Type;

4172: x_msg_data out nocopy varchar2) is
4173: p_count number := -1;
4174: p_x_header_rec OE_ORDER_PUB.Header_Rec_Type;
4175: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
4176: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
4177: l_return_status varchar2(30) := NULL;
4178:
4179: Begin
4180: