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.ARP_ROUNDING dependencies on ARP_GLOBAL

Line 469: last_updated_by = arp_global.last_updated_by,

465: UPDATE ra_cust_trx_line_gl_dist g
466: SET amount = amount - t_true_amount(i),
467: percent = percent - t_true_percent(i),
468: acctd_amount = acctd_amount - t_true_acctd(i),
469: last_updated_by = arp_global.last_updated_by,
470: last_update_date = sysdate
471: WHERE cust_trx_line_gl_dist_id in (
472: /* SELECT GL_DIST_ID FOR EACH DATE THAT
473: REQUIRES TRUING */

Line 893: arp_global.sysparam.trx_header_round_ccid;

889: base_min_accountable_unit := p_base_min_accountable_unit;
890: end if;
891:
892: trx_header_round_ccid :=
893: arp_global.sysparam.trx_header_round_ccid;
894:
895: /*------------------------------------------+
896: | Set default values |
897: | If p_trx_header_level_rounding = Y then |

Line 1061: arp_global.last_updated_by,

1057: CUSTOMER_TRX_LINE_ID,
1058: P_TRX_HEADER_ROUND_CCID, /* CODE_COMBINATION_ID */
1059: SET_OF_BOOKS_ID,
1060: SYSDATE,
1061: arp_global.last_updated_by,
1062: SYSDATE,
1063: arp_global.created_by,
1064: arp_global.last_update_login,
1065: PERCENT,

Line 1063: arp_global.created_by,

1059: SET_OF_BOOKS_ID,
1060: SYSDATE,
1061: arp_global.last_updated_by,
1062: SYSDATE,
1063: arp_global.created_by,
1064: arp_global.last_update_login,
1065: PERCENT,
1066: NULL, /* AMOUNT */
1067: GL_DATE,

Line 1064: arp_global.last_update_login,

1060: SYSDATE,
1061: arp_global.last_updated_by,
1062: SYSDATE,
1063: arp_global.created_by,
1064: arp_global.last_update_login,
1065: PERCENT,
1066: NULL, /* AMOUNT */
1067: GL_DATE,
1068: GL_POSTED_DATE,

Line 1082: arp_global.request_id,

1078: ATTRIBUTE7,
1079: ATTRIBUTE8,
1080: ATTRIBUTE9,
1081: ATTRIBUTE10,
1082: arp_global.request_id,
1083: arp_global.program_application_id,
1084: arp_global.program_id,
1085: arp_global.program_update_date,
1086: CONCATENATED_SEGMENTS,

Line 1083: arp_global.program_application_id,

1079: ATTRIBUTE8,
1080: ATTRIBUTE9,
1081: ATTRIBUTE10,
1082: arp_global.request_id,
1083: arp_global.program_application_id,
1084: arp_global.program_id,
1085: arp_global.program_update_date,
1086: CONCATENATED_SEGMENTS,
1087: ORIGINAL_GL_DATE

Line 1084: arp_global.program_id,

1080: ATTRIBUTE9,
1081: ATTRIBUTE10,
1082: arp_global.request_id,
1083: arp_global.program_application_id,
1084: arp_global.program_id,
1085: arp_global.program_update_date,
1086: CONCATENATED_SEGMENTS,
1087: ORIGINAL_GL_DATE
1088: from ra_cust_trx_line_gl_dist rec

Line 1085: arp_global.program_update_date,

1081: ATTRIBUTE10,
1082: arp_global.request_id,
1083: arp_global.program_application_id,
1084: arp_global.program_id,
1085: arp_global.program_update_date,
1086: CONCATENATED_SEGMENTS,
1087: ORIGINAL_GL_DATE
1088: from ra_cust_trx_line_gl_dist rec
1089: where account_class = 'REC'

Line 1195: arp_global.last_updated_by,

1191: CUSTOMER_TRX_LINE_ID,
1192: P_TRX_HEADER_ROUND_CCID, /* CODE_COMBINATION_ID */
1193: SET_OF_BOOKS_ID,
1194: SYSDATE,
1195: arp_global.last_updated_by,
1196: SYSDATE,
1197: arp_global.created_by,
1198: arp_global.last_update_login,
1199: PERCENT,

Line 1197: arp_global.created_by,

1193: SET_OF_BOOKS_ID,
1194: SYSDATE,
1195: arp_global.last_updated_by,
1196: SYSDATE,
1197: arp_global.created_by,
1198: arp_global.last_update_login,
1199: PERCENT,
1200: NULL, /* AMOUNT */
1201: GL_DATE,

Line 1198: arp_global.last_update_login,

1194: SYSDATE,
1195: arp_global.last_updated_by,
1196: SYSDATE,
1197: arp_global.created_by,
1198: arp_global.last_update_login,
1199: PERCENT,
1200: NULL, /* AMOUNT */
1201: GL_DATE,
1202: GL_POSTED_DATE,

Line 1216: arp_global.request_id,

1212: ATTRIBUTE7,
1213: ATTRIBUTE8,
1214: ATTRIBUTE9,
1215: ATTRIBUTE10,
1216: arp_global.request_id,
1217: arp_global.program_application_id,
1218: arp_global.program_id,
1219: arp_global.program_update_date,
1220: CONCATENATED_SEGMENTS,

Line 1217: arp_global.program_application_id,

1213: ATTRIBUTE8,
1214: ATTRIBUTE9,
1215: ATTRIBUTE10,
1216: arp_global.request_id,
1217: arp_global.program_application_id,
1218: arp_global.program_id,
1219: arp_global.program_update_date,
1220: CONCATENATED_SEGMENTS,
1221: ORIGINAL_GL_DATE

Line 1218: arp_global.program_id,

1214: ATTRIBUTE9,
1215: ATTRIBUTE10,
1216: arp_global.request_id,
1217: arp_global.program_application_id,
1218: arp_global.program_id,
1219: arp_global.program_update_date,
1220: CONCATENATED_SEGMENTS,
1221: ORIGINAL_GL_DATE
1222: from ra_cust_trx_line_gl_dist rec

Line 1219: arp_global.program_update_date,

1215: ATTRIBUTE10,
1216: arp_global.request_id,
1217: arp_global.program_application_id,
1218: arp_global.program_id,
1219: arp_global.program_update_date,
1220: CONCATENATED_SEGMENTS,
1221: ORIGINAL_GL_DATE
1222: from ra_cust_trx_line_gl_dist rec
1223: where account_class = 'REC'

Line 1464: last_updated_by = arp_global.last_updated_by, /* Bug 2089972 */

1460: concatenated_segments
1461: from ra_customer_trx ct
1462: where ct.customer_trx_id = dist.customer_trx_id
1463: ),
1464: last_updated_by = arp_global.last_updated_by, /* Bug 2089972 */
1465: last_update_date = sysdate
1466: where dist.customer_trx_id = P_CUSTOMER_TRX_ID
1467: and dist.account_class = 'ROUND'
1468: and dist.gl_posted_date is null

Line 1590: last_updated_by = arp_global.last_updated_by, /* Bug 2089972 */

1586: t.invoice_currency_code,
1587: t.exchange_date,
1588: exchange_rate
1589: ),
1590: last_updated_by = arp_global.last_updated_by, /* Bug 2089972 */
1591: last_update_date = sysdate
1592: where customer_trx_id in
1593: ( select l.customer_trx_id
1594: from ra_customer_trx_lines l,

Line 1684: last_updated_by = arp_global.last_updated_by, /Bug 2089972 /

1680: t.exchange_date,
1681: t.exchange_rate_type,
1682: exchange_rate
1683: ),
1684: last_updated_by = arp_global.last_updated_by, /*Bug 2089972 */
1685: last_update_date = sysdate
1686: where customer_trx_id in
1687: ( select /*+ leading(T,D,L) use_hash(L)
1688: index(L RA_CUSTOMER_TRX_LINES_N4) */

Line 1768: last_updated_by = arp_global.last_updated_by, /Bug 2089972 /

1764: t.exchange_date,
1765: t.exchange_rate_type,
1766: exchange_rate
1767: ),
1768: last_updated_by = arp_global.last_updated_by, /*Bug 2089972 */
1769: last_update_date = sysdate
1770: where customer_trx_id in
1771: ( select l.customer_trx_id
1772: from ra_customer_trx t,

Line 1937: last_updated_by = arp_global.last_updated_by, /* Bug 2089972 */

1933: GROUP BY
1934: l.customer_trx_id,
1935: t.trx_number
1936: ),
1937: last_updated_by = arp_global.last_updated_by, /* Bug 2089972 */
1938: last_update_date = sysdate
1939: WHERE customer_trx_id IN
1940: ( SELECT
1941: l.customer_trx_id

Line 2025: last_updated_by = arp_global.last_updated_by, /* Bug 2089972 */

2021: GROUP BY
2022: l.customer_trx_id,
2023: t.trx_number
2024: ),
2025: last_updated_by = arp_global.last_updated_by, /* Bug 2089972 */
2026: last_update_date = sysdate
2027: WHERE customer_trx_id IN
2028: ( SELECT
2029: l.customer_trx_id

Line 2281: last_updated_by = arp_global.last_updated_by, /* Bug 2089972 */

2277: GROUP BY
2278: rec2.gl_date,
2279: lgd.gl_date
2280: ),
2281: last_updated_by = arp_global.last_updated_by, /* Bug 2089972 */
2282: last_update_date = sysdate
2283: WHERE cust_trx_line_gl_dist_id IN
2284: (SELECT /*+ INDEX (lgd3 ra_cust_trx_line_gl_dist_n7) */
2285: MIN(DECODE(lgd3.gl_posted_date,

Line 2501: last_updated_by = arp_global.last_updated_by, /* Bug 2089972 */

2497: GROUP BY
2498: rec2.gl_date,
2499: lgd.gl_date
2500: ),
2501: last_updated_by = arp_global.last_updated_by, /* Bug 2089972 */
2502: last_update_date = sysdate
2503: WHERE cust_trx_line_gl_dist_id IN
2504: (SELECT /*+ leading(T,LGD3,REC3,CTL)
2505: use_hash(CTL) index(CTL RA_CUSTOMER_TRX_LINES_N4)

Line 2745: last_updated_by = arp_global.last_updated_by, /* Bug 2089972 */

2741: GROUP BY
2742: rec2.gl_date,
2743: lgd.gl_date
2744: ),
2745: last_updated_by = arp_global.last_updated_by, /* Bug 2089972 */
2746: last_update_date = sysdate
2747: WHERE cust_trx_line_gl_dist_id IN
2748: (SELECT MIN(DECODE(lgd3.gl_posted_date,
2749: NULL, lgd3.cust_trx_line_gl_dist_id,

Line 2981: last_updated_by = arp_global.last_updated_by, /* Bug 2089972 */

2977: GROUP BY
2978: rec2.gl_date,
2979: lgd.gl_date
2980: ),
2981: last_updated_by = arp_global.last_updated_by, /* Bug 2089972 */
2982: last_update_date = sysdate
2983: WHERE cust_trx_line_gl_dist_id IN
2984: (SELECT MIN(DECODE(lgd3.gl_posted_date,
2985: NULL, lgd3.cust_trx_line_gl_dist_id,

Line 3569: last_updated_by = arp_global.last_updated_by,

3565: UPDATE ra_cust_trx_line_gl_dist
3566: SET amount = amount + t_round_amount(i),
3567: percent = percent + t_round_percent(i),
3568: acctd_amount = acctd_amount + t_round_acctd(i),
3569: last_updated_by = arp_global.last_updated_by,
3570: last_update_date = sysdate
3571: WHERE cust_trx_line_gl_dist_id in (
3572: /* SELECT GL_DIST_ID FOR EACH LINE THAT
3573: REQUIRES ROUNDING */

Line 4112: last_updated_by = arp_global.last_updated_by,

4108: UPDATE ra_cust_trx_line_gl_dist
4109: SET amount = amount + t_round_amount(i),
4110: percent = percent + t_round_percent(i),
4111: acctd_amount = acctd_amount + t_round_acctd(i),
4112: last_updated_by = arp_global.last_updated_by,
4113: last_update_date = sysdate
4114: WHERE cust_trx_line_gl_dist_id in (
4115: /* SELECT GL_DIST_ID FOR EACH LINE THAT
4116: REQUIRES ROUNDING */

Line 4641: arp_global.chart_of_accounts_id,

4637: to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
4638: END IF;
4639:
4640: if not AR_FLEXBUILDER_WF_PKG.SUBSTITUTE_BALANCING_SEGMENT(
4641: arp_global.chart_of_accounts_id,
4642: original_ccid,
4643: balancing_ccid,
4644: return_ccid,
4645: concat_segs,