PACKAGE: APPS.PSP_EFFORT_REPORTS_PKG

Source

1 package PSP_EFFORT_REPORTS_PKG AUTHID CURRENT_USER as
2  /* $Header: PSPERRES.pls 115.6 2002/11/18 12:44:29 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_PERSON_ID in NUMBER,
8   X_EFFECTIVE_START_DATE in DATE,
9   X_EFFECTIVE_END_DATE in DATE,
10   X_VERSION_CREATION_DATE in DATE,
11   X_VERSION_REASON_CODE in VARCHAR2,
12   X_MESSAGE_ID in NUMBER,
13   X_REPORT_COMMENT in VARCHAR2,
14   X_REPORT_CREATION_DATE in DATE,
15   X_STATUS_CODE in VARCHAR2,
16   X_TEMPLATE_ID in NUMBER,
17   X_PREV_EFFORT_REPORT_ID in NUMBER,
18   X_BUSINESS_GROUP_ID	in  NUMBER,
19   X_SET_OF_BOOKS_ID	in  NUMBER,
20   X_MODE in VARCHAR2 default 'R'
21   );
22 procedure LOCK_ROW (
23   X_EFFORT_REPORT_ID in NUMBER,
24   X_VERSION_NUM in NUMBER,
25   X_PERSON_ID in NUMBER,
26   X_EFFECTIVE_START_DATE in DATE,
27   X_EFFECTIVE_END_DATE in DATE,
28   X_VERSION_CREATION_DATE in DATE,
29   X_VERSION_REASON_CODE in VARCHAR2,
30   X_MESSAGE_ID in NUMBER,
31   X_REPORT_COMMENT in VARCHAR2,
32   X_REPORT_CREATION_DATE in DATE,
33   X_STATUS_CODE in VARCHAR2,
34   X_TEMPLATE_ID in NUMBER,
35   X_BUSINESS_GROUP_ID	in  NUMBER,
36   X_SET_OF_BOOKS_ID	in  NUMBER,
37   X_PREV_EFFORT_REPORT_ID in NUMBER
38 );
39 procedure UPDATE_ROW (
40   X_EFFORT_REPORT_ID in NUMBER,
41   X_VERSION_NUM in NUMBER,
42   X_PERSON_ID in NUMBER,
43   X_EFFECTIVE_START_DATE in DATE,
44   X_EFFECTIVE_END_DATE in DATE,
45   X_VERSION_CREATION_DATE in DATE,
46   X_VERSION_REASON_CODE in VARCHAR2,
47   X_MESSAGE_ID in NUMBER,
48   X_REPORT_COMMENT in VARCHAR2,
49   X_REPORT_CREATION_DATE in DATE,
50   X_STATUS_CODE in VARCHAR2,
51   X_TEMPLATE_ID in NUMBER,
52   X_PREV_EFFORT_REPORT_ID in NUMBER,
53   X_BUSINESS_GROUP_ID	in  NUMBER,
54   X_SET_OF_BOOKS_ID	in  NUMBER,
55   X_MODE in VARCHAR2 default 'R'
56   );
57 procedure ADD_ROW (
58   X_ROWID in out NOCOPY VARCHAR2,
59   X_EFFORT_REPORT_ID in NUMBER,
60   X_VERSION_NUM in NUMBER,
61   X_PERSON_ID in NUMBER,
62   X_EFFECTIVE_START_DATE in DATE,
63   X_EFFECTIVE_END_DATE in DATE,
64   X_VERSION_CREATION_DATE in DATE,
65   X_VERSION_REASON_CODE in VARCHAR2,
66   X_MESSAGE_ID in NUMBER,
67   X_REPORT_COMMENT in VARCHAR2,
68   X_REPORT_CREATION_DATE in DATE,
69   X_STATUS_CODE in VARCHAR2,
70   X_TEMPLATE_ID in NUMBER,
71   X_PREV_EFFORT_REPORT_ID in NUMBER,
72   X_BUSINESS_GROUP_ID	in  NUMBER,
73   X_SET_OF_BOOKS_ID	in  NUMBER,
74   X_MODE in VARCHAR2 default 'R'
75   );
76 procedure DELETE_ROW (
77   X_EFFORT_REPORT_ID in NUMBER,
78   X_VERSION_NUM in NUMBER
79 );
80 end PSP_EFFORT_REPORTS_PKG;