APPS.PAY_CA_PAYREG_EXTRACT_PKG dependencies on PAY_CA_PAYREG_EXTRACT_DATA_PKG

Line 312: ** Package pay_ca_payreg_extract_data_pkg (pycaprpd.pkh/pkb).

308: ** can insert data and the label in this PL/SQL table which will
309: ** be printed at the end of the report.
310: ** The PL/SQL table which needs to be populated is
311: ** LTT_PAYMENT_EXTRACT_DATA. This PL/SQL table is defined in the
312: ** Package pay_ca_payreg_extract_data_pkg (pycaprpd.pkh/pkb).
313: *****************************************************************/
314: PROCEDURE formated_static_header(
315: p_output_file_type in varchar2
316: ,p_static_label1 out NOCOPY varchar2

Line 479: if pay_ca_payreg_extract_data_pkg.ltt_payment_extract_label.count > 0 then

475:
476: /*******************************************************************
477: ** Only do this if there is some configuration data present
478: *******************************************************************/
479: if pay_ca_payreg_extract_data_pkg.ltt_payment_extract_label.count > 0 then
480: for i in pay_ca_payreg_extract_data_pkg.ltt_payment_extract_label.first ..
481: pay_ca_payreg_extract_data_pkg.ltt_payment_extract_label.last
482: loop
483:

Line 480: for i in pay_ca_payreg_extract_data_pkg.ltt_payment_extract_label.first ..

476: /*******************************************************************
477: ** Only do this if there is some configuration data present
478: *******************************************************************/
479: if pay_ca_payreg_extract_data_pkg.ltt_payment_extract_label.count > 0 then
480: for i in pay_ca_payreg_extract_data_pkg.ltt_payment_extract_label.first ..
481: pay_ca_payreg_extract_data_pkg.ltt_payment_extract_label.last
482: loop
483:
484: lv_format2 := lv_format2 ||

Line 481: pay_ca_payreg_extract_data_pkg.ltt_payment_extract_label.last

477: ** Only do this if there is some configuration data present
478: *******************************************************************/
479: if pay_ca_payreg_extract_data_pkg.ltt_payment_extract_label.count > 0 then
480: for i in pay_ca_payreg_extract_data_pkg.ltt_payment_extract_label.first ..
481: pay_ca_payreg_extract_data_pkg.ltt_payment_extract_label.last
482: loop
483:
484: lv_format2 := lv_format2 ||
485: formated_data_string (

Line 487: pay_ca_payreg_extract_data_pkg.ltt_payment_extract_label(i)

483:
484: lv_format2 := lv_format2 ||
485: formated_data_string (
486: p_input_string =>
487: pay_ca_payreg_extract_data_pkg.ltt_payment_extract_label(i)
488: ,p_bold => 'Y'
489: ,p_output_file_type => p_output_file_type);
490:
491: end loop;

Line 516: ** Package pay_ca_payreg_extract_data_pkg (pycaprpd.pkh/pkb).

512: ** can insert data and the label in this PL/SQL table which will
513: ** be printed at the end of the report.
514: ** The PL/SQL table which needs to be populated is
515: ** LTT_PAYMENT_EXTRACT_DATA. This PL/SQL table is defined in the
516: ** Package pay_ca_payreg_extract_data_pkg (pycaprpd.pkh/pkb).
517: *****************************************************************/
518: /* Added two columns p_case_number, p_payee_name to format the
519: Third Party Payments, to fix bug#2745577 */
520: PROCEDURE formated_static_data(

Line 620: if pay_ca_payreg_extract_data_pkg.ltt_payment_extract_label.count > 0 then

616:
617: /*******************************************************************
618: ** Only do this if there is some configuration data present
619: *******************************************************************/
620: if pay_ca_payreg_extract_data_pkg.ltt_payment_extract_label.count > 0 then
621:
622: for i in pay_ca_payreg_extract_data_pkg.ltt_payment_extract_data.first ..
623: pay_ca_payreg_extract_data_pkg.ltt_payment_extract_data.last
624: loop

Line 622: for i in pay_ca_payreg_extract_data_pkg.ltt_payment_extract_data.first ..

618: ** Only do this if there is some configuration data present
619: *******************************************************************/
620: if pay_ca_payreg_extract_data_pkg.ltt_payment_extract_label.count > 0 then
621:
622: for i in pay_ca_payreg_extract_data_pkg.ltt_payment_extract_data.first ..
623: pay_ca_payreg_extract_data_pkg.ltt_payment_extract_data.last
624: loop
625:
626: lv_format2 := lv_format2 ||

Line 623: pay_ca_payreg_extract_data_pkg.ltt_payment_extract_data.last

619: *******************************************************************/
620: if pay_ca_payreg_extract_data_pkg.ltt_payment_extract_label.count > 0 then
621:
622: for i in pay_ca_payreg_extract_data_pkg.ltt_payment_extract_data.first ..
623: pay_ca_payreg_extract_data_pkg.ltt_payment_extract_data.last
624: loop
625:
626: lv_format2 := lv_format2 ||
627: formated_data_string (

Line 629: pay_ca_payreg_extract_data_pkg.ltt_payment_extract_data(i)

625:
626: lv_format2 := lv_format2 ||
627: formated_data_string (
628: p_input_string =>
629: pay_ca_payreg_extract_data_pkg.ltt_payment_extract_data(i)
630: ,p_output_file_type => p_output_file_type);
631:
632: end loop;
633: end if;

Line 1328: /* pay_ca_payreg_extract_data_pkg.populate_table(

1324: /********************************************************************
1325: ** Populate the user defined PL/SQL table to print the additional
1326: ** columns in the report.
1327: ********************************************************************/
1328: /* pay_ca_payreg_extract_data_pkg.populate_table(
1329: p_assignment_id => ln_assignment_id
1330: ,p_person_id => ln_person_id
1331: ,p_assignment_action_id => ln_assignment_action_id
1332: ,p_effective_date=> ld_effective_date