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.AP_APXTRSWP_XMLP_PKG dependencies on FND_DATE

Line 984: || fnd_date.date_to_canonical(C_from_acctg_date) ||''', ''YYYY/MM/DD HH24:MI:SS'')'

980:
981: C_date_filter_inv := ' and aid.period_name = ''' || p_period_name || '''';
982: C_date_filter_pay := ' and aip.period_name = ''' || p_period_name || '''';
983: C_date_filter_payhist := ' and aph.accounting_date between to_date('''
984: || fnd_date.date_to_canonical(C_from_acctg_date) ||''', ''YYYY/MM/DD HH24:MI:SS'')'
985: || ' and to_date(''' || fnd_date.date_to_canonical(C_to_acctg_date)
986: ||''', ''YYYY/MM/DD HH24:MI:SS'')';
987:
988: ELSIF (P_from_acctg_date is NOT NULL and P_to_acctg_date is NOT NULL) THEN

Line 985: || ' and to_date(''' || fnd_date.date_to_canonical(C_to_acctg_date)

981: C_date_filter_inv := ' and aid.period_name = ''' || p_period_name || '''';
982: C_date_filter_pay := ' and aip.period_name = ''' || p_period_name || '''';
983: C_date_filter_payhist := ' and aph.accounting_date between to_date('''
984: || fnd_date.date_to_canonical(C_from_acctg_date) ||''', ''YYYY/MM/DD HH24:MI:SS'')'
985: || ' and to_date(''' || fnd_date.date_to_canonical(C_to_acctg_date)
986: ||''', ''YYYY/MM/DD HH24:MI:SS'')';
987:
988: ELSIF (P_from_acctg_date is NOT NULL and P_to_acctg_date is NOT NULL) THEN
989:

Line 991: ' and aid.accounting_date between to_date(''' || fnd_date.date_to_canonical(P_from_acctg_date)

987:
988: ELSIF (P_from_acctg_date is NOT NULL and P_to_acctg_date is NOT NULL) THEN
989:
990: C_date_filter_inv :=
991: ' and aid.accounting_date between to_date(''' || fnd_date.date_to_canonical(P_from_acctg_date)
992: || ''', ''YYYY/MM/DD HH24:MI:SS'') and to_date('''
993: || fnd_date.date_to_canonical(P_to_acctg_date) || ''', ''YYYY/MM/DD HH24:MI:SS'')';
994:
995: C_date_filter_pay :=

Line 993: || fnd_date.date_to_canonical(P_to_acctg_date) || ''', ''YYYY/MM/DD HH24:MI:SS'')';

989:
990: C_date_filter_inv :=
991: ' and aid.accounting_date between to_date(''' || fnd_date.date_to_canonical(P_from_acctg_date)
992: || ''', ''YYYY/MM/DD HH24:MI:SS'') and to_date('''
993: || fnd_date.date_to_canonical(P_to_acctg_date) || ''', ''YYYY/MM/DD HH24:MI:SS'')';
994:
995: C_date_filter_pay :=
996: ' and aip.accounting_date between to_date(''' || fnd_date.date_to_canonical(P_from_acctg_date)
997: || ''', ''YYYY/MM/DD HH24:MI:SS'') and to_date('''

Line 996: ' and aip.accounting_date between to_date(''' || fnd_date.date_to_canonical(P_from_acctg_date)

992: || ''', ''YYYY/MM/DD HH24:MI:SS'') and to_date('''
993: || fnd_date.date_to_canonical(P_to_acctg_date) || ''', ''YYYY/MM/DD HH24:MI:SS'')';
994:
995: C_date_filter_pay :=
996: ' and aip.accounting_date between to_date(''' || fnd_date.date_to_canonical(P_from_acctg_date)
997: || ''', ''YYYY/MM/DD HH24:MI:SS'') and to_date('''
998: || fnd_date.date_to_canonical(P_to_acctg_date) || ''', ''YYYY/MM/DD HH24:MI:SS'')';
999:
1000: C_date_filter_payhist :=

Line 998: || fnd_date.date_to_canonical(P_to_acctg_date) || ''', ''YYYY/MM/DD HH24:MI:SS'')';

994:
995: C_date_filter_pay :=
996: ' and aip.accounting_date between to_date(''' || fnd_date.date_to_canonical(P_from_acctg_date)
997: || ''', ''YYYY/MM/DD HH24:MI:SS'') and to_date('''
998: || fnd_date.date_to_canonical(P_to_acctg_date) || ''', ''YYYY/MM/DD HH24:MI:SS'')';
999:
1000: C_date_filter_payhist :=
1001: ' and aph.accounting_date between to_date(''' || fnd_date.date_to_canonical(P_from_acctg_date)
1002: || ''', ''YYYY/MM/DD HH24:MI:SS'') and to_date('''

Line 1001: ' and aph.accounting_date between to_date(''' || fnd_date.date_to_canonical(P_from_acctg_date)

997: || ''', ''YYYY/MM/DD HH24:MI:SS'') and to_date('''
998: || fnd_date.date_to_canonical(P_to_acctg_date) || ''', ''YYYY/MM/DD HH24:MI:SS'')';
999:
1000: C_date_filter_payhist :=
1001: ' and aph.accounting_date between to_date(''' || fnd_date.date_to_canonical(P_from_acctg_date)
1002: || ''', ''YYYY/MM/DD HH24:MI:SS'') and to_date('''
1003: || fnd_date.date_to_canonical(P_to_acctg_date) || ''', ''YYYY/MM/DD HH24:MI:SS'')';
1004:
1005: ELSIF (P_to_acctg_date is NOT NULL and P_from_acctg_date is NULL) THEN

Line 1003: || fnd_date.date_to_canonical(P_to_acctg_date) || ''', ''YYYY/MM/DD HH24:MI:SS'')';

999:
1000: C_date_filter_payhist :=
1001: ' and aph.accounting_date between to_date(''' || fnd_date.date_to_canonical(P_from_acctg_date)
1002: || ''', ''YYYY/MM/DD HH24:MI:SS'') and to_date('''
1003: || fnd_date.date_to_canonical(P_to_acctg_date) || ''', ''YYYY/MM/DD HH24:MI:SS'')';
1004:
1005: ELSIF (P_to_acctg_date is NOT NULL and P_from_acctg_date is NULL) THEN
1006:
1007: C_date_filter_inv := ' and aid.accounting_date <= to_date('''

Line 1008: || fnd_date.date_to_canonical(P_to_acctg_date)

1004:
1005: ELSIF (P_to_acctg_date is NOT NULL and P_from_acctg_date is NULL) THEN
1006:
1007: C_date_filter_inv := ' and aid.accounting_date <= to_date('''
1008: || fnd_date.date_to_canonical(P_to_acctg_date)
1009: || ''', ''YYYY/MM/DD HH24:MI:SS'')';
1010: C_date_filter_pay := ' and aip.accounting_date <= to_date('''
1011: || fnd_date.date_to_canonical(P_to_acctg_date)
1012: || ''', ''YYYY/MM/DD HH24:MI:SS'')';

Line 1011: || fnd_date.date_to_canonical(P_to_acctg_date)

1007: C_date_filter_inv := ' and aid.accounting_date <= to_date('''
1008: || fnd_date.date_to_canonical(P_to_acctg_date)
1009: || ''', ''YYYY/MM/DD HH24:MI:SS'')';
1010: C_date_filter_pay := ' and aip.accounting_date <= to_date('''
1011: || fnd_date.date_to_canonical(P_to_acctg_date)
1012: || ''', ''YYYY/MM/DD HH24:MI:SS'')';
1013: C_date_filter_payhist := ' and aph.accounting_date <= to_date('''
1014: || fnd_date.date_to_canonical(P_to_acctg_date)
1015: || ''', ''YYYY/MM/DD HH24:MI:SS'')';

Line 1014: || fnd_date.date_to_canonical(P_to_acctg_date)

1010: C_date_filter_pay := ' and aip.accounting_date <= to_date('''
1011: || fnd_date.date_to_canonical(P_to_acctg_date)
1012: || ''', ''YYYY/MM/DD HH24:MI:SS'')';
1013: C_date_filter_payhist := ' and aph.accounting_date <= to_date('''
1014: || fnd_date.date_to_canonical(P_to_acctg_date)
1015: || ''', ''YYYY/MM/DD HH24:MI:SS'')';
1016:
1017: ELSIF (P_to_acctg_date is NULL and P_from_acctg_date is NOT NULL) THEN
1018:

Line 1020: || fnd_date.date_to_canonical(P_from_acctg_date)

1016:
1017: ELSIF (P_to_acctg_date is NULL and P_from_acctg_date is NOT NULL) THEN
1018:
1019: C_date_filter_inv := ' and aid.accounting_date >= to_date('''
1020: || fnd_date.date_to_canonical(P_from_acctg_date)
1021: || ''', ''YYYY/MM/DD HH24:MI:SS'')';
1022: C_date_filter_pay := ' and aip.accounting_date >= to_date('''
1023: || fnd_date.date_to_canonical(P_from_acctg_date)
1024: || ''', ''YYYY/MM/DD HH24:MI:SS'')';

Line 1023: || fnd_date.date_to_canonical(P_from_acctg_date)

1019: C_date_filter_inv := ' and aid.accounting_date >= to_date('''
1020: || fnd_date.date_to_canonical(P_from_acctg_date)
1021: || ''', ''YYYY/MM/DD HH24:MI:SS'')';
1022: C_date_filter_pay := ' and aip.accounting_date >= to_date('''
1023: || fnd_date.date_to_canonical(P_from_acctg_date)
1024: || ''', ''YYYY/MM/DD HH24:MI:SS'')';
1025: C_date_filter_payhist := ' and aph.accounting_date >= to_date('''
1026: || fnd_date.date_to_canonical(P_from_acctg_date)
1027: || ''', ''YYYY/MM/DD HH24:MI:SS'')';

Line 1026: || fnd_date.date_to_canonical(P_from_acctg_date)

1022: C_date_filter_pay := ' and aip.accounting_date >= to_date('''
1023: || fnd_date.date_to_canonical(P_from_acctg_date)
1024: || ''', ''YYYY/MM/DD HH24:MI:SS'')';
1025: C_date_filter_payhist := ' and aph.accounting_date >= to_date('''
1026: || fnd_date.date_to_canonical(P_from_acctg_date)
1027: || ''', ''YYYY/MM/DD HH24:MI:SS'')';
1028: else
1029: C_DATE_FILTER_PAY := 'AND 1 = 1 ';
1030: C_DATE_FILTER_PAYHIST := 'AND 1 = 1 ';