APPS.IGI_IAC_WEBADI_PKG dependencies on IGI_IAC_REVALUATIONS

Line 1220: igi_iac_revaluations iir,

1216: fa.asset_number,
1217: irar.selected_for_reval_flag,
1218: iir.status
1219: FROM igi_iac_reval_asset_rules irar,
1220: igi_iac_revaluations iir,
1221: fa_additions fa
1222: WHERE irar.book_type_code = cp_book_type_code
1223: AND fa.asset_id = irar.asset_id
1224: AND irar.revaluation_id = iir.revaluation_id

Line 1226: FROM igi_iac_revaluations

1222: WHERE irar.book_type_code = cp_book_type_code
1223: AND fa.asset_id = irar.asset_id
1224: AND irar.revaluation_id = iir.revaluation_id
1225: AND irar.revaluation_id = (SELECT max(revaluation_id)
1226: FROM igi_iac_revaluations
1227: WHERE book_type_code = cp_book_type_code
1228: AND calling_program IN ('IGIIAIAR', 'SSUPLOAD') -- bug 3510376, add
1229: AND status in ('PREVIEWED', 'NEW', 'FAILED_PRE',
1230: 'FAILED_RUN', 'PREVIEW', 'UPDATED'));

Line 1233: -- l_book_type_code igi_iac_revaluations.book_type_code%TYPE;

1229: AND status in ('PREVIEWED', 'NEW', 'FAILED_PRE',
1230: 'FAILED_RUN', 'PREVIEW', 'UPDATED'));
1231:
1232: l_preview_exists c_preview_exists%ROWTYPE;
1233: -- l_book_type_code igi_iac_revaluations.book_type_code%TYPE;
1234: -- bug 3443410, end 1
1235:
1236: -- bug 3536362, start 1
1237: -- cursor to retrieve the historic portion of the cost of an asset

Line 1278: l_create_req_id igi_iac_revaluations.create_request_id%type := null;

1274: l_last_closed_period number;
1275: l_request_id Number;
1276: l_message varchar2(1000);
1277: l_get_period_rec igi_iac_types.prd_rec;
1278: l_create_req_id igi_iac_revaluations.create_request_id%type := null;
1279:
1280: -- bug 3412940, start 1
1281: l_reval_factor igi_iac_reval_asset_rules.revaluation_factor%TYPE;
1282: -- bug 3412940, end 1

Line 1299: Select igi_iac_revaluations_s.NEXTVAL

1295: comment this out - the nextval should be retrieved only if
1296: the upload process is allowed to create a NEW or PREVIEWED
1297: revaluation. Move it to after the Preview/New exists exception
1298: check
1299: Select igi_iac_revaluations_s.NEXTVAL
1300: Into l_reval_id
1301: From dual;
1302:
1303: bug 3443419, end 3 */

Line 1319: Select igi_iac_revaluations_s.NEXTVAL

1315: RAISE e_preview_exists;
1316: END IF;
1317: CLOSE c_preview_exists;
1318:
1319: Select igi_iac_revaluations_s.NEXTVAL
1320: Into l_reval_id
1321: From dual;
1322: -- mh end 4
1323:

Line 1351: Insert into igi_iac_revaluations(

1347: C_Upload_Hdr_Rec.period_counter,
1348: l_get_period_rec) Then
1349: l_reval_date := l_get_period_rec.period_end_date;
1350: End If;
1351: Insert into igi_iac_revaluations(
1352: Revaluation_Id,
1353: Book_Type_Code,
1354: Revaluation_Date ,
1355: Revaluation_Period ,