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.

[Home] [Help]

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 912: aso_utility_pvt.DECODE (

908: fnd_api.g_miss_char,
909: NULL,
910: p_approver_comments
911: ),
912: aso_utility_pvt.DECODE (
913: p_date_sent,
914: fnd_api.g_miss_date,
915: NULL,
916: p_date_sent

Line 918: aso_utility_pvt.DECODE (

914: fnd_api.g_miss_date,
915: NULL,
916: p_date_sent
917: ),
918: aso_utility_pvt.DECODE (
919: p_date_received,
920: fnd_api.g_miss_date,
921: NULL,
922: p_date_received

Line 924: aso_utility_pvt.DECODE (

920: fnd_api.g_miss_date,
921: NULL,
922: p_date_received
923: ),
924: aso_utility_pvt.DECODE (
925: p_creation_date,
926: fnd_api.g_miss_date,
927: NULL,
928: p_creation_date

Line 930: aso_utility_pvt.DECODE (

926: fnd_api.g_miss_date,
927: NULL,
928: p_creation_date
929: ),
930: aso_utility_pvt.DECODE (
931: p_last_update_date,
932: fnd_api.g_miss_date,
933: NULL,
934: p_last_update_date

Line 1198: date_sent = aso_utility_pvt.DECODE (

1194: fnd_api.g_miss_char,
1195: approver_comments,
1196: p_approver_comments
1197: ),
1198: date_sent = aso_utility_pvt.DECODE (
1199: p_date_sent,
1200: fnd_api.g_miss_date,
1201: date_sent,
1202: p_date_sent

Line 1204: date_received = aso_utility_pvt.DECODE (

1200: fnd_api.g_miss_date,
1201: date_sent,
1202: p_date_sent
1203: ),
1204: date_received = aso_utility_pvt.DECODE (
1205: p_date_received,
1206: fnd_api.g_miss_date,
1207: date_received,
1208: p_date_received

Line 1210: creation_date = aso_utility_pvt.DECODE (

1206: fnd_api.g_miss_date,
1207: date_received,
1208: p_date_received
1209: ),
1210: creation_date = aso_utility_pvt.DECODE (
1211: p_creation_date,
1212: fnd_api.g_miss_date,
1213: creation_date,
1214: p_creation_date

Line 1216: last_update_date = aso_utility_pvt.DECODE (

1212: fnd_api.g_miss_date,
1213: creation_date,
1214: p_creation_date
1215: ),
1216: last_update_date = aso_utility_pvt.DECODE (
1217: p_last_update_date,
1218: fnd_api.g_miss_date,
1219: last_update_date,
1220: p_last_update_date

Line 1616: aso_utility_pvt.DECODE (

1612: fnd_api.g_miss_num,
1613: NULL,
1614: p_rule_action_id
1615: ),
1616: aso_utility_pvt.DECODE (
1617: p_creation_date,
1618: fnd_api.g_miss_date,
1619: NULL,
1620: p_creation_date

Line 1628: aso_utility_pvt.DECODE (

1624: fnd_api.g_miss_num,
1625: NULL,
1626: p_created_by
1627: ),
1628: aso_utility_pvt.DECODE (
1629: p_last_update_date,
1630: fnd_api.g_miss_date,
1631: NULL,
1632: p_last_update_date

Line 1857: creation_date = aso_utility_pvt.DECODE (

1853: fnd_api.g_miss_num,
1854: rule_action_id,
1855: p_rule_action_id
1856: ),
1857: creation_date = aso_utility_pvt.DECODE (
1858: p_creation_date,
1859: fnd_api.g_miss_date,
1860: creation_date,
1861: p_creation_date

Line 1869: last_update_date = aso_utility_pvt.DECODE (

1865: fnd_api.g_miss_num,
1866: created_by,
1867: p_created_by
1868: ),
1869: last_update_date = aso_utility_pvt.DECODE (
1870: p_last_update_date,
1871: fnd_api.g_miss_date,
1872: last_update_date,
1873: p_last_update_date