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_RS_RESOURCE_EXTNS

Line 409: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,

405: It also inserts the calendar for the resource in CRM. If the resource exists the procedure checks to see if the calendar in CRM has been end dated and if so inserts the new calendar.
406: The procedure also checks for internal resources having multiple assignments who might have a different calendar for each assignment. If calendar is not present in hr_organization_information the calendar_id is got from profile option.*/
407:
408: PROCEDURE INSERT_INTO_CRM(
409: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
410: P_PERSON_ID IN JTF_RS_RESOURCE_extns.SOURCE_id%TYPE,
411: P_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
412: P_START_DATE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
413: P_ASSIGNMENT_START_DATE IN DATE,

Line 410: P_PERSON_ID IN JTF_RS_RESOURCE_extns.SOURCE_id%TYPE,

406: The procedure also checks for internal resources having multiple assignments who might have a different calendar for each assignment. If calendar is not present in hr_organization_information the calendar_id is got from profile option.*/
407:
408: PROCEDURE INSERT_INTO_CRM(
409: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
410: P_PERSON_ID IN JTF_RS_RESOURCE_extns.SOURCE_id%TYPE,
411: P_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
412: P_START_DATE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
413: P_ASSIGNMENT_START_DATE IN DATE,
414: P_ASSIGNMENT_END_DATE IN DATE,

Line 411: P_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,

407:
408: PROCEDURE INSERT_INTO_CRM(
409: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
410: P_PERSON_ID IN JTF_RS_RESOURCE_extns.SOURCE_id%TYPE,
411: P_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
412: P_START_DATE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
413: P_ASSIGNMENT_START_DATE IN DATE,
414: P_ASSIGNMENT_END_DATE IN DATE,
415: P_CALENDAR_ID IN NUMBER,

Line 412: P_START_DATE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,

408: PROCEDURE INSERT_INTO_CRM(
409: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
410: P_PERSON_ID IN JTF_RS_RESOURCE_extns.SOURCE_id%TYPE,
411: P_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
412: P_START_DATE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
413: P_ASSIGNMENT_START_DATE IN DATE,
414: P_ASSIGNMENT_END_DATE IN DATE,
415: P_CALENDAR_ID IN NUMBER,
416: P_COUNT IN NUMBER,

Line 417: X_CRM_RESOURCE_ID OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE , --File.Sql.39 bug 4440895

413: P_ASSIGNMENT_START_DATE IN DATE,
414: P_ASSIGNMENT_END_DATE IN DATE,
415: P_CALENDAR_ID IN NUMBER,
416: P_COUNT IN NUMBER,
417: X_CRM_RESOURCE_ID OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE , --File.Sql.39 bug 4440895
418: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
419: P_START_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_start_date%TYPE,
420: P_END_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_end_date%TYPE,
421: P_SOURCE_NUMBER IN pa_r_project_resources_ind_v.per_emp_number%TYPE,

Line 449: l_crm_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;

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;
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;

Line 450: l_resource_number JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE;

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;
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;

Line 453: l_category JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE := P_CATEGORY;

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:
457: l_check_dup_id varchar2(1);

Line 454: l_start_date JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE := P_START_DATE_ACTIVE;

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:
457: l_check_dup_id varchar2(1);
458: l_calendar_id NUMBER := TO_NUMBER(P_CALENDAR_ID);

Line 455: l_person_id JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE := P_PERSON_ID;

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:
457: l_check_dup_id varchar2(1);
458: l_calendar_id NUMBER := TO_NUMBER(P_CALENDAR_ID);
459:

Line 490: CURSOR CUR_CRMID(l_person_id in jtf_rs_resource_extns.source_id%type,

486: AND TRUNC(SYSDATE) BETWEEN ASGN.EFFECTIVE_START_DATE AND ASGN.EFFECTIVE_END_DATE
487: AND (PER.EMPLOYEE_NUMBER IS NOT NULL OR PER.NPW_NUMBER IS NOT NULL)
488: AND PER.PERSON_ID = p_person_id;
489:
490: CURSOR CUR_CRMID(l_person_id in jtf_rs_resource_extns.source_id%type,
491: l_category in jtf_rs_resource_extns.category%type)
492: IS
493: select resource_id
494: from jtf_rs_resource_extns

Line 491: l_category in jtf_rs_resource_extns.category%type)

487: AND (PER.EMPLOYEE_NUMBER IS NOT NULL OR PER.NPW_NUMBER IS NOT NULL)
488: AND PER.PERSON_ID = p_person_id;
489:
490: CURSOR CUR_CRMID(l_person_id in jtf_rs_resource_extns.source_id%type,
491: l_category in jtf_rs_resource_extns.category%type)
492: IS
493: select resource_id
494: from jtf_rs_resource_extns
495: where source_id = l_person_id

Line 494: from jtf_rs_resource_extns

490: CURSOR CUR_CRMID(l_person_id in jtf_rs_resource_extns.source_id%type,
491: l_category in jtf_rs_resource_extns.category%type)
492: IS
493: select resource_id
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)

Line 1419: P_RESOURCE_TYPE IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,

1415: P_SYSTEM_TYPE IN PER_PERSON_TYPES.SYSTEM_PERSON_TYPE%TYPE,
1416: P_USER_TYPE IN PER_PERSON_TYPES.USER_PERSON_TYPE%TYPE,
1417: P_RES_EXISTS IN VARCHAR2,
1418: P_COUNT IN NUMBER,
1419: P_RESOURCE_TYPE IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
1420: X_RESOURCE_ID OUT NOCOPY PA_RESOURCES.RESOURCE_ID%TYPE, --File.Sql.39 bug 4440895
1421: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1422: P_START_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_start_date%TYPE,
1423: P_END_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_end_date%TYPE,

Line 1454: x_crm_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;

1450: l_check VARCHAR2(1) := 'N';
1451: l_jtf_id NUMBER := null;
1452: l_cal_id NUMBER := TO_NUMBER(P_CALENDAR_ID);
1453:
1454: x_crm_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
1455: x_error_message_code varchar2(1000);
1456:
1457: l_valid VARCHAR2(1);
1458: l_code VARCHAR2(100);

Line 1946: P_RESOURCE_TYPE IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,

1942: P_PERSON_ID IN PA_RESOURCE_TXN_ATTRIBUTES.PERSON_ID%TYPE,
1943: P_INDIVIDUAL IN VARCHAR2,
1944: P_CHECK_RESOURCE IN VARCHAR2,
1945: P_SCHEDULED_MEMBER_FLAG IN VARCHAR2,
1946: P_RESOURCE_TYPE IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
1947: P_PARTY_ID IN PA_RESOURCE_TXN_ATTRIBUTES.PARTY_ID%TYPE,
1948: P_FROM_EMP_NUM IN VARCHAR2,
1949: P_TO_EMP_NUM IN VARCHAR2,
1950: P_ORGANIZATION_ID IN NUMBER,

Line 1970: l_resource_type JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE := P_RESOURCE_TYPE;

1966: L_API_NAME CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE';
1967: -- If no date specified, default to previous year.
1968: l_term_range_date DATE := trunc(nvl(p_term_range_date, ADD_MONTHS(trunc(sysdate), -12)));
1969:
1970: l_resource_type JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE := P_RESOURCE_TYPE;
1971:
1972: x_resource_number NUMBER;
1973:
1974: l_name PA_RESOURCES.NAME%TYPE;

Line 2030: l_crm_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;

2026: l_end_date DATE;
2027: G_person_id NUMBER := 0;
2028: l_resource_type_id PA_RESOURCE_TYPES.RESOURCE_TYPE_ID%TYPE;
2029: -- l_org_type VARCHAR2(20); --Bug 4363092
2030: l_crm_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
2031: l_res_id PA_RESOURCES.RESOURCE_ID%TYPE;
2032: l_per_success VARCHAR2(1);
2033: l_asgmt_success VARCHAR2(1) := 'N';
2034:

Line 2061: CURSOR CUR_CRMID(l_person_id in jtf_rs_resource_extns.source_id%type,

2057:
2058: PERSON_ERROR_EXCEPTION EXCEPTION;
2059: TERM_DATE_EXCEPTION EXCEPTION;
2060:
2061: CURSOR CUR_CRMID(l_person_id in jtf_rs_resource_extns.source_id%type,
2062: l_resource_type in jtf_rs_resource_extns.category%type)
2063: IS
2064: select resource_id
2065: from jtf_rs_resource_extns

Line 2062: l_resource_type in jtf_rs_resource_extns.category%type)

2058: PERSON_ERROR_EXCEPTION EXCEPTION;
2059: TERM_DATE_EXCEPTION EXCEPTION;
2060:
2061: CURSOR CUR_CRMID(l_person_id in jtf_rs_resource_extns.source_id%type,
2062: l_resource_type in jtf_rs_resource_extns.category%type)
2063: IS
2064: select resource_id
2065: from jtf_rs_resource_extns
2066: where source_id = l_person_id

Line 2065: from jtf_rs_resource_extns

2061: CURSOR CUR_CRMID(l_person_id in jtf_rs_resource_extns.source_id%type,
2062: l_resource_type in jtf_rs_resource_extns.category%type)
2063: IS
2064: select resource_id
2065: from jtf_rs_resource_extns
2066: where source_id = l_person_id
2067: and category = l_resource_type;
2068:
2069: --MOAC Changes : Bug 4363092: Commenting this cursor as now As R12 will have multi org setup only