PACKAGE: APPS.PSP_REP_ORG_DLS_PKG

Source

1 package PSP_REP_ORG_DLS_PKG AUTHID CURRENT_USER as
2   /* $Header: PSPREDLS.pls 115.6 2002/11/18 11:58:57 lveerubh ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_ORG_DLS_LINE_ID in NUMBER,
6   X_ORG_DLS_BATCH_ID in NUMBER,
7   X_ORGANIZATION_ID in NUMBER,
8   X_ASSIGNMENT_ID in NUMBER,
9   X_PERSON_ID in NUMBER,
10   X_ELEMENT_TYPE_ID in NUMBER,
11   X_SCHEDULE_LINE_ID in NUMBER,
12   X_SCHEDULE_BEGIN_DATE in DATE,
13   X_SCHEDULE_END_DATE in DATE,
14   X_ORIGINAL_SCH_CODE in VARCHAR2,
15   X_MODE in VARCHAR2 default 'R'
16   );
17 procedure LOCK_ROW (
18   X_ORG_DLS_LINE_ID in NUMBER,
19   X_ORG_DLS_BATCH_ID in NUMBER,
20   X_ORGANIZATION_ID in NUMBER,
21   X_ASSIGNMENT_ID in NUMBER,
22   X_PERSON_ID in NUMBER,
23   X_ELEMENT_TYPE_ID in NUMBER,
24   X_SCHEDULE_LINE_ID in NUMBER,
25   X_SCHEDULE_BEGIN_DATE in DATE,
26   X_SCHEDULE_END_DATE in DATE,
27   X_ORIGINAL_SCH_CODE in VARCHAR2
28 );
29 procedure UPDATE_ROW (
30   X_ORG_DLS_LINE_ID in NUMBER,
31   X_ORG_DLS_BATCH_ID in NUMBER,
32   X_ORGANIZATION_ID in NUMBER,
33   X_ASSIGNMENT_ID in NUMBER,
34   X_PERSON_ID in NUMBER,
35   X_ELEMENT_TYPE_ID in NUMBER,
36   X_SCHEDULE_LINE_ID in NUMBER,
37   X_SCHEDULE_BEGIN_DATE in DATE,
38   X_SCHEDULE_END_DATE in DATE,
39   X_ORIGINAL_SCH_CODE in VARCHAR2,
40   X_MODE in VARCHAR2 default 'R'
41   );
42 procedure ADD_ROW (
43   X_ROWID in out NOCOPY VARCHAR2,
44   X_ORG_DLS_LINE_ID in NUMBER,
45   X_ORG_DLS_BATCH_ID in NUMBER,
46   X_ORGANIZATION_ID in NUMBER,
47   X_ASSIGNMENT_ID in NUMBER,
48   X_PERSON_ID in NUMBER,
49   X_ELEMENT_TYPE_ID in NUMBER,
50   X_SCHEDULE_LINE_ID in NUMBER,
51   X_SCHEDULE_BEGIN_DATE in DATE,
52   X_SCHEDULE_END_DATE in DATE,
53   X_ORIGINAL_SCH_CODE in VARCHAR2,
54   X_MODE in VARCHAR2 default 'R'
55   );
56 procedure DELETE_ROW (
57   X_ORG_DLS_LINE_ID in NUMBER
58 );
59 end PSP_REP_ORG_DLS_PKG;