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

Line 442: l_salesrep_tbl dbms_utility.uncl_array;

438: TYPE l_salesrep_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
439: TYPE l_period_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
440: TYPE l_ruleset_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
441:
442: l_salesrep_tbl dbms_utility.uncl_array;
443: l_period_tbl dbms_utility.uncl_array;
444: l_ruleset_tbl dbms_utility.uncl_array;
445:
446: linenos VARCHAR2(1000):='';

Line 443: l_period_tbl dbms_utility.uncl_array;

439: TYPE l_period_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
440: TYPE l_ruleset_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
441:
442: l_salesrep_tbl dbms_utility.uncl_array;
443: l_period_tbl dbms_utility.uncl_array;
444: l_ruleset_tbl dbms_utility.uncl_array;
445:
446: linenos VARCHAR2(1000):='';
447: tablength BINARY_INTEGER := 0;

Line 444: l_ruleset_tbl dbms_utility.uncl_array;

440: TYPE l_ruleset_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
441:
442: l_salesrep_tbl dbms_utility.uncl_array;
443: l_period_tbl dbms_utility.uncl_array;
444: l_ruleset_tbl dbms_utility.uncl_array;
445:
446: linenos VARCHAR2(1000):='';
447: tablength BINARY_INTEGER := 0;
448:

Line 517: dbms_utility.table_to_comma(l_salesrep_tbl,tablength,linenos);

513: OPEN proj_comp_srp_cr;
514: FETCH proj_comp_srp_cr BULK COLLECT INTO l_salesrep_tbl;
515:
516: IF l_salesrep_tbl.count > 0 THEN
517: dbms_utility.table_to_comma(l_salesrep_tbl,tablength,linenos);
518: x_return_status := FND_API.G_RET_STS_ERROR;
519: fnd_message.set_name('CN','CN_INVALID_RES_ID');
520: fnd_message.set_token('LINE_NO', linenos);
521: fnd_msg_pub.ADD;

Line 530: dbms_utility.table_to_comma(l_period_tbl,tablength,linenos);

526: OPEN proj_comp_prd_cr;
527: FETCH proj_comp_prd_cr BULK COLLECT INTO l_period_tbl;
528:
529: IF l_period_tbl.count > 0 THEN
530: dbms_utility.table_to_comma(l_period_tbl,tablength,linenos);
531: x_return_status := FND_API.G_RET_STS_ERROR;
532: fnd_message.set_name('CN','CN_INVALID_PRD_ID');
533: fnd_message.set_token('LINE_NO', linenos);
534: fnd_msg_pub.ADD;

Line 543: dbms_utility.table_to_comma(l_ruleset_tbl,tablength,linenos);

539: OPEN proj_comp_rs_cr;
540: FETCH proj_comp_rs_cr BULK COLLECT INTO l_ruleset_tbl;
541:
542: IF l_ruleset_tbl.count > 0 THEN
543: dbms_utility.table_to_comma(l_ruleset_tbl,tablength,linenos);
544: x_return_status := FND_API.G_RET_STS_ERROR;
545: fnd_message.set_name('CN','CN_INVALID_RS_ID');
546: fnd_message.set_token('LINE_NO', linenos);
547: fnd_msg_pub.ADD;