APPS.IGI_IAC_WEBADI_PKG dependencies on IGI_IAC_REVALUATIONS

Line 1206: igi_iac_revaluations iir,

1202: fa.asset_number,
1203: irar.selected_for_reval_flag,
1204: iir.status
1205: FROM igi_iac_reval_asset_rules irar,
1206: igi_iac_revaluations iir,
1207: fa_additions fa
1208: WHERE irar.book_type_code = cp_book_type_code
1209: AND fa.asset_id = irar.asset_id
1210: AND irar.revaluation_id = iir.revaluation_id

Line 1212: FROM igi_iac_revaluations

1208: WHERE irar.book_type_code = cp_book_type_code
1209: AND fa.asset_id = irar.asset_id
1210: AND irar.revaluation_id = iir.revaluation_id
1211: AND irar.revaluation_id = (SELECT max(revaluation_id)
1212: FROM igi_iac_revaluations
1213: WHERE book_type_code = cp_book_type_code
1214: AND calling_program IN ('IGIIAIAR', 'SSUPLOAD') -- bug 3510376, add
1215: AND status in ('PREVIEWED', 'NEW', 'FAILED_PRE',
1216: 'FAILED_RUN', 'PREVIEW', 'UPDATED'));

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

1215: AND status in ('PREVIEWED', 'NEW', 'FAILED_PRE',
1216: 'FAILED_RUN', 'PREVIEW', 'UPDATED'));
1217:
1218: l_preview_exists c_preview_exists%ROWTYPE;
1219: -- l_book_type_code igi_iac_revaluations.book_type_code%TYPE;
1220: -- bug 3443410, end 1
1221:
1222: -- bug 3536362, start 1
1223: -- cursor to retrieve the historic portion of the cost of an asset

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

1257: l_last_closed_period number;
1258: l_request_id Number;
1259: l_message varchar2(1000);
1260: l_get_period_rec igi_iac_types.prd_rec;
1261: l_create_req_id igi_iac_revaluations.create_request_id%type := null;
1262:
1263: -- bug 3412940, start 1
1264: l_reval_factor igi_iac_reval_asset_rules.revaluation_factor%TYPE;
1265: -- bug 3412940, end 1

Line 1282: Select igi_iac_revaluations_s.NEXTVAL

1278: comment this out - the nextval should be retrieved only if
1279: the upload process is allowed to create a NEW or PREVIEWED
1280: revaluation. Move it to after the Preview/New exists exception
1281: check
1282: Select igi_iac_revaluations_s.NEXTVAL
1283: Into l_reval_id
1284: From dual;
1285:
1286: bug 3443419, end 3 */

Line 1302: Select igi_iac_revaluations_s.NEXTVAL

1298: RAISE e_preview_exists;
1299: END IF;
1300: CLOSE c_preview_exists;
1301:
1302: Select igi_iac_revaluations_s.NEXTVAL
1303: Into l_reval_id
1304: From dual;
1305: -- mh end 4
1306:

Line 1334: Insert into igi_iac_revaluations(

1330: C_Upload_Hdr_Rec.period_counter,
1331: l_get_period_rec) Then
1332: l_reval_date := l_get_period_rec.period_end_date;
1333: End If;
1334: Insert into igi_iac_revaluations(
1335: Revaluation_Id,
1336: Book_Type_Code,
1337: Revaluation_Date ,
1338: Revaluation_Period ,