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 946: p_location_id pn_locations.location_id%TYPE,

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

Line 947: p_property_id pn_locations.property_id%TYPE) IS

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

Line 953: FROM pn_locations_all

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

Line 958: (SELECT location_id FROM pn_locations_all

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

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

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

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

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

Line 980: FROM pn_locations_all

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

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

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

Line 987: FROM pn_locations_all

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

Line 989: (SELECT location_id FROM pn_locations_all

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

Line 1088: l_uom_code pn_locations_all.uom_code%TYPE;

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

Line 1680: p_location_id pn_locations.location_id%TYPE,

1676: -- 06-OCT-07 bifernan o Modified cursor prop_loc_combo_check for bug 6461211
1677: ------------------------------------------------------------------------------+
1678:
1679: FUNCTION check_loc_n_prop_id(
1680: p_location_id pn_locations.location_id%TYPE,
1681: p_property_id pn_locations.property_id%TYPE
1682: ) RETURN BOOLEAN
1683: IS
1684: l_result BOOLEAN:= FALSE;

Line 1681: p_property_id pn_locations.property_id%TYPE

1677: ------------------------------------------------------------------------------+
1678:
1679: FUNCTION check_loc_n_prop_id(
1680: p_location_id pn_locations.location_id%TYPE,
1681: p_property_id pn_locations.property_id%TYPE
1682: ) RETURN BOOLEAN
1683: IS
1684: l_result BOOLEAN:= FALSE;
1685:

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

1683: IS
1684: l_result BOOLEAN:= FALSE;
1685:
1686: CURSOR loc_check IS
1687: SELECT 'TRUE' FROM pn_locations_all WHERE location_id = p_location_id;
1688:
1689: CURSOR prop_check IS
1690: SELECT 'TRUE' FROM pn_properties_all WHERE property_id = p_property_id;
1691:

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

1690: SELECT 'TRUE' FROM pn_properties_all WHERE property_id = p_property_id;
1691:
1692: /* Commented and modified for Bug 6461211
1693: CURSOR prop_loc_combo_check IS
1694: SELECT 'TRUE' FROM pn_locations_all WHERE location_id = p_location_id AND property_id = p_property_id; */
1695:
1696: CURSOR prop_loc_combo_check IS
1697: SELECT 'TRUE' FROM pn_locations_all
1698: WHERE property_id = p_property_id

Line 1697: SELECT 'TRUE' FROM pn_locations_all

1693: CURSOR prop_loc_combo_check IS
1694: SELECT 'TRUE' FROM pn_locations_all WHERE location_id = p_location_id AND property_id = p_property_id; */
1695:
1696: CURSOR prop_loc_combo_check IS
1697: SELECT 'TRUE' FROM pn_locations_all
1698: WHERE property_id = p_property_id
1699: START WITH location_id = p_location_id
1700: CONNECT BY PRIOR parent_location_id = location_id;
1701:

Line 2072: (SELECT location_id FROM pn_locations_all

2068: AND from_date = p_from_date
2069: AND to_date = p_to_date
2070: AND currency_code = p_currency_code
2071: AND (location_id IN
2072: (SELECT location_id FROM pn_locations_all
2073: WHERE active_start_date < p_to_date
2074: AND active_end_date > p_from_date
2075: START WITH (location_id = p_location_id OR
2076: (property_id = p_property_id AND p_location_id IS NULL))

Line 2831: FROM pn_locations_all

2827:
2828: CURSOR get_locn_prop_id IS
2829: SELECT property_id,
2830: location_id
2831: FROM pn_locations_all
2832: WHERE active_start_date < fnd_date.canonical_to_date(p_to_date)
2833: AND active_end_date > fnd_date.canonical_to_date(p_from_date)
2834: START WITH location_id = p_location_id
2835: CONNECT BY location_id = PRIOR parent_location_id;

Line 2977: FROM pn_locations_all

2973:
2974: CURSOR get_locn_prop_id IS
2975: SELECT property_id,
2976: location_id
2977: FROM pn_locations_all
2978: WHERE active_start_date < fnd_date.canonical_to_date(p_to_date)
2979: AND active_end_date > fnd_date.canonical_to_date(p_from_date)
2980: START WITH location_id = p_location_id
2981: CONNECT BY location_id = PRIOR parent_location_id;

Line 3255: p_location_id pn_locations.location_id%TYPE,

3251: AND lines_dtl.expense_type_code = p_expense_type_code
3252: AND lines_dtl.recoverable_flag = 'Y';
3253:
3254: CURSOR get_cust_assignment_info(
3255: p_location_id pn_locations.location_id%TYPE,
3256: p_property_id pn_locations.property_id%TYPE,
3257: p_rec_spc_std_code pn_space_assign_cust.recovery_space_std_code%TYPE,
3258: p_rec_type_code pn_space_assign_cust.recovery_type_code%TYPE) IS
3259: SELECT cust.cust_space_assign_id,

Line 3256: p_property_id pn_locations.property_id%TYPE,

3252: AND lines_dtl.recoverable_flag = 'Y';
3253:
3254: CURSOR get_cust_assignment_info(
3255: p_location_id pn_locations.location_id%TYPE,
3256: p_property_id pn_locations.property_id%TYPE,
3257: p_rec_spc_std_code pn_space_assign_cust.recovery_space_std_code%TYPE,
3258: p_rec_type_code pn_space_assign_cust.recovery_type_code%TYPE) IS
3259: SELECT cust.cust_space_assign_id,
3260: cust.cust_account_id,

Line 3267: (SELECT location_id FROM pn_locations_all locn

3263: cust.recovery_space_std_code,
3264: cust.recovery_type_code
3265: FROM pn_space_assign_cust_all cust
3266: WHERE cust.location_id IN
3267: (SELECT location_id FROM pn_locations_all locn
3268: WHERE locn.active_start_date < fnd_date.canonical_to_date(p_to_date)
3269: AND locn.active_end_date > fnd_date.canonical_to_date(p_from_date))
3270: AND cust.cust_assign_start_date < fnd_date.canonical_to_date(p_to_date)
3271: AND cust.fin_oblig_end_date > fnd_date.canonical_to_date(p_from_date)

Line 3275: (SELECT location_id FROM pn_locations_all

3271: AND cust.fin_oblig_end_date > fnd_date.canonical_to_date(p_from_date)
3272: AND cust.recovery_space_std_code = p_rec_spc_std_code
3273: AND cust.recovery_type_code = p_rec_type_code
3274: AND cust.location_id IN
3275: (SELECT location_id FROM pn_locations_all
3276: START WITH (location_id = p_location_id OR
3277: (property_id = p_property_id AND p_location_id IS NULL))
3278: CONNECT BY PRIOR location_id = parent_location_id);
3279:

Line 3774: p_location_code IN pn_locations.location_code%TYPE,

3770:
3771: PROCEDURE extract_line_expense_area(
3772: errbuf OUT NOCOPY VARCHAR2,
3773: retcode OUT NOCOPY VARCHAR2,
3774: p_location_code IN pn_locations.location_code%TYPE,
3775: p_property_code IN pn_properties.property_code%TYPE,
3776: p_as_of_date IN VARCHAR2,
3777: p_from_date IN VARCHAR2,
3778: p_to_date IN VARCHAR2,

Line 3793: l_location_id pn_locations.location_id%TYPE;

3789: l_currency pn_rec_exp_line.currency_code%TYPE;
3790: l_info VARCHAR2(300);
3791: l_desc VARCHAR2(100) := 'pn_recovery_extract_pkg.extract_line_expense_area' ;
3792: l_err VARCHAR2(100);
3793: l_location_id pn_locations.location_id%TYPE;
3794: l_property_id pn_locations.property_id%TYPE;
3795: l_extract_code pn_rec_exp_line.expense_extract_code%TYPE;
3796:
3797: CURSOR derive_loc_id_from_loc_code IS

Line 3794: l_property_id pn_locations.property_id%TYPE;

3790: l_info VARCHAR2(300);
3791: l_desc VARCHAR2(100) := 'pn_recovery_extract_pkg.extract_line_expense_area' ;
3792: l_err VARCHAR2(100);
3793: l_location_id pn_locations.location_id%TYPE;
3794: l_property_id pn_locations.property_id%TYPE;
3795: l_extract_code pn_rec_exp_line.expense_extract_code%TYPE;
3796:
3797: CURSOR derive_loc_id_from_loc_code IS
3798: SELECT location_id, property_id

Line 3799: FROM pn_locations

3795: l_extract_code pn_rec_exp_line.expense_extract_code%TYPE;
3796:
3797: CURSOR derive_loc_id_from_loc_code IS
3798: SELECT location_id, property_id
3799: FROM pn_locations
3800: WHERE location_code = p_location_code
3801: AND rownum = 1;
3802:
3803: CURSOR derive_prop_id_from_prop_code IS

Line 3947: p_location_code IN pn_locations.location_code%TYPE,

3943: PROCEDURE purge_expense_lines_itf_data(
3944: errbuf OUT NOCOPY VARCHAR2,
3945: retcode OUT NOCOPY VARCHAR2,
3946: p_extract_code IN pn_rec_exp_line.expense_extract_code%TYPE,
3947: p_location_code IN pn_locations.location_code%TYPE,
3948: p_property_code IN pn_properties.property_code%TYPE,
3949: p_from_date IN VARCHAR2,
3950: p_to_date IN VARCHAR2,
3951: p_transfer_flag IN pn_rec_exp_itf.transfer_flag%TYPE,

Line 3957: FROM pn_locations

3953: IS
3954:
3955: CURSOR derive_loc_id_from_loc_code IS
3956: SELECT location_id
3957: FROM pn_locations
3958: WHERE location_code = p_location_code;
3959:
3960: CURSOR derive_prop_id_from_prop_code IS
3961: SELECT property_id

Line 3965: l_loc_id pn_locations.location_id%TYPE;

3961: SELECT property_id
3962: FROM pn_properties
3963: WHERE property_code = p_property_code;
3964:
3965: l_loc_id pn_locations.location_id%TYPE;
3966: l_prop_id pn_locations.property_id%TYPE;
3967: l_sqlhead VARCHAR2(300);
3968: l_sqltail VARCHAR2(900) := null;
3969: l_info VARCHAR2(300);

Line 3966: l_prop_id pn_locations.property_id%TYPE;

3962: FROM pn_properties
3963: WHERE property_code = p_property_code;
3964:
3965: l_loc_id pn_locations.location_id%TYPE;
3966: l_prop_id pn_locations.property_id%TYPE;
3967: l_sqlhead VARCHAR2(300);
3968: l_sqltail VARCHAR2(900) := null;
3969: l_info VARCHAR2(300);
3970: l_desc VARCHAR2(100) := 'pn_recovery_extract_pkg.purge_expense_lines_itf_data' ;