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_ESCWFACTIVITY_PVT dependencies on JTF_TERRITORY_GET_PUB

Line 470: l_terr_resource_table jtf_territory_get_pub.QualifyingRsc_out_tbl_type;

466: -------------------------------------------------------------------------
467: -- Territory record and table definitions (returned from
468: -- jtf_territories_get APIs)
469: -------------------------------------------------------------------------
470: l_terr_resource_table jtf_territory_get_pub.QualifyingRsc_out_tbl_type;
471: l_terr_record jtf_territory_get_pub.Terr_Rec_Type;
472: l_terr_type_record jtf_territory_get_pub.Terr_Type_Rec_Type;
473: l_terr_sub_terr_table jtf_territory_get_pub.Terr_Tbl_Type;
474: l_terr_usgs_table jtf_territory_get_pub.Terr_Usgs_Tbl_Type;

Line 471: l_terr_record jtf_territory_get_pub.Terr_Rec_Type;

467: -- Territory record and table definitions (returned from
468: -- jtf_territories_get APIs)
469: -------------------------------------------------------------------------
470: l_terr_resource_table jtf_territory_get_pub.QualifyingRsc_out_tbl_type;
471: l_terr_record jtf_territory_get_pub.Terr_Rec_Type;
472: l_terr_type_record jtf_territory_get_pub.Terr_Type_Rec_Type;
473: l_terr_sub_terr_table jtf_territory_get_pub.Terr_Tbl_Type;
474: l_terr_usgs_table jtf_territory_get_pub.Terr_Usgs_Tbl_Type;
475: l_terr_qtype_usgs_table jtf_territory_get_pub.Terr_QType_Usgs_Tbl_Type;

Line 472: l_terr_type_record jtf_territory_get_pub.Terr_Type_Rec_Type;

468: -- jtf_territories_get APIs)
469: -------------------------------------------------------------------------
470: l_terr_resource_table jtf_territory_get_pub.QualifyingRsc_out_tbl_type;
471: l_terr_record jtf_territory_get_pub.Terr_Rec_Type;
472: l_terr_type_record jtf_territory_get_pub.Terr_Type_Rec_Type;
473: l_terr_sub_terr_table jtf_territory_get_pub.Terr_Tbl_Type;
474: l_terr_usgs_table jtf_territory_get_pub.Terr_Usgs_Tbl_Type;
475: l_terr_qtype_usgs_table jtf_territory_get_pub.Terr_QType_Usgs_Tbl_Type;
476: l_terr_qual_table jtf_territory_get_pub.Terr_Qual_Tbl_Type;

Line 473: l_terr_sub_terr_table jtf_territory_get_pub.Terr_Tbl_Type;

469: -------------------------------------------------------------------------
470: l_terr_resource_table jtf_territory_get_pub.QualifyingRsc_out_tbl_type;
471: l_terr_record jtf_territory_get_pub.Terr_Rec_Type;
472: l_terr_type_record jtf_territory_get_pub.Terr_Type_Rec_Type;
473: l_terr_sub_terr_table jtf_territory_get_pub.Terr_Tbl_Type;
474: l_terr_usgs_table jtf_territory_get_pub.Terr_Usgs_Tbl_Type;
475: l_terr_qtype_usgs_table jtf_territory_get_pub.Terr_QType_Usgs_Tbl_Type;
476: l_terr_qual_table jtf_territory_get_pub.Terr_Qual_Tbl_Type;
477: l_terr_values_table jtf_territory_get_pub.Terr_Values_Tbl_Type;

Line 474: l_terr_usgs_table jtf_territory_get_pub.Terr_Usgs_Tbl_Type;

470: l_terr_resource_table jtf_territory_get_pub.QualifyingRsc_out_tbl_type;
471: l_terr_record jtf_territory_get_pub.Terr_Rec_Type;
472: l_terr_type_record jtf_territory_get_pub.Terr_Type_Rec_Type;
473: l_terr_sub_terr_table jtf_territory_get_pub.Terr_Tbl_Type;
474: l_terr_usgs_table jtf_territory_get_pub.Terr_Usgs_Tbl_Type;
475: l_terr_qtype_usgs_table jtf_territory_get_pub.Terr_QType_Usgs_Tbl_Type;
476: l_terr_qual_table jtf_territory_get_pub.Terr_Qual_Tbl_Type;
477: l_terr_values_table jtf_territory_get_pub.Terr_Values_Tbl_Type;
478: l_terr_rsc_table jtf_territory_get_pub.Terr_Rsc_Tbl_Type;

Line 475: l_terr_qtype_usgs_table jtf_territory_get_pub.Terr_QType_Usgs_Tbl_Type;

471: l_terr_record jtf_territory_get_pub.Terr_Rec_Type;
472: l_terr_type_record jtf_territory_get_pub.Terr_Type_Rec_Type;
473: l_terr_sub_terr_table jtf_territory_get_pub.Terr_Tbl_Type;
474: l_terr_usgs_table jtf_territory_get_pub.Terr_Usgs_Tbl_Type;
475: l_terr_qtype_usgs_table jtf_territory_get_pub.Terr_QType_Usgs_Tbl_Type;
476: l_terr_qual_table jtf_territory_get_pub.Terr_Qual_Tbl_Type;
477: l_terr_values_table jtf_territory_get_pub.Terr_Values_Tbl_Type;
478: l_terr_rsc_table jtf_territory_get_pub.Terr_Rsc_Tbl_Type;
479: l_index BINARY_INTEGER;

Line 476: l_terr_qual_table jtf_territory_get_pub.Terr_Qual_Tbl_Type;

472: l_terr_type_record jtf_territory_get_pub.Terr_Type_Rec_Type;
473: l_terr_sub_terr_table jtf_territory_get_pub.Terr_Tbl_Type;
474: l_terr_usgs_table jtf_territory_get_pub.Terr_Usgs_Tbl_Type;
475: l_terr_qtype_usgs_table jtf_territory_get_pub.Terr_QType_Usgs_Tbl_Type;
476: l_terr_qual_table jtf_territory_get_pub.Terr_Qual_Tbl_Type;
477: l_terr_values_table jtf_territory_get_pub.Terr_Values_Tbl_Type;
478: l_terr_rsc_table jtf_territory_get_pub.Terr_Rsc_Tbl_Type;
479: l_index BINARY_INTEGER;
480: l_esc_territory NUMBER;

Line 477: l_terr_values_table jtf_territory_get_pub.Terr_Values_Tbl_Type;

473: l_terr_sub_terr_table jtf_territory_get_pub.Terr_Tbl_Type;
474: l_terr_usgs_table jtf_territory_get_pub.Terr_Usgs_Tbl_Type;
475: l_terr_qtype_usgs_table jtf_territory_get_pub.Terr_QType_Usgs_Tbl_Type;
476: l_terr_qual_table jtf_territory_get_pub.Terr_Qual_Tbl_Type;
477: l_terr_values_table jtf_territory_get_pub.Terr_Values_Tbl_Type;
478: l_terr_rsc_table jtf_territory_get_pub.Terr_Rsc_Tbl_Type;
479: l_index BINARY_INTEGER;
480: l_esc_territory NUMBER;
481: l_contact_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;

Line 478: l_terr_rsc_table jtf_territory_get_pub.Terr_Rsc_Tbl_Type;

474: l_terr_usgs_table jtf_territory_get_pub.Terr_Usgs_Tbl_Type;
475: l_terr_qtype_usgs_table jtf_territory_get_pub.Terr_QType_Usgs_Tbl_Type;
476: l_terr_qual_table jtf_territory_get_pub.Terr_Qual_Tbl_Type;
477: l_terr_values_table jtf_territory_get_pub.Terr_Values_Tbl_Type;
478: l_terr_rsc_table jtf_territory_get_pub.Terr_Rsc_Tbl_Type;
479: l_index BINARY_INTEGER;
480: l_esc_territory NUMBER;
481: l_contact_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
482: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;

Line 519: JTF_TERRITORY_GET_PUB.Get_Escalation_Territory

