PACKAGE: APPS.OKC_QP_UPGRADE_PUB

Source

1 PACKAGE OKC_QP_UPGRADE_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKCPQPUS.pls 120.0 2005/05/25 22:32:43 appldev noship $ */
3 
4 PROCEDURE upgrade_contracts
5 (
6  errbuf                   OUT NOCOPY  VARCHAR2,
7  retcode                  OUT NOCOPY  VARCHAR2,
8  p_dflt_price_list_id     IN   NUMBER,
9  p_category_code          IN   okc_subclasses_b.code%TYPE DEFAULT NULL,
10  p_enable_qp_profile      IN   VARCHAR2  DEFAULT 'N',
11  p_rpt_upgrade_status     IN   VARCHAR2  DEFAULT 'N'
12 );
13 
14 PROCEDURE ins_summary_rec;
15 
16 PROCEDURE ins_category_rec
17 (
18  p_category_code  IN   okc_subclasses_b.code%TYPE
19 );
20 
21 PROCEDURE start_category_upgrade
22 (
23  p_category_code          IN   okc_subclasses_b.code%TYPE
24 );
25 
26 PROCEDURE ins_contract_rec
27 (
28  p_category_code            IN   okc_subclasses_b.code%TYPE,
29  p_chr_id                   IN   okc_k_headers_b.id%TYPE ,
30  p_contract_number          IN   okc_k_headers_b.contract_number%TYPE,
31  p_contract_number_modifier IN   okc_k_headers_b.contract_number_modifier%TYPE
32 );
33 
34 PROCEDURE call_qp_upgrade
35 (
36  p_category_code          IN   okc_subclasses_b.code%TYPE DEFAULT NULL
37 );
38 
39 PROCEDURE upd_category_rec
40 (
41  p_category_code  IN   okc_subclasses_b.code%TYPE,
42  p_status         IN   varchar2  DEFAULT 'N'
43 );
44 
45 PROCEDURE upd_summary_rec;
46 
47 PROCEDURE process_report;
48 
49 PROCEDURE upgrade_status_rpt;
50 
51 FUNCTION check_qp_profile RETURN VARCHAR2;
52 
53 FUNCTION compute_estimated_amt
54 (
55  p_chr_id    IN okc_k_headers_b.id%TYPE
56 ) RETURN NUMBER;
57 
58 PROCEDURE create_manual_adjustment
59 (
60  p_chr_id    IN okc_k_headers_b.id%TYPE
61 );
62 
63 FUNCTION check_modifier RETURN VARCHAR2;
64 
65 
66 END OKC_QP_UPGRADE_PUB; -- Package Specification OKC_QP_UPGRADE_PUB