DBA Data[Home] [Help]

APPS.OE_HEADER_ACK_UTIL dependencies on OE_ORDER_PUB

Line 79: ( p_header_rec IN OE_Order_Pub.Header_Rec_Type

75: END GET_ACK_CODE;
76: -- End GET_ACK_CODE }
77:
78: PROCEDURE Insert_Row
79: ( p_header_rec IN OE_Order_Pub.Header_Rec_Type
80: , p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type
81: , p_old_header_rec IN OE_Order_Pub.Header_Rec_Type
82: , p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type
83: , p_reject_order IN VARCHAR2

Line 80: , p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type

76: -- End GET_ACK_CODE }
77:
78: PROCEDURE Insert_Row
79: ( p_header_rec IN OE_Order_Pub.Header_Rec_Type
80: , p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type
81: , p_old_header_rec IN OE_Order_Pub.Header_Rec_Type
82: , p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type
83: , p_reject_order IN VARCHAR2
84: , p_ack_type IN VARCHAR2 := NULL

Line 81: , p_old_header_rec IN OE_Order_Pub.Header_Rec_Type

77:
78: PROCEDURE Insert_Row
79: ( p_header_rec IN OE_Order_Pub.Header_Rec_Type
80: , p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type
81: , p_old_header_rec IN OE_Order_Pub.Header_Rec_Type
82: , p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type
83: , p_reject_order IN VARCHAR2
84: , p_ack_type IN VARCHAR2 := NULL
85: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 82: , p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type

78: PROCEDURE Insert_Row
79: ( p_header_rec IN OE_Order_Pub.Header_Rec_Type
80: , p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type
81: , p_old_header_rec IN OE_Order_Pub.Header_Rec_Type
82: , p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type
83: , p_reject_order IN VARCHAR2
84: , p_ack_type IN VARCHAR2 := NULL
85: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
86: )

Line 88: l_header_rec OE_Order_Pub.Header_Rec_Type;

84: , p_ack_type IN VARCHAR2 := NULL
85: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
86: )
87: IS
88: l_header_rec OE_Order_Pub.Header_Rec_Type;
89: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
90:
91: l_count NUMBER;
92:

Line 89: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;

85: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
86: )
87: IS
88: l_header_rec OE_Order_Pub.Header_Rec_Type;
89: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
90:
91: l_count NUMBER;
92:
93: BEGIN

Line 837: (p_header_rec In OE_Order_Pub.Header_Rec_Type,

833: END Insert_Row;
834:
835:
836: Procedure Insert_Row
837: (p_header_rec In OE_Order_Pub.Header_Rec_Type,
838: x_ack_type Out Nocopy Varchar2,
839: x_return_status Out Nocopy Varchar2
840: )
841: Is

Line 843: l_header_rec OE_Order_Pub.Header_Rec_Type := p_header_rec;

839: x_return_status Out Nocopy Varchar2
840: )
841: Is
842:
843: l_header_rec OE_Order_Pub.Header_Rec_Type := p_header_rec;
844: l_count Number;
845: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
846: l_ack_type Varchar2(3);
847: