DBA Data[Home] [Help]

APPS.JTF_BRM_PVT dependencies on JTF_BRM_PARAMETERS

Line 139: -- record in the JTF_BRM_PARAMETERS table to indicate the start of the

135: --
136: -- PROCEDURE start_monitor
137: --
138: -- Set the START command and PROCESS_ID item attributes and update the
139: -- record in the JTF_BRM_PARAMETERS table to indicate the start of the
140: -- Business Rule Monitor. The WORKFLOW_PROCESS_ID is set to be the same
141: -- as the itemkey.
142: --
143: -- IN

Line 177: FROM jtf_brm_parameters

173: l_found BOOLEAN;
174: --
175: CURSOR c_parameters IS
176: SELECT *
177: FROM jtf_brm_parameters
178: WHERE parameter_id = 1;
179: --
180: BEGIN
181: --

Line 216: -- Update columns in the JTF_BRM_PARAMETERS table to indicate

212: itemkey => itemkey,
213: aname => 'PROCESS_ID',
214: avalue => itemkey);
215: --
216: -- Update columns in the JTF_BRM_PARAMETERS table to indicate
217: -- the start of the Business Rule Monitor. But first select the
218: -- record so as not to overwrite good data.
219: --
220: OPEN c_parameters;

Line 788: FROM jtf_brm_parameters

784: l_now DATE := SYSDATE;
785: --
786: CURSOR c_command IS
787: SELECT brm_wf_command_type, brm_wf_command_code
788: FROM jtf_brm_parameters
789: WHERE workflow_process_id = itemkey;
790: --
791: CURSOR c_lookups(b_command_type fnd_lookups.lookup_type%TYPE,
792: b_command_code fnd_lookups.lookup_code%TYPE,