DBA Data[Home] [Help]

APPS.AMS_APPROVAL_DETAILS_PKG dependencies on AMS_APPROVAL_DETAILS_PKG

Line 1: package body AMS_APPROVAL_DETAILS_PKG as

1: package body AMS_APPROVAL_DETAILS_PKG as
2: /* $Header: amslapdb.pls 120.1 2005/06/27 05:37:47 appldev ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in OUT NOCOPY VARCHAR2,
5: X_APPROVAL_DETAIL_ID in NUMBER,

Line 483: AMS_APPROVAL_DETAILS_PKG.INSERT_ROW(

479: else
480: l_approval_detail_id := X_APPROVAL_DETAIL_ID;
481: end if;
482: l_obj_verno := 1;
483: AMS_APPROVAL_DETAILS_PKG.INSERT_ROW(
484: X_ROWID => l_row_id,
485: X_APPROVAL_DETAIL_ID => l_approval_detail_id,
486: X_START_DATE_ACTIVE => X_START_DATE_ACTIVE,
487: X_END_DATE_ACTIVE => X_END_DATE_ACTIVE,

Line 518: AMS_APPROVAL_DETAILS_PKG.UPDATE_ROW(

514: fetch c_obj_verno into l_obj_verno;
515: close c_obj_verno;
516: -- assigning value for l_user_status_id
517: l_approval_detail_id := X_APPROVAL_DETAIL_ID;
518: AMS_APPROVAL_DETAILS_PKG.UPDATE_ROW(
519: X_APPROVAL_DETAIL_ID => l_approval_detail_id,
520: X_START_DATE_ACTIVE => X_START_DATE_ACTIVE,
521: X_END_DATE_ACTIVE => X_END_DATE_ACTIVE,
522: X_OBJECT_VERSION_NUMBER => l_obj_verno+1,

Line 547: end AMS_APPROVAL_DETAILS_PKG;

543: );
544: END iF;
545: END;
546:
547: end AMS_APPROVAL_DETAILS_PKG;