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_US_RULES dependencies on PAY_PAYROLL_XML_EXTRACT_PKG

Line 2755: pay_payroll_xml_extract_pkg.load_xml_data('CS','US_EMPLOYER_ADDRESS',null);

2751: lv_employer_zip_code,
2752: lv_employer_country ;
2753: CLOSE get_us_employer_addr;
2754:
2755: pay_payroll_xml_extract_pkg.load_xml_data('CS','US_EMPLOYER_ADDRESS',null);
2756: pay_payroll_xml_extract_pkg.load_xml_data('D','ORGANIZATION_ID',ln_organization_id);
2757: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_TYPE','US Employer Address');
2758: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS1',lv_employer_address1);
2759: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS2',lv_employer_address2);

Line 2756: pay_payroll_xml_extract_pkg.load_xml_data('D','ORGANIZATION_ID',ln_organization_id);

2752: lv_employer_country ;
2753: CLOSE get_us_employer_addr;
2754:
2755: pay_payroll_xml_extract_pkg.load_xml_data('CS','US_EMPLOYER_ADDRESS',null);
2756: pay_payroll_xml_extract_pkg.load_xml_data('D','ORGANIZATION_ID',ln_organization_id);
2757: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_TYPE','US Employer Address');
2758: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS1',lv_employer_address1);
2759: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS2',lv_employer_address2);
2760: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS3',lv_employer_address3);

Line 2757: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_TYPE','US Employer Address');

2753: CLOSE get_us_employer_addr;
2754:
2755: pay_payroll_xml_extract_pkg.load_xml_data('CS','US_EMPLOYER_ADDRESS',null);
2756: pay_payroll_xml_extract_pkg.load_xml_data('D','ORGANIZATION_ID',ln_organization_id);
2757: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_TYPE','US Employer Address');
2758: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS1',lv_employer_address1);
2759: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS2',lv_employer_address2);
2760: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS3',lv_employer_address3);
2761: pay_payroll_xml_extract_pkg.load_xml_data('D','CITY',lv_employer_city);

Line 2758: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS1',lv_employer_address1);

2754:
2755: pay_payroll_xml_extract_pkg.load_xml_data('CS','US_EMPLOYER_ADDRESS',null);
2756: pay_payroll_xml_extract_pkg.load_xml_data('D','ORGANIZATION_ID',ln_organization_id);
2757: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_TYPE','US Employer Address');
2758: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS1',lv_employer_address1);
2759: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS2',lv_employer_address2);
2760: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS3',lv_employer_address3);
2761: pay_payroll_xml_extract_pkg.load_xml_data('D','CITY',lv_employer_city);
2762: pay_payroll_xml_extract_pkg.load_xml_data('D','STATE',lv_employer_state);

Line 2759: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS2',lv_employer_address2);

2755: pay_payroll_xml_extract_pkg.load_xml_data('CS','US_EMPLOYER_ADDRESS',null);
2756: pay_payroll_xml_extract_pkg.load_xml_data('D','ORGANIZATION_ID',ln_organization_id);
2757: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_TYPE','US Employer Address');
2758: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS1',lv_employer_address1);
2759: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS2',lv_employer_address2);
2760: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS3',lv_employer_address3);
2761: pay_payroll_xml_extract_pkg.load_xml_data('D','CITY',lv_employer_city);
2762: pay_payroll_xml_extract_pkg.load_xml_data('D','STATE',lv_employer_state);
2763: pay_payroll_xml_extract_pkg.load_xml_data('D','ZIP_CODE',lv_employer_zip_code);

Line 2760: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS3',lv_employer_address3);

2756: pay_payroll_xml_extract_pkg.load_xml_data('D','ORGANIZATION_ID',ln_organization_id);
2757: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_TYPE','US Employer Address');
2758: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS1',lv_employer_address1);
2759: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS2',lv_employer_address2);
2760: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS3',lv_employer_address3);
2761: pay_payroll_xml_extract_pkg.load_xml_data('D','CITY',lv_employer_city);
2762: pay_payroll_xml_extract_pkg.load_xml_data('D','STATE',lv_employer_state);
2763: pay_payroll_xml_extract_pkg.load_xml_data('D','ZIP_CODE',lv_employer_zip_code);
2764: pay_payroll_xml_extract_pkg.load_xml_data('D','COUNTRY',lv_employer_country);

