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.CSF_RESOURCE_PUB dependencies on JTF_ASSIGN_PUB

Line 108: * @returns Task Record (JTF_ASSIGN_PUB.JTF_SRV_TASK_REC_TYPE).

104: * Gets the Task Information in the format as desired by JTF Assignment
105: * Manager API.
106: *
107: * @param p_task_id Task Identifier
108: * @returns Task Record (JTF_ASSIGN_PUB.JTF_SRV_TASK_REC_TYPE).
109: */
110: FUNCTION get_srv_task_rec(p_task_id IN NUMBER)
111: RETURN jtf_assign_pub.jtf_srv_task_rec_type IS
112: l_rec jtf_assign_pub.jtf_srv_task_rec_type;

Line 111: RETURN jtf_assign_pub.jtf_srv_task_rec_type IS

107: * @param p_task_id Task Identifier
108: * @returns Task Record (JTF_ASSIGN_PUB.JTF_SRV_TASK_REC_TYPE).
109: */
110: FUNCTION get_srv_task_rec(p_task_id IN NUMBER)
111: RETURN jtf_assign_pub.jtf_srv_task_rec_type IS
112: l_rec jtf_assign_pub.jtf_srv_task_rec_type;
113: l_contract_service_id NUMBER;
114: l_planned_start_date date;
115: -- Task, SR, Party and Address Information

Line 112: l_rec jtf_assign_pub.jtf_srv_task_rec_type;

108: * @returns Task Record (JTF_ASSIGN_PUB.JTF_SRV_TASK_REC_TYPE).
109: */
110: FUNCTION get_srv_task_rec(p_task_id IN NUMBER)
111: RETURN jtf_assign_pub.jtf_srv_task_rec_type IS
112: l_rec jtf_assign_pub.jtf_srv_task_rec_type;
113: l_contract_service_id NUMBER;
114: l_planned_start_date date;
115: -- Task, SR, Party and Address Information
116: CURSOR c_rec IS

Line 331: p_res_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type

327: RETURN l_value;
328: END get_display_value;
329:
330: PROCEDURE set_generic_planwindow (
331: p_res_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type
332: , p_start DATE
333: , p_end DATE
334: ) IS
335: i PLS_INTEGER;

Line 350: * and the fields in JTF_ASSIGN_PUB.JTF_SRV_TASK_REC_TYPE.

346: * Adds the Qualifier identified by the Index to the global Task Qualifer Table with
347: * the value taken from the given Task Record and only when the value is Not Null.
348: *
349: * Uses a Hard Coded Mapping between JTF_SEEDED_QUAL_USGS_V.QUAL_USG_ID
350: * and the fields in JTF_ASSIGN_PUB.JTF_SRV_TASK_REC_TYPE.
351: *
352: * Qualifiers of type -1211, -1212 and -1218 have been disabled and
353: * therefore wont be set by this API.
354: *

Line 362: , p_task_rec IN jtf_assign_pub.jtf_srv_task_rec_type

358: */
359: PROCEDURE add_qualifier(
360: p_qualifier_tbl IN OUT NOCOPY resource_qualifier_tbl_type
361: , p_index IN PLS_INTEGER
362: , p_task_rec IN jtf_assign_pub.jtf_srv_task_rec_type
363: ) IS
364: l_value VARCHAR2(360);
365: l_associated_value VARCHAR2(360);
366: i PLS_INTEGER;

Line 459: l_task_rec jtf_assign_pub.jtf_srv_task_rec_type;

455: */
456: FUNCTION get_res_qualifier_table(p_task_id NUMBER)
457: RETURN resource_qualifier_tbl_type IS
458: m PLS_INTEGER;
459: l_task_rec jtf_assign_pub.jtf_srv_task_rec_type;
460: l_qualifier_tbl resource_qualifier_tbl_type;
461: BEGIN
462: -- Fetch all the Enabled Qualifiers
463: IF g_all_qualifiers.COUNT = 0 THEN

Line 487: * and the fields in JTF_ASSIGN_PUB.JTF_SRV_TASK_REC_TYPE.

483: * Assembles the selected Qualifiers for this Task from the Qualifier
484: * Table in to a Record Type understandable by JTF Assignment Manager.
485: *
486: * Uses a Hard Coded Mapping between JTF_SEEDED_QUAL_USGS_V.QUAL_USG_ID
487: * and the fields in JTF_ASSIGN_PUB.JTF_SRV_TASK_REC_TYPE.
488: *
489: * The Task and SR Number must be set by the caller and wont be set by
490: * this API. Moreover Qualifiers of type -1211, -1212 and -1218 have
491: * been disabled and therefore wont be set by this API.

Line 496: RETURN jtf_assign_pub.jtf_srv_task_rec_type IS

492: *
493: * @param p_table Qualifier Table having the list of Task Qualifiers
494: */
495: FUNCTION get_qualified_task_rec(p_table resource_qualifier_tbl_type)
496: RETURN jtf_assign_pub.jtf_srv_task_rec_type IS
497: k PLS_INTEGER;
498: task_rec jtf_assign_pub.jtf_srv_task_rec_type;
499: BEGIN
500: k := p_table.FIRST;

Line 498: task_rec jtf_assign_pub.jtf_srv_task_rec_type;

494: */
495: FUNCTION get_qualified_task_rec(p_table resource_qualifier_tbl_type)
496: RETURN jtf_assign_pub.jtf_srv_task_rec_type IS
497: k PLS_INTEGER;
498: task_rec jtf_assign_pub.jtf_srv_task_rec_type;
499: BEGIN
500: k := p_table.FIRST;
501: WHILE k IS NOT NULL LOOP
502: IF p_table(k).use_flag = 'Y' THEN

Line 603: * @return Common Resource Table (JTF_ASSIGN_PUB.ASSIGNRESOURCES_TBL_TYPE)

599: * @param p_res_1_tbl Resource Table 1
600: * @param p_res_2_tbl Resource Table 2
601: * @param p_start Start Date of the Window
602: * @param p_end End Date of the Window
603: * @return Common Resource Table (JTF_ASSIGN_PUB.ASSIGNRESOURCES_TBL_TYPE)
604: */
605: FUNCTION intersect_results(
606: p_res_1_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type
607: , p_res_2_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type

Line 606: p_res_1_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type

602: * @param p_end End Date of the Window
603: * @return Common Resource Table (JTF_ASSIGN_PUB.ASSIGNRESOURCES_TBL_TYPE)
604: */
605: FUNCTION intersect_results(
606: p_res_1_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type
607: , p_res_2_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type
608: , p_start DATE
609: , p_end DATE
610: ) RETURN jtf_assign_pub.assignresources_tbl_type IS

Line 607: , p_res_2_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type

603: * @return Common Resource Table (JTF_ASSIGN_PUB.ASSIGNRESOURCES_TBL_TYPE)
604: */
605: FUNCTION intersect_results(
606: p_res_1_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type
607: , p_res_2_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type
608: , p_start DATE
609: , p_end DATE
610: ) RETURN jtf_assign_pub.assignresources_tbl_type IS
611: i PLS_INTEGER;

Line 610: ) RETURN jtf_assign_pub.assignresources_tbl_type IS

606: p_res_1_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type
607: , p_res_2_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type
608: , p_start DATE
609: , p_end DATE
610: ) RETURN jtf_assign_pub.assignresources_tbl_type IS
611: i PLS_INTEGER;
612: j PLS_INTEGER;
613: k PLS_INTEGER;
614: l_res_tbl jtf_assign_pub.assignresources_tbl_type;

Line 614: l_res_tbl jtf_assign_pub.assignresources_tbl_type;

610: ) RETURN jtf_assign_pub.assignresources_tbl_type IS
611: i PLS_INTEGER;
612: j PLS_INTEGER;
613: k PLS_INTEGER;
614: l_res_tbl jtf_assign_pub.assignresources_tbl_type;
615: BEGIN
616: k := 0;
617: i := p_res_1_tbl.FIRST;
618: WHILE i IS NOT NULL LOOP

Line 668: * @return Common Resource Table (JTF_ASSIGN_PUB.ASSIGNRESOURCES_TBL_TYPE)

