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_ACTG_POPULATE_PKG dependencies on DBMS_UTILITY

Line 2311: l_tbl_index_cust := dbms_utility.get_hash_value(to_char(l_bill_to_site_id)||to_char(l_bill_to_party_id)||

2307:
2308: -- IF GT_BILLING_TP_ID(i) IS NOT NULL AND GT_BILLING_TP_ADDRESS_ID(i) IS NOT NULL THEN
2309:
2310: IF l_bill_to_site_id is not null and l_bill_to_party_id is not null THEN
2311: l_tbl_index_cust := dbms_utility.get_hash_value(to_char(l_bill_to_site_id)||to_char(l_bill_to_party_id)||
2312: l_bill_ship, 1,8192);
2313:
2314: IF (g_level_procedure >= g_current_runtime_level ) THEN
2315: FND_LOG.STRING(g_level_procedure,

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

2359: 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.EXTRACT_PARTY_INFO',
2360: 'After assign to g_cust_bill_ar_tbl ');
2361: END IF;
2362:
2363: l_tbl_index_party := dbms_utility.get_hash_value(to_char(l_bill_to_party_id)||
2364: l_bill_ship, 1,8192);
2365: IF g_party_bill_ar_tbl.EXISTS(l_tbl_index_party) THEN
2366:
2367: GT_BILLING_TP_NAME_ALT(i) := g_party_bill_ar_tbl(l_tbl_index_party).BILLING_TP_NAME_ALT;

Line 2392: l_tbl_index_site := dbms_utility.get_hash_value(to_char(l_bill_to_site_id)||

2388: FND_LOG.STRING(g_level_procedure,
2389: 'ZX.TRL.ZX_AR_ACTG_POPULATE_PKG.EXTRACT_PARTY_INFO',
2390: 'After assign to g_party_bill_ar_tbl '||g_party_bill_ar_tbl(l_tbl_index_party).BILLING_TP_NUMBER);
2391: END IF;
2392: l_tbl_index_site := dbms_utility.get_hash_value(to_char(l_bill_to_site_id)||
2393: l_bill_ship, 1,8192);
2394:
2395: IF g_site_bill_ar_tbl.EXISTS(l_tbl_index_site) THEN
2396: GT_BILLING_TP_CITY(i) := g_site_bill_ar_tbl(l_tbl_index_site).BILLING_TP_CITY;

Line 2484: l_tbl_index_cust := dbms_utility.get_hash_value(to_char(l_ship_to_site_id)||(l_ship_to_party_id)||

2480: -- IF GT_SHIPPING_TP_ID(i) IS NOT NULL AND GT_SHIPPING_TP_ADDRESS_ID(i) IS NOT NULL THEN
2481:
2482:
2483: IF l_ship_to_site_id is not null and l_ship_to_party_id is not null THEN
2484: l_tbl_index_cust := dbms_utility.get_hash_value(to_char(l_ship_to_site_id)||(l_ship_to_party_id)||
2485: l_bill_ship, 1,8192);
2486:
2487: IF g_cust_ship_ar_tbl.EXISTS(l_tbl_index_cust) THEN
2488: GT_SHIPPING_TP_NUMBER(i) := g_cust_ship_ar_tbl(l_tbl_index_cust).SHIPPING_TP_NUMBER ;

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

2513:
2514: CLOSE cust_acct_cur;
2515: END IF;
2516:
2517: l_tbl_index_party := dbms_utility.get_hash_value(to_char(l_ship_to_party_id)||
2518: l_bill_ship, 1,8192);
2519: IF g_party_ship_ar_tbl.EXISTS(l_tbl_index_party) THEN
2520:
2521: GT_SHIPPING_TP_NAME_ALT(i) := g_party_ship_ar_tbl(l_tbl_index_party).SHIPPING_TP_NAME_ALT;

Line 2539: l_tbl_index_site := dbms_utility.get_hash_value(to_char(l_ship_to_site_id)||

2535: g_party_ship_ar_tbl(l_tbl_index_party).SHIPPING_TP_NUMBER := GT_SHIPPING_TP_NUMBER(i);
2536: CLOSE party_cur;
2537: END IF;
2538:
2539: l_tbl_index_site := dbms_utility.get_hash_value(to_char(l_ship_to_site_id)||
2540: l_bill_ship, 1,8192);
2541: IF g_site_ship_ar_tbl.EXISTS(l_tbl_index_site) THEN
2542: GT_SHIPPING_TP_CITY(i) := g_site_ship_ar_tbl(l_tbl_index_site).SHIPPING_TP_CITY;
2543: GT_SHIPPING_TP_COUNTY(i) := g_site_ship_ar_tbl(l_tbl_index_site).SHIPPING_TP_COUNTY;

Line 2781: l_tbl_index_cust := dbms_utility.get_hash_value(to_char(l_bill_to_site_id)||to_char(l_bill_to_party_id)||

2777:
2778: -- IF GT_BILLING_TP_ID(i) IS NOT NULL AND GT_BILLING_TP_ADDRESS_ID(i) IS NOT NULL THEN
2779:
2780: IF l_bill_to_site_id is not null and l_bill_to_party_id is not null THEN
2781: l_tbl_index_cust := dbms_utility.get_hash_value(to_char(l_bill_to_site_id)||to_char(l_bill_to_party_id)||
2782: l_bill_ship, 1,8192);
2783:
2784: IF (g_level_procedure >= g_current_runtime_level ) THEN
2785: FND_LOG.STRING(g_level_procedure,

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

2829: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
2830: 'After assign to g_cust_bill_ar_tbl ');
2831: END IF;
2832:
2833: l_tbl_index_party := dbms_utility.get_hash_value(to_char(l_bill_to_party_id)||
2834: l_bill_ship, 1,8192);
2835: IF g_party_bill_ar_tbl.EXISTS(l_tbl_index_party) THEN
2836:
2837: GT_BILLING_TP_NAME_ALT(i) := g_party_bill_ar_tbl(l_tbl_index_party).BILLING_TP_NAME_ALT;

Line 2867: l_tbl_index_site := dbms_utility.get_hash_value(to_char(l_bill_to_site_id)||

2863: FND_LOG.STRING(g_level_procedure,
2864: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
2865: 'After assign to g_party_bill_ar_tbl '||g_party_bill_ar_tbl(l_tbl_index_party).BILLING_TP_NUMBER);
2866: END IF;
2867: l_tbl_index_site := dbms_utility.get_hash_value(to_char(l_bill_to_site_id)||
2868: l_bill_ship, 1,8192);
2869:
2870: IF g_site_bill_ar_tbl.EXISTS(l_tbl_index_site) THEN
2871: GT_BILLING_TP_CITY(i) := g_site_bill_ar_tbl(l_tbl_index_site).BILLING_TP_CITY;

Line 2974: l_tbl_index_cust := dbms_utility.get_hash_value(to_char(l_ship_to_site_id)||(l_ship_to_party_id)||

2970: -- IF GT_SHIPPING_TP_ID(i) IS NOT NULL AND GT_SHIPPING_TP_ADDRESS_ID(i) IS NOT NULL THEN
2971:
2972:
2973: IF l_ship_to_site_id is not null and l_ship_to_party_id is not null THEN
2974: l_tbl_index_cust := dbms_utility.get_hash_value(to_char(l_ship_to_site_id)||(l_ship_to_party_id)||
2975: l_bill_ship, 1,8192);
2976:
2977: IF g_cust_ship_ar_tbl.EXISTS(l_tbl_index_cust) THEN
2978: GT_SHIPPING_TP_NUMBER(i) := g_cust_ship_ar_tbl(l_tbl_index_cust).SHIPPING_TP_NUMBER ;

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

3015: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3016: 'After assign to g_cust_ship_ar_tbl '||g_cust_ship_ar_tbl(l_tbl_index_cust).SHIPPING_TP_NUMBER);
3017: END IF;
3018:
3019: l_tbl_index_party := dbms_utility.get_hash_value(to_char(l_ship_to_party_id)||
3020: l_bill_ship, 1,8192);
3021: IF g_party_ship_ar_tbl.EXISTS(l_tbl_index_party) THEN
3022:
3023: GT_SHIPPING_TP_NAME_ALT(i) := g_party_ship_ar_tbl(l_tbl_index_party).SHIPPING_TP_NAME_ALT;

Line 3051: l_tbl_index_site := dbms_utility.get_hash_value(to_char(l_ship_to_site_id)||

3047: 'ZX.TRL.ZX_AR_POPULATE_PKG.EXTRACT_PARTY_INFO',
3048: 'After assign to g_party_ship_ar_tbl '||g_party_ship_ar_tbl(l_tbl_index_party).SHIPPING_TP_NAME);
3049: END IF;
3050:
3051: l_tbl_index_site := dbms_utility.get_hash_value(to_char(l_ship_to_site_id)||
3052: l_bill_ship, 1,8192);
3053: IF g_site_ship_ar_tbl.EXISTS(l_tbl_index_site) THEN
3054: GT_SHIPPING_TP_CITY(i) := g_site_ship_ar_tbl(l_tbl_index_site).SHIPPING_TP_CITY;
3055: GT_SHIPPING_TP_COUNTY(i) := g_site_ship_ar_tbl(l_tbl_index_site).SHIPPING_TP_COUNTY;