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: (
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: (
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: );
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: (
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;