APPS.PAY_CN_BAL_UPLOAD dependencies on PAY_CN_BAL_UPLOAD

Line 1: PACKAGE BODY pay_cn_bal_upload AS

1: PACKAGE BODY pay_cn_bal_upload AS
2: /* $Header: pycnupld.pkb 120.1 2005/12/19 21:36:05 snekkala noship $ */
3:
4: -- Date constants.
5: START_OF_TIME CONSTANT DATE := TO_DATE('01/01/0001','DD/MM/YYYY');

Line 383: hr_utility.trace('Entering pay_cn_bal_upload.is_supported');

379: l_dimension_id NUMBER;
380: --
381: BEGIN
382: --
383: hr_utility.trace('Entering pay_cn_bal_upload.is_supported');
384: --
385: -- See if the dimension is supported.
386: --
387: OPEN csr_dimension (p_dimension_name);

Line 398: hr_utility.trace('Exiting pay_cn_bal_upload.is_supported');

394: CLOSE csr_dimension;
395: RETURN (1); -- denotes TRUE
396: END IF;
397: --
398: hr_utility.trace('Exiting pay_cn_bal_upload.is_supported');
399: --
400: EXCEPTION
401: WHEN others THEN
402: CLOSE csr_dimension;

Line 506: hr_utility.trace('Entering pay_cn_bal_upload.include_adjustment_test');

502: l_adj_tax_unit_id pay_temp_balance_adjustments.tax_unit_id%TYPE;
503: l_adj_orig_entry_id pay_temp_balance_adjustments.original_entry_id%TYPE;
504:
505: BEGIN
506: hr_utility.trace('Entering pay_cn_bal_upload.include_adjustment_test');
507:
508: OPEN csr_get_tax_unit(p_batch_line_id);
509: FETCH csr_get_tax_unit
510: INTO l_tax_unit_id;

Line 537: hr_utility.trace('Exiting pay_cn_bal_upload.include_adjustment_test');

533: FETCH csr_is_included
534: INTO l_bal_type_id;
535: CLOSE csr_is_included;
536:
537: hr_utility.trace('Exiting pay_cn_bal_upload.include_adjustment_test');
538:
539: -- Adjustment does contribute to the new balance.
540:
541: IF l_bal_type_id IS NOT NULL THEN

Line 585: hr_utility.trace('Entering pay_cn_bal_upload.validate_batch_lines');

581: PROCEDURE validate_batch_lines (p_batch_id NUMBER)
582: IS
583:
584: BEGIN
585: hr_utility.trace('Entering pay_cn_bal_upload.validate_batch_lines');
586:
587: hr_utility.trace('Exiting pay_cn_bal_upload.validate_batch_lines');
588:
589: END validate_batch_lines;

Line 587: hr_utility.trace('Exiting pay_cn_bal_upload.validate_batch_lines');

583:
584: BEGIN
585: hr_utility.trace('Entering pay_cn_bal_upload.validate_batch_lines');
586:
587: hr_utility.trace('Exiting pay_cn_bal_upload.validate_batch_lines');
588:
589: END validate_batch_lines;
590:
591: END pay_cn_bal_upload;

Line 591: END pay_cn_bal_upload;

587: hr_utility.trace('Exiting pay_cn_bal_upload.validate_batch_lines');
588:
589: END validate_batch_lines;
590:
591: END pay_cn_bal_upload;