DBA Data[Home] [Help]

APPS.WF_SYSTEMS_PKG dependencies on WF_SYSTEMS_PKG

Line 1: package body WF_SYSTEMS_PKG as

1: package body WF_SYSTEMS_PKG as
2: /* $Header: WFEVSYSB.pls 120.3 2005/09/02 16:07:55 vshanmug ship $ */
3:
4: m_table_name varchar2(255) := 'WF_SYSTEMS';
5: m_package_version varchar2(30) := '1.0';

Line 45: wf_core.context('Wf_Systems_Pkg', 'Insert_row', x_guid, x_name);

41: end if;
42: close c;
43: exception
44: when others then
45: wf_core.context('Wf_Systems_Pkg', 'Insert_row', x_guid, x_name);
46: raise;
47:
48: end INSERT_ROW;
49: -----------------------------------------------------------------------------

Line 72: wf_core.context('Wf_Systems_Pkg', 'Update_row', x_guid, x_name);

68: wf_event.raise('oracle.apps.wf.event.system.update',x_guid);
69: end if;
70: exception
71: when others then
72: wf_core.context('Wf_Systems_Pkg', 'Update_row', x_guid, x_name);
73: raise;
74: end UPDATE_ROW;
75: -----------------------------------------------------------------------------
76: procedure DELETE_ROW (

Line 93: wf_core.context('Wf_Systems_Pkg', 'Delete_row', x_guid);

89: -- Invalidate cache
90: wf_bes_cache.SetMetaDataUploaded();
91: exception
92: when others then
93: wf_core.context('Wf_Systems_Pkg', 'Delete_row', x_guid);
94: raise;
95: end DELETE_ROW;
96: -----------------------------------------------------------------------------
97: procedure LOAD_ROW (

Line 107: WF_SYSTEMS_PKG.UPDATE_ROW (

103: ) is
104: row_id varchar2(64);
105: begin
106: begin
107: WF_SYSTEMS_PKG.UPDATE_ROW (
108: X_GUID => X_GUID,
109: X_NAME => X_NAME,
110: X_MASTER_GUID => X_MASTER_GUID,
111: X_DISPLAY_NAME => X_DISPLAY_NAME,

Line 118: WF_SYSTEMS_PKG.INSERT_ROW(

114: -- Invalidate cache
115: wf_bes_cache.SetMetaDataUploaded();
116: exception
117: when no_data_found then
118: WF_SYSTEMS_PKG.INSERT_ROW(
119: X_ROWID => row_id,
120: X_GUID => X_GUID,
121: X_NAME => X_NAME,
122: X_MASTER_GUID => X_MASTER_GUID,

Line 129: wf_core.context('Wf_Systems_Pkg', 'Load_row', x_guid, x_name);

125: end;
126:
127: exception
128: when others then
129: wf_core.context('Wf_Systems_Pkg', 'Load_row', x_guid, x_name);
130: raise;
131: end LOAD_ROW;
132: -----------------------------------------------------------------------------
133: function GENERATE (

Line 173: wf_core.context('Wf_Systems_Pkg', 'Generate', x_guid);

169:
170: return buf;
171: exception
172: when others then
173: wf_core.context('Wf_Systems_Pkg', 'Generate', x_guid);
174: raise;
175: end GENERATE;
176: -----------------------------------------------------------------------------
177: procedure RECEIVE (

Line 237: wf_core.context('Wf_Systems_Pkg', 'Receive', x_message);

233:
234: load_row(l_guid, l_name, l_master_guid, l_display_name, l_description);
235: exception
236: when others then
237: wf_core.context('Wf_Systems_Pkg', 'Receive', x_message);
238: raise;
239: end RECEIVE;
240: -----------------------------------------------------------------------------
241: end WF_SYSTEMS_PKG;

Line 241: end WF_SYSTEMS_PKG;

237: wf_core.context('Wf_Systems_Pkg', 'Receive', x_message);
238: raise;
239: end RECEIVE;
240: -----------------------------------------------------------------------------
241: end WF_SYSTEMS_PKG;