[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;