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 97: * @returns Task Record (JTF_ASSIGN_PUB.JTF_SRV_TASK_REC_TYPE).

93: * Gets the Task Information in the format as desired by JTF Assignment
94: * Manager API.
95: *
96: * @param p_task_id Task Identifier
97: * @returns Task Record (JTF_ASSIGN_PUB.JTF_SRV_TASK_REC_TYPE).
98: */
99: FUNCTION get_srv_task_rec(p_task_id IN NUMBER)
100: RETURN jtf_assign_pub.jtf_srv_task_rec_type IS
101: l_rec jtf_assign_pub.jtf_srv_task_rec_type;

Line 100: RETURN jtf_assign_pub.jtf_srv_task_rec_type IS

96: * @param p_task_id Task Identifier
97: * @returns Task Record (JTF_ASSIGN_PUB.JTF_SRV_TASK_REC_TYPE).
98: */
99: FUNCTION get_srv_task_rec(p_task_id IN NUMBER)
100: RETURN jtf_assign_pub.jtf_srv_task_rec_type IS
101: l_rec jtf_assign_pub.jtf_srv_task_rec_type;
102: l_contract_service_id NUMBER;
103:
104: -- Task, SR, Party and Address Information

Line 101: l_rec jtf_assign_pub.jtf_srv_task_rec_type;

97: * @returns Task Record (JTF_ASSIGN_PUB.JTF_SRV_TASK_REC_TYPE).
98: */
99: FUNCTION get_srv_task_rec(p_task_id IN NUMBER)
100: RETURN jtf_assign_pub.jtf_srv_task_rec_type IS
101: l_rec jtf_assign_pub.jtf_srv_task_rec_type;
102: l_contract_service_id NUMBER;
103:
104: -- Task, SR, Party and Address Information
105: CURSOR c_rec IS

Line 301: p_res_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type

297: RETURN l_value;
298: END get_display_value;
299:
300: PROCEDURE set_generic_planwindow (
301: p_res_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type
302: , p_start DATE
303: , p_end DATE
304: ) IS
305: i PLS_INTEGER;

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

316: * Adds the Qualifier identified by the Index to the global Task Qualifer Table with
317: * the value taken from the given Task Record and only when the value is Not Null.
318: *
319: * Uses a Hard Coded Mapping between JTF_SEEDED_QUAL_USGS_V.QUAL_USG_ID
320: * and the fields in JTF_ASSIGN_PUB.JTF_SRV_TASK_REC_TYPE.
321: *
322: * Qualifiers of type -1211, -1212 and -1218 have been disabled and
323: * therefore wont be set by this API.
324: *

Line 332: , p_task_rec IN jtf_assign_pub.jtf_srv_task_rec_type

328: */
329: PROCEDURE add_qualifier(
330: p_qualifier_tbl IN OUT NOCOPY resource_qualifier_tbl_type
331: , p_index IN PLS_INTEGER
332: , p_task_rec IN jtf_assign_pub.jtf_srv_task_rec_type
333: ) IS
334: l_value VARCHAR2(360);
335: l_associated_value VARCHAR2(360);
336: i PLS_INTEGER;

Line 419: l_task_rec jtf_assign_pub.jtf_srv_task_rec_type;

415: */
416: FUNCTION get_res_qualifier_table(p_task_id NUMBER)
417: RETURN resource_qualifier_tbl_type IS
418: m PLS_INTEGER;
419: l_task_rec jtf_assign_pub.jtf_srv_task_rec_type;
420: l_qualifier_tbl resource_qualifier_tbl_type;
421: BEGIN
422: -- Fetch all the Enabled Qualifiers
423: IF g_all_qualifiers.COUNT = 0 THEN

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

443: * Assembles the selected Qualifiers for this Task from the Qualifier
444: * Table in to a Record Type understandable by JTF Assignment Manager.
445: *
446: * Uses a Hard Coded Mapping between JTF_SEEDED_QUAL_USGS_V.QUAL_USG_ID
447: * and the fields in JTF_ASSIGN_PUB.JTF_SRV_TASK_REC_TYPE.
448: *
449: * The Task and SR Number must be set by the caller and wont be set by
450: * this API. Moreover Qualifiers of type -1211, -1212 and -1218 have
451: * been disabled and therefore wont be set by this API.

Line 456: RETURN jtf_assign_pub.jtf_srv_task_rec_type IS

