90: | MODIFICATION HISTORY
91: | Created Naga Vijayapuram 1998
92: | Modified Naga Vijayapuram 1999 Included Validations
93: | 23-APR-02 Kiran Hegde o Fixed Bug#2324687. Added columns Location_Alias,
94: | Property_Id to PN_LOCATIONS_ITF. Modified the
95: | Inserts and Updates. Added function
96: | Exists_Property_Id for validating Property_id.
97: | Added validations for Locations_Alias.
98: | 08-MAY-02 Kiran Hegde o Fixed Bug#2341761. Added column
95: | Inserts and Updates. Added function
96: | Exists_Property_Id for validating Property_id.
97: | Added validations for Locations_Alias.
98: | 08-MAY-02 Kiran Hegde o Fixed Bug#2341761. Added column
99: | Standard_Type_Lookup_Code to PN_LOCATIONS_ITF.
100: | Modified inserts and updates appropriately.
101: | Changed the validations of Usable, Rentable,
102: | Assignable to match the validations in the form
103: | 14-MAY-02 Kiran Hegde o Added validations to Locations_Itf to behave
159: l_occ_status varchar2(1) := ''; /* Bug 6861678 */
160:
161: CURSOR loccur IS
162: SELECT pli.*, pli.rowid,occupancy_status_code
163: FROM PN_LOCATIONS_ITF pli,
164: PN_LOCATIONS_ALL pnl
165: WHERE pli.parent_location_id = pnl.location_id(+)
166: AND pli.batch_name = p_batch_name
167: AND pli.transferred_to_pn IS NULL
160:
161: CURSOR loccur IS
162: SELECT pli.*, pli.rowid,occupancy_status_code
163: FROM PN_LOCATIONS_ITF pli,
164: PN_LOCATIONS_ALL pnl
165: WHERE pli.parent_location_id = pnl.location_id(+)
166: AND pli.batch_name = p_batch_name
167: AND pli.transferred_to_pn IS NULL
168: ORDER BY pli.location_type_lookup_code, pli.active_start_date;
182:
183: l_last_update_date DATE;
184: l_location_id NUMBER;
185: l_loc_id NUMBER;
186: v_loc_rec PN_LOCATIONS%ROWTYPE;
187: v_addr_rec PN_ADDRESSES%ROWTYPE;
188: l_act_str_dt DATE;
189: l_pn_locations_rec PN_LOCATIONS_ALL%ROWTYPE;
190: l_pn_addresses_rec PN_ADDRESSES_ALL%ROWTYPE;
185: l_loc_id NUMBER;
186: v_loc_rec PN_LOCATIONS%ROWTYPE;
187: v_addr_rec PN_ADDRESSES%ROWTYPE;
188: l_act_str_dt DATE;
189: l_pn_locations_rec PN_LOCATIONS_ALL%ROWTYPE;
190: l_pn_addresses_rec PN_ADDRESSES_ALL%ROWTYPE;
191: l_active_start_date DATE;
192: l_active_end_date DATE;
193: l_filename VARCHAR2(50) := 'IMPORT_'||to_char(sysdate,'DDMMYYYYHHMMSS');
414: -------------------------------------------------------------------------
415: if loc.LOCATION_TYPE_LOOKUP_CODE in ('FLOOR', 'OFFICE', 'PARCEL', 'SECTION') then
416: select min(active_start_date), nvl(max(active_end_date),PNT_LOCATIONS_PKG.G_END_OF_TIME)
417: into l_active_start_date, l_active_end_date
418: from pn_locations_all where location_id = loc.PARENT_LOCATION_ID
419: group by location_id;
420:
421: if trunc(loc.active_start_date) < trunc(l_active_start_date) then
422: fnd_message.set_name('PN', 'PN_CAFM_LOC_CHILD_ST_DT');
639: end if;
640: end if;
641:
642: --------------------------------------
643: -- Insert Data into PN_LOCATIONS
644: --------------------------------------
645: put_log( 'Just before Insert');
646:
647: BEGIN
775: --------------------------------------
776: BEGIN
777: select *
778: into v_loc_rec
779: from PN_LOCATIONS_ALL
780: where LOCATION_ID = loc.location_id
781: and location_code = loc.location_code
782: and active_Start_date = trunc(loc.active_start_date)
783: and active_End_date = trunc(nvl(loc.active_end_date, PNT_LOCATIONS_PKG.G_END_OF_TIME));
1041:
1042: BEGIN
1043: l_active_end_date := trunc(v_loc_rec.active_end_date); --Used trunc() :Bug 6009957
1044:
1045: l_pn_locations_rec.location_id := loc.location_id;
1046: l_pn_locations_rec.ORG_ID := l_org_id;
1047: l_pn_locations_rec.LOCATION_TYPE_LOOKUP_CODE := loc.location_type_lookup_code;
1048: l_pn_locations_rec.SPACE_TYPE_LOOKUP_CODE := loc.space_type_lookup_code;
1049: l_pn_locations_rec.LAST_UPDATE_DATE := sysdate;
1042: BEGIN
1043: l_active_end_date := trunc(v_loc_rec.active_end_date); --Used trunc() :Bug 6009957
1044:
1045: l_pn_locations_rec.location_id := loc.location_id;
1046: l_pn_locations_rec.ORG_ID := l_org_id;
1047: l_pn_locations_rec.LOCATION_TYPE_LOOKUP_CODE := loc.location_type_lookup_code;
1048: l_pn_locations_rec.SPACE_TYPE_LOOKUP_CODE := loc.space_type_lookup_code;
1049: l_pn_locations_rec.LAST_UPDATE_DATE := sysdate;
1050: l_pn_locations_rec.PARENT_LOCATION_ID := loc.parent_location_id;
1043: l_active_end_date := trunc(v_loc_rec.active_end_date); --Used trunc() :Bug 6009957
1044:
1045: l_pn_locations_rec.location_id := loc.location_id;
1046: l_pn_locations_rec.ORG_ID := l_org_id;
1047: l_pn_locations_rec.LOCATION_TYPE_LOOKUP_CODE := loc.location_type_lookup_code;
1048: l_pn_locations_rec.SPACE_TYPE_LOOKUP_CODE := loc.space_type_lookup_code;
1049: l_pn_locations_rec.LAST_UPDATE_DATE := sysdate;
1050: l_pn_locations_rec.PARENT_LOCATION_ID := loc.parent_location_id;
1051: l_pn_locations_rec.LEASE_OR_OWNED := loc.lease_or_owned;
1044:
1045: l_pn_locations_rec.location_id := loc.location_id;
1046: l_pn_locations_rec.ORG_ID := l_org_id;
1047: l_pn_locations_rec.LOCATION_TYPE_LOOKUP_CODE := loc.location_type_lookup_code;
1048: l_pn_locations_rec.SPACE_TYPE_LOOKUP_CODE := loc.space_type_lookup_code;
1049: l_pn_locations_rec.LAST_UPDATE_DATE := sysdate;
1050: l_pn_locations_rec.PARENT_LOCATION_ID := loc.parent_location_id;
1051: l_pn_locations_rec.LEASE_OR_OWNED := loc.lease_or_owned;
1052: l_pn_locations_rec.BUILDING := loc.building;
1045: l_pn_locations_rec.location_id := loc.location_id;
1046: l_pn_locations_rec.ORG_ID := l_org_id;
1047: l_pn_locations_rec.LOCATION_TYPE_LOOKUP_CODE := loc.location_type_lookup_code;
1048: l_pn_locations_rec.SPACE_TYPE_LOOKUP_CODE := loc.space_type_lookup_code;
1049: l_pn_locations_rec.LAST_UPDATE_DATE := sysdate;
1050: l_pn_locations_rec.PARENT_LOCATION_ID := loc.parent_location_id;
1051: l_pn_locations_rec.LEASE_OR_OWNED := loc.lease_or_owned;
1052: l_pn_locations_rec.BUILDING := loc.building;
1053: l_pn_locations_rec.FLOOR := loc.floor;
1046: l_pn_locations_rec.ORG_ID := l_org_id;
1047: l_pn_locations_rec.LOCATION_TYPE_LOOKUP_CODE := loc.location_type_lookup_code;
1048: l_pn_locations_rec.SPACE_TYPE_LOOKUP_CODE := loc.space_type_lookup_code;
1049: l_pn_locations_rec.LAST_UPDATE_DATE := sysdate;
1050: l_pn_locations_rec.PARENT_LOCATION_ID := loc.parent_location_id;
1051: l_pn_locations_rec.LEASE_OR_OWNED := loc.lease_or_owned;
1052: l_pn_locations_rec.BUILDING := loc.building;
1053: l_pn_locations_rec.FLOOR := loc.floor;
1054: l_pn_locations_rec.OFFICE := loc.office;
1047: l_pn_locations_rec.LOCATION_TYPE_LOOKUP_CODE := loc.location_type_lookup_code;
1048: l_pn_locations_rec.SPACE_TYPE_LOOKUP_CODE := loc.space_type_lookup_code;
1049: l_pn_locations_rec.LAST_UPDATE_DATE := sysdate;
1050: l_pn_locations_rec.PARENT_LOCATION_ID := loc.parent_location_id;
1051: l_pn_locations_rec.LEASE_OR_OWNED := loc.lease_or_owned;
1052: l_pn_locations_rec.BUILDING := loc.building;
1053: l_pn_locations_rec.FLOOR := loc.floor;
1054: l_pn_locations_rec.OFFICE := loc.office;
1055: l_pn_locations_rec.MAX_CAPACITY := loc.max_capacity;
1048: l_pn_locations_rec.SPACE_TYPE_LOOKUP_CODE := loc.space_type_lookup_code;
1049: l_pn_locations_rec.LAST_UPDATE_DATE := sysdate;
1050: l_pn_locations_rec.PARENT_LOCATION_ID := loc.parent_location_id;
1051: l_pn_locations_rec.LEASE_OR_OWNED := loc.lease_or_owned;
1052: l_pn_locations_rec.BUILDING := loc.building;
1053: l_pn_locations_rec.FLOOR := loc.floor;
1054: l_pn_locations_rec.OFFICE := loc.office;
1055: l_pn_locations_rec.MAX_CAPACITY := loc.max_capacity;
1056: l_pn_locations_rec.OPTIMUM_CAPACITY := loc.optimum_capacity;
1049: l_pn_locations_rec.LAST_UPDATE_DATE := sysdate;
1050: l_pn_locations_rec.PARENT_LOCATION_ID := loc.parent_location_id;
1051: l_pn_locations_rec.LEASE_OR_OWNED := loc.lease_or_owned;
1052: l_pn_locations_rec.BUILDING := loc.building;
1053: l_pn_locations_rec.FLOOR := loc.floor;
1054: l_pn_locations_rec.OFFICE := loc.office;
1055: l_pn_locations_rec.MAX_CAPACITY := loc.max_capacity;
1056: l_pn_locations_rec.OPTIMUM_CAPACITY := loc.optimum_capacity;
1057: l_pn_locations_rec.RENTABLE_AREA := loc.rentable_area;
1050: l_pn_locations_rec.PARENT_LOCATION_ID := loc.parent_location_id;
1051: l_pn_locations_rec.LEASE_OR_OWNED := loc.lease_or_owned;
1052: l_pn_locations_rec.BUILDING := loc.building;
1053: l_pn_locations_rec.FLOOR := loc.floor;
1054: l_pn_locations_rec.OFFICE := loc.office;
1055: l_pn_locations_rec.MAX_CAPACITY := loc.max_capacity;
1056: l_pn_locations_rec.OPTIMUM_CAPACITY := loc.optimum_capacity;
1057: l_pn_locations_rec.RENTABLE_AREA := loc.rentable_area;
1058: l_pn_locations_rec.USABLE_AREA := loc.usable_area;
1051: l_pn_locations_rec.LEASE_OR_OWNED := loc.lease_or_owned;
1052: l_pn_locations_rec.BUILDING := loc.building;
1053: l_pn_locations_rec.FLOOR := loc.floor;
1054: l_pn_locations_rec.OFFICE := loc.office;
1055: l_pn_locations_rec.MAX_CAPACITY := loc.max_capacity;
1056: l_pn_locations_rec.OPTIMUM_CAPACITY := loc.optimum_capacity;
1057: l_pn_locations_rec.RENTABLE_AREA := loc.rentable_area;
1058: l_pn_locations_rec.USABLE_AREA := loc.usable_area;
1059: l_pn_locations_rec.GROSS_AREA := loc.gross_area;
1052: l_pn_locations_rec.BUILDING := loc.building;
1053: l_pn_locations_rec.FLOOR := loc.floor;
1054: l_pn_locations_rec.OFFICE := loc.office;
1055: l_pn_locations_rec.MAX_CAPACITY := loc.max_capacity;
1056: l_pn_locations_rec.OPTIMUM_CAPACITY := loc.optimum_capacity;
1057: l_pn_locations_rec.RENTABLE_AREA := loc.rentable_area;
1058: l_pn_locations_rec.USABLE_AREA := loc.usable_area;
1059: l_pn_locations_rec.GROSS_AREA := loc.gross_area;
1060: l_pn_locations_rec.ASSIGNABLE_AREA := loc.assignable_area;
1053: l_pn_locations_rec.FLOOR := loc.floor;
1054: l_pn_locations_rec.OFFICE := loc.office;
1055: l_pn_locations_rec.MAX_CAPACITY := loc.max_capacity;
1056: l_pn_locations_rec.OPTIMUM_CAPACITY := loc.optimum_capacity;
1057: l_pn_locations_rec.RENTABLE_AREA := loc.rentable_area;
1058: l_pn_locations_rec.USABLE_AREA := loc.usable_area;
1059: l_pn_locations_rec.GROSS_AREA := loc.gross_area;
1060: l_pn_locations_rec.ASSIGNABLE_AREA := loc.assignable_area;
1061: l_pn_locations_rec.COMMON_AREA := loc.common_area;
1054: l_pn_locations_rec.OFFICE := loc.office;
1055: l_pn_locations_rec.MAX_CAPACITY := loc.max_capacity;
1056: l_pn_locations_rec.OPTIMUM_CAPACITY := loc.optimum_capacity;
1057: l_pn_locations_rec.RENTABLE_AREA := loc.rentable_area;
1058: l_pn_locations_rec.USABLE_AREA := loc.usable_area;
1059: l_pn_locations_rec.GROSS_AREA := loc.gross_area;
1060: l_pn_locations_rec.ASSIGNABLE_AREA := loc.assignable_area;
1061: l_pn_locations_rec.COMMON_AREA := loc.common_area;
1062: l_pn_locations_rec.COMMON_AREA_FLAG := loc.common_area_flag;
1055: l_pn_locations_rec.MAX_CAPACITY := loc.max_capacity;
1056: l_pn_locations_rec.OPTIMUM_CAPACITY := loc.optimum_capacity;
1057: l_pn_locations_rec.RENTABLE_AREA := loc.rentable_area;
1058: l_pn_locations_rec.USABLE_AREA := loc.usable_area;
1059: l_pn_locations_rec.GROSS_AREA := loc.gross_area;
1060: l_pn_locations_rec.ASSIGNABLE_AREA := loc.assignable_area;
1061: l_pn_locations_rec.COMMON_AREA := loc.common_area;
1062: l_pn_locations_rec.COMMON_AREA_FLAG := loc.common_area_flag;
1063: l_pn_locations_rec.CLASS := loc.class;
1056: l_pn_locations_rec.OPTIMUM_CAPACITY := loc.optimum_capacity;
1057: l_pn_locations_rec.RENTABLE_AREA := loc.rentable_area;
1058: l_pn_locations_rec.USABLE_AREA := loc.usable_area;
1059: l_pn_locations_rec.GROSS_AREA := loc.gross_area;
1060: l_pn_locations_rec.ASSIGNABLE_AREA := loc.assignable_area;
1061: l_pn_locations_rec.COMMON_AREA := loc.common_area;
1062: l_pn_locations_rec.COMMON_AREA_FLAG := loc.common_area_flag;
1063: l_pn_locations_rec.CLASS := loc.class;
1064: l_pn_locations_rec.STATUS_TYPE := loc.status_type;
1057: l_pn_locations_rec.RENTABLE_AREA := loc.rentable_area;
1058: l_pn_locations_rec.USABLE_AREA := loc.usable_area;
1059: l_pn_locations_rec.GROSS_AREA := loc.gross_area;
1060: l_pn_locations_rec.ASSIGNABLE_AREA := loc.assignable_area;
1061: l_pn_locations_rec.COMMON_AREA := loc.common_area;
1062: l_pn_locations_rec.COMMON_AREA_FLAG := loc.common_area_flag;
1063: l_pn_locations_rec.CLASS := loc.class;
1064: l_pn_locations_rec.STATUS_TYPE := loc.status_type;
1065: l_pn_locations_rec.STATUS := 'A';
1058: l_pn_locations_rec.USABLE_AREA := loc.usable_area;
1059: l_pn_locations_rec.GROSS_AREA := loc.gross_area;
1060: l_pn_locations_rec.ASSIGNABLE_AREA := loc.assignable_area;
1061: l_pn_locations_rec.COMMON_AREA := loc.common_area;
1062: l_pn_locations_rec.COMMON_AREA_FLAG := loc.common_area_flag;
1063: l_pn_locations_rec.CLASS := loc.class;
1064: l_pn_locations_rec.STATUS_TYPE := loc.status_type;
1065: l_pn_locations_rec.STATUS := 'A';
1066: l_pn_locations_rec.SUITE := loc.suite;
1059: l_pn_locations_rec.GROSS_AREA := loc.gross_area;
1060: l_pn_locations_rec.ASSIGNABLE_AREA := loc.assignable_area;
1061: l_pn_locations_rec.COMMON_AREA := loc.common_area;
1062: l_pn_locations_rec.COMMON_AREA_FLAG := loc.common_area_flag;
1063: l_pn_locations_rec.CLASS := loc.class;
1064: l_pn_locations_rec.STATUS_TYPE := loc.status_type;
1065: l_pn_locations_rec.STATUS := 'A';
1066: l_pn_locations_rec.SUITE := loc.suite;
1067: l_pn_locations_rec.ALLOCATE_COST_CENTER_CODE := loc.allocate_cost_center_code;
1060: l_pn_locations_rec.ASSIGNABLE_AREA := loc.assignable_area;
1061: l_pn_locations_rec.COMMON_AREA := loc.common_area;
1062: l_pn_locations_rec.COMMON_AREA_FLAG := loc.common_area_flag;
1063: l_pn_locations_rec.CLASS := loc.class;
1064: l_pn_locations_rec.STATUS_TYPE := loc.status_type;
1065: l_pn_locations_rec.STATUS := 'A';
1066: l_pn_locations_rec.SUITE := loc.suite;
1067: l_pn_locations_rec.ALLOCATE_COST_CENTER_CODE := loc.allocate_cost_center_code;
1068: l_pn_locations_rec.UOM_CODE := loc.uom_code;
1061: l_pn_locations_rec.COMMON_AREA := loc.common_area;
1062: l_pn_locations_rec.COMMON_AREA_FLAG := loc.common_area_flag;
1063: l_pn_locations_rec.CLASS := loc.class;
1064: l_pn_locations_rec.STATUS_TYPE := loc.status_type;
1065: l_pn_locations_rec.STATUS := 'A';
1066: l_pn_locations_rec.SUITE := loc.suite;
1067: l_pn_locations_rec.ALLOCATE_COST_CENTER_CODE := loc.allocate_cost_center_code;
1068: l_pn_locations_rec.UOM_CODE := loc.uom_code;
1069: l_pn_locations_rec.LAST_UPDATE_LOGIN := nvl(fnd_profile.value('CONC_LOGIN_ID'), 0);
1062: l_pn_locations_rec.COMMON_AREA_FLAG := loc.common_area_flag;
1063: l_pn_locations_rec.CLASS := loc.class;
1064: l_pn_locations_rec.STATUS_TYPE := loc.status_type;
1065: l_pn_locations_rec.STATUS := 'A';
1066: l_pn_locations_rec.SUITE := loc.suite;
1067: l_pn_locations_rec.ALLOCATE_COST_CENTER_CODE := loc.allocate_cost_center_code;
1068: l_pn_locations_rec.UOM_CODE := loc.uom_code;
1069: l_pn_locations_rec.LAST_UPDATE_LOGIN := nvl(fnd_profile.value('CONC_LOGIN_ID'), 0);
1070: l_pn_locations_rec.LAST_UPDATED_BY := nvl(fnd_profile.value('CONC_USER_ID'), 0);
1063: l_pn_locations_rec.CLASS := loc.class;
1064: l_pn_locations_rec.STATUS_TYPE := loc.status_type;
1065: l_pn_locations_rec.STATUS := 'A';
1066: l_pn_locations_rec.SUITE := loc.suite;
1067: l_pn_locations_rec.ALLOCATE_COST_CENTER_CODE := loc.allocate_cost_center_code;
1068: l_pn_locations_rec.UOM_CODE := loc.uom_code;
1069: l_pn_locations_rec.LAST_UPDATE_LOGIN := nvl(fnd_profile.value('CONC_LOGIN_ID'), 0);
1070: l_pn_locations_rec.LAST_UPDATED_BY := nvl(fnd_profile.value('CONC_USER_ID'), 0);
1071: l_pn_locations_rec.ATTRIBUTE_CATEGORY := loc.attribute_category;
1064: l_pn_locations_rec.STATUS_TYPE := loc.status_type;
1065: l_pn_locations_rec.STATUS := 'A';
1066: l_pn_locations_rec.SUITE := loc.suite;
1067: l_pn_locations_rec.ALLOCATE_COST_CENTER_CODE := loc.allocate_cost_center_code;
1068: l_pn_locations_rec.UOM_CODE := loc.uom_code;
1069: l_pn_locations_rec.LAST_UPDATE_LOGIN := nvl(fnd_profile.value('CONC_LOGIN_ID'), 0);
1070: l_pn_locations_rec.LAST_UPDATED_BY := nvl(fnd_profile.value('CONC_USER_ID'), 0);
1071: l_pn_locations_rec.ATTRIBUTE_CATEGORY := loc.attribute_category;
1072: l_pn_locations_rec.ATTRIBUTE1 := loc.attribute1;
1065: l_pn_locations_rec.STATUS := 'A';
1066: l_pn_locations_rec.SUITE := loc.suite;
1067: l_pn_locations_rec.ALLOCATE_COST_CENTER_CODE := loc.allocate_cost_center_code;
1068: l_pn_locations_rec.UOM_CODE := loc.uom_code;
1069: l_pn_locations_rec.LAST_UPDATE_LOGIN := nvl(fnd_profile.value('CONC_LOGIN_ID'), 0);
1070: l_pn_locations_rec.LAST_UPDATED_BY := nvl(fnd_profile.value('CONC_USER_ID'), 0);
1071: l_pn_locations_rec.ATTRIBUTE_CATEGORY := loc.attribute_category;
1072: l_pn_locations_rec.ATTRIBUTE1 := loc.attribute1;
1073: l_pn_locations_rec.ATTRIBUTE2 := loc.attribute2;
1066: l_pn_locations_rec.SUITE := loc.suite;
1067: l_pn_locations_rec.ALLOCATE_COST_CENTER_CODE := loc.allocate_cost_center_code;
1068: l_pn_locations_rec.UOM_CODE := loc.uom_code;
1069: l_pn_locations_rec.LAST_UPDATE_LOGIN := nvl(fnd_profile.value('CONC_LOGIN_ID'), 0);
1070: l_pn_locations_rec.LAST_UPDATED_BY := nvl(fnd_profile.value('CONC_USER_ID'), 0);
1071: l_pn_locations_rec.ATTRIBUTE_CATEGORY := loc.attribute_category;
1072: l_pn_locations_rec.ATTRIBUTE1 := loc.attribute1;
1073: l_pn_locations_rec.ATTRIBUTE2 := loc.attribute2;
1074: l_pn_locations_rec.ATTRIBUTE3 := loc.attribute3;
1067: l_pn_locations_rec.ALLOCATE_COST_CENTER_CODE := loc.allocate_cost_center_code;
1068: l_pn_locations_rec.UOM_CODE := loc.uom_code;
1069: l_pn_locations_rec.LAST_UPDATE_LOGIN := nvl(fnd_profile.value('CONC_LOGIN_ID'), 0);
1070: l_pn_locations_rec.LAST_UPDATED_BY := nvl(fnd_profile.value('CONC_USER_ID'), 0);
1071: l_pn_locations_rec.ATTRIBUTE_CATEGORY := loc.attribute_category;
1072: l_pn_locations_rec.ATTRIBUTE1 := loc.attribute1;
1073: l_pn_locations_rec.ATTRIBUTE2 := loc.attribute2;
1074: l_pn_locations_rec.ATTRIBUTE3 := loc.attribute3;
1075: l_pn_locations_rec.ATTRIBUTE4 := loc.attribute4;
1068: l_pn_locations_rec.UOM_CODE := loc.uom_code;
1069: l_pn_locations_rec.LAST_UPDATE_LOGIN := nvl(fnd_profile.value('CONC_LOGIN_ID'), 0);
1070: l_pn_locations_rec.LAST_UPDATED_BY := nvl(fnd_profile.value('CONC_USER_ID'), 0);
1071: l_pn_locations_rec.ATTRIBUTE_CATEGORY := loc.attribute_category;
1072: l_pn_locations_rec.ATTRIBUTE1 := loc.attribute1;
1073: l_pn_locations_rec.ATTRIBUTE2 := loc.attribute2;
1074: l_pn_locations_rec.ATTRIBUTE3 := loc.attribute3;
1075: l_pn_locations_rec.ATTRIBUTE4 := loc.attribute4;
1076: l_pn_locations_rec.ATTRIBUTE5 := loc.attribute5;
1069: l_pn_locations_rec.LAST_UPDATE_LOGIN := nvl(fnd_profile.value('CONC_LOGIN_ID'), 0);
1070: l_pn_locations_rec.LAST_UPDATED_BY := nvl(fnd_profile.value('CONC_USER_ID'), 0);
1071: l_pn_locations_rec.ATTRIBUTE_CATEGORY := loc.attribute_category;
1072: l_pn_locations_rec.ATTRIBUTE1 := loc.attribute1;
1073: l_pn_locations_rec.ATTRIBUTE2 := loc.attribute2;
1074: l_pn_locations_rec.ATTRIBUTE3 := loc.attribute3;
1075: l_pn_locations_rec.ATTRIBUTE4 := loc.attribute4;
1076: l_pn_locations_rec.ATTRIBUTE5 := loc.attribute5;
1077: l_pn_locations_rec.ATTRIBUTE6 := loc.attribute6;
1070: l_pn_locations_rec.LAST_UPDATED_BY := nvl(fnd_profile.value('CONC_USER_ID'), 0);
1071: l_pn_locations_rec.ATTRIBUTE_CATEGORY := loc.attribute_category;
1072: l_pn_locations_rec.ATTRIBUTE1 := loc.attribute1;
1073: l_pn_locations_rec.ATTRIBUTE2 := loc.attribute2;
1074: l_pn_locations_rec.ATTRIBUTE3 := loc.attribute3;
1075: l_pn_locations_rec.ATTRIBUTE4 := loc.attribute4;
1076: l_pn_locations_rec.ATTRIBUTE5 := loc.attribute5;
1077: l_pn_locations_rec.ATTRIBUTE6 := loc.attribute6;
1078: l_pn_locations_rec.ATTRIBUTE7 := loc.attribute7;
1071: l_pn_locations_rec.ATTRIBUTE_CATEGORY := loc.attribute_category;
1072: l_pn_locations_rec.ATTRIBUTE1 := loc.attribute1;
1073: l_pn_locations_rec.ATTRIBUTE2 := loc.attribute2;
1074: l_pn_locations_rec.ATTRIBUTE3 := loc.attribute3;
1075: l_pn_locations_rec.ATTRIBUTE4 := loc.attribute4;
1076: l_pn_locations_rec.ATTRIBUTE5 := loc.attribute5;
1077: l_pn_locations_rec.ATTRIBUTE6 := loc.attribute6;
1078: l_pn_locations_rec.ATTRIBUTE7 := loc.attribute7;
1079: l_pn_locations_rec.ATTRIBUTE8 := loc.attribute8;
1072: l_pn_locations_rec.ATTRIBUTE1 := loc.attribute1;
1073: l_pn_locations_rec.ATTRIBUTE2 := loc.attribute2;
1074: l_pn_locations_rec.ATTRIBUTE3 := loc.attribute3;
1075: l_pn_locations_rec.ATTRIBUTE4 := loc.attribute4;
1076: l_pn_locations_rec.ATTRIBUTE5 := loc.attribute5;
1077: l_pn_locations_rec.ATTRIBUTE6 := loc.attribute6;
1078: l_pn_locations_rec.ATTRIBUTE7 := loc.attribute7;
1079: l_pn_locations_rec.ATTRIBUTE8 := loc.attribute8;
1080: l_pn_locations_rec.ATTRIBUTE9 := loc.attribute9;
1073: l_pn_locations_rec.ATTRIBUTE2 := loc.attribute2;
1074: l_pn_locations_rec.ATTRIBUTE3 := loc.attribute3;
1075: l_pn_locations_rec.ATTRIBUTE4 := loc.attribute4;
1076: l_pn_locations_rec.ATTRIBUTE5 := loc.attribute5;
1077: l_pn_locations_rec.ATTRIBUTE6 := loc.attribute6;
1078: l_pn_locations_rec.ATTRIBUTE7 := loc.attribute7;
1079: l_pn_locations_rec.ATTRIBUTE8 := loc.attribute8;
1080: l_pn_locations_rec.ATTRIBUTE9 := loc.attribute9;
1081: l_pn_locations_rec.ATTRIBUTE10 := loc.attribute10;
1074: l_pn_locations_rec.ATTRIBUTE3 := loc.attribute3;
1075: l_pn_locations_rec.ATTRIBUTE4 := loc.attribute4;
1076: l_pn_locations_rec.ATTRIBUTE5 := loc.attribute5;
1077: l_pn_locations_rec.ATTRIBUTE6 := loc.attribute6;
1078: l_pn_locations_rec.ATTRIBUTE7 := loc.attribute7;
1079: l_pn_locations_rec.ATTRIBUTE8 := loc.attribute8;
1080: l_pn_locations_rec.ATTRIBUTE9 := loc.attribute9;
1081: l_pn_locations_rec.ATTRIBUTE10 := loc.attribute10;
1082: l_pn_locations_rec.ATTRIBUTE11 := loc.attribute11;
1075: l_pn_locations_rec.ATTRIBUTE4 := loc.attribute4;
1076: l_pn_locations_rec.ATTRIBUTE5 := loc.attribute5;
1077: l_pn_locations_rec.ATTRIBUTE6 := loc.attribute6;
1078: l_pn_locations_rec.ATTRIBUTE7 := loc.attribute7;
1079: l_pn_locations_rec.ATTRIBUTE8 := loc.attribute8;
1080: l_pn_locations_rec.ATTRIBUTE9 := loc.attribute9;
1081: l_pn_locations_rec.ATTRIBUTE10 := loc.attribute10;
1082: l_pn_locations_rec.ATTRIBUTE11 := loc.attribute11;
1083: l_pn_locations_rec.ATTRIBUTE12 := loc.attribute12;
1076: l_pn_locations_rec.ATTRIBUTE5 := loc.attribute5;
1077: l_pn_locations_rec.ATTRIBUTE6 := loc.attribute6;
1078: l_pn_locations_rec.ATTRIBUTE7 := loc.attribute7;
1079: l_pn_locations_rec.ATTRIBUTE8 := loc.attribute8;
1080: l_pn_locations_rec.ATTRIBUTE9 := loc.attribute9;
1081: l_pn_locations_rec.ATTRIBUTE10 := loc.attribute10;
1082: l_pn_locations_rec.ATTRIBUTE11 := loc.attribute11;
1083: l_pn_locations_rec.ATTRIBUTE12 := loc.attribute12;
1084: l_pn_locations_rec.ATTRIBUTE13 := loc.attribute13;
1077: l_pn_locations_rec.ATTRIBUTE6 := loc.attribute6;
1078: l_pn_locations_rec.ATTRIBUTE7 := loc.attribute7;
1079: l_pn_locations_rec.ATTRIBUTE8 := loc.attribute8;
1080: l_pn_locations_rec.ATTRIBUTE9 := loc.attribute9;
1081: l_pn_locations_rec.ATTRIBUTE10 := loc.attribute10;
1082: l_pn_locations_rec.ATTRIBUTE11 := loc.attribute11;
1083: l_pn_locations_rec.ATTRIBUTE12 := loc.attribute12;
1084: l_pn_locations_rec.ATTRIBUTE13 := loc.attribute13;
1085: l_pn_locations_rec.ATTRIBUTE14 := loc.attribute14;
1078: l_pn_locations_rec.ATTRIBUTE7 := loc.attribute7;
1079: l_pn_locations_rec.ATTRIBUTE8 := loc.attribute8;
1080: l_pn_locations_rec.ATTRIBUTE9 := loc.attribute9;
1081: l_pn_locations_rec.ATTRIBUTE10 := loc.attribute10;
1082: l_pn_locations_rec.ATTRIBUTE11 := loc.attribute11;
1083: l_pn_locations_rec.ATTRIBUTE12 := loc.attribute12;
1084: l_pn_locations_rec.ATTRIBUTE13 := loc.attribute13;
1085: l_pn_locations_rec.ATTRIBUTE14 := loc.attribute14;
1086: l_pn_locations_rec.ATTRIBUTE15 := loc.attribute15;
1079: l_pn_locations_rec.ATTRIBUTE8 := loc.attribute8;
1080: l_pn_locations_rec.ATTRIBUTE9 := loc.attribute9;
1081: l_pn_locations_rec.ATTRIBUTE10 := loc.attribute10;
1082: l_pn_locations_rec.ATTRIBUTE11 := loc.attribute11;
1083: l_pn_locations_rec.ATTRIBUTE12 := loc.attribute12;
1084: l_pn_locations_rec.ATTRIBUTE13 := loc.attribute13;
1085: l_pn_locations_rec.ATTRIBUTE14 := loc.attribute14;
1086: l_pn_locations_rec.ATTRIBUTE15 := loc.attribute15;
1087: l_pn_locations_rec.REQUEST_ID := nvl(fnd_profile.value('CONC_REQUEST_ID'), 0);
1080: l_pn_locations_rec.ATTRIBUTE9 := loc.attribute9;
1081: l_pn_locations_rec.ATTRIBUTE10 := loc.attribute10;
1082: l_pn_locations_rec.ATTRIBUTE11 := loc.attribute11;
1083: l_pn_locations_rec.ATTRIBUTE12 := loc.attribute12;
1084: l_pn_locations_rec.ATTRIBUTE13 := loc.attribute13;
1085: l_pn_locations_rec.ATTRIBUTE14 := loc.attribute14;
1086: l_pn_locations_rec.ATTRIBUTE15 := loc.attribute15;
1087: l_pn_locations_rec.REQUEST_ID := nvl(fnd_profile.value('CONC_REQUEST_ID'), 0);
1088: l_pn_locations_rec.PROGRAM_APPLICATION_ID := nvl(fnd_profile.value('CONC_PROGRAM_APPLICATION_ID'), 0);
1081: l_pn_locations_rec.ATTRIBUTE10 := loc.attribute10;
1082: l_pn_locations_rec.ATTRIBUTE11 := loc.attribute11;
1083: l_pn_locations_rec.ATTRIBUTE12 := loc.attribute12;
1084: l_pn_locations_rec.ATTRIBUTE13 := loc.attribute13;
1085: l_pn_locations_rec.ATTRIBUTE14 := loc.attribute14;
1086: l_pn_locations_rec.ATTRIBUTE15 := loc.attribute15;
1087: l_pn_locations_rec.REQUEST_ID := nvl(fnd_profile.value('CONC_REQUEST_ID'), 0);
1088: l_pn_locations_rec.PROGRAM_APPLICATION_ID := nvl(fnd_profile.value('CONC_PROGRAM_APPLICATION_ID'), 0);
1089: l_pn_locations_rec.PROGRAM_ID := nvl(fnd_profile.value('CONC_PROGRAM_ID'), 0);
1082: l_pn_locations_rec.ATTRIBUTE11 := loc.attribute11;
1083: l_pn_locations_rec.ATTRIBUTE12 := loc.attribute12;
1084: l_pn_locations_rec.ATTRIBUTE13 := loc.attribute13;
1085: l_pn_locations_rec.ATTRIBUTE14 := loc.attribute14;
1086: l_pn_locations_rec.ATTRIBUTE15 := loc.attribute15;
1087: l_pn_locations_rec.REQUEST_ID := nvl(fnd_profile.value('CONC_REQUEST_ID'), 0);
1088: l_pn_locations_rec.PROGRAM_APPLICATION_ID := nvl(fnd_profile.value('CONC_PROGRAM_APPLICATION_ID'), 0);
1089: l_pn_locations_rec.PROGRAM_ID := nvl(fnd_profile.value('CONC_PROGRAM_ID'), 0);
1090: l_pn_locations_rec.PROGRAM_UPDATE_DATE := sysdate ;
1083: l_pn_locations_rec.ATTRIBUTE12 := loc.attribute12;
1084: l_pn_locations_rec.ATTRIBUTE13 := loc.attribute13;
1085: l_pn_locations_rec.ATTRIBUTE14 := loc.attribute14;
1086: l_pn_locations_rec.ATTRIBUTE15 := loc.attribute15;
1087: l_pn_locations_rec.REQUEST_ID := nvl(fnd_profile.value('CONC_REQUEST_ID'), 0);
1088: l_pn_locations_rec.PROGRAM_APPLICATION_ID := nvl(fnd_profile.value('CONC_PROGRAM_APPLICATION_ID'), 0);
1089: l_pn_locations_rec.PROGRAM_ID := nvl(fnd_profile.value('CONC_PROGRAM_ID'), 0);
1090: l_pn_locations_rec.PROGRAM_UPDATE_DATE := sysdate ;
1091: l_pn_locations_rec.FUNCTION_TYPE_LOOKUP_CODE := loc.FUNCTION_TYPE_LOOKUP_CODE;
1084: l_pn_locations_rec.ATTRIBUTE13 := loc.attribute13;
1085: l_pn_locations_rec.ATTRIBUTE14 := loc.attribute14;
1086: l_pn_locations_rec.ATTRIBUTE15 := loc.attribute15;
1087: l_pn_locations_rec.REQUEST_ID := nvl(fnd_profile.value('CONC_REQUEST_ID'), 0);
1088: l_pn_locations_rec.PROGRAM_APPLICATION_ID := nvl(fnd_profile.value('CONC_PROGRAM_APPLICATION_ID'), 0);
1089: l_pn_locations_rec.PROGRAM_ID := nvl(fnd_profile.value('CONC_PROGRAM_ID'), 0);
1090: l_pn_locations_rec.PROGRAM_UPDATE_DATE := sysdate ;
1091: l_pn_locations_rec.FUNCTION_TYPE_LOOKUP_CODE := loc.FUNCTION_TYPE_LOOKUP_CODE;
1092: l_pn_locations_rec.LOCATION_ALIAS := loc.Location_Alias;
1085: l_pn_locations_rec.ATTRIBUTE14 := loc.attribute14;
1086: l_pn_locations_rec.ATTRIBUTE15 := loc.attribute15;
1087: l_pn_locations_rec.REQUEST_ID := nvl(fnd_profile.value('CONC_REQUEST_ID'), 0);
1088: l_pn_locations_rec.PROGRAM_APPLICATION_ID := nvl(fnd_profile.value('CONC_PROGRAM_APPLICATION_ID'), 0);
1089: l_pn_locations_rec.PROGRAM_ID := nvl(fnd_profile.value('CONC_PROGRAM_ID'), 0);
1090: l_pn_locations_rec.PROGRAM_UPDATE_DATE := sysdate ;
1091: l_pn_locations_rec.FUNCTION_TYPE_LOOKUP_CODE := loc.FUNCTION_TYPE_LOOKUP_CODE;
1092: l_pn_locations_rec.LOCATION_ALIAS := loc.Location_Alias;
1093: l_pn_locations_rec.PROPERTY_ID := loc.Property_Id;
1086: l_pn_locations_rec.ATTRIBUTE15 := loc.attribute15;
1087: l_pn_locations_rec.REQUEST_ID := nvl(fnd_profile.value('CONC_REQUEST_ID'), 0);
1088: l_pn_locations_rec.PROGRAM_APPLICATION_ID := nvl(fnd_profile.value('CONC_PROGRAM_APPLICATION_ID'), 0);
1089: l_pn_locations_rec.PROGRAM_ID := nvl(fnd_profile.value('CONC_PROGRAM_ID'), 0);
1090: l_pn_locations_rec.PROGRAM_UPDATE_DATE := sysdate ;
1091: l_pn_locations_rec.FUNCTION_TYPE_LOOKUP_CODE := loc.FUNCTION_TYPE_LOOKUP_CODE;
1092: l_pn_locations_rec.LOCATION_ALIAS := loc.Location_Alias;
1093: l_pn_locations_rec.PROPERTY_ID := loc.Property_Id;
1094: l_pn_locations_rec.STANDARD_TYPE_LOOKUP_CODE := loc.STANDARD_TYPE_LOOKUP_CODE;
1087: l_pn_locations_rec.REQUEST_ID := nvl(fnd_profile.value('CONC_REQUEST_ID'), 0);
1088: l_pn_locations_rec.PROGRAM_APPLICATION_ID := nvl(fnd_profile.value('CONC_PROGRAM_APPLICATION_ID'), 0);
1089: l_pn_locations_rec.PROGRAM_ID := nvl(fnd_profile.value('CONC_PROGRAM_ID'), 0);
1090: l_pn_locations_rec.PROGRAM_UPDATE_DATE := sysdate ;
1091: l_pn_locations_rec.FUNCTION_TYPE_LOOKUP_CODE := loc.FUNCTION_TYPE_LOOKUP_CODE;
1092: l_pn_locations_rec.LOCATION_ALIAS := loc.Location_Alias;
1093: l_pn_locations_rec.PROPERTY_ID := loc.Property_Id;
1094: l_pn_locations_rec.STANDARD_TYPE_LOOKUP_CODE := loc.STANDARD_TYPE_LOOKUP_CODE;
1095: l_pn_locations_rec.ACTIVE_START_DATE := trunc(NVL(loc.new_active_start_date,
1088: l_pn_locations_rec.PROGRAM_APPLICATION_ID := nvl(fnd_profile.value('CONC_PROGRAM_APPLICATION_ID'), 0);
1089: l_pn_locations_rec.PROGRAM_ID := nvl(fnd_profile.value('CONC_PROGRAM_ID'), 0);
1090: l_pn_locations_rec.PROGRAM_UPDATE_DATE := sysdate ;
1091: l_pn_locations_rec.FUNCTION_TYPE_LOOKUP_CODE := loc.FUNCTION_TYPE_LOOKUP_CODE;
1092: l_pn_locations_rec.LOCATION_ALIAS := loc.Location_Alias;
1093: l_pn_locations_rec.PROPERTY_ID := loc.Property_Id;
1094: l_pn_locations_rec.STANDARD_TYPE_LOOKUP_CODE := loc.STANDARD_TYPE_LOOKUP_CODE;
1095: l_pn_locations_rec.ACTIVE_START_DATE := trunc(NVL(loc.new_active_start_date,
1096: loc.active_start_date));
1089: l_pn_locations_rec.PROGRAM_ID := nvl(fnd_profile.value('CONC_PROGRAM_ID'), 0);
1090: l_pn_locations_rec.PROGRAM_UPDATE_DATE := sysdate ;
1091: l_pn_locations_rec.FUNCTION_TYPE_LOOKUP_CODE := loc.FUNCTION_TYPE_LOOKUP_CODE;
1092: l_pn_locations_rec.LOCATION_ALIAS := loc.Location_Alias;
1093: l_pn_locations_rec.PROPERTY_ID := loc.Property_Id;
1094: l_pn_locations_rec.STANDARD_TYPE_LOOKUP_CODE := loc.STANDARD_TYPE_LOOKUP_CODE;
1095: l_pn_locations_rec.ACTIVE_START_DATE := trunc(NVL(loc.new_active_start_date,
1096: loc.active_start_date));
1097: l_pn_locations_rec.ACTIVE_END_DATE := trunc(NVL(loc.new_active_end_date,
1090: l_pn_locations_rec.PROGRAM_UPDATE_DATE := sysdate ;
1091: l_pn_locations_rec.FUNCTION_TYPE_LOOKUP_CODE := loc.FUNCTION_TYPE_LOOKUP_CODE;
1092: l_pn_locations_rec.LOCATION_ALIAS := loc.Location_Alias;
1093: l_pn_locations_rec.PROPERTY_ID := loc.Property_Id;
1094: l_pn_locations_rec.STANDARD_TYPE_LOOKUP_CODE := loc.STANDARD_TYPE_LOOKUP_CODE;
1095: l_pn_locations_rec.ACTIVE_START_DATE := trunc(NVL(loc.new_active_start_date,
1096: loc.active_start_date));
1097: l_pn_locations_rec.ACTIVE_END_DATE := trunc(NVL(loc.new_active_end_date,
1098: loc.active_end_date));
1091: l_pn_locations_rec.FUNCTION_TYPE_LOOKUP_CODE := loc.FUNCTION_TYPE_LOOKUP_CODE;
1092: l_pn_locations_rec.LOCATION_ALIAS := loc.Location_Alias;
1093: l_pn_locations_rec.PROPERTY_ID := loc.Property_Id;
1094: l_pn_locations_rec.STANDARD_TYPE_LOOKUP_CODE := loc.STANDARD_TYPE_LOOKUP_CODE;
1095: l_pn_locations_rec.ACTIVE_START_DATE := trunc(NVL(loc.new_active_start_date,
1096: loc.active_start_date));
1097: l_pn_locations_rec.ACTIVE_END_DATE := trunc(NVL(loc.new_active_end_date,
1098: loc.active_end_date));
1099: --Used trunc() :Bug 6009957
1093: l_pn_locations_rec.PROPERTY_ID := loc.Property_Id;
1094: l_pn_locations_rec.STANDARD_TYPE_LOOKUP_CODE := loc.STANDARD_TYPE_LOOKUP_CODE;
1095: l_pn_locations_rec.ACTIVE_START_DATE := trunc(NVL(loc.new_active_start_date,
1096: loc.active_start_date));
1097: l_pn_locations_rec.ACTIVE_END_DATE := trunc(NVL(loc.new_active_end_date,
1098: loc.active_end_date));
1099: --Used trunc() :Bug 6009957
1100: l_pn_locations_rec.address_id := v_loc_rec.address_id;
1101: l_pn_locations_rec.source := loc.source;
1096: loc.active_start_date));
1097: l_pn_locations_rec.ACTIVE_END_DATE := trunc(NVL(loc.new_active_end_date,
1098: loc.active_end_date));
1099: --Used trunc() :Bug 6009957
1100: l_pn_locations_rec.address_id := v_loc_rec.address_id;
1101: l_pn_locations_rec.source := loc.source;
1102:
1103: /* populate the address_rec */
1104:
1097: l_pn_locations_rec.ACTIVE_END_DATE := trunc(NVL(loc.new_active_end_date,
1098: loc.active_end_date));
1099: --Used trunc() :Bug 6009957
1100: l_pn_locations_rec.address_id := v_loc_rec.address_id;
1101: l_pn_locations_rec.source := loc.source;
1102:
1103: /* populate the address_rec */
1104:
1105: l_pn_addresses_rec.ADDRESS_LINE1 := loc.address_line1;
1136: put_log( 'U: Just before Correct/Update');
1137:
1138: --Used trunc() :Bug 6009957
1139: PNT_LOCATIONS_PKG.correct_update_row
1140: ( p_pn_locations_rec => l_pn_locations_rec,
1141: p_pn_addresses_rec => l_pn_addresses_rec,
1142: p_change_mode => nvl(loc.change_mode, 'CORRECT'),
1143: p_as_of_date => loc.change_date,
1144: p_active_start_date_old => trunc(loc.active_start_date),
1167: ELSIF (loc.ENTRY_TYPE = 'R') THEN
1168:
1169: BEGIN
1170: --------------------------------------
1171: -- Update Data in PN_LOCATIONS
1172: --------------------------------------
1173: l_active_end_date := trunc(v_loc_rec.active_end_date); --Used trunc() :Bug 6009957
1174:
1175: put_log('R: Building the locations record');
1172: --------------------------------------
1173: l_active_end_date := trunc(v_loc_rec.active_end_date); --Used trunc() :Bug 6009957
1174:
1175: put_log('R: Building the locations record');
1176: l_pn_locations_rec.location_id := loc.location_id;
1177: l_pn_locations_rec.ORG_ID := l_org_id;
1178: l_pn_locations_rec.LOCATION_CODE := nvl( loc.location_code, v_loc_rec.location_code);
1179: l_pn_locations_rec.LOCATION_TYPE_LOOKUP_CODE :=
1180: nvl(loc.location_type_lookup_code, v_loc_rec.location_type_lookup_code);
1173: l_active_end_date := trunc(v_loc_rec.active_end_date); --Used trunc() :Bug 6009957
1174:
1175: put_log('R: Building the locations record');
1176: l_pn_locations_rec.location_id := loc.location_id;
1177: l_pn_locations_rec.ORG_ID := l_org_id;
1178: l_pn_locations_rec.LOCATION_CODE := nvl( loc.location_code, v_loc_rec.location_code);
1179: l_pn_locations_rec.LOCATION_TYPE_LOOKUP_CODE :=
1180: nvl(loc.location_type_lookup_code, v_loc_rec.location_type_lookup_code);
1181: l_pn_locations_rec.SPACE_TYPE_LOOKUP_CODE :=
1174:
1175: put_log('R: Building the locations record');
1176: l_pn_locations_rec.location_id := loc.location_id;
1177: l_pn_locations_rec.ORG_ID := l_org_id;
1178: l_pn_locations_rec.LOCATION_CODE := nvl( loc.location_code, v_loc_rec.location_code);
1179: l_pn_locations_rec.LOCATION_TYPE_LOOKUP_CODE :=
1180: nvl(loc.location_type_lookup_code, v_loc_rec.location_type_lookup_code);
1181: l_pn_locations_rec.SPACE_TYPE_LOOKUP_CODE :=
1182: nvl( loc.space_type_lookup_code, v_loc_rec.space_type_lookup_code);
1175: put_log('R: Building the locations record');
1176: l_pn_locations_rec.location_id := loc.location_id;
1177: l_pn_locations_rec.ORG_ID := l_org_id;
1178: l_pn_locations_rec.LOCATION_CODE := nvl( loc.location_code, v_loc_rec.location_code);
1179: l_pn_locations_rec.LOCATION_TYPE_LOOKUP_CODE :=
1180: nvl(loc.location_type_lookup_code, v_loc_rec.location_type_lookup_code);
1181: l_pn_locations_rec.SPACE_TYPE_LOOKUP_CODE :=
1182: nvl( loc.space_type_lookup_code, v_loc_rec.space_type_lookup_code);
1183: l_pn_locations_rec.LAST_UPDATE_DATE := sysdate;
1177: l_pn_locations_rec.ORG_ID := l_org_id;
1178: l_pn_locations_rec.LOCATION_CODE := nvl( loc.location_code, v_loc_rec.location_code);
1179: l_pn_locations_rec.LOCATION_TYPE_LOOKUP_CODE :=
1180: nvl(loc.location_type_lookup_code, v_loc_rec.location_type_lookup_code);
1181: l_pn_locations_rec.SPACE_TYPE_LOOKUP_CODE :=
1182: nvl( loc.space_type_lookup_code, v_loc_rec.space_type_lookup_code);
1183: l_pn_locations_rec.LAST_UPDATE_DATE := sysdate;
1184: l_pn_locations_rec.PARENT_LOCATION_ID :=
1185: nvl( loc.parent_location_id, v_loc_rec.parent_location_id);
1179: l_pn_locations_rec.LOCATION_TYPE_LOOKUP_CODE :=
1180: nvl(loc.location_type_lookup_code, v_loc_rec.location_type_lookup_code);
1181: l_pn_locations_rec.SPACE_TYPE_LOOKUP_CODE :=
1182: nvl( loc.space_type_lookup_code, v_loc_rec.space_type_lookup_code);
1183: l_pn_locations_rec.LAST_UPDATE_DATE := sysdate;
1184: l_pn_locations_rec.PARENT_LOCATION_ID :=
1185: nvl( loc.parent_location_id, v_loc_rec.parent_location_id);
1186: l_pn_locations_rec.LEASE_OR_OWNED := nvl( loc.lease_or_owned, v_loc_rec.lease_or_owned);
1187: l_pn_locations_rec.BUILDING := nvl( loc.building, v_loc_rec.building);
1180: nvl(loc.location_type_lookup_code, v_loc_rec.location_type_lookup_code);
1181: l_pn_locations_rec.SPACE_TYPE_LOOKUP_CODE :=
1182: nvl( loc.space_type_lookup_code, v_loc_rec.space_type_lookup_code);
1183: l_pn_locations_rec.LAST_UPDATE_DATE := sysdate;
1184: l_pn_locations_rec.PARENT_LOCATION_ID :=
1185: nvl( loc.parent_location_id, v_loc_rec.parent_location_id);
1186: l_pn_locations_rec.LEASE_OR_OWNED := nvl( loc.lease_or_owned, v_loc_rec.lease_or_owned);
1187: l_pn_locations_rec.BUILDING := nvl( loc.building, v_loc_rec.building);
1188: l_pn_locations_rec.FLOOR := nvl( loc.floor, v_loc_rec.floor);
1182: nvl( loc.space_type_lookup_code, v_loc_rec.space_type_lookup_code);
1183: l_pn_locations_rec.LAST_UPDATE_DATE := sysdate;
1184: l_pn_locations_rec.PARENT_LOCATION_ID :=
1185: nvl( loc.parent_location_id, v_loc_rec.parent_location_id);
1186: l_pn_locations_rec.LEASE_OR_OWNED := nvl( loc.lease_or_owned, v_loc_rec.lease_or_owned);
1187: l_pn_locations_rec.BUILDING := nvl( loc.building, v_loc_rec.building);
1188: l_pn_locations_rec.FLOOR := nvl( loc.floor, v_loc_rec.floor);
1189: l_pn_locations_rec.OFFICE := nvl( loc.office, v_loc_rec.office);
1190: l_pn_locations_rec.MAX_CAPACITY := nvl( loc.max_capacity, v_loc_rec.max_capacity);
1183: l_pn_locations_rec.LAST_UPDATE_DATE := sysdate;
1184: l_pn_locations_rec.PARENT_LOCATION_ID :=
1185: nvl( loc.parent_location_id, v_loc_rec.parent_location_id);
1186: l_pn_locations_rec.LEASE_OR_OWNED := nvl( loc.lease_or_owned, v_loc_rec.lease_or_owned);
1187: l_pn_locations_rec.BUILDING := nvl( loc.building, v_loc_rec.building);
1188: l_pn_locations_rec.FLOOR := nvl( loc.floor, v_loc_rec.floor);
1189: l_pn_locations_rec.OFFICE := nvl( loc.office, v_loc_rec.office);
1190: l_pn_locations_rec.MAX_CAPACITY := nvl( loc.max_capacity, v_loc_rec.max_capacity);
1191: l_pn_locations_rec.OPTIMUM_CAPACITY := nvl( loc.optimum_capacity, v_loc_rec.optimum_capacity);
1184: l_pn_locations_rec.PARENT_LOCATION_ID :=
1185: nvl( loc.parent_location_id, v_loc_rec.parent_location_id);
1186: l_pn_locations_rec.LEASE_OR_OWNED := nvl( loc.lease_or_owned, v_loc_rec.lease_or_owned);
1187: l_pn_locations_rec.BUILDING := nvl( loc.building, v_loc_rec.building);
1188: l_pn_locations_rec.FLOOR := nvl( loc.floor, v_loc_rec.floor);
1189: l_pn_locations_rec.OFFICE := nvl( loc.office, v_loc_rec.office);
1190: l_pn_locations_rec.MAX_CAPACITY := nvl( loc.max_capacity, v_loc_rec.max_capacity);
1191: l_pn_locations_rec.OPTIMUM_CAPACITY := nvl( loc.optimum_capacity, v_loc_rec.optimum_capacity);
1192: l_pn_locations_rec.RENTABLE_AREA := nvl( loc.rentable_area, v_loc_rec.rentable_area);
1185: nvl( loc.parent_location_id, v_loc_rec.parent_location_id);
1186: l_pn_locations_rec.LEASE_OR_OWNED := nvl( loc.lease_or_owned, v_loc_rec.lease_or_owned);
1187: l_pn_locations_rec.BUILDING := nvl( loc.building, v_loc_rec.building);
1188: l_pn_locations_rec.FLOOR := nvl( loc.floor, v_loc_rec.floor);
1189: l_pn_locations_rec.OFFICE := nvl( loc.office, v_loc_rec.office);
1190: l_pn_locations_rec.MAX_CAPACITY := nvl( loc.max_capacity, v_loc_rec.max_capacity);
1191: l_pn_locations_rec.OPTIMUM_CAPACITY := nvl( loc.optimum_capacity, v_loc_rec.optimum_capacity);
1192: l_pn_locations_rec.RENTABLE_AREA := nvl( loc.rentable_area, v_loc_rec.rentable_area);
1193: l_pn_locations_rec.USABLE_AREA := nvl( loc.usable_area, v_loc_rec.usable_area);
1186: l_pn_locations_rec.LEASE_OR_OWNED := nvl( loc.lease_or_owned, v_loc_rec.lease_or_owned);
1187: l_pn_locations_rec.BUILDING := nvl( loc.building, v_loc_rec.building);
1188: l_pn_locations_rec.FLOOR := nvl( loc.floor, v_loc_rec.floor);
1189: l_pn_locations_rec.OFFICE := nvl( loc.office, v_loc_rec.office);
1190: l_pn_locations_rec.MAX_CAPACITY := nvl( loc.max_capacity, v_loc_rec.max_capacity);
1191: l_pn_locations_rec.OPTIMUM_CAPACITY := nvl( loc.optimum_capacity, v_loc_rec.optimum_capacity);
1192: l_pn_locations_rec.RENTABLE_AREA := nvl( loc.rentable_area, v_loc_rec.rentable_area);
1193: l_pn_locations_rec.USABLE_AREA := nvl( loc.usable_area, v_loc_rec.usable_area);
1194: l_pn_locations_rec.GROSS_AREA := nvl( loc.gross_area, v_loc_rec.gross_area);
1187: l_pn_locations_rec.BUILDING := nvl( loc.building, v_loc_rec.building);
1188: l_pn_locations_rec.FLOOR := nvl( loc.floor, v_loc_rec.floor);
1189: l_pn_locations_rec.OFFICE := nvl( loc.office, v_loc_rec.office);
1190: l_pn_locations_rec.MAX_CAPACITY := nvl( loc.max_capacity, v_loc_rec.max_capacity);
1191: l_pn_locations_rec.OPTIMUM_CAPACITY := nvl( loc.optimum_capacity, v_loc_rec.optimum_capacity);
1192: l_pn_locations_rec.RENTABLE_AREA := nvl( loc.rentable_area, v_loc_rec.rentable_area);
1193: l_pn_locations_rec.USABLE_AREA := nvl( loc.usable_area, v_loc_rec.usable_area);
1194: l_pn_locations_rec.GROSS_AREA := nvl( loc.gross_area, v_loc_rec.gross_area);
1195: l_pn_locations_rec.ASSIGNABLE_AREA :=
1188: l_pn_locations_rec.FLOOR := nvl( loc.floor, v_loc_rec.floor);
1189: l_pn_locations_rec.OFFICE := nvl( loc.office, v_loc_rec.office);
1190: l_pn_locations_rec.MAX_CAPACITY := nvl( loc.max_capacity, v_loc_rec.max_capacity);
1191: l_pn_locations_rec.OPTIMUM_CAPACITY := nvl( loc.optimum_capacity, v_loc_rec.optimum_capacity);
1192: l_pn_locations_rec.RENTABLE_AREA := nvl( loc.rentable_area, v_loc_rec.rentable_area);
1193: l_pn_locations_rec.USABLE_AREA := nvl( loc.usable_area, v_loc_rec.usable_area);
1194: l_pn_locations_rec.GROSS_AREA := nvl( loc.gross_area, v_loc_rec.gross_area);
1195: l_pn_locations_rec.ASSIGNABLE_AREA :=
1196: nvl( loc.assignable_area, v_loc_rec.assignable_area);
1189: l_pn_locations_rec.OFFICE := nvl( loc.office, v_loc_rec.office);
1190: l_pn_locations_rec.MAX_CAPACITY := nvl( loc.max_capacity, v_loc_rec.max_capacity);
1191: l_pn_locations_rec.OPTIMUM_CAPACITY := nvl( loc.optimum_capacity, v_loc_rec.optimum_capacity);
1192: l_pn_locations_rec.RENTABLE_AREA := nvl( loc.rentable_area, v_loc_rec.rentable_area);
1193: l_pn_locations_rec.USABLE_AREA := nvl( loc.usable_area, v_loc_rec.usable_area);
1194: l_pn_locations_rec.GROSS_AREA := nvl( loc.gross_area, v_loc_rec.gross_area);
1195: l_pn_locations_rec.ASSIGNABLE_AREA :=
1196: nvl( loc.assignable_area, v_loc_rec.assignable_area);
1197: l_pn_locations_rec.COMMON_AREA := nvl( loc.common_area, v_loc_rec.common_area);
1190: l_pn_locations_rec.MAX_CAPACITY := nvl( loc.max_capacity, v_loc_rec.max_capacity);
1191: l_pn_locations_rec.OPTIMUM_CAPACITY := nvl( loc.optimum_capacity, v_loc_rec.optimum_capacity);
1192: l_pn_locations_rec.RENTABLE_AREA := nvl( loc.rentable_area, v_loc_rec.rentable_area);
1193: l_pn_locations_rec.USABLE_AREA := nvl( loc.usable_area, v_loc_rec.usable_area);
1194: l_pn_locations_rec.GROSS_AREA := nvl( loc.gross_area, v_loc_rec.gross_area);
1195: l_pn_locations_rec.ASSIGNABLE_AREA :=
1196: nvl( loc.assignable_area, v_loc_rec.assignable_area);
1197: l_pn_locations_rec.COMMON_AREA := nvl( loc.common_area, v_loc_rec.common_area);
1198: l_pn_locations_rec.COMMON_AREA_FLAG :=
1191: l_pn_locations_rec.OPTIMUM_CAPACITY := nvl( loc.optimum_capacity, v_loc_rec.optimum_capacity);
1192: l_pn_locations_rec.RENTABLE_AREA := nvl( loc.rentable_area, v_loc_rec.rentable_area);
1193: l_pn_locations_rec.USABLE_AREA := nvl( loc.usable_area, v_loc_rec.usable_area);
1194: l_pn_locations_rec.GROSS_AREA := nvl( loc.gross_area, v_loc_rec.gross_area);
1195: l_pn_locations_rec.ASSIGNABLE_AREA :=
1196: nvl( loc.assignable_area, v_loc_rec.assignable_area);
1197: l_pn_locations_rec.COMMON_AREA := nvl( loc.common_area, v_loc_rec.common_area);
1198: l_pn_locations_rec.COMMON_AREA_FLAG :=
1199: nvl( loc.common_area_flag, v_loc_rec.common_area_flag);
1193: l_pn_locations_rec.USABLE_AREA := nvl( loc.usable_area, v_loc_rec.usable_area);
1194: l_pn_locations_rec.GROSS_AREA := nvl( loc.gross_area, v_loc_rec.gross_area);
1195: l_pn_locations_rec.ASSIGNABLE_AREA :=
1196: nvl( loc.assignable_area, v_loc_rec.assignable_area);
1197: l_pn_locations_rec.COMMON_AREA := nvl( loc.common_area, v_loc_rec.common_area);
1198: l_pn_locations_rec.COMMON_AREA_FLAG :=
1199: nvl( loc.common_area_flag, v_loc_rec.common_area_flag);
1200: l_pn_locations_rec.CLASS := nvl( loc.class, v_loc_rec.class);
1201: l_pn_locations_rec.STATUS_TYPE := nvl( loc.status_type, v_loc_rec.status_type);
1194: l_pn_locations_rec.GROSS_AREA := nvl( loc.gross_area, v_loc_rec.gross_area);
1195: l_pn_locations_rec.ASSIGNABLE_AREA :=
1196: nvl( loc.assignable_area, v_loc_rec.assignable_area);
1197: l_pn_locations_rec.COMMON_AREA := nvl( loc.common_area, v_loc_rec.common_area);
1198: l_pn_locations_rec.COMMON_AREA_FLAG :=
1199: nvl( loc.common_area_flag, v_loc_rec.common_area_flag);
1200: l_pn_locations_rec.CLASS := nvl( loc.class, v_loc_rec.class);
1201: l_pn_locations_rec.STATUS_TYPE := nvl( loc.status_type, v_loc_rec.status_type);
1202: l_pn_locations_rec.STATUS := v_loc_rec.status;
1196: nvl( loc.assignable_area, v_loc_rec.assignable_area);
1197: l_pn_locations_rec.COMMON_AREA := nvl( loc.common_area, v_loc_rec.common_area);
1198: l_pn_locations_rec.COMMON_AREA_FLAG :=
1199: nvl( loc.common_area_flag, v_loc_rec.common_area_flag);
1200: l_pn_locations_rec.CLASS := nvl( loc.class, v_loc_rec.class);
1201: l_pn_locations_rec.STATUS_TYPE := nvl( loc.status_type, v_loc_rec.status_type);
1202: l_pn_locations_rec.STATUS := v_loc_rec.status;
1203: l_pn_locations_rec.SUITE := nvl( loc.suite, v_loc_rec.suite);
1204: l_pn_locations_rec.ALLOCATE_COST_CENTER_CODE :=
1197: l_pn_locations_rec.COMMON_AREA := nvl( loc.common_area, v_loc_rec.common_area);
1198: l_pn_locations_rec.COMMON_AREA_FLAG :=
1199: nvl( loc.common_area_flag, v_loc_rec.common_area_flag);
1200: l_pn_locations_rec.CLASS := nvl( loc.class, v_loc_rec.class);
1201: l_pn_locations_rec.STATUS_TYPE := nvl( loc.status_type, v_loc_rec.status_type);
1202: l_pn_locations_rec.STATUS := v_loc_rec.status;
1203: l_pn_locations_rec.SUITE := nvl( loc.suite, v_loc_rec.suite);
1204: l_pn_locations_rec.ALLOCATE_COST_CENTER_CODE :=
1205: nvl( loc.allocate_cost_center_code, v_loc_rec.allocate_cost_center_code);
1198: l_pn_locations_rec.COMMON_AREA_FLAG :=
1199: nvl( loc.common_area_flag, v_loc_rec.common_area_flag);
1200: l_pn_locations_rec.CLASS := nvl( loc.class, v_loc_rec.class);
1201: l_pn_locations_rec.STATUS_TYPE := nvl( loc.status_type, v_loc_rec.status_type);
1202: l_pn_locations_rec.STATUS := v_loc_rec.status;
1203: l_pn_locations_rec.SUITE := nvl( loc.suite, v_loc_rec.suite);
1204: l_pn_locations_rec.ALLOCATE_COST_CENTER_CODE :=
1205: nvl( loc.allocate_cost_center_code, v_loc_rec.allocate_cost_center_code);
1206: l_pn_locations_rec.UOM_CODE := nvl( loc.uom_code, v_loc_rec.uom_code);
1199: nvl( loc.common_area_flag, v_loc_rec.common_area_flag);
1200: l_pn_locations_rec.CLASS := nvl( loc.class, v_loc_rec.class);
1201: l_pn_locations_rec.STATUS_TYPE := nvl( loc.status_type, v_loc_rec.status_type);
1202: l_pn_locations_rec.STATUS := v_loc_rec.status;
1203: l_pn_locations_rec.SUITE := nvl( loc.suite, v_loc_rec.suite);
1204: l_pn_locations_rec.ALLOCATE_COST_CENTER_CODE :=
1205: nvl( loc.allocate_cost_center_code, v_loc_rec.allocate_cost_center_code);
1206: l_pn_locations_rec.UOM_CODE := nvl( loc.uom_code, v_loc_rec.uom_code);
1207: l_pn_locations_rec.LAST_UPDATE_LOGIN := nvl( fnd_profile.value('CONC_LOGIN_ID'), 0);
1200: l_pn_locations_rec.CLASS := nvl( loc.class, v_loc_rec.class);
1201: l_pn_locations_rec.STATUS_TYPE := nvl( loc.status_type, v_loc_rec.status_type);
1202: l_pn_locations_rec.STATUS := v_loc_rec.status;
1203: l_pn_locations_rec.SUITE := nvl( loc.suite, v_loc_rec.suite);
1204: l_pn_locations_rec.ALLOCATE_COST_CENTER_CODE :=
1205: nvl( loc.allocate_cost_center_code, v_loc_rec.allocate_cost_center_code);
1206: l_pn_locations_rec.UOM_CODE := nvl( loc.uom_code, v_loc_rec.uom_code);
1207: l_pn_locations_rec.LAST_UPDATE_LOGIN := nvl( fnd_profile.value('CONC_LOGIN_ID'), 0);
1208: l_pn_locations_rec.LAST_UPDATED_BY := nvl( fnd_profile.value('CONC_USER_ID'), 0);
1202: l_pn_locations_rec.STATUS := v_loc_rec.status;
1203: l_pn_locations_rec.SUITE := nvl( loc.suite, v_loc_rec.suite);
1204: l_pn_locations_rec.ALLOCATE_COST_CENTER_CODE :=
1205: nvl( loc.allocate_cost_center_code, v_loc_rec.allocate_cost_center_code);
1206: l_pn_locations_rec.UOM_CODE := nvl( loc.uom_code, v_loc_rec.uom_code);
1207: l_pn_locations_rec.LAST_UPDATE_LOGIN := nvl( fnd_profile.value('CONC_LOGIN_ID'), 0);
1208: l_pn_locations_rec.LAST_UPDATED_BY := nvl( fnd_profile.value('CONC_USER_ID'), 0);
1209: l_pn_locations_rec.ATTRIBUTE_CATEGORY :=
1210: nvl( loc.attribute_category, v_loc_rec.attribute_category);
1203: l_pn_locations_rec.SUITE := nvl( loc.suite, v_loc_rec.suite);
1204: l_pn_locations_rec.ALLOCATE_COST_CENTER_CODE :=
1205: nvl( loc.allocate_cost_center_code, v_loc_rec.allocate_cost_center_code);
1206: l_pn_locations_rec.UOM_CODE := nvl( loc.uom_code, v_loc_rec.uom_code);
1207: l_pn_locations_rec.LAST_UPDATE_LOGIN := nvl( fnd_profile.value('CONC_LOGIN_ID'), 0);
1208: l_pn_locations_rec.LAST_UPDATED_BY := nvl( fnd_profile.value('CONC_USER_ID'), 0);
1209: l_pn_locations_rec.ATTRIBUTE_CATEGORY :=
1210: nvl( loc.attribute_category, v_loc_rec.attribute_category);
1211: l_pn_locations_rec.ATTRIBUTE1 := nvl( loc.attribute1, v_loc_rec.attribute1);
1204: l_pn_locations_rec.ALLOCATE_COST_CENTER_CODE :=
1205: nvl( loc.allocate_cost_center_code, v_loc_rec.allocate_cost_center_code);
1206: l_pn_locations_rec.UOM_CODE := nvl( loc.uom_code, v_loc_rec.uom_code);
1207: l_pn_locations_rec.LAST_UPDATE_LOGIN := nvl( fnd_profile.value('CONC_LOGIN_ID'), 0);
1208: l_pn_locations_rec.LAST_UPDATED_BY := nvl( fnd_profile.value('CONC_USER_ID'), 0);
1209: l_pn_locations_rec.ATTRIBUTE_CATEGORY :=
1210: nvl( loc.attribute_category, v_loc_rec.attribute_category);
1211: l_pn_locations_rec.ATTRIBUTE1 := nvl( loc.attribute1, v_loc_rec.attribute1);
1212: l_pn_locations_rec.ATTRIBUTE2 := nvl( loc.attribute2, v_loc_rec.attribute2);
1205: nvl( loc.allocate_cost_center_code, v_loc_rec.allocate_cost_center_code);
1206: l_pn_locations_rec.UOM_CODE := nvl( loc.uom_code, v_loc_rec.uom_code);
1207: l_pn_locations_rec.LAST_UPDATE_LOGIN := nvl( fnd_profile.value('CONC_LOGIN_ID'), 0);
1208: l_pn_locations_rec.LAST_UPDATED_BY := nvl( fnd_profile.value('CONC_USER_ID'), 0);
1209: l_pn_locations_rec.ATTRIBUTE_CATEGORY :=
1210: nvl( loc.attribute_category, v_loc_rec.attribute_category);
1211: l_pn_locations_rec.ATTRIBUTE1 := nvl( loc.attribute1, v_loc_rec.attribute1);
1212: l_pn_locations_rec.ATTRIBUTE2 := nvl( loc.attribute2, v_loc_rec.attribute2);
1213: l_pn_locations_rec.ATTRIBUTE3 := nvl( loc.attribute3, v_loc_rec.attribute3);
1207: l_pn_locations_rec.LAST_UPDATE_LOGIN := nvl( fnd_profile.value('CONC_LOGIN_ID'), 0);
1208: l_pn_locations_rec.LAST_UPDATED_BY := nvl( fnd_profile.value('CONC_USER_ID'), 0);
1209: l_pn_locations_rec.ATTRIBUTE_CATEGORY :=
1210: nvl( loc.attribute_category, v_loc_rec.attribute_category);
1211: l_pn_locations_rec.ATTRIBUTE1 := nvl( loc.attribute1, v_loc_rec.attribute1);
1212: l_pn_locations_rec.ATTRIBUTE2 := nvl( loc.attribute2, v_loc_rec.attribute2);
1213: l_pn_locations_rec.ATTRIBUTE3 := nvl( loc.attribute3, v_loc_rec.attribute3);
1214: l_pn_locations_rec.ATTRIBUTE4 := nvl( loc.attribute4, v_loc_rec.attribute4);
1215: l_pn_locations_rec.ATTRIBUTE5 := nvl( loc.attribute5, v_loc_rec.attribute5);
1208: l_pn_locations_rec.LAST_UPDATED_BY := nvl( fnd_profile.value('CONC_USER_ID'), 0);
1209: l_pn_locations_rec.ATTRIBUTE_CATEGORY :=
1210: nvl( loc.attribute_category, v_loc_rec.attribute_category);
1211: l_pn_locations_rec.ATTRIBUTE1 := nvl( loc.attribute1, v_loc_rec.attribute1);
1212: l_pn_locations_rec.ATTRIBUTE2 := nvl( loc.attribute2, v_loc_rec.attribute2);
1213: l_pn_locations_rec.ATTRIBUTE3 := nvl( loc.attribute3, v_loc_rec.attribute3);
1214: l_pn_locations_rec.ATTRIBUTE4 := nvl( loc.attribute4, v_loc_rec.attribute4);
1215: l_pn_locations_rec.ATTRIBUTE5 := nvl( loc.attribute5, v_loc_rec.attribute5);
1216: l_pn_locations_rec.ATTRIBUTE6 := nvl( loc.attribute6, v_loc_rec.attribute6);
1209: l_pn_locations_rec.ATTRIBUTE_CATEGORY :=
1210: nvl( loc.attribute_category, v_loc_rec.attribute_category);
1211: l_pn_locations_rec.ATTRIBUTE1 := nvl( loc.attribute1, v_loc_rec.attribute1);
1212: l_pn_locations_rec.ATTRIBUTE2 := nvl( loc.attribute2, v_loc_rec.attribute2);
1213: l_pn_locations_rec.ATTRIBUTE3 := nvl( loc.attribute3, v_loc_rec.attribute3);
1214: l_pn_locations_rec.ATTRIBUTE4 := nvl( loc.attribute4, v_loc_rec.attribute4);
1215: l_pn_locations_rec.ATTRIBUTE5 := nvl( loc.attribute5, v_loc_rec.attribute5);
1216: l_pn_locations_rec.ATTRIBUTE6 := nvl( loc.attribute6, v_loc_rec.attribute6);
1217: l_pn_locations_rec.ATTRIBUTE7 := nvl( loc.attribute7, v_loc_rec.attribute7);
1210: nvl( loc.attribute_category, v_loc_rec.attribute_category);
1211: l_pn_locations_rec.ATTRIBUTE1 := nvl( loc.attribute1, v_loc_rec.attribute1);
1212: l_pn_locations_rec.ATTRIBUTE2 := nvl( loc.attribute2, v_loc_rec.attribute2);
1213: l_pn_locations_rec.ATTRIBUTE3 := nvl( loc.attribute3, v_loc_rec.attribute3);
1214: l_pn_locations_rec.ATTRIBUTE4 := nvl( loc.attribute4, v_loc_rec.attribute4);
1215: l_pn_locations_rec.ATTRIBUTE5 := nvl( loc.attribute5, v_loc_rec.attribute5);
1216: l_pn_locations_rec.ATTRIBUTE6 := nvl( loc.attribute6, v_loc_rec.attribute6);
1217: l_pn_locations_rec.ATTRIBUTE7 := nvl( loc.attribute7, v_loc_rec.attribute7);
1218: l_pn_locations_rec.ATTRIBUTE8 := nvl( loc.attribute8, v_loc_rec.attribute8);
1211: l_pn_locations_rec.ATTRIBUTE1 := nvl( loc.attribute1, v_loc_rec.attribute1);
1212: l_pn_locations_rec.ATTRIBUTE2 := nvl( loc.attribute2, v_loc_rec.attribute2);
1213: l_pn_locations_rec.ATTRIBUTE3 := nvl( loc.attribute3, v_loc_rec.attribute3);
1214: l_pn_locations_rec.ATTRIBUTE4 := nvl( loc.attribute4, v_loc_rec.attribute4);
1215: l_pn_locations_rec.ATTRIBUTE5 := nvl( loc.attribute5, v_loc_rec.attribute5);
1216: l_pn_locations_rec.ATTRIBUTE6 := nvl( loc.attribute6, v_loc_rec.attribute6);
1217: l_pn_locations_rec.ATTRIBUTE7 := nvl( loc.attribute7, v_loc_rec.attribute7);
1218: l_pn_locations_rec.ATTRIBUTE8 := nvl( loc.attribute8, v_loc_rec.attribute8);
1219: l_pn_locations_rec.ATTRIBUTE9 := nvl( loc.attribute9, v_loc_rec.attribute9);
1212: l_pn_locations_rec.ATTRIBUTE2 := nvl( loc.attribute2, v_loc_rec.attribute2);
1213: l_pn_locations_rec.ATTRIBUTE3 := nvl( loc.attribute3, v_loc_rec.attribute3);
1214: l_pn_locations_rec.ATTRIBUTE4 := nvl( loc.attribute4, v_loc_rec.attribute4);
1215: l_pn_locations_rec.ATTRIBUTE5 := nvl( loc.attribute5, v_loc_rec.attribute5);
1216: l_pn_locations_rec.ATTRIBUTE6 := nvl( loc.attribute6, v_loc_rec.attribute6);
1217: l_pn_locations_rec.ATTRIBUTE7 := nvl( loc.attribute7, v_loc_rec.attribute7);
1218: l_pn_locations_rec.ATTRIBUTE8 := nvl( loc.attribute8, v_loc_rec.attribute8);
1219: l_pn_locations_rec.ATTRIBUTE9 := nvl( loc.attribute9, v_loc_rec.attribute9);
1220: l_pn_locations_rec.ATTRIBUTE10 := nvl( loc.attribute10, v_loc_rec.attribute10);
1213: l_pn_locations_rec.ATTRIBUTE3 := nvl( loc.attribute3, v_loc_rec.attribute3);
1214: l_pn_locations_rec.ATTRIBUTE4 := nvl( loc.attribute4, v_loc_rec.attribute4);
1215: l_pn_locations_rec.ATTRIBUTE5 := nvl( loc.attribute5, v_loc_rec.attribute5);
1216: l_pn_locations_rec.ATTRIBUTE6 := nvl( loc.attribute6, v_loc_rec.attribute6);
1217: l_pn_locations_rec.ATTRIBUTE7 := nvl( loc.attribute7, v_loc_rec.attribute7);
1218: l_pn_locations_rec.ATTRIBUTE8 := nvl( loc.attribute8, v_loc_rec.attribute8);
1219: l_pn_locations_rec.ATTRIBUTE9 := nvl( loc.attribute9, v_loc_rec.attribute9);
1220: l_pn_locations_rec.ATTRIBUTE10 := nvl( loc.attribute10, v_loc_rec.attribute10);
1221: l_pn_locations_rec.ATTRIBUTE11 := nvl( loc.attribute11, v_loc_rec.attribute11);
1214: l_pn_locations_rec.ATTRIBUTE4 := nvl( loc.attribute4, v_loc_rec.attribute4);
1215: l_pn_locations_rec.ATTRIBUTE5 := nvl( loc.attribute5, v_loc_rec.attribute5);
1216: l_pn_locations_rec.ATTRIBUTE6 := nvl( loc.attribute6, v_loc_rec.attribute6);
1217: l_pn_locations_rec.ATTRIBUTE7 := nvl( loc.attribute7, v_loc_rec.attribute7);
1218: l_pn_locations_rec.ATTRIBUTE8 := nvl( loc.attribute8, v_loc_rec.attribute8);
1219: l_pn_locations_rec.ATTRIBUTE9 := nvl( loc.attribute9, v_loc_rec.attribute9);
1220: l_pn_locations_rec.ATTRIBUTE10 := nvl( loc.attribute10, v_loc_rec.attribute10);
1221: l_pn_locations_rec.ATTRIBUTE11 := nvl( loc.attribute11, v_loc_rec.attribute11);
1222: l_pn_locations_rec.ATTRIBUTE12 := nvl( loc.attribute12, v_loc_rec.attribute12);
1215: l_pn_locations_rec.ATTRIBUTE5 := nvl( loc.attribute5, v_loc_rec.attribute5);
1216: l_pn_locations_rec.ATTRIBUTE6 := nvl( loc.attribute6, v_loc_rec.attribute6);
1217: l_pn_locations_rec.ATTRIBUTE7 := nvl( loc.attribute7, v_loc_rec.attribute7);
1218: l_pn_locations_rec.ATTRIBUTE8 := nvl( loc.attribute8, v_loc_rec.attribute8);
1219: l_pn_locations_rec.ATTRIBUTE9 := nvl( loc.attribute9, v_loc_rec.attribute9);
1220: l_pn_locations_rec.ATTRIBUTE10 := nvl( loc.attribute10, v_loc_rec.attribute10);
1221: l_pn_locations_rec.ATTRIBUTE11 := nvl( loc.attribute11, v_loc_rec.attribute11);
1222: l_pn_locations_rec.ATTRIBUTE12 := nvl( loc.attribute12, v_loc_rec.attribute12);
1223: l_pn_locations_rec.ATTRIBUTE13 := nvl( loc.attribute13, v_loc_rec.attribute13);
1216: l_pn_locations_rec.ATTRIBUTE6 := nvl( loc.attribute6, v_loc_rec.attribute6);
1217: l_pn_locations_rec.ATTRIBUTE7 := nvl( loc.attribute7, v_loc_rec.attribute7);
1218: l_pn_locations_rec.ATTRIBUTE8 := nvl( loc.attribute8, v_loc_rec.attribute8);
1219: l_pn_locations_rec.ATTRIBUTE9 := nvl( loc.attribute9, v_loc_rec.attribute9);
1220: l_pn_locations_rec.ATTRIBUTE10 := nvl( loc.attribute10, v_loc_rec.attribute10);
1221: l_pn_locations_rec.ATTRIBUTE11 := nvl( loc.attribute11, v_loc_rec.attribute11);
1222: l_pn_locations_rec.ATTRIBUTE12 := nvl( loc.attribute12, v_loc_rec.attribute12);
1223: l_pn_locations_rec.ATTRIBUTE13 := nvl( loc.attribute13, v_loc_rec.attribute13);
1224: l_pn_locations_rec.ATTRIBUTE14 := nvl( loc.attribute14, v_loc_rec.attribute14);
1217: l_pn_locations_rec.ATTRIBUTE7 := nvl( loc.attribute7, v_loc_rec.attribute7);
1218: l_pn_locations_rec.ATTRIBUTE8 := nvl( loc.attribute8, v_loc_rec.attribute8);
1219: l_pn_locations_rec.ATTRIBUTE9 := nvl( loc.attribute9, v_loc_rec.attribute9);
1220: l_pn_locations_rec.ATTRIBUTE10 := nvl( loc.attribute10, v_loc_rec.attribute10);
1221: l_pn_locations_rec.ATTRIBUTE11 := nvl( loc.attribute11, v_loc_rec.attribute11);
1222: l_pn_locations_rec.ATTRIBUTE12 := nvl( loc.attribute12, v_loc_rec.attribute12);
1223: l_pn_locations_rec.ATTRIBUTE13 := nvl( loc.attribute13, v_loc_rec.attribute13);
1224: l_pn_locations_rec.ATTRIBUTE14 := nvl( loc.attribute14, v_loc_rec.attribute14);
1225: l_pn_locations_rec.ATTRIBUTE15 := nvl( loc.attribute15, v_loc_rec.attribute15);
1218: l_pn_locations_rec.ATTRIBUTE8 := nvl( loc.attribute8, v_loc_rec.attribute8);
1219: l_pn_locations_rec.ATTRIBUTE9 := nvl( loc.attribute9, v_loc_rec.attribute9);
1220: l_pn_locations_rec.ATTRIBUTE10 := nvl( loc.attribute10, v_loc_rec.attribute10);
1221: l_pn_locations_rec.ATTRIBUTE11 := nvl( loc.attribute11, v_loc_rec.attribute11);
1222: l_pn_locations_rec.ATTRIBUTE12 := nvl( loc.attribute12, v_loc_rec.attribute12);
1223: l_pn_locations_rec.ATTRIBUTE13 := nvl( loc.attribute13, v_loc_rec.attribute13);
1224: l_pn_locations_rec.ATTRIBUTE14 := nvl( loc.attribute14, v_loc_rec.attribute14);
1225: l_pn_locations_rec.ATTRIBUTE15 := nvl( loc.attribute15, v_loc_rec.attribute15);
1226: l_pn_locations_rec.REQUEST_ID := nvl( fnd_profile.value('CONC_REQUEST_ID'), 0);
1219: l_pn_locations_rec.ATTRIBUTE9 := nvl( loc.attribute9, v_loc_rec.attribute9);
1220: l_pn_locations_rec.ATTRIBUTE10 := nvl( loc.attribute10, v_loc_rec.attribute10);
1221: l_pn_locations_rec.ATTRIBUTE11 := nvl( loc.attribute11, v_loc_rec.attribute11);
1222: l_pn_locations_rec.ATTRIBUTE12 := nvl( loc.attribute12, v_loc_rec.attribute12);
1223: l_pn_locations_rec.ATTRIBUTE13 := nvl( loc.attribute13, v_loc_rec.attribute13);
1224: l_pn_locations_rec.ATTRIBUTE14 := nvl( loc.attribute14, v_loc_rec.attribute14);
1225: l_pn_locations_rec.ATTRIBUTE15 := nvl( loc.attribute15, v_loc_rec.attribute15);
1226: l_pn_locations_rec.REQUEST_ID := nvl( fnd_profile.value('CONC_REQUEST_ID'), 0);
1227: l_pn_locations_rec.PROGRAM_APPLICATION_ID :=
1220: l_pn_locations_rec.ATTRIBUTE10 := nvl( loc.attribute10, v_loc_rec.attribute10);
1221: l_pn_locations_rec.ATTRIBUTE11 := nvl( loc.attribute11, v_loc_rec.attribute11);
1222: l_pn_locations_rec.ATTRIBUTE12 := nvl( loc.attribute12, v_loc_rec.attribute12);
1223: l_pn_locations_rec.ATTRIBUTE13 := nvl( loc.attribute13, v_loc_rec.attribute13);
1224: l_pn_locations_rec.ATTRIBUTE14 := nvl( loc.attribute14, v_loc_rec.attribute14);
1225: l_pn_locations_rec.ATTRIBUTE15 := nvl( loc.attribute15, v_loc_rec.attribute15);
1226: l_pn_locations_rec.REQUEST_ID := nvl( fnd_profile.value('CONC_REQUEST_ID'), 0);
1227: l_pn_locations_rec.PROGRAM_APPLICATION_ID :=
1228: nvl( fnd_profile.value('CONC_PROGRAM_APPLICATION_ID'), 0);
1221: l_pn_locations_rec.ATTRIBUTE11 := nvl( loc.attribute11, v_loc_rec.attribute11);
1222: l_pn_locations_rec.ATTRIBUTE12 := nvl( loc.attribute12, v_loc_rec.attribute12);
1223: l_pn_locations_rec.ATTRIBUTE13 := nvl( loc.attribute13, v_loc_rec.attribute13);
1224: l_pn_locations_rec.ATTRIBUTE14 := nvl( loc.attribute14, v_loc_rec.attribute14);
1225: l_pn_locations_rec.ATTRIBUTE15 := nvl( loc.attribute15, v_loc_rec.attribute15);
1226: l_pn_locations_rec.REQUEST_ID := nvl( fnd_profile.value('CONC_REQUEST_ID'), 0);
1227: l_pn_locations_rec.PROGRAM_APPLICATION_ID :=
1228: nvl( fnd_profile.value('CONC_PROGRAM_APPLICATION_ID'), 0);
1229: l_pn_locations_rec.PROGRAM_ID := nvl( fnd_profile.value('CONC_PROGRAM_ID'), 0);
1222: l_pn_locations_rec.ATTRIBUTE12 := nvl( loc.attribute12, v_loc_rec.attribute12);
1223: l_pn_locations_rec.ATTRIBUTE13 := nvl( loc.attribute13, v_loc_rec.attribute13);
1224: l_pn_locations_rec.ATTRIBUTE14 := nvl( loc.attribute14, v_loc_rec.attribute14);
1225: l_pn_locations_rec.ATTRIBUTE15 := nvl( loc.attribute15, v_loc_rec.attribute15);
1226: l_pn_locations_rec.REQUEST_ID := nvl( fnd_profile.value('CONC_REQUEST_ID'), 0);
1227: l_pn_locations_rec.PROGRAM_APPLICATION_ID :=
1228: nvl( fnd_profile.value('CONC_PROGRAM_APPLICATION_ID'), 0);
1229: l_pn_locations_rec.PROGRAM_ID := nvl( fnd_profile.value('CONC_PROGRAM_ID'), 0);
1230: l_pn_locations_rec.PROGRAM_UPDATE_DATE:= sysdate;
1223: l_pn_locations_rec.ATTRIBUTE13 := nvl( loc.attribute13, v_loc_rec.attribute13);
1224: l_pn_locations_rec.ATTRIBUTE14 := nvl( loc.attribute14, v_loc_rec.attribute14);
1225: l_pn_locations_rec.ATTRIBUTE15 := nvl( loc.attribute15, v_loc_rec.attribute15);
1226: l_pn_locations_rec.REQUEST_ID := nvl( fnd_profile.value('CONC_REQUEST_ID'), 0);
1227: l_pn_locations_rec.PROGRAM_APPLICATION_ID :=
1228: nvl( fnd_profile.value('CONC_PROGRAM_APPLICATION_ID'), 0);
1229: l_pn_locations_rec.PROGRAM_ID := nvl( fnd_profile.value('CONC_PROGRAM_ID'), 0);
1230: l_pn_locations_rec.PROGRAM_UPDATE_DATE:= sysdate;
1231: l_pn_locations_rec.LOCATION_ALIAS :=
1225: l_pn_locations_rec.ATTRIBUTE15 := nvl( loc.attribute15, v_loc_rec.attribute15);
1226: l_pn_locations_rec.REQUEST_ID := nvl( fnd_profile.value('CONC_REQUEST_ID'), 0);
1227: l_pn_locations_rec.PROGRAM_APPLICATION_ID :=
1228: nvl( fnd_profile.value('CONC_PROGRAM_APPLICATION_ID'), 0);
1229: l_pn_locations_rec.PROGRAM_ID := nvl( fnd_profile.value('CONC_PROGRAM_ID'), 0);
1230: l_pn_locations_rec.PROGRAM_UPDATE_DATE:= sysdate;
1231: l_pn_locations_rec.LOCATION_ALIAS :=
1232: nvl( loc.location_alias, v_loc_rec.location_alias);
1233: l_pn_locations_rec.PROPERTY_ID := nvl( loc.property_id, v_loc_rec.property_id);
1226: l_pn_locations_rec.REQUEST_ID := nvl( fnd_profile.value('CONC_REQUEST_ID'), 0);
1227: l_pn_locations_rec.PROGRAM_APPLICATION_ID :=
1228: nvl( fnd_profile.value('CONC_PROGRAM_APPLICATION_ID'), 0);
1229: l_pn_locations_rec.PROGRAM_ID := nvl( fnd_profile.value('CONC_PROGRAM_ID'), 0);
1230: l_pn_locations_rec.PROGRAM_UPDATE_DATE:= sysdate;
1231: l_pn_locations_rec.LOCATION_ALIAS :=
1232: nvl( loc.location_alias, v_loc_rec.location_alias);
1233: l_pn_locations_rec.PROPERTY_ID := nvl( loc.property_id, v_loc_rec.property_id);
1234:
1227: l_pn_locations_rec.PROGRAM_APPLICATION_ID :=
1228: nvl( fnd_profile.value('CONC_PROGRAM_APPLICATION_ID'), 0);
1229: l_pn_locations_rec.PROGRAM_ID := nvl( fnd_profile.value('CONC_PROGRAM_ID'), 0);
1230: l_pn_locations_rec.PROGRAM_UPDATE_DATE:= sysdate;
1231: l_pn_locations_rec.LOCATION_ALIAS :=
1232: nvl( loc.location_alias, v_loc_rec.location_alias);
1233: l_pn_locations_rec.PROPERTY_ID := nvl( loc.property_id, v_loc_rec.property_id);
1234:
1235: l_pn_locations_rec.FUNCTION_TYPE_LOOKUP_CODE :=
1229: l_pn_locations_rec.PROGRAM_ID := nvl( fnd_profile.value('CONC_PROGRAM_ID'), 0);
1230: l_pn_locations_rec.PROGRAM_UPDATE_DATE:= sysdate;
1231: l_pn_locations_rec.LOCATION_ALIAS :=
1232: nvl( loc.location_alias, v_loc_rec.location_alias);
1233: l_pn_locations_rec.PROPERTY_ID := nvl( loc.property_id, v_loc_rec.property_id);
1234:
1235: l_pn_locations_rec.FUNCTION_TYPE_LOOKUP_CODE :=
1236: nvl( loc.function_type_lookup_code, v_loc_rec.function_type_lookup_code);
1237: l_pn_locations_rec.STANDARD_TYPE_LOOKUP_CODE :=
1231: l_pn_locations_rec.LOCATION_ALIAS :=
1232: nvl( loc.location_alias, v_loc_rec.location_alias);
1233: l_pn_locations_rec.PROPERTY_ID := nvl( loc.property_id, v_loc_rec.property_id);
1234:
1235: l_pn_locations_rec.FUNCTION_TYPE_LOOKUP_CODE :=
1236: nvl( loc.function_type_lookup_code, v_loc_rec.function_type_lookup_code);
1237: l_pn_locations_rec.STANDARD_TYPE_LOOKUP_CODE :=
1238: nvl( loc.standard_type_lookup_code, v_loc_rec.standard_type_lookup_code);
1239: l_pn_locations_rec.active_start_date :=
1233: l_pn_locations_rec.PROPERTY_ID := nvl( loc.property_id, v_loc_rec.property_id);
1234:
1235: l_pn_locations_rec.FUNCTION_TYPE_LOOKUP_CODE :=
1236: nvl( loc.function_type_lookup_code, v_loc_rec.function_type_lookup_code);
1237: l_pn_locations_rec.STANDARD_TYPE_LOOKUP_CODE :=
1238: nvl( loc.standard_type_lookup_code, v_loc_rec.standard_type_lookup_code);
1239: l_pn_locations_rec.active_start_date :=
1240: trunc(nvl(loc.new_active_start_date, v_loc_rec.active_start_date)); --Used trunc() :Bug 6009957
1241: l_pn_locations_rec.active_end_date :=
1235: l_pn_locations_rec.FUNCTION_TYPE_LOOKUP_CODE :=
1236: nvl( loc.function_type_lookup_code, v_loc_rec.function_type_lookup_code);
1237: l_pn_locations_rec.STANDARD_TYPE_LOOKUP_CODE :=
1238: nvl( loc.standard_type_lookup_code, v_loc_rec.standard_type_lookup_code);
1239: l_pn_locations_rec.active_start_date :=
1240: trunc(nvl(loc.new_active_start_date, v_loc_rec.active_start_date)); --Used trunc() :Bug 6009957
1241: l_pn_locations_rec.active_end_date :=
1242: trunc(nvl(loc.new_active_end_date,v_loc_rec.active_end_date)); --Used trunc() :Bug 6009957
1243: l_pn_locations_rec .address_id := nvl(v_loc_rec.address_id,l_Address_id);
1237: l_pn_locations_rec.STANDARD_TYPE_LOOKUP_CODE :=
1238: nvl( loc.standard_type_lookup_code, v_loc_rec.standard_type_lookup_code);
1239: l_pn_locations_rec.active_start_date :=
1240: trunc(nvl(loc.new_active_start_date, v_loc_rec.active_start_date)); --Used trunc() :Bug 6009957
1241: l_pn_locations_rec.active_end_date :=
1242: trunc(nvl(loc.new_active_end_date,v_loc_rec.active_end_date)); --Used trunc() :Bug 6009957
1243: l_pn_locations_rec .address_id := nvl(v_loc_rec.address_id,l_Address_id);
1244: l_pn_locations_rec.source := nvl(loc.source,v_loc_rec.source);
1245:
1239: l_pn_locations_rec.active_start_date :=
1240: trunc(nvl(loc.new_active_start_date, v_loc_rec.active_start_date)); --Used trunc() :Bug 6009957
1241: l_pn_locations_rec.active_end_date :=
1242: trunc(nvl(loc.new_active_end_date,v_loc_rec.active_end_date)); --Used trunc() :Bug 6009957
1243: l_pn_locations_rec .address_id := nvl(v_loc_rec.address_id,l_Address_id);
1244: l_pn_locations_rec.source := nvl(loc.source,v_loc_rec.source);
1245:
1246: l_pn_addresses_rec.ADDRESS_LINE1 := nvl( loc.address_line1, v_addr_rec.address_line1);
1247: l_pn_addresses_rec.ADDRESS_LINE2 := nvl( loc.address_line2, v_addr_rec.address_line2);
1240: trunc(nvl(loc.new_active_start_date, v_loc_rec.active_start_date)); --Used trunc() :Bug 6009957
1241: l_pn_locations_rec.active_end_date :=
1242: trunc(nvl(loc.new_active_end_date,v_loc_rec.active_end_date)); --Used trunc() :Bug 6009957
1243: l_pn_locations_rec .address_id := nvl(v_loc_rec.address_id,l_Address_id);
1244: l_pn_locations_rec.source := nvl(loc.source,v_loc_rec.source);
1245:
1246: l_pn_addresses_rec.ADDRESS_LINE1 := nvl( loc.address_line1, v_addr_rec.address_line1);
1247: l_pn_addresses_rec.ADDRESS_LINE2 := nvl( loc.address_line2, v_addr_rec.address_line2);
1248: l_pn_addresses_rec.ADDRESS_LINE3 := nvl( loc.address_line3, v_addr_rec.address_line3);
1281: -------------------------------------------------------------------
1282:
1283: put_log('Validate Common_Area and Assignable_Area');
1284:
1285: if (l_pn_locations_rec.assignable_area is null and
1286: l_pn_locations_rec.location_type_lookup_code in ('OFFICE','SECTION') and
1287: nvl(l_pn_locations_rec.common_area_flag,'N') = 'N') then
1288: fnd_message.set_name('PN','PN_CAFM_ASSIGNABLE_REQ');
1289: fnd_message.set_token('LOCATION_ID', l_pn_locations_rec.location_id);
1282:
1283: put_log('Validate Common_Area and Assignable_Area');
1284:
1285: if (l_pn_locations_rec.assignable_area is null and
1286: l_pn_locations_rec.location_type_lookup_code in ('OFFICE','SECTION') and
1287: nvl(l_pn_locations_rec.common_area_flag,'N') = 'N') then
1288: fnd_message.set_name('PN','PN_CAFM_ASSIGNABLE_REQ');
1289: fnd_message.set_token('LOCATION_ID', l_pn_locations_rec.location_id);
1290: l_error_message := fnd_message.get;
1283: put_log('Validate Common_Area and Assignable_Area');
1284:
1285: if (l_pn_locations_rec.assignable_area is null and
1286: l_pn_locations_rec.location_type_lookup_code in ('OFFICE','SECTION') and
1287: nvl(l_pn_locations_rec.common_area_flag,'N') = 'N') then
1288: fnd_message.set_name('PN','PN_CAFM_ASSIGNABLE_REQ');
1289: fnd_message.set_token('LOCATION_ID', l_pn_locations_rec.location_id);
1290: l_error_message := fnd_message.get;
1291: raise INVALID_RECORD;
1285: if (l_pn_locations_rec.assignable_area is null and
1286: l_pn_locations_rec.location_type_lookup_code in ('OFFICE','SECTION') and
1287: nvl(l_pn_locations_rec.common_area_flag,'N') = 'N') then
1288: fnd_message.set_name('PN','PN_CAFM_ASSIGNABLE_REQ');
1289: fnd_message.set_token('LOCATION_ID', l_pn_locations_rec.location_id);
1290: l_error_message := fnd_message.get;
1291: raise INVALID_RECORD;
1292: end if;
1293:
1290: l_error_message := fnd_message.get;
1291: raise INVALID_RECORD;
1292: end if;
1293:
1294: if (l_pn_locations_rec.common_area is null and
1295: l_pn_locations_rec.location_type_lookup_code in ('OFFICE','SECTION') and
1296: l_pn_locations_rec.common_area_flag = 'Y') then
1297: fnd_message.set_name('PN','PN_CAFM_COMMON_AREA_REQ');
1298: fnd_message.set_token('LOCATION_ID', l_pn_locations_rec.location_id);
1291: raise INVALID_RECORD;
1292: end if;
1293:
1294: if (l_pn_locations_rec.common_area is null and
1295: l_pn_locations_rec.location_type_lookup_code in ('OFFICE','SECTION') and
1296: l_pn_locations_rec.common_area_flag = 'Y') then
1297: fnd_message.set_name('PN','PN_CAFM_COMMON_AREA_REQ');
1298: fnd_message.set_token('LOCATION_ID', l_pn_locations_rec.location_id);
1299: l_error_message := fnd_message.get;
1292: end if;
1293:
1294: if (l_pn_locations_rec.common_area is null and
1295: l_pn_locations_rec.location_type_lookup_code in ('OFFICE','SECTION') and
1296: l_pn_locations_rec.common_area_flag = 'Y') then
1297: fnd_message.set_name('PN','PN_CAFM_COMMON_AREA_REQ');
1298: fnd_message.set_token('LOCATION_ID', l_pn_locations_rec.location_id);
1299: l_error_message := fnd_message.get;
1300: raise INVALID_RECORD;
1294: if (l_pn_locations_rec.common_area is null and
1295: l_pn_locations_rec.location_type_lookup_code in ('OFFICE','SECTION') and
1296: l_pn_locations_rec.common_area_flag = 'Y') then
1297: fnd_message.set_name('PN','PN_CAFM_COMMON_AREA_REQ');
1298: fnd_message.set_token('LOCATION_ID', l_pn_locations_rec.location_id);
1299: l_error_message := fnd_message.get;
1300: raise INVALID_RECORD;
1301: end if;
1302:
1299: l_error_message := fnd_message.get;
1300: raise INVALID_RECORD;
1301: end if;
1302:
1303: if (l_pn_locations_rec.Common_Area is not null and
1304: l_pn_locations_rec.Assignable_Area is not null and
1305: l_pn_locations_rec.location_type_lookup_code in ('OFFICE','SECTION'))
1306: then
1307: if l_pn_locations_rec.common_area_flag = 'Y' then
1300: raise INVALID_RECORD;
1301: end if;
1302:
1303: if (l_pn_locations_rec.Common_Area is not null and
1304: l_pn_locations_rec.Assignable_Area is not null and
1305: l_pn_locations_rec.location_type_lookup_code in ('OFFICE','SECTION'))
1306: then
1307: if l_pn_locations_rec.common_area_flag = 'Y' then
1308: l_pn_locations_rec.Assignable_Area := null;
1301: end if;
1302:
1303: if (l_pn_locations_rec.Common_Area is not null and
1304: l_pn_locations_rec.Assignable_Area is not null and
1305: l_pn_locations_rec.location_type_lookup_code in ('OFFICE','SECTION'))
1306: then
1307: if l_pn_locations_rec.common_area_flag = 'Y' then
1308: l_pn_locations_rec.Assignable_Area := null;
1309: elsif nvl(l_pn_locations_rec.common_area_flag,'N') = 'N' then
1303: if (l_pn_locations_rec.Common_Area is not null and
1304: l_pn_locations_rec.Assignable_Area is not null and
1305: l_pn_locations_rec.location_type_lookup_code in ('OFFICE','SECTION'))
1306: then
1307: if l_pn_locations_rec.common_area_flag = 'Y' then
1308: l_pn_locations_rec.Assignable_Area := null;
1309: elsif nvl(l_pn_locations_rec.common_area_flag,'N') = 'N' then
1310: l_pn_locations_rec.Common_Area := null;
1311: end if;
1304: l_pn_locations_rec.Assignable_Area is not null and
1305: l_pn_locations_rec.location_type_lookup_code in ('OFFICE','SECTION'))
1306: then
1307: if l_pn_locations_rec.common_area_flag = 'Y' then
1308: l_pn_locations_rec.Assignable_Area := null;
1309: elsif nvl(l_pn_locations_rec.common_area_flag,'N') = 'N' then
1310: l_pn_locations_rec.Common_Area := null;
1311: end if;
1312: end if;
1305: l_pn_locations_rec.location_type_lookup_code in ('OFFICE','SECTION'))
1306: then
1307: if l_pn_locations_rec.common_area_flag = 'Y' then
1308: l_pn_locations_rec.Assignable_Area := null;
1309: elsif nvl(l_pn_locations_rec.common_area_flag,'N') = 'N' then
1310: l_pn_locations_rec.Common_Area := null;
1311: end if;
1312: end if;
1313:
1306: then
1307: if l_pn_locations_rec.common_area_flag = 'Y' then
1308: l_pn_locations_rec.Assignable_Area := null;
1309: elsif nvl(l_pn_locations_rec.common_area_flag,'N') = 'N' then
1310: l_pn_locations_rec.Common_Area := null;
1311: end if;
1312: end if;
1313:
1314: put_log( 'R: Just before Correct/Update');
1312: end if;
1313:
1314: put_log( 'R: Just before Correct/Update');
1315: PNT_LOCATIONS_PKG.correct_update_row
1316: ( p_pn_locations_rec => l_pn_locations_rec,
1317: p_pn_addresses_rec => l_pn_addresses_rec,
1318: p_change_mode => nvl(loc.change_mode, 'CORRECT'),
1319: p_as_of_date => loc.change_date,
1320: p_active_start_date_old => trunc(loc.active_start_date), --Used trunc() :Bug 6009957
1345:
1346: END IF; -- loc.ENTRY_TYPE
1347:
1348: ------------------------------------------------
1349: -- Set PN_LOCATIONS_ITF.transferred_to_pn = 'Y'
1350: ------------------------------------------------
1351: put_log('Update ITF set transfer = Y');
1352: UPDATE pn_locations_itf
1353: SET transferred_to_pn = 'Y',
1348: ------------------------------------------------
1349: -- Set PN_LOCATIONS_ITF.transferred_to_pn = 'Y'
1350: ------------------------------------------------
1351: put_log('Update ITF set transfer = Y');
1352: UPDATE pn_locations_itf
1353: SET transferred_to_pn = 'Y',
1354: error_message = NULL
1355: WHERE rowid = loc.rowid;
1356:
1367: WHEN INVALID_RECORD THEN
1368: ROLLBACK TO S1;
1369: l_fail := l_fail + 1;
1370: -- Update ERROR_MESSAGE
1371: UPDATE pn_locations_itf
1372: SET error_message = substr(l_error_message, 1, 240)
1373: WHERE rowid = loc.rowid;
1374: -- Spool to Conc Log
1375: put_line(l_error_message);
1383: WHEN OTHERS THEN
1384: ROLLBACK TO S1;
1385: l_fail := l_fail + 1;
1386: l_error_message := substr(sqlerrm,1,250);
1387: UPDATE pn_locations_itf
1388: SET error_message = substr(l_error_message, 1, 240)
1389: WHERE rowid = loc.rowid;
1390: errbuf := l_error_message;
1391: retcode := '2';
1475:
1476: CURSOR locCodeCur IS
1477:
1478: SELECT loc.LOCATION_CODE
1479: FROM PN_LOCATIONS_ALL loc
1480: WHERE loc.LOCATION_ID = p_Loc_Id;
1481:
1482: CURSOR locIdCur is
1483: SELECT loc.LOCATION_ID
1480: WHERE loc.LOCATION_ID = p_Loc_Id;
1481:
1482: CURSOR locIdCur is
1483: SELECT loc.LOCATION_ID
1484: FROM PN_LOCATIONS_ALL loc
1485: WHERE loc.LOCATION_CODE = p_Loc_Code
1486: AND org_id = p_org_id;
1487:
1488: BEGIN
1522: |
1523: | MODIFICATION HISTORY
1524: | 1999 Naga Vijayapuram o Created
1525: | 17-MAY-02 Kiran Hegde o Location_Type_lookup_Code is now validated
1526: | only from pn_locations
1527: | 01-APR-05 piagrawa o Modified the select statements to retrieve values
1528: | from _ALL tables
1529: +===========================================================================*/
1530:
1535: BEGIN
1536:
1537: Select distinct location_type_lookup_code
1538: into l_lookup_type
1539: from PN_LOCATIONS_ALL
1540: where location_id = p_location_id ;
1541:
1542: Return l_lookup_type ;
1543:
1572: |
1573: | MODIFICATION HISTORY
1574: | 23-APR-02 Kiran Hegde o Created -
1575: | Bug#2324687 - Validates if the Property_Id in the
1576: | table Pn_Locations_Itf exists in Pn_Properties
1577: | 01-APR-05 piagrawa o Modified the select statements to retrieve values
1578: | from _ALL tables
1579: +===========================================================================*/
1580: