APPS.GHR_CCA_BUS dependencies on GHR_COMPL_APPEALS

Line 69: PROCEDURE chk_appealed_to(p_compl_appeal_id in ghr_compl_appeals.compl_appeal_id%TYPE,

65: (p_compl_appeal_id in number
66: ) RETURN varchar2;
67: --
68:
69: PROCEDURE chk_appealed_to(p_compl_appeal_id in ghr_compl_appeals.compl_appeal_id%TYPE,
70: p_appealed_to in ghr_compl_appeals.appealed_to%TYPE,
71: p_effective_date in date,
72: p_object_version_number in number);
73:

Line 70: p_appealed_to in ghr_compl_appeals.appealed_to%TYPE,

66: ) RETURN varchar2;
67: --
68:
69: PROCEDURE chk_appealed_to(p_compl_appeal_id in ghr_compl_appeals.compl_appeal_id%TYPE,
70: p_appealed_to in ghr_compl_appeals.appealed_to%TYPE,
71: p_effective_date in date,
72: p_object_version_number in number);
73:
74:

Line 75: PROCEDURE chk_reason_for_appeal(p_compl_appeal_id in ghr_compl_appeals.compl_appeal_id%TYPE,

71: p_effective_date in date,
72: p_object_version_number in number);
73:
74:
75: PROCEDURE chk_reason_for_appeal(p_compl_appeal_id in ghr_compl_appeals.compl_appeal_id%TYPE,
76: p_reason_for_appeal in ghr_compl_appeals.reason_for_appeal%TYPE,
77: p_effective_date in date,
78: p_object_version_number in number);
79:

Line 76: p_reason_for_appeal in ghr_compl_appeals.reason_for_appeal%TYPE,

72: p_object_version_number in number);
73:
74:
75: PROCEDURE chk_reason_for_appeal(p_compl_appeal_id in ghr_compl_appeals.compl_appeal_id%TYPE,
76: p_reason_for_appeal in ghr_compl_appeals.reason_for_appeal%TYPE,
77: p_effective_date in date,
78: p_object_version_number in number);
79:
80: PROCEDURE chk_decision(p_compl_appeal_id in ghr_compl_appeals.compl_appeal_id%TYPE,

Line 80: PROCEDURE chk_decision(p_compl_appeal_id in ghr_compl_appeals.compl_appeal_id%TYPE,

76: p_reason_for_appeal in ghr_compl_appeals.reason_for_appeal%TYPE,
77: p_effective_date in date,
78: p_object_version_number in number);
79:
80: PROCEDURE chk_decision(p_compl_appeal_id in ghr_compl_appeals.compl_appeal_id%TYPE,
81: p_appealed_to in ghr_compl_appeals.appealed_to%TYPE,
82: p_decision in ghr_compl_appeals.decision%TYPE,
83: p_effective_date in date,
84: p_object_version_number in number);

Line 81: p_appealed_to in ghr_compl_appeals.appealed_to%TYPE,

77: p_effective_date in date,
78: p_object_version_number in number);
79:
80: PROCEDURE chk_decision(p_compl_appeal_id in ghr_compl_appeals.compl_appeal_id%TYPE,
81: p_appealed_to in ghr_compl_appeals.appealed_to%TYPE,
82: p_decision in ghr_compl_appeals.decision%TYPE,
83: p_effective_date in date,
84: p_object_version_number in number);
85:

Line 82: p_decision in ghr_compl_appeals.decision%TYPE,

78: p_object_version_number in number);
79:
80: PROCEDURE chk_decision(p_compl_appeal_id in ghr_compl_appeals.compl_appeal_id%TYPE,
81: p_appealed_to in ghr_compl_appeals.appealed_to%TYPE,
82: p_decision in ghr_compl_appeals.decision%TYPE,
83: p_effective_date in date,
84: p_object_version_number in number);
85:
86: PROCEDURE chk_rfr_requested_by(p_compl_appeal_id in ghr_compl_appeals.compl_appeal_id%TYPE,

Line 86: PROCEDURE chk_rfr_requested_by(p_compl_appeal_id in ghr_compl_appeals.compl_appeal_id%TYPE,

82: p_decision in ghr_compl_appeals.decision%TYPE,
83: p_effective_date in date,
84: p_object_version_number in number);
85:
86: PROCEDURE chk_rfr_requested_by(p_compl_appeal_id in ghr_compl_appeals.compl_appeal_id%TYPE,
87: p_rfr_requested_by in ghr_compl_appeals.rfr_requested_by%TYPE,
88: p_effective_date in date,
89: p_object_version_number in number);
90:

Line 87: p_rfr_requested_by in ghr_compl_appeals.rfr_requested_by%TYPE,

83: p_effective_date in date,
84: p_object_version_number in number);
85:
86: PROCEDURE chk_rfr_requested_by(p_compl_appeal_id in ghr_compl_appeals.compl_appeal_id%TYPE,
87: p_rfr_requested_by in ghr_compl_appeals.rfr_requested_by%TYPE,
88: p_effective_date in date,
89: p_object_version_number in number);
90:
91: PROCEDURE chk_rfr_decision(p_compl_appeal_id in ghr_compl_appeals.compl_appeal_id%TYPE,

Line 91: PROCEDURE chk_rfr_decision(p_compl_appeal_id in ghr_compl_appeals.compl_appeal_id%TYPE,

87: p_rfr_requested_by in ghr_compl_appeals.rfr_requested_by%TYPE,
88: p_effective_date in date,
89: p_object_version_number in number);
90:
91: PROCEDURE chk_rfr_decision(p_compl_appeal_id in ghr_compl_appeals.compl_appeal_id%TYPE,
92: p_rfr_decision in ghr_compl_appeals.rfr_decision%TYPE,
93: p_effective_date in date,
94: p_object_version_number in number);
95:

Line 92: p_rfr_decision in ghr_compl_appeals.rfr_decision%TYPE,

88: p_effective_date in date,
89: p_object_version_number in number);
90:
91: PROCEDURE chk_rfr_decision(p_compl_appeal_id in ghr_compl_appeals.compl_appeal_id%TYPE,
92: p_rfr_decision in ghr_compl_appeals.rfr_decision%TYPE,
93: p_effective_date in date,
94: p_object_version_number in number);
95:
96: --