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.PER_POS_STRUCTURE_VERSIONS_PKG dependencies on PER_POS_STRUCTURE_VERSIONS_PKG

Line 1: PACKAGE BODY PER_POS_STRUCTURE_VERSIONS_PKG as

1: PACKAGE BODY PER_POS_STRUCTURE_VERSIONS_PKG as
2: /* $Header: pepsv01t.pkb 120.1 2006/06/29 12:06:48 hmehta ship $ */
3: -----------------------------------------------------------------------------
4: FUNCTION get_next_free_no(X_Position_Structure_Id NUMBER) return NUMBER IS
5: --

Line 309: PER_POS_STRUCTURE_VERSIONS_PKG.check_version_number(

305: WHERE pos_structure_version_id = X_Pos_Structure_Version_Id;
306: CURSOR C2 IS SELECT per_pos_structure_versions_s.nextval FROM sys.dual;
307: BEGIN
308: --
309: PER_POS_STRUCTURE_VERSIONS_PKG.check_version_number(
310: X_Position_Structure_Id=> X_Position_Structure_Id
311: ,X_Version_Number => X_Version_Number
312: ,X_Rowid => X_Rowid);
313: --

Line 314: PER_POS_STRUCTURE_VERSIONS_PKG.check_overlap(

310: X_Position_Structure_Id=> X_Position_Structure_Id
311: ,X_Version_Number => X_Version_Number
312: ,X_Rowid => X_Rowid);
313: --
314: PER_POS_STRUCTURE_VERSIONS_PKG.check_overlap(
315: X_Position_Structure_Id=> X_Position_Structure_Id
316: ,X_Rowid => X_Rowid
317: ,X_Date_From => X_Date_From
318: ,X_Date_To => X_Date_To

Line 322: PER_POS_STRUCTURE_VERSIONS_PKG.check_date_gap(X_Date_From => X_Date_From

318: ,X_Date_To => X_Date_To
319: ,X_End_Of_Time => X_End_Of_Time
320: ,X_End_Date_Closedown => X_closedown_warning);
321: --
322: PER_POS_STRUCTURE_VERSIONS_PKG.check_date_gap(X_Date_From => X_Date_From
323: ,X_Date_To => X_Date_To
324: ,X_gap_warning => X_gap_warning
325: ,X_Position_Structure_Id =>X_Position_Structure_Id
326: ,X_Rowid => X_Rowid);

Line 358: PER_POS_STRUCTURE_VERSIONS_PKG.copy_elements(

354: RAISE NO_DATA_FOUND;
355: end if;
356: CLOSE C;
357: if X_Copy_Structure_Version_Id is not null then
358: PER_POS_STRUCTURE_VERSIONS_PKG.copy_elements(
359: X_Copy_Structure_Version_Id => X_Copy_Structure_Version_Id
360: ,X_Pos_Structure_Version_Id => X_Pos_Structure_Version_Id);
361: end if;
362: X_Next_no_free :=PER_POS_STRUCTURE_VERSIONS_PKG.get_next_free_no(

Line 362: X_Next_no_free :=PER_POS_STRUCTURE_VERSIONS_PKG.get_next_free_no(

358: PER_POS_STRUCTURE_VERSIONS_PKG.copy_elements(
359: X_Copy_Structure_Version_Id => X_Copy_Structure_Version_Id
360: ,X_Pos_Structure_Version_Id => X_Pos_Structure_Version_Id);
361: end if;
362: X_Next_no_free :=PER_POS_STRUCTURE_VERSIONS_PKG.get_next_free_no(
363: X_Position_Structure_Id =>X_Position_Structure_Id);
364: end Insert_Row;
365: -----------------------------------------------------------------------------
366: PROCEDURE Lock_Row(X_Rowid VARCHAR2,

Line 433: PER_POS_STRUCTURE_VERSIONS_PKG.check_version_number(

429: X_closedown_warning IN OUT NOCOPY VARCHAR2,
430: X_gap_warning IN OUT NOCOPY VARCHAR2
431: ) IS
432: BEGIN
433: PER_POS_STRUCTURE_VERSIONS_PKG.check_version_number(
434: X_Position_Structure_Id=> X_Position_Structure_Id
435: ,X_Version_Number => X_Version_Number
436: ,X_Rowid => X_Rowid);
437: --

Line 438: PER_POS_STRUCTURE_VERSIONS_PKG.check_overlap(

434: X_Position_Structure_Id=> X_Position_Structure_Id
435: ,X_Version_Number => X_Version_Number
436: ,X_Rowid => X_Rowid);
437: --
438: PER_POS_STRUCTURE_VERSIONS_PKG.check_overlap(
439: X_Position_Structure_Id=> X_Position_Structure_Id
440: ,X_Rowid => X_Rowid
441: ,X_Date_From => X_Date_From
442: ,X_Date_To => X_Date_To

Line 446: PER_POS_STRUCTURE_VERSIONS_PKG.check_date_gap(X_Date_From => X_Date_From

442: ,X_Date_To => X_Date_To
443: ,X_End_Of_Time => X_End_Of_Time
444: ,X_End_Date_Closedown => X_closedown_warning);
445: --
446: PER_POS_STRUCTURE_VERSIONS_PKG.check_date_gap(X_Date_From => X_Date_From
447: ,X_Date_To => X_Date_To
448: ,X_gap_warning => X_gap_warning
449: ,X_Position_Structure_Id =>X_Position_Structure_Id
450: ,X_Rowid => X_Rowid);

Line 465: X_Next_no_free :=PER_POS_STRUCTURE_VERSIONS_PKG.get_next_free_no(

461: WHERE rowid = X_rowid;
462: if (SQL%NOTFOUND) then
463: RAISE NO_DATA_FOUND;
464: end if;
465: X_Next_no_free :=PER_POS_STRUCTURE_VERSIONS_PKG.get_next_free_no(
466: X_Position_Structure_Id =>X_Position_Structure_Id);
467: END Update_Row;
468: -----------------------------------------------------------------------------
469: PROCEDURE Delete_Row(X_Rowid VARCHAR2,

Line 487: X_Next_no_free :=PER_POS_STRUCTURE_VERSIONS_PKG.get_next_free_no(

483: WHERE rowid = X_Rowid;
484: if (SQL%NOTFOUND) then
485: RAISE NO_DATA_FOUND;
486: end if;
487: X_Next_no_free :=PER_POS_STRUCTURE_VERSIONS_PKG.get_next_free_no(
488: X_Position_Structure_Id =>X_Position_Structure_Id);
489: END Delete_Row;
490: -----------------------------------------------------------------------------
491: END PER_POS_STRUCTURE_VERSIONS_PKG;

Line 491: END PER_POS_STRUCTURE_VERSIONS_PKG;

487: X_Next_no_free :=PER_POS_STRUCTURE_VERSIONS_PKG.get_next_free_no(
488: X_Position_Structure_Id =>X_Position_Structure_Id);
489: END Delete_Row;
490: -----------------------------------------------------------------------------
491: END PER_POS_STRUCTURE_VERSIONS_PKG;