APPS.PN_INDEX_LEASE_PERIODS_PKG dependencies on PN_INDEX_LEASE_PERIODS_ALL

Line 94: FROM pn_index_lease_periods_all

90: ,x_index_multiplier IN NUMBER)
91: IS
92: CURSOR c IS
93: SELECT ROWID
94: FROM pn_index_lease_periods_all
95: WHERE index_period_id = x_index_period_id;
96:
97: l_return_status VARCHAR2 (30) := NULL;
98: l_rowid VARCHAR2 (18) := NULL;

Line 120: FROM pn_index_lease_periods_all a

116:
117: IF x_line_number IS NULL THEN
118: SELECT NVL(MAX (line_number),0) + 1
119: INTO x_line_number
120: FROM pn_index_lease_periods_all a
121: WHERE index_lease_id = x_index_lease_id
122: AND a.org_id = x_org_id;
123: END IF;
124:

Line 133: INSERT INTO pn_index_lease_periods_all

129: ELSE
130: l_org_id := x_org_id;
131: END IF;
132:
133: INSERT INTO pn_index_lease_periods_all
134: (
135: index_period_id
136: ,org_id
137: ,index_lease_id

Line 292: UPDATE pn_index_lease_periods_all

288: THEN
289: app_exception.raise_exception;
290: END IF;
291:
292: UPDATE pn_index_lease_periods_all
293: SET index_lease_id = x_index_lease_id
294: ,line_number = x_line_number
295: ,assessment_date = x_assessment_date
296: ,last_update_date = x_last_update_date

Line 331: WHERE pn_index_lease_periods_all.index_period_id = x_index_period_id;

327: ,attribute15 = x_attribute15
328: ,index_multiplier = x_index_multiplier
329: ,constraint_applied_amount = x_constraint_applied_amount
330: ,constraint_applied_percent = x_constraint_applied_percent
331: WHERE pn_index_lease_periods_all.index_period_id = x_index_period_id;
332:
333:
334: IF (SQL%NOTFOUND)
335: THEN

Line 415: UPDATE pn_index_lease_periods_all

411: app_exception.raise_exception;
412: END IF;
413:
414:
415: UPDATE pn_index_lease_periods_all
416: SET index_lease_id = x_index_lease_id
417: ,line_number = x_line_number
418: ,assessment_date = x_assessment_date
419: ,last_update_date = x_last_update_date

Line 454: WHERE pn_index_lease_periods_all.index_period_id = x_index_period_id;

450: ,attribute15 = x_attribute15
451: ,index_multiplier = x_index_multiplier
452: ,constraint_applied_amount = x_constraint_applied_amount
453: ,constraint_applied_percent = x_constraint_applied_percent
454: WHERE pn_index_lease_periods_all.index_period_id = x_index_period_id;
455:
456:
457: IF (SQL%NOTFOUND)
458: THEN

Line 493: UPDATE pn_index_lease_periods_all

489: op_msg => l_msg
490: );
491:
492:
493: UPDATE pn_index_lease_periods_all
494: SET index_lease_id = x_index_lease_id
495: ,line_number = x_line_number
496: ,assessment_date = x_assessment_date
497: ,last_update_date = x_last_update_date

Line 607: FROM pn_index_lease_periods_all

603: ,x_constraint_applied_percent IN NUMBER)
604: IS
605: CURSOR c1 IS
606: SELECT *
607: FROM pn_index_lease_periods_all
608: WHERE index_period_id = x_index_period_id
609: FOR UPDATE OF index_period_id NOWAIT;
610:
611: tlinfo c1%ROWTYPE;

Line 736: DELETE FROM pn_index_lease_periods_all

732: PROCEDURE delete_row (x_rowid IN VARCHAR2)
733: IS
734: BEGIN
735: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_PERIODS_PKG.delete_row (+)');
736: DELETE FROM pn_index_lease_periods_all
737: WHERE ROWID = x_rowid;
738:
739: IF (SQL%NOTFOUND)
740: THEN

Line 759: DELETE FROM pn_index_lease_periods_all

755: PROCEDURE delete_row (x_index_period_id IN NUMBER)
756: IS
757: BEGIN
758: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_PERIODS_PKG.delete_row (+)');
759: DELETE FROM pn_index_lease_periods_all
760: WHERE index_period_id = x_index_period_id;
761:
762: IF (SQL%NOTFOUND)
763: THEN