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.ZX_AR_POPULATE_PKG dependencies on DBMS_UTILITY

Line 2409: l_tbl_index_ccid := dbms_utility.get_hash_value('tax'||LPAD(TO_CHAR(l_tax_dist_ccid),15,'0'), 1,8192);

2405: END LOOP;
2406:
2407: IF l_tax_dist_ccid IS NOT NULL THEN
2408:
2409: l_tbl_index_ccid := dbms_utility.get_hash_value('tax'||LPAD(TO_CHAR(l_tax_dist_ccid),15,'0'), 1,8192);
2410: IF ZX_EXTRACT_PKG.g_ccid_val_desc_tbl.EXISTS(l_tbl_index_ccid) AND
2411: ZX_EXTRACT_PKG.g_ccid_val_desc_tbl(l_tbl_index_ccid).CCID_KEY = 'tax'||TO_CHAR(l_tax_dist_ccid) THEN
2412:
2413: GT_ACCOUNT_FLEXFIELD(j) := ZX_EXTRACT_PKG.g_ccid_val_desc_tbl(l_tbl_index_ccid).FLEXFIELD_VAL;

Line 2462: l_tbl_index_ccid := dbms_utility.get_hash_value('TRX'||LPAD(TO_CHAR(l_trx_dist_ccid),15,'0'), 1,8192);

2458: END IF; --TAX CCID Null Check
2459:
2460: IF l_trx_dist_ccid IS NOT NULL THEN
2461:
2462: l_tbl_index_ccid := dbms_utility.get_hash_value('TRX'||LPAD(TO_CHAR(l_trx_dist_ccid),15,'0'), 1,8192);
2463:
2464: IF ZX_EXTRACT_PKG.g_ccid_val_desc_tbl.EXISTS(l_tbl_index_ccid) AND
2465: ZX_EXTRACT_PKG.g_ccid_val_desc_tbl(l_tbl_index_ccid).CCID_KEY = 'TRX'||TO_CHAR(l_trx_dist_ccid) THEN
2466:

Line 3248: l_tbl_index_ccid := dbms_utility.get_hash_value('tax'||LPAD(TO_CHAR(l_tax_dist_ccid),15,'0'), 1,8192);

3244: END IF;
3245:
3246: IF l_tax_dist_ccid IS NOT NULL AND l_tax_dist_ccid <> -1 THEN
3247:
3248: l_tbl_index_ccid := dbms_utility.get_hash_value('tax'||LPAD(TO_CHAR(l_tax_dist_ccid),15,'0'), 1,8192);
3249: IF ZX_EXTRACT_PKG.g_ccid_val_desc_tbl.EXISTS(l_tbl_index_ccid) AND
3250: ZX_EXTRACT_PKG.g_ccid_val_desc_tbl(l_tbl_index_ccid).CCID_KEY = 'tax'||TO_CHAR(l_tax_dist_ccid) THEN
3251:
3252: GT_ACCOUNT_FLEXFIELD(j) := ZX_EXTRACT_PKG.g_ccid_val_desc_tbl(l_tbl_index_ccid).FLEXFIELD_VAL;

Line 3300: l_tbl_index_ccid := dbms_utility.get_hash_value('TRX'||LPAD(TO_CHAR(l_trx_dist_ccid),15,'0'), 1,8192);

3296: END IF; --TAX CCID Null Check
3297:
3298: IF l_trx_dist_ccid IS NOT NULL AND l_trx_dist_ccid <> -1 THEN
3299:
3300: l_tbl_index_ccid := dbms_utility.get_hash_value('TRX'||LPAD(TO_CHAR(l_trx_dist_ccid),15,'0'), 1,8192);
3301:
3302: IF ZX_EXTRACT_PKG.g_ccid_val_desc_tbl.EXISTS(l_tbl_index_ccid) AND
3303: ZX_EXTRACT_PKG.g_ccid_val_desc_tbl(l_tbl_index_ccid).CCID_KEY = 'TRX'||TO_CHAR(l_trx_dist_ccid) THEN
3304:

Line 3940: --l_tbl_index_cust := dbms_utility.get_hash_value(to_char(l_bill_to_acct_site_id)||

3936:
3937: -- IF GT_BILLING_TP_ID(i) IS NOT NULL AND GT_BILLING_TP_ADDRESS_ID(i) IS NOT NULL THEN
3938:
3939: IF l_bill_to_acct_site_id is not null and l_bill_to_acct_id is not null THEN
3940: --l_tbl_index_cust := dbms_utility.get_hash_value(to_char(l_bill_to_acct_site_id)||
3941: -- to_char(l_bill_to_acct_id)|| l_bill_ship, 1,8192);
3942:
3943: l_tbl_index_cust := to_char(l_bill_to_acct_site_id);
3944: --|| to_char(l_bill_to_acct_id);

Line 4008: --l_tbl_index_party := dbms_utility.get_hash_value(to_char(l_bill_to_party_id)||

4004: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4005: 'After assign to g_cust_bill_ar_tbl ');
4006: END IF;
4007:
4008: --l_tbl_index_party := dbms_utility.get_hash_value(to_char(l_bill_to_party_id)||
4009: -- l_bill_ship, 1,8192);
4010: l_tbl_index_party := to_char(l_bill_to_party_id);
4011:
4012: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 4160: -- l_tbl_index_site := dbms_utility.get_hash_value(to_char(l_bill_to_pty_site_id)||

4156: FND_LOG.STRING(g_level_statement,
4157: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4158: 'After assign to g_party_bill_ar_tbl '||g_party_bill_ar_tbl(l_tbl_index_party).BILLING_TP_NUMBER);
4159: END IF;
4160: -- l_tbl_index_site := dbms_utility.get_hash_value(to_char(l_bill_to_pty_site_id)||
4161: -- l_bill_ship, 1,8192);
4162:
4163: l_tbl_index_bill_site := to_char(l_bill_to_pty_site_id);
4164:

Line 4244: --l_tbl_index_cust := dbms_utility.get_hash_value(to_char(l_ship_to_acct_site_id)||(l_ship_to_acct_id)||

4240: -- IF GT_SHIPPING_TP_ID(i) IS NOT NULL AND GT_SHIPPING_TP_ADDRESS_ID(i) IS NOT NULL THEN
4241:
4242:
4243: IF l_ship_to_acct_site_id is not null and l_ship_to_acct_id is not null THEN
4244: --l_tbl_index_cust := dbms_utility.get_hash_value(to_char(l_ship_to_acct_site_id)||(l_ship_to_acct_id)||
4245: -- l_bill_ship, 1,8192);
4246:
4247: l_tbl_index_cust := to_char(l_ship_to_acct_site_id);
4248: --||(l_ship_to_acct_id);

Line 4302: -- l_tbl_index_party := dbms_utility.get_hash_value(to_char(l_ship_to_party_id)||

4298: l_ship_to_pty_site_id := GT_SHIP_TO_PARTY_SITE_ID(i);
4299: l_ship_to_party_id := GT_SHIP_TO_PARTY_ID(i);
4300:
4301:
4302: -- l_tbl_index_party := dbms_utility.get_hash_value(to_char(l_ship_to_party_id)||
4303: -- l_bill_ship, 1,8192);
4304: l_tbl_index_party := to_char(l_ship_to_party_id);
4305:
4306: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 4476: --l_tbl_index_site := dbms_utility.get_hash_value(to_char(l_ship_to_pty_site_id)||

4472: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
4473: 'After assign to g_party_ship_ar_tbl '||g_party_ship_ar_tbl(l_tbl_index_party).SHIPPING_TP_NAME);
4474: END IF;
4475:
4476: --l_tbl_index_site := dbms_utility.get_hash_value(to_char(l_ship_to_pty_site_id)||
4477: -- l_bill_ship, 1,8192);
4478: l_tbl_index_ship_site := to_char(l_ship_to_pty_site_id);
4479:
4480: IF (g_level_statement >= g_current_runtime_level ) THEN