65: (p_compl_ca_header_id in number
66: ) RETURN varchar2;
67: --
68:
69: PROCEDURE chk_ca_source(p_compl_ca_header_id in ghr_compl_ca_headers.compl_ca_header_id%TYPE,
70: p_ca_source in ghr_compl_ca_headers.ca_source%TYPE,
71: p_effective_date in date,
72: p_object_version_number in number);
73:
66: ) RETURN varchar2;
67: --
68:
69: PROCEDURE chk_ca_source(p_compl_ca_header_id in ghr_compl_ca_headers.compl_ca_header_id%TYPE,
70: p_ca_source in ghr_compl_ca_headers.ca_source%TYPE,
71: p_effective_date in date,
72: p_object_version_number in number);
73:
74: PROCEDURE chk_comrep_noncom_req(p_compl_ca_header_id in ghr_compl_ca_headers.compl_ca_header_id%TYPE,
70: p_ca_source in ghr_compl_ca_headers.ca_source%TYPE,
71: p_effective_date in date,
72: p_object_version_number in number);
73:
74: PROCEDURE chk_comrep_noncom_req(p_compl_ca_header_id in ghr_compl_ca_headers.compl_ca_header_id%TYPE,
75: p_comrep_noncom_req in ghr_compl_ca_headers.comrep_noncom_req%TYPE,
76: p_effective_date in date,
77: p_object_version_number in number);
78:
71: p_effective_date in date,
72: p_object_version_number in number);
73:
74: PROCEDURE chk_comrep_noncom_req(p_compl_ca_header_id in ghr_compl_ca_headers.compl_ca_header_id%TYPE,
75: p_comrep_noncom_req in ghr_compl_ca_headers.comrep_noncom_req%TYPE,
76: p_effective_date in date,
77: p_object_version_number in number);
78:
79: PROCEDURE chk_stage_complaint_reinstated(p_compl_ca_header_id in ghr_compl_ca_headers.compl_ca_header_id%TYPE,
75: p_comrep_noncom_req in ghr_compl_ca_headers.comrep_noncom_req%TYPE,
76: p_effective_date in date,
77: p_object_version_number in number);
78:
79: PROCEDURE chk_stage_complaint_reinstated(p_compl_ca_header_id in ghr_compl_ca_headers.compl_ca_header_id%TYPE,
80: p_stage_complaint_reinstated in ghr_compl_ca_headers.stage_complaint_reinstated%TYPE,
81: p_effective_date in date,
82: p_object_version_number in number);
83:
76: p_effective_date in date,
77: p_object_version_number in number);
78:
79: PROCEDURE chk_stage_complaint_reinstated(p_compl_ca_header_id in ghr_compl_ca_headers.compl_ca_header_id%TYPE,
80: p_stage_complaint_reinstated in ghr_compl_ca_headers.stage_complaint_reinstated%TYPE,
81: p_effective_date in date,
82: p_object_version_number in number);
83:
84: --