664: * the operation.
665: *
666: * @param p_res_1_tbl Resource Table 1
667: * @param p_res_2_tbl Resource Table 2
668: * @return Common Resource Table (JTF_ASSIGN_PUB.ASSIGNRESOURCES_TBL_TYPE)
669: */
670: FUNCTION union_results(
671: p_res_1_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type
672: , p_res_2_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type

Line 671: p_res_1_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type

667: * @param p_res_2_tbl Resource Table 2
668: * @return Common Resource Table (JTF_ASSIGN_PUB.ASSIGNRESOURCES_TBL_TYPE)
669: */
670: FUNCTION union_results(
671: p_res_1_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type
672: , p_res_2_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type
673: ) RETURN jtf_assign_pub.assignresources_tbl_type IS
674: i PLS_INTEGER;
675: j PLS_INTEGER;

Line 672: , p_res_2_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type

668: * @return Common Resource Table (JTF_ASSIGN_PUB.ASSIGNRESOURCES_TBL_TYPE)
669: */
670: FUNCTION union_results(
671: p_res_1_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type
672: , p_res_2_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type
673: ) RETURN jtf_assign_pub.assignresources_tbl_type IS
674: i PLS_INTEGER;
675: j PLS_INTEGER;
676: k PLS_INTEGER;

Line 673: ) RETURN jtf_assign_pub.assignresources_tbl_type IS

669: */
670: FUNCTION union_results(
671: p_res_1_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type
672: , p_res_2_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type
673: ) RETURN jtf_assign_pub.assignresources_tbl_type IS
674: i PLS_INTEGER;
675: j PLS_INTEGER;
676: k PLS_INTEGER;
677: l_res_tbl jtf_assign_pub.assignresources_tbl_type;

Line 677: l_res_tbl jtf_assign_pub.assignresources_tbl_type;

673: ) RETURN jtf_assign_pub.assignresources_tbl_type IS
674: i PLS_INTEGER;
675: j PLS_INTEGER;
676: k PLS_INTEGER;
677: l_res_tbl jtf_assign_pub.assignresources_tbl_type;
678: BEGIN
679: k := p_res_1_tbl.LAST;
680: i := p_res_2_tbl.FIRST;
681:

Line 755: , x_skilled_res_tbl OUT NOCOPY jtf_assign_pub.assignresources_tbl_type

751: , p_start IN DATE
752: , p_end IN DATE
753: , p_resource_id IN NUMBER DEFAULT NULL
754: , p_resource_type IN VARCHAR2 DEFAULT NULL
755: , x_skilled_res_tbl OUT NOCOPY jtf_assign_pub.assignresources_tbl_type
756: ) IS
757: l_levelmatch CONSTANT NUMBER := NVL(fnd_profile.VALUE('CSF_SKILL_LEVEL_MATCH'), 2);
758: j PLS_INTEGER;
759:

Line 888: * @returns Sorted Resources List (JTF_ASSIGN_PUB.ASSIGNRESOURCES_TBL_TYPE)

884: * @param p_unsorted_res_tbl List of UnSorted Resources
885: * @param p_task_id Task ID of the Task to be performed
886: * @param p_start Start of the Window to get that Period's Address
887: * @param p_end End of the Window to get that Period's Address
888: * @returns Sorted Resources List (JTF_ASSIGN_PUB.ASSIGNRESOURCES_TBL_TYPE)
889: */
890: FUNCTION sort_resource_by_distance(
891: p_unsorted_res_tbl jtf_assign_pub.assignresources_tbl_type
892: , p_task_id NUMBER

Line 891: p_unsorted_res_tbl jtf_assign_pub.assignresources_tbl_type

887: * @param p_end End of the Window to get that Period's Address
888: * @returns Sorted Resources List (JTF_ASSIGN_PUB.ASSIGNRESOURCES_TBL_TYPE)
889: */
890: FUNCTION sort_resource_by_distance(
891: p_unsorted_res_tbl jtf_assign_pub.assignresources_tbl_type
892: , p_task_id NUMBER
893: , p_start DATE
894: , p_end DATE
895: )

Line 896: RETURN jtf_assign_pub.assignresources_tbl_type IS

892: , p_task_id NUMBER
893: , p_start DATE
894: , p_end DATE
895: )
896: RETURN jtf_assign_pub.assignresources_tbl_type IS
897: l_return_status VARCHAR2(1);
898: l_msg_count NUMBER;
899: l_msg_data VARCHAR2(2000);
900: l_sorted_res_tbl jtf_assign_pub.assignresources_tbl_type;

Line 900: l_sorted_res_tbl jtf_assign_pub.assignresources_tbl_type;

