APPS.PAY_BATCH_BALANCEADJ_WRAPPER dependencies on PAY_ADJUST_BATCH_GROUPS

Line 351: l_batch_group_status pay_adjust_batch_groups.batch_group_status%TYPE;

347: p_col_val3 in varchar2 default null,
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;

Line 436: from pay_adjust_batch_groups

432: hr_utility.trace('p_col_val4 is : '|| p_col_val4 );
433: hr_utility.trace('p_col_val5 is : '|| p_col_val5 );
434:
435: select batch_group_status into l_batch_group_status
436: from pay_adjust_batch_groups
437: where batch_group_id = p_batch_group_id;
438:
439: if l_batch_group_status in ('L','T','C') then
440:

Line 445: update pay_adjust_batch_groups

441: raise value_found;
442:
443: else
444:
445: update pay_adjust_batch_groups
446: set consolidation_set_id = p_consolidation_set_id,
447: payroll_id = p_payroll_id,
448: effective_date = p_effective_date,
449: prepay_flag = p_prepay_flag

Line 584: from pay_adjust_batch_groups

580: ln_payroll_id number,
581: ln_effective_date date,
582: ln_prepay_flag varchar2) IS
583: select batch_group_id, batch_group_status
584: from pay_adjust_batch_groups
585: where batch_id = ln_batch_id
586: and consolidation_set_id = ln_consolidation_set_id
587: and payroll_id = ln_payroll_id
588: and effective_date = ln_effective_date

Line 612: FROM pay_adjust_batch_groups

608: AND batch_id = p_batch_id;
609:
610: CURSOR csr_get_batch_group_details(l_batch_group_id number) IS
611: SELECT batch_group_status, consolidation_set_id,effective_date, prepay_flag
612: FROM pay_adjust_batch_groups
613: WHERE batch_group_id = l_batch_group_id;
614:
615: -- Modified for the bug: 5212923
616:

Line 1474: hr_utility.trace('No data found for pay_adjust_batch_groups ');

1470: CLOSE csr_check_batch_group;
1471:
1472: if lv_batch_group_exists = 'N' then
1473:
1474: hr_utility.trace('No data found for pay_adjust_batch_groups ');
1475: select pay_adjust_batch_groups_s.nextval into l_batch_group_id
1476: from dual;
1477:
1478: insert into pay_adjust_batch_groups

Line 1475: select pay_adjust_batch_groups_s.nextval into l_batch_group_id

1471:
1472: if lv_batch_group_exists = 'N' then
1473:
1474: hr_utility.trace('No data found for pay_adjust_batch_groups ');
1475: select pay_adjust_batch_groups_s.nextval into l_batch_group_id
1476: from dual;
1477:
1478: insert into pay_adjust_batch_groups
1479: (batch_group_id,

Line 1478: insert into pay_adjust_batch_groups

1474: hr_utility.trace('No data found for pay_adjust_batch_groups ');
1475: select pay_adjust_batch_groups_s.nextval into l_batch_group_id
1476: from dual;
1477:
1478: insert into pay_adjust_batch_groups
1479: (batch_group_id,
1480: batch_id,
1481: batch_group_status,
1482: consolidation_set_id,

Line 1495: hr_utility.trace('Done inserting into pay_adjust_batch_groups table');

1491: p_effective_date,
1492: l_prepay_flag);
1493:
1494: l_batch_group_status := 'U';
1495: hr_utility.trace('Done inserting into pay_adjust_batch_groups table');
1496: hr_utility.trace('New Batch Group id: '||to_char(l_batch_group_id));
1497:
1498: end if; /* lv_batch_group_exists = 'N' */
1499: