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_LEASE dependencies on PNP_UTIL_FUNC

Line 151: v_emp_data PNP_UTIL_FUNC.emp_hr_data_rec := NULL;

147: V_LAST_UPDATE_LOGIN pn_space_assign_lease_itf.LAST_UPDATE_LOGIN%TYPE;
148: V_CREATION_DATE pn_space_assign_lease_itf.CREATION_DATE%TYPE;
149: V_CREATED_BY pn_space_assign_lease_itf.CREATED_BY%TYPE;
150: --declare the record type for the function here.........
151: v_emp_data PNP_UTIL_FUNC.emp_hr_data_rec := NULL;
152: v_code_data PNP_UTIL_FUNC.location_name_rec := NULL;
153: l_date DATE:=fnd_date.canonical_to_date(
154: '4712/12/31 00:00:00' );
155: v_compare_emp BOOLEAN;

Line 152: v_code_data PNP_UTIL_FUNC.location_name_rec := NULL;

148: V_CREATION_DATE pn_space_assign_lease_itf.CREATION_DATE%TYPE;
149: V_CREATED_BY pn_space_assign_lease_itf.CREATED_BY%TYPE;
150: --declare the record type for the function here.........
151: v_emp_data PNP_UTIL_FUNC.emp_hr_data_rec := NULL;
152: v_code_data PNP_UTIL_FUNC.location_name_rec := NULL;
153: l_date DATE:=fnd_date.canonical_to_date(
154: '4712/12/31 00:00:00' );
155: v_compare_emp BOOLEAN;
156: v_compare_cust BOOLEAN;

Line 159: v_loc_area PNP_UTIL_FUNC.PN_LOCATION_AREA_REC; --bug#2226865

155: v_compare_emp BOOLEAN;
156: v_compare_cust BOOLEAN;
157: v_coa_id NUMBER;
158: v_loc_type VARCHAR2(100) ; --BUG#2226865
159: v_loc_area PNP_UTIL_FUNC.PN_LOCATION_AREA_REC; --bug#2226865
160: v_space_area PNP_UTIL_FUNC.PN_SPACE_AREA_REC; --bug#2226865
161: l_count_1 NUMBER := 0;
162: l_count_2 NUMBER := 0;
163: l_count_3 NUMBER := 0;

Line 160: v_space_area PNP_UTIL_FUNC.PN_SPACE_AREA_REC; --bug#2226865

156: v_compare_cust BOOLEAN;
157: v_coa_id NUMBER;
158: v_loc_type VARCHAR2(100) ; --BUG#2226865
159: v_loc_area PNP_UTIL_FUNC.PN_LOCATION_AREA_REC; --bug#2226865
160: v_space_area PNP_UTIL_FUNC.PN_SPACE_AREA_REC; --bug#2226865
161: l_count_1 NUMBER := 0;
162: l_count_2 NUMBER := 0;
163: l_count_3 NUMBER := 0;
164:

Line 404: v_code_data:=pnp_util_func.get_location_name(V_LOCATION_ID, AS_OF_DATE);

400: EXIT WHEN emp_pn%notfound;
401: v_compare_emp:=compare_assign_emplease(V_LOCATION_ID, V_PERSON_ID, V_COST_CENTER, l_request_id);
402: IF NOT(v_compare_emp) THEN
403:
404: v_code_data:=pnp_util_func.get_location_name(V_LOCATION_ID, AS_OF_DATE);
405: v_emp_data:= pnp_util_func.get_emp_hr_data(V_PERSON_ID);
406: --------------bug#2226865-----------------
407: IF V_LOC_TYPE in ('BUILDING' ,'LAND','FLOOR','PARCEL') THEN
408: PNP_UTIL_FUNC.get_area(v_location_id , v_loc_type ,NULL,AS_OF_DATE,V_LOC_AREA,V_SPACE_AREA);

Line 405: v_emp_data:= pnp_util_func.get_emp_hr_data(V_PERSON_ID);

401: v_compare_emp:=compare_assign_emplease(V_LOCATION_ID, V_PERSON_ID, V_COST_CENTER, l_request_id);
402: IF NOT(v_compare_emp) THEN
403:
404: v_code_data:=pnp_util_func.get_location_name(V_LOCATION_ID, AS_OF_DATE);
405: v_emp_data:= pnp_util_func.get_emp_hr_data(V_PERSON_ID);
406: --------------bug#2226865-----------------
407: IF V_LOC_TYPE in ('BUILDING' ,'LAND','FLOOR','PARCEL') THEN
408: PNP_UTIL_FUNC.get_area(v_location_id , v_loc_type ,NULL,AS_OF_DATE,V_LOC_AREA,V_SPACE_AREA);
409: END IF;

Line 408: PNP_UTIL_FUNC.get_area(v_location_id , v_loc_type ,NULL,AS_OF_DATE,V_LOC_AREA,V_SPACE_AREA);

404: v_code_data:=pnp_util_func.get_location_name(V_LOCATION_ID, AS_OF_DATE);
405: v_emp_data:= pnp_util_func.get_emp_hr_data(V_PERSON_ID);
406: --------------bug#2226865-----------------
407: IF V_LOC_TYPE in ('BUILDING' ,'LAND','FLOOR','PARCEL') THEN
408: PNP_UTIL_FUNC.get_area(v_location_id , v_loc_type ,NULL,AS_OF_DATE,V_LOC_AREA,V_SPACE_AREA);
409: END IF;
410: -----------bug#2226865--------
411: INSERT INTO pn_space_assign_lease_itf
412: (LEASE_ID ,

Line 792: v_code_data:=pnp_util_func.get_location_name(V_LOCATION_ID, AS_OF_DATE);

788: EXIT WHEN cust_pn%notfound;
789: v_compare_cust:=compare_assign_custlease(V_LOCATION_ID, V_CUSTOMER_ACCOUNT, l_request_id);
790: IF NOT(v_compare_cust) THEN
791:
792: v_code_data:=pnp_util_func.get_location_name(V_LOCATION_ID, AS_OF_DATE);
793: v_emp_data:= pnp_util_func.get_emp_hr_data(V_PERSON_ID);
794: --------------bug#2226865-----------------
795: IF V_LOC_TYPE in ('BUILDING' ,'LAND','FLOOR','PARCEL') THEN
796: PNP_UTIL_FUNC.get_area(v_location_id , v_loc_type ,NULL,AS_OF_DATE,V_LOC_AREA,V_SPACE_AREA);

Line 793: v_emp_data:= pnp_util_func.get_emp_hr_data(V_PERSON_ID);

789: v_compare_cust:=compare_assign_custlease(V_LOCATION_ID, V_CUSTOMER_ACCOUNT, l_request_id);
790: IF NOT(v_compare_cust) THEN
791:
792: v_code_data:=pnp_util_func.get_location_name(V_LOCATION_ID, AS_OF_DATE);
793: v_emp_data:= pnp_util_func.get_emp_hr_data(V_PERSON_ID);
794: --------------bug#2226865-----------------
795: IF V_LOC_TYPE in ('BUILDING' ,'LAND','FLOOR','PARCEL') THEN
796: PNP_UTIL_FUNC.get_area(v_location_id , v_loc_type ,NULL,AS_OF_DATE,V_LOC_AREA,V_SPACE_AREA);
797: END IF;

Line 796: PNP_UTIL_FUNC.get_area(v_location_id , v_loc_type ,NULL,AS_OF_DATE,V_LOC_AREA,V_SPACE_AREA);

792: v_code_data:=pnp_util_func.get_location_name(V_LOCATION_ID, AS_OF_DATE);
793: v_emp_data:= pnp_util_func.get_emp_hr_data(V_PERSON_ID);
794: --------------bug#2226865-----------------
795: IF V_LOC_TYPE in ('BUILDING' ,'LAND','FLOOR','PARCEL') THEN
796: PNP_UTIL_FUNC.get_area(v_location_id , v_loc_type ,NULL,AS_OF_DATE,V_LOC_AREA,V_SPACE_AREA);
797: END IF;
798: -----------bug#2226865--------
799: INSERT INTO pn_space_assign_lease_itf
800: (LEASE_ID ,