APPS.PAY_MIX_ROLLBACK_PKG dependencies on PAY_BATCH_LINES

Line 45: batch_line_id pay_batch_lines.batch_id%type,

41: ) is
42:
43: type batch_line is record
44: (
45: batch_line_id pay_batch_lines.batch_id%type,
46: assignment_id pay_batch_lines.assignment_id%type,
47: assignment_number pay_batch_lines.assignment_number%type,
48: element_type_id pay_batch_lines.element_type_id%type,
49: effective_date pay_batch_lines.effective_date%type,

Line 46: assignment_id pay_batch_lines.assignment_id%type,

42:
43: type batch_line is record
44: (
45: batch_line_id pay_batch_lines.batch_id%type,
46: assignment_id pay_batch_lines.assignment_id%type,
47: assignment_number pay_batch_lines.assignment_number%type,
48: element_type_id pay_batch_lines.element_type_id%type,
49: effective_date pay_batch_lines.effective_date%type,
50: effective_start_date pay_batch_lines.effective_start_date%type

Line 47: assignment_number pay_batch_lines.assignment_number%type,

43: type batch_line is record
44: (
45: batch_line_id pay_batch_lines.batch_id%type,
46: assignment_id pay_batch_lines.assignment_id%type,
47: assignment_number pay_batch_lines.assignment_number%type,
48: element_type_id pay_batch_lines.element_type_id%type,
49: effective_date pay_batch_lines.effective_date%type,
50: effective_start_date pay_batch_lines.effective_start_date%type
51: );

Line 48: element_type_id pay_batch_lines.element_type_id%type,

44: (
45: batch_line_id pay_batch_lines.batch_id%type,
46: assignment_id pay_batch_lines.assignment_id%type,
47: assignment_number pay_batch_lines.assignment_number%type,
48: element_type_id pay_batch_lines.element_type_id%type,
49: effective_date pay_batch_lines.effective_date%type,
50: effective_start_date pay_batch_lines.effective_start_date%type
51: );
52:

Line 49: effective_date pay_batch_lines.effective_date%type,

45: batch_line_id pay_batch_lines.batch_id%type,
46: assignment_id pay_batch_lines.assignment_id%type,
47: assignment_number pay_batch_lines.assignment_number%type,
48: element_type_id pay_batch_lines.element_type_id%type,
49: effective_date pay_batch_lines.effective_date%type,
50: effective_start_date pay_batch_lines.effective_start_date%type
51: );
52:
53: l_business_group_id number;

Line 50: effective_start_date pay_batch_lines.effective_start_date%type

46: assignment_id pay_batch_lines.assignment_id%type,
47: assignment_number pay_batch_lines.assignment_number%type,
48: element_type_id pay_batch_lines.element_type_id%type,
49: effective_date pay_batch_lines.effective_date%type,
50: effective_start_date pay_batch_lines.effective_start_date%type
51: );
52:
53: l_business_group_id number;
54: l_check_batch_id varchar2(1) := 'N';

Line 88: from pay_batch_lines pbl

84: pbl.assignment_number,
85: pbl.element_type_id,
86: pbl.effective_date,
87: pbl.effective_start_date
88: from pay_batch_lines pbl
89: where pbl.batch_id = p_batch_header_id
90: and pbl.batch_line_status = 'T'
91: and (p_assignment_id is null or pbl.assignment_id = p_assignment_id)
92: union all

Line 452: update pay_batch_lines

448: -- change batch line status to 'unprocessed'
449: --
450: payplnk.g_payplnk_call := true;
451: --
452: update pay_batch_lines
453: set batch_line_status = 'U'
454: where batch_line_id = l_batch_line.batch_line_id;
455: --
456: payplnk.g_payplnk_call := false;

Line 477: update pay_batch_lines

473: and l_reject_ent_not_removed <> 'Y')) then
474: --
475: payplnk.g_payplnk_call := true;
476: --
477: update pay_batch_lines
478: set batch_line_status = 'U'
479: where batch_line_id = l_batch_line.batch_line_id;
480: --
481: payplnk.g_payplnk_call := false;

Line 644: from pay_batch_lines pbl

640: where pct.batch_id = p_batch_id
641: and pct.control_status <> 'U')
642: and exists
643: (select null
644: from pay_batch_lines pbl
645: where pbl.batch_id = p_batch_id
646: and pbl.batch_line_status <> 'T')
647: and exists
648: (select null

Line 741: from pay_batch_lines pbl

737: and pbh.batch_id = ppa.batch_id
738: and ppa.action_type = 'BEE'
739: and not exists
740: (select null
741: from pay_batch_lines pbl
742: where pbl.batch_id = pbh.batch_id
743: and pbl.batch_line_status = 'T');
744: --
745: l_rec csr_asg_act%ROWTYPE;