APPS.PN_LEASE_DETAILS_PKG dependencies on PN_LEASE_DETAILS_HISTORY

Line 404: -- PN_LEASE_DETAILS_HISTORY update

400: -- 19-MAR-02 lkatputu o Added Send_Entries into the table handler
401: -- as per the 'DO NOT SEND' enhancement requirement.
402: -- 11-APR-02 lkatputu o Bug Fix for the ID#2300965.
403: -- Added the sEND_entries column IN the
404: -- PN_LEASE_DETAILS_HISTORY update
405: -- to get a before and after picture for the sEND_entries.
406: -- 25-SEP-02 graghuna o Added parameter x_lease_status_old.
407: -- 25-OCT-02 STripathi o Removed parametes x_name_old, x_lease_num_old and
408: -- x_lease_status_old. Added columns name, lease_num,

Line 479: INSERT INTO pn_lease_details_history

475: CLOSE c2;
476:
477: IF(recInfoForHist.lease_change_id <> x_lease_change_id) THEN
478:
479: INSERT INTO pn_lease_details_history
480: (
481: detail_history_id
482: ,lease_detail_id
483: ,lease_change_id

Line 519: pn_lease_details_history_s.NEXTVAL

515: ,lease_extension_end_date
516: )
517: VALUES
518: (
519: pn_lease_details_history_s.NEXTVAL
520: ,recInfoForHist.lease_detail_id
521: ,recInfoForHist.lease_change_id
522: ,x_lease_change_id
523: ,recInfoForHist.lease_id