DBA Data[Home] [Help]

APPS.PER_ORG_STRUCTURE_VERSIONS_PKG dependencies on PER_ORG_STRUCTURE_VERSIONS_PKG

Line 1: PACKAGE BODY PER_ORG_STRUCTURE_VERSIONS_PKG as

1: PACKAGE BODY PER_ORG_STRUCTURE_VERSIONS_PKG as
2: /* $Header: peosv01t.pkb 115.6 2002/12/06 16:34:45 pkakar ship $ */
3: -------------------------------------------------------------------------------
4: FUNCTION get_next_free_no(p_Org_Structure_Version_Id NUMBER) return NUMBER is
5: --

Line 265: PER_ORG_STRUCTURE_VERSIONS_PKG.check_version_number(

261: CURSOR C2 IS SELECT per_org_structure_versions_s.nextval
262: FROM sys.dual;
263: --
264: BEGIN
265: PER_ORG_STRUCTURE_VERSIONS_PKG.check_version_number(
266: p_org_structure_id => p_Organization_Structure_Id
267: ,p_version_number => p_version_number
268: ,p_rowid => p_rowid);
269: --

Line 270: PER_ORG_STRUCTURE_VERSIONS_PKG.check_overlap(

266: p_org_structure_id => p_Organization_Structure_Id
267: ,p_version_number => p_version_number
268: ,p_rowid => p_rowid);
269: --
270: PER_ORG_STRUCTURE_VERSIONS_PKG.check_overlap(
271: p_org_structure_id => p_Organization_Structure_Id
272: ,p_rowid => p_rowid
273: ,p_date_from => p_date_from
274: ,p_date_to => p_date_to

Line 278: PER_ORG_STRUCTURE_VERSIONS_PKG.check_date_gaps(

274: ,p_date_to => p_date_to
275: ,p_end_of_time =>p_end_of_time
276: ,p_end_date_closedown => p_closedown_warning);
277: --
278: PER_ORG_STRUCTURE_VERSIONS_PKG.check_date_gaps(
279: p_org_structure_id=> p_Organization_Structure_Id
280: ,p_rowid => p_rowid
281: ,p_date_from => p_date_from
282: ,p_date_to => p_date_to

Line 403: PER_ORG_STRUCTURE_VERSIONS_PKG.check_version_number(

399: p_gap_warning IN OUT NOCOPY VARCHAR2
400: ) IS
401: BEGIN
402: --
403: PER_ORG_STRUCTURE_VERSIONS_PKG.check_version_number(
404: p_org_structure_id => p_Organization_Structure_Id
405: ,p_version_number => p_version_number
406: ,p_rowid => p_rowid);
407: --

Line 408: PER_ORG_STRUCTURE_VERSIONS_PKG.check_overlap(

404: p_org_structure_id => p_Organization_Structure_Id
405: ,p_version_number => p_version_number
406: ,p_rowid => p_rowid);
407: --
408: PER_ORG_STRUCTURE_VERSIONS_PKG.check_overlap(
409: p_org_structure_id => p_Organization_Structure_Id
410: ,p_rowid => p_rowid
411: ,p_date_from => p_date_from
412: ,p_date_to => p_date_to

Line 518: PER_ORG_STRUCTURE_VERSIONS_PKG.check_date_gaps(

514: --
515: update_copied_versions(
516: p_org_Structure_Version_Id =>p_org_Structure_Version_Id);
517: --
518: PER_ORG_STRUCTURE_VERSIONS_PKG.check_date_gaps(
519: p_org_structure_id=> p_Organization_Structure_Id
520: ,p_rowid => p_rowid
521: ,p_date_from => p_date_from
522: ,p_date_to => p_date_to

Line 528: END PER_ORG_STRUCTURE_VERSIONS_PKG;

524: --
525: p_Next_no_free:=get_next_free_no(p_Organization_Structure_Id);
526: END Delete_Row;
527: ------------------------------------------------------------------------------
528: END PER_ORG_STRUCTURE_VERSIONS_PKG;