DBA Data[Home] [Help]

APPS.PNRX_RENT_INCREASE_DETAIL dependencies on PN_RENT_INCREASE_DETAIL_ITF

Line 63: term_rec pn_rent_increase_detail_itf%ROWTYPE;

59: l_lease_detail lease_detail;
60: l_lease_detail_null lease_detail;
61: c_lease_pn cur_typ;
62: -- term_Rec c_lease_pn%ROWTYPE;
63: term_rec pn_rent_increase_detail_itf%ROWTYPE;
64: term_rec_null pn_rent_increase_detail_itf%ROWTYPE;
65: query_str VARCHAR2 (20000);
66: --declare the 'where clauses here........'
67: lease_number_where_clause VARCHAR2 (4000) := NULL;

Line 64: term_rec_null pn_rent_increase_detail_itf%ROWTYPE;

60: l_lease_detail_null lease_detail;
61: c_lease_pn cur_typ;
62: -- term_Rec c_lease_pn%ROWTYPE;
63: term_rec pn_rent_increase_detail_itf%ROWTYPE;
64: term_rec_null pn_rent_increase_detail_itf%ROWTYPE;
65: query_str VARCHAR2 (20000);
66: --declare the 'where clauses here........'
67: lease_number_where_clause VARCHAR2 (4000) := NULL;
68: ri_number_where_clause VARCHAR2 (4000) := NULL;

Line 781: INSERT INTO pn_rent_increase_detail_itf

777: NULL;
778: END;
779:
780:
781: INSERT INTO pn_rent_increase_detail_itf
782: (name,
783: lease_num,
784: payment_term_proration_rule,
785: lease_class_meaning,