DBA Data[Home] [Help]

APPS.PQP_GDS_SHD dependencies on PQP_GAP_DURATION_SUMMARY

Line 32: If (p_constraint_name = 'PQP_GAP_DURATION_SUMMARY_PK') Then

28: l_proc varchar2(72) := g_package||'constraint_error';
29: --
30: Begin
31: --
32: If (p_constraint_name = 'PQP_GAP_DURATION_SUMMARY_PK') Then
33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;

Line 70: from pqp_gap_duration_summary

66: ,duration_in_hours
67: ,date_start
68: ,date_end
69: ,object_version_number
70: from pqp_gap_duration_summary
71: where gap_duration_summary_id = p_gap_duration_summary_id;
72: --
73: l_fct_ret boolean;
74: --

Line 145: from pqp_gap_duration_summary

141: ,duration_in_hours
142: ,date_start
143: ,date_end
144: ,object_version_number
145: from pqp_gap_duration_summary
146: where gap_duration_summary_id = p_gap_duration_summary_id
147: for update nowait;
148: --
149: l_proc varchar2(72) := g_package||'lck';

Line 194: fnd_message.set_token('TABLE_NAME', 'pqp_gap_duration_summary');

190: -- The object is locked therefore we need to supply a meaningful
191: -- error message.
192: --
193: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
194: fnd_message.set_token('TABLE_NAME', 'pqp_gap_duration_summary');
195: fnd_message.raise_error;
196: End lck;
197: --
198: -- ----------------------------------------------------------------------------