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.PN_RECOVERY_EXTRACT_PKG dependencies on PN_LOCATIONS

Line 505: p_location_id pn_locations.location_id%TYPE,

501: -- 15-AUG-03 ftanudja o changed total asgnbl area calculation. 3099669.
502: ------------------------------------------------------------------------------+
503:
504: PROCEDURE insert_vacancy_data(
505: p_location_id pn_locations.location_id%TYPE,
506: p_property_id pn_locations.property_id%TYPE,
507: p_date_table date_table_type,
508: p_num_table number_table_type,
509: p_ref_date_table date_table_type,

Line 506: p_property_id pn_locations.property_id%TYPE,

502: ------------------------------------------------------------------------------+
503:
504: PROCEDURE insert_vacancy_data(
505: p_location_id pn_locations.location_id%TYPE,
506: p_property_id pn_locations.property_id%TYPE,
507: p_date_table date_table_type,
508: p_num_table number_table_type,
509: p_ref_date_table date_table_type,
510: p_ref_num_table number_table_type,

Line 944: p_location_id pn_locations.location_id%TYPE,

940: WHERE class.area_class_id = excl_dtl.area_class_id (+)
941: AND class.area_class_id = p_area_class_id;
942:
943: CURSOR get_location_info(
944: p_location_id pn_locations.location_id%TYPE,
945: p_property_id pn_locations.property_id%TYPE) IS
946: SELECT location_id,
947: property_id,
948: active_start_date,

Line 945: p_property_id pn_locations.property_id%TYPE) IS

941: AND class.area_class_id = p_area_class_id;
942:
943: CURSOR get_location_info(
944: p_location_id pn_locations.location_id%TYPE,
945: p_property_id pn_locations.property_id%TYPE) IS
946: SELECT location_id,
947: property_id,
948: active_start_date,
949: active_end_date,

Line 951: FROM pn_locations_all

947: property_id,
948: active_start_date,
949: active_end_date,
950: assignable_area
951: FROM pn_locations_all
952: WHERE location_type_lookup_code IN ('SECTION','OFFICE')
953: AND active_start_date < fnd_date.canonical_to_date(p_to_date)
954: AND active_end_date > fnd_date.canonical_to_date(p_from_date)
955: AND location_id IN

Line 956: (SELECT location_id FROM pn_locations_all

952: WHERE location_type_lookup_code IN ('SECTION','OFFICE')
953: AND active_start_date < fnd_date.canonical_to_date(p_to_date)
954: AND active_end_date > fnd_date.canonical_to_date(p_from_date)
955: AND location_id IN
956: (SELECT location_id FROM pn_locations_all
957: START WITH (location_id = p_location_id OR
958: (property_id = p_property_id AND p_location_id IS NULL))
959: CONNECT BY PRIOR location_id = parent_location_id)
960: ORDER BY location_id;

Line 962: CURSOR get_cust_assignment_info(p_location_id pn_locations.location_id%TYPE) IS

958: (property_id = p_property_id AND p_location_id IS NULL))
959: CONNECT BY PRIOR location_id = parent_location_id)
960: ORDER BY location_id;
961:
962: CURSOR get_cust_assignment_info(p_location_id pn_locations.location_id%TYPE) IS
963: SELECT cust_space_assign_id,
964: cust_account_id,
965: allocated_area,
966: cust_assign_start_date,

Line 976: CURSOR get_uom_info_from_prop(p_property_id pn_locations.property_id%TYPE) IS

972: WHERE cust.location_id = p_location_id
973: AND cust.cust_assign_start_date < fnd_date.canonical_to_date(p_to_date)
974: AND cust.fin_oblig_end_date > fnd_date.canonical_to_date(p_from_date);
975:
976: CURSOR get_uom_info_from_prop(p_property_id pn_locations.property_id%TYPE) IS
977: SELECT uom_code
978: FROM pn_locations_all
979: WHERE property_id = p_property_id
980: AND active_start_date < fnd_date.canonical_to_date(p_to_date)

Line 978: FROM pn_locations_all

974: AND cust.fin_oblig_end_date > fnd_date.canonical_to_date(p_from_date);
975:
976: CURSOR get_uom_info_from_prop(p_property_id pn_locations.property_id%TYPE) IS
977: SELECT uom_code
978: FROM pn_locations_all
979: WHERE property_id = p_property_id
980: AND active_start_date < fnd_date.canonical_to_date(p_to_date)
981: AND active_end_date > fnd_date.canonical_to_date(p_from_date);
982:

Line 983: CURSOR get_uom_info_from_locn(p_location_id pn_locations.location_id%TYPE) IS

979: WHERE property_id = p_property_id
980: AND active_start_date < fnd_date.canonical_to_date(p_to_date)
981: AND active_end_date > fnd_date.canonical_to_date(p_from_date);
982:
983: CURSOR get_uom_info_from_locn(p_location_id pn_locations.location_id%TYPE) IS
984: SELECT uom_code
985: FROM pn_locations_all
986: WHERE location_id IN
987: (SELECT location_id FROM pn_locations_all

Line 985: FROM pn_locations_all

981: AND active_end_date > fnd_date.canonical_to_date(p_from_date);
982:
983: CURSOR get_uom_info_from_locn(p_location_id pn_locations.location_id%TYPE) IS
984: SELECT uom_code
985: FROM pn_locations_all
986: WHERE location_id IN
987: (SELECT location_id FROM pn_locations_all
988: START WITH location_id = p_location_id
989: CONNECT BY location_id = PRIOR parent_location_id)

Line 987: (SELECT location_id FROM pn_locations_all

983: CURSOR get_uom_info_from_locn(p_location_id pn_locations.location_id%TYPE) IS
984: SELECT uom_code
985: FROM pn_locations_all
986: WHERE location_id IN
987: (SELECT location_id FROM pn_locations_all
988: START WITH location_id = p_location_id
989: CONNECT BY location_id = PRIOR parent_location_id)
990: AND parent_location_id IS NULL
991: AND active_start_date < fnd_date.canonical_to_date(p_to_date)

Line 1086: l_uom_code pn_locations_all.uom_code%TYPE;

1082: l_area_total_tbl area_cls_line_hdr_tbl;
1083: l_arcl_locid pn_rec_arcl.location_id%TYPE;
1084: l_arcl_propid pn_rec_arcl.property_id%TYPE;
1085: l_arcl_exc_table area_cls_exc_tbl;
1086: l_uom_code pn_locations_all.uom_code%TYPE;
1087: l_info VARCHAR2(100);
1088: l_desc VARCHAR2(100) := 'pn_recovery_extract_pkg.extract_area' ;
1089:
1090:

Line 1668: p_location_id pn_locations.location_id%TYPE,

1664: -- 06-OCT-07 bifernan o Modified cursor prop_loc_combo_check for bug 6461211
1665: ------------------------------------------------------------------------------+
1666:
1667: FUNCTION check_loc_n_prop_id(
1668: p_location_id pn_locations.location_id%TYPE,
1669: p_property_id pn_locations.property_id%TYPE
1670: ) RETURN BOOLEAN
1671: IS
1672: l_result BOOLEAN:= FALSE;

Line 1669: p_property_id pn_locations.property_id%TYPE

1665: ------------------------------------------------------------------------------+
1666:
1667: FUNCTION check_loc_n_prop_id(
1668: p_location_id pn_locations.location_id%TYPE,
1669: p_property_id pn_locations.property_id%TYPE
1670: ) RETURN BOOLEAN
1671: IS
1672: l_result BOOLEAN:= FALSE;
1673:

Line 1675: SELECT 'TRUE' FROM pn_locations_all WHERE location_id = p_location_id;

1671: IS
1672: l_result BOOLEAN:= FALSE;
1673:
1674: CURSOR loc_check IS
1675: SELECT 'TRUE' FROM pn_locations_all WHERE location_id = p_location_id;
1676:
1677: CURSOR prop_check IS
1678: SELECT 'TRUE' FROM pn_properties_all WHERE property_id = p_property_id;
1679:

Line 1682: SELECT 'TRUE' FROM pn_locations_all WHERE location_id = p_location_id AND property_id = p_property_id; */

1678: SELECT 'TRUE' FROM pn_properties_all WHERE property_id = p_property_id;
1679:
1680: /* Commented and modified for Bug 6461211
1681: CURSOR prop_loc_combo_check IS
1682: SELECT 'TRUE' FROM pn_locations_all WHERE location_id = p_location_id AND property_id = p_property_id; */
1683:
1684: CURSOR prop_loc_combo_check IS
1685: SELECT 'TRUE' FROM pn_locations_all
1686: WHERE property_id = p_property_id

Line 1685: SELECT 'TRUE' FROM pn_locations_all

1681: CURSOR prop_loc_combo_check IS
1682: SELECT 'TRUE' FROM pn_locations_all WHERE location_id = p_location_id AND property_id = p_property_id; */
1683:
1684: CURSOR prop_loc_combo_check IS
1685: SELECT 'TRUE' FROM pn_locations_all
1686: WHERE property_id = p_property_id
1687: START WITH location_id = p_location_id
1688: CONNECT BY PRIOR parent_location_id = location_id;
1689:

Line 2060: (SELECT location_id FROM pn_locations_all

2056: AND from_date = p_from_date
2057: AND to_date = p_to_date
2058: AND currency_code = p_currency_code
2059: AND (location_id IN
2060: (SELECT location_id FROM pn_locations_all
2061: WHERE active_start_date < p_to_date
2062: AND active_end_date > p_from_date
2063: START WITH (location_id = p_location_id OR
2064: (property_id = p_property_id AND p_location_id IS NULL))

Line 2819: FROM pn_locations_all

2815:
2816: CURSOR get_locn_prop_id IS
2817: SELECT property_id,
2818: location_id
2819: FROM pn_locations_all
2820: WHERE active_start_date < fnd_date.canonical_to_date(p_to_date)
2821: AND active_end_date > fnd_date.canonical_to_date(p_from_date)
2822: START WITH location_id = p_location_id
2823: CONNECT BY location_id = PRIOR parent_location_id;

Line 2965: FROM pn_locations_all

2961:
2962: CURSOR get_locn_prop_id IS
2963: SELECT property_id,
2964: location_id
2965: FROM pn_locations_all
2966: WHERE active_start_date < fnd_date.canonical_to_date(p_to_date)
2967: AND active_end_date > fnd_date.canonical_to_date(p_from_date)
2968: START WITH location_id = p_location_id
2969: CONNECT BY location_id = PRIOR parent_location_id;

Line 3243: p_location_id pn_locations.location_id%TYPE,

3239: AND lines_dtl.expense_type_code = p_expense_type_code
3240: AND lines_dtl.recoverable_flag = 'Y';
3241:
3242: CURSOR get_cust_assignment_info(
3243: p_location_id pn_locations.location_id%TYPE,
3244: p_property_id pn_locations.property_id%TYPE,
3245: p_rec_spc_std_code pn_space_assign_cust.recovery_space_std_code%TYPE,
3246: p_rec_type_code pn_space_assign_cust.recovery_type_code%TYPE) IS
3247: SELECT cust.cust_space_assign_id,

Line 3244: p_property_id pn_locations.property_id%TYPE,

3240: AND lines_dtl.recoverable_flag = 'Y';
3241:
3242: CURSOR get_cust_assignment_info(
3243: p_location_id pn_locations.location_id%TYPE,
3244: p_property_id pn_locations.property_id%TYPE,
3245: p_rec_spc_std_code pn_space_assign_cust.recovery_space_std_code%TYPE,
3246: p_rec_type_code pn_space_assign_cust.recovery_type_code%TYPE) IS
3247: SELECT cust.cust_space_assign_id,
3248: cust.cust_account_id,

Line 3255: (SELECT location_id FROM pn_locations_all locn

3251: cust.recovery_space_std_code,
3252: cust.recovery_type_code
3253: FROM pn_space_assign_cust_all cust
3254: WHERE cust.location_id IN
3255: (SELECT location_id FROM pn_locations_all locn
3256: WHERE locn.active_start_date < fnd_date.canonical_to_date(p_to_date)
3257: AND locn.active_end_date > fnd_date.canonical_to_date(p_from_date))
3258: AND cust.cust_assign_start_date < fnd_date.canonical_to_date(p_to_date)
3259: AND cust.fin_oblig_end_date > fnd_date.canonical_to_date(p_from_date)

Line 3263: (SELECT location_id FROM pn_locations_all

3259: AND cust.fin_oblig_end_date > fnd_date.canonical_to_date(p_from_date)
3260: AND cust.recovery_space_std_code = p_rec_spc_std_code
3261: AND cust.recovery_type_code = p_rec_type_code
3262: AND cust.location_id IN
3263: (SELECT location_id FROM pn_locations_all
3264: START WITH (location_id = p_location_id OR
3265: (property_id = p_property_id AND p_location_id IS NULL))
3266: CONNECT BY PRIOR location_id = parent_location_id);
3267:

Line 3762: p_location_code IN pn_locations.location_code%TYPE,

3758:
3759: PROCEDURE extract_line_expense_area(
3760: errbuf OUT NOCOPY VARCHAR2,
3761: retcode OUT NOCOPY VARCHAR2,
3762: p_location_code IN pn_locations.location_code%TYPE,
3763: p_property_code IN pn_properties.property_code%TYPE,
3764: p_as_of_date IN VARCHAR2,
3765: p_from_date IN VARCHAR2,
3766: p_to_date IN VARCHAR2,

Line 3781: l_location_id pn_locations.location_id%TYPE;

3777: l_currency pn_rec_exp_line.currency_code%TYPE;
3778: l_info VARCHAR2(300);
3779: l_desc VARCHAR2(100) := 'pn_recovery_extract_pkg.extract_line_expense_area' ;
3780: l_err VARCHAR2(100);
3781: l_location_id pn_locations.location_id%TYPE;
3782: l_property_id pn_locations.property_id%TYPE;
3783: l_extract_code pn_rec_exp_line.expense_extract_code%TYPE;
3784:
3785: CURSOR derive_loc_id_from_loc_code IS

Line 3782: l_property_id pn_locations.property_id%TYPE;

3778: l_info VARCHAR2(300);
3779: l_desc VARCHAR2(100) := 'pn_recovery_extract_pkg.extract_line_expense_area' ;
3780: l_err VARCHAR2(100);
3781: l_location_id pn_locations.location_id%TYPE;
3782: l_property_id pn_locations.property_id%TYPE;
3783: l_extract_code pn_rec_exp_line.expense_extract_code%TYPE;
3784:
3785: CURSOR derive_loc_id_from_loc_code IS
3786: SELECT location_id, property_id

Line 3787: FROM pn_locations

3783: l_extract_code pn_rec_exp_line.expense_extract_code%TYPE;
3784:
3785: CURSOR derive_loc_id_from_loc_code IS
3786: SELECT location_id, property_id
3787: FROM pn_locations
3788: WHERE location_code = p_location_code
3789: AND rownum = 1;
3790:
3791: CURSOR derive_prop_id_from_prop_code IS

Line 3935: p_location_code IN pn_locations.location_code%TYPE,

3931: PROCEDURE purge_expense_lines_itf_data(
3932: errbuf OUT NOCOPY VARCHAR2,
3933: retcode OUT NOCOPY VARCHAR2,
3934: p_extract_code IN pn_rec_exp_line.expense_extract_code%TYPE,
3935: p_location_code IN pn_locations.location_code%TYPE,
3936: p_property_code IN pn_properties.property_code%TYPE,
3937: p_from_date IN VARCHAR2,
3938: p_to_date IN VARCHAR2,
3939: p_transfer_flag IN pn_rec_exp_itf.transfer_flag%TYPE,

Line 3945: FROM pn_locations

3941: IS
3942:
3943: CURSOR derive_loc_id_from_loc_code IS
3944: SELECT location_id
3945: FROM pn_locations
3946: WHERE location_code = p_location_code;
3947:
3948: CURSOR derive_prop_id_from_prop_code IS
3949: SELECT property_id

Line 3953: l_loc_id pn_locations.location_id%TYPE;

3949: SELECT property_id
3950: FROM pn_properties
3951: WHERE property_code = p_property_code;
3952:
3953: l_loc_id pn_locations.location_id%TYPE;
3954: l_prop_id pn_locations.property_id%TYPE;
3955: l_sqlhead VARCHAR2(300);
3956: l_sqltail VARCHAR2(900) := null;
3957: l_info VARCHAR2(300);

Line 3954: l_prop_id pn_locations.property_id%TYPE;

3950: FROM pn_properties
3951: WHERE property_code = p_property_code;
3952:
3953: l_loc_id pn_locations.location_id%TYPE;
3954: l_prop_id pn_locations.property_id%TYPE;
3955: l_sqlhead VARCHAR2(300);
3956: l_sqltail VARCHAR2(900) := null;
3957: l_info VARCHAR2(300);
3958: l_desc VARCHAR2(100) := 'pn_recovery_extract_pkg.purge_expense_lines_itf_data' ;