1: Package OKC_COPY_CONTRACT_PUB AS
2: /*$Header: OKCPCPYS.pls 120.2.12010000.2 2008/10/24 08:01:17 ssreekum ship $*/
3:
4: SUBTYPE chrv_rec_type IS OKC_COPY_CONTRACT_PVT.chrv_rec_type;
5: SUBTYPE chrv_tbl_type IS OKC_COPY_CONTRACT_PVT.chrv_tbl_type;
6: SUBTYPE clev_rec_type IS OKC_COPY_CONTRACT_PVT.clev_rec_type;
7: SUBTYPE clev_tbl_type IS OKC_COPY_CONTRACT_PVT.clev_tbl_type;
8: SUBTYPE cacv_rec_type IS OKC_COPY_CONTRACT_PVT.cacv_rec_type;
1: Package OKC_COPY_CONTRACT_PUB AS
2: /*$Header: OKCPCPYS.pls 120.2.12010000.2 2008/10/24 08:01:17 ssreekum ship $*/
3:
4: SUBTYPE chrv_rec_type IS OKC_COPY_CONTRACT_PVT.chrv_rec_type;
5: SUBTYPE chrv_tbl_type IS OKC_COPY_CONTRACT_PVT.chrv_tbl_type;
6: SUBTYPE clev_rec_type IS OKC_COPY_CONTRACT_PVT.clev_rec_type;
7: SUBTYPE clev_tbl_type IS OKC_COPY_CONTRACT_PVT.clev_tbl_type;
8: SUBTYPE cacv_rec_type IS OKC_COPY_CONTRACT_PVT.cacv_rec_type;
9: SUBTYPE cacv_tbl_type IS OKC_COPY_CONTRACT_PVT.cacv_tbl_type;
2: /*$Header: OKCPCPYS.pls 120.2.12010000.2 2008/10/24 08:01:17 ssreekum ship $*/
3:
4: SUBTYPE chrv_rec_type IS OKC_COPY_CONTRACT_PVT.chrv_rec_type;
5: SUBTYPE chrv_tbl_type IS OKC_COPY_CONTRACT_PVT.chrv_tbl_type;
6: SUBTYPE clev_rec_type IS OKC_COPY_CONTRACT_PVT.clev_rec_type;
7: SUBTYPE clev_tbl_type IS OKC_COPY_CONTRACT_PVT.clev_tbl_type;
8: SUBTYPE cacv_rec_type IS OKC_COPY_CONTRACT_PVT.cacv_rec_type;
9: SUBTYPE cacv_tbl_type IS OKC_COPY_CONTRACT_PVT.cacv_tbl_type;
10: SUBTYPE cpsv_rec_type IS OKC_COPY_CONTRACT_PVT.cpsv_rec_type;
3:
4: SUBTYPE chrv_rec_type IS OKC_COPY_CONTRACT_PVT.chrv_rec_type;
5: SUBTYPE chrv_tbl_type IS OKC_COPY_CONTRACT_PVT.chrv_tbl_type;
6: SUBTYPE clev_rec_type IS OKC_COPY_CONTRACT_PVT.clev_rec_type;
7: SUBTYPE clev_tbl_type IS OKC_COPY_CONTRACT_PVT.clev_tbl_type;
8: SUBTYPE cacv_rec_type IS OKC_COPY_CONTRACT_PVT.cacv_rec_type;
9: SUBTYPE cacv_tbl_type IS OKC_COPY_CONTRACT_PVT.cacv_tbl_type;
10: SUBTYPE cpsv_rec_type IS OKC_COPY_CONTRACT_PVT.cpsv_rec_type;
11: SUBTYPE cpsv_tbl_type IS OKC_COPY_CONTRACT_PVT.cpsv_tbl_type;
4: SUBTYPE chrv_rec_type IS OKC_COPY_CONTRACT_PVT.chrv_rec_type;
5: SUBTYPE chrv_tbl_type IS OKC_COPY_CONTRACT_PVT.chrv_tbl_type;
6: SUBTYPE clev_rec_type IS OKC_COPY_CONTRACT_PVT.clev_rec_type;
7: SUBTYPE clev_tbl_type IS OKC_COPY_CONTRACT_PVT.clev_tbl_type;
8: SUBTYPE cacv_rec_type IS OKC_COPY_CONTRACT_PVT.cacv_rec_type;
9: SUBTYPE cacv_tbl_type IS OKC_COPY_CONTRACT_PVT.cacv_tbl_type;
10: SUBTYPE cpsv_rec_type IS OKC_COPY_CONTRACT_PVT.cpsv_rec_type;
11: SUBTYPE cpsv_tbl_type IS OKC_COPY_CONTRACT_PVT.cpsv_tbl_type;
12: SUBTYPE rulv_rec_type IS OKC_COPY_CONTRACT_PVT.rulv_rec_type;
5: SUBTYPE chrv_tbl_type IS OKC_COPY_CONTRACT_PVT.chrv_tbl_type;
6: SUBTYPE clev_rec_type IS OKC_COPY_CONTRACT_PVT.clev_rec_type;
7: SUBTYPE clev_tbl_type IS OKC_COPY_CONTRACT_PVT.clev_tbl_type;
8: SUBTYPE cacv_rec_type IS OKC_COPY_CONTRACT_PVT.cacv_rec_type;
9: SUBTYPE cacv_tbl_type IS OKC_COPY_CONTRACT_PVT.cacv_tbl_type;
10: SUBTYPE cpsv_rec_type IS OKC_COPY_CONTRACT_PVT.cpsv_rec_type;
11: SUBTYPE cpsv_tbl_type IS OKC_COPY_CONTRACT_PVT.cpsv_tbl_type;
12: SUBTYPE rulv_rec_type IS OKC_COPY_CONTRACT_PVT.rulv_rec_type;
13: SUBTYPE rulv_tbl_type IS OKC_COPY_CONTRACT_PVT.rulv_tbl_type;
6: SUBTYPE clev_rec_type IS OKC_COPY_CONTRACT_PVT.clev_rec_type;
7: SUBTYPE clev_tbl_type IS OKC_COPY_CONTRACT_PVT.clev_tbl_type;
8: SUBTYPE cacv_rec_type IS OKC_COPY_CONTRACT_PVT.cacv_rec_type;
9: SUBTYPE cacv_tbl_type IS OKC_COPY_CONTRACT_PVT.cacv_tbl_type;
10: SUBTYPE cpsv_rec_type IS OKC_COPY_CONTRACT_PVT.cpsv_rec_type;
11: SUBTYPE cpsv_tbl_type IS OKC_COPY_CONTRACT_PVT.cpsv_tbl_type;
12: SUBTYPE rulv_rec_type IS OKC_COPY_CONTRACT_PVT.rulv_rec_type;
13: SUBTYPE rulv_tbl_type IS OKC_COPY_CONTRACT_PVT.rulv_tbl_type;
14: SUBTYPE rgpv_rec_type IS OKC_COPY_CONTRACT_PVT.rgpv_rec_type;
7: SUBTYPE clev_tbl_type IS OKC_COPY_CONTRACT_PVT.clev_tbl_type;
8: SUBTYPE cacv_rec_type IS OKC_COPY_CONTRACT_PVT.cacv_rec_type;
9: SUBTYPE cacv_tbl_type IS OKC_COPY_CONTRACT_PVT.cacv_tbl_type;
10: SUBTYPE cpsv_rec_type IS OKC_COPY_CONTRACT_PVT.cpsv_rec_type;
11: SUBTYPE cpsv_tbl_type IS OKC_COPY_CONTRACT_PVT.cpsv_tbl_type;
12: SUBTYPE rulv_rec_type IS OKC_COPY_CONTRACT_PVT.rulv_rec_type;
13: SUBTYPE rulv_tbl_type IS OKC_COPY_CONTRACT_PVT.rulv_tbl_type;
14: SUBTYPE rgpv_rec_type IS OKC_COPY_CONTRACT_PVT.rgpv_rec_type;
15: SUBTYPE rgpv_tbl_type IS OKC_COPY_CONTRACT_PVT.rgpv_tbl_type;
8: SUBTYPE cacv_rec_type IS OKC_COPY_CONTRACT_PVT.cacv_rec_type;
9: SUBTYPE cacv_tbl_type IS OKC_COPY_CONTRACT_PVT.cacv_tbl_type;
10: SUBTYPE cpsv_rec_type IS OKC_COPY_CONTRACT_PVT.cpsv_rec_type;
11: SUBTYPE cpsv_tbl_type IS OKC_COPY_CONTRACT_PVT.cpsv_tbl_type;
12: SUBTYPE rulv_rec_type IS OKC_COPY_CONTRACT_PVT.rulv_rec_type;
13: SUBTYPE rulv_tbl_type IS OKC_COPY_CONTRACT_PVT.rulv_tbl_type;
14: SUBTYPE rgpv_rec_type IS OKC_COPY_CONTRACT_PVT.rgpv_rec_type;
15: SUBTYPE rgpv_tbl_type IS OKC_COPY_CONTRACT_PVT.rgpv_tbl_type;
16: SUBTYPE catv_rec_type IS OKC_COPY_CONTRACT_PVT.catv_rec_type;
9: SUBTYPE cacv_tbl_type IS OKC_COPY_CONTRACT_PVT.cacv_tbl_type;
10: SUBTYPE cpsv_rec_type IS OKC_COPY_CONTRACT_PVT.cpsv_rec_type;
11: SUBTYPE cpsv_tbl_type IS OKC_COPY_CONTRACT_PVT.cpsv_tbl_type;
12: SUBTYPE rulv_rec_type IS OKC_COPY_CONTRACT_PVT.rulv_rec_type;
13: SUBTYPE rulv_tbl_type IS OKC_COPY_CONTRACT_PVT.rulv_tbl_type;
14: SUBTYPE rgpv_rec_type IS OKC_COPY_CONTRACT_PVT.rgpv_rec_type;
15: SUBTYPE rgpv_tbl_type IS OKC_COPY_CONTRACT_PVT.rgpv_tbl_type;
16: SUBTYPE catv_rec_type IS OKC_COPY_CONTRACT_PVT.catv_rec_type;
17: SUBTYPE catv_tbl_type IS OKC_COPY_CONTRACT_PVT.catv_tbl_type;
10: SUBTYPE cpsv_rec_type IS OKC_COPY_CONTRACT_PVT.cpsv_rec_type;
11: SUBTYPE cpsv_tbl_type IS OKC_COPY_CONTRACT_PVT.cpsv_tbl_type;
12: SUBTYPE rulv_rec_type IS OKC_COPY_CONTRACT_PVT.rulv_rec_type;
13: SUBTYPE rulv_tbl_type IS OKC_COPY_CONTRACT_PVT.rulv_tbl_type;
14: SUBTYPE rgpv_rec_type IS OKC_COPY_CONTRACT_PVT.rgpv_rec_type;
15: SUBTYPE rgpv_tbl_type IS OKC_COPY_CONTRACT_PVT.rgpv_tbl_type;
16: SUBTYPE catv_rec_type IS OKC_COPY_CONTRACT_PVT.catv_rec_type;
17: SUBTYPE catv_tbl_type IS OKC_COPY_CONTRACT_PVT.catv_tbl_type;
18: SUBTYPE cnhv_rec_type IS OKC_COPY_CONTRACT_PVT.cnhv_rec_type;
11: SUBTYPE cpsv_tbl_type IS OKC_COPY_CONTRACT_PVT.cpsv_tbl_type;
12: SUBTYPE rulv_rec_type IS OKC_COPY_CONTRACT_PVT.rulv_rec_type;
13: SUBTYPE rulv_tbl_type IS OKC_COPY_CONTRACT_PVT.rulv_tbl_type;
14: SUBTYPE rgpv_rec_type IS OKC_COPY_CONTRACT_PVT.rgpv_rec_type;
15: SUBTYPE rgpv_tbl_type IS OKC_COPY_CONTRACT_PVT.rgpv_tbl_type;
16: SUBTYPE catv_rec_type IS OKC_COPY_CONTRACT_PVT.catv_rec_type;
17: SUBTYPE catv_tbl_type IS OKC_COPY_CONTRACT_PVT.catv_tbl_type;
18: SUBTYPE cnhv_rec_type IS OKC_COPY_CONTRACT_PVT.cnhv_rec_type;
19: SUBTYPE cnhv_tbl_type IS OKC_COPY_CONTRACT_PVT.cnhv_tbl_type;
12: SUBTYPE rulv_rec_type IS OKC_COPY_CONTRACT_PVT.rulv_rec_type;
13: SUBTYPE rulv_tbl_type IS OKC_COPY_CONTRACT_PVT.rulv_tbl_type;
14: SUBTYPE rgpv_rec_type IS OKC_COPY_CONTRACT_PVT.rgpv_rec_type;
15: SUBTYPE rgpv_tbl_type IS OKC_COPY_CONTRACT_PVT.rgpv_tbl_type;
16: SUBTYPE catv_rec_type IS OKC_COPY_CONTRACT_PVT.catv_rec_type;
17: SUBTYPE catv_tbl_type IS OKC_COPY_CONTRACT_PVT.catv_tbl_type;
18: SUBTYPE cnhv_rec_type IS OKC_COPY_CONTRACT_PVT.cnhv_rec_type;
19: SUBTYPE cnhv_tbl_type IS OKC_COPY_CONTRACT_PVT.cnhv_tbl_type;
20: SUBTYPE cnlv_rec_type IS OKC_COPY_CONTRACT_PVT.cnlv_rec_type;
13: SUBTYPE rulv_tbl_type IS OKC_COPY_CONTRACT_PVT.rulv_tbl_type;
14: SUBTYPE rgpv_rec_type IS OKC_COPY_CONTRACT_PVT.rgpv_rec_type;
15: SUBTYPE rgpv_tbl_type IS OKC_COPY_CONTRACT_PVT.rgpv_tbl_type;
16: SUBTYPE catv_rec_type IS OKC_COPY_CONTRACT_PVT.catv_rec_type;
17: SUBTYPE catv_tbl_type IS OKC_COPY_CONTRACT_PVT.catv_tbl_type;
18: SUBTYPE cnhv_rec_type IS OKC_COPY_CONTRACT_PVT.cnhv_rec_type;
19: SUBTYPE cnhv_tbl_type IS OKC_COPY_CONTRACT_PVT.cnhv_tbl_type;
20: SUBTYPE cnlv_rec_type IS OKC_COPY_CONTRACT_PVT.cnlv_rec_type;
21: SUBTYPE cnlv_tbl_type IS OKC_COPY_CONTRACT_PVT.cnlv_tbl_type;
14: SUBTYPE rgpv_rec_type IS OKC_COPY_CONTRACT_PVT.rgpv_rec_type;
15: SUBTYPE rgpv_tbl_type IS OKC_COPY_CONTRACT_PVT.rgpv_tbl_type;
16: SUBTYPE catv_rec_type IS OKC_COPY_CONTRACT_PVT.catv_rec_type;
17: SUBTYPE catv_tbl_type IS OKC_COPY_CONTRACT_PVT.catv_tbl_type;
18: SUBTYPE cnhv_rec_type IS OKC_COPY_CONTRACT_PVT.cnhv_rec_type;
19: SUBTYPE cnhv_tbl_type IS OKC_COPY_CONTRACT_PVT.cnhv_tbl_type;
20: SUBTYPE cnlv_rec_type IS OKC_COPY_CONTRACT_PVT.cnlv_rec_type;
21: SUBTYPE cnlv_tbl_type IS OKC_COPY_CONTRACT_PVT.cnlv_tbl_type;
22: SUBTYPE cimv_rec_type IS OKC_COPY_CONTRACT_PVT.cimv_rec_type;
15: SUBTYPE rgpv_tbl_type IS OKC_COPY_CONTRACT_PVT.rgpv_tbl_type;
16: SUBTYPE catv_rec_type IS OKC_COPY_CONTRACT_PVT.catv_rec_type;
17: SUBTYPE catv_tbl_type IS OKC_COPY_CONTRACT_PVT.catv_tbl_type;
18: SUBTYPE cnhv_rec_type IS OKC_COPY_CONTRACT_PVT.cnhv_rec_type;
19: SUBTYPE cnhv_tbl_type IS OKC_COPY_CONTRACT_PVT.cnhv_tbl_type;
20: SUBTYPE cnlv_rec_type IS OKC_COPY_CONTRACT_PVT.cnlv_rec_type;
21: SUBTYPE cnlv_tbl_type IS OKC_COPY_CONTRACT_PVT.cnlv_tbl_type;
22: SUBTYPE cimv_rec_type IS OKC_COPY_CONTRACT_PVT.cimv_rec_type;
23: SUBTYPE cimv_tbl_type IS OKC_COPY_CONTRACT_PVT.cimv_tbl_type;
16: SUBTYPE catv_rec_type IS OKC_COPY_CONTRACT_PVT.catv_rec_type;
17: SUBTYPE catv_tbl_type IS OKC_COPY_CONTRACT_PVT.catv_tbl_type;
18: SUBTYPE cnhv_rec_type IS OKC_COPY_CONTRACT_PVT.cnhv_rec_type;
19: SUBTYPE cnhv_tbl_type IS OKC_COPY_CONTRACT_PVT.cnhv_tbl_type;
20: SUBTYPE cnlv_rec_type IS OKC_COPY_CONTRACT_PVT.cnlv_rec_type;
21: SUBTYPE cnlv_tbl_type IS OKC_COPY_CONTRACT_PVT.cnlv_tbl_type;
22: SUBTYPE cimv_rec_type IS OKC_COPY_CONTRACT_PVT.cimv_rec_type;
23: SUBTYPE cimv_tbl_type IS OKC_COPY_CONTRACT_PVT.cimv_tbl_type;
24: SUBTYPE cplv_rec_type IS OKC_COPY_CONTRACT_PVT.cplv_rec_type;
17: SUBTYPE catv_tbl_type IS OKC_COPY_CONTRACT_PVT.catv_tbl_type;
18: SUBTYPE cnhv_rec_type IS OKC_COPY_CONTRACT_PVT.cnhv_rec_type;
19: SUBTYPE cnhv_tbl_type IS OKC_COPY_CONTRACT_PVT.cnhv_tbl_type;
20: SUBTYPE cnlv_rec_type IS OKC_COPY_CONTRACT_PVT.cnlv_rec_type;
21: SUBTYPE cnlv_tbl_type IS OKC_COPY_CONTRACT_PVT.cnlv_tbl_type;
22: SUBTYPE cimv_rec_type IS OKC_COPY_CONTRACT_PVT.cimv_rec_type;
23: SUBTYPE cimv_tbl_type IS OKC_COPY_CONTRACT_PVT.cimv_tbl_type;
24: SUBTYPE cplv_rec_type IS OKC_COPY_CONTRACT_PVT.cplv_rec_type;
25: SUBTYPE cplv_tbl_type IS OKC_COPY_CONTRACT_PVT.cplv_tbl_type;
18: SUBTYPE cnhv_rec_type IS OKC_COPY_CONTRACT_PVT.cnhv_rec_type;
19: SUBTYPE cnhv_tbl_type IS OKC_COPY_CONTRACT_PVT.cnhv_tbl_type;
20: SUBTYPE cnlv_rec_type IS OKC_COPY_CONTRACT_PVT.cnlv_rec_type;
21: SUBTYPE cnlv_tbl_type IS OKC_COPY_CONTRACT_PVT.cnlv_tbl_type;
22: SUBTYPE cimv_rec_type IS OKC_COPY_CONTRACT_PVT.cimv_rec_type;
23: SUBTYPE cimv_tbl_type IS OKC_COPY_CONTRACT_PVT.cimv_tbl_type;
24: SUBTYPE cplv_rec_type IS OKC_COPY_CONTRACT_PVT.cplv_rec_type;
25: SUBTYPE cplv_tbl_type IS OKC_COPY_CONTRACT_PVT.cplv_tbl_type;
26: SUBTYPE cgcv_rec_type IS OKC_COPY_CONTRACT_PVT.cgcv_rec_type;
19: SUBTYPE cnhv_tbl_type IS OKC_COPY_CONTRACT_PVT.cnhv_tbl_type;
20: SUBTYPE cnlv_rec_type IS OKC_COPY_CONTRACT_PVT.cnlv_rec_type;
21: SUBTYPE cnlv_tbl_type IS OKC_COPY_CONTRACT_PVT.cnlv_tbl_type;
22: SUBTYPE cimv_rec_type IS OKC_COPY_CONTRACT_PVT.cimv_rec_type;
23: SUBTYPE cimv_tbl_type IS OKC_COPY_CONTRACT_PVT.cimv_tbl_type;
24: SUBTYPE cplv_rec_type IS OKC_COPY_CONTRACT_PVT.cplv_rec_type;
25: SUBTYPE cplv_tbl_type IS OKC_COPY_CONTRACT_PVT.cplv_tbl_type;
26: SUBTYPE cgcv_rec_type IS OKC_COPY_CONTRACT_PVT.cgcv_rec_type;
27: SUBTYPE cgcv_tbl_type IS OKC_CONTRACT_GROUP_PUB.cgcv_tbl_type;
20: SUBTYPE cnlv_rec_type IS OKC_COPY_CONTRACT_PVT.cnlv_rec_type;
21: SUBTYPE cnlv_tbl_type IS OKC_COPY_CONTRACT_PVT.cnlv_tbl_type;
22: SUBTYPE cimv_rec_type IS OKC_COPY_CONTRACT_PVT.cimv_rec_type;
23: SUBTYPE cimv_tbl_type IS OKC_COPY_CONTRACT_PVT.cimv_tbl_type;
24: SUBTYPE cplv_rec_type IS OKC_COPY_CONTRACT_PVT.cplv_rec_type;
25: SUBTYPE cplv_tbl_type IS OKC_COPY_CONTRACT_PVT.cplv_tbl_type;
26: SUBTYPE cgcv_rec_type IS OKC_COPY_CONTRACT_PVT.cgcv_rec_type;
27: SUBTYPE cgcv_tbl_type IS OKC_CONTRACT_GROUP_PUB.cgcv_tbl_type;
28:
21: SUBTYPE cnlv_tbl_type IS OKC_COPY_CONTRACT_PVT.cnlv_tbl_type;
22: SUBTYPE cimv_rec_type IS OKC_COPY_CONTRACT_PVT.cimv_rec_type;
23: SUBTYPE cimv_tbl_type IS OKC_COPY_CONTRACT_PVT.cimv_tbl_type;
24: SUBTYPE cplv_rec_type IS OKC_COPY_CONTRACT_PVT.cplv_rec_type;
25: SUBTYPE cplv_tbl_type IS OKC_COPY_CONTRACT_PVT.cplv_tbl_type;
26: SUBTYPE cgcv_rec_type IS OKC_COPY_CONTRACT_PVT.cgcv_rec_type;
27: SUBTYPE cgcv_tbl_type IS OKC_CONTRACT_GROUP_PUB.cgcv_tbl_type;
28:
29:
22: SUBTYPE cimv_rec_type IS OKC_COPY_CONTRACT_PVT.cimv_rec_type;
23: SUBTYPE cimv_tbl_type IS OKC_COPY_CONTRACT_PVT.cimv_tbl_type;
24: SUBTYPE cplv_rec_type IS OKC_COPY_CONTRACT_PVT.cplv_rec_type;
25: SUBTYPE cplv_tbl_type IS OKC_COPY_CONTRACT_PVT.cplv_tbl_type;
26: SUBTYPE cgcv_rec_type IS OKC_COPY_CONTRACT_PVT.cgcv_rec_type;
27: SUBTYPE cgcv_tbl_type IS OKC_CONTRACT_GROUP_PUB.cgcv_tbl_type;
28:
29:
30: ---------------------------------------------------------------------------
56: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
57: ---------------------------------------------------------------------------
58:
59:
60: SUBTYPE api_components_tbl IS OKC_COPY_CONTRACT_PVT.api_components_tbl;
61: SUBTYPE api_lines_tbl IS OKC_COPY_CONTRACT_PVT.api_lines_tbl;
62:
63:
64: FUNCTION update_target_contract(p_chr_id IN NUMBER) RETURN BOOLEAN;
57: ---------------------------------------------------------------------------
58:
59:
60: SUBTYPE api_components_tbl IS OKC_COPY_CONTRACT_PVT.api_components_tbl;
61: SUBTYPE api_lines_tbl IS OKC_COPY_CONTRACT_PVT.api_lines_tbl;
62:
63:
64: FUNCTION update_target_contract(p_chr_id IN NUMBER) RETURN BOOLEAN;
65: FUNCTION is_copy_allowed(p_chr_id IN NUMBER,p_sts_code IN VARCHAR2 DEFAULT NULL) RETURN BOOLEAN;