65: (p_compl_ca_detail_id in number
66: ) RETURN varchar2;
67: --
68:
69: PROCEDURE chk_category(p_compl_ca_detail_id in ghr_compl_ca_details.compl_ca_detail_id%TYPE,
70: p_category in ghr_compl_ca_details.category%TYPE,
71: p_effective_date in date,
72: p_object_version_number in number);
73: /*
66: ) RETURN varchar2;
67: --
68:
69: PROCEDURE chk_category(p_compl_ca_detail_id in ghr_compl_ca_details.compl_ca_detail_id%TYPE,
70: p_category in ghr_compl_ca_details.category%TYPE,
71: p_effective_date in date,
72: p_object_version_number in number);
73: /*
74: PROCEDURE chk_type(p_compl_ca_detail_id in ghr_compl_ca_details.compl_ca_detail_id%TYPE,
70: p_category in ghr_compl_ca_details.category%TYPE,
71: p_effective_date in date,
72: p_object_version_number in number);
73: /*
74: PROCEDURE chk_type(p_compl_ca_detail_id in ghr_compl_ca_details.compl_ca_detail_id%TYPE,
75: p_category in ghr_compl_ca_details.category%TYPE,
76: p_type in ghr_compl_ca_details.type%TYPE,
77: p_effective_date in date,
78: p_object_version_number in number);
71: p_effective_date in date,
72: p_object_version_number in number);
73: /*
74: PROCEDURE chk_type(p_compl_ca_detail_id in ghr_compl_ca_details.compl_ca_detail_id%TYPE,
75: p_category in ghr_compl_ca_details.category%TYPE,
76: p_type in ghr_compl_ca_details.type%TYPE,
77: p_effective_date in date,
78: p_object_version_number in number);
79: */
72: p_object_version_number in number);
73: /*
74: PROCEDURE chk_type(p_compl_ca_detail_id in ghr_compl_ca_details.compl_ca_detail_id%TYPE,
75: p_category in ghr_compl_ca_details.category%TYPE,
76: p_type in ghr_compl_ca_details.type%TYPE,
77: p_effective_date in date,
78: p_object_version_number in number);
79: */
80:
77: p_effective_date in date,
78: p_object_version_number in number);
79: */
80:
81: PROCEDURE chk_phase(p_compl_ca_detail_id in ghr_compl_ca_details.compl_ca_detail_id%TYPE,
82: p_phase in ghr_compl_ca_details.phase%TYPE,
83: p_effective_date in date,
84: p_object_version_number in number);
85:
78: p_object_version_number in number);
79: */
80:
81: PROCEDURE chk_phase(p_compl_ca_detail_id in ghr_compl_ca_details.compl_ca_detail_id%TYPE,
82: p_phase in ghr_compl_ca_details.phase%TYPE,
83: p_effective_date in date,
84: p_object_version_number in number);
85:
86: