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_QTYPE_USGS_ALL

Line 273: DELETE from JTF_TERR_QTYPE_USGS_ALL jtqu

269: WHERE jt.terr_group_flag = 'Y' );
270:
271:
272: --Delete Territory qual type usgs
273: DELETE from JTF_TERR_QTYPE_USGS_ALL jtqu
274: WHERE jtqu.terr_id IN
275: ( SELECT jt.terr_id
276: FROM jtf_terr_all jt
277: WHERE jt.terr_group_flag = 'Y' );

Line 3698: FROM jtf_terr_qtype_usgs_all jtqu

3694: CURSOR csr_get_terr ( lp_source_id NUMBER
3695: , lp_qual_type_id NUMBER
3696: , lp_sysdate DATE ) IS
3697: SELECT 'TRUE'
3698: FROM jtf_terr_qtype_usgs_all jtqu
3699: , jtf_terr_usgs_all jtu
3700: , jtf_terr_all jt1
3701: , jtf_qual_type_usgs jqtu
3702: WHERE jtqu.terr_id = jt1.terr_id

Line 3736: /* ARPATEL: 12/08/2003 Cursor used to update num_qual in jtf_terr_qtype_usgs_all for Oracle Sales */

3732: WHERE jtdr.terr_id = jtdr.related_terr_id
3733: AND jtdr.source_id = lp_source_id
3734: AND jtdr.qual_type_id = lp_qual_type_id;
3735:
3736: /* ARPATEL: 12/08/2003 Cursor used to update num_qual in jtf_terr_qtype_usgs_all for Oracle Sales */
3737: CURSOR csr_get_terr_num_qual ( lp_source_id NUMBER
3738: , lp_qual_type_id NUMBER ) IS
3739: SELECT jtqu.terr_id
3740: , jtqu.terr_qtype_usg_id

Line 3741: FROM jtf_terr_qtype_usgs_all jtqu

3737: CURSOR csr_get_terr_num_qual ( lp_source_id NUMBER
3738: , lp_qual_type_id NUMBER ) IS
3739: SELECT jtqu.terr_id
3740: , jtqu.terr_qtype_usg_id
3741: FROM jtf_terr_qtype_usgs_all jtqu
3742: , jtf_terr_denorm_rules_all jtdr
3743: , jtf_qual_type_usgs jqtu
3744: WHERE jqtu.qual_type_id = LP_qual_type_id
3745: AND jqtu.qual_type_usg_id = jtqu.qual_type_usg_id

Line 4049: Write_Log(2, 'START: UPDATE jtf_terr_qtype_usgs_all ');

4045: /* ONLY FOR ORACLE SALES */
4046: IF ( p_source_id = -1001 ) THEN
4047:
4048: If G_Debug Then
4049: Write_Log(2, 'START: UPDATE jtf_terr_qtype_usgs_all ');
4050: End If;
4051:
4052: /* ACHANDA 02/03/04 Bug 3373687 : disable the trigger before update */
4053: BEGIN

Line 4061: ** jtf_terr_qtype_usgs_all.num_qual column ONLY

4057: NULL;
4058: END;
4059:
4060: /* ARPATEL: 12/03/2003 populate
4061: ** jtf_terr_qtype_usgs_all.num_qual column ONLY
4062: ** for Oracle Sales (-1001) */
4063: FOR csr_dnm IN csr_get_terr_num_qual( p_source_id
4064: , lp_qual_type_id) LOOP
4065:

Line 4066: --dbms_output.put_line('GEN: UPDATE jtf_terr_qtype_usgs_all '||lp_qual_type_id);

