APPS.AHL_WF_MAPPING_PKG dependencies on AHL_WF_MAPPING

Line 1: PACKAGE BODY AHL_WF_MAPPING_PKG as

1: PACKAGE BODY AHL_WF_MAPPING_PKG as
2: /*$Header: AHLLWFMB.pls 115.6 2003/12/10 13:39:06 rroy noship $*/
3: procedure INSERT_ROW
4: (
5: X_ROWID IN out NOCOPY VARCHAR2,

Line 20: cursor C is select ROWID from AHL_WF_MAPPING where

16: X_ITEM_TYPE IN VARCHAR2,
17: X_APPLICATION_USG_CODE IN VARCHAR2
18: )
19: is
20: cursor C is select ROWID from AHL_WF_MAPPING where
21: WF_MAPPING_ID = X_WF_MAPPING_ID ;
22: begin
23: insert into AHL_WF_MAPPING
24: (

Line 23: insert into AHL_WF_MAPPING

19: is
20: cursor C is select ROWID from AHL_WF_MAPPING where
21: WF_MAPPING_ID = X_WF_MAPPING_ID ;
22: begin
23: insert into AHL_WF_MAPPING
24: (
25: WF_MAPPING_ID ,
26: OBJECT_VERSION_NUMBER ,
27: LAST_UPDATE_DATE ,

Line 78: update AHL_WF_MAPPING set

74: X_ITEM_TYPE IN VARCHAR2,
75: X_APPLICATION_USG_CODE IN VARCHAR2
76: ) is
77: begin
78: update AHL_WF_MAPPING set
79: WF_MAPPING_ID = X_WF_MAPPING_ID,
80: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
81: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
82: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 118: from AHL_WF_MAPPING

114:
115:
116: cursor c_obj_verno is
117: select object_version_number
118: from AHL_WF_MAPPING
119: where WF_MAPPING_ID = X_WF_MAPPING_ID;
120:
121: cursor c_chk_wfm_exists is
122: select 'x'

Line 123: from AHL_WF_MAPPING

119: where WF_MAPPING_ID = X_WF_MAPPING_ID;
120:
121: cursor c_chk_wfm_exists is
122: select 'x'
123: from AHL_WF_MAPPING
124: where WF_MAPPING_ID = X_WF_MAPPING_ID;
125:
126: cursor c_get_wfm_id is
127: select Ahl_Wf_Mapping_S.NEXTVAL

Line 127: select Ahl_Wf_Mapping_S.NEXTVAL

123: from AHL_WF_MAPPING
124: where WF_MAPPING_ID = X_WF_MAPPING_ID;
125:
126: cursor c_get_wfm_id is
127: select Ahl_Wf_Mapping_S.NEXTVAL
128: from dual;
129: begin
130: if X_OWNER = 'SEED' then
131: l_user_id := 1;

Line 150: AHL_WF_MAPPING_PKG.INSERT_ROW

146: end if ;
147:
148: l_obj_verno := 1;
149:
150: AHL_WF_MAPPING_PKG.INSERT_ROW
151: (
152: X_ROWID => l_row_id,
153: X_WF_MAPPING_ID => l_wfm_id,
154: X_OBJECT_VERSION_NUMBER => l_obj_verno,

Line 173: AHL_WF_MAPPING_PKG.UPDATE_ROW

169: open c_obj_verno;
170: fetch c_obj_verno into l_obj_verno;
171: close c_obj_verno;
172:
173: AHL_WF_MAPPING_PKG.UPDATE_ROW
174: (
175: X_WF_MAPPING_ID => X_WF_MAPPING_ID,
176: X_OBJECT_VERSION_NUMBER => l_obj_verno + 1,
177: X_LAST_UPDATE_DATE => SYSDATE,

Line 195: delete from AHL_WF_MAPPING

191: X_WF_MAPPING_ID in NUMBER
192: )
193: is
194: begin
195: delete from AHL_WF_MAPPING
196: where WF_MAPPING_ID = X_WF_MAPPING_ID;
197:
198: if (sql%notfound) then
199: raise no_data_found;

Line 203: end AHL_WF_MAPPING_PKG;

199: raise no_data_found;
200: end if;
201: end DELETE_ROW;
202:
203: end AHL_WF_MAPPING_PKG;