eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CA_RULES dependencies on PAY_PAYROLL_XML_EXTRACT_PKG

Line 602: pay_payroll_xml_extract_pkg.load_xml_data('D','PROPOSED_SALARY_CUSTOM',ln_proposed_salary );

598:
599: /* Takes care of NULL value for proposed salary. Custom tag
600: PROPOSED_SALARY_CUSTOM is populated*/
601:
602: pay_payroll_xml_extract_pkg.load_xml_data('D','PROPOSED_SALARY_CUSTOM',ln_proposed_salary );
603: CLOSE get_proposed_salary;
604:
605: /* Changes for Deposit Advice (XML) Enhancements starts here*/
606: OPEN get_preassact_id (P_ASSIGNMENT_ACTION_ID);

Line 609: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_FINAL_ADNUM',ln_deposit_advice_number);

605: /* Changes for Deposit Advice (XML) Enhancements starts here*/
606: OPEN get_preassact_id (P_ASSIGNMENT_ACTION_ID);
607: FETCH get_preassact_id INTO ln_deposit_advice_number ;
608: CLOSE get_preassact_id ;
609: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_FINAL_ADNUM',ln_deposit_advice_number);
610: OPEN get_depoadvice_deatils(P_ASSIGNMENT_ACTION_ID);
611: LOOP
612: FETCH get_depoadvice_deatils INTO lv_account_name,
613: lv_account_type,

Line 629: pay_payroll_xml_extract_pkg.load_xml_data('CS','DEPOSIT_ADVICE_DETAILS',null);

625: close get_depoadvice_deatils ;
626: exit;
627: ELSE
628: IF lv_payment_status = 'Paid' THEN /*bug 13870178 */
629: pay_payroll_xml_extract_pkg.load_xml_data('CS','DEPOSIT_ADVICE_DETAILS',null);
630: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);
631: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
632: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
633: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);

Line 630: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);

626: exit;
627: ELSE
628: IF lv_payment_status = 'Paid' THEN /*bug 13870178 */
629: pay_payroll_xml_extract_pkg.load_xml_data('CS','DEPOSIT_ADVICE_DETAILS',null);
630: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);
631: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
632: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
633: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
634: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);

Line 631: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);

627: ELSE
628: IF lv_payment_status = 'Paid' THEN /*bug 13870178 */
629: pay_payroll_xml_extract_pkg.load_xml_data('CS','DEPOSIT_ADVICE_DETAILS',null);
630: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);
631: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
632: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
633: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
634: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
635: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NUMBER',lv_bank_number);

Line 632: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);

628: IF lv_payment_status = 'Paid' THEN /*bug 13870178 */
629: pay_payroll_xml_extract_pkg.load_xml_data('CS','DEPOSIT_ADVICE_DETAILS',null);
630: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);
631: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
632: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
633: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
634: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
635: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NUMBER',lv_bank_number);
636: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_BRANCH',lv_bank_branch);

Line 633: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);

629: pay_payroll_xml_extract_pkg.load_xml_data('CS','DEPOSIT_ADVICE_DETAILS',null);
630: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);
631: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
632: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
633: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
634: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
635: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NUMBER',lv_bank_number);
636: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_BRANCH',lv_bank_branch);
637: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_depoad_num);

Line 634: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);

630: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);
631: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
632: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
633: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
634: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
635: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NUMBER',lv_bank_number);
636: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_BRANCH',lv_bank_branch);
637: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_depoad_num);
638: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);

Line 635: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NUMBER',lv_bank_number);

631: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
632: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
633: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
634: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
635: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NUMBER',lv_bank_number);
636: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_BRANCH',lv_bank_branch);
637: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_depoad_num);
638: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);
639: pay_payroll_xml_extract_pkg.load_xml_data('D','PAYMETHOD_ID',ln_paymethod_id);

Line 636: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_BRANCH',lv_bank_branch);

632: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
633: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
634: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
635: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NUMBER',lv_bank_number);
636: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_BRANCH',lv_bank_branch);
637: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_depoad_num);
638: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);
639: pay_payroll_xml_extract_pkg.load_xml_data('D','PAYMETHOD_ID',ln_paymethod_id);
640: pay_payroll_xml_extract_pkg.load_xml_data('D','PAYMETHOD_TYPE',ln_paymethod_type);