4062: ** for Oracle Sales (-1001) */
4063: FOR csr_dnm IN csr_get_terr_num_qual( p_source_id
4064: , lp_qual_type_id) LOOP
4065:
4066: --dbms_output.put_line('GEN: UPDATE jtf_terr_qtype_usgs_all '||lp_qual_type_id);
4067:
4068: UPDATE jtf_terr_qtype_usgs_all qua
4069: SET qua.num_qual = (
4070: SELECT COUNT(*)

Line 4068: UPDATE jtf_terr_qtype_usgs_all qua

4064: , lp_qual_type_id) LOOP
4065:
4066: --dbms_output.put_line('GEN: UPDATE jtf_terr_qtype_usgs_all '||lp_qual_type_id);
4067:
4068: UPDATE jtf_terr_qtype_usgs_all qua
4069: SET qua.num_qual = (
4070: SELECT COUNT(*)
4071: FROM jtf_terr_qual_all jtq
4072: , jtf_qual_usgs_all jqu

Line 4096: --dbms_output.put_line('AFTER: GEN: UPDATE jtf_terr_qtype_usgs_all '||lp_qual_type_id);

4092: START WITH jt.terr_id = csr_dnm.terr_id )
4093: )
4094: WHERE qua.terr_qtype_usg_id = csr_dnm.terr_qtype_usg_id;
4095:
4096: --dbms_output.put_line('AFTER: GEN: UPDATE jtf_terr_qtype_usgs_all '||lp_qual_type_id);
4097:
4098: END LOOP;
4099:
4100: /* ACHANDA 02/03/04 Bug 3373687 : enable the trigger after update */

Line 4109: Write_Log(2, 'END: UPDATE jtf_terr_qtype_usgs_all ');

4105: NULL;
4106: END;
4107:
4108: If G_Debug Then
4109: Write_Log(2, 'END: UPDATE jtf_terr_qtype_usgs_all ');
4110: End If;
4111:
4112: END IF; -- end of p_source_id = -1001
4113:

Line 4307: Write_Log(2, 'START: UPDATE jtf_terr_qtype_usgs_all ');

4303:
4304: IF ( p_source_id = -1001 ) THEN
4305:
4306: If G_Debug Then
4307: Write_Log(2, 'START: UPDATE jtf_terr_qtype_usgs_all ');
4308: End If;
4309:
4310: /* ACHANDA 02/03/04 Bug 3373687 : disable the trigger before update */
4311: BEGIN

Line 4322: --dbms_output.put_line('GEN: UPDATE jtf_terr_qtype_usgs_all '||lp_qual_type_id);

4318: /* ARPATEL: 12/03/2003 populate num_qual column ONLY for Oracle Sales (-1001) */
4319: FOR csr_dnm IN csr_get_terr_num_qual( p_source_id
4320: , LP_QUAL_TYPE_ID ) LOOP
4321:
4322: --dbms_output.put_line('GEN: UPDATE jtf_terr_qtype_usgs_all '||lp_qual_type_id);
4323: UPDATE jtf_terr_qtype_usgs_all qua
4324: SET qua.num_qual = ( SELECT count(*)
4325: FROM jtf_terr_qual_all jtq
4326: , jtf_qual_usgs_all jqu

Line 4323: UPDATE jtf_terr_qtype_usgs_all qua

4319: FOR csr_dnm IN csr_get_terr_num_qual( p_source_id
4320: , LP_QUAL_TYPE_ID ) LOOP
4321:
4322: --dbms_output.put_line('GEN: UPDATE jtf_terr_qtype_usgs_all '||lp_qual_type_id);
4323: UPDATE jtf_terr_qtype_usgs_all qua
4324: SET qua.num_qual = ( SELECT count(*)
4325: FROM jtf_terr_qual_all jtq
4326: , jtf_qual_usgs_all jqu
4327: , jtf_qual_type_usgs jqtu

Line 4350: --dbms_output.put_line('AFTER: GEN: UPDATE jtf_terr_qtype_usgs_all '||lp_qual_type_id);

4346: START WITH jt.terr_id = csr_dnm.terr_id )
4347: )
4348: WHERE qua.terr_qtype_usg_id = csr_dnm.terr_qtype_usg_id;
4349:
4350: --dbms_output.put_line('AFTER: GEN: UPDATE jtf_terr_qtype_usgs_all '||lp_qual_type_id);
4351:
4352: END LOOP;
4353:
4354: /* ACHANDA 02/03/04 Bug 3373687 : enable the trigger after update */

Line 4363: Write_Log(2, 'END: UPDATE jtf_terr_qtype_usgs_all ');

4359: NULL;
4360: END;
4361:
4362: If G_Debug Then
4363: Write_Log(2, 'END: UPDATE jtf_terr_qtype_usgs_all ');
4364: End If;
4365:
4366: END IF; -- end of p_source_id = -1001
4367: