DBA Data[Home] [Help]

APPS.PN_INDEX_RENT_PVT dependencies on PN_INDEX_LEASE_COMMON_PKG

Line 1581: IF pn_index_lease_common_pkg.find_if_period_exists(p_rent_index_rec.index_lease_id) IS NOT NULL

1577:
1578:
1579: IF p_rent_index_rec.termination_date <>l_rent_index_rec_old.termination_date
1580: THEN
1581: IF pn_index_lease_common_pkg.find_if_period_exists(p_rent_index_rec.index_lease_id) IS NOT NULL
1582: OR pn_index_lease_common_pkg.find_if_period_exists(p_rent_index_rec.index_lease_id)<> pn_index_rent_utils.g_pn_miss_num
1583: THEN
1584:
1585: pn_index_rent_periods_pkg.process_new_termination_date( p_index_lease_id => p_rent_index_rec.index_lease_id,

Line 1582: OR pn_index_lease_common_pkg.find_if_period_exists(p_rent_index_rec.index_lease_id)<> pn_index_rent_utils.g_pn_miss_num

1578:
1579: IF p_rent_index_rec.termination_date <>l_rent_index_rec_old.termination_date
1580: THEN
1581: IF pn_index_lease_common_pkg.find_if_period_exists(p_rent_index_rec.index_lease_id) IS NOT NULL
1582: OR pn_index_lease_common_pkg.find_if_period_exists(p_rent_index_rec.index_lease_id)<> pn_index_rent_utils.g_pn_miss_num
1583: THEN
1584:
1585: pn_index_rent_periods_pkg.process_new_termination_date( p_index_lease_id => p_rent_index_rec.index_lease_id,
1586: p_new_termination_date => p_rent_index_rec.termination_date,

Line 1625: AND (pn_index_lease_common_pkg.find_if_period_exists(l_rent_index_rec_old.index_lease_id) IS NOT NULL)

1621: */
1622: IF p_rent_index_rec.location_id IS NOT NULL AND p_rent_index_rec.location_id <> pn_index_rent_utils.g_pn_miss_num
1623: THEN
1624: IF p_rent_index_rec.index_lease_id IS NOT NULL AND p_rent_index_rec.index_lease_id <> pn_index_rent_utils.g_pn_miss_num
1625: AND (pn_index_lease_common_pkg.find_if_period_exists(l_rent_index_rec_old.index_lease_id) IS NOT NULL)
1626: THEN
1627:
1628: IF p_rent_index_rec.location_id<> l_rent_index_rec_old.location_id
1629: THEN

Line 1630: PN_INDEX_LEASE_COMMON_PKG.update_location_for_ir_terms(l_rent_index_rec_old.index_lease_id,

1626: THEN
1627:
1628: IF p_rent_index_rec.location_id<> l_rent_index_rec_old.location_id
1629: THEN
1630: PN_INDEX_LEASE_COMMON_PKG.update_location_for_ir_terms(l_rent_index_rec_old.index_lease_id,
1631: l_rent_index_rec_old.location_id,
1632: x_return_status);
1633: IF (x_return_status <> 'SUCCESS_FIRE_RECALC' AND
1634: x_return_status <> 'S') THEN

Line 1650: AND (pn_index_lease_common_pkg.find_if_period_exists(l_rent_index_rec_old.index_lease_id) IS NOT NULL)

1646:
1647: IF p_rent_index_rec.term_template_id IS NOT NULL AND p_rent_index_rec.term_template_id <> pn_index_rent_utils.g_pn_miss_num
1648: THEN
1649: IF p_rent_index_rec.index_lease_id IS NOT NULL AND p_rent_index_rec.index_lease_id <> pn_index_rent_utils.g_pn_miss_num
1650: AND (pn_index_lease_common_pkg.find_if_period_exists(l_rent_index_rec_old.index_lease_id) IS NOT NULL)
1651: THEN
1652:
1653: IF p_rent_index_rec.location_id<> l_rent_index_rec_old.location_id
1654: THEN

Line 1655: PN_INDEX_LEASE_COMMON_PKG.update_location_for_ir_terms(l_rent_index_rec_old.index_lease_id,

1651: THEN
1652:
1653: IF p_rent_index_rec.location_id<> l_rent_index_rec_old.location_id
1654: THEN
1655: PN_INDEX_LEASE_COMMON_PKG.update_location_for_ir_terms(l_rent_index_rec_old.index_lease_id,
1656: l_rent_index_rec_old.location_id,
1657: x_return_status);
1658: IF (x_return_status <> 'SUCCESS_FIRE_RECALC' AND
1659: x_return_status <> 'S') THEN

Line 3070: pn_index_lease_common_pkg.lookup_index_history

3066: --AND ( p_rent_index_rec.base_index_line_id IS NOT NULL
3067: -- AND p_rent_index_rec.base_index_line_id <> pn_index_rent_utils.g_pn_miss_num))
3068: )
3069: THEN
3070: pn_index_lease_common_pkg.lookup_index_history
3071: (p_index_history_id => p_rent_index_rec.index_id
3072: , p_index_finder_date => p_rent_index_rec.base_year
3073: , op_cpi_value => l_base_index --p_rent_index_rec.base_index
3074: , op_cpi_id => l_base_index_line_id --p_rent_index_rec.base_index_line_id

Line 3351: l_period_exists := pn_index_lease_common_pkg.find_if_period_exists( p_rent_index_rec.index_lease_id);

3347: AND p_rent_index_rec.termination_date<> pn_index_rent_utils.g_pn_miss_date
3348: THEN
3349:
3350:
3351: l_period_exists := pn_index_lease_common_pkg.find_if_period_exists( p_rent_index_rec.index_lease_id);
3352:
3353: IF l_period_exists IS NOT NULL THEN
3354:
3355: pn_index_rent_periods_pkg.process_new_termination_date(

Line 4467: pn_index_lease_common_pkg.find_if_period_exists (p_rent_index_rec.index_lease_id);

4463: || g_program_unit
4464: || ' Generating Periods '
4465: , 3);
4466: l_period_exists :=
4467: pn_index_lease_common_pkg.find_if_period_exists (p_rent_index_rec.index_lease_id);
4468:
4469: IF l_period_exists IS NULL
4470: THEN
4471: pn_index_rent_pvt.DEBUG ( g_pkg_name

Line 4627: pn_index_lease_common_pkg.chk_for_approved_index_periods( p_index_lease_id => p_rent_index_rec.index_lease_id,

4623: THEN
4624: RAISE fnd_api.g_exc_unexpected_error;
4625: ELSE
4626:
4627: pn_index_lease_common_pkg.chk_for_approved_index_periods( p_index_lease_id => p_rent_index_rec.index_lease_id,
4628: p_index_lease_period_id => NULL,
4629: p_chk_index_ind => 'N',
4630: p_msg => l_msg
4631: );

Line 4654: l_period_exists := pn_index_lease_common_pkg.find_if_period_exists (p_rent_index_rec.index_lease_id);

4650: pn_index_rent_pvt.DEBUG ( g_pkg_name
4651: || g_program_unit
4652: || ' Generating Periods '
4653: , 3);
4654: l_period_exists := pn_index_lease_common_pkg.find_if_period_exists (p_rent_index_rec.index_lease_id);
4655:
4656: IF l_period_exists IS NULL
4657: THEN
4658: pn_index_rent_pvt.DEBUG ( g_pkg_name