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_IN_24QC_ER_RETURNS dependencies on PAY_IN_24QC_ER_RETURNS

Line 1: PACKAGE BODY pay_in_24qc_er_returns AS

1: PACKAGE BODY pay_in_24qc_er_returns AS
2: /* $Header: pyin24cr.pkb 120.3.12010000.1 2008/07/27 22:52:05 appldev ship $ */
3:
4: g_debug BOOLEAN;
5: g_package CONSTANT VARCHAR2(40) := 'pay_in_24qc_er_returns.';

Line 5: g_package CONSTANT VARCHAR2(40) := 'pay_in_24qc_er_returns.';

1: PACKAGE BODY pay_in_24qc_er_returns AS
2: /* $Header: pyin24cr.pkb 120.3.12010000.1 2008/07/27 22:52:05 appldev ship $ */
3:
4: g_debug BOOLEAN;
5: g_package CONSTANT VARCHAR2(40) := 'pay_in_24qc_er_returns.';
6:
7: --------------------------------------------------------------------------
8: -- --
9: -- Name : GET_FILE_SEQ_NO --

Line 516: ,pay_in_24qc_er_returns.remove_curr_format(action_information15) action_information15

512: - SUM(DECODE(action_information15, 'U', NVL(action_information23, 0)
513: , 0)) cess
514: FROM (
515: SELECT DISTINCT source_id
516: ,pay_in_24qc_er_returns.remove_curr_format(action_information15) action_information15
517: ,pay_in_24qc_er_returns.remove_curr_format(action_information16) action_information16
518: ,pay_in_24qc_er_returns.remove_curr_format(action_information24) action_information24
519: ,pay_in_24qc_er_returns.remove_curr_format(action_information6) action_information6
520: ,pay_in_24qc_er_returns.remove_curr_format(action_information21) action_information21

Line 517: ,pay_in_24qc_er_returns.remove_curr_format(action_information16) action_information16

513: , 0)) cess
514: FROM (
515: SELECT DISTINCT source_id
516: ,pay_in_24qc_er_returns.remove_curr_format(action_information15) action_information15
517: ,pay_in_24qc_er_returns.remove_curr_format(action_information16) action_information16
518: ,pay_in_24qc_er_returns.remove_curr_format(action_information24) action_information24
519: ,pay_in_24qc_er_returns.remove_curr_format(action_information6) action_information6
520: ,pay_in_24qc_er_returns.remove_curr_format(action_information21) action_information21
521: ,pay_in_24qc_er_returns.remove_curr_format(action_information7) action_information7

Line 518: ,pay_in_24qc_er_returns.remove_curr_format(action_information24) action_information24

514: FROM (
515: SELECT DISTINCT source_id
516: ,pay_in_24qc_er_returns.remove_curr_format(action_information15) action_information15
517: ,pay_in_24qc_er_returns.remove_curr_format(action_information16) action_information16
518: ,pay_in_24qc_er_returns.remove_curr_format(action_information24) action_information24
519: ,pay_in_24qc_er_returns.remove_curr_format(action_information6) action_information6
520: ,pay_in_24qc_er_returns.remove_curr_format(action_information21) action_information21
521: ,pay_in_24qc_er_returns.remove_curr_format(action_information7) action_information7
522: ,pay_in_24qc_er_returns.remove_curr_format(action_information22) action_information22

Line 519: ,pay_in_24qc_er_returns.remove_curr_format(action_information6) action_information6

515: SELECT DISTINCT source_id
516: ,pay_in_24qc_er_returns.remove_curr_format(action_information15) action_information15
517: ,pay_in_24qc_er_returns.remove_curr_format(action_information16) action_information16
518: ,pay_in_24qc_er_returns.remove_curr_format(action_information24) action_information24
519: ,pay_in_24qc_er_returns.remove_curr_format(action_information6) action_information6
520: ,pay_in_24qc_er_returns.remove_curr_format(action_information21) action_information21
521: ,pay_in_24qc_er_returns.remove_curr_format(action_information7) action_information7
522: ,pay_in_24qc_er_returns.remove_curr_format(action_information22) action_information22
523: ,pay_in_24qc_er_returns.remove_curr_format(action_information8) action_information8

Line 520: ,pay_in_24qc_er_returns.remove_curr_format(action_information21) action_information21

516: ,pay_in_24qc_er_returns.remove_curr_format(action_information15) action_information15
517: ,pay_in_24qc_er_returns.remove_curr_format(action_information16) action_information16
518: ,pay_in_24qc_er_returns.remove_curr_format(action_information24) action_information24
519: ,pay_in_24qc_er_returns.remove_curr_format(action_information6) action_information6
520: ,pay_in_24qc_er_returns.remove_curr_format(action_information21) action_information21
521: ,pay_in_24qc_er_returns.remove_curr_format(action_information7) action_information7
522: ,pay_in_24qc_er_returns.remove_curr_format(action_information22) action_information22
523: ,pay_in_24qc_er_returns.remove_curr_format(action_information8) action_information8
524: ,pay_in_24qc_er_returns.remove_curr_format(action_information23) action_information23

Line 521: ,pay_in_24qc_er_returns.remove_curr_format(action_information7) action_information7

517: ,pay_in_24qc_er_returns.remove_curr_format(action_information16) action_information16
518: ,pay_in_24qc_er_returns.remove_curr_format(action_information24) action_information24
519: ,pay_in_24qc_er_returns.remove_curr_format(action_information6) action_information6
520: ,pay_in_24qc_er_returns.remove_curr_format(action_information21) action_information21
521: ,pay_in_24qc_er_returns.remove_curr_format(action_information7) action_information7
522: ,pay_in_24qc_er_returns.remove_curr_format(action_information22) action_information22
523: ,pay_in_24qc_er_returns.remove_curr_format(action_information8) action_information8
524: ,pay_in_24qc_er_returns.remove_curr_format(action_information23) action_information23
525: FROM pay_action_information

Line 522: ,pay_in_24qc_er_returns.remove_curr_format(action_information22) action_information22

518: ,pay_in_24qc_er_returns.remove_curr_format(action_information24) action_information24
519: ,pay_in_24qc_er_returns.remove_curr_format(action_information6) action_information6
520: ,pay_in_24qc_er_returns.remove_curr_format(action_information21) action_information21
521: ,pay_in_24qc_er_returns.remove_curr_format(action_information7) action_information7
522: ,pay_in_24qc_er_returns.remove_curr_format(action_information22) action_information22
523: ,pay_in_24qc_er_returns.remove_curr_format(action_information8) action_information8
524: ,pay_in_24qc_er_returns.remove_curr_format(action_information23) action_information23
525: FROM pay_action_information
526: WHERE action_information_category ='IN_24QC_DEDUCTEE'

Line 523: ,pay_in_24qc_er_returns.remove_curr_format(action_information8) action_information8

519: ,pay_in_24qc_er_returns.remove_curr_format(action_information6) action_information6
520: ,pay_in_24qc_er_returns.remove_curr_format(action_information21) action_information21
521: ,pay_in_24qc_er_returns.remove_curr_format(action_information7) action_information7
522: ,pay_in_24qc_er_returns.remove_curr_format(action_information22) action_information22
523: ,pay_in_24qc_er_returns.remove_curr_format(action_information8) action_information8
524: ,pay_in_24qc_er_returns.remove_curr_format(action_information23) action_information23
525: FROM pay_action_information
526: WHERE action_information_category ='IN_24QC_DEDUCTEE'
527: AND action_context_type = 'AAP'

Line 524: ,pay_in_24qc_er_returns.remove_curr_format(action_information23) action_information23

520: ,pay_in_24qc_er_returns.remove_curr_format(action_information21) action_information21
521: ,pay_in_24qc_er_returns.remove_curr_format(action_information7) action_information7
522: ,pay_in_24qc_er_returns.remove_curr_format(action_information22) action_information22
523: ,pay_in_24qc_er_returns.remove_curr_format(action_information8) action_information8
524: ,pay_in_24qc_er_returns.remove_curr_format(action_information23) action_information23
525: FROM pay_action_information
526: WHERE action_information_category ='IN_24QC_DEDUCTEE'
527: AND action_context_type = 'AAP'
528: AND action_information3 = p_gre_org_id

Line 989: END pay_in_24qc_er_returns;

985:
986: END chapter_VIA_rec_count;
987:
988:
989: END pay_in_24qc_er_returns;