Line 2761: pay_payroll_xml_extract_pkg.load_xml_data('D','CITY',lv_employer_city);

2757: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS_TYPE','US Employer Address');
2758: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS1',lv_employer_address1);
2759: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS2',lv_employer_address2);
2760: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS3',lv_employer_address3);
2761: pay_payroll_xml_extract_pkg.load_xml_data('D','CITY',lv_employer_city);
2762: pay_payroll_xml_extract_pkg.load_xml_data('D','STATE',lv_employer_state);
2763: pay_payroll_xml_extract_pkg.load_xml_data('D','ZIP_CODE',lv_employer_zip_code);
2764: pay_payroll_xml_extract_pkg.load_xml_data('D','COUNTRY',lv_employer_country);
2765: pay_payroll_xml_extract_pkg.load_xml_data('CE','US_EMPLOYER_ADDRESS',null);

Line 2762: pay_payroll_xml_extract_pkg.load_xml_data('D','STATE',lv_employer_state);

2758: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS1',lv_employer_address1);
2759: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS2',lv_employer_address2);
2760: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS3',lv_employer_address3);
2761: pay_payroll_xml_extract_pkg.load_xml_data('D','CITY',lv_employer_city);
2762: pay_payroll_xml_extract_pkg.load_xml_data('D','STATE',lv_employer_state);
2763: pay_payroll_xml_extract_pkg.load_xml_data('D','ZIP_CODE',lv_employer_zip_code);
2764: pay_payroll_xml_extract_pkg.load_xml_data('D','COUNTRY',lv_employer_country);
2765: pay_payroll_xml_extract_pkg.load_xml_data('CE','US_EMPLOYER_ADDRESS',null);
2766:

Line 2763: pay_payroll_xml_extract_pkg.load_xml_data('D','ZIP_CODE',lv_employer_zip_code);

2759: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS2',lv_employer_address2);
2760: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS3',lv_employer_address3);
2761: pay_payroll_xml_extract_pkg.load_xml_data('D','CITY',lv_employer_city);
2762: pay_payroll_xml_extract_pkg.load_xml_data('D','STATE',lv_employer_state);
2763: pay_payroll_xml_extract_pkg.load_xml_data('D','ZIP_CODE',lv_employer_zip_code);
2764: pay_payroll_xml_extract_pkg.load_xml_data('D','COUNTRY',lv_employer_country);
2765: pay_payroll_xml_extract_pkg.load_xml_data('CE','US_EMPLOYER_ADDRESS',null);
2766:
2767: /*Bug# 13529461 - Start*/

Line 2764: pay_payroll_xml_extract_pkg.load_xml_data('D','COUNTRY',lv_employer_country);

