APPS.PQH_STR_SHD dependencies on PQH_FR_STAT_SITUATION_RULES

Line 23: If (p_constraint_name = 'PQH_FR_STAT_SITUATION_RULES_PK') Then

19: l_proc varchar2(72) := g_package||'constraint_error';
20: --
21: Begin
22: --
23: If (p_constraint_name = 'PQH_FR_STAT_SITUATION_RULES_PK') Then
24: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
25: fnd_message.set_token('PROCEDURE', l_proc);
26: fnd_message.set_token('STEP','5');
27: fnd_message.raise_error;

Line 61: from pqh_fr_stat_situation_rules

57: ,enabled_flag
58: ,required_flag
59: ,exclude_flag
60: ,object_version_number
61: from pqh_fr_stat_situation_rules
62: where stat_situation_rule_id = p_stat_situation_rule_id;
63: --
64: l_fct_ret boolean;
65: --

Line 136: from pqh_fr_stat_situation_rules

132: ,enabled_flag
133: ,required_flag
134: ,exclude_flag
135: ,object_version_number
136: from pqh_fr_stat_situation_rules
137: where stat_situation_rule_id = p_stat_situation_rule_id
138: for update nowait;
139: --
140: l_proc varchar2(72) := g_package||'lck';

Line 202: fnd_message.set_token('TABLE_NAME', 'pqh_fr_stat_situation_rules');

198: -- The object is locked therefore we need to supply a meaningful
199: -- error message.
200: --
201: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
202: fnd_message.set_token('TABLE_NAME', 'pqh_fr_stat_situation_rules');
203: fnd_message.raise_error;
204: End lck;
205: --
206: -- ----------------------------------------------------------------------------