DBA Data[Home] [Help]

PACKAGE: APPS.PSP_SUB_LINE_REASONS_PKG

Source


1 package PSP_SUB_LINE_REASONS_PKG AUTHID CURRENT_USER as
2  /* $Header: PSPPITRS.pls 115.6 2002/11/18 11:02:23 ddubey ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_PAYROLL_SUB_LINE_ID in NUMBER,
6   X_REASON_CODE in VARCHAR2,
7   X_PARENT_LINE_ID in NUMBER,
8   X_MODE in VARCHAR2 default 'R'
9   );
10 procedure LOCK_ROW (
11   X_PAYROLL_SUB_LINE_ID in NUMBER,
12   X_REASON_CODE in VARCHAR2,
13   X_PARENT_LINE_ID in NUMBER
14 );
15 procedure UPDATE_ROW (
16   X_PAYROLL_SUB_LINE_ID in NUMBER,
17   X_REASON_CODE in VARCHAR2,
18   X_PARENT_LINE_ID in NUMBER,
19   X_MODE in VARCHAR2 default 'R'
20   );
21 procedure ADD_ROW (
22   X_ROWID in out NOCOPY VARCHAR2,
23   X_PAYROLL_SUB_LINE_ID in NUMBER,
24   X_REASON_CODE in VARCHAR2,
25   X_PARENT_LINE_ID in NUMBER,
26   X_MODE in VARCHAR2 default 'R'
27   );
28 procedure DELETE_ROW (
29   X_PAYROLL_SUB_LINE_ID in NUMBER,
30   X_REASON_CODE in VARCHAR2
31 );
32 end PSP_SUB_LINE_REASONS_PKG;