APPS.WF_SYSTEMS_PKG dependencies on WF_SYSTEMS

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 4: m_table_name varchar2(255) := 'WF_SYSTEMS';

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';
6:
7: -----------------------------------------------------------------------------
8: procedure INSERT_ROW (

Line 17: from wf_systems

13: X_DISPLAY_NAME in varchar2,
14: X_DESCRIPTION in varchar2
15: ) is
16: cursor C is select rowid
17: from wf_systems
18: where guid = X_GUID;
19: begin
20: insert into wf_systems (
21: guid,

Line 20: insert into wf_systems (

16: cursor C is select rowid
17: from wf_systems
18: where guid = X_GUID;
19: begin
20: insert into wf_systems (
21: guid,
22: name,
23: master_guid,
24: display_name,

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 58: update wf_systems

54: X_DISPLAY_NAME in varchar2,
55: X_DESCRIPTION in varchar2
56: ) is
57: begin
58: update wf_systems
59: set name = X_NAME,
60: master_guid = X_MASTER_GUID,
61: display_name = X_DISPLAY_NAME,
62: description = X_DESCRIPTION

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 82: delete from wf_systems

78: ) is
79: begin
80: wf_event.raise('oracle.apps.wf.event.system.delete',x_guid);
81:
82: delete from wf_systems
83: where guid = X_GUID;
84:
85: if (sql%notfound) then
86: raise no_data_found;

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 150: from wf_systems

146:
147: begin
148: select name, master_guid, display_name, description
149: into l_name, l_master_guid, l_display_name, l_description
150: from wf_systems
151: where guid = x_guid;
152:
153: l_doc := xmldom.newDOMDocument;
154: l_root := xmldom.makeNode(l_doc);

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;