DBA Data[Home] [Help]

APPS.PNRX_RENT_INCREASE_DETAILACC dependencies on PN_RENT_INCREASE_DETAILACC_ITF

Line 42: term_rec pn_rent_increase_detailacc_itf%ROWTYPE;

38: TYPE cur_typ IS REF CURSOR;
39:
40: c_lease_pn cur_typ;
41: -- term_Rec c_lease_pn%ROWTYPE;
42: term_rec pn_rent_increase_detailacc_itf%ROWTYPE;
43: term_rec_null pn_rent_increase_detailacc_itf%ROWTYPE;
44: query_str VARCHAR2 (20000);
45: --declare the 'where clauses here........'
46: lease_number_where_clause VARCHAR2 (4000) := NULL;

Line 43: term_rec_null pn_rent_increase_detailacc_itf%ROWTYPE;

39:
40: c_lease_pn cur_typ;
41: -- term_Rec c_lease_pn%ROWTYPE;
42: term_rec pn_rent_increase_detailacc_itf%ROWTYPE;
43: term_rec_null pn_rent_increase_detailacc_itf%ROWTYPE;
44: query_str VARCHAR2 (20000);
45: --declare the 'where clauses here........'
46: lease_number_where_clause VARCHAR2 (4000) := NULL;
47: ri_number_where_clause VARCHAR2 (4000) := NULL;

Line 810: INSERT INTO pn_rent_increase_detailacc_itf

806: WHEN OTHERS THEN
807: NULL;
808: END;
809:
810: INSERT INTO pn_rent_increase_detailacc_itf
811: (name,
812: lease_num,
813: payment_term_proration_rule,
814: abstracted_by_user_name,