1 PACKAGE ASO_BI_QOT_PC_PVT AUTHID CURRENT_USER AS
2 /* $Header: asovbiqpcs.pls 120.2 2005/09/16 04:41:47 kedukull noship $*/
3
4 PROCEDURE PCAll(p_conv_rate IN NUMBER
5 ,p_record_type_id IN NUMBER
6 ,p_sg_id_num IN NUMBER
7 ,p_sr_id_num IN NUMBER
8 ,p_asof_date IN DATE
9 ,p_priorasof_date IN DATE
10 ,p_fdcp_date IN DATE
11 ,p_fdpp_date IN DATE
12 ,p_fdcp_date_j IN NUMBER
13 ,p_fdpp_date_j IN NUMBER);
14
15 PROCEDURE PCSPrA(p_asof_date IN DATE
16 ,p_priorasof_date IN DATE
17 ,p_fdcp_date IN DATE
18 ,p_fdpp_date IN DATE
19 ,p_conv_rate IN NUMBER
20 ,p_record_type_id IN NUMBER
21 ,p_sg_id_num IN NUMBER
22 ,p_sr_id_num IN NUMBER
23 ,p_fdcp_date_j IN NUMBER
24 ,p_fdpp_date_j IN NUMBER
25 ,p_product_cat IN NUMBER);
26
27 PROCEDURE PCAPrS(p_asof_date IN DATE
28 ,p_priorasof_date IN DATE
29 ,p_fdcp_date IN DATE
30 ,p_fdpp_date IN DATE
31 ,p_conv_rate IN NUMBER
32 ,p_record_type_id IN NUMBER
33 ,p_sg_id_num IN NUMBER
34 ,p_sr_id_num IN NUMBER
35 ,p_fdcp_date_j IN NUMBER
36 ,p_fdpp_date_j IN NUMBER
37 ,p_product_id IN VARCHAR2);
38
39 PROCEDURE PCSPrS(p_asof_date IN DATE
40 ,p_priorasof_date IN DATE
41 ,p_fdcp_date IN DATE
42 ,p_fdpp_date IN DATE
43 ,p_conv_rate IN NUMBER
44 ,p_record_type_id IN NUMBER
45 ,p_sg_id_num IN NUMBER
46 ,p_sr_id_num IN NUMBER
47 ,p_fdcp_date_j IN NUMBER
48 ,p_fdpp_date_j IN NUMBER
49 ,p_product_cat IN NUMBER
50 ,p_product_id IN VARCHAR2);
51
52 PROCEDURE PCAllProd(p_conv_rate IN NUMBER
53 ,p_record_type_id IN NUMBER
54 ,p_sg_id_num IN NUMBER
55 ,p_sr_id_num IN NUMBER
56 ,p_fdcp_date_j IN NUMBER
57 ,p_fdpp_date_j IN NUMBER
58 ,p_asof_date IN DATE
59 ,p_priorasof_date IN DATE
60 ,p_fdcp_date IN DATE
61 ,p_fdpp_date IN DATE);
62
63 PROCEDURE PCSPrAProd(p_asof_date IN DATE
64 ,p_priorasof_date IN DATE
65 ,p_fdcp_date IN DATE
66 ,p_fdpp_date IN DATE
67 ,p_conv_rate IN NUMBER
68 ,p_record_type_id IN NUMBER
69 ,p_sg_id_num IN NUMBER
70 ,p_sr_id_num IN NUMBER
71 ,p_fdcp_date_j IN NUMBER
72 ,p_fdpp_date_j IN NUMBER
73 ,p_product_cat IN NUMBER);
74
75 PROCEDURE PCAPrSProd(p_asof_date IN DATE
76 ,p_priorasof_date IN DATE
77 ,p_fdcp_date IN DATE
78 ,p_fdpp_date IN DATE
79 ,p_conv_rate IN NUMBER
80 ,p_record_type_id IN NUMBER
81 ,p_sg_id_num IN NUMBER
82 ,p_sr_id_num IN NUMBER
83 ,p_fdcp_date_j IN NUMBER
84 ,p_fdpp_date_j IN NUMBER
85 ,p_product_id IN VARCHAR2);
86
87 PROCEDURE PCSPrSProd(p_asof_date IN DATE
88 ,p_priorasof_date IN DATE
89 ,p_fdcp_date IN DATE
90 ,p_fdpp_date IN DATE
91 ,p_conv_rate IN NUMBER
92 ,p_record_type_id IN NUMBER
93 ,p_sg_id_num IN NUMBER
94 ,p_sr_id_num IN NUMBER
95 ,p_fdcp_date_j IN NUMBER
96 ,p_fdpp_date_j IN NUMBER
97 ,p_product_cat IN NUMBER
98 ,p_product_id IN VARCHAR2);
99 END;