APPS.PN_VAR_RENTS_PKG dependencies on PN_VAR_RENTS_ALL

Line 61: FROM PN_VAR_RENTS_ALL

57: IS
58:
59: CURSOR var_rents IS
60: SELECT ROWID
61: FROM PN_VAR_RENTS_ALL
62: WHERE VAR_RENT_ID = X_VAR_RENT_ID ;
63:
64: CURSOR org_cur IS
65: SELECT org_id FROM pn_leases_all WHERE lease_id = x_lease_id;

Line 110: INSERT INTO PN_VAR_RENTS_ALL

106: ELSE
107: l_org_id := x_org_id;
108: END IF;
109:
110: INSERT INTO PN_VAR_RENTS_ALL
111: (
112: VAR_RENT_ID,
113: RENT_NUM,
114: LAST_UPDATE_DATE,

Line 268: FROM PN_VAR_RENTS_ALL

264: IS
265:
266: CURSOR c1 IS
267: SELECT *
268: FROM PN_VAR_RENTS_ALL
269: WHERE VAR_RENT_ID = X_VAR_RENT_ID
270: FOR UPDATE OF VAR_RENT_ID NOWAIT;
271:
272: tlinfo c1%rowtype;

Line 570: FROM PN_VAR_RENTS_ALL bkdetails

566: l_return_status := NULL;
567:
568: SELECT org_id
569: INTO l_org_id
570: FROM PN_VAR_RENTS_ALL bkdetails
571: WHERE VAR_RENT_ID = X_VAR_RENT_ID;
572:
573: PN_VAR_RENTS_PKG.CHECK_UNIQUE_RENT_NUMBER
574: (

Line 585: UPDATE PN_VAR_RENTS_ALL

581: IF (l_return_status IS NOT NULL) THEN
582: APP_EXCEPTION.Raise_Exception;
583: END IF;
584:
585: UPDATE PN_VAR_RENTS_ALL
586: SET
587: VAR_RENT_ID = X_VAR_RENT_ID,
588: RENT_NUM = X_RENT_NUM,
589: LEASE_ID = X_LEASE_ID,

Line 657: DELETE FROM PN_VAR_RENTS_ALL

653: IS
654: BEGIN
655: PNP_DEBUG_PKG.debug ('PN_VAR_RENTS_PKG.DELETE_ROW (+)');
656:
657: DELETE FROM PN_VAR_RENTS_ALL
658: WHERE VAR_RENT_ID = X_VAR_RENT_ID;
659:
660: IF (sql%notfound) THEN
661: RAISE NO_DATA_FOUND;

Line 694: FROM pn_var_rents_all pnvr

690: FROM dual
691: WHERE not exists
692: (
693: SELECT 1
694: FROM pn_var_rents_all pnvr
695: WHERE pnvr.rent_num = x_rent_num
696: AND ((x_var_rent_id is null) or
697: (pnvr.var_rent_id <> x_var_rent_id))
698: AND org_id = x_org_id

Line 721: ( p_pn_var_rents_rec IN pn_var_rents_all%rowtype DEFAULT NULL,

717: -- 24-APR-06 pikhar o Added for Codev.
718: -------------------------------------------------------------------------------
719:
720: PROCEDURE CREATE_VAR_RENT_AGREEMENT
721: ( p_pn_var_rents_rec IN pn_var_rents_all%rowtype DEFAULT NULL,
722: p_var_rent_dates_rec IN pn_var_rent_dates_all%rowtype DEFAULT NULL,
723: p_create_periods IN VARCHAR2 DEFAULT 'N',
724: x_var_rent_id OUT NOCOPY NUMBER,
725: x_var_rent_num OUT NOCOPY VARCHAR2)

Line 866: UPDATE pn_var_rents_all

862: IS
863: BEGIN
864: PNP_DEBUG_PKG.debug ('PN_VAR_RENTS_PKG.MODIF_VAR_RENT (+)');
865:
866: UPDATE pn_var_rents_all
867: SET excess_abat_code = x_excess_abat_code,
868: order_of_appl_code = x_order_of_appl_code,
869: LAST_UPDATE_DATE = sysdate,
870: LAST_UPDATED_BY = NVL(fnd_profile.value('USER_ID'),-1),

Line 895: FROM pn_var_rents_all vrent

891: p_termination_dt IN DATE)
892: IS
893: CURSOR get_var_rents(p1_lease_id IN NUMBER,p1_termination_dt IN DATE) IS
894: SELECT var_rent_id
895: FROM pn_var_rents_all vrent
896: WHERE lease_id = p1_lease_id
897: AND commencement_date > p1_termination_dt
898: AND NOT EXISTS ( SELECT NULL
899: FROM pn_payment_schedules_all ps,

Line 928: DELETE FROM pn_var_rents_all

924:
925: DELETE FROM pn_var_rent_dates_all
926: WHERE var_rent_id=l_varent_id;
927:
928: DELETE FROM pn_var_rents_all
929: WHERE var_rent_id=l_varent_id;
930:
931: IF SQL%NOTFOUND THEN
932: NULL;