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 646: from pay_batch_lines pbl

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

Line 771: from pay_batch_lines pbl

767: and pbh.batch_id = ppa.batch_id
768: and ppa.action_type = 'BEE'
769: and not exists
770: (select null
771: from pay_batch_lines pbl
772: where pbl.batch_id = pbh.batch_id
773: and pbl.batch_line_status = 'T');
774:
775: cursor csr_get_parent_req_id (p_request_id NUMBER) is