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_CAD_IMPORT dependencies on FND_PROFILE

Line 47: l_org_ID := fnd_profile.value('ORG_ID');

43: /* init the ORG */
44: IF pn_mo_cache_utils.is_MOAC_enabled THEN
45: l_org_ID := p_org_ID;
46: ELSE
47: l_org_ID := fnd_profile.value('ORG_ID');
48: END IF;
49:
50: IF (function_flag = 'L') then
51: BEGIN

Line 130: | fnd_profile.value('ORG_ID')

126: | 01-APR-05 piagrawa o Modified the signature to include org_id,
127: | Modified the select statements to retrieve values
128: | from _ALL tables and in INSERT_ROW call passed
129: | the value of p_org_id in place of
130: | fnd_profile.value('ORG_ID')
131: | 14-JUL-05 piagrawa o passed org id in call to Is_Id_Code_Valid
132: | 27-JUL-05 SatyaDeep o Added a check for office/section in the call to
133: | PNT_LOCATIONS_PKG.check_location_gaps for Bug#4503407
134: | 27-JUL-05 SatyaDeep o Added validation for NEW_ACTIVE_START_DATE

Line 488: loc.COUNTRY := fnd_profile.value('DEFAULT_COUNTRY');

484: -- Validate Country (Territory)
485: --------------------------------------
486: if (loc.COUNTRY is NULL) then
487: if (loc.ENTRY_TYPE IN ('A', 'U')) then
488: loc.COUNTRY := fnd_profile.value('DEFAULT_COUNTRY');
489: end if;
490: else
491: if (NOT PNP_UTIL_FUNC.valid_country_code(loc.COUNTRY)) then
492: fnd_message.set_name('PN', 'PN_CAFM_COUNTRY');

Line 685: ,x_request_id => nvl(fnd_profile.value('CONC_REQUEST_ID'), 0)

681: ,x_UOM_CODE => loc.uom_code
682: ,x_DESCRIPTION => NULL
683: ,x_PARENT_LOCATION_ID => loc.parent_location_id
684: ,x_INTERFACE_FLAG => NULL
685: ,x_request_id => nvl(fnd_profile.value('CONC_REQUEST_ID'), 0)
686: ,x_PROGRAM_ID => nvl(fnd_profile.value('CONC_PROGRAM_APPLICATION_ID'), 0)
687: ,x_PROGRAM_APPLICATION_ID => nvl(fnd_profile.value('CONC_PROGRAM_ID'), 0)
688: ,x_PROGRAM_UPDATE_DATE => SYSDATE
689: ,x_STATUS => 'A'

Line 686: ,x_PROGRAM_ID => nvl(fnd_profile.value('CONC_PROGRAM_APPLICATION_ID'), 0)

682: ,x_DESCRIPTION => NULL
683: ,x_PARENT_LOCATION_ID => loc.parent_location_id
684: ,x_INTERFACE_FLAG => NULL
685: ,x_request_id => nvl(fnd_profile.value('CONC_REQUEST_ID'), 0)
686: ,x_PROGRAM_ID => nvl(fnd_profile.value('CONC_PROGRAM_APPLICATION_ID'), 0)
687: ,x_PROGRAM_APPLICATION_ID => nvl(fnd_profile.value('CONC_PROGRAM_ID'), 0)
688: ,x_PROGRAM_UPDATE_DATE => SYSDATE
689: ,x_STATUS => 'A'
690: ,x_PROPERTY_ID => loc.property_id

Line 687: ,x_PROGRAM_APPLICATION_ID => nvl(fnd_profile.value('CONC_PROGRAM_ID'), 0)

683: ,x_PARENT_LOCATION_ID => loc.parent_location_id
684: ,x_INTERFACE_FLAG => NULL
685: ,x_request_id => nvl(fnd_profile.value('CONC_REQUEST_ID'), 0)
686: ,x_PROGRAM_ID => nvl(fnd_profile.value('CONC_PROGRAM_APPLICATION_ID'), 0)
687: ,x_PROGRAM_APPLICATION_ID => nvl(fnd_profile.value('CONC_PROGRAM_ID'), 0)
688: ,x_PROGRAM_UPDATE_DATE => SYSDATE
689: ,x_STATUS => 'A'
690: ,x_PROPERTY_ID => loc.property_id
691: ,x_ATTRIBUTE_CATEGORY => loc.attribute_category

Line 1069: l_pn_locations_rec.LAST_UPDATE_LOGIN := nvl(fnd_profile.value('CONC_LOGIN_ID'), 0);

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;

Line 1070: l_pn_locations_rec.LAST_UPDATED_BY := nvl(fnd_profile.value('CONC_USER_ID'), 0);

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;

Line 1087: l_pn_locations_rec.REQUEST_ID := nvl(fnd_profile.value('CONC_REQUEST_ID'), 0);

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;

Line 1088: l_pn_locations_rec.PROGRAM_APPLICATION_ID := nvl(fnd_profile.value('CONC_PROGRAM_APPLICATION_ID'), 0);

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;

Line 1089: l_pn_locations_rec.PROGRAM_ID := nvl(fnd_profile.value('CONC_PROGRAM_ID'), 0);

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;

Line 1117: l_pn_addresses_rec.LAST_UPDATED_BY := nvl(fnd_profile.value('USER_ID'), 0);

1113: l_pn_addresses_rec.ZIP_CODE := loc.zip_code;
1114: l_pn_addresses_rec.COUNTRY := loc.country;
1115: l_pn_addresses_rec.ADDRESS_STYLE := loc.address_style;
1116: l_pn_addresses_rec.LAST_UPDATE_DATE := sysdate;
1117: l_pn_addresses_rec.LAST_UPDATED_BY := nvl(fnd_profile.value('USER_ID'), 0);
1118: l_pn_addresses_rec.LAST_UPDATE_LOGIN := nvl(fnd_profile.value('CONC_LOGIN_ID'), 0);
1119: l_pn_addresses_rec.ADDR_ATTRIBUTE_CATEGORY := loc.addr_attribute_category;
1120: l_pn_addresses_rec.ADDR_ATTRIBUTE1 := loc.addr_attribute1;
1121: l_pn_addresses_rec.ADDR_ATTRIBUTE2 := loc.addr_attribute2;

Line 1118: l_pn_addresses_rec.LAST_UPDATE_LOGIN := nvl(fnd_profile.value('CONC_LOGIN_ID'), 0);

1114: l_pn_addresses_rec.COUNTRY := loc.country;
1115: l_pn_addresses_rec.ADDRESS_STYLE := loc.address_style;
1116: l_pn_addresses_rec.LAST_UPDATE_DATE := sysdate;
1117: l_pn_addresses_rec.LAST_UPDATED_BY := nvl(fnd_profile.value('USER_ID'), 0);
1118: l_pn_addresses_rec.LAST_UPDATE_LOGIN := nvl(fnd_profile.value('CONC_LOGIN_ID'), 0);
1119: l_pn_addresses_rec.ADDR_ATTRIBUTE_CATEGORY := loc.addr_attribute_category;
1120: l_pn_addresses_rec.ADDR_ATTRIBUTE1 := loc.addr_attribute1;
1121: l_pn_addresses_rec.ADDR_ATTRIBUTE2 := loc.addr_attribute2;
1122: l_pn_addresses_rec.ADDR_ATTRIBUTE3 := loc.addr_attribute3;

Line 1207: l_pn_locations_rec.LAST_UPDATE_LOGIN := nvl( fnd_profile.value('CONC_LOGIN_ID'), 0);

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

Line 1208: l_pn_locations_rec.LAST_UPDATED_BY := nvl( fnd_profile.value('CONC_USER_ID'), 0);

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

Line 1226: l_pn_locations_rec.REQUEST_ID := nvl( fnd_profile.value('CONC_REQUEST_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;

Line 1228: nvl( fnd_profile.value('CONC_PROGRAM_APPLICATION_ID'), 0);

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 :=
1232: nvl( loc.location_alias, v_loc_rec.location_alias);

Line 1229: l_pn_locations_rec.PROGRAM_ID := nvl( fnd_profile.value('CONC_PROGRAM_ID'), 0);

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

Line 1258: l_pn_addresses_rec.LAST_UPDATED_BY := nvl(fnd_profile.value('USER_ID'), 0);

1254: l_pn_addresses_rec.ZIP_CODE := nvl( loc.zip_code, v_addr_rec.zip_code);
1255: l_pn_addresses_rec.COUNTRY := nvl( loc.country, v_addr_rec.country);
1256: l_pn_addresses_rec.ADDRESS_STYLE := nvl( loc.address_style, v_addr_rec.address_style);
1257: l_pn_addresses_rec.LAST_UPDATE_DATE := sysdate;
1258: l_pn_addresses_rec.LAST_UPDATED_BY := nvl(fnd_profile.value('USER_ID'), 0);
1259: l_pn_addresses_rec.LAST_UPDATE_LOGIN := nvl(fnd_profile.value('CONC_LOGIN_ID'), 0);
1260: l_pn_addresses_rec.ADDR_ATTRIBUTE_CATEGORY
1261: := nvl(loc.addr_attribute_category,
1262: v_addr_rec.addr_attribute_category);

Line 1259: l_pn_addresses_rec.LAST_UPDATE_LOGIN := nvl(fnd_profile.value('CONC_LOGIN_ID'), 0);

1255: l_pn_addresses_rec.COUNTRY := nvl( loc.country, v_addr_rec.country);
1256: l_pn_addresses_rec.ADDRESS_STYLE := nvl( loc.address_style, v_addr_rec.address_style);
1257: l_pn_addresses_rec.LAST_UPDATE_DATE := sysdate;
1258: l_pn_addresses_rec.LAST_UPDATED_BY := nvl(fnd_profile.value('USER_ID'), 0);
1259: l_pn_addresses_rec.LAST_UPDATE_LOGIN := nvl(fnd_profile.value('CONC_LOGIN_ID'), 0);
1260: l_pn_addresses_rec.ADDR_ATTRIBUTE_CATEGORY
1261: := nvl(loc.addr_attribute_category,
1262: v_addr_rec.addr_attribute_category);
1263: l_pn_addresses_rec.ADDR_ATTRIBUTE1 := nvl(loc.addr_attribute1,v_addr_rec.addr_attribute1);

Line 1653: | fnd_profile.value('ORG_ID')

1649: | o #3649373
1650: | 01-APR-05 piagrawa o Modified the signature to include org_id,
1651: | also in INSERT_ROW call passed
1652: | the value of p_org_id in place of
1653: | fnd_profile.value('ORG_ID')
1654: | 19-JUL-05 sdm o Passed SOURCE from PN_EMP_ASSIGN_SPACE_ITF to
1655: | Procedure PN_SPACE_ASSIGN_EMP.INSERT_ROW and
1656: | Procedure PN_SPACE_ASSIGN_EMP.UPDATE_ROW
1657: | 23-NOV-05 Hareesha o Modified get_profile_value to include org_id as

Line 2133: X_CREATED_BY => NVL( fnd_profile.value('USER_ID'), 0),

2129: X_UTILIZED_AREA => space.UTILIZED_AREA,
2130: X_EMP_SPACE_COMMENTS => NULL,
2131: X_ATTRIBUTE_CATEGORY => space.ATTRIBUTE_CATEGORY,
2132: X_CREATION_DATE => SYSDATE,
2133: X_CREATED_BY => NVL( fnd_profile.value('USER_ID'), 0),
2134: X_LAST_UPDATE_DATE => SYSDATE,
2135: X_LAST_UPDATED_BY => NVL( fnd_profile.value('USER_ID'), 0),
2136: X_LAST_UPDATE_LOGIN => NVL( fnd_profile.value('CONC_LOGIN_ID'), 0),
2137: X_SOURCE => space.source

Line 2135: X_LAST_UPDATED_BY => NVL( fnd_profile.value('USER_ID'), 0),

2131: X_ATTRIBUTE_CATEGORY => space.ATTRIBUTE_CATEGORY,
2132: X_CREATION_DATE => SYSDATE,
2133: X_CREATED_BY => NVL( fnd_profile.value('USER_ID'), 0),
2134: X_LAST_UPDATE_DATE => SYSDATE,
2135: X_LAST_UPDATED_BY => NVL( fnd_profile.value('USER_ID'), 0),
2136: X_LAST_UPDATE_LOGIN => NVL( fnd_profile.value('CONC_LOGIN_ID'), 0),
2137: X_SOURCE => space.source
2138: );
2139:

Line 2136: X_LAST_UPDATE_LOGIN => NVL( fnd_profile.value('CONC_LOGIN_ID'), 0),

2132: X_CREATION_DATE => SYSDATE,
2133: X_CREATED_BY => NVL( fnd_profile.value('USER_ID'), 0),
2134: X_LAST_UPDATE_DATE => SYSDATE,
2135: X_LAST_UPDATED_BY => NVL( fnd_profile.value('USER_ID'), 0),
2136: X_LAST_UPDATE_LOGIN => NVL( fnd_profile.value('CONC_LOGIN_ID'), 0),
2137: X_SOURCE => space.source
2138: );
2139:
2140:

