APPS.PAY_BTL_SHD dependencies on PAY_BATCH_LINES

Line 34: If (p_constraint_name = 'PAY_BATCH_LINES_FK3') Then

30: l_proc varchar2(72) := g_package||'constraint_error';
31: --
32: Begin
33: --
34: If (p_constraint_name = 'PAY_BATCH_LINES_FK3') Then
35: fnd_message.set_name('PAY', 'PAY_52680_BHT_INVALID_HEADER');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PAY_BATCH_LINES_PK') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 37: ElsIf (p_constraint_name = 'PAY_BATCH_LINES_PK') Then

33: --
34: If (p_constraint_name = 'PAY_BATCH_LINES_FK3') Then
35: fnd_message.set_name('PAY', 'PAY_52680_BHT_INVALID_HEADER');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PAY_BATCH_LINES_PK') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','10');
41: fnd_message.raise_error;

Line 189: from pay_batch_lines

185: ,subpriority
186: ,effective_start_date
187: ,effective_end_date
188: ,object_version_number
189: from pay_batch_lines
190: where batch_line_id = p_batch_line_id;
191: --
192: l_fct_ret boolean;
193: --

Line 370: from pay_batch_lines

366: ,subpriority
367: ,effective_start_date
368: ,effective_end_date
369: ,object_version_number
370: from pay_batch_lines
371: where batch_line_id = p_batch_line_id
372: for update nowait;
373: --
374: l_proc varchar2(72) := g_package||'lck';

Line 413: fnd_message.set_token('TABLE_NAME', 'pay_batch_lines');

409: -- The object is locked therefore we need to supply a meaningful
410: -- error message.
411: --
412: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
413: fnd_message.set_token('TABLE_NAME', 'pay_batch_lines');
414: fnd_message.raise_error;
415: End lck;
416: --
417: -- ----------------------------------------------------------------------------

Line 735: cursor csr_batch_id (p_batch_line_id pay_batch_lines.batch_line_id%type) is

731: select cost_allocation_structure
732: from per_business_groups
733: where business_group_id= c_business_group_id;
734:
735: cursor csr_batch_id (p_batch_line_id pay_batch_lines.batch_line_id%type) is
736: select pbl.batch_id
737: from pay_batch_lines pbl
738: where pbl.batch_line_id = p_batch_line_id;
739:

Line 737: from pay_batch_lines pbl

733: where business_group_id= c_business_group_id;
734:
735: cursor csr_batch_id (p_batch_line_id pay_batch_lines.batch_line_id%type) is
736: select pbl.batch_id
737: from pay_batch_lines pbl
738: where pbl.batch_line_id = p_batch_line_id;
739:
740: cursor csr_get_concat_segments(c_ccid pay_batch_lines.cost_allocation_keyflex_id%type) is
741: select concatenated_segments

Line 740: cursor csr_get_concat_segments(c_ccid pay_batch_lines.cost_allocation_keyflex_id%type) is

736: select pbl.batch_id
737: from pay_batch_lines pbl
738: where pbl.batch_line_id = p_batch_line_id;
739:
740: cursor csr_get_concat_segments(c_ccid pay_batch_lines.cost_allocation_keyflex_id%type) is
741: select concatenated_segments
742: from pay_cost_allocation_keyflex
743: where cost_allocation_keyflex_id = c_ccid;
744:

Line 746: l_ccid pay_batch_lines.cost_allocation_keyflex_id%type;

742: from pay_cost_allocation_keyflex
743: where cost_allocation_keyflex_id = c_ccid;
744:
745: l_business_group_id pay_batch_headers.business_group_id%type;
746: l_ccid pay_batch_lines.cost_allocation_keyflex_id%type;
747: l_concat_segments_out pay_batch_lines.concatenated_segments%type;
748: l_batch_id pay_batch_headers.batch_id%type;
749: l_check_segments boolean;
750: l_proc varchar2(72) := g_package||'keyflex_comb';

Line 747: l_concat_segments_out pay_batch_lines.concatenated_segments%type;

743: where cost_allocation_keyflex_id = c_ccid;
744:
745: l_business_group_id pay_batch_headers.business_group_id%type;
746: l_ccid pay_batch_lines.cost_allocation_keyflex_id%type;
747: l_concat_segments_out pay_batch_lines.concatenated_segments%type;
748: l_batch_id pay_batch_headers.batch_id%type;
749: l_check_segments boolean;
750: l_proc varchar2(72) := g_package||'keyflex_comb';
751: l_id_flex_num pay_cost_allocation_keyflex.id_flex_num%type;

Line 909: cursor csr_get_segs(c_ccid pay_batch_lines.cost_allocation_keyflex_id%type ) is

905: )
906: is
907:
908:
909: cursor csr_get_segs(c_ccid pay_batch_lines.cost_allocation_keyflex_id%type ) is
910: select segment1,segment2,segment3,segment4,segment5,segment6,segment7,segment8,segment9,
911: segment10,segment11,segment12,segment13,segment14,segment15,segment16,segment17,
912: segment18,segment19,segment20,segment21,segment22,segment23,segment24,segment25,
913: segment26,segment27,segment28,segment29,segment30