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.ASO_APR_APPROVALS_PKG dependencies on ASO_UTILITY_PVT

Line 141: aso_utility_pvt.DECODE (

137: fnd_api.g_miss_num,
138: NULL,
139: p_application_id
140: ),
141: aso_utility_pvt.DECODE (
142: p_start_date,
143: fnd_api.g_miss_date,
144: NULL,
145: p_start_date

Line 147: aso_utility_pvt.DECODE (

143: fnd_api.g_miss_date,
144: NULL,
145: p_start_date
146: ),
147: aso_utility_pvt.DECODE (
148: p_end_date,
149: fnd_api.g_miss_date,
150: NULL,
151: p_end_date

Line 153: aso_utility_pvt.DECODE (

149: fnd_api.g_miss_date,
150: NULL,
151: p_end_date
152: ),
153: aso_utility_pvt.DECODE (
154: p_creation_date,
155: fnd_api.g_miss_date,
156: NULL,
157: p_creation_date

Line 165: aso_utility_pvt.DECODE (

161: fnd_api.g_miss_num,
162: NULL,
163: p_created_by
164: ),
165: aso_utility_pvt.DECODE (
166: p_last_update_date,
167: fnd_api.g_miss_date,
168: NULL,
169: p_last_update_date

Line 449: start_date = aso_utility_pvt.DECODE (

445: fnd_api.g_miss_num,
446: application_id,
447: p_application_id
448: ),
449: start_date = aso_utility_pvt.DECODE (
450: p_start_date,
451: fnd_api.g_miss_date,
452: start_date,
453: p_start_date

Line 455: end_date = aso_utility_pvt.DECODE (

451: fnd_api.g_miss_date,
452: start_date,
453: p_start_date
454: ),
455: end_date = aso_utility_pvt.DECODE (
456: p_end_date,
457: fnd_api.g_miss_date,
458: end_date,
459: p_end_date

Line 461: last_update_date = aso_utility_pvt.DECODE (

457: fnd_api.g_miss_date,
458: end_date,
459: p_end_date
460: ),
461: last_update_date = aso_utility_pvt.DECODE (
462: p_last_update_date,
463: fnd_api.g_miss_date,
464: last_update_date,
465: p_last_update_date

Line 930: aso_utility_pvt.DECODE (

926: fnd_api.g_miss_char,
927: NULL,
928: p_approver_comments
929: ),
930: aso_utility_pvt.DECODE (
931: p_date_sent,
932: fnd_api.g_miss_date,
933: NULL,
934: p_date_sent

Line 936: aso_utility_pvt.DECODE (

932: fnd_api.g_miss_date,
933: NULL,
934: p_date_sent
935: ),
936: aso_utility_pvt.DECODE (
937: p_date_received,
938: fnd_api.g_miss_date,
939: NULL,
940: p_date_received

Line 942: aso_utility_pvt.DECODE (

938: fnd_api.g_miss_date,
939: NULL,
940: p_date_received
941: ),
942: aso_utility_pvt.DECODE (
943: p_creation_date,
944: fnd_api.g_miss_date,
945: NULL,
946: p_creation_date

Line 948: aso_utility_pvt.DECODE (

944: fnd_api.g_miss_date,
945: NULL,
946: p_creation_date
947: ),
948: aso_utility_pvt.DECODE (
949: p_last_update_date,
950: fnd_api.g_miss_date,
951: NULL,
952: p_last_update_date

Line 1279: date_sent = aso_utility_pvt.DECODE (

1275: fnd_api.g_miss_char,
1276: approver_comments,
1277: p_approver_comments
1278: ),
1279: date_sent = aso_utility_pvt.DECODE (
1280: p_date_sent,
1281: fnd_api.g_miss_date,
1282: date_sent,
1283: p_date_sent

Line 1285: date_received = aso_utility_pvt.DECODE (

1281: fnd_api.g_miss_date,
1282: date_sent,
1283: p_date_sent
1284: ),
1285: date_received = aso_utility_pvt.DECODE (
1286: p_date_received,
1287: fnd_api.g_miss_date,
1288: date_received,
1289: p_date_received

Line 1291: creation_date = aso_utility_pvt.DECODE (

1287: fnd_api.g_miss_date,
1288: date_received,
1289: p_date_received
1290: ),
1291: creation_date = aso_utility_pvt.DECODE (
1292: p_creation_date,
1293: fnd_api.g_miss_date,
1294: creation_date,
1295: p_creation_date

Line 1297: last_update_date = aso_utility_pvt.DECODE (

1293: fnd_api.g_miss_date,
1294: creation_date,
1295: p_creation_date
1296: ),
1297: last_update_date = aso_utility_pvt.DECODE (
1298: p_last_update_date,
1299: fnd_api.g_miss_date,
1300: last_update_date,
1301: p_last_update_date

Line 1697: aso_utility_pvt.DECODE (

1693: fnd_api.g_miss_num,
1694: NULL,
1695: p_rule_action_id
1696: ),
1697: aso_utility_pvt.DECODE (
1698: p_creation_date,
1699: fnd_api.g_miss_date,
1700: NULL,
1701: p_creation_date

Line 1709: aso_utility_pvt.DECODE (

1705: fnd_api.g_miss_num,
1706: NULL,
1707: p_created_by
1708: ),
1709: aso_utility_pvt.DECODE (
1710: p_last_update_date,
1711: fnd_api.g_miss_date,
1712: NULL,
1713: p_last_update_date

Line 1938: creation_date = aso_utility_pvt.DECODE (

1934: fnd_api.g_miss_num,
1935: rule_action_id,
1936: p_rule_action_id
1937: ),
1938: creation_date = aso_utility_pvt.DECODE (
1939: p_creation_date,
1940: fnd_api.g_miss_date,
1941: creation_date,
1942: p_creation_date

Line 1950: last_update_date = aso_utility_pvt.DECODE (

1946: fnd_api.g_miss_num,
1947: created_by,
1948: p_created_by
1949: ),
1950: last_update_date = aso_utility_pvt.DECODE (
1951: p_last_update_date,
1952: fnd_api.g_miss_date,
1953: last_update_date,
1954: p_last_update_date