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.PA_R_PROJECT_RESOURCES_PVT dependencies on JTF_CAL_RESOURCE_ASSIGN

Line 442: --For inserting into jtf_cal_resource_assign.

438: IS
439: l_insert VARCHAR2(1) := 'N';
440: l_end_date_insert VARCHAR2(1) := 'N'; -- Bug 4668272
441:
442: --For inserting into jtf_cal_resource_assign.
443: l_cal_resource_assign_id JTF_CAL_RESOURCE_ASSIGN.CAL_RESOURCE_ASSIGN_ID%TYPE;
444: l_msg_count NUMBER;
445: l_msg_data VARCHAR2(100);
446: --Used to check return status in jtf_cal_resource_assign_pkg.insert_row

Line 443: l_cal_resource_assign_id JTF_CAL_RESOURCE_ASSIGN.CAL_RESOURCE_ASSIGN_ID%TYPE;

439: l_insert VARCHAR2(1) := 'N';
440: l_end_date_insert VARCHAR2(1) := 'N'; -- Bug 4668272
441:
442: --For inserting into jtf_cal_resource_assign.
443: l_cal_resource_assign_id JTF_CAL_RESOURCE_ASSIGN.CAL_RESOURCE_ASSIGN_ID%TYPE;
444: l_msg_count NUMBER;
445: l_msg_data VARCHAR2(100);
446: --Used to check return status in jtf_cal_resource_assign_pkg.insert_row
447: l_error VARCHAR2(1):= 'N';

Line 446: --Used to check return status in jtf_cal_resource_assign_pkg.insert_row

442: --For inserting into jtf_cal_resource_assign.
443: l_cal_resource_assign_id JTF_CAL_RESOURCE_ASSIGN.CAL_RESOURCE_ASSIGN_ID%TYPE;
444: l_msg_count NUMBER;
445: l_msg_data VARCHAR2(100);
446: --Used to check return status in jtf_cal_resource_assign_pkg.insert_row
447: l_error VARCHAR2(1):= 'N';
448:
449: l_crm_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
450: l_resource_number JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE;

Line 452: l_resource_type_code JTF_CAL_RESOURCE_ASSIGN.RESOURCE_TYPE_CODE%TYPE;

448:
449: l_crm_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
450: l_resource_number JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE;
451:
452: l_resource_type_code JTF_CAL_RESOURCE_ASSIGN.RESOURCE_TYPE_CODE%TYPE;
453: l_category JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE := P_CATEGORY;
454: l_start_date JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE := P_START_DATE_ACTIVE;
455: l_person_id JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE := P_PERSON_ID;
456:

Line 470: -- For checking dates info in jtf_cal_resource_assign

466: l_latest_start_date DATE;
467: l_earliest_utl_start_date DATE;
468: l_calander_start_date DATE;
469:
470: -- For checking dates info in jtf_cal_resource_assign
471: l_min_start_date DATE;
472: l_max_end_date DATE; -- Bug 4668272
473: l_populate_jtf_res_cal VARCHAR2(1) := 'Y'; -- Bug 6411422
474:

Line 498: CURSOR c_dup_resource_assign_id (l_cal_resource_assign_id IN jtf_cal_resource_assign.cal_resource_assign_id%type)

494: from jtf_rs_resource_extns
495: where source_id = l_person_id
496: and category = l_category ;
497:
498: CURSOR c_dup_resource_assign_id (l_cal_resource_assign_id IN jtf_cal_resource_assign.cal_resource_assign_id%type)
499: IS
500: SELECT 'X'
501: FROM jtf_cal_resource_assign
502: WHERE cal_resource_assign_id = l_cal_resource_assign_id;

Line 501: FROM jtf_cal_resource_assign

497:
498: CURSOR c_dup_resource_assign_id (l_cal_resource_assign_id IN jtf_cal_resource_assign.cal_resource_assign_id%type)
499: IS
500: SELECT 'X'
501: FROM jtf_cal_resource_assign
502: WHERE cal_resource_assign_id = l_cal_resource_assign_id;
503:
504: CURSOR c_jtf_cal(l_cal_resource_assign_id in jtf_cal_resource_assign.cal_resource_assign_id%type)
505: IS

Line 504: CURSOR c_jtf_cal(l_cal_resource_assign_id in jtf_cal_resource_assign.cal_resource_assign_id%type)

500: SELECT 'X'
501: FROM jtf_cal_resource_assign
502: WHERE cal_resource_assign_id = l_cal_resource_assign_id;
503:
504: CURSOR c_jtf_cal(l_cal_resource_assign_id in jtf_cal_resource_assign.cal_resource_assign_id%type)
505: IS
506: SELECT rowid
507: FROM jtf_cal_resource_assign
508: WHERE cal_resource_assign_id = l_cal_resource_assign_id;

Line 507: FROM jtf_cal_resource_assign

503:
504: CURSOR c_jtf_cal(l_cal_resource_assign_id in jtf_cal_resource_assign.cal_resource_assign_id%type)
505: IS
506: SELECT rowid
507: FROM jtf_cal_resource_assign
508: WHERE cal_resource_assign_id = l_cal_resource_assign_id;
509:
510: CURSOR c_user_id(l_employee_id NUMBER)
511: IS

Line 519: from jtf_cal_resource_assign

515:
516: CURSOR cur_crm_cal(l_crm_resource_id in NUMBER)
517: IS
518: SELECT 'Y'
519: from jtf_cal_resource_assign
520: where resource_id = l_crm_resource_id
521: and resource_type_code = l_resource_type_code
522: and l_assignment_start_date between start_date_time and nvl(end_date_time, to_date('31/12/4712', 'DD/MM/YYYY'))
523: and primary_calendar_flag = 'Y';

Line 530: from jtf_cal_resource_assign

526: -- end date changing to be later than what it was.
527: CURSOR cur_crm_cal_end(l_crm_resource_id in NUMBER)
528: IS
529: SELECT 'Y'
530: from jtf_cal_resource_assign
531: where resource_id = l_crm_resource_id
532: and resource_type_code = l_resource_type_code
533: and l_assignment_end_date between start_date_time and nvl(end_date_time, to_date('31/12/4712', 'DD/MM/YYYY'))
534: and primary_calendar_flag = 'Y';

Line 539: from jtf_cal_resource_assign

535:
536: CURSOR cur_crm_check_date
537: IS
538: SELECT MIN(start_date_time)
539: from jtf_cal_resource_assign
540: where resource_id = l_crm_resource_id
541: and resource_type_code = l_resource_type_code
542: and primary_calendar_flag = 'Y'
543: and start_date_time between l_assignment_start_date and l_assignment_end_date;

Line 559: from jtf_cal_resource_assign

555: -- changed to be later than it was we don't do anything.
556:
557: CURSOR cur_crm_chk_end_date IS
558: SELECT MAX(end_date_time)
559: from jtf_cal_resource_assign
560: where resource_id = l_crm_resource_id
561: and resource_type_code = l_resource_type_code
562: and primary_calendar_flag = 'Y';
563: -- and end_date_time between l_assignment_start_date

Line 875: -- Will need to do insert into jtf_cal_resource_assign.

871:
872: -----------------------------------------------------------------------------
873: -- When the value of l_min_start_date is NULL, this means that no calendar
874: -- exist for this resource during the assignment time period.
875: -- Will need to do insert into jtf_cal_resource_assign.
876: -- This resource is a new crm resource.
877: -----------------------------------------------------------------------------
878: log_message('L_CAL_EXIST is null: ' || to_char(l_crm_resource_id));
879: log_message('Set insert = Y');

Line 967: --Insert calendar details into jtf_cal_resource_assign

963: ---------------------------------------------------
964: x_crm_resource_id := l_crm_resource_id;
965:
966: ---------------------------------------------------------
967: --Insert calendar details into jtf_cal_resource_assign
968: --For a totally new crm resource or to insert a partial
969: --period if start date changes to an earlier start date
970: --for an existing resource
971: ---------------------------------------------------------

Line 977: log_message('Begin of insert into jtf_cal_resource_assign');

973: -- Bug 4668272
974: -- hr_utility.trace('l_end_date_insert IS : ' || l_end_date_insert);
975: IF (l_insert = 'Y') OR (l_end_date_insert = 'Y') THEN
976:
977: log_message('Begin of insert into jtf_cal_resource_assign');
978: log_message('l_assignment_start ' || to_char(l_assignment_start_date, 'DD-MON-RR'));
979: log_message('l_assignment_end ' || to_char(l_assignment_end_date, 'DD-MON-RR'));
980:
981: --Unique cal_resource_assign_id from sequence

Line 983: select jtf_cal_resource_assign_s.nextval

979: log_message('l_assignment_end ' || to_char(l_assignment_end_date, 'DD-MON-RR'));
980:
981: --Unique cal_resource_assign_id from sequence
982: LOOP
983: select jtf_cal_resource_assign_s.nextval
984: into l_cal_resource_assign_id
985: from dual;
986: OPEN c_dup_resource_assign_id(l_cal_resource_assign_id);
987: FETCH c_dup_resource_assign_id INTO l_check_dup_id;

Line 999: pa_debug.g_err_stage := 'Log: User CRM API to Insert calendar into jtf_cal_resource_assign from '|| to_char(l_assignment_start_date,'DD-MON-RR')||' to '|| to_char(l_assignment_end_date,'DD-MON-RR');

995: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
996: END IF;
997: log_message('Selected unique cal_resource_assign_id');
998:
999: pa_debug.g_err_stage := 'Log: User CRM API to Insert calendar into jtf_cal_resource_assign from '|| to_char(l_assignment_start_date,'DD-MON-RR')||' to '|| to_char(l_assignment_end_date,'DD-MON-RR');
1000: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1001: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1002: END IF;
1003: log_message('Insert calendar into jtf_cal_resource_assign');

Line 1003: log_message('Insert calendar into jtf_cal_resource_assign');

999: pa_debug.g_err_stage := 'Log: User CRM API to Insert calendar into jtf_cal_resource_assign from '|| to_char(l_assignment_start_date,'DD-MON-RR')||' to '|| to_char(l_assignment_end_date,'DD-MON-RR');
1000: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1001: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1002: END IF;
1003: log_message('Insert calendar into jtf_cal_resource_assign');
1004:
1005: --Added code to use CRM Table Handler API instead of direct insert
1006:
1007: IF( l_assignment_start_date > P_ASSIGNMENT_END_DATE ) THEN -- Bug 6411422: IF condition added

Line 1012: jtf_cal_resource_assign_pkg.insert_row(

1008: l_populate_jtf_res_cal := 'N';
1009: END IF ;
1010: IF( l_populate_jtf_res_cal = 'Y' ) THEN -- Bug 6411422: IF condition added
1011:
1012: jtf_cal_resource_assign_pkg.insert_row(
1013: X_ERROR => l_error,
1014: X_ROWID => l_rowid,
1015: X_CAL_RESOURCE_ASSIGN_ID => l_cal_resource_assign_id,
1016: X_OBJECT_VERSION_NUMBER => 1,

Line 1093: pa_debug.g_err_stage := 'Log: After insert into jtf_cal_resource_assign';

1089: x_return_status := FND_API.G_RET_STS_ERROR;
1090: RAISE FND_API.G_EXC_ERROR;
1091: END IF;
1092:
1093: pa_debug.g_err_stage := 'Log: After insert into jtf_cal_resource_assign';
1094: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1095: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1096: END IF;
1097:

Line 1098: log_message('End of insert into jtf_cal_resource_assign');

1094: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1095: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1096: END IF;
1097:
1098: log_message('End of insert into jtf_cal_resource_assign');
1099:
1100: END IF;
1101: END IF; -- Bug 6411422
1102: