DBA Data[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;