65: (p_compl_agency_appeal_id in number
66: ) RETURN varchar2;
67: --
68:
69: PROCEDURE chk_reason_for_appeal(p_compl_agency_appeal_id in ghr_compl_agency_appeals.compl_agency_appeal_id%TYPE,
70: p_reason_for_appeal in ghr_compl_agency_appeals.reason_for_appeal%TYPE,
71: p_effective_date in date,
72: p_object_version_number in number);
73:
66: ) RETURN varchar2;
67: --
68:
69: PROCEDURE chk_reason_for_appeal(p_compl_agency_appeal_id in ghr_compl_agency_appeals.compl_agency_appeal_id%TYPE,
70: p_reason_for_appeal in ghr_compl_agency_appeals.reason_for_appeal%TYPE,
71: p_effective_date in date,
72: p_object_version_number in number);
73:
74: PROCEDURE chk_decision(p_compl_agency_appeal_id in ghr_compl_agency_appeals.compl_agency_appeal_id%TYPE,
70: p_reason_for_appeal in ghr_compl_agency_appeals.reason_for_appeal%TYPE,
71: p_effective_date in date,
72: p_object_version_number in number);
73:
74: PROCEDURE chk_decision(p_compl_agency_appeal_id in ghr_compl_agency_appeals.compl_agency_appeal_id%TYPE,
75: p_decision in ghr_compl_agency_appeals.decision%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_decision(p_compl_agency_appeal_id in ghr_compl_agency_appeals.compl_agency_appeal_id%TYPE,
75: p_decision in ghr_compl_agency_appeals.decision%TYPE,
76: p_effective_date in date,
77: p_object_version_number in number);
78:
79: PROCEDURE chk_rfr_requested_by(p_compl_agency_appeal_id in ghr_compl_agency_appeals.compl_agency_appeal_id%TYPE,
75: p_decision in ghr_compl_agency_appeals.decision%TYPE,
76: p_effective_date in date,
77: p_object_version_number in number);
78:
79: PROCEDURE chk_rfr_requested_by(p_compl_agency_appeal_id in ghr_compl_agency_appeals.compl_agency_appeal_id%TYPE,
80: p_rfr_requested_by in ghr_compl_agency_appeals.rfr_requested_by%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_rfr_requested_by(p_compl_agency_appeal_id in ghr_compl_agency_appeals.compl_agency_appeal_id%TYPE,
80: p_rfr_requested_by in ghr_compl_agency_appeals.rfr_requested_by%TYPE,
81: p_effective_date in date,
82: p_object_version_number in number);
83:
84: PROCEDURE chk_rfr_decision(p_compl_agency_appeal_id in ghr_compl_agency_appeals.compl_agency_appeal_id%TYPE,
80: p_rfr_requested_by in ghr_compl_agency_appeals.rfr_requested_by%TYPE,
81: p_effective_date in date,
82: p_object_version_number in number);
83:
84: PROCEDURE chk_rfr_decision(p_compl_agency_appeal_id in ghr_compl_agency_appeals.compl_agency_appeal_id%TYPE,
85: p_rfr_decision in ghr_compl_agency_appeals.rfr_decision%TYPE,
86: p_effective_date in date,
87: p_object_version_number in number);
88:
81: p_effective_date in date,
82: p_object_version_number in number);
83:
84: PROCEDURE chk_rfr_decision(p_compl_agency_appeal_id in ghr_compl_agency_appeals.compl_agency_appeal_id%TYPE,
85: p_rfr_decision in ghr_compl_agency_appeals.rfr_decision%TYPE,
86: p_effective_date in date,
87: p_object_version_number in number);
88:
89: --