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.JTF_TERR_ENGINE_GEN_PVT dependencies on JTF_TERR_DENORM_RULES_PVT

Line 3869: --dbms_output.put_line('GEN: B4 JTF_TERR_DENORM_RULES_PVT.Populate_API');

3865:
3866: --ARPATEL: 12/03/2003 call denorm package only once for Oracle Sales.
3867: IF (p_source_id = -1001) THEN
3868:
3869: --dbms_output.put_line('GEN: B4 JTF_TERR_DENORM_RULES_PVT.Populate_API');
3870: JTF_TERR_DENORM_RULES_PVT.Populate_API( P_ERROR_CODE => retcode
3871: , P_ERROR_MSG => errbuf
3872: , P_SOURCE_ID => p_source_id
3873: , p_qual_type_id => lp_qual_type_id );

Line 3870: JTF_TERR_DENORM_RULES_PVT.Populate_API( P_ERROR_CODE => retcode

3866: --ARPATEL: 12/03/2003 call denorm package only once for Oracle Sales.
3867: IF (p_source_id = -1001) THEN
3868:
3869: --dbms_output.put_line('GEN: B4 JTF_TERR_DENORM_RULES_PVT.Populate_API');
3870: JTF_TERR_DENORM_RULES_PVT.Populate_API( P_ERROR_CODE => retcode
3871: , P_ERROR_MSG => errbuf
3872: , P_SOURCE_ID => p_source_id
3873: , p_qual_type_id => lp_qual_type_id );
3874: --dbms_output.put_line('AFTER: B4 JTF_TERR_DENORM_RULES_PVT.Populate_API');

Line 3874: --dbms_output.put_line('AFTER: B4 JTF_TERR_DENORM_RULES_PVT.Populate_API');

3870: JTF_TERR_DENORM_RULES_PVT.Populate_API( P_ERROR_CODE => retcode
3871: , P_ERROR_MSG => errbuf
3872: , P_SOURCE_ID => p_source_id
3873: , p_qual_type_id => lp_qual_type_id );
3874: --dbms_output.put_line('AFTER: B4 JTF_TERR_DENORM_RULES_PVT.Populate_API');
3875:
3876:
3877: /* populate resource_exists_flag and absolute rank for Oracle Sales */
3878: UPDATE jtf_terr_denorm_rules_all j

Line 3971: JTF_TERR_DENORM_RULES_PVT.Populate_API( P_ERROR_CODE => retcode

3967: -- IF THE USAGE IS NOT ORACLE SALES
3968: --
3969: IF ( p_source_id <> -1001 ) THEN
3970:
3971: JTF_TERR_DENORM_RULES_PVT.Populate_API( P_ERROR_CODE => retcode
3972: , P_ERROR_MSG => errbuf
3973: , P_SOURCE_ID => p_source_id
3974: , p_qual_type_id => lp_qual_type_id );
3975:

Line 4174: JTF_TERR_DENORM_RULES_PVT.Populate_API( P_ERROR_CODE => retcode

4170: --'/' || p_qualifier_type_id);
4171: --dbms_output.put_line(' ');
4172:
4173: /* build denormalised territory hierarchy table */
4174: JTF_TERR_DENORM_RULES_PVT.Populate_API( P_ERROR_CODE => retcode
4175: , P_ERROR_MSG => errbuf
4176: , P_SOURCE_ID => p_source_id
4177: , p_qual_type_id => LP_QUAL_TYPE_ID );
4178:

Line 4242: /* moved from jtf_terr_denorm_rules_pvt */

4238:
4239:
4240: ELSE --p_source_id <> -1001
4241:
4242: /* moved from jtf_terr_denorm_rules_pvt */
4243: BEGIN
4244: /* get all territories that have resources attached */
4245: UPDATE jtf_terr_denorm_rules_all j
4246: SET j.resource_exists_flag = 'Y'