33: G_ERROR EXCEPTION;
34: ----------------------------------------------------------------------------------------
35:
36: --SUBTYPE DECLARATION
37: SUBTYPE clvl_filter_rec IS OKS_AUTH_UTIL_PVT.clvl_filter_rec;
38: SUBTYPE clvl_selections_tbl IS OKS_AUTH_UTIL_PVT.clvl_selections_tbl;
39: SUBTYPE prod_selections_tbl IS OKS_AUTH_UTIL_PVT.prod_selections_tbl;
40: SUBTYPE copy_source_rec IS OKS_AUTH_UTIL_PVT.copy_source_rec;
41: SUBTYPE copy_target_tbl IS OKS_AUTH_UTIL_PVT.copy_target_tbl;
34: ----------------------------------------------------------------------------------------
35:
36: --SUBTYPE DECLARATION
37: SUBTYPE clvl_filter_rec IS OKS_AUTH_UTIL_PVT.clvl_filter_rec;
38: SUBTYPE clvl_selections_tbl IS OKS_AUTH_UTIL_PVT.clvl_selections_tbl;
39: SUBTYPE prod_selections_tbl IS OKS_AUTH_UTIL_PVT.prod_selections_tbl;
40: SUBTYPE copy_source_rec IS OKS_AUTH_UTIL_PVT.copy_source_rec;
41: SUBTYPE copy_target_tbl IS OKS_AUTH_UTIL_PVT.copy_target_tbl;
42: SUBTYPE contact_point_rec IS OKS_AUTH_UTIL_PVT.contact_point_rec;
35:
36: --SUBTYPE DECLARATION
37: SUBTYPE clvl_filter_rec IS OKS_AUTH_UTIL_PVT.clvl_filter_rec;
38: SUBTYPE clvl_selections_tbl IS OKS_AUTH_UTIL_PVT.clvl_selections_tbl;
39: SUBTYPE prod_selections_tbl IS OKS_AUTH_UTIL_PVT.prod_selections_tbl;
40: SUBTYPE copy_source_rec IS OKS_AUTH_UTIL_PVT.copy_source_rec;
41: SUBTYPE copy_target_tbl IS OKS_AUTH_UTIL_PVT.copy_target_tbl;
42: SUBTYPE contact_point_rec IS OKS_AUTH_UTIL_PVT.contact_point_rec;
43: -- SUBTYPE contact_dtl_rec IS OKS_AUTH_UTIL_PVT.contact_dtl_rec;
36: --SUBTYPE DECLARATION
37: SUBTYPE clvl_filter_rec IS OKS_AUTH_UTIL_PVT.clvl_filter_rec;
38: SUBTYPE clvl_selections_tbl IS OKS_AUTH_UTIL_PVT.clvl_selections_tbl;
39: SUBTYPE prod_selections_tbl IS OKS_AUTH_UTIL_PVT.prod_selections_tbl;
40: SUBTYPE copy_source_rec IS OKS_AUTH_UTIL_PVT.copy_source_rec;
41: SUBTYPE copy_target_tbl IS OKS_AUTH_UTIL_PVT.copy_target_tbl;
42: SUBTYPE contact_point_rec IS OKS_AUTH_UTIL_PVT.contact_point_rec;
43: -- SUBTYPE contact_dtl_rec IS OKS_AUTH_UTIL_PVT.contact_dtl_rec;
44:
37: SUBTYPE clvl_filter_rec IS OKS_AUTH_UTIL_PVT.clvl_filter_rec;
38: SUBTYPE clvl_selections_tbl IS OKS_AUTH_UTIL_PVT.clvl_selections_tbl;
39: SUBTYPE prod_selections_tbl IS OKS_AUTH_UTIL_PVT.prod_selections_tbl;
40: SUBTYPE copy_source_rec IS OKS_AUTH_UTIL_PVT.copy_source_rec;
41: SUBTYPE copy_target_tbl IS OKS_AUTH_UTIL_PVT.copy_target_tbl;
42: SUBTYPE contact_point_rec IS OKS_AUTH_UTIL_PVT.contact_point_rec;
43: -- SUBTYPE contact_dtl_rec IS OKS_AUTH_UTIL_PVT.contact_dtl_rec;
44:
45: -- SUBTYPE prod_rec IS OKS_AUTH_UTIL_PVT.prod_rec;
38: SUBTYPE clvl_selections_tbl IS OKS_AUTH_UTIL_PVT.clvl_selections_tbl;
39: SUBTYPE prod_selections_tbl IS OKS_AUTH_UTIL_PVT.prod_selections_tbl;
40: SUBTYPE copy_source_rec IS OKS_AUTH_UTIL_PVT.copy_source_rec;
41: SUBTYPE copy_target_tbl IS OKS_AUTH_UTIL_PVT.copy_target_tbl;
42: SUBTYPE contact_point_rec IS OKS_AUTH_UTIL_PVT.contact_point_rec;
43: -- SUBTYPE contact_dtl_rec IS OKS_AUTH_UTIL_PVT.contact_dtl_rec;
44:
45: -- SUBTYPE prod_rec IS OKS_AUTH_UTIL_PVT.prod_rec;
46: -- SUBTYPE prod_tbl IS OKS_AUTH_UTIL_PVT.prod_tbl;
39: SUBTYPE prod_selections_tbl IS OKS_AUTH_UTIL_PVT.prod_selections_tbl;
40: SUBTYPE copy_source_rec IS OKS_AUTH_UTIL_PVT.copy_source_rec;
41: SUBTYPE copy_target_tbl IS OKS_AUTH_UTIL_PVT.copy_target_tbl;
42: SUBTYPE contact_point_rec IS OKS_AUTH_UTIL_PVT.contact_point_rec;
43: -- SUBTYPE contact_dtl_rec IS OKS_AUTH_UTIL_PVT.contact_dtl_rec;
44:
45: -- SUBTYPE prod_rec IS OKS_AUTH_UTIL_PVT.prod_rec;
46: -- SUBTYPE prod_tbl IS OKS_AUTH_UTIL_PVT.prod_tbl;
47: -- SUBTYPE cust_id_rec IS OKS_AUTH_UTIL_PVT.cust_id_rec;
41: SUBTYPE copy_target_tbl IS OKS_AUTH_UTIL_PVT.copy_target_tbl;
42: SUBTYPE contact_point_rec IS OKS_AUTH_UTIL_PVT.contact_point_rec;
43: -- SUBTYPE contact_dtl_rec IS OKS_AUTH_UTIL_PVT.contact_dtl_rec;
44:
45: -- SUBTYPE prod_rec IS OKS_AUTH_UTIL_PVT.prod_rec;
46: -- SUBTYPE prod_tbl IS OKS_AUTH_UTIL_PVT.prod_tbl;
47: -- SUBTYPE cust_id_rec IS OKS_AUTH_UTIL_PVT.cust_id_rec;
48: -- SUBTYPE cust_id_tbl IS OKS_AUTH_UTIL_PVT.cust_id_tbl;
49: ------------------------------------------------------------------------
42: SUBTYPE contact_point_rec IS OKS_AUTH_UTIL_PVT.contact_point_rec;
43: -- SUBTYPE contact_dtl_rec IS OKS_AUTH_UTIL_PVT.contact_dtl_rec;
44:
45: -- SUBTYPE prod_rec IS OKS_AUTH_UTIL_PVT.prod_rec;
46: -- SUBTYPE prod_tbl IS OKS_AUTH_UTIL_PVT.prod_tbl;
47: -- SUBTYPE cust_id_rec IS OKS_AUTH_UTIL_PVT.cust_id_rec;
48: -- SUBTYPE cust_id_tbl IS OKS_AUTH_UTIL_PVT.cust_id_tbl;
49: ------------------------------------------------------------------------
50: ---- start --CONTACT CREATION 11.5.10+ OCT 2004
43: -- SUBTYPE contact_dtl_rec IS OKS_AUTH_UTIL_PVT.contact_dtl_rec;
44:
45: -- SUBTYPE prod_rec IS OKS_AUTH_UTIL_PVT.prod_rec;
46: -- SUBTYPE prod_tbl IS OKS_AUTH_UTIL_PVT.prod_tbl;
47: -- SUBTYPE cust_id_rec IS OKS_AUTH_UTIL_PVT.cust_id_rec;
48: -- SUBTYPE cust_id_tbl IS OKS_AUTH_UTIL_PVT.cust_id_tbl;
49: ------------------------------------------------------------------------
50: ---- start --CONTACT CREATION 11.5.10+ OCT 2004
51: ------------------------------------------------------------------------
44:
45: -- SUBTYPE prod_rec IS OKS_AUTH_UTIL_PVT.prod_rec;
46: -- SUBTYPE prod_tbl IS OKS_AUTH_UTIL_PVT.prod_tbl;
47: -- SUBTYPE cust_id_rec IS OKS_AUTH_UTIL_PVT.cust_id_rec;
48: -- SUBTYPE cust_id_tbl IS OKS_AUTH_UTIL_PVT.cust_id_tbl;
49: ------------------------------------------------------------------------
50: ---- start --CONTACT CREATION 11.5.10+ OCT 2004
51: ------------------------------------------------------------------------
52: SUBTYPE person_tbl_type IS OKS_AUTH_UTIL_PVT.person_tbl_type;
48: -- SUBTYPE cust_id_tbl IS OKS_AUTH_UTIL_PVT.cust_id_tbl;
49: ------------------------------------------------------------------------
50: ---- start --CONTACT CREATION 11.5.10+ OCT 2004
51: ------------------------------------------------------------------------
52: SUBTYPE person_tbl_type IS OKS_AUTH_UTIL_PVT.person_tbl_type;
53: SUBTYPE relationship_tbl_type IS OKS_AUTH_UTIL_PVT.relationship_tbl_type;
54: SUBTYPE org_contact_tbl_type IS OKS_AUTH_UTIL_PVT.org_contact_tbl_type;
55: SUBTYPE party_site_tbl_type IS OKS_AUTH_UTIL_PVT.party_site_tbl_type;
56: SUBTYPE CUST_ACCOUNT_ROLE_tbl_TYPE IS OKS_AUTH_UTIL_PVT.CUST_ACCOUNT_ROLE_tbl_TYPE;
49: ------------------------------------------------------------------------
50: ---- start --CONTACT CREATION 11.5.10+ OCT 2004
51: ------------------------------------------------------------------------
52: SUBTYPE person_tbl_type IS OKS_AUTH_UTIL_PVT.person_tbl_type;
53: SUBTYPE relationship_tbl_type IS OKS_AUTH_UTIL_PVT.relationship_tbl_type;
54: SUBTYPE org_contact_tbl_type IS OKS_AUTH_UTIL_PVT.org_contact_tbl_type;
55: SUBTYPE party_site_tbl_type IS OKS_AUTH_UTIL_PVT.party_site_tbl_type;
56: SUBTYPE CUST_ACCOUNT_ROLE_tbl_TYPE IS OKS_AUTH_UTIL_PVT.CUST_ACCOUNT_ROLE_tbl_TYPE;
57: SUBTYPE CUST_ACCT_SITE_TBL_TYPE IS OKS_AUTH_UTIL_PVT.CUST_ACCT_SITE_TBL_TYPE;
50: ---- start --CONTACT CREATION 11.5.10+ OCT 2004
51: ------------------------------------------------------------------------
52: SUBTYPE person_tbl_type IS OKS_AUTH_UTIL_PVT.person_tbl_type;
53: SUBTYPE relationship_tbl_type IS OKS_AUTH_UTIL_PVT.relationship_tbl_type;
54: SUBTYPE org_contact_tbl_type IS OKS_AUTH_UTIL_PVT.org_contact_tbl_type;
55: SUBTYPE party_site_tbl_type IS OKS_AUTH_UTIL_PVT.party_site_tbl_type;
56: SUBTYPE CUST_ACCOUNT_ROLE_tbl_TYPE IS OKS_AUTH_UTIL_PVT.CUST_ACCOUNT_ROLE_tbl_TYPE;
57: SUBTYPE CUST_ACCT_SITE_TBL_TYPE IS OKS_AUTH_UTIL_PVT.CUST_ACCT_SITE_TBL_TYPE;
58:
51: ------------------------------------------------------------------------
52: SUBTYPE person_tbl_type IS OKS_AUTH_UTIL_PVT.person_tbl_type;
53: SUBTYPE relationship_tbl_type IS OKS_AUTH_UTIL_PVT.relationship_tbl_type;
54: SUBTYPE org_contact_tbl_type IS OKS_AUTH_UTIL_PVT.org_contact_tbl_type;
55: SUBTYPE party_site_tbl_type IS OKS_AUTH_UTIL_PVT.party_site_tbl_type;
56: SUBTYPE CUST_ACCOUNT_ROLE_tbl_TYPE IS OKS_AUTH_UTIL_PVT.CUST_ACCOUNT_ROLE_tbl_TYPE;
57: SUBTYPE CUST_ACCT_SITE_TBL_TYPE IS OKS_AUTH_UTIL_PVT.CUST_ACCT_SITE_TBL_TYPE;
58:
59: -- GCHADHA --
52: SUBTYPE person_tbl_type IS OKS_AUTH_UTIL_PVT.person_tbl_type;
53: SUBTYPE relationship_tbl_type IS OKS_AUTH_UTIL_PVT.relationship_tbl_type;
54: SUBTYPE org_contact_tbl_type IS OKS_AUTH_UTIL_PVT.org_contact_tbl_type;
55: SUBTYPE party_site_tbl_type IS OKS_AUTH_UTIL_PVT.party_site_tbl_type;
56: SUBTYPE CUST_ACCOUNT_ROLE_tbl_TYPE IS OKS_AUTH_UTIL_PVT.CUST_ACCOUNT_ROLE_tbl_TYPE;
57: SUBTYPE CUST_ACCT_SITE_TBL_TYPE IS OKS_AUTH_UTIL_PVT.CUST_ACCT_SITE_TBL_TYPE;
58:
59: -- GCHADHA --
60: -- 28-OCT-2004 --
53: SUBTYPE relationship_tbl_type IS OKS_AUTH_UTIL_PVT.relationship_tbl_type;
54: SUBTYPE org_contact_tbl_type IS OKS_AUTH_UTIL_PVT.org_contact_tbl_type;
55: SUBTYPE party_site_tbl_type IS OKS_AUTH_UTIL_PVT.party_site_tbl_type;
56: SUBTYPE CUST_ACCOUNT_ROLE_tbl_TYPE IS OKS_AUTH_UTIL_PVT.CUST_ACCOUNT_ROLE_tbl_TYPE;
57: SUBTYPE CUST_ACCT_SITE_TBL_TYPE IS OKS_AUTH_UTIL_PVT.CUST_ACCT_SITE_TBL_TYPE;
58:
59: -- GCHADHA --
60: -- 28-OCT-2004 --
61: ---------------------------------------------------------------------------