[Home] [Help]
PACKAGE: APPS.QP_BULK_PREQ_GRP
Source
1 PACKAGE QP_BULK_PREQ_GRP AUTHID CURRENT_USER AS
2 /* $Header: QPBGPRES.pls 120.2 2005/08/19 17:57:09 spgopal noship $ */
3
4
5 G_header_tbl QP_PREQ_GRP.number_type;
6
7 G_header_rec OE_BULK_ORDER_PVT.HEADER_REC_TYPE;
8 G_line_rec OE_WSH_BULK_GRP.Line_Rec_Type;
9
10 G_HVOP_Pricing_ON VARCHAR2(1) := 'N';
11
12 G_line_index QP_PREQ_GRP.number_type;
13 G_attr_type QP_PREQ_GRP.varchar_type;
14 G_attr_context QP_PREQ_GRP.varchar_type;
15 G_attr_attr QP_PREQ_GRP.varchar_type;
16 G_attr_value QP_PREQ_GRP.varchar_type;
17 G_validated_flag QP_PREQ_GRP.flag_type;
18
19
20 l_debug VARCHAR2(1);
21
22
23 Procedure Bulk_insert_lines(p_header_rec OE_BULK_ORDER_PVT.HEADER_REC_TYPE,
24 p_line_rec IN OE_WSH_BULK_GRP.Line_Rec_Type,
25 p_org_id IN NUMBER DEFAULT NULL, --added for moac
26 x_return_status OUT NOCOPY VARCHAR2,
27 x_return_status_text OUT NOCOPY VARCHAR2);
28
29 Procedure Bulk_insert_adj(x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
30 x_return_status_text OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
31
32 END QP_BULK_PREQ_GRP;