DBA Data[Home] [Help]

APPS.PER_POS_STRUCTURE_ELEMENTS_PKG dependencies on PER_POS_STRUCTURE_ELEMENTS_PKG

Line 1: PACKAGE BODY PER_POS_STRUCTURE_ELEMENTS_PKG as

1: PACKAGE BODY PER_POS_STRUCTURE_ELEMENTS_PKG as
2: /* $Header: pepse01t.pkb 120.0 2005/05/31 15:14:31 appldev noship $ */
3: ------------------------------------------------------------------------------
4: FUNCTION get_subordinates(X_View_All_Positions VARCHAR2
5: ,X_Parent_Position_Id NUMBER

Line 390: /* PER_POS_STRUCTURE_ELEMENTS_PKG.check_unique(

386: and Pos_Structure_Version_Id = X_Pos_Structure_Version_Id;
387: Recinfo get_details%ROWTYPE;
388: --
389: BEGIN
390: /* PER_POS_STRUCTURE_ELEMENTS_PKG.check_unique(
391: X_Parent_position_id => X_Parent_position_id
392: ,X_Pos_Structure_Version_Id => X_Pos_Structure_Version_Id
393: ,X_Subordinate_Position_Id => X_Subordinate_Position_Id);
394: */

Line 411: PER_POS_STRUCTURE_ELEMENTS_PKG.lock_row(

407: --
408: -- Lock the row
409: --
410:
411: PER_POS_STRUCTURE_ELEMENTS_PKG.lock_row(
412: X_Rowid => Recinfo.ROWID,
413: X_Pos_Structure_Element_Id => Recinfo.POS_STRUCTURE_ELEMENT_ID,
414: X_Business_Group_Id => Recinfo.BUSINESS_GROUP_ID,
415: X_Pos_Structure_Version_Id => Recinfo.POS_STRUCTURE_VERSION_ID,

Line 421: PER_POS_STRUCTURE_ELEMENTS_PKG.update_row(

417: X_Parent_Position_Id => Recinfo.PARENT_POSITION_ID);
418: --
419: -- Update the row
420: --
421: PER_POS_STRUCTURE_ELEMENTS_PKG.update_row(
422: X_Rowid => Recinfo.ROWID,
423: X_Pos_Structure_Element_Id => Recinfo.POS_STRUCTURE_ELEMENT_ID,
424: X_Business_Group_Id => Recinfo.BUSINESS_GROUP_ID,
425: X_Pos_Structure_Version_Id => Recinfo.POS_STRUCTURE_VERSION_ID,

Line 540: PER_POS_STRUCTURE_ELEMENTS_PKG.pre_delete_checks(

536: BEGIN
537: --
538: -- Do the Pre-delete checks
539: --
540: PER_POS_STRUCTURE_ELEMENTS_PKG.pre_delete_checks(
541: X_Subordinate_position_Id => X_Subordinate_position_Id
542: ,X_Position_Structure_Id => X_Position_Structure_Id
543: ,X_Business_Group_Id => X_Business_Group_Id
544: ,X_Hr_Installed => X_Hr_Installed

Line 554: END PER_POS_STRUCTURE_ELEMENTS_PKG;

550: RAISE NO_DATA_FOUND;
551: end if;
552: END Delete_Row;
553:
554: END PER_POS_STRUCTURE_ELEMENTS_PKG;