2760: pay_payroll_xml_extract_pkg.load_xml_data('D','ADDRESS3',lv_employer_address3);
2761: pay_payroll_xml_extract_pkg.load_xml_data('D','CITY',lv_employer_city);
2762: pay_payroll_xml_extract_pkg.load_xml_data('D','STATE',lv_employer_state);
2763: pay_payroll_xml_extract_pkg.load_xml_data('D','ZIP_CODE',lv_employer_zip_code);
2764: pay_payroll_xml_extract_pkg.load_xml_data('D','COUNTRY',lv_employer_country);
2765: pay_payroll_xml_extract_pkg.load_xml_data('CE','US_EMPLOYER_ADDRESS',null);
2766:
2767: /*Bug# 13529461 - Start*/
2768: /*This is an extension to the existing requirement in bug# 9382065,Basical we need to show the

Line 2765: pay_payroll_xml_extract_pkg.load_xml_data('CE','US_EMPLOYER_ADDRESS',null);

2761: pay_payroll_xml_extract_pkg.load_xml_data('D','CITY',lv_employer_city);
2762: pay_payroll_xml_extract_pkg.load_xml_data('D','STATE',lv_employer_state);
2763: pay_payroll_xml_extract_pkg.load_xml_data('D','ZIP_CODE',lv_employer_zip_code);
2764: pay_payroll_xml_extract_pkg.load_xml_data('D','COUNTRY',lv_employer_country);
2765: pay_payroll_xml_extract_pkg.load_xml_data('CE','US_EMPLOYER_ADDRESS',null);
2766:
2767: /*Bug# 13529461 - Start*/
2768: /*This is an extension to the existing requirement in bug# 9382065,Basical we need to show the
2769: employer name and phone number for the same organization for which we are showing up the Address

Line 2778: pay_payroll_xml_extract_pkg.load_xml_data('CS','US_EMPLOYER_DETAILS',null);

2774: FETCH get_employer_name_phone INTO lv_employer_name,
2775: lv_phone_number;
2776: CLOSE get_employer_name_phone;
2777:
2778: pay_payroll_xml_extract_pkg.load_xml_data('CS','US_EMPLOYER_DETAILS',null);
2779: pay_payroll_xml_extract_pkg.load_xml_data('D','US_EMPLOYER_NAME',lv_employer_name);
2780: pay_payroll_xml_extract_pkg.load_xml_data('D','US_EMPLOYER_PHONE',lv_phone_number);
2781: pay_payroll_xml_extract_pkg.load_xml_data('CE','US_EMPLOYER_DETAILS',null);
2782:

Line 2779: pay_payroll_xml_extract_pkg.load_xml_data('D','US_EMPLOYER_NAME',lv_employer_name);

2775: lv_phone_number;
2776: CLOSE get_employer_name_phone;
2777:
2778: pay_payroll_xml_extract_pkg.load_xml_data('CS','US_EMPLOYER_DETAILS',null);
2779: pay_payroll_xml_extract_pkg.load_xml_data('D','US_EMPLOYER_NAME',lv_employer_name);
2780: pay_payroll_xml_extract_pkg.load_xml_data('D','US_EMPLOYER_PHONE',lv_phone_number);
2781: pay_payroll_xml_extract_pkg.load_xml_data('CE','US_EMPLOYER_DETAILS',null);
2782:
2783: /*Bug# 13529461 - End*/

Line 2780: pay_payroll_xml_extract_pkg.load_xml_data('D','US_EMPLOYER_PHONE',lv_phone_number);

2776: CLOSE get_employer_name_phone;
2777:
2778: pay_payroll_xml_extract_pkg.load_xml_data('CS','US_EMPLOYER_DETAILS',null);
2779: pay_payroll_xml_extract_pkg.load_xml_data('D','US_EMPLOYER_NAME',lv_employer_name);
2780: pay_payroll_xml_extract_pkg.load_xml_data('D','US_EMPLOYER_PHONE',lv_phone_number);
2781: pay_payroll_xml_extract_pkg.load_xml_data('CE','US_EMPLOYER_DETAILS',null);
2782:
2783: /*Bug# 13529461 - End*/
2784:

Line 2781: pay_payroll_xml_extract_pkg.load_xml_data('CE','US_EMPLOYER_DETAILS',null);