515: -- Use primary contact in relevant escalation territory
516: -----------------------------------------------------------------------
517: debug( fnd_log.level_statement, l_api_name, 'escalation territory exists for source doc');
518:
519: JTF_TERRITORY_GET_PUB.Get_Escalation_Territory
520: ( p_api_version => 1.0
521: , p_init_msg_list => FND_API.G_TRUE
522: , x_return_status => l_return_status
523: , x_msg_count => l_msg_count

Line 532: JTF_TERRITORY_GET_PUB.Get_Escalation_TerrMembers

528:
529: IF (l_return_status = FND_API.G_Ret_Sts_Success)
530: THEN
531: debug( fnd_log.level_statement, l_api_name, 'Getting the members for territory'||l_esc_territory);
532: JTF_TERRITORY_GET_PUB.Get_Escalation_TerrMembers
533: ( 1.0
534: , p_terr_id => l_esc_territory
535: , p_init_msg_list => FND_API.G_TRUE
536: , x_return_status => l_return_status

Line 659: l_terr_resource_table jtf_territory_get_pub.QualifyingRsc_out_tbl_type;

655: -------------------------------------------------------------------------
656: -- Territory record and table definitions (returned from
657: -- jtf_territories_get APIs)
658: -------------------------------------------------------------------------
659: l_terr_resource_table jtf_territory_get_pub.QualifyingRsc_out_tbl_type;
660: l_terr_record jtf_territory_get_pub.Terr_Rec_Type;
661: l_terr_type_record jtf_territory_get_pub.Terr_Type_Rec_Type;
662: l_terr_sub_terr_table jtf_territory_get_pub.Terr_Tbl_Type;
663: l_terr_usgs_table jtf_territory_get_pub.Terr_Usgs_Tbl_Type;

Line 660: l_terr_record jtf_territory_get_pub.Terr_Rec_Type;

656: -- Territory record and table definitions (returned from
657: -- jtf_territories_get APIs)
658: -------------------------------------------------------------------------
659: l_terr_resource_table jtf_territory_get_pub.QualifyingRsc_out_tbl_type;
660: l_terr_record jtf_territory_get_pub.Terr_Rec_Type;
661: l_terr_type_record jtf_territory_get_pub.Terr_Type_Rec_Type;
662: l_terr_sub_terr_table jtf_territory_get_pub.Terr_Tbl_Type;
663: l_terr_usgs_table jtf_territory_get_pub.Terr_Usgs_Tbl_Type;
664: l_terr_qtype_usgs_table jtf_territory_get_pub.Terr_QType_Usgs_Tbl_Type;

Line 661: l_terr_type_record jtf_territory_get_pub.Terr_Type_Rec_Type;

657: -- jtf_territories_get APIs)
658: -------------------------------------------------------------------------
659: l_terr_resource_table jtf_territory_get_pub.QualifyingRsc_out_tbl_type;
660: l_terr_record jtf_territory_get_pub.Terr_Rec_Type;
661: l_terr_type_record jtf_territory_get_pub.Terr_Type_Rec_Type;
662: l_terr_sub_terr_table jtf_territory_get_pub.Terr_Tbl_Type;
663: l_terr_usgs_table jtf_territory_get_pub.Terr_Usgs_Tbl_Type;
664: l_terr_qtype_usgs_table jtf_territory_get_pub.Terr_QType_Usgs_Tbl_Type;
665: l_terr_qual_table jtf_territory_get_pub.Terr_Qual_Tbl_Type;

Line 662: l_terr_sub_terr_table jtf_territory_get_pub.Terr_Tbl_Type;

658: -------------------------------------------------------------------------
659: l_terr_resource_table jtf_territory_get_pub.QualifyingRsc_out_tbl_type;
660: l_terr_record jtf_territory_get_pub.Terr_Rec_Type;
661: l_terr_type_record jtf_territory_get_pub.Terr_Type_Rec_Type;
662: l_terr_sub_terr_table jtf_territory_get_pub.Terr_Tbl_Type;
663: l_terr_usgs_table jtf_territory_get_pub.Terr_Usgs_Tbl_Type;
664: l_terr_qtype_usgs_table jtf_territory_get_pub.Terr_QType_Usgs_Tbl_Type;
665: l_terr_qual_table jtf_territory_get_pub.Terr_Qual_Tbl_Type;
666: l_terr_values_table jtf_territory_get_pub.Terr_Values_Tbl_Type;

Line 663: l_terr_usgs_table jtf_territory_get_pub.Terr_Usgs_Tbl_Type;

659: l_terr_resource_table jtf_territory_get_pub.QualifyingRsc_out_tbl_type;
660: l_terr_record jtf_territory_get_pub.Terr_Rec_Type;
661: l_terr_type_record jtf_territory_get_pub.Terr_Type_Rec_Type;
662: l_terr_sub_terr_table jtf_territory_get_pub.Terr_Tbl_Type;
663: l_terr_usgs_table jtf_territory_get_pub.Terr_Usgs_Tbl_Type;
664: l_terr_qtype_usgs_table jtf_territory_get_pub.Terr_QType_Usgs_Tbl_Type;
665: l_terr_qual_table jtf_territory_get_pub.Terr_Qual_Tbl_Type;
666: l_terr_values_table jtf_territory_get_pub.Terr_Values_Tbl_Type;
667: l_terr_rsc_table jtf_territory_get_pub.Terr_Rsc_Tbl_Type;

Line 664: l_terr_qtype_usgs_table jtf_territory_get_pub.Terr_QType_Usgs_Tbl_Type;

660: l_terr_record jtf_territory_get_pub.Terr_Rec_Type;
661: l_terr_type_record jtf_territory_get_pub.Terr_Type_Rec_Type;
662: l_terr_sub_terr_table jtf_territory_get_pub.Terr_Tbl_Type;
663: l_terr_usgs_table jtf_territory_get_pub.Terr_Usgs_Tbl_Type;
664: l_terr_qtype_usgs_table jtf_territory_get_pub.Terr_QType_Usgs_Tbl_Type;
665: l_terr_qual_table jtf_territory_get_pub.Terr_Qual_Tbl_Type;
666: l_terr_values_table jtf_territory_get_pub.Terr_Values_Tbl_Type;
667: l_terr_rsc_table jtf_territory_get_pub.Terr_Rsc_Tbl_Type;
668:

Line 665: l_terr_qual_table jtf_territory_get_pub.Terr_Qual_Tbl_Type;

661: l_terr_type_record jtf_territory_get_pub.Terr_Type_Rec_Type;
662: l_terr_sub_terr_table jtf_territory_get_pub.Terr_Tbl_Type;
663: l_terr_usgs_table jtf_territory_get_pub.Terr_Usgs_Tbl_Type;
664: l_terr_qtype_usgs_table jtf_territory_get_pub.Terr_QType_Usgs_Tbl_Type;
665: l_terr_qual_table jtf_territory_get_pub.Terr_Qual_Tbl_Type;
666: l_terr_values_table jtf_territory_get_pub.Terr_Values_Tbl_Type;
667: l_terr_rsc_table jtf_territory_get_pub.Terr_Rsc_Tbl_Type;
668:
669: -------------------------------------------------------------------------

Line 666: l_terr_values_table jtf_territory_get_pub.Terr_Values_Tbl_Type;

662: l_terr_sub_terr_table jtf_territory_get_pub.Terr_Tbl_Type;
663: l_terr_usgs_table jtf_territory_get_pub.Terr_Usgs_Tbl_Type;
664: l_terr_qtype_usgs_table jtf_territory_get_pub.Terr_QType_Usgs_Tbl_Type;
665: l_terr_qual_table jtf_territory_get_pub.Terr_Qual_Tbl_Type;
666: l_terr_values_table jtf_territory_get_pub.Terr_Values_Tbl_Type;
667: l_terr_rsc_table jtf_territory_get_pub.Terr_Rsc_Tbl_Type;
668:
669: -------------------------------------------------------------------------
670: -- Cursor for HR Manager query

Line 667: l_terr_rsc_table jtf_territory_get_pub.Terr_Rsc_Tbl_Type;

663: l_terr_usgs_table jtf_territory_get_pub.Terr_Usgs_Tbl_Type;
664: l_terr_qtype_usgs_table jtf_territory_get_pub.Terr_QType_Usgs_Tbl_Type;
665: l_terr_qual_table jtf_territory_get_pub.Terr_Qual_Tbl_Type;
666: l_terr_values_table jtf_territory_get_pub.Terr_Values_Tbl_Type;
667: l_terr_rsc_table jtf_territory_get_pub.Terr_Rsc_Tbl_Type;
668:
669: -------------------------------------------------------------------------
670: -- Cursor for HR Manager query
671: -------------------------------------------------------------------------