1 PACKAGE QP_PRICE_BOOK_PVT AS
2 /*$Header: QPXVGPBS.pls 120.2.12010000.2 2008/10/15 13:33:22 dnema ship $*/
3
4 TYPE NUMBER_TYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
5 TYPE PLS_INTEGER_TYPE IS TABLE OF PLS_INTEGER INDEX BY BINARY_INTEGER;
6 TYPE VARCHAR3_TYPE IS TABLE OF VARCHAR2(3) INDEX BY BINARY_INTEGER;
7 TYPE VARCHAR30_TYPE IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
8 TYPE VARCHAR_TYPE IS TABLE OF VARCHAR2(240) INDEX BY BINARY_INTEGER;
9 TYPE VARCHAR2000_TYPE IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
10 TYPE DATE_TYPE IS TABLE OF DATE INDEX BY BINARY_INTEGER;
11 TYPE FLAG_TYPE IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
12
13 G_pb_Processor_Batchsize PLS_INTEGER; --bug 7453115
14
15 rows NATURAL := 5000;
16
17 PROCEDURE Generate_Publish_Price_Book(p_pb_input_header_id IN NUMBER,
18 x_request_id OUT NOCOPY NUMBER,
19 x_return_status OUT NOCOPY VARCHAR2,
20 x_retcode OUT NOCOPY NUMBER,
21 x_err_buf OUT NOCOPY VARCHAR2);
22
23 PROCEDURE Price_Book_Conc_Pgm(retcode OUT NOCOPY NUMBER,
24 errbuf OUT NOCOPY VARCHAR2,
25 p_pb_input_header_id IN NUMBER,
26 p_customer_id IN NUMBER := NULL,
27 p_price_book_header_id IN NUMBER := NULL,
28 p_spawned_request IN VARCHAR2 := 'N');
29
30 END QP_PRICE_BOOK_PVT;