eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PN_INDEX_LEASE_PERIODS_PKG dependencies on PN_INDEX_LEASE_PERIODS

Line 1: PACKAGE BODY pn_index_lease_periods_pkg AS

1: PACKAGE BODY pn_index_lease_periods_pkg AS
2: -- $Header: PNTINLPB.pls 120.4 2007/03/14 12:58:14 pseeram ship $
3:
4: /*============================================================================+
5: | Copyright (c) 2001 Oracle Corporation

Line 11: | PN_INDEX_LEASE_PERIODS table.

Line 13: | INSERT_ROW - insert a row into PN_INDEX_LEASE_PERIODS.

Line 14: | DELETE_ROW - deletes a row from PN_INDEX_LEASE_PERIODS.

10: | These procedures consist are used a table handlers for the
11: | PN_INDEX_LEASE_PERIODS table.
12: | They include:
13: | INSERT_ROW - insert a row into PN_INDEX_LEASE_PERIODS.
14: | DELETE_ROW - deletes a row from PN_INDEX_LEASE_PERIODS.
15: | UPDATE_ROW - updates a row from PN_INDEX_LEASE_PERIODS.
16: | LOCKS_ROW - will check if a row has been modified since
17: | being queried by form.
18: |

Line 15: | UPDATE_ROW - updates a row from PN_INDEX_LEASE_PERIODS.

Line 44: -- 04-JUL-05 hrodda o Bug 4284035 - Replaced pn_index_lease_periods with

40: -- PROCDURE : INSERT_ROW
41: -- INVOKED FROM : insert_row procedure
42: -- PURPOSE : inserts the row
43: -- HISTORY :
44: -- 04-JUL-05 hrodda o Bug 4284035 - Replaced pn_index_lease_periods with
45: -- _ALL table.
46: -- 09-NOV-06 Prabhakar o Added index_multiplier to insert_row.
47: -------------------------------------------------------------------------------
48: PROCEDURE insert_row

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 106: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_PERIODS_PKG.insert_row (+)');

102: l_org_ID NUMBER;
103:
104: BEGIN
105:
106: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_PERIODS_PKG.insert_row (+)');
107: /* If no INDEX_PERIOD_ID is provided, get one from sequence */
108: IF (x_index_period_id IS NULL) THEN
109: SELECT pn_index_lease_periods_s.NEXTVAL
110: INTO x_index_period_id

Line 109: SELECT pn_index_lease_periods_s.NEXTVAL

105:
106: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_PERIODS_PKG.insert_row (+)');
107: /* If no INDEX_PERIOD_ID is provided, get one from sequence */
108: IF (x_index_period_id IS NULL) THEN
109: SELECT pn_index_lease_periods_s.NEXTVAL
110: INTO x_index_period_id
111: FROM DUAL;
112: END IF;
113:

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 228: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_PERIODS_PKG.insert_row (-)');

224: CLOSE c;
225: RAISE NO_DATA_FOUND;
226: END IF;
227: CLOSE c;
228: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_PERIODS_PKG.insert_row (-)');
229: END insert_row;
230:
231:
232: -------------------------------------------------------------------------------

Line 237: -- 04-JUL-05 hrodda o Bug 4284035 - Replaced pn_index_lease_periods with

