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 PA_RESOURCE_TYPES

Line 1130: P_RESOURCE_TYPE_ID IN PA_RESOURCE_TYPES.RESOURCE_TYPE_ID%TYPE,

1126: pa_resource_txn_attributes table. This procedure calls the table
1127: handler package PA_RESOURCE_PKG.INSERT_ROW1 and PA_RESOURCE_PKG.INSERT_ROW2 . */
1128:
1129: PROCEDURE INSERT_INTO_PA(
1130: P_RESOURCE_TYPE_ID IN PA_RESOURCE_TYPES.RESOURCE_TYPE_ID%TYPE,
1131: P_CRM_RESOURCE_ID IN PA_RESOURCES.JTF_RESOURCE_ID%TYPE,
1132: X_RESOURCE_ID OUT NOCOPY PA_RESOURCES.RESOURCE_ID%TYPE, --File.Sql.39 bug 4440895
1133: P_START_DATE IN PA_RESOURCES.START_DATE_ACTIVE%TYPE,
1134: P_END_DATE IN PA_RESOURCES.END_DATE_ACTIVE%TYPE DEFAULT NULL,

Line 1442: l_resource_type_code PA_RESOURCE_TYPES.RESOURCE_TYPE_CODE%TYPE := 'EMPLOYEE';

1438: P_SOURCE_FIRST_NAME IN pa_r_project_resources_ind_v.per_first_name%TYPE,
1439: P_SOURCE_LAST_NAME IN pa_r_project_resources_ind_v.per_last_name%TYPE,
1440: P_SOURCE_MIDDLE_NAME IN pa_r_project_resources_ind_v.per_middle_name%TYPE)
1441: IS
1442: l_resource_type_code PA_RESOURCE_TYPES.RESOURCE_TYPE_CODE%TYPE := 'EMPLOYEE';
1443: l_resource_type_id PA_RESOURCE_TYPES.RESOURCE_TYPE_ID%TYPE;
1444:
1445: l_res_id pa_resource_txn_attributes.resource_id%type;
1446: l_org_id NUMBER;

Line 1443: l_resource_type_id PA_RESOURCE_TYPES.RESOURCE_TYPE_ID%TYPE;

1439: P_SOURCE_LAST_NAME IN pa_r_project_resources_ind_v.per_last_name%TYPE,
1440: P_SOURCE_MIDDLE_NAME IN pa_r_project_resources_ind_v.per_middle_name%TYPE)
1441: IS
1442: l_resource_type_code PA_RESOURCE_TYPES.RESOURCE_TYPE_CODE%TYPE := 'EMPLOYEE';
1443: l_resource_type_id PA_RESOURCE_TYPES.RESOURCE_TYPE_ID%TYPE;
1444:
1445: l_res_id pa_resource_txn_attributes.resource_id%type;
1446: l_org_id NUMBER;
1447: l_start DATE;

Line 1557: from pa_resource_types

1553: END IF;
1554: log_message('Get the resource_type_id from the resource_type_code');
1555:
1556: select resource_type_id into l_resource_type_id
1557: from pa_resource_types
1558: where resource_type_code = l_resource_type_code ;
1559:
1560: pa_debug.g_err_stage := 'Log: After getting the resource_type_id based on the resource_type_code';
1561: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

Line 1813: P_RESOURCE_TYPE IN PA_RESOURCE_TYPES.RESOURCE_TYPE_CODE%TYPE,

1809: of the external resource */
1810:
1811: PROCEDURE CREATE_EXTERNAL_RESOURCE(
1812: P_PARTY_ID IN PA_RESOURCE_TXN_ATTRIBUTES.PARTY_ID%TYPE,
1813: P_RESOURCE_TYPE IN PA_RESOURCE_TYPES.RESOURCE_TYPE_CODE%TYPE,
1814: X_RESOURCE_ID OUT NOCOPY PA_RESOURCES.RESOURCE_ID%TYPE, --File.Sql.39 bug 4440895
1815: X_RETURN_STATUS OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1816: IS
1817: l_resource_type_id PA_RESOURCE_TYPES.RESOURCE_TYPE_ID%TYPE;

Line 1817: l_resource_type_id PA_RESOURCE_TYPES.RESOURCE_TYPE_ID%TYPE;

1813: P_RESOURCE_TYPE IN PA_RESOURCE_TYPES.RESOURCE_TYPE_CODE%TYPE,
1814: X_RESOURCE_ID OUT NOCOPY PA_RESOURCES.RESOURCE_ID%TYPE, --File.Sql.39 bug 4440895
1815: X_RETURN_STATUS OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1816: IS
1817: l_resource_type_id PA_RESOURCE_TYPES.RESOURCE_TYPE_ID%TYPE;
1818: l_valid VARCHAR2(1) := 'N';
1819: l_res_exists VARCHAR2(20);
1820: l_party_id PA_RESOURCE_TXN_ATTRIBUTES.PARTY_ID%TYPE := P_PARTY_ID;
1821: l_res_id PA_RESOURCES.RESOURCE_ID%TYPE;

Line 1840: from pa_resource_types

1836: X_RETURN_STATUS := fnd_api.g_ret_sts_success;
1837:
1838: --to get the resource type id for code HZ_PARTY
1839: select resource_type_id into l_resource_type_id
1840: from pa_resource_types
1841: where resource_type_code = p_resource_type;
1842:
1843: --Call check_res_exists procedure
1844: pa_resource_utils.check_res_exists(

Line 2028: l_resource_type_id PA_RESOURCE_TYPES.RESOURCE_TYPE_ID%TYPE;

2024: l_postal_code HR_LOCATIONS.POSTAL_CODE%TYPE;
2025: l_country HR_LOCATIONS.COUNTRY%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);

Line 2258: from pa_resource_types

2254:
2255: log_message('**** p_scheduled_member_flag = N *****');
2256: --to get the resource type id for code EMPLOYEE: now only handles this resource type
2257: select resource_type_id into l_resource_type_id
2258: from pa_resource_types
2259: where resource_type_code = 'EMPLOYEE';
2260:
2261: open cur_crmid(l_person_id,l_resource_type);
2262: fetch cur_crmid into l_crm_resource_id;