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 2561: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_NUMBER',lv_check_number);

2557: lv_bank_branch,
2558: lv_check_number ;
2559: CLOSE get_check_depoad_details;
2560: IF lv_category = 'CH' THEN
2561: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_NUMBER',lv_check_number);
2562: lv_amount_in_word := CF_word_amountFormula(ln_check_value);
2563: pay_payroll_xml_extract_pkg.load_xml_data('D','AMOUNT_IN_WORDS',lv_amount_in_word);
2564: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_AMOUNT',ln_check_value);
2565: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);

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

2559: CLOSE get_check_depoad_details;
2560: IF lv_category = 'CH' THEN
2561: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_NUMBER',lv_check_number);
2562: lv_amount_in_word := CF_word_amountFormula(ln_check_value);
2563: pay_payroll_xml_extract_pkg.load_xml_data('D','AMOUNT_IN_WORDS',lv_amount_in_word);
2564: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_AMOUNT',ln_check_value);
2565: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);
2566: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2567: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);

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

2560: IF lv_category = 'CH' THEN
2561: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_NUMBER',lv_check_number);
2562: lv_amount_in_word := CF_word_amountFormula(ln_check_value);
2563: pay_payroll_xml_extract_pkg.load_xml_data('D','AMOUNT_IN_WORDS',lv_amount_in_word);
2564: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_AMOUNT',ln_check_value);
2565: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);
2566: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2567: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
2568: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);

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

2561: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_NUMBER',lv_check_number);
2562: lv_amount_in_word := CF_word_amountFormula(ln_check_value);
2563: pay_payroll_xml_extract_pkg.load_xml_data('D','AMOUNT_IN_WORDS',lv_amount_in_word);
2564: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_AMOUNT',ln_check_value);
2565: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);
2566: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2567: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
2568: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
2569: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);

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

2562: lv_amount_in_word := CF_word_amountFormula(ln_check_value);
2563: pay_payroll_xml_extract_pkg.load_xml_data('D','AMOUNT_IN_WORDS',lv_amount_in_word);
2564: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_AMOUNT',ln_check_value);
2565: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);
2566: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2567: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
2568: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
2569: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2570: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_BRANCH',lv_bank_branch);

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

2563: pay_payroll_xml_extract_pkg.load_xml_data('D','AMOUNT_IN_WORDS',lv_amount_in_word);
2564: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_AMOUNT',ln_check_value);
2565: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);
2566: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2567: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
2568: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
2569: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2570: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_BRANCH',lv_bank_branch);
2571:

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

2564: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_AMOUNT',ln_check_value);
2565: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);
2566: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2567: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
2568: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
2569: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2570: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_BRANCH',lv_bank_branch);
2571:
2572: ELSE

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

2565: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);
2566: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2567: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
2568: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
2569: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2570: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_BRANCH',lv_bank_branch);
2571:
2572: ELSE
2573: OPEN get_preassact_id (P_ASSIGNMENT_ACTION_ID);

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

2566: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2567: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
2568: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
2569: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2570: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_BRANCH',lv_bank_branch);
2571:
2572: ELSE
2573: OPEN get_preassact_id (P_ASSIGNMENT_ACTION_ID);
2574: FETCH get_preassact_id INTO ln_deposit_advice_number ;

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

2572: ELSE
2573: OPEN get_preassact_id (P_ASSIGNMENT_ACTION_ID);
2574: FETCH get_preassact_id INTO ln_deposit_advice_number ;
2575: CLOSE get_preassact_id ;
2576: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_FINAL_ADNUM',ln_deposit_advice_number);
2577: OPEN get_depoadvice_deatils(P_ASSIGNMENT_ACTION_ID);
2578: LOOP
2579: FETCH get_depoadvice_deatils INTO lv_account_name,
2580: lv_account_type,

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

2587: IF get_depoadvice_deatils%NOTFOUND THEN
2588: close get_depoadvice_deatils ;
2589: exit;
2590: ELSE
2591: pay_payroll_xml_extract_pkg.load_xml_data('CS','CHECK_DETAILS',null);
2592: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);
2593: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2594: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
2595: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);

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

2588: close get_depoadvice_deatils ;
2589: exit;
2590: ELSE
2591: pay_payroll_xml_extract_pkg.load_xml_data('CS','CHECK_DETAILS',null);
2592: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);
2593: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2594: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
2595: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
2596: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);

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

2589: exit;
2590: ELSE
2591: pay_payroll_xml_extract_pkg.load_xml_data('CS','CHECK_DETAILS',null);
2592: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);
2593: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2594: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
2595: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
2596: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2597: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_BRANCH',lv_bank_branch);

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

2590: ELSE
2591: pay_payroll_xml_extract_pkg.load_xml_data('CS','CHECK_DETAILS',null);
2592: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);
2593: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2594: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
2595: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
2596: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2597: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_BRANCH',lv_bank_branch);
2598: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_depoad_num);

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

2591: pay_payroll_xml_extract_pkg.load_xml_data('CS','CHECK_DETAILS',null);
2592: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);
2593: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2594: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
2595: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
2596: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2597: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_BRANCH',lv_bank_branch);
2598: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_depoad_num);
2599: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);

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

