APPS.GHR_CAA_BUS dependencies on GHR_COMPL_AGENCY_APPEALS

Line 69: PROCEDURE chk_reason_for_appeal(p_compl_agency_appeal_id in ghr_compl_agency_appeals.compl_agency_appeal_id%TYPE,

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:

Line 70: p_reason_for_appeal in ghr_compl_agency_appeals.reason_for_appeal%TYPE,

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,

Line 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:

Line 75: p_decision in ghr_compl_agency_appeals.decision%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:
79: PROCEDURE chk_rfr_requested_by(p_compl_agency_appeal_id in ghr_compl_agency_appeals.compl_agency_appeal_id%TYPE,

Line 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:

Line 80: p_rfr_requested_by in ghr_compl_agency_appeals.rfr_requested_by%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:
84: PROCEDURE chk_rfr_decision(p_compl_agency_appeal_id in ghr_compl_agency_appeals.compl_agency_appeal_id%TYPE,

Line 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:

Line 85: p_rfr_decision in ghr_compl_agency_appeals.rfr_decision%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:
89: --