1 PACKAGE IEX_STRATEGY_WORK_ITEMS_PKG as
2 /* $Header: iextswis.pls 120.0.12010000.2 2008/08/06 09:03:52 schekuri ship $ */
3 PROCEDURE Insert_Row(
4 X_ROWID IN OUT NOCOPY VARCHAR2
5 ,x_WORK_ITEM_ID IN NUMBER
6 ,x_STRATEGY_ID IN NUMBER
7 ,x_work_item_template_id IN NUMBER
8 ,x_RESOURCE_ID IN NUMBER
9 ,x_STATUS_CODE IN VARCHAR2
10 ,x_execute_start IN DATE
11 ,x_execute_end IN DATE
12 ,x_LAST_UPDATE_LOGIN IN NUMBER
13 ,x_CREATION_DATE IN DATE
14 ,x_CREATED_BY IN NUMBER
15 ,x_LAST_UPDATE_DATE DATE
16 ,x_last_updated_by IN NUMBER
17 ,x_OBJECT_VERSION_NUMBER IN NUMBER
18 ,X_REQUEST_ID in NUMBER
19 ,X_PROGRAM_APPLICATION_ID in NUMBER
20 ,X_PROGRAM_ID in NUMBER
21 ,X_PROGRAM_UPDATE_DATE in DATE
22 ,x_schedule_start in DATE
23 ,x_schedule_end in DATE
24 ,x_strategy_temp_id in NUMBER
25 ,x_work_item_order in NUMBER
26 ,x_escalated_yn in CHAR
27 );
28
29
30 PROCEDURE Update_Row(
31
32 x_WORK_ITEM_ID IN NUMBER
33 ,x_STRATEGY_ID IN NUMBER
34 ,x_work_item_template_id IN NUMBER
35 ,x_RESOURCE_ID IN NUMBER
36 ,x_STATUS_CODE IN VARCHAR2
37 ,x_execute_start IN DATE
38 ,x_execute_end IN DATE
39 ,x_LAST_UPDATE_LOGIN IN NUMBER
40 ,x_LAST_UPDATE_DATE DATE
41 ,x_last_updated_by IN NUMBER
42 ,x_OBJECT_VERSION_NUMBER IN NUMBER
43 ,X_REQUEST_ID in NUMBER
44 ,X_PROGRAM_APPLICATION_ID in NUMBER
45 ,X_PROGRAM_ID in NUMBER
46 ,X_PROGRAM_UPDATE_DATE in DATE
47 ,x_schedule_start in DATE
48 ,x_schedule_end in DATE
49 ,x_strategy_temp_id in NUMBER
50 ,x_work_item_order in NUMBER
51 ,x_escalated_yn in CHAR
52 );
53
54 /*PROCEDURE Lock_Row(
55 x_WORK_ITEM_ID IN NUMBER
56 ,x_STRATEGY_ID IN NUMBER
57 ,x_work_item_template_id IN NUMBER
58 ,x_RESOURCE_ID IN NUMBER
59 ,x_STATUS_CODE IN VARCHAR2
60 ,x_execute_start IN DATE
61 ,x_execute_end IN DATE
62 ,x_LAST_UPDATE_LOGIN IN NUMBER
63 ,x_CREATION_DATE IN DATE
64 ,x_CREATED_BY IN NUMBER
65 ,x_LAST_UPDATE_DATE DATE
66 ,x_last_updated_by IN NUMBER
67 ,x_OBJECT_VERSION_NUMBER IN NUMBER
68 ,X_REQUEST_ID in NUMBER
69 ,X_PROGRAM_APPLICATION_ID in NUMBER
70 ,X_PROGRAM_ID in NUMBER
71 ,X_PROGRAM_UPDATE_DATE in DATE
72 ,x_schedule_start in DATE
73 ,x_schedule_end in DATE
74 ,x_strategy_temp_id in NUMBER
75 ,x_work_item_order in NUMBER
76 );
77
78 */
79 procedure LOCK_ROW (
80 x_WORK_ITEM_ID in NUMBER,
81 X_OBJECT_VERSION_NUMBER in NUMBER);
82
83 PROCEDURE Delete_Row(
84 x_WORK_ITEM_ID IN NUMBER);
85
86 End IEX_STRATEGY_WORK_ITEMS_PKG;