APPS.JTF_DPF_LOGICAL_FLOWS_PKG dependencies on JTF_DPF_LOGICAL_FLOWS_B

Line 6: select logical_flow_id from jtf_dpf_logical_flows_b

2: /* $Header: jtfdpffb.pls 120.2 2005/10/25 05:16:26 psanyal ship $ */
3: cursor find_match_with_owner(x_logical_flow_name varchar2,
4: x_application_id varchar2,
5: x_last_updated_by number) is
6: select logical_flow_id from jtf_dpf_logical_flows_b
7: where logical_flow_name=x_logical_flow_name and
8: application_id=x_application_id and
9: last_updated_by = x_last_updated_by
10: order by last_update_date;

Line 15: select logical_flow_id from jtf_dpf_logical_flows_b

11:
12: -- same query, without the last_updated_by test
13: cursor find_match(x_logical_flow_name varchar2,
14: x_application_id varchar2) is
15: select logical_flow_id from jtf_dpf_logical_flows_b
16: where logical_flow_name=x_logical_flow_name and
17: application_id=x_application_id
18: order by last_update_date;
19:

Line 41: cursor C is select ROWID from JTF_DPF_LOGICAL_FLOWS_B

37: X_LAST_UPDATED_BY in NUMBER,
38: X_LAST_UPDATE_LOGIN in NUMBER) is
39: l_flowid number;
40: l_enabled varchar2(1);
41: cursor C is select ROWID from JTF_DPF_LOGICAL_FLOWS_B
42: where LOGICAL_FLOW_ID = X_LOGICAL_FLOW_ID;
43: cursor any_others_with_same_name is
44: select logical_flow_id
45: from jtf_dpf_logical_flows_b

Line 45: from jtf_dpf_logical_flows_b

41: cursor C is select ROWID from JTF_DPF_LOGICAL_FLOWS_B
42: where LOGICAL_FLOW_ID = X_LOGICAL_FLOW_ID;
43: cursor any_others_with_same_name is
44: select logical_flow_id
45: from jtf_dpf_logical_flows_b
46: where logical_flow_name = x_logical_flow_name and
47: application_id = x_application_id;
48: begin
49: -- if there are any other flows of the same appid and name, then set

Line 61: insert into JTF_DPF_LOGICAL_FLOWS_B (

57: else
58: l_enabled := 'F';
59: end if;
60:
61: insert into JTF_DPF_LOGICAL_FLOWS_B (
62: LOGICAL_FLOW_ID,
63: LOGICAL_FLOW_HEAD_ID,
64: LOGICAL_FLOW_NAME,
65: SECURE_FLOW_FLAG,

Line 158: from JTF_DPF_LOGICAL_FLOWS_B

154: RETURN_TO_PAGE_ID,
155: BASE_FLOW_FLAG,
156: ENABLED_CLONE_FLAG,
157: OBJECT_VERSION_NUMBER
158: from JTF_DPF_LOGICAL_FLOWS_B
159: where LOGICAL_FLOW_ID = X_LOGICAL_FLOW_ID
160: for update of LOGICAL_FLOW_ID nowait;
161: recinfo c%rowtype;
162:

Line 231: update JTF_DPF_LOGICAL_FLOWS_B set

227: X_LAST_UPDATED_BY in NUMBER,
228: X_LAST_UPDATE_LOGIN in NUMBER
229: ) is
230: begin
231: update JTF_DPF_LOGICAL_FLOWS_B set
232: LOGICAL_FLOW_HEAD_ID = X_LOGICAL_FLOW_HEAD_ID,
233: LOGICAL_FLOW_NAME = X_LOGICAL_FLOW_NAME,
234: SECURE_FLOW_FLAG = X_SECURE_FLOW_FLAG,
235: VALIDATE_FLAG = X_VALIDATE_FLAG,

Line 276: delete from JTF_DPF_LOGICAL_FLOWS_B

272: if (sql%notfound) then
273: raise no_data_found;
274: end if;
275:
276: delete from JTF_DPF_LOGICAL_FLOWS_B
277: where LOGICAL_FLOW_ID = X_LOGICAL_FLOW_ID;
278:
279: if (sql%notfound) then
280: raise no_data_found;

Line 290: from JTF_DPF_LOGICAL_FLOWS_B B

286: begin
287: delete from JTF_DPF_LOGICAL_FLOWS_TL T
288: where not exists
289: (select NULL
290: from JTF_DPF_LOGICAL_FLOWS_B B
291: where B.LOGICAL_FLOW_ID = T.LOGICAL_FLOW_ID
292: );
293:
294: update JTF_DPF_LOGICAL_FLOWS_TL T set (

Line 484: -- jtf_dpf_logical_flows_b where logical_flow_id<10000;

480: l_new_flow_id := null;
481: -- arsingh: prevent use of same id by different threads.
482: select JTF_DPF_LOGICAL_FLOWS_S.nextval into l_new_flow_id from dual;
483: -- select max(logical_flow_id) into l_new_flow_id from
484: -- jtf_dpf_logical_flows_b where logical_flow_id<10000;
485: -- if l_new_flow_id is null then
486: -- l_new_flow_id := 1;
487: -- else
488: -- l_new_flow_id := l_new_flow_id+1;

Line 514: select count(*) into l_counter from jtf_dpf_logical_flows_b

510: X_LAST_UPDATE_LOGIN => 0);
511:
512: -- if there's exactly one row with a flow wit this appid/flowname,
513: -- then make sure that row has enabled_clone_flag = 'T'
514: select count(*) into l_counter from jtf_dpf_logical_flows_b
515: where application_id = x_application_id and
516: logical_flow_name = x_logical_flow_name;
517: if l_counter = 1 then
518: update jtf_dpf_logical_flows_b set

Line 518: update jtf_dpf_logical_flows_b set

514: select count(*) into l_counter from jtf_dpf_logical_flows_b
515: where application_id = x_application_id and
516: logical_flow_name = x_logical_flow_name;
517: if l_counter = 1 then
518: update jtf_dpf_logical_flows_b set
519: enabled_clone_flag = 'T'
520: where application_id = x_application_id and
521: logical_flow_name = x_logical_flow_name;
522: end if;

Line 597: from jtf_dpf_logical_flows_b where logical_flow_id = l_flow_id;

593: -- the flow in question is not owned by us, then just return
594: -- without doing anything
595: if x_force_update_flag is null and x_force_update_flag <> 'TRUE' then
596: select last_updated_by into l_last_updated_by
597: from jtf_dpf_logical_flows_b where logical_flow_id = l_flow_id;
598: if l_last_updated_by <> l_user_id then return; end if;
599: end if;
600:
601: -- try to find a row which matches this one (to see whether we should