452: *
453: * @param p_table Qualifier Table having the list of Task Qualifiers
454: */
455: FUNCTION get_qualified_task_rec(p_table resource_qualifier_tbl_type)
456: RETURN jtf_assign_pub.jtf_srv_task_rec_type IS
457: k PLS_INTEGER;
458: task_rec jtf_assign_pub.jtf_srv_task_rec_type;
459: BEGIN
460: k := p_table.FIRST;

Line 458: task_rec jtf_assign_pub.jtf_srv_task_rec_type;

454: */
455: FUNCTION get_qualified_task_rec(p_table resource_qualifier_tbl_type)
456: RETURN jtf_assign_pub.jtf_srv_task_rec_type IS
457: k PLS_INTEGER;
458: task_rec jtf_assign_pub.jtf_srv_task_rec_type;
459: BEGIN
460: k := p_table.FIRST;
461: WHILE k IS NOT NULL LOOP
462: IF p_table(k).use_flag = 'Y' THEN

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

544: * @param p_res_1_tbl Resource Table 1
545: * @param p_res_2_tbl Resource Table 2
546: * @param p_start Start Date of the Window
547: * @param p_end End Date of the Window
548: * @return Common Resource Table (JTF_ASSIGN_PUB.ASSIGNRESOURCES_TBL_TYPE)
549: */
550: FUNCTION intersect_results(
551: p_res_1_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type
552: , p_res_2_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type

Line 551: p_res_1_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type

547: * @param p_end End Date of the Window
548: * @return Common Resource Table (JTF_ASSIGN_PUB.ASSIGNRESOURCES_TBL_TYPE)
549: */
550: FUNCTION intersect_results(
551: p_res_1_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type
552: , p_res_2_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type
553: , p_start DATE
554: , p_end DATE
555: ) RETURN jtf_assign_pub.assignresources_tbl_type IS

Line 552: , p_res_2_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type

548: * @return Common Resource Table (JTF_ASSIGN_PUB.ASSIGNRESOURCES_TBL_TYPE)
549: */
550: FUNCTION intersect_results(
551: p_res_1_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type
552: , p_res_2_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type
553: , p_start DATE
554: , p_end DATE
555: ) RETURN jtf_assign_pub.assignresources_tbl_type IS
556: i PLS_INTEGER;

Line 555: ) RETURN jtf_assign_pub.assignresources_tbl_type IS

551: p_res_1_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type
552: , p_res_2_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type
553: , p_start DATE
554: , p_end DATE
555: ) RETURN jtf_assign_pub.assignresources_tbl_type IS
556: i PLS_INTEGER;
557: j PLS_INTEGER;
558: k PLS_INTEGER;
559: l_res_tbl jtf_assign_pub.assignresources_tbl_type;

Line 559: l_res_tbl jtf_assign_pub.assignresources_tbl_type;

555: ) RETURN jtf_assign_pub.assignresources_tbl_type IS
556: i PLS_INTEGER;
557: j PLS_INTEGER;
558: k PLS_INTEGER;
559: l_res_tbl jtf_assign_pub.assignresources_tbl_type;
560: BEGIN
561: k := 0;
562: i := p_res_1_tbl.FIRST;
563: WHILE i IS NOT NULL LOOP

Line 625: , x_skilled_res_tbl OUT NOCOPY jtf_assign_pub.assignresources_tbl_type

621: , p_start IN DATE
622: , p_end IN DATE
623: , p_resource_id IN NUMBER DEFAULT NULL
624: , p_resource_type IN VARCHAR2 DEFAULT NULL
625: , x_skilled_res_tbl OUT NOCOPY jtf_assign_pub.assignresources_tbl_type
626: ) IS
627: l_levelmatch CONSTANT NUMBER := NVL(fnd_profile.VALUE('CSF_SKILL_LEVEL_MATCH'), 2);
628: j PLS_INTEGER;
629:

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