233: -- PROCDURE : update_row
234: -- INVOKED FROM : update_row procedure
235: -- PURPOSE : updates the row
236: -- HISTORY :
237: -- 04-JUL-05 hrodda o Bug 4284035 - Replaced pn_index_lease_periods with
238: -- _ALL table.Also changed the where clause
239: -- 09-NOV-06 Prabhakar o Added index_multiplier to update_row.
240: -------------------------------------------------------------------------------
241: PROCEDURE update_row (

Line 286: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_PERIODS_PKG.update_row (+)');

282: IS
283: l_return_status VARCHAR2 (30) := NULL;
284: BEGIN
285:
286: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_PERIODS_PKG.update_row (+)');
287: IF (l_return_status IS NOT NULL)
288: THEN
289: app_exception.raise_exception;
290: END IF;

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 339: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_PERIODS_PKG.update_row (-)');

335: THEN
336: RAISE NO_DATA_FOUND;
337: END IF;
338:
339: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_PERIODS_PKG.update_row (-)');
340: END update_row;
341:
342: -------------------------------------------------------------------------------
343: -- PROCDURE : update_row_calc

Line 347: -- 04-JUL-05 hrodda o Bug 4284035 - Replaced pn_index_lease_periods with

343: -- PROCDURE : update_row_calc
344: -- INVOKED FROM : update_row_calc procedure
345: -- PURPOSE :
346: -- HISTORY :
347: -- 04-JUL-05 hrodda o Bug 4284035 - Replaced pn_index_lease_periods with
348: -- _ALL table.Also changed the where clause
349: -- 09-NOV-06 Prabhakar o added index_multiplier.
350: -------------------------------------------------------------------------------
351: PROCEDURE update_row_calc (

Line 401: l_carry_forward_amount pn_index_lease_periods.carry_forward_amount%type := null;

397: l_calc_exists NUMBER := NULL;
398: l_msg VARCHAR2(2000);
399: l_previous_index_amount NUMBER := NULL;
400: l_previous_asmt_date DATE := NULL;
401: l_carry_forward_amount pn_index_lease_periods.carry_forward_amount%type := null;
402: l_constraint_applied_amount pn_index_lease_periods.constraint_applied_amount%type := null;
403: l_constraint_applied_percent pn_index_lease_periods.constraint_applied_percent%type :=null;
404: l_carry_forward_percent pn_index_lease_periods.carry_forward_percent%type;
405:

Line 402: l_constraint_applied_amount pn_index_lease_periods.constraint_applied_amount%type := null;

398: l_msg VARCHAR2(2000);
399: l_previous_index_amount NUMBER := NULL;
400: l_previous_asmt_date DATE := NULL;
401: l_carry_forward_amount pn_index_lease_periods.carry_forward_amount%type := null;
402: l_constraint_applied_amount pn_index_lease_periods.constraint_applied_amount%type := null;
403: l_constraint_applied_percent pn_index_lease_periods.constraint_applied_percent%type :=null;
404: l_carry_forward_percent pn_index_lease_periods.carry_forward_percent%type;
405:
406: BEGIN

Line 403: l_constraint_applied_percent pn_index_lease_periods.constraint_applied_percent%type :=null;

399: l_previous_index_amount NUMBER := NULL;
400: l_previous_asmt_date DATE := NULL;
401: l_carry_forward_amount pn_index_lease_periods.carry_forward_amount%type := null;
402: l_constraint_applied_amount pn_index_lease_periods.constraint_applied_amount%type := null;
403: l_constraint_applied_percent pn_index_lease_periods.constraint_applied_percent%type :=null;
404: l_carry_forward_percent pn_index_lease_periods.carry_forward_percent%type;
405:
406: BEGIN
407:

Line 404: l_carry_forward_percent pn_index_lease_periods.carry_forward_percent%type;

400: l_previous_asmt_date DATE := NULL;
401: l_carry_forward_amount pn_index_lease_periods.carry_forward_amount%type := null;
402: l_constraint_applied_amount pn_index_lease_periods.constraint_applied_amount%type := null;
403: l_constraint_applied_percent pn_index_lease_periods.constraint_applied_percent%type :=null;
404: l_carry_forward_percent pn_index_lease_periods.carry_forward_percent%type;
405:
406: BEGIN
407:
408: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_PERIODS_PKG.update_row_calc (+)');

Line 408: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_PERIODS_PKG.update_row_calc (+)');

404: l_carry_forward_percent pn_index_lease_periods.carry_forward_percent%type;
405:
406: BEGIN
407:
408: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_PERIODS_PKG.update_row_calc (+)');
409: IF (l_return_status IS NOT NULL)
410: THEN
411: app_exception.raise_exception;
412: END IF;

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 553: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_PERIODS_PKG.update_row_calc (-)');

549: END IF;
550:
551: END IF;
552:
553: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_PERIODS_PKG.update_row_calc (-)');
554: END update_row_calc;
555:
556:
557: -------------------------------------------------------------------------------

Line 562: -- 04-JUL-05 hrodda o Bug 4284035 - Replaced pn_index_lease_periods with

558: -- PROCDURE : lock_row
559: -- INVOKED FROM : lock_row procedure
560: -- PURPOSE : locks the row
561: -- HISTORY :
562: -- 04-JUL-05 hrodda o Bug 4284035 - Replaced pn_index_lease_periods with
563: -- _ALL table.Also changed the where clause
564: -- 09-NOV-2006 Prabhakar o Added index_multiplier to lock_row.
565: -------------------------------------------------------------------------------
566: PROCEDURE lock_row (

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 614: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_PERIODS_PKG.lock_row (+)');

610:
611: tlinfo c1%ROWTYPE;
612: BEGIN
613:
614: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_PERIODS_PKG.lock_row (+)');
615: OPEN c1;
616: FETCH c1 INTO tlinfo;
617: IF (c1%NOTFOUND)
618: THEN

Line 720: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_PERIODS_PKG.lock_row (-)');

716: OR ((tlinfo.constraint_applied_percent IS NULL) AND x_constraint_applied_percent IS NULL)) THEN
717: pn_var_rent_pkg.lock_row_exception('CONSTRAINT_RENT_DUE',tlinfo.constraint_applied_percent);
718: END IF;
719:
720: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_PERIODS_PKG.lock_row (-)');
721: END lock_row;
722:
723:
724: -------------------------------------------------------------------------------

Line 729: -- 04-JUL-05 hrodda o Bug 4284035 - Replaced pn_index_lease_periods with

725: -- PROCDURE : delete_row
726: -- INVOKED FROM : delete_row procedure
727: -- PURPOSE : deletes the row
728: -- HISTORY :
729: -- 04-JUL-05 hrodda o Bug 4284035 - Replaced pn_index_lease_periods with
730: -- _ALL table.
731: -------------------------------------------------------------------------------
732: PROCEDURE delete_row (x_rowid IN VARCHAR2)
733: IS

Line 735: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_PERIODS_PKG.delete_row (+)');

731: -------------------------------------------------------------------------------
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)

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 744: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_PERIODS_PKG.delete_row (-)');

740: THEN
741: RAISE NO_DATA_FOUND;
742: END IF;
743:
744: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_PERIODS_PKG.delete_row (-)');
745: END delete_row;
746:
747: -------------------------------------------------------------------------------
748: -- PROCDURE : delete_row

Line 758: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_PERIODS_PKG.delete_row (+)');

754: -------------------------------------------------------------------------------
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)

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

Line 767: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_PERIODS_PKG.delete_row (-)');

763: THEN
764: RAISE NO_DATA_FOUND;
765: END IF;
766:
767: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_PERIODS_PKG.delete_row (-)');
768: END delete_row;
769:
770:
771:

Line 772: END pn_index_lease_periods_pkg;

768: END delete_row;
769:
770:
771:
772: END pn_index_lease_periods_pkg;