2592: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NAME',lv_account_name);
2593: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2594: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
2595: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
2596: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2597: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_BRANCH',lv_bank_branch);
2598: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_depoad_num);
2599: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);
2600: pay_payroll_xml_extract_pkg.load_xml_data('CE','CHECK_DETAILS',null);

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

2593: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2594: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
2595: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
2596: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2597: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_BRANCH',lv_bank_branch);
2598: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_depoad_num);
2599: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);
2600: pay_payroll_xml_extract_pkg.load_xml_data('CE','CHECK_DETAILS',null);
2601: END IF;

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

2594: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number);
2595: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
2596: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2597: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_BRANCH',lv_bank_branch);
2598: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_depoad_num);
2599: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);
2600: pay_payroll_xml_extract_pkg.load_xml_data('CE','CHECK_DETAILS',null);
2601: END IF;
2602: END LOOP;

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

2595: pay_payroll_xml_extract_pkg.load_xml_data('D','TRANSIT_CODE',lv_transit_code);
2596: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2597: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_BRANCH',lv_bank_branch);
2598: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_depoad_num);
2599: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);
2600: pay_payroll_xml_extract_pkg.load_xml_data('CE','CHECK_DETAILS',null);
2601: END IF;
2602: END LOOP;
2603: END IF;

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

2596: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2597: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_BRANCH',lv_bank_branch);
2598: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_depoad_num);
2599: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);
2600: pay_payroll_xml_extract_pkg.load_xml_data('CE','CHECK_DETAILS',null);
2601: END IF;
2602: END LOOP;
2603: END IF;
2604:

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

2613: IF get_check_num_for_depad%NOTFOUND THEN
2614: close get_check_num_for_depad;
2615: EXIT;
2616: ELSE
2617: pay_payroll_xml_extract_pkg.load_xml_data('CS','CHECK_DETAILS',null);
2618: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_account_number);
2619: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);
2620: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2621: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);

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

2614: close get_check_num_for_depad;
2615: EXIT;
2616: ELSE
2617: pay_payroll_xml_extract_pkg.load_xml_data('CS','CHECK_DETAILS',null);
2618: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_account_number);
2619: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);
2620: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2621: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2622: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number1);

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

2615: EXIT;
2616: ELSE
2617: pay_payroll_xml_extract_pkg.load_xml_data('CS','CHECK_DETAILS',null);
2618: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_account_number);
2619: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);
2620: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2621: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2622: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number1);
2623: pay_payroll_xml_extract_pkg.load_xml_data('CE','CHECK_DETAILS',null);

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

2616: ELSE
2617: pay_payroll_xml_extract_pkg.load_xml_data('CS','CHECK_DETAILS',null);
2618: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_account_number);
2619: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);
2620: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2621: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2622: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number1);
2623: pay_payroll_xml_extract_pkg.load_xml_data('CE','CHECK_DETAILS',null);
2624:

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

2617: pay_payroll_xml_extract_pkg.load_xml_data('CS','CHECK_DETAILS',null);
2618: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_account_number);
2619: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);
2620: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2621: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2622: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number1);
2623: pay_payroll_xml_extract_pkg.load_xml_data('CE','CHECK_DETAILS',null);
2624:
2625:

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

2618: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_NUMBER',ln_account_number);
2619: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);
2620: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2621: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2622: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number1);
2623: pay_payroll_xml_extract_pkg.load_xml_data('CE','CHECK_DETAILS',null);
2624:
2625:
2626: END IF;

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

2619: pay_payroll_xml_extract_pkg.load_xml_data('D','DEPOSIT_ADVICE_VALUE',ln_check_value);
2620: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_TYPE',lv_account_type);
2621: pay_payroll_xml_extract_pkg.load_xml_data('D','BANK_NAME',lv_bank_name);
2622: pay_payroll_xml_extract_pkg.load_xml_data('D','ACCOUNT_NUMBER',ln_account_number1);
2623: pay_payroll_xml_extract_pkg.load_xml_data('CE','CHECK_DETAILS',null);
2624:
2625:
2626: END IF;
2627: END LOOP;

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

2631: IF p_action_information_category = 'AC SUMMARY YTD' THEN
2632:
2633: OPEN get_net_pay_ytd(p_assignment_action_id);
2634: FETCH get_net_pay_ytd INTO ln_net_pay_ytd;
2635: pay_payroll_xml_extract_pkg.load_xml_data('D','NET_PAY_YTD',ln_net_pay_ytd );
2636: CLOSE get_net_pay_ytd;
2637:
2638: END IF;
2639:

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

2642: OPEN get_net_pay(p_assignment_action_id);
2643: FETCH get_net_pay into ln_amount;
2644: CLOSE get_net_pay;
2645:
2646: pay_payroll_xml_extract_pkg.load_xml_data('D','NET_PAY',ln_amount);
2647:
2648: END IF;
2649: hr_utility.trace('exiting PAY_US_RULES.add_custom_xml');
2650: END add_custom_xml;