[Home] [Help]
402:
403: /*Procedure : CRM Insert
404: This procedure checks if the resource exists in CRM and inserts the resource into CRM by calling the CRM public API jtf_rs_resource.create_resource if it does not exist.
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,
2099: --MOAC Changes bug 4363092 - removed nvl used with org_id
2100: CURSOR get_max_asgmt_end_date IS
2101: select max(assignment_end_date)
2102: from pa_r_project_resources_ind_v res
2103: , hr_organization_information org_info
2104: , pa_all_organizations org
2105: where res.person_id = l_person_id
2106: and res.organization_id = org_info.organization_id
2107: and org_info.org_information_context = 'Exp Organization Defaults'
2882: l_sel_clause := ' SELECT DISTINCT a.person_id ';
2883: l_from_clause := ' FROM per_all_assignments_f a';
2884: l_where_clause := ' WHERE a.organization_id IN ( '||
2885: ' SELECT hrorg.organization_id '||
2886: ' FROM hr_all_organization_units_tl hrorg, hr_organization_information orginfo '||
2887: ' WHERE hrorg.language = userenv(''LANG'') '||
2888: ' AND orginfo.organization_id = hrorg.organization_id '||
2889: ' AND orginfo.ORG_INFORMATION_CONTEXT = ''CLASS'' '||
2890: ' AND orginfo.ORG_INFORMATION1 = ''PA_EXPENDITURE_ORG'' '||