Line 2215: X_LAST_UPDATED_BY => nvl(fnd_profile.value('USER_ID'), 0),

2211: X_UTILIZED_AREA => space.UTILIZED_AREA,
2212: X_EMP_SPACE_COMMENTS => NULL,
2213: X_ATTRIBUTE_CATEGORY => space.ATTRIBUTE_CATEGORY,
2214: X_LAST_UPDATE_DATE => sysdate,
2215: X_LAST_UPDATED_BY => nvl(fnd_profile.value('USER_ID'), 0),
2216: X_LAST_UPDATE_LOGIN => nvl(fnd_profile.value('CONC_LOGIN_ID'), 0),
2217: X_UPDATE_CORRECT_OPTION => space.change_mode,
2218: X_CHANGED_START_DATE => l_changed_start_date,
2219: X_SOURCE => space.source

Line 2216: X_LAST_UPDATE_LOGIN => nvl(fnd_profile.value('CONC_LOGIN_ID'), 0),

2212: X_EMP_SPACE_COMMENTS => NULL,
2213: X_ATTRIBUTE_CATEGORY => space.ATTRIBUTE_CATEGORY,
2214: X_LAST_UPDATE_DATE => sysdate,
2215: X_LAST_UPDATED_BY => nvl(fnd_profile.value('USER_ID'), 0),
2216: X_LAST_UPDATE_LOGIN => nvl(fnd_profile.value('CONC_LOGIN_ID'), 0),
2217: X_UPDATE_CORRECT_OPTION => space.change_mode,
2218: X_CHANGED_START_DATE => l_changed_start_date,
2219: X_SOURCE => space.source
2220: );

Line 2278: X_LAST_UPDATED_BY => nvl(fnd_profile.value('USER_ID'), 0),

2274: X_UTILIZED_AREA => NVL(space.UTILIZED_AREA,tlempinfo.UTILIZED_AREA),
2275: X_EMP_SPACE_COMMENTS => NULL,
2276: X_ATTRIBUTE_CATEGORY => NVL(space.ATTRIBUTE_CATEGORY,tlempinfo.ATTRIBUTE_CATEGORY),
2277: X_LAST_UPDATE_DATE => sysdate,
2278: X_LAST_UPDATED_BY => nvl(fnd_profile.value('USER_ID'), 0),
2279: X_LAST_UPDATE_LOGIN => nvl(fnd_profile.value('CONC_LOGIN_ID'), 0),
2280: X_UPDATE_CORRECT_OPTION => space.change_mode,
2281: X_CHANGED_START_DATE => l_changed_start_date,
2282: X_SOURCE => NVL(space.source,tlempinfo.source)

Line 2279: X_LAST_UPDATE_LOGIN => nvl(fnd_profile.value('CONC_LOGIN_ID'), 0),

2275: X_EMP_SPACE_COMMENTS => NULL,
2276: X_ATTRIBUTE_CATEGORY => NVL(space.ATTRIBUTE_CATEGORY,tlempinfo.ATTRIBUTE_CATEGORY),
2277: X_LAST_UPDATE_DATE => sysdate,
2278: X_LAST_UPDATED_BY => nvl(fnd_profile.value('USER_ID'), 0),
2279: X_LAST_UPDATE_LOGIN => nvl(fnd_profile.value('CONC_LOGIN_ID'), 0),
2280: X_UPDATE_CORRECT_OPTION => space.change_mode,
2281: X_CHANGED_START_DATE => l_changed_start_date,
2282: X_SOURCE => NVL(space.source,tlempinfo.source)
2283: );