151: v_creation_date pn_space_assign_loc_itf.creation_date%TYPE;
152: v_created_by pn_space_assign_loc_itf.created_by%TYPE;
153:
154: --declare the record type for the function here.........
155: v_emp_data pnp_util_func.emp_hr_data_rec := NULL;
156: v_code_data pnp_util_func.location_name_rec := NULL;
157: v_compare_emp BOOLEAN;
158: v_compare_cust BOOLEAN;
159: l_date DATE := fnd_date.canonical_to_date('4712/12/31 00:00:00' );
152: v_created_by pn_space_assign_loc_itf.created_by%TYPE;
153:
154: --declare the record type for the function here.........
155: v_emp_data pnp_util_func.emp_hr_data_rec := NULL;
156: v_code_data pnp_util_func.location_name_rec := NULL;
157: v_compare_emp BOOLEAN;
158: v_compare_cust BOOLEAN;
159: l_date DATE := fnd_date.canonical_to_date('4712/12/31 00:00:00' );
160: v_coa_id NUMBER; --VARCHAR2(30);
158: v_compare_cust BOOLEAN;
159: l_date DATE := fnd_date.canonical_to_date('4712/12/31 00:00:00' );
160: v_coa_id NUMBER; --VARCHAR2(30);
161: v_loc_type VARCHAR2(100) ; --BUG#2226865
162: v_loc_area pnp_util_func.pn_location_area_rec; --bug#2226865
163: v_space_area pnp_util_func.pn_space_area_rec; --bug#2226865
164:
165: l_cursor INTEGER;
166: l_rows INTEGER;
159: l_date DATE := fnd_date.canonical_to_date('4712/12/31 00:00:00' );
160: v_coa_id NUMBER; --VARCHAR2(30);
161: v_loc_type VARCHAR2(100) ; --BUG#2226865
162: v_loc_area pnp_util_func.pn_location_area_rec; --bug#2226865
163: v_space_area pnp_util_func.pn_space_area_rec; --bug#2226865
164:
165: l_cursor INTEGER;
166: l_rows INTEGER;
167: l_count INTEGER;
431: EXIT WHEN emp_pn%NOTFOUND;
432: v_compare_emp:=compare_assign_emploc(v_location_id, v_person_id, v_cost_center, l_request_id);
433: IF NOT(v_compare_emp) THEN
434:
435: v_code_data:=pnp_util_func.get_location_name(v_location_id, as_of_date);
436: v_emp_data:= pnp_util_func.get_emp_hr_data(v_person_id);
437: --dbms_output.put_line('fet'||sqlerrm);
438: --------------bug#2226865-----------------
439: IF V_LOC_TYPE in ('BUILDING' ,'LAND','FLOOR','PARCEL') THEN
432: v_compare_emp:=compare_assign_emploc(v_location_id, v_person_id, v_cost_center, l_request_id);
433: IF NOT(v_compare_emp) THEN
434:
435: v_code_data:=pnp_util_func.get_location_name(v_location_id, as_of_date);
436: v_emp_data:= pnp_util_func.get_emp_hr_data(v_person_id);
437: --dbms_output.put_line('fet'||sqlerrm);
438: --------------bug#2226865-----------------
439: IF V_LOC_TYPE in ('BUILDING' ,'LAND','FLOOR','PARCEL') THEN
440: PNP_UTIL_FUNC.get_area(v_location_id , v_loc_type ,NULL,as_of_date,v_loc_area,v_space_area);
436: v_emp_data:= pnp_util_func.get_emp_hr_data(v_person_id);
437: --dbms_output.put_line('fet'||sqlerrm);
438: --------------bug#2226865-----------------
439: IF V_LOC_TYPE in ('BUILDING' ,'LAND','FLOOR','PARCEL') THEN
440: PNP_UTIL_FUNC.get_area(v_location_id , v_loc_type ,NULL,as_of_date,v_loc_area,v_space_area);
441: END IF;
442: -----------bug#2226865--------
443:
444:
773: EXIT WHEN cust_pn%NOTFOUND;
774: v_compare_cust:= compare_assign_custloc(v_location_id, v_customer_account, l_request_id);
775: IF NOT (v_compare_cust) THEN
776:
777: v_code_data:=pnp_util_func.get_location_name(v_location_id, as_of_date);
778: v_emp_data:= pnp_util_func.get_emp_hr_data(v_person_id);
779: --dbms_output.put_line('fet'||sqlerrm);
780: --------------bug#2226865-----------------
781: IF V_LOC_TYPE in ('BUILDING' ,'LAND','FLOOR','PARCEL') THEN
774: v_compare_cust:= compare_assign_custloc(v_location_id, v_customer_account, l_request_id);
775: IF NOT (v_compare_cust) THEN
776:
777: v_code_data:=pnp_util_func.get_location_name(v_location_id, as_of_date);
778: v_emp_data:= pnp_util_func.get_emp_hr_data(v_person_id);
779: --dbms_output.put_line('fet'||sqlerrm);
780: --------------bug#2226865-----------------
781: IF V_LOC_TYPE in ('BUILDING' ,'LAND','FLOOR','PARCEL') THEN
782: PNP_UTIL_FUNC.get_area(v_location_id , v_loc_type ,NULL,as_of_date,v_loc_area,v_space_area);
778: v_emp_data:= pnp_util_func.get_emp_hr_data(v_person_id);
779: --dbms_output.put_line('fet'||sqlerrm);
780: --------------bug#2226865-----------------
781: IF V_LOC_TYPE in ('BUILDING' ,'LAND','FLOOR','PARCEL') THEN
782: PNP_UTIL_FUNC.get_area(v_location_id , v_loc_type ,NULL,as_of_date,v_loc_area,v_space_area);
783: END IF;
784: -----------bug#2226865--------
785:
786: