DBA Data[Home] [Help]

APPS.OE_LINE_ACK_UTIL dependencies on OE_ORDER_PUB

Line 83: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type

79: END Update_Header_Ack_Code;
80:
81:
82: PROCEDURE Insert_Row
83: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
84: , p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type
85: , p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type
86: , p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type
87: , p_buyer_seller_flag IN VARCHAR2

Line 84: , p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type

80:
81:
82: PROCEDURE Insert_Row
83: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
84: , p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type
85: , p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type
86: , p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type
87: , p_buyer_seller_flag IN VARCHAR2
88: , p_reject_order IN VARCHAR2

Line 85: , p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type

81:
82: PROCEDURE Insert_Row
83: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
84: , p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type
85: , p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type
86: , p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type
87: , p_buyer_seller_flag IN VARCHAR2
88: , p_reject_order IN VARCHAR2
89: , p_ack_type IN VARCHAR2 := NULL

Line 86: , p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type

82: PROCEDURE Insert_Row
83: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
84: , p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type
85: , p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type
86: , p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type
87: , p_buyer_seller_flag IN VARCHAR2
88: , p_reject_order IN VARCHAR2
89: , p_ack_type IN VARCHAR2 := NULL
90: , x_return_status OUT NOCOPY VARCHAR2

Line 93: l_line_rec OE_Order_Pub.Line_Rec_Type;

89: , p_ack_type IN VARCHAR2 := NULL
90: , x_return_status OUT NOCOPY VARCHAR2
91: )
92: IS
93: l_line_rec OE_Order_Pub.Line_Rec_Type;
94: l_line_val_rec OE_Order_Pub.Line_Val_Rec_Type;
95: l_order_source_id NUMBER;
96: l_count NUMBER;
97: I BINARY_INTEGER;

Line 94: l_line_val_rec OE_Order_Pub.Line_Val_Rec_Type;

90: , x_return_status OUT NOCOPY VARCHAR2
91: )
92: IS
93: l_line_rec OE_Order_Pub.Line_Rec_Type;
94: l_line_val_rec OE_Order_Pub.Line_Val_Rec_Type;
95: l_order_source_id NUMBER;
96: l_count NUMBER;
97: I BINARY_INTEGER;
98: l_error_flag Varchar2(1);

Line 1676: ( p_line_tbl In OE_Order_Pub.Line_Tbl_Type,

1672: End Extend_Line_Rec;
1673:
1674:
1675: Procedure Insert_Row
1676: ( p_line_tbl In OE_Order_Pub.Line_Tbl_Type,
1677: p_old_line_tbl In OE_Order_Pub.Line_Tbl_Type,
1678: x_return_status Out NOCOPY /* file.sql.39 change */ Varchar2
1679: )
1680:

Line 1677: p_old_line_tbl In OE_Order_Pub.Line_Tbl_Type,

1673:
1674:
1675: Procedure Insert_Row
1676: ( p_line_tbl In OE_Order_Pub.Line_Tbl_Type,
1677: p_old_line_tbl In OE_Order_Pub.Line_Tbl_Type,
1678: x_return_status Out NOCOPY /* file.sql.39 change */ Varchar2
1679: )
1680:
1681: Is

Line 1683: l_line_tbl OE_Order_Pub.Line_Tbl_Type := p_line_tbl;

1679: )
1680:
1681: Is
1682:
1683: l_line_tbl OE_Order_Pub.Line_Tbl_Type := p_line_tbl;
1684: l_line_acks_rec OE_Update_Ack_Util.Line_Rec_Type;
1685: l_count Number;
1686: i Pls_Integer;
1687: k Pls_Integer := 0;