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 1769: last_updated_by = arp_global.last_updated_by, /Bug 2089972 /

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

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

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

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

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

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

2279: GROUP BY
2280: rec2.gl_date,
2281: lgd.gl_date
2282: ),
2283: last_updated_by = arp_global.last_updated_by, /* Bug 2089972 */
2284: last_update_date = sysdate
2285: WHERE cust_trx_line_gl_dist_id IN
2286: (SELECT /*+ index(rec3 RA_CUST_TRX_LINE_GL_DIST_N6) */
2287: MIN(DECODE(lgd3.gl_posted_date,

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

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

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

2746: GROUP BY
2747: rec2.gl_date,
2748: lgd.gl_date
2749: ),
2750: last_updated_by = arp_global.last_updated_by, /* Bug 2089972 */
2751: last_update_date = sysdate
2752: WHERE cust_trx_line_gl_dist_id IN
2753: (SELECT MIN(DECODE(lgd3.gl_posted_date,
2754: NULL, lgd3.cust_trx_line_gl_dist_id,

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

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

Line 3599: last_updated_by = arp_global.last_updated_by,

3595: UPDATE ra_cust_trx_line_gl_dist
3596: SET amount = amount + t_round_amount(i),
3597: percent = percent + t_round_percent(i),
3598: acctd_amount = acctd_amount + t_round_acctd(i),
3599: last_updated_by = arp_global.last_updated_by,
3600: last_update_date = sysdate
3601: WHERE cust_trx_line_gl_dist_id in (
3602: /* Bug 4082528 - Select restructured */
3603: /* START OF GL_DIST_ID SELECT */

Line 4121: last_updated_by = arp_global.last_updated_by,

4117: UPDATE ra_cust_trx_line_gl_dist
4118: SET amount = amount + t_round_amount(i),
4119: percent = percent + t_round_percent(i),
4120: acctd_amount = acctd_amount + t_round_acctd(i),
4121: last_updated_by = arp_global.last_updated_by,
4122: last_update_date = sysdate
4123: WHERE cust_trx_line_gl_dist_id in (
4124: /* SELECT GL_DIST_ID FOR EACH LINE THAT
4125: REQUIRES ROUNDING */

Line 4653: arp_global.chart_of_accounts_id,

4649: to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
4650: END IF;
4651:
4652: if not AR_FLEXBUILDER_WF_PKG.SUBSTITUTE_BALANCING_SEGMENT(
4653: arp_global.chart_of_accounts_id,
4654: original_ccid,
4655: balancing_ccid,
4656: return_ccid,
4657: concat_segs,