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_ARCHIVE_CHEQUEWRITER dependencies on PAY_ARCHIVE_CHEQUEWRITER

Line 1: PACKAGE BODY pay_archive_chequewriter as

1: PACKAGE BODY pay_archive_chequewriter as
2: /* $Header: paychqarch.pkb 120.0.12010000.3 2008/08/06 06:31:08 ubhat ship $ */
3: /* +======================================================================+
4: | Copyright (c) 2003 Oracle Corporation |
5: | Redwood Shores, California, USA |

Line 181: ,p_xml_dummy_tab OUT NOCOPY pay_archive_chequewriter.ltr_char_tab_typ)

177: ,cp_branch_name IN VARCHAR2
178: ,cp_employee_no IN VARCHAR2
179: ,cp_full_name IN VARCHAR2
180: ,cp_national_identifier IN VARCHAR2
181: ,p_xml_dummy_tab OUT NOCOPY pay_archive_chequewriter.ltr_char_tab_typ)
182: AS
183: CURSOR get_flex_segment(cp_flex_ctx_code IN VARCHAR2)
184: IS
185: SELECT end_user_column_name

Line 191: ltr_ctx_tag pay_archive_chequewriter.ltr_char_tab_typ;

187: WHERE descriptive_flexfield_name like 'Action Information DF'
188: and descriptive_flex_context_code = cp_flex_ctx_code
189: AND enabled_flag = 'Y';
190:
191: ltr_ctx_tag pay_archive_chequewriter.ltr_char_tab_typ;
192: ltr_xml_tab pay_archive_chequewriter.ltr_char_tab_typ;
193:
194: i NUMBER;
195: cntr NUMBER;

Line 192: ltr_xml_tab pay_archive_chequewriter.ltr_char_tab_typ;

188: and descriptive_flex_context_code = cp_flex_ctx_code
189: AND enabled_flag = 'Y';
190:
191: ltr_ctx_tag pay_archive_chequewriter.ltr_char_tab_typ;
192: ltr_xml_tab pay_archive_chequewriter.ltr_char_tab_typ;
193:
194: i NUMBER;
195: cntr NUMBER;
196: xml_cntr NUMBER;

Line 515: ltr_xml_dummy_tab pay_archive_chequewriter.ltr_char_tab_typ;

511: and (ppa_chq.payroll_action_id = cp_chk_payroll_act_id)
512: and ppa_chq.effective_date between popm.effective_start_date and popm.effective_end_date;
513:
514:
515: ltr_xml_dummy_tab pay_archive_chequewriter.ltr_char_tab_typ;
516: l_first_name per_all_people_f.first_name%TYPE;
517: l_last_name per_all_people_f.last_name%TYPE;
518: l_order_name per_all_people_f.order_name%TYPE;
519: l_full_name per_all_people_f.full_name%TYPE;

Line 553: l_proc_name varchar2(50) := 'pay_archive_chequewriter.generate_xml' ;

549: lv_legislation_code per_business_groups.legislation_code%TYPE ;
550: lv_full_name VARCHAR2(250);
551: l_xml BLOB;
552: ln_arch_assignment_action_id NUMBER;
553: l_proc_name varchar2(50) := 'pay_archive_chequewriter.generate_xml' ;
554: l_xml_dummy BLOB;
555: lr_xml_dummy RAW (32767);
556: ln_amt_dummy NUMBER;
557: dummy_xml BLOB;

Line 560: hr_utility.trace('Entering pay_archive_chequewriter.generate_xml');

556: ln_amt_dummy NUMBER;
557: dummy_xml BLOB;
558:
559: BEGIN
560: hr_utility.trace('Entering pay_archive_chequewriter.generate_xml');
561:
562: ln_chq_asg_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');
563:
564: hr_utility.trace('ln_chq_asg_action_id := '||ln_chq_asg_action_id);

Line 598: pay_archive_chequewriter.g_chq_asg_action_id := ln_chq_asg_action_id;

594:
595: hr_utility.trace('ln_arch_assignment_action_id := '||ln_arch_assignment_action_id);
596:
597: -- Setting Global Variable values
598: pay_archive_chequewriter.g_chq_asg_action_id := ln_chq_asg_action_id;
599: pay_archive_chequewriter.g_arch_asg_action_id := ln_arch_assignment_action_id;
600: --
601: --
602: IF ln_arch_assignment_action_id IS NOT NULL THEN

Line 599: pay_archive_chequewriter.g_arch_asg_action_id := ln_arch_assignment_action_id;

595: hr_utility.trace('ln_arch_assignment_action_id := '||ln_arch_assignment_action_id);
596:
597: -- Setting Global Variable values
598: pay_archive_chequewriter.g_chq_asg_action_id := ln_chq_asg_action_id;
599: pay_archive_chequewriter.g_arch_asg_action_id := ln_arch_assignment_action_id;
600: --
601: --
602: IF ln_arch_assignment_action_id IS NOT NULL THEN
603:

Line 608: --hr_utility.trace('g_chq_asg_action_id := '||pay_archive_chequewriter.g_chq_asg_action_id);

604: pay_core_files.write_to_magtape_lob('');
605: pay_core_files.write_to_magtape_lob('');
606:
607: -- Printing Global Variable Values
608: --hr_utility.trace('g_chq_asg_action_id := '||pay_archive_chequewriter.g_chq_asg_action_id);
609: --hr_utility.trace('g_arch_asg_action_id := '||pay_archive_chequewriter.g_arch_asg_action_id);
610:
611: pay_payroll_xml_extract_pkg.generate ( ln_arch_assignment_action_id , -- Action Context ID
612: null , -- Custom XML Procedure

Line 609: --hr_utility.trace('g_arch_asg_action_id := '||pay_archive_chequewriter.g_arch_asg_action_id);

605: pay_core_files.write_to_magtape_lob('');
606:
607: -- Printing Global Variable Values
608: --hr_utility.trace('g_chq_asg_action_id := '||pay_archive_chequewriter.g_chq_asg_action_id);
609: --hr_utility.trace('g_arch_asg_action_id := '||pay_archive_chequewriter.g_arch_asg_action_id);
610:
611: pay_payroll_xml_extract_pkg.generate ( ln_arch_assignment_action_id , -- Action Context ID
612: null , -- Custom XML Procedure
613: 'N' , -- Generate Header Flag (Y/N)

Line 754: hr_utility.trace('Leaving pay_archive_chequewriter.generate_xml');

750: dbms_lob.freeTemporary(l_xml_dummy);
751:
752: END IF;
753:
754: hr_utility.trace('Leaving pay_archive_chequewriter.generate_xml');
755:
756: EXCEPTION WHEN OTHERS THEN
757: hr_utility.trace('SQLERRM := '||SQLERRM) ;
758: END GENERATE_XML ;

Line 761: g_proc_name := 'pay_archive_chequewriter';

757: hr_utility.trace('SQLERRM := '||SQLERRM) ;
758: END GENERATE_XML ;
759:
760: BEGIN
761: g_proc_name := 'pay_archive_chequewriter';
762: g_document_type := 'ARCHIVE_CHEQUE_WRITER';
763: g_debug := hr_utility.debug_enabled;
764:
765: END pay_archive_chequewriter;

Line 765: END pay_archive_chequewriter;

761: g_proc_name := 'pay_archive_chequewriter';
762: g_document_type := 'ARCHIVE_CHEQUE_WRITER';
763: g_debug := hr_utility.debug_enabled;
764:
765: END pay_archive_chequewriter;