APPS.PN_INDEX_RENT_PVT dependencies on PN_INDEX_LEASES_ALL

Line 1171: -- Procedure to update pn_index_leases_all table with the provided index rent new values.

1167: x_return_status := fnd_api.g_ret_sts_unexp_error;
1168: END init_index_rent_rec;
1169:
1170: -----------------------------------------------------------------------------------------
1171: -- Procedure to update pn_index_leases_all table with the provided index rent new values.
1172: -----------------------------------------------------------------------------------------
1173: PROCEDURE update_index_rent_row (
1174: p_rent_index_rec IN OUT NOCOPY rent_index_rec
1175: , x_return_status OUT NOCOPY VARCHAR2

Line 1295: -- Procedure to insert index rent record into pn_index_leases_all table

1291: , 5);
1292: x_return_status := fnd_api.g_ret_sts_unexp_error;
1293: END update_index_rent_row;
1294: ------------------------------------------------------------------------
1295: -- Procedure to insert index rent record into pn_index_leases_all table
1296: ------------------------------------------------------------------------
1297: PROCEDURE insert_index_rent_row (
1298: p_rent_index_rec IN OUT NOCOPY rent_index_rec
1299: , x_return_status OUT NOCOPY VARCHAR2

Line 1436: -- Procedure to get the changed index rent fields for updating pn_index_leases_all table

1432: x_return_status := fnd_api.g_ret_sts_unexp_error;
1433: END insert_index_rent_row;
1434:
1435: -----------------------------------------------------------------------------------------
1436: -- Procedure to get the changed index rent fields for updating pn_index_leases_all table
1437: -----------------------------------------------------------------------------------------
1438: PROCEDURE get_changed_index_rent_rec (
1439: p_rent_index_rec IN OUT NOCOPY rent_index_rec
1440: , x_return_status OUT NOCOPY VARCHAR2

Line 1521: FROM pn_index_leases_all

1517: , constraint_proration
1518: , vr_nbp_flag
1519: , proration_rule
1520: , proration_period_start_date
1521: FROM pn_index_leases_all
1522: WHERE index_lease_id = p_index_lease_id;
1523:
1524: l_rent_index_rec_old pn_index_leases_all%ROWTYPE;
1525: BEGIN

Line 1524: l_rent_index_rec_old pn_index_leases_all%ROWTYPE;

1520: , proration_period_start_date
1521: FROM pn_index_leases_all
1522: WHERE index_lease_id = p_index_lease_id;
1523:
1524: l_rent_index_rec_old pn_index_leases_all%ROWTYPE;
1525: BEGIN
1526: g_program_unit := 'GET_CHANGED_INDEX_RENT_REC';
1527: x_return_status := fnd_api.g_ret_sts_success;
1528: pn_index_rent_pvt.DEBUG ( g_pkg_name