DBA Data[Home] [Help]

APPS.FA_CALC_DEPRN_BASIS2_PKG dependencies on FA_TRACK_MEMBER_PVT

Line 1106: FOR i IN 1 .. fa_track_member_pvt.p_track_member_table.COUNT LOOP

1102: close CUR_FULL_RSV_MEMBER_TRC;
1103:
1104: else -- used_by_adjsutment ='ADJUSTMENT'
1105:
1106: FOR i IN 1 .. fa_track_member_pvt.p_track_member_table.COUNT LOOP
1107: if fa_track_member_pvt.p_track_member_table(i).group_asset_id
1108: = px_rule_in.asset_id and
1109: fa_track_member_pvt.p_track_member_table(i).period_counter
1110: = px_rule_in.period_counter and

Line 1107: if fa_track_member_pvt.p_track_member_table(i).group_asset_id

1103:
1104: else -- used_by_adjsutment ='ADJUSTMENT'
1105:
1106: FOR i IN 1 .. fa_track_member_pvt.p_track_member_table.COUNT LOOP
1107: if fa_track_member_pvt.p_track_member_table(i).group_asset_id
1108: = px_rule_in.asset_id and
1109: fa_track_member_pvt.p_track_member_table(i).period_counter
1110: = px_rule_in.period_counter and
1111: nvl(fa_track_member_pvt.p_track_member_table(i).fully_reserved_flag,'N') = 'Y' then

Line 1109: fa_track_member_pvt.p_track_member_table(i).period_counter

1105:
1106: FOR i IN 1 .. fa_track_member_pvt.p_track_member_table.COUNT LOOP
1107: if fa_track_member_pvt.p_track_member_table(i).group_asset_id
1108: = px_rule_in.asset_id and
1109: fa_track_member_pvt.p_track_member_table(i).period_counter
1110: = px_rule_in.period_counter and
1111: nvl(fa_track_member_pvt.p_track_member_table(i).fully_reserved_flag,'N') = 'Y' then
1112:
1113: trc_fully_rsv_adjusted_cost := trc_fully_rsv_adjusted_cost +

Line 1111: nvl(fa_track_member_pvt.p_track_member_table(i).fully_reserved_flag,'N') = 'Y' then

1107: if fa_track_member_pvt.p_track_member_table(i).group_asset_id
1108: = px_rule_in.asset_id and
1109: fa_track_member_pvt.p_track_member_table(i).period_counter
1110: = px_rule_in.period_counter and
1111: nvl(fa_track_member_pvt.p_track_member_table(i).fully_reserved_flag,'N') = 'Y' then
1112:
1113: trc_fully_rsv_adjusted_cost := trc_fully_rsv_adjusted_cost +
1114: fa_track_member_pvt.p_track_member_table(i).adjusted_cost;
1115: trc_fully_rsv_salvage_value := trc_fully_rsv_salvage_value +

Line 1114: fa_track_member_pvt.p_track_member_table(i).adjusted_cost;

1110: = px_rule_in.period_counter and
1111: nvl(fa_track_member_pvt.p_track_member_table(i).fully_reserved_flag,'N') = 'Y' then
1112:
1113: trc_fully_rsv_adjusted_cost := trc_fully_rsv_adjusted_cost +
1114: fa_track_member_pvt.p_track_member_table(i).adjusted_cost;
1115: trc_fully_rsv_salvage_value := trc_fully_rsv_salvage_value +
1116: fa_track_member_pvt.p_track_member_table(i).salvage_value;
1117: trc_fully_rsv_recoverable_cost := trc_fully_rsv_recoverable_cost +
1118: fa_track_member_pvt.p_track_member_table(i).recoverable_cost;

Line 1116: fa_track_member_pvt.p_track_member_table(i).salvage_value;

1112:
1113: trc_fully_rsv_adjusted_cost := trc_fully_rsv_adjusted_cost +
1114: fa_track_member_pvt.p_track_member_table(i).adjusted_cost;
1115: trc_fully_rsv_salvage_value := trc_fully_rsv_salvage_value +
1116: fa_track_member_pvt.p_track_member_table(i).salvage_value;
1117: trc_fully_rsv_recoverable_cost := trc_fully_rsv_recoverable_cost +
1118: fa_track_member_pvt.p_track_member_table(i).recoverable_cost;
1119: trc_fully_rsv_deprn_reserve := trc_fully_rsv_deprn_reserve +
1120: fa_track_member_pvt.p_track_member_table(i).deprn_reserve;

Line 1118: fa_track_member_pvt.p_track_member_table(i).recoverable_cost;

1114: fa_track_member_pvt.p_track_member_table(i).adjusted_cost;
1115: trc_fully_rsv_salvage_value := trc_fully_rsv_salvage_value +
1116: fa_track_member_pvt.p_track_member_table(i).salvage_value;
1117: trc_fully_rsv_recoverable_cost := trc_fully_rsv_recoverable_cost +
1118: fa_track_member_pvt.p_track_member_table(i).recoverable_cost;
1119: trc_fully_rsv_deprn_reserve := trc_fully_rsv_deprn_reserve +
1120: fa_track_member_pvt.p_track_member_table(i).deprn_reserve;
1121:
1122: end if;

Line 1120: fa_track_member_pvt.p_track_member_table(i).deprn_reserve;

1116: fa_track_member_pvt.p_track_member_table(i).salvage_value;
1117: trc_fully_rsv_recoverable_cost := trc_fully_rsv_recoverable_cost +
1118: fa_track_member_pvt.p_track_member_table(i).recoverable_cost;
1119: trc_fully_rsv_deprn_reserve := trc_fully_rsv_deprn_reserve +
1120: fa_track_member_pvt.p_track_member_table(i).deprn_reserve;
1121:
1122: end if;
1123:
1124: END LOOP;

Line 1154: FOR i IN 1 .. fa_track_member_pvt.p_track_member_table.COUNT LOOP

1150: close MIN_TRC_PERIOD;
1151:
1152: else -- used_by_adjustment 'ADJUSTMENT'
1153:
1154: FOR i IN 1 .. fa_track_member_pvt.p_track_member_table.COUNT LOOP
1155: if fa_track_member_pvt.p_track_member_table(i).group_asset_id
1156: = px_rule_in.asset_id and
1157: fa_track_member_pvt.p_track_member_table(i).period_counter
1158: <= px_rule_in.period_counter and

Line 1155: if fa_track_member_pvt.p_track_member_table(i).group_asset_id

1151:
1152: else -- used_by_adjustment 'ADJUSTMENT'
1153:
1154: FOR i IN 1 .. fa_track_member_pvt.p_track_member_table.COUNT LOOP
1155: if fa_track_member_pvt.p_track_member_table(i).group_asset_id
1156: = px_rule_in.asset_id and
1157: fa_track_member_pvt.p_track_member_table(i).period_counter
1158: <= px_rule_in.period_counter and
1159: nvl(fa_track_member_pvt.p_track_member_table(i).fully_reserved_flag,'N') = 'Y' then

Line 1157: fa_track_member_pvt.p_track_member_table(i).period_counter

1153:
1154: FOR i IN 1 .. fa_track_member_pvt.p_track_member_table.COUNT LOOP
1155: if fa_track_member_pvt.p_track_member_table(i).group_asset_id
1156: = px_rule_in.asset_id and
1157: fa_track_member_pvt.p_track_member_table(i).period_counter
1158: <= px_rule_in.period_counter and
1159: nvl(fa_track_member_pvt.p_track_member_table(i).fully_reserved_flag,'N') = 'Y' then
1160:
1161: trc_fully_rsv_adjusted_cost := trc_fully_rsv_adjusted_cost +

Line 1159: nvl(fa_track_member_pvt.p_track_member_table(i).fully_reserved_flag,'N') = 'Y' then

1155: if fa_track_member_pvt.p_track_member_table(i).group_asset_id
1156: = px_rule_in.asset_id and
1157: fa_track_member_pvt.p_track_member_table(i).period_counter
1158: <= px_rule_in.period_counter and
1159: nvl(fa_track_member_pvt.p_track_member_table(i).fully_reserved_flag,'N') = 'Y' then
1160:
1161: trc_fully_rsv_adjusted_cost := trc_fully_rsv_adjusted_cost +
1162: fa_track_member_pvt.p_track_member_table(i).adjusted_cost;
1163: trc_fully_rsv_salvage_value := trc_fully_rsv_salvage_value +

Line 1162: fa_track_member_pvt.p_track_member_table(i).adjusted_cost;

1158: <= px_rule_in.period_counter and
1159: nvl(fa_track_member_pvt.p_track_member_table(i).fully_reserved_flag,'N') = 'Y' then
1160:
1161: trc_fully_rsv_adjusted_cost := trc_fully_rsv_adjusted_cost +
1162: fa_track_member_pvt.p_track_member_table(i).adjusted_cost;
1163: trc_fully_rsv_salvage_value := trc_fully_rsv_salvage_value +
1164: fa_track_member_pvt.p_track_member_table(i).salvage_value;
1165: trc_fully_rsv_recoverable_cost := trc_fully_rsv_recoverable_cost +
1166: fa_track_member_pvt.p_track_member_table(i).recoverable_cost;

Line 1164: fa_track_member_pvt.p_track_member_table(i).salvage_value;

1160:
1161: trc_fully_rsv_adjusted_cost := trc_fully_rsv_adjusted_cost +
1162: fa_track_member_pvt.p_track_member_table(i).adjusted_cost;
1163: trc_fully_rsv_salvage_value := trc_fully_rsv_salvage_value +
1164: fa_track_member_pvt.p_track_member_table(i).salvage_value;
1165: trc_fully_rsv_recoverable_cost := trc_fully_rsv_recoverable_cost +
1166: fa_track_member_pvt.p_track_member_table(i).recoverable_cost;
1167: trc_fully_rsv_deprn_reserve := trc_fully_rsv_deprn_reserve +
1168: fa_track_member_pvt.p_track_member_table(i).deprn_reserve;

Line 1166: fa_track_member_pvt.p_track_member_table(i).recoverable_cost;

1162: fa_track_member_pvt.p_track_member_table(i).adjusted_cost;
1163: trc_fully_rsv_salvage_value := trc_fully_rsv_salvage_value +
1164: fa_track_member_pvt.p_track_member_table(i).salvage_value;
1165: trc_fully_rsv_recoverable_cost := trc_fully_rsv_recoverable_cost +
1166: fa_track_member_pvt.p_track_member_table(i).recoverable_cost;
1167: trc_fully_rsv_deprn_reserve := trc_fully_rsv_deprn_reserve +
1168: fa_track_member_pvt.p_track_member_table(i).deprn_reserve;
1169:
1170: end if;

Line 1168: fa_track_member_pvt.p_track_member_table(i).deprn_reserve;

1164: fa_track_member_pvt.p_track_member_table(i).salvage_value;
1165: trc_fully_rsv_recoverable_cost := trc_fully_rsv_recoverable_cost +
1166: fa_track_member_pvt.p_track_member_table(i).recoverable_cost;
1167: trc_fully_rsv_deprn_reserve := trc_fully_rsv_deprn_reserve +
1168: fa_track_member_pvt.p_track_member_table(i).deprn_reserve;
1169:
1170: end if;
1171:
1172: END LOOP;

Line 1174: FOR i IN 1 .. fa_track_member_pvt.p_track_member_table.COUNT LOOP

1170: end if;
1171:
1172: END LOOP;
1173:
1174: FOR i IN 1 .. fa_track_member_pvt.p_track_member_table.COUNT LOOP
1175: if fa_track_member_pvt.p_track_member_table(i).period_counter <
1176: nvl(l_trc_min_period_counter,
1177: fa_track_member_pvt.p_track_member_table(i).period_counter+1) and
1178: fa_track_member_pvt.p_track_member_table(i).member_asset_id is not null then

Line 1175: if fa_track_member_pvt.p_track_member_table(i).period_counter <

1171:
1172: END LOOP;
1173:
1174: FOR i IN 1 .. fa_track_member_pvt.p_track_member_table.COUNT LOOP
1175: if fa_track_member_pvt.p_track_member_table(i).period_counter <
1176: nvl(l_trc_min_period_counter,
1177: fa_track_member_pvt.p_track_member_table(i).period_counter+1) and
1178: fa_track_member_pvt.p_track_member_table(i).member_asset_id is not null then
1179:

Line 1177: fa_track_member_pvt.p_track_member_table(i).period_counter+1) and

1173:
1174: FOR i IN 1 .. fa_track_member_pvt.p_track_member_table.COUNT LOOP
1175: if fa_track_member_pvt.p_track_member_table(i).period_counter <
1176: nvl(l_trc_min_period_counter,
1177: fa_track_member_pvt.p_track_member_table(i).period_counter+1) and
1178: fa_track_member_pvt.p_track_member_table(i).member_asset_id is not null then
1179:
1180: l_trc_min_period_counter := fa_track_member_pvt.p_track_member_table(i).period_counter;
1181: end if;

Line 1178: fa_track_member_pvt.p_track_member_table(i).member_asset_id is not null then

1174: FOR i IN 1 .. fa_track_member_pvt.p_track_member_table.COUNT LOOP
1175: if fa_track_member_pvt.p_track_member_table(i).period_counter <
1176: nvl(l_trc_min_period_counter,
1177: fa_track_member_pvt.p_track_member_table(i).period_counter+1) and
1178: fa_track_member_pvt.p_track_member_table(i).member_asset_id is not null then
1179:
1180: l_trc_min_period_counter := fa_track_member_pvt.p_track_member_table(i).period_counter;
1181: end if;
1182: END LOOP;

Line 1180: l_trc_min_period_counter := fa_track_member_pvt.p_track_member_table(i).period_counter;

1176: nvl(l_trc_min_period_counter,
1177: fa_track_member_pvt.p_track_member_table(i).period_counter+1) and
1178: fa_track_member_pvt.p_track_member_table(i).member_asset_id is not null then
1179:
1180: l_trc_min_period_counter := fa_track_member_pvt.p_track_member_table(i).period_counter;
1181: end if;
1182: END LOOP;
1183:
1184: if l_trc_min_period_counter is null then