PACKAGE: APPS.QP_LIST_UPGRADE_UTIL_PVT

Source

1 package qp_list_upgrade_util_pvt AUTHID CURRENT_USER as
2 /* $Header: QPXVUPLS.pls 120.0 2005/06/02 00:13:37 appldev noship $ */
3 
4 Type pricing_attr_rec_type is RECORD
5 (
6   l_pricing_context varchar2(30) := NULL,
7   l_pricing_attr varchar2(30) := NULL,
8   l_pricing_attr_value_from varchar2(240) := NULL,
9   l_pricing_attr_value_to varchar2(240) := NULL);
10 
11 Type pricing_attr_tbl_type is table of pricing_attr_rec_type
12   INDEX BY BINARY_INTEGER;
13 
14 Type prc_list_map_rec_type is RECORD
15 (
16   old_price_list_id number,
17   old_price_list_line_id number,
18   new_list_header_id number,
19   new_list_line_id number,
20   secondary_price_list_id number,
21   db_flag varchar2(1) := 'N'
22 );
23 
24 Type prc_list_map_tbl_type is table of prc_list_map_rec_type
25   INDEX BY BINARY_INTEGER;
26 
27 procedure upgrade_flex_structures;
28 
29 procedure  create_parallel_lines
30        (  l_workers IN number := 5,
31           p_batchsize in number := 5000);
32 
33 PROCEDURE  CREATE_PARALLEL_SLABS
34        (  L_WORKERS IN NUMBER := 5);
35 
36 procedure create_price_list(p_batchsize in number := 5000,
37                             p_worker in number := 1);
38 
39 procedure create_list_lines(p_batchsize in number := 5000,
40                             l_worker in number := 1);
41 
42 
43 end qp_list_upgrade_util_pvt;