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.PNRX_SP_ASSIGN_BY_LOC dependencies on PNP_UTIL_FUNC

Line 155: v_emp_data pnp_util_func.emp_hr_data_rec := NULL;

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

Line 156: v_code_data pnp_util_func.location_name_rec := NULL;

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

Line 162: v_loc_area pnp_util_func.pn_location_area_rec; --bug#2226865

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;

Line 163: v_space_area pnp_util_func.pn_space_area_rec; --bug#2226865

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;

Line 435: v_code_data:=pnp_util_func.get_location_name(v_location_id, as_of_date);

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

Line 436: v_emp_data:= pnp_util_func.get_emp_hr_data(v_person_id);

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

Line 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:

Line 777: v_code_data:=pnp_util_func.get_location_name(v_location_id, as_of_date);

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

Line 778: v_emp_data:= pnp_util_func.get_emp_hr_data(v_person_id);

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

Line 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: