APPS.OKE_WORKFLOWS_PKG dependencies on OKE_WORKFLOWS

Line 1: package body OKE_WORKFLOWS_PKG as

1: package body OKE_WORKFLOWS_PKG as
2: /* $Header: OKEOWXXB.pls 115.0 2003/10/22 22:23:27 ybchen noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2
5: , X_SOURCE_CODE in VARCHAR2

Line 15: cursor C is select ROWID from OKE_WORKFLOWS

11: , X_LAST_UPDATE_LOGIN in NUMBER
12: , X_WF_ITEM_TYPE in VARCHAR2
13: , X_WF_PROCESS in VARCHAR2
14: ) is
15: cursor C is select ROWID from OKE_WORKFLOWS
16: where SOURCE_CODE = X_SOURCE_CODE
17: and USAGE_CODE = X_USAGE_CODE
18: ;
19: begin

Line 20: insert into OKE_WORKFLOWS (

16: where SOURCE_CODE = X_SOURCE_CODE
17: and USAGE_CODE = X_USAGE_CODE
18: ;
19: begin
20: insert into OKE_WORKFLOWS (
21: SOURCE_CODE
22: , USAGE_CODE
23: , CREATION_DATE
24: , CREATED_BY

Line 63: from OKE_WORKFLOWS

59: SOURCE_CODE
60: , USAGE_CODE
61: , WF_ITEM_TYPE
62: , WF_PROCESS
63: from OKE_WORKFLOWS
64: where SOURCE_CODE = X_SOURCE_CODE
65: and USAGE_CODE = X_USAGE_CODE
66: for update nowait;
67: recinfo c%rowtype;

Line 105: update OKE_WORKFLOWS set

101: , X_WF_ITEM_TYPE in VARCHAR2
102: , X_WF_PROCESS in VARCHAR2
103: ) is
104: begin
105: update OKE_WORKFLOWS set
106: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE
107: , LAST_UPDATED_BY = X_LAST_UPDATED_BY
108: , LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
109: , WF_ITEM_TYPE = X_WF_ITEM_TYPE

Line 121: end OKE_WORKFLOWS_PKG;

117: end if;
118:
119: end UPDATE_ROW;
120:
121: end OKE_WORKFLOWS_PKG;