1 PACKAGE IEX_STRATEGY_WORK_ITEMS_PKG AUTHID CURRENT_USER as
2 /* $Header: iextswis.pls 120.4 2010/11/10 09:59:27 pnaveenk 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 ,x_pre_execution_wait IN NUMBER
28 ,x_pre_execution_time_uom IN VARCHAR2
29 ,x_post_execution_wait IN NUMBER
30 ,x_execution_time_uom IN VARCHAR2
31 ,x_xdo_temp_id IN NUMBER
32 ,x_optional_yn IN VARCHAR2
33 ,x_optional_wait_time IN NUMBER
34 ,x_optional_wait_time_uom IN VARCHAR2
35 ,x_notify_yn IN VARCHAR2
36 ,x_escalate_yn IN CHAR
37 ,x_escalate_wait_time NUMBER
38 ,x_escalate_wait_time_uom VARCHAR2
39 ,x_custom_workflow_type VARCHAR2
40 );
41
42
43 PROCEDURE Update_Row(
44
45 x_WORK_ITEM_ID IN NUMBER
46 ,x_STRATEGY_ID IN NUMBER
47 ,x_work_item_template_id IN NUMBER
48 ,x_RESOURCE_ID IN NUMBER
49 ,x_STATUS_CODE IN VARCHAR2
50 ,x_execute_start IN DATE
51 ,x_execute_end IN DATE
52 ,x_LAST_UPDATE_LOGIN IN NUMBER
53 ,x_LAST_UPDATE_DATE DATE
54 ,x_last_updated_by IN NUMBER
55 ,x_OBJECT_VERSION_NUMBER IN NUMBER
56 ,X_REQUEST_ID in NUMBER
57 ,X_PROGRAM_APPLICATION_ID in NUMBER
58 ,X_PROGRAM_ID in NUMBER
59 ,X_PROGRAM_UPDATE_DATE in DATE
60 ,x_schedule_start in DATE
61 ,x_schedule_end in DATE
62 ,x_strategy_temp_id in NUMBER
63 ,x_work_item_order in NUMBER
64 ,x_escalated_yn in CHAR
65 );
66
67 /*PROCEDURE Lock_Row(
68 x_WORK_ITEM_ID IN NUMBER
69 ,x_STRATEGY_ID IN NUMBER
70 ,x_work_item_template_id IN NUMBER
71 ,x_RESOURCE_ID IN NUMBER
72 ,x_STATUS_CODE IN VARCHAR2
73 ,x_execute_start IN DATE
74 ,x_execute_end IN DATE
75 ,x_LAST_UPDATE_LOGIN IN NUMBER
76 ,x_CREATION_DATE IN DATE
77 ,x_CREATED_BY IN NUMBER
78 ,x_LAST_UPDATE_DATE DATE
79 ,x_last_updated_by IN NUMBER
80 ,x_OBJECT_VERSION_NUMBER IN NUMBER
81 ,X_REQUEST_ID in NUMBER
82 ,X_PROGRAM_APPLICATION_ID in NUMBER
83 ,X_PROGRAM_ID in NUMBER
84 ,X_PROGRAM_UPDATE_DATE in DATE
85 ,x_schedule_start in DATE
86 ,x_schedule_end in DATE
87 ,x_strategy_temp_id in NUMBER
88 ,x_work_item_order in NUMBER
89 );
90
91 */
92 procedure LOCK_ROW (
93 x_WORK_ITEM_ID in NUMBER,
94 X_OBJECT_VERSION_NUMBER in NUMBER);
95
96 PROCEDURE Delete_Row(
97 x_WORK_ITEM_ID IN NUMBER);
98
99 End IEX_STRATEGY_WORK_ITEMS_PKG;