721: * @param p_unsorted_res_tbl List of UnSorted Resources
722: * @param p_task_id Task ID of the Task to be performed
723: * @param p_start Start of the Window to get that Period's Address
724: * @param p_end End of the Window to get that Period's Address
725: * @returns Sorted Resources List (JTF_ASSIGN_PUB.ASSIGNRESOURCES_TBL_TYPE)
726: */
727: FUNCTION sort_resource_by_distance(
728: p_unsorted_res_tbl jtf_assign_pub.assignresources_tbl_type
729: , p_task_id NUMBER

Line 728: p_unsorted_res_tbl jtf_assign_pub.assignresources_tbl_type

724: * @param p_end End of the Window to get that Period's Address
725: * @returns Sorted Resources List (JTF_ASSIGN_PUB.ASSIGNRESOURCES_TBL_TYPE)
726: */
727: FUNCTION sort_resource_by_distance(
728: p_unsorted_res_tbl jtf_assign_pub.assignresources_tbl_type
729: , p_task_id NUMBER
730: , p_start DATE
731: , p_end DATE
732: )

Line 733: RETURN jtf_assign_pub.assignresources_tbl_type IS

729: , p_task_id NUMBER
730: , p_start DATE
731: , p_end DATE
732: )
733: RETURN jtf_assign_pub.assignresources_tbl_type IS
734: l_return_status VARCHAR2(1);
735: l_msg_count NUMBER;
736: l_msg_data VARCHAR2(2000);
737: l_sorted_res_tbl jtf_assign_pub.assignresources_tbl_type;

Line 737: l_sorted_res_tbl jtf_assign_pub.assignresources_tbl_type;

733: RETURN jtf_assign_pub.assignresources_tbl_type IS
734: l_return_status VARCHAR2(1);
735: l_msg_count NUMBER;
736: l_msg_data VARCHAR2(2000);
737: l_sorted_res_tbl jtf_assign_pub.assignresources_tbl_type;
738: l_res_dist_tbl csf_resource_tbl;
739: i PLS_INTEGER;
740: j PLS_INTEGER;
741: l_pref_res_cnt PLS_INTEGER;

Line 851: p_res_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type

847: * @param p_end End of the Window for Valid Shifts Consideration
848: * @returns Top N Resources as determined by the MAXNRSELECTEDRES profile.
849: */
850: FUNCTION reduce_resource_list(
851: p_res_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type
852: , p_start DATE
853: , p_end DATE
854: )
855: RETURN jtf_assign_pub.assignresources_tbl_type IS

Line 855: RETURN jtf_assign_pub.assignresources_tbl_type IS

851: p_res_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type
852: , p_start DATE
853: , p_end DATE
854: )
855: RETURN jtf_assign_pub.assignresources_tbl_type IS
856: l_max_resources NUMBER;
857: l_return_status VARCHAR2(1);
858: l_msg_count NUMBER;
859: l_msg_data VARCHAR2(2000);

Line 861: l_out_tbl jtf_assign_pub.assignresources_tbl_type;

857: l_return_status VARCHAR2(1);
858: l_msg_count NUMBER;
859: l_msg_data VARCHAR2(2000);
860: l_shift_tbl jtf_calendar_pub.shift_tbl_type;
861: l_out_tbl jtf_assign_pub.assignresources_tbl_type;
862: i PLS_INTEGER;
863: j PLS_INTEGER;
864: cnt PLS_INTEGER;
865: BEGIN

Line 938: p_res_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type

934: * @param p_suggested_res_id_tbl Suggested Resource ID Table
935: * @param p_suggested_res_type_tbl Suggested Resource Type Table
936: */
937: PROCEDURE add_suggested_resources(
938: p_res_tbl IN OUT NOCOPY jtf_assign_pub.assignresources_tbl_type
939: , p_suggested_res_id_tbl IN jtf_number_table
940: , p_suggested_res_type_tbl IN jtf_varchar2_table_100
941: , p_start_date IN DATE
942: , p_end_date IN DATE

Line 1093: , x_res_tbl OUT NOCOPY jtf_assign_pub.assignresources_tbl_type

1089: , p_calendar_flag IN VARCHAR2
1090: , p_sort_flag IN VARCHAR2
1091: , p_suggested_res_id_tbl IN jtf_number_table
1092: , p_suggested_res_type_tbl IN jtf_varchar2_table_100
1093: , x_res_tbl OUT NOCOPY jtf_assign_pub.assignresources_tbl_type
1094: ) IS
1095: l_api_name CONSTANT VARCHAR2(30) := 'GET_RESOURCES_TO_SCHEDULE';
1096: l_api_version CONSTANT NUMBER := 1.0;
1097:

Line 1106: l_sr_task_rec jtf_assign_pub.jtf_srv_task_rec_type;

1102: l_territory_flag VARCHAR2(1);
1103: l_skills_flag VARCHAR2(1);
1104: l_has_suggested_res BOOLEAN;
1105: l_continue_search BOOLEAN;
1106: l_sr_task_rec jtf_assign_pub.jtf_srv_task_rec_type;
1107:
1108: l_contracts_ib_res_tbl jtf_assign_pub.assignresources_tbl_type;
1109: l_territory_res_tbl jtf_assign_pub.assignresources_tbl_type;
1110: l_skilled_res_tbl jtf_assign_pub.assignresources_tbl_type;

Line 1108: l_contracts_ib_res_tbl jtf_assign_pub.assignresources_tbl_type;

1104: l_has_suggested_res BOOLEAN;
1105: l_continue_search BOOLEAN;
1106: l_sr_task_rec jtf_assign_pub.jtf_srv_task_rec_type;
1107:
1108: l_contracts_ib_res_tbl jtf_assign_pub.assignresources_tbl_type;
1109: l_territory_res_tbl jtf_assign_pub.assignresources_tbl_type;
1110: l_skilled_res_tbl jtf_assign_pub.assignresources_tbl_type;
1111: l_stic NUMBER;
1112:

Line 1109: l_territory_res_tbl jtf_assign_pub.assignresources_tbl_type;

1105: l_continue_search BOOLEAN;
1106: l_sr_task_rec jtf_assign_pub.jtf_srv_task_rec_type;
1107:
1108: l_contracts_ib_res_tbl jtf_assign_pub.assignresources_tbl_type;
1109: l_territory_res_tbl jtf_assign_pub.assignresources_tbl_type;
1110: l_skilled_res_tbl jtf_assign_pub.assignresources_tbl_type;
1111: l_stic NUMBER;
1112:
1113: e_no_res EXCEPTION;

Line 1110: l_skilled_res_tbl jtf_assign_pub.assignresources_tbl_type;

1106: l_sr_task_rec jtf_assign_pub.jtf_srv_task_rec_type;
1107:
1108: l_contracts_ib_res_tbl jtf_assign_pub.assignresources_tbl_type;
1109: l_territory_res_tbl jtf_assign_pub.assignresources_tbl_type;
1110: l_skilled_res_tbl jtf_assign_pub.assignresources_tbl_type;
1111: l_stic NUMBER;
1112:
1113: e_no_res EXCEPTION;
1114:

Line 1238: jtf_assign_pub.get_assign_resources(

1234: IF l_ib_flag = 'Y' THEN
1235: l_stic := l_stic + 2;
1236: END IF;
1237:
1238: jtf_assign_pub.get_assign_resources(
1239: p_api_version => 1.0
1240: , p_init_msg_list => fnd_api.g_false
1241: , p_commit => fnd_api.g_false
1242: , x_return_status => x_return_status

Line 1287: jtf_assign_pub.get_assign_resources(

1283: END IF;
1284:
1285: l_stic := l_stic + 4;
1286:
1287: jtf_assign_pub.get_assign_resources(
1288: p_api_version => 1.0
1289: , p_init_msg_list => fnd_api.g_false
1290: , p_commit => fnd_api.g_false
1291: , x_return_status => x_return_status

Line 1456: l_assign_resource_tbl jtf_assign_pub.assignresources_tbl_type;

1452: ) IS
1453: l_api_name CONSTANT VARCHAR2(30) := 'GET_RESOURCES_TO_SCHEDULE(2)';
1454: l_api_version CONSTANT NUMBER := 1.0;
1455:
1456: l_assign_resource_tbl jtf_assign_pub.assignresources_tbl_type;
1457: j PLS_INTEGER;
1458: k PLS_INTEGER;
1459: BEGIN
1460: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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

1510: x_res_tbl(k).resource_type := l_assign_resource_tbl(j).resource_type;
1511: x_res_tbl(k).planwin_start := l_assign_resource_tbl(j).start_date;
1512: x_res_tbl(k).planwin_end := l_assign_resource_tbl(j).end_date;
1513: x_res_tbl(k).territory_id := l_assign_resource_tbl(j).terr_id;
1514: IF l_assign_resource_tbl(j).terr_rank = jtf_assign_pub.am_miss_num THEN
1515: x_res_tbl(k).territory_rank := NULL;
1516: ELSE
1517: x_res_tbl(k).territory_rank := l_assign_resource_tbl(j).terr_rank;
1518: END IF;