2777:
2778: pay_payroll_xml_extract_pkg.load_xml_data('CS','US_EMPLOYER_DETAILS',null);
2779: pay_payroll_xml_extract_pkg.load_xml_data('D','US_EMPLOYER_NAME',lv_employer_name);
2780: pay_payroll_xml_extract_pkg.load_xml_data('D','US_EMPLOYER_PHONE',lv_phone_number);
2781: pay_payroll_xml_extract_pkg.load_xml_data('CE','US_EMPLOYER_DETAILS',null);
2782:
2783: /*Bug# 13529461 - End*/
2784:
2785: /*Bug:9439388: Added the code to display net pay distribution section on pdf payslip

Line 2799: pay_payroll_xml_extract_pkg.load_xml_data('CS','US_EMPLOYEE_NET_PAY_DISTRIBUTION',null);

2795: IF get_net_pay_dstr_details%NOTFOUND THEN
2796: close get_net_pay_dstr_details;
2797: EXIT;
2798: ELSE
2799: pay_payroll_xml_extract_pkg.load_xml_data('CS','US_EMPLOYEE_NET_PAY_DISTRIBUTION',null);
2800: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_DEPOSIT_NUMBER',lv_check_number);
2801: pay_payroll_xml_extract_pkg.load_xml_data('D','VALUE',ln_check_value);
2802: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2803: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);

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

2796: close get_net_pay_dstr_details;
2797: EXIT;
2798: ELSE
2799: pay_payroll_xml_extract_pkg.load_xml_data('CS','US_EMPLOYEE_NET_PAY_DISTRIBUTION',null);
2800: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_DEPOSIT_NUMBER',lv_check_number);
2801: pay_payroll_xml_extract_pkg.load_xml_data('D','VALUE',ln_check_value);
2802: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2803: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2804: pay_payroll_xml_extract_pkg.load_xml_data('D','MASK_ACCOUNT_NUMBER',HR_GENERAL2.mask_characters(ln_account_number));

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

2797: EXIT;
2798: ELSE
2799: pay_payroll_xml_extract_pkg.load_xml_data('CS','US_EMPLOYEE_NET_PAY_DISTRIBUTION',null);
2800: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_DEPOSIT_NUMBER',lv_check_number);
2801: pay_payroll_xml_extract_pkg.load_xml_data('D','VALUE',ln_check_value);
2802: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2803: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2804: pay_payroll_xml_extract_pkg.load_xml_data('D','MASK_ACCOUNT_NUMBER',HR_GENERAL2.mask_characters(ln_account_number));
2805: pay_payroll_xml_extract_pkg.load_xml_data('CE','US_EMPLOYEE_NET_PAY_DISTRIBUTION',null);

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

2798: ELSE
2799: pay_payroll_xml_extract_pkg.load_xml_data('CS','US_EMPLOYEE_NET_PAY_DISTRIBUTION',null);
2800: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_DEPOSIT_NUMBER',lv_check_number);
2801: pay_payroll_xml_extract_pkg.load_xml_data('D','VALUE',ln_check_value);
2802: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2803: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2804: pay_payroll_xml_extract_pkg.load_xml_data('D','MASK_ACCOUNT_NUMBER',HR_GENERAL2.mask_characters(ln_account_number));
2805: pay_payroll_xml_extract_pkg.load_xml_data('CE','US_EMPLOYEE_NET_PAY_DISTRIBUTION',null);
2806:

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

2799: pay_payroll_xml_extract_pkg.load_xml_data('CS','US_EMPLOYEE_NET_PAY_DISTRIBUTION',null);
2800: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_DEPOSIT_NUMBER',lv_check_number);
2801: pay_payroll_xml_extract_pkg.load_xml_data('D','VALUE',ln_check_value);
2802: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2803: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2804: pay_payroll_xml_extract_pkg.load_xml_data('D','MASK_ACCOUNT_NUMBER',HR_GENERAL2.mask_characters(ln_account_number));
2805: pay_payroll_xml_extract_pkg.load_xml_data('CE','US_EMPLOYEE_NET_PAY_DISTRIBUTION',null);
2806:
2807: END IF;

Line 2804: pay_payroll_xml_extract_pkg.load_xml_data('D','MASK_ACCOUNT_NUMBER',HR_GENERAL2.mask_characters(ln_account_number));

2800: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_DEPOSIT_NUMBER',lv_check_number);
2801: pay_payroll_xml_extract_pkg.load_xml_data('D','VALUE',ln_check_value);
2802: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2803: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2804: pay_payroll_xml_extract_pkg.load_xml_data('D','MASK_ACCOUNT_NUMBER',HR_GENERAL2.mask_characters(ln_account_number));
2805: pay_payroll_xml_extract_pkg.load_xml_data('CE','US_EMPLOYEE_NET_PAY_DISTRIBUTION',null);
2806:
2807: END IF;
2808: END LOOP;

Line 2805: pay_payroll_xml_extract_pkg.load_xml_data('CE','US_EMPLOYEE_NET_PAY_DISTRIBUTION',null);

2801: pay_payroll_xml_extract_pkg.load_xml_data('D','VALUE',ln_check_value);
2802: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2803: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2804: pay_payroll_xml_extract_pkg.load_xml_data('D','MASK_ACCOUNT_NUMBER',HR_GENERAL2.mask_characters(ln_account_number));
2805: pay_payroll_xml_extract_pkg.load_xml_data('CE','US_EMPLOYEE_NET_PAY_DISTRIBUTION',null);
2806:
2807: END IF;
2808: END LOOP;
2809:

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

2825: lv_bank_branch,
2826: lv_check_number ;
2827: CLOSE get_check_depoad_details;
2828: IF lv_category = 'CH' THEN
2829: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_NUMBER',lv_check_number);
2830: lv_amount_in_word := CF_word_amountFormula(ln_check_value);
2831: pay_payroll_xml_extract_pkg.load_xml_data('D','AMOUNT_IN_WORDS',lv_amount_in_word);
2832: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_AMOUNT',ln_check_value);
2833: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);

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

2827: CLOSE get_check_depoad_details;
2828: IF lv_category = 'CH' THEN
2829: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_NUMBER',lv_check_number);
2830: lv_amount_in_word := CF_word_amountFormula(ln_check_value);
2831: pay_payroll_xml_extract_pkg.load_xml_data('D','AMOUNT_IN_WORDS',lv_amount_in_word);
2832: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_AMOUNT',ln_check_value);
2833: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);
2834: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2835: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);

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

2828: IF lv_category = 'CH' THEN
2829: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_NUMBER',lv_check_number);
2830: lv_amount_in_word := CF_word_amountFormula(ln_check_value);
2831: pay_payroll_xml_extract_pkg.load_xml_data('D','AMOUNT_IN_WORDS',lv_amount_in_word);
2832: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_AMOUNT',ln_check_value);
2833: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);
2834: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2835: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
2836: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);

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

2829: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_NUMBER',lv_check_number);
2830: lv_amount_in_word := CF_word_amountFormula(ln_check_value);
2831: pay_payroll_xml_extract_pkg.load_xml_data('D','AMOUNT_IN_WORDS',lv_amount_in_word);
2832: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_AMOUNT',ln_check_value);
2833: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);
2834: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2835: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
2836: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
2837: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);

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

2830: lv_amount_in_word := CF_word_amountFormula(ln_check_value);
2831: pay_payroll_xml_extract_pkg.load_xml_data('D','AMOUNT_IN_WORDS',lv_amount_in_word);
2832: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_AMOUNT',ln_check_value);
2833: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);
2834: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2835: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
2836: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
2837: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2838: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_BRANCH',lv_bank_branch);

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

2831: pay_payroll_xml_extract_pkg.load_xml_data('D','AMOUNT_IN_WORDS',lv_amount_in_word);
2832: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_AMOUNT',ln_check_value);
2833: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);
2834: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2835: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
2836: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
2837: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2838: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_BRANCH',lv_bank_branch);
2839:

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

2832: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_AMOUNT',ln_check_value);
2833: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);
2834: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2835: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
2836: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
2837: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2838: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_BRANCH',lv_bank_branch);
2839:
2840: ELSE

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

2833: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);
2834: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2835: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
2836: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
2837: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2838: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_BRANCH',lv_bank_branch);
2839:
2840: ELSE
2841: OPEN get_preassact_id (P_ASSIGNMENT_ACTION_ID);

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

2834: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2835: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
2836: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
2837: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2838: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_BRANCH',lv_bank_branch);
2839:
2840: ELSE
2841: OPEN get_preassact_id (P_ASSIGNMENT_ACTION_ID);
2842: FETCH get_preassact_id INTO ln_deposit_advice_number ;

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

2840: ELSE
2841: OPEN get_preassact_id (P_ASSIGNMENT_ACTION_ID);
2842: FETCH get_preassact_id INTO ln_deposit_advice_number ;
2843: CLOSE get_preassact_id ;
2844: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_FINAL_ADNUM',ln_deposit_advice_number);
2845: OPEN get_depoadvice_deatils(P_ASSIGNMENT_ACTION_ID);
2846: LOOP
2847: FETCH get_depoadvice_deatils INTO lv_account_name,
2848: lv_account_type,

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

2857: IF get_depoadvice_deatils%NOTFOUND THEN
2858: close get_depoadvice_deatils ;
2859: exit;
2860: ELSE
2861: pay_payroll_xml_extract_pkg.load_xml_data('CS','CHECK_DETAILS',null);
2862: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);
2863: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2864: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
2865: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);

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

2858: close get_depoadvice_deatils ;
2859: exit;
2860: ELSE
2861: pay_payroll_xml_extract_pkg.load_xml_data('CS','CHECK_DETAILS',null);
2862: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);
2863: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2864: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
2865: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
2866: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);

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

2859: exit;
2860: ELSE
2861: pay_payroll_xml_extract_pkg.load_xml_data('CS','CHECK_DETAILS',null);
2862: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);
2863: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2864: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
2865: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
2866: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2867: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_BRANCH',lv_bank_branch);

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

2860: ELSE
2861: pay_payroll_xml_extract_pkg.load_xml_data('CS','CHECK_DETAILS',null);
2862: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);
2863: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2864: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
2865: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
2866: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2867: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_BRANCH',lv_bank_branch);
2868: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_depoad_num);

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

2861: pay_payroll_xml_extract_pkg.load_xml_data('CS','CHECK_DETAILS',null);
2862: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);
2863: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2864: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
2865: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
2866: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2867: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_BRANCH',lv_bank_branch);
2868: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_depoad_num);
2869: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);

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

2862: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);
2863: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2864: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
2865: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
2866: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2867: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_BRANCH',lv_bank_branch);
2868: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_depoad_num);
2869: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);
2870: pay_payroll_xml_extract_pkg.load_xml_data('D','PAYMETHOD_ID',ln_paymethod_id);

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

2863: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2864: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
2865: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
2866: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2867: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_BRANCH',lv_bank_branch);
2868: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_depoad_num);
2869: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);
2870: pay_payroll_xml_extract_pkg.load_xml_data('D','PAYMETHOD_ID',ln_paymethod_id);
2871: pay_payroll_xml_extract_pkg.load_xml_data('D','PAYMETHOD_TYPE',ln_paymethod_type);

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

2864: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
2865: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
2866: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2867: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_BRANCH',lv_bank_branch);
2868: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_depoad_num);
2869: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);
2870: pay_payroll_xml_extract_pkg.load_xml_data('D','PAYMETHOD_ID',ln_paymethod_id);
2871: pay_payroll_xml_extract_pkg.load_xml_data('D','PAYMETHOD_TYPE',ln_paymethod_type);
2872: pay_payroll_xml_extract_pkg.load_xml_data('CE','CHECK_DETAILS',null);

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

2865: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
2866: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2867: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_BRANCH',lv_bank_branch);
2868: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_depoad_num);
2869: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);
2870: pay_payroll_xml_extract_pkg.load_xml_data('D','PAYMETHOD_ID',ln_paymethod_id);
2871: pay_payroll_xml_extract_pkg.load_xml_data('D','PAYMETHOD_TYPE',ln_paymethod_type);
2872: pay_payroll_xml_extract_pkg.load_xml_data('CE','CHECK_DETAILS',null);
2873: END IF;

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

2866: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2867: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_BRANCH',lv_bank_branch);
2868: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_depoad_num);
2869: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);
2870: pay_payroll_xml_extract_pkg.load_xml_data('D','PAYMETHOD_ID',ln_paymethod_id);
2871: pay_payroll_xml_extract_pkg.load_xml_data('D','PAYMETHOD_TYPE',ln_paymethod_type);
2872: pay_payroll_xml_extract_pkg.load_xml_data('CE','CHECK_DETAILS',null);
2873: END IF;
2874: END LOOP;

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

2867: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_BRANCH',lv_bank_branch);
2868: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_depoad_num);
2869: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);
2870: pay_payroll_xml_extract_pkg.load_xml_data('D','PAYMETHOD_ID',ln_paymethod_id);
2871: pay_payroll_xml_extract_pkg.load_xml_data('D','PAYMETHOD_TYPE',ln_paymethod_type);
2872: pay_payroll_xml_extract_pkg.load_xml_data('CE','CHECK_DETAILS',null);
2873: END IF;
2874: END LOOP;
2875: END IF;

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

2868: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_depoad_num);
2869: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);
2870: pay_payroll_xml_extract_pkg.load_xml_data('D','PAYMETHOD_ID',ln_paymethod_id);
2871: pay_payroll_xml_extract_pkg.load_xml_data('D','PAYMETHOD_TYPE',ln_paymethod_type);
2872: pay_payroll_xml_extract_pkg.load_xml_data('CE','CHECK_DETAILS',null);
2873: END IF;
2874: END LOOP;
2875: END IF;
2876:

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

2885: IF get_check_num_for_depad%NOTFOUND THEN
2886: close get_check_num_for_depad;
2887: EXIT;
2888: ELSE
2889: pay_payroll_xml_extract_pkg.load_xml_data('CS','CHECK_DETAILS',null);
2890: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_account_number);
2891: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);
2892: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2893: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);

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

2886: close get_check_num_for_depad;
2887: EXIT;
2888: ELSE
2889: pay_payroll_xml_extract_pkg.load_xml_data('CS','CHECK_DETAILS',null);
2890: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_account_number);
2891: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);
2892: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2893: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2894: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number1);

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

2887: EXIT;
2888: ELSE
2889: pay_payroll_xml_extract_pkg.load_xml_data('CS','CHECK_DETAILS',null);
2890: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_account_number);
2891: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);
2892: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2893: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2894: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number1);
2895: pay_payroll_xml_extract_pkg.load_xml_data('CE','CHECK_DETAILS',null);

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

2888: ELSE
2889: pay_payroll_xml_extract_pkg.load_xml_data('CS','CHECK_DETAILS',null);
2890: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_account_number);
2891: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);
2892: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2893: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2894: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number1);
2895: pay_payroll_xml_extract_pkg.load_xml_data('CE','CHECK_DETAILS',null);
2896:

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

2889: pay_payroll_xml_extract_pkg.load_xml_data('CS','CHECK_DETAILS',null);
2890: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_account_number);
2891: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);
2892: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2893: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2894: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number1);
2895: pay_payroll_xml_extract_pkg.load_xml_data('CE','CHECK_DETAILS',null);
2896:
2897:

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

2890: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_account_number);
2891: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);
2892: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2893: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2894: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number1);
2895: pay_payroll_xml_extract_pkg.load_xml_data('CE','CHECK_DETAILS',null);
2896:
2897:
2898: END IF;

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

2891: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);
2892: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2893: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2894: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number1);
2895: pay_payroll_xml_extract_pkg.load_xml_data('CE','CHECK_DETAILS',null);
2896:
2897:
2898: END IF;
2899: END LOOP;

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

2903: IF p_action_information_category = 'AC SUMMARY YTD' THEN
2904:
2905: OPEN get_net_pay_ytd(p_assignment_action_id);
2906: FETCH get_net_pay_ytd INTO ln_net_pay_ytd;
2907: pay_payroll_xml_extract_pkg.load_xml_data('D','NET_PAY_YTD',ln_net_pay_ytd );
2908: CLOSE get_net_pay_ytd;
2909:
2910: END IF;
2911:

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

2914: OPEN get_net_pay(p_assignment_action_id);
2915: FETCH get_net_pay into ln_amount;
2916: CLOSE get_net_pay;
2917:
2918: pay_payroll_xml_extract_pkg.load_xml_data('D','NET_PAY',ln_amount);
2919:
2920: END IF;
2921:
2922: -- 13029999 start

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

2930: lv_ER_Transit_code, lv_ER_Account_Number;
2931: CLOSE get_third_party_check_info;
2932:
2933: lv_amount_in_word := CF_word_amountFormula(ln_check_value);
2934: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_NUMBER',ln_depoad_num);
2935: pay_payroll_xml_extract_pkg.load_xml_data('D','AMOUNT_IN_WORDS',lv_amount_in_word);
2936: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYEE_NAME',lv_employee_name);
2937: pay_payroll_xml_extract_pkg.load_xml_data('D','ER_TRANSIT_CODE',lv_ER_Transit_code);
2938: pay_payroll_xml_extract_pkg.load_xml_data('D','ER_ACCOUNT_NUMBER',lv_ER_Account_Number);

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

2931: CLOSE get_third_party_check_info;
2932:
2933: lv_amount_in_word := CF_word_amountFormula(ln_check_value);
2934: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_NUMBER',ln_depoad_num);
2935: pay_payroll_xml_extract_pkg.load_xml_data('D','AMOUNT_IN_WORDS',lv_amount_in_word);
2936: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYEE_NAME',lv_employee_name);
2937: pay_payroll_xml_extract_pkg.load_xml_data('D','ER_TRANSIT_CODE',lv_ER_Transit_code);
2938: pay_payroll_xml_extract_pkg.load_xml_data('D','ER_ACCOUNT_NUMBER',lv_ER_Account_Number);
2939:

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

2932:
2933: lv_amount_in_word := CF_word_amountFormula(ln_check_value);
2934: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_NUMBER',ln_depoad_num);
2935: pay_payroll_xml_extract_pkg.load_xml_data('D','AMOUNT_IN_WORDS',lv_amount_in_word);
2936: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYEE_NAME',lv_employee_name);
2937: pay_payroll_xml_extract_pkg.load_xml_data('D','ER_TRANSIT_CODE',lv_ER_Transit_code);
2938: pay_payroll_xml_extract_pkg.load_xml_data('D','ER_ACCOUNT_NUMBER',lv_ER_Account_Number);
2939:
2940: IF lv_print_ssn_flag = 'Y' THEN

Line 2937: pay_payroll_xml_extract_pkg.load_xml_data('D','ER_TRANSIT_CODE',lv_ER_Transit_code);

2933: lv_amount_in_word := CF_word_amountFormula(ln_check_value);
2934: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_NUMBER',ln_depoad_num);
2935: pay_payroll_xml_extract_pkg.load_xml_data('D','AMOUNT_IN_WORDS',lv_amount_in_word);
2936: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYEE_NAME',lv_employee_name);
2937: pay_payroll_xml_extract_pkg.load_xml_data('D','ER_TRANSIT_CODE',lv_ER_Transit_code);
2938: pay_payroll_xml_extract_pkg.load_xml_data('D','ER_ACCOUNT_NUMBER',lv_ER_Account_Number);
2939:
2940: IF lv_print_ssn_flag = 'Y' THEN
2941: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYEE_SSN',lv_employee_ssn);

Line 2938: pay_payroll_xml_extract_pkg.load_xml_data('D','ER_ACCOUNT_NUMBER',lv_ER_Account_Number);

2934: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_NUMBER',ln_depoad_num);
2935: pay_payroll_xml_extract_pkg.load_xml_data('D','AMOUNT_IN_WORDS',lv_amount_in_word);
2936: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYEE_NAME',lv_employee_name);
2937: pay_payroll_xml_extract_pkg.load_xml_data('D','ER_TRANSIT_CODE',lv_ER_Transit_code);
2938: pay_payroll_xml_extract_pkg.load_xml_data('D','ER_ACCOUNT_NUMBER',lv_ER_Account_Number);
2939:
2940: IF lv_print_ssn_flag = 'Y' THEN
2941: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYEE_SSN',lv_employee_ssn);
2942: END IF;

Line 2941: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYEE_SSN',lv_employee_ssn);

2937: pay_payroll_xml_extract_pkg.load_xml_data('D','ER_TRANSIT_CODE',lv_ER_Transit_code);
2938: pay_payroll_xml_extract_pkg.load_xml_data('D','ER_ACCOUNT_NUMBER',lv_ER_Account_Number);
2939:
2940: IF lv_print_ssn_flag = 'Y' THEN
2941: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYEE_SSN',lv_employee_ssn);
2942: END IF;
2943:
2944: /* Put transit info here*/
2945: