APPS.PAY_BATCH_BALANCEADJ_WRAPPER dependencies on PAY_ADJUST_BATCH_LINES

Line 352: l_batch_line_status pay_adjust_batch_lines.batch_line_status%TYPE;

348: p_col_val4 in varchar2 default null,
349: p_col_val5 in varchar2 default null) IS
350:
351: l_batch_group_status pay_adjust_batch_groups.batch_group_status%TYPE;
352: l_batch_line_status pay_adjust_batch_lines.batch_line_status%TYPE;
353:
354: l_cakff_id number;
355: l_batch_line_id pay_adjust_batch_lines.batch_line_id%TYPE;
356:

Line 355: l_batch_line_id pay_adjust_batch_lines.batch_line_id%TYPE;

351: l_batch_group_status pay_adjust_batch_groups.batch_group_status%TYPE;
352: l_batch_line_status pay_adjust_batch_lines.batch_line_status%TYPE;
353:
354: l_cakff_id number;
355: l_batch_line_id pay_adjust_batch_lines.batch_line_id%TYPE;
356:
357: Begin
358:
359:

Line 467: update pay_adjust_batch_lines

463: segment26,segment27,segment28,segment29,segment30);
464:
465: end if;
466:
467: update pay_adjust_batch_lines
468: set assignment_id = p_assignment_id,
469: tax_unit_id = p_gre_id,
470: entry_value1 = p_ee_value1,
471: entry_value2 = p_ee_value2,

Line 596: from pay_adjust_batch_lines

592: ln_batch_group_id number,
593: ln_assignment_id number,
594: ln_element_type_id number) IS
595: select batch_line_id, batch_line_status
596: from pay_adjust_batch_lines
597: where batch_id = ln_batch_id
598: and batch_group_id = ln_batch_group_id
599: and assignment_id = ln_assignment_id
600: and element_type_id = ln_element_type_id;

Line 606: FROM pay_adjust_batch_lines

602: -- Bug: 5212904
603:
604: CURSOR csr_get_batch_line_details IS
605: SELECT batch_line_status, batch_group_id, assignment_id
606: FROM pay_adjust_batch_lines
607: WHERE batch_line_id = p_batch_line_id
608: AND batch_id = p_batch_id;
609:
610: CURSOR csr_get_batch_group_details(l_batch_group_id number) IS

Line 1561: hr_utility.trace('Update of pay_adjust_batch_lines ');

1557: hr_utility.trace('l_cakff_id :'||to_char(l_cakff_id));
1558:
1559: end if;
1560:
1561: hr_utility.trace('Update of pay_adjust_batch_lines ');
1562:
1563: UPDATE pay_adjust_batch_lines
1564: SET entry_value1 = g_ee_value1,
1565: entry_value2 = g_ee_value2,

Line 1563: UPDATE pay_adjust_batch_lines

1559: end if;
1560:
1561: hr_utility.trace('Update of pay_adjust_batch_lines ');
1562:
1563: UPDATE pay_adjust_batch_lines
1564: SET entry_value1 = g_ee_value1,
1565: entry_value2 = g_ee_value2,
1566: entry_value3 = g_ee_value3,
1567: entry_value4 = g_ee_value4,

Line 1590: hr_utility.trace('No data found for pay_adjust_batch_lines ');

1586:
1587: end if; /*End of If l_batch_line_status in ('C','T') */
1588:
1589: else
1590: hr_utility.trace('No data found for pay_adjust_batch_lines ');
1591:
1592: IF l_costing_flag = 'Y' THEN
1593: hr_utility.trace('Costing Flag is set to Yes ');
1594: l_cakff_id := get_costing_info(p_concatenated_segments,

Line 1604: hr_utility.trace('inserting into pay_adjust_batch_lines table');

1600: segment26,segment27,segment28,segment29,segment30);
1601: hr_utility.trace('l_cakff_id :'||to_char(l_cakff_id));
1602: END IF;
1603:
1604: hr_utility.trace('inserting into pay_adjust_batch_lines table');
1605: insert into pay_adjust_batch_lines(batch_line_id,
1606: batch_id,
1607: batch_line_status,
1608: batch_group_id,

Line 1605: insert into pay_adjust_batch_lines(batch_line_id,

1601: hr_utility.trace('l_cakff_id :'||to_char(l_cakff_id));
1602: END IF;
1603:
1604: hr_utility.trace('inserting into pay_adjust_batch_lines table');
1605: insert into pay_adjust_batch_lines(batch_line_id,
1606: batch_id,
1607: batch_line_status,
1608: batch_group_id,
1609: batch_line_sequence,

Line 1645: values (pay_adjust_batch_lines_s.nextval,

1641: entry_value15,
1642: balance_adj_cost_flag,
1643: cost_allocation_keyflex_id,
1644: tax_unit_id)
1645: values (pay_adjust_batch_lines_s.nextval,
1646: p_batch_id,
1647: 'U',
1648: l_batch_group_id,
1649: 1,