896: RETURN jtf_assign_pub.assignresources_tbl_type IS
897: l_return_status VARCHAR2(1);
898: l_msg_count NUMBER;
899: l_msg_data VARCHAR2(2000);
900: l_sorted_res_tbl jtf_assign_pub.assignresources_tbl_type;
901: l_res_dist_tbl csf_resource_tbl;
902: i PLS_INTEGER;
903: j PLS_INTEGER;
904: l_pref_res_cnt PLS_INTEGER;

Line 1022: p_res_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type

1018: * @param p_end End of the Window for Valid Shifts Consideration
1019: * @returns Top N Resources as determined by the MAXNRSELECTEDRES profile.
1020: */
1021: FUNCTION reduce_resource_list(
1022: p_res_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type
1023: , p_start DATE
1024: , p_end DATE
1025: )
1026: RETURN jtf_assign_pub.assignresources_tbl_type IS

Line 1026: RETURN jtf_assign_pub.assignresources_tbl_type IS

1022: p_res_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type
1023: , p_start DATE
1024: , p_end DATE
1025: )
1026: RETURN jtf_assign_pub.assignresources_tbl_type IS
1027: l_max_resources NUMBER;
1028: l_return_status VARCHAR2(1);
1029: l_msg_count NUMBER;
1030: l_msg_data VARCHAR2(2000);

Line 1032: l_out_tbl jtf_assign_pub.assignresources_tbl_type;

1028: l_return_status VARCHAR2(1);
1029: l_msg_count NUMBER;
1030: l_msg_data VARCHAR2(2000);
1031: l_shift_tbl jtf_calendar_pub.shift_tbl_type;
1032: l_out_tbl jtf_assign_pub.assignresources_tbl_type;
1033: i PLS_INTEGER;
1034: j PLS_INTEGER;
1035: cnt PLS_INTEGER;
1036: BEGIN

Line 1116: p_res_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type

1112: * @param p_suggested_res_id_tbl Suggested Resource ID Table
1113: * @param p_suggested_res_type_tbl Suggested Resource Type Table
1114: */
1115: PROCEDURE add_suggested_resources(
1116: p_res_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type
1117: , p_suggested_res_id_tbl IN jtf_number_table
1118: , p_suggested_res_type_tbl IN jtf_varchar2_table_100
1119: , p_start_date IN DATE
1120: , p_end_date IN DATE

Line 1271: , x_res_tbl OUT NOCOPY jtf_assign_pub.assignresources_tbl_type

1267: , p_calendar_flag IN VARCHAR2
1268: , p_sort_flag IN VARCHAR2
1269: , p_suggested_res_id_tbl IN jtf_number_table
1270: , p_suggested_res_type_tbl IN jtf_varchar2_table_100
1271: , x_res_tbl OUT NOCOPY jtf_assign_pub.assignresources_tbl_type
1272: ) IS
1273: l_api_name CONSTANT VARCHAR2(30) := 'GET_RESOURCES_TO_SCHEDULE';
1274: l_api_version CONSTANT NUMBER := 1.0;
1275:

Line 1287: l_sr_task_rec jtf_assign_pub.jtf_srv_task_rec_type;

1283: l_has_suggested_res BOOLEAN;
1284: l_continue_search BOOLEAN;
1285: l_cont_ib_res_found BOOLEAN := TRUE;
1286: l_terr_res_found BOOLEAN := TRUE;
1287: l_sr_task_rec jtf_assign_pub.jtf_srv_task_rec_type;
1288:
1289: l_contracts_ib_res_tbl jtf_assign_pub.assignresources_tbl_type;
1290: l_territory_res_tbl jtf_assign_pub.assignresources_tbl_type;
1291: l_skilled_res_tbl jtf_assign_pub.assignresources_tbl_type;

Line 1289: l_contracts_ib_res_tbl jtf_assign_pub.assignresources_tbl_type;

1285: l_cont_ib_res_found BOOLEAN := TRUE;
1286: l_terr_res_found BOOLEAN := TRUE;
1287: l_sr_task_rec jtf_assign_pub.jtf_srv_task_rec_type;
1288:
1289: l_contracts_ib_res_tbl jtf_assign_pub.assignresources_tbl_type;
1290: l_territory_res_tbl jtf_assign_pub.assignresources_tbl_type;
1291: l_skilled_res_tbl jtf_assign_pub.assignresources_tbl_type;
1292: l_stic NUMBER;
1293:

Line 1290: l_territory_res_tbl jtf_assign_pub.assignresources_tbl_type;

1286: l_terr_res_found BOOLEAN := TRUE;
1287: l_sr_task_rec jtf_assign_pub.jtf_srv_task_rec_type;
1288:
1289: l_contracts_ib_res_tbl jtf_assign_pub.assignresources_tbl_type;
1290: l_territory_res_tbl jtf_assign_pub.assignresources_tbl_type;
1291: l_skilled_res_tbl jtf_assign_pub.assignresources_tbl_type;
1292: l_stic NUMBER;
1293:
1294: e_no_res EXCEPTION;

Line 1291: l_skilled_res_tbl jtf_assign_pub.assignresources_tbl_type;

1287: l_sr_task_rec jtf_assign_pub.jtf_srv_task_rec_type;
1288:
1289: l_contracts_ib_res_tbl jtf_assign_pub.assignresources_tbl_type;
1290: l_territory_res_tbl jtf_assign_pub.assignresources_tbl_type;
1291: l_skilled_res_tbl jtf_assign_pub.assignresources_tbl_type;
1292: l_stic NUMBER;
1293:
1294: e_no_res EXCEPTION;
1295:

Line 1484: jtf_assign_pub.get_assign_resources(

1480: IF l_ib_flag = 'Y' THEN
1481: l_stic := l_stic + 2;
1482: END IF;
1483:
1484: jtf_assign_pub.get_assign_resources(
1485: p_api_version => 1.0
1486: , p_init_msg_list => fnd_api.g_false
1487: , p_commit => fnd_api.g_false
1488: , x_return_status => x_return_status

Line 1544: jtf_assign_pub.get_assign_resources(

1540:
1541: l_stic := l_stic + 4;
1542:
1543:
1544: jtf_assign_pub.get_assign_resources(
1545: p_api_version => 1.0
1546: , p_init_msg_list => fnd_api.g_false
1547: , p_commit => fnd_api.g_false
1548: , x_return_status => x_return_status

Line 1768: l_assign_resource_tbl jtf_assign_pub.assignresources_tbl_type;

1764: ) IS
1765: l_api_name CONSTANT VARCHAR2(30) := 'GET_RESOURCES_TO_SCHEDULE(2)';
1766: l_api_version CONSTANT NUMBER := 1.0;
1767:
1768: l_assign_resource_tbl jtf_assign_pub.assignresources_tbl_type;
1769: j PLS_INTEGER;
1770: k PLS_INTEGER;
1771: BEGIN
1772: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 1831: IF l_assign_resource_tbl(j).terr_rank = jtf_assign_pub.am_miss_num THEN

1827: x_res_tbl(k).planwin_start := l_assign_resource_tbl(j).start_date;
1828: x_res_tbl(k).planwin_end := l_assign_resource_tbl(j).end_date;
1829: x_res_tbl(k).territory_id := l_assign_resource_tbl(j).terr_id;
1830:
1831: IF l_assign_resource_tbl(j).terr_rank = jtf_assign_pub.am_miss_num THEN
1832: x_res_tbl(k).territory_rank := NULL;
1833: ELSE
1834: x_res_tbl(k).territory_rank := l_assign_resource_tbl(j).terr_rank;
1835: END IF;

Line 1893: l_assign_resource_tbl jtf_assign_pub.assignresources_tbl_type;

1889: l_api_name CONSTANT VARCHAR2(30) := 'GET_RESOURCES_TO_SCHEDULE(3)';
1890: l_api_version CONSTANT NUMBER := 1.0;
1891:
1892: l_res_qualifiers resource_qualifier_tbl_type;
1893: l_assign_resource_tbl jtf_assign_pub.assignresources_tbl_type;
1894: j PLS_INTEGER;
1895: k PLS_INTEGER;
1896: --
1897: CURSOR c_task_info IS

Line 1987: IF l_assign_resource_tbl(j).terr_rank = jtf_assign_pub.am_miss_num THEN

1983: , l_assign_resource_tbl(j).start_date
1984: , l_assign_resource_tbl(j).end_date
1985: );
1986:
1987: IF l_assign_resource_tbl(j).terr_rank = jtf_assign_pub.am_miss_num THEN
1988: x_res_tbl(k).terr_rank := NULL;
1989: END IF;
1990:
1991: IF l_assign_resource_tbl(j).preference_type = 'I' THEN