Line 637: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_depoad_num);

633: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
634: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
635: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NUMBER',lv_bank_number);
636: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_BRANCH',lv_bank_branch);
637: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_depoad_num);
638: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);
639: pay_payroll_xml_extract_pkg.load_xml_data('D','PAYMETHOD_ID',ln_paymethod_id);
640: pay_payroll_xml_extract_pkg.load_xml_data('D','PAYMETHOD_TYPE',ln_paymethod_type);
641: pay_payroll_xml_extract_pkg.load_xml_data('CE','DEPOSIT_ADVICE_DETAILS',null);

Line 638: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);

634: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
635: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NUMBER',lv_bank_number);
636: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_BRANCH',lv_bank_branch);
637: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_depoad_num);
638: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);
639: pay_payroll_xml_extract_pkg.load_xml_data('D','PAYMETHOD_ID',ln_paymethod_id);
640: pay_payroll_xml_extract_pkg.load_xml_data('D','PAYMETHOD_TYPE',ln_paymethod_type);
641: pay_payroll_xml_extract_pkg.load_xml_data('CE','DEPOSIT_ADVICE_DETAILS',null);
642: END IF;

Line 639: pay_payroll_xml_extract_pkg.load_xml_data('D','PAYMETHOD_ID',ln_paymethod_id);

635: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NUMBER',lv_bank_number);
636: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_BRANCH',lv_bank_branch);
637: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_depoad_num);
638: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);
639: pay_payroll_xml_extract_pkg.load_xml_data('D','PAYMETHOD_ID',ln_paymethod_id);
640: pay_payroll_xml_extract_pkg.load_xml_data('D','PAYMETHOD_TYPE',ln_paymethod_type);
641: pay_payroll_xml_extract_pkg.load_xml_data('CE','DEPOSIT_ADVICE_DETAILS',null);
642: END IF;
643: END IF;

Line 640: pay_payroll_xml_extract_pkg.load_xml_data('D','PAYMETHOD_TYPE',ln_paymethod_type);

636: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_BRANCH',lv_bank_branch);
637: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_depoad_num);
638: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);
639: pay_payroll_xml_extract_pkg.load_xml_data('D','PAYMETHOD_ID',ln_paymethod_id);
640: pay_payroll_xml_extract_pkg.load_xml_data('D','PAYMETHOD_TYPE',ln_paymethod_type);
641: pay_payroll_xml_extract_pkg.load_xml_data('CE','DEPOSIT_ADVICE_DETAILS',null);
642: END IF;
643: END IF;
644: END LOOP;

Line 641: pay_payroll_xml_extract_pkg.load_xml_data('CE','DEPOSIT_ADVICE_DETAILS',null);

637: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_depoad_num);
638: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);
639: pay_payroll_xml_extract_pkg.load_xml_data('D','PAYMETHOD_ID',ln_paymethod_id);
640: pay_payroll_xml_extract_pkg.load_xml_data('D','PAYMETHOD_TYPE',ln_paymethod_type);
641: pay_payroll_xml_extract_pkg.load_xml_data('CE','DEPOSIT_ADVICE_DETAILS',null);
642: END IF;
643: END IF;
644: END LOOP;
645:

Line 666: pay_payroll_xml_extract_pkg.load_xml_data('CS','CA_EMPLOYEE_NET_PAY_DISTRIBUTION',null);

662: IF get_net_pay_dstr_details%NOTFOUND THEN
663: close get_net_pay_dstr_details;
664: EXIT;
665: ELSE
666: pay_payroll_xml_extract_pkg.load_xml_data('CS','CA_EMPLOYEE_NET_PAY_DISTRIBUTION',null);
667: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_DEPOSIT_NUMBER',lv_check_number);
668:
669: -- org_payment_method_id added for bug 13024522
670: pay_payroll_xml_extract_pkg.load_xml_data('D','ORG_PAYMENT_METHOD_ID',lv_org_payment_method_id);

Line 667: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_DEPOSIT_NUMBER',lv_check_number);

663: close get_net_pay_dstr_details;
664: EXIT;
665: ELSE
666: pay_payroll_xml_extract_pkg.load_xml_data('CS','CA_EMPLOYEE_NET_PAY_DISTRIBUTION',null);
667: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_DEPOSIT_NUMBER',lv_check_number);
668:
669: -- org_payment_method_id added for bug 13024522
670: pay_payroll_xml_extract_pkg.load_xml_data('D','ORG_PAYMENT_METHOD_ID',lv_org_payment_method_id);
671:

Line 670: pay_payroll_xml_extract_pkg.load_xml_data('D','ORG_PAYMENT_METHOD_ID',lv_org_payment_method_id);

666: pay_payroll_xml_extract_pkg.load_xml_data('CS','CA_EMPLOYEE_NET_PAY_DISTRIBUTION',null);
667: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_DEPOSIT_NUMBER',lv_check_number);
668:
669: -- org_payment_method_id added for bug 13024522
670: pay_payroll_xml_extract_pkg.load_xml_data('D','ORG_PAYMENT_METHOD_ID',lv_org_payment_method_id);
671:
672: pay_payroll_xml_extract_pkg.load_xml_data('D','VALUE',ln_check_value);
673: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
674: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);

Line 672: pay_payroll_xml_extract_pkg.load_xml_data('D','VALUE',ln_check_value);

668:
669: -- org_payment_method_id added for bug 13024522
670: pay_payroll_xml_extract_pkg.load_xml_data('D','ORG_PAYMENT_METHOD_ID',lv_org_payment_method_id);
671:
672: pay_payroll_xml_extract_pkg.load_xml_data('D','VALUE',ln_check_value);
673: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
674: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
675: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NUMBER',lv_bank_number);
676: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',

Line 673: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);

669: -- org_payment_method_id added for bug 13024522
670: pay_payroll_xml_extract_pkg.load_xml_data('D','ORG_PAYMENT_METHOD_ID',lv_org_payment_method_id);
671:
672: pay_payroll_xml_extract_pkg.load_xml_data('D','VALUE',ln_check_value);
673: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
674: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
675: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NUMBER',lv_bank_number);
676: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',
677: HR_GENERAL2.mask_characters(ln_account_number));

Line 674: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);

670: pay_payroll_xml_extract_pkg.load_xml_data('D','ORG_PAYMENT_METHOD_ID',lv_org_payment_method_id);
671:
672: pay_payroll_xml_extract_pkg.load_xml_data('D','VALUE',ln_check_value);
673: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
674: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
675: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NUMBER',lv_bank_number);
676: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',
677: HR_GENERAL2.mask_characters(ln_account_number));
678: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);

Line 675: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NUMBER',lv_bank_number);

671:
672: pay_payroll_xml_extract_pkg.load_xml_data('D','VALUE',ln_check_value);
673: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
674: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
675: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NUMBER',lv_bank_number);
676: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',
677: HR_GENERAL2.mask_characters(ln_account_number));
678: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
679: pay_payroll_xml_extract_pkg.load_xml_data('CE','CA_EMPLOYEE_NET_PAY_DISTRIBUTION',null);

Line 676: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',

672: pay_payroll_xml_extract_pkg.load_xml_data('D','VALUE',ln_check_value);
673: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
674: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
675: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NUMBER',lv_bank_number);
676: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',
677: HR_GENERAL2.mask_characters(ln_account_number));
678: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
679: pay_payroll_xml_extract_pkg.load_xml_data('CE','CA_EMPLOYEE_NET_PAY_DISTRIBUTION',null);
680:

Line 678: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);

674: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
675: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NUMBER',lv_bank_number);
676: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',
677: HR_GENERAL2.mask_characters(ln_account_number));
678: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
679: pay_payroll_xml_extract_pkg.load_xml_data('CE','CA_EMPLOYEE_NET_PAY_DISTRIBUTION',null);
680:
681: END IF;
682: END LOOP;

Line 679: pay_payroll_xml_extract_pkg.load_xml_data('CE','CA_EMPLOYEE_NET_PAY_DISTRIBUTION',null);

675: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NUMBER',lv_bank_number);
676: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',
677: HR_GENERAL2.mask_characters(ln_account_number));
678: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
679: pay_payroll_xml_extract_pkg.load_xml_data('CE','CA_EMPLOYEE_NET_PAY_DISTRIBUTION',null);
680:
681: END IF;
682: END LOOP;
683:

Line 692: pay_payroll_xml_extract_pkg.load_xml_data('D','NET_PAY_YTD',ln_net_pay_ytd );

688: IF p_action_information_category = 'AC SUMMARY YTD' THEN
689:
690: OPEN get_net_pay_ytd(p_assignment_action_id);
691: FETCH get_net_pay_ytd INTO ln_net_pay_ytd;
692: pay_payroll_xml_extract_pkg.load_xml_data('D','NET_PAY_YTD',ln_net_pay_ytd );
693: CLOSE get_net_pay_ytd;
694:
695: END IF;
696:

Line 703: pay_payroll_xml_extract_pkg.load_xml_data('D','NET_PAY',ln_amount);

699: OPEN get_net_pay(p_assignment_action_id);
700: FETCH get_net_pay into ln_amount;
701: CLOSE get_net_pay;
702:
703: pay_payroll_xml_extract_pkg.load_xml_data('D','NET_PAY',ln_amount);
704:
705: END IF;
706:
707: /*Added the code to display employee and employer country name on pdf payslip */

Line 712: pay_payroll_xml_extract_pkg.load_xml_data('D','EE_COUNTRY',ln_employee_country );

708:
709: IF p_action_information_category = 'ADDRESS DETAILS' THEN
710: OPEN get_employee_country(p_assignment_action_id);
711: FETCH get_employee_country INTO ln_employee_country;
712: pay_payroll_xml_extract_pkg.load_xml_data('D','EE_COUNTRY',ln_employee_country );
713: CLOSE get_employee_country;
714:
715: OPEN get_employer_country(p_assignment_action_id);
716: FETCH get_employer_country INTO ln_employer_country;

Line 717: pay_payroll_xml_extract_pkg.load_xml_data('D','ER_COUNTRY',ln_employer_country );

713: CLOSE get_employee_country;
714:
715: OPEN get_employer_country(p_assignment_action_id);
716: FETCH get_employer_country INTO ln_employer_country;
717: pay_payroll_xml_extract_pkg.load_xml_data('D','ER_COUNTRY',ln_employer_country );
718: CLOSE get_employer_country;
719:
720: END IF;
721: END IF;

Line 744: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_NUMBER',lv_check_number);

740: lv_check_number;
741: CLOSE get_check_depoad_details;
742: IF lv_category = 'CH' THEN
743: hr_utility.trace('sbachu employee details2.......');
744: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_NUMBER',lv_check_number);
745: lv_amount_in_word := CF_word_amountFormula(ln_check_value);
746: pay_payroll_xml_extract_pkg.load_xml_data('D','AMOUNT_IN_WORDS',lv_amount_in_word);
747: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_AMOUNT',ln_check_value);
748: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);

Line 746: pay_payroll_xml_extract_pkg.load_xml_data('D','AMOUNT_IN_WORDS',lv_amount_in_word);

742: IF lv_category = 'CH' THEN
743: hr_utility.trace('sbachu employee details2.......');
744: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_NUMBER',lv_check_number);
745: lv_amount_in_word := CF_word_amountFormula(ln_check_value);
746: pay_payroll_xml_extract_pkg.load_xml_data('D','AMOUNT_IN_WORDS',lv_amount_in_word);
747: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_AMOUNT',ln_check_value);
748: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);
749: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
750: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);

Line 747: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_AMOUNT',ln_check_value);

743: hr_utility.trace('sbachu employee details2.......');
744: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_NUMBER',lv_check_number);
745: lv_amount_in_word := CF_word_amountFormula(ln_check_value);
746: pay_payroll_xml_extract_pkg.load_xml_data('D','AMOUNT_IN_WORDS',lv_amount_in_word);
747: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_AMOUNT',ln_check_value);
748: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);
749: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
750: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
751: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);

Line 748: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);

744: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_NUMBER',lv_check_number);
745: lv_amount_in_word := CF_word_amountFormula(ln_check_value);
746: pay_payroll_xml_extract_pkg.load_xml_data('D','AMOUNT_IN_WORDS',lv_amount_in_word);
747: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_AMOUNT',ln_check_value);
748: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);
749: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
750: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
751: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
752: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);

Line 749: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);

745: lv_amount_in_word := CF_word_amountFormula(ln_check_value);
746: pay_payroll_xml_extract_pkg.load_xml_data('D','AMOUNT_IN_WORDS',lv_amount_in_word);
747: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_AMOUNT',ln_check_value);
748: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);
749: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
750: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
751: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
752: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
753: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_BRANCH',lv_bank_branch);

Line 750: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);

746: pay_payroll_xml_extract_pkg.load_xml_data('D','AMOUNT_IN_WORDS',lv_amount_in_word);
747: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_AMOUNT',ln_check_value);
748: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);
749: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
750: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
751: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
752: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
753: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_BRANCH',lv_bank_branch);
754: END IF;

Line 751: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);

747: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_AMOUNT',ln_check_value);
748: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);
749: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
750: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
751: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
752: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
753: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_BRANCH',lv_bank_branch);
754: END IF;
755:

Line 752: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);

748: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);
749: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
750: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
751: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
752: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
753: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_BRANCH',lv_bank_branch);
754: END IF;
755:
756: IF lv_category <> 'CH' THEN

Line 753: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_BRANCH',lv_bank_branch);

749: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
750: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
751: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
752: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
753: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_BRANCH',lv_bank_branch);
754: END IF;
755:
756: IF lv_category <> 'CH' THEN
757: OPEN get_check_num_for_depad (P_ASSIGNMENT_ACTION_ID);

Line 768: pay_payroll_xml_extract_pkg.load_xml_data('CS','CHECK_DETAILS',null);

764: IF get_check_num_for_depad%NOTFOUND THEN
765: close get_check_num_for_depad;
766: EXIT;
767: ELSE
768: pay_payroll_xml_extract_pkg.load_xml_data('CS','CHECK_DETAILS',null);
769: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_account_number);
770: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);
771: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
772: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);

Line 769: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_account_number);

765: close get_check_num_for_depad;
766: EXIT;
767: ELSE
768: pay_payroll_xml_extract_pkg.load_xml_data('CS','CHECK_DETAILS',null);
769: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_account_number);
770: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);
771: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
772: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
773: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number1);

Line 770: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);

766: EXIT;
767: ELSE
768: pay_payroll_xml_extract_pkg.load_xml_data('CS','CHECK_DETAILS',null);
769: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_account_number);
770: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);
771: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
772: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
773: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number1);
774: pay_payroll_xml_extract_pkg.load_xml_data('CE','CHECK_DETAILS',null);

Line 771: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);

767: ELSE
768: pay_payroll_xml_extract_pkg.load_xml_data('CS','CHECK_DETAILS',null);
769: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_account_number);
770: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);
771: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
772: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
773: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number1);
774: pay_payroll_xml_extract_pkg.load_xml_data('CE','CHECK_DETAILS',null);
775:

Line 772: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);

768: pay_payroll_xml_extract_pkg.load_xml_data('CS','CHECK_DETAILS',null);
769: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_account_number);
770: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);
771: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
772: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
773: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number1);
774: pay_payroll_xml_extract_pkg.load_xml_data('CE','CHECK_DETAILS',null);
775:
776:

Line 773: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number1);

769: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_account_number);
770: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);
771: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
772: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
773: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number1);
774: pay_payroll_xml_extract_pkg.load_xml_data('CE','CHECK_DETAILS',null);
775:
776:
777: END IF;

Line 774: pay_payroll_xml_extract_pkg.load_xml_data('CE','CHECK_DETAILS',null);

770: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);
771: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
772: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
773: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number1);
774: pay_payroll_xml_extract_pkg.load_xml_data('CE','CHECK_DETAILS',null);
775:
776:
777: END IF;
778: END LOOP;

Line 786: pay_payroll_xml_extract_pkg.load_xml_data('D','NET_PAY_YTD',ln_net_pay_ytd );

782: IF p_action_information_category = 'AC SUMMARY YTD' THEN
783: hr_utility.trace('sbachu AC SUMMARY YTD.......');
784: OPEN get_net_pay_ytd(p_assignment_action_id);
785: FETCH get_net_pay_ytd INTO ln_net_pay_ytd;
786: pay_payroll_xml_extract_pkg.load_xml_data('D','NET_PAY_YTD',ln_net_pay_ytd );
787: CLOSE get_net_pay_ytd;
788:
789: END IF;
790:

Line 797: pay_payroll_xml_extract_pkg.load_xml_data('D','NET_PAY',ln_amount);

793: OPEN get_net_pay(p_assignment_action_id);
794: FETCH get_net_pay into ln_amount;
795: CLOSE get_net_pay;
796:
797: pay_payroll_xml_extract_pkg.load_xml_data('D','NET_PAY',ln_amount);
798:
799: END IF;
800:
801: END IF;

Line 811: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_NUMBER',ln_depoad_num);

807: OPEN get_third_party_check_info(P_ASSIGNMENT_ACTION_ID, pay_archive_chequewriter.g_chq_asg_action_id);
808: FETCH get_third_party_check_info into ln_depoad_num, ln_check_value, lv_employee_name,lv_ER_Transit_code, lv_ER_Account_Number;
809: CLOSE get_third_party_check_info;
810: lv_amount_in_word := CF_word_amountFormula(ln_check_value);
811: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_NUMBER',ln_depoad_num);
812: pay_payroll_xml_extract_pkg.load_xml_data('D','AMOUNT_IN_WORDS',lv_amount_in_word);
813: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYEE_NAME',lv_employee_name);
814: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_ER_Transit_code);
815: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',lv_ER_Account_Number);

Line 812: pay_payroll_xml_extract_pkg.load_xml_data('D','AMOUNT_IN_WORDS',lv_amount_in_word);

808: FETCH get_third_party_check_info into ln_depoad_num, ln_check_value, lv_employee_name,lv_ER_Transit_code, lv_ER_Account_Number;
809: CLOSE get_third_party_check_info;
810: lv_amount_in_word := CF_word_amountFormula(ln_check_value);
811: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_NUMBER',ln_depoad_num);
812: pay_payroll_xml_extract_pkg.load_xml_data('D','AMOUNT_IN_WORDS',lv_amount_in_word);
813: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYEE_NAME',lv_employee_name);
814: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_ER_Transit_code);
815: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',lv_ER_Account_Number);
816: /*changes for bug 13849708 ends here*/

Line 813: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYEE_NAME',lv_employee_name);

809: CLOSE get_third_party_check_info;
810: lv_amount_in_word := CF_word_amountFormula(ln_check_value);
811: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_NUMBER',ln_depoad_num);
812: pay_payroll_xml_extract_pkg.load_xml_data('D','AMOUNT_IN_WORDS',lv_amount_in_word);
813: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYEE_NAME',lv_employee_name);
814: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_ER_Transit_code);
815: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',lv_ER_Account_Number);
816: /*changes for bug 13849708 ends here*/
817: END IF;

Line 814: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_ER_Transit_code);

810: lv_amount_in_word := CF_word_amountFormula(ln_check_value);
811: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_NUMBER',ln_depoad_num);
812: pay_payroll_xml_extract_pkg.load_xml_data('D','AMOUNT_IN_WORDS',lv_amount_in_word);
813: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYEE_NAME',lv_employee_name);
814: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_ER_Transit_code);
815: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',lv_ER_Account_Number);
816: /*changes for bug 13849708 ends here*/
817: END IF;
818:

Line 815: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',lv_ER_Account_Number);

811: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_NUMBER',ln_depoad_num);
812: pay_payroll_xml_extract_pkg.load_xml_data('D','AMOUNT_IN_WORDS',lv_amount_in_word);
813: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYEE_NAME',lv_employee_name);
814: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_ER_Transit_code);
815: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',lv_ER_Account_Number);
816: /*changes for bug 13849708 ends here*/
817: END IF;
818:
819: IF P_DOCUMENT_TYPE like '%THIRD%PARTY%CHEQUE%WRITER' AND