DBA Data[Home] [Help]

APPS.FA_CALC_DEPRN_BASIS2_PKG dependencies on FA_TRACK_MEMBER_PVT

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

920: close CUR_FULL_RSV_MEMBER_TRC;
921:
922: else -- used_by_adjsutment ='ADJUSTMENT'
923:
924: FOR i IN 1 .. fa_track_member_pvt.p_track_member_table.COUNT LOOP
925: if fa_track_member_pvt.p_track_member_table(i).group_asset_id
926: = px_rule_in.asset_id and
927: fa_track_member_pvt.p_track_member_table(i).period_counter
928: = px_rule_in.period_counter and

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

921:
922: else -- used_by_adjsutment ='ADJUSTMENT'
923:
924: FOR i IN 1 .. fa_track_member_pvt.p_track_member_table.COUNT LOOP
925: if fa_track_member_pvt.p_track_member_table(i).group_asset_id
926: = px_rule_in.asset_id and
927: fa_track_member_pvt.p_track_member_table(i).period_counter
928: = px_rule_in.period_counter and
929: nvl(fa_track_member_pvt.p_track_member_table(i).fully_reserved_flag,'N') = 'Y' then

Line 927: fa_track_member_pvt.p_track_member_table(i).period_counter

923:
924: FOR i IN 1 .. fa_track_member_pvt.p_track_member_table.COUNT LOOP
925: if fa_track_member_pvt.p_track_member_table(i).group_asset_id
926: = px_rule_in.asset_id and
927: fa_track_member_pvt.p_track_member_table(i).period_counter
928: = px_rule_in.period_counter and
929: nvl(fa_track_member_pvt.p_track_member_table(i).fully_reserved_flag,'N') = 'Y' then
930:
931: trc_fully_rsv_adjusted_cost := trc_fully_rsv_adjusted_cost +

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

925: if fa_track_member_pvt.p_track_member_table(i).group_asset_id
926: = px_rule_in.asset_id and
927: fa_track_member_pvt.p_track_member_table(i).period_counter
928: = px_rule_in.period_counter and
929: nvl(fa_track_member_pvt.p_track_member_table(i).fully_reserved_flag,'N') = 'Y' then
930:
931: trc_fully_rsv_adjusted_cost := trc_fully_rsv_adjusted_cost +
932: fa_track_member_pvt.p_track_member_table(i).adjusted_cost;
933: trc_fully_rsv_salvage_value := trc_fully_rsv_salvage_value +

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

928: = px_rule_in.period_counter and
929: nvl(fa_track_member_pvt.p_track_member_table(i).fully_reserved_flag,'N') = 'Y' then
930:
931: trc_fully_rsv_adjusted_cost := trc_fully_rsv_adjusted_cost +
932: fa_track_member_pvt.p_track_member_table(i).adjusted_cost;
933: trc_fully_rsv_salvage_value := trc_fully_rsv_salvage_value +
934: fa_track_member_pvt.p_track_member_table(i).salvage_value;
935: trc_fully_rsv_recoverable_cost := trc_fully_rsv_recoverable_cost +
936: fa_track_member_pvt.p_track_member_table(i).recoverable_cost;

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

930:
931: trc_fully_rsv_adjusted_cost := trc_fully_rsv_adjusted_cost +
932: fa_track_member_pvt.p_track_member_table(i).adjusted_cost;
933: trc_fully_rsv_salvage_value := trc_fully_rsv_salvage_value +
934: fa_track_member_pvt.p_track_member_table(i).salvage_value;
935: trc_fully_rsv_recoverable_cost := trc_fully_rsv_recoverable_cost +
936: fa_track_member_pvt.p_track_member_table(i).recoverable_cost;
937: trc_fully_rsv_deprn_reserve := trc_fully_rsv_deprn_reserve +
938: fa_track_member_pvt.p_track_member_table(i).deprn_reserve;

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

932: fa_track_member_pvt.p_track_member_table(i).adjusted_cost;
933: trc_fully_rsv_salvage_value := trc_fully_rsv_salvage_value +
934: fa_track_member_pvt.p_track_member_table(i).salvage_value;
935: trc_fully_rsv_recoverable_cost := trc_fully_rsv_recoverable_cost +
936: fa_track_member_pvt.p_track_member_table(i).recoverable_cost;
937: trc_fully_rsv_deprn_reserve := trc_fully_rsv_deprn_reserve +
938: fa_track_member_pvt.p_track_member_table(i).deprn_reserve;
939:
940: end if;

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

934: fa_track_member_pvt.p_track_member_table(i).salvage_value;
935: trc_fully_rsv_recoverable_cost := trc_fully_rsv_recoverable_cost +
936: fa_track_member_pvt.p_track_member_table(i).recoverable_cost;
937: trc_fully_rsv_deprn_reserve := trc_fully_rsv_deprn_reserve +
938: fa_track_member_pvt.p_track_member_table(i).deprn_reserve;
939:
940: end if;
941:
942: END LOOP;

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

968: close MIN_TRC_PERIOD;
969:
970: else -- used_by_adjustment 'ADJUSTMENT'
971:
972: FOR i IN 1 .. fa_track_member_pvt.p_track_member_table.COUNT LOOP
973: if fa_track_member_pvt.p_track_member_table(i).group_asset_id
974: = px_rule_in.asset_id and
975: fa_track_member_pvt.p_track_member_table(i).period_counter
976: <= px_rule_in.period_counter and

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

969:
970: else -- used_by_adjustment 'ADJUSTMENT'
971:
972: FOR i IN 1 .. fa_track_member_pvt.p_track_member_table.COUNT LOOP
973: if fa_track_member_pvt.p_track_member_table(i).group_asset_id
974: = px_rule_in.asset_id and
975: fa_track_member_pvt.p_track_member_table(i).period_counter
976: <= px_rule_in.period_counter and
977: nvl(fa_track_member_pvt.p_track_member_table(i).fully_reserved_flag,'N') = 'Y' then

Line 975: fa_track_member_pvt.p_track_member_table(i).period_counter

971:
972: FOR i IN 1 .. fa_track_member_pvt.p_track_member_table.COUNT LOOP
973: if fa_track_member_pvt.p_track_member_table(i).group_asset_id
974: = px_rule_in.asset_id and
975: fa_track_member_pvt.p_track_member_table(i).period_counter
976: <= px_rule_in.period_counter and
977: nvl(fa_track_member_pvt.p_track_member_table(i).fully_reserved_flag,'N') = 'Y' then
978:
979: trc_fully_rsv_adjusted_cost := trc_fully_rsv_adjusted_cost +

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

973: if fa_track_member_pvt.p_track_member_table(i).group_asset_id
974: = px_rule_in.asset_id and
975: fa_track_member_pvt.p_track_member_table(i).period_counter
976: <= px_rule_in.period_counter and
977: nvl(fa_track_member_pvt.p_track_member_table(i).fully_reserved_flag,'N') = 'Y' then
978:
979: trc_fully_rsv_adjusted_cost := trc_fully_rsv_adjusted_cost +
980: fa_track_member_pvt.p_track_member_table(i).adjusted_cost;
981: trc_fully_rsv_salvage_value := trc_fully_rsv_salvage_value +

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

976: <= px_rule_in.period_counter and
977: nvl(fa_track_member_pvt.p_track_member_table(i).fully_reserved_flag,'N') = 'Y' then
978:
979: trc_fully_rsv_adjusted_cost := trc_fully_rsv_adjusted_cost +
980: fa_track_member_pvt.p_track_member_table(i).adjusted_cost;
981: trc_fully_rsv_salvage_value := trc_fully_rsv_salvage_value +
982: fa_track_member_pvt.p_track_member_table(i).salvage_value;
983: trc_fully_rsv_recoverable_cost := trc_fully_rsv_recoverable_cost +
984: fa_track_member_pvt.p_track_member_table(i).recoverable_cost;

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

978:
979: trc_fully_rsv_adjusted_cost := trc_fully_rsv_adjusted_cost +
980: fa_track_member_pvt.p_track_member_table(i).adjusted_cost;
981: trc_fully_rsv_salvage_value := trc_fully_rsv_salvage_value +
982: fa_track_member_pvt.p_track_member_table(i).salvage_value;
983: trc_fully_rsv_recoverable_cost := trc_fully_rsv_recoverable_cost +
984: fa_track_member_pvt.p_track_member_table(i).recoverable_cost;
985: trc_fully_rsv_deprn_reserve := trc_fully_rsv_deprn_reserve +
986: fa_track_member_pvt.p_track_member_table(i).deprn_reserve;

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

980: fa_track_member_pvt.p_track_member_table(i).adjusted_cost;
981: trc_fully_rsv_salvage_value := trc_fully_rsv_salvage_value +
982: fa_track_member_pvt.p_track_member_table(i).salvage_value;
983: trc_fully_rsv_recoverable_cost := trc_fully_rsv_recoverable_cost +
984: fa_track_member_pvt.p_track_member_table(i).recoverable_cost;
985: trc_fully_rsv_deprn_reserve := trc_fully_rsv_deprn_reserve +
986: fa_track_member_pvt.p_track_member_table(i).deprn_reserve;
987:
988: end if;

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

982: fa_track_member_pvt.p_track_member_table(i).salvage_value;
983: trc_fully_rsv_recoverable_cost := trc_fully_rsv_recoverable_cost +
984: fa_track_member_pvt.p_track_member_table(i).recoverable_cost;
985: trc_fully_rsv_deprn_reserve := trc_fully_rsv_deprn_reserve +
986: fa_track_member_pvt.p_track_member_table(i).deprn_reserve;
987:
988: end if;
989:
990: END LOOP;

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

988: end if;
989:
990: END LOOP;
991:
992: FOR i IN 1 .. fa_track_member_pvt.p_track_member_table.COUNT LOOP
993: if fa_track_member_pvt.p_track_member_table(i).period_counter <
994: nvl(l_trc_min_period_counter,
995: fa_track_member_pvt.p_track_member_table(i).period_counter+1) and
996: fa_track_member_pvt.p_track_member_table(i).member_asset_id is not null then

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

989:
990: END LOOP;
991:
992: FOR i IN 1 .. fa_track_member_pvt.p_track_member_table.COUNT LOOP
993: if fa_track_member_pvt.p_track_member_table(i).period_counter <
994: nvl(l_trc_min_period_counter,
995: fa_track_member_pvt.p_track_member_table(i).period_counter+1) and
996: fa_track_member_pvt.p_track_member_table(i).member_asset_id is not null then
997:

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

991:
992: FOR i IN 1 .. fa_track_member_pvt.p_track_member_table.COUNT LOOP
993: if fa_track_member_pvt.p_track_member_table(i).period_counter <
994: nvl(l_trc_min_period_counter,
995: fa_track_member_pvt.p_track_member_table(i).period_counter+1) and
996: fa_track_member_pvt.p_track_member_table(i).member_asset_id is not null then
997:
998: l_trc_min_period_counter := fa_track_member_pvt.p_track_member_table(i).period_counter;
999: end if;

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

992: FOR i IN 1 .. fa_track_member_pvt.p_track_member_table.COUNT LOOP
993: if fa_track_member_pvt.p_track_member_table(i).period_counter <
994: nvl(l_trc_min_period_counter,
995: fa_track_member_pvt.p_track_member_table(i).period_counter+1) and
996: fa_track_member_pvt.p_track_member_table(i).member_asset_id is not null then
997:
998: l_trc_min_period_counter := fa_track_member_pvt.p_track_member_table(i).period_counter;
999: end if;
1000: END LOOP;

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

994: nvl(l_trc_min_period_counter,
995: fa_track_member_pvt.p_track_member_table(i).period_counter+1) and
996: fa_track_member_pvt.p_track_member_table(i).member_asset_id is not null then
997:
998: l_trc_min_period_counter := fa_track_member_pvt.p_track_member_table(i).period_counter;
999: end if;
1000: END LOOP;
1001:
1002: if l_trc_min_period_counter is null then