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,
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,
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,
543: );
544: END iF;
545: END;
546:
547: end AMS_APPROVAL_DETAILS_PKG;