APPS.PN_LEASE_DETAILS_PKG dependencies on PN_LEASE_DETAILS_ALL

Line 53: FROM pn_lease_details_all

49: )
50: IS
51: CURSOR c IS
52: SELECT ROWID
53: FROM pn_lease_details_all
54: WHERE lease_detail_id = x_lease_detail_id;
55:
56:
57: CURSOR org_cur IS

Line 76: INSERT INTO pn_lease_details_all

72: ELSE
73: l_org_id := x_org_id;
74: END IF;
75:
76: INSERT INTO pn_lease_details_all
77: (
78: lease_detail_id
79: ,lease_change_id
80: ,lease_id

Line 216: FROM pn_lease_details_all pld,

212: SELECT pld.*,
213: pll.name,
214: pll.lease_num,
215: pll.lease_status
216: FROM pn_lease_details_all pld,
217: pn_leases_all pll
218: WHERE pld.lease_detail_id = x_lease_detail_id
219: AND pld.lease_id = pll.lease_id
220: FOR UPDATE OF pld.lease_detail_id NOWAIT;

Line 451: FROM pn_lease_details_all ldt,

447: )
448: IS
449: CURSOR c2 IS
450: SELECT ldt.*, pnl.name, pnl.lease_num, pnl.lease_status
451: FROM pn_lease_details_all ldt,
452: pn_leases_all pnl
453: WHERE lease_detail_id = x_lease_detail_id
454: AND ldt.lease_id = pnl.lease_id;
455:

Line 558: UPDATE pn_lease_details_all

554: );
555: END IF;
556: END IF;
557:
558: UPDATE pn_lease_details_all
559: SET lease_change_id = x_lease_change_id
560: ,responsible_user = x_responsible_user
561: ,expense_account_id = x_expense_account_id
562: ,lease_commencement_date = x_lease_commencement_date

Line 616: DELETE FROM pn_lease_details_all

612: BEGIN
613:
614: pnp_debug_pkg.debug('PN_LEASE_DETAILS_PKG.Delete_Row (+)');
615:
616: DELETE FROM pn_lease_details_all
617: WHERE lease_detail_id = x_lease_detail_id;
618:
619: IF(SQL%NOTFOUND) THEN
620: RAISE NO_DATA_FOUND;