PACKAGE: APPS.PSP_ER_APPROVALS_PKG

Source

1 package PSP_ER_APPROVALS_PKG AUTHID CURRENT_USER as
2  /* $Header: PSPERAPS.pls 115.5 2002/11/18 12:24:52 lveerubh ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_EFFORT_REPORT_ID in NUMBER,
6   X_VERSION_NUM in NUMBER,
7   X_APPROVING_PERSON_ID in NUMBER,
8   X_APPROVED_DATE in DATE,
9   X_MODE in VARCHAR2 default 'R'
10   );
11 procedure LOCK_ROW (
12   X_EFFORT_REPORT_ID in NUMBER,
13   X_VERSION_NUM in NUMBER,
14   X_APPROVING_PERSON_ID in NUMBER,
15   X_APPROVED_DATE in DATE
16 );
17 procedure UPDATE_ROW (
18   X_EFFORT_REPORT_ID in NUMBER,
19   X_VERSION_NUM in NUMBER,
20   X_APPROVING_PERSON_ID in NUMBER,
21   X_APPROVED_DATE in DATE,
22   X_MODE in VARCHAR2 default 'R'
23   );
24 procedure ADD_ROW (
25   X_ROWID in out NOCOPY VARCHAR2,
26   X_EFFORT_REPORT_ID in NUMBER,
27   X_VERSION_NUM in NUMBER,
28   X_APPROVING_PERSON_ID in NUMBER,
29   X_APPROVED_DATE in DATE,
30   X_MODE in VARCHAR2 default 'R'
31   );
32 procedure DELETE_ROW (
33   X_EFFORT_REPORT_ID in NUMBER,
34   X_VERSION_NUM in NUMBER,
35   X_APPROVING_PERSON_ID in NUMBER
36 );
37 end PSP_ER_APPROVALS_PKG;