APPS.JTF_DPF dependencies on JTF_DPF_LOGICAL_FLOWS_B

Line 24: from jtf_dpf_logical_flows_b lf

20: lf.validate_flag,
21: lf.secure_flow_flag,
22: lf.enabled_clone_flag,
23: lf.last_updated_by -- was: base_flow_flag
24: from jtf_dpf_logical_flows_b lf
25: where lf.application_id =
26: (select application_id from fnd_application fa2
27: where fa2.application_short_name = pp_asn);
28: begin

Line 279: from jtf_dpf_logical_flows_b lf

275: procedure get_next_logical_default_tbl(asn varchar2,
276: retval out NOCOPY next_logical_default_tbl) is
277: cursor q1 (pp_asn varchar2) is
278: select logical_flow_name, logical_flow_id
279: from jtf_dpf_logical_flows_b lf
280: where lf.application_id =
281: (select application_id from fnd_application fa
282: where fa.application_short_name = pp_asn);
283:

Line 340: from jtf_dpf_logical_flows_b lf

336: procedure get_next_logical_non_def_tbl(asn varchar2,
337: retval out NOCOPY next_logical_non_default_tbl) is
338: cursor q1 (pp_asn varchar2) is
339: select logical_flow_name, logical_flow_id
340: from jtf_dpf_logical_flows_b lf
341: where lf.application_id =
342: (select application_id from fnd_application fa
343: where fa.application_short_name = pp_asn);
344:

Line 873: delete from jtf_dpf_logical_flows_b

869: procedure flow_delete(p_logical_flow_id number) is
870: begin
871: delete from jtf_dpf_lgcl_flow_params
872: where logical_flow_id = p_logical_flow_id;
873: delete from jtf_dpf_logical_flows_b
874: where logical_flow_id = p_logical_flow_id;
875: delete from jtf_dpf_logical_flows_tl
876: where logical_flow_id = p_logical_flow_id;
877: delete from jtf_dpf_lgcl_next_rules

Line 886: current_name jtf_dpf_logical_flows_b.logical_flow_name%type;

882: function flow_update(p_logical_flow_id number,
883: upd flow_update_rec) return number is
884: t_appid number;
885: existential number;
886: current_name jtf_dpf_logical_flows_b.logical_flow_name%type;
887: begin
888: if upd.p_new_name is null or 0 = length(upd.p_new_name) then
889: return 3;
890: end if;

Line 925: from jtf_dpf_logical_flows_b

921: -- is the proposed new name different from the current name, and yet
922: -- already taken? count the number of rows which already have this
923: -- name, but which have a different logical_flow_id
924: select logical_flow_name into current_name
925: from jtf_dpf_logical_flows_b
926: where logical_flow_id = p_logical_flow_id;
927:
928: if current_name <> upd.p_new_name then
929: select count(*) into existential

Line 930: from jtf_dpf_logical_flows_b

926: where logical_flow_id = p_logical_flow_id;
927:
928: if current_name <> upd.p_new_name then
929: select count(*) into existential
930: from jtf_dpf_logical_flows_b
931: where logical_flow_id <> p_logical_flow_id and
932: logical_flow_name = upd.p_new_name and
933: application_id = t_appid;
934:

Line 938: update jtf_dpf_logical_flows_b

934:
935: if existential > 0 then return 2; end if;
936: end if;
937:
938: update jtf_dpf_logical_flows_b
939: set
940: logical_flow_name = upd.p_new_name,
941: flow_finalizer_class = upd.p_new_flow_finalizer_class,
942: -- logical_flow_description = p_new_descr,

Line 966: update jtf_dpf_logical_flows_b

962: end if;
963:
964: -- update logical_flow_head_id, unless the given is G_MISS_NUM
965: if fnd_api.g_miss_num <> upd.p_new_header_logical_page_id then
966: update jtf_dpf_logical_flows_b
967: set logical_flow_head_id = upd.p_new_header_logical_page_id
968: where logical_flow_id = p_logical_flow_id;
969: end if;
970:

Line 973: update jtf_dpf_logical_flows_b

969: end if;
970:
971: -- update return_to_page_id, unless the given is G_MISS_NUM
972: if fnd_api.g_miss_num <> upd.p_rtn_to_logical_page_id then
973: update jtf_dpf_logical_flows_b
974: set return_to_page_id = upd.p_rtn_to_logical_page_id
975: where logical_flow_id = p_logical_flow_id;
976: end if;
977:

Line 993: log_id jtf_dpf_logical_flows_b.logical_flow_id%type;

989: p_new_header_logical_page_id number,
990: p_rtn_to_logical_page_id number) return number is
991: t_appid number;
992: existential number;
993: log_id jtf_dpf_logical_flows_b.logical_flow_id%type;
994: t_rowid rowid;
995: begin
996: if p_new_name is null or 0 = length(p_new_name) then return 3; end if;
997:

Line 1018: from jtf_dpf_logical_flows_b

1014: select application_id into t_appid
1015: from fnd_application where application_short_name = p_new_asn;
1016:
1017: select count(*) into existential
1018: from jtf_dpf_logical_flows_b
1019: where application_id = t_appid and
1020: logical_flow_name = p_new_name;
1021:
1022: if existential <> 0 then return 2; end if;

Line 1046: -- insert into jtf_dpf_logical_flows_b(

1042: X_LAST_UPDATE_DATE => SYSDATE,
1043: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1044: X_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID);
1045:
1046: -- insert into jtf_dpf_logical_flows_b(
1047: -- logical_flow_id,
1048: -- logical_flow_head_id,
1049: -- return_to_page_id,
1050: -- logical_flow_name,

Line 1116: from jtf_dpf_logical_flows_b

1112: existential number;
1113: new_flow_id number;
1114: begin
1115: select count(*) into existential
1116: from jtf_dpf_logical_flows_b
1117: where logical_flow_id = p_flow_id;
1118:
1119: if existential <> 1 then return 2; end if;
1120:

Line 1121: -- insert a single row into jtf_dpf_logical_flows_b and the

1117: where logical_flow_id = p_flow_id;
1118:
1119: if existential <> 1 then return 2; end if;
1120:
1121: -- insert a single row into jtf_dpf_logical_flows_b and the
1122: -- same number of rows that're already in jtf_dpf_logical_flows_tl
1123: -- for the old p_flow_id.
1124:
1125: select jtf_dpf_logical_flows_s.nextval into new_flow_id from dual;

Line 1129: insert into jtf_dpf_logical_flows_b(

1125: select jtf_dpf_logical_flows_s.nextval into new_flow_id from dual;
1126:
1127: p_new_flow_id := new_flow_id;
1128:
1129: insert into jtf_dpf_logical_flows_b(
1130: LOGICAL_FLOW_ID,
1131: LOGICAL_FLOW_HEAD_ID,
1132: LOGICAL_FLOW_NAME,
1133: -- LOGICAL_FLOW_DESCRIPTION,

Line 1165: from jtf_dpf_logical_flows_b o

1161: SYSDATE,
1162: SYSDATE,
1163: FND_GLOBAL.USER_ID,
1164: FND_GLOBAL.CONC_LOGIN_ID
1165: from jtf_dpf_logical_flows_b o
1166: where o.logical_flow_id = p_flow_id;
1167:
1168: insert into jtf_dpf_logical_flows_tl(
1169: logical_flow_id,

Line 1234: l_flow_name jtf_dpf_logical_flows_b.logical_flow_name%type;

1230:
1231: function flow_activate(p_flow_id number) return number is
1232: existential number;
1233: l_app_id number;
1234: l_flow_name jtf_dpf_logical_flows_b.logical_flow_name%type;
1235: begin
1236: select count(*) into existential
1237: from jtf_dpf_logical_flows_b
1238: where logical_flow_id = p_flow_id;

Line 1237: from jtf_dpf_logical_flows_b

1233: l_app_id number;
1234: l_flow_name jtf_dpf_logical_flows_b.logical_flow_name%type;
1235: begin
1236: select count(*) into existential
1237: from jtf_dpf_logical_flows_b
1238: where logical_flow_id = p_flow_id;
1239:
1240: if existential <> 1 then return 2; end if;
1241:

Line 1244: from jtf_dpf_logical_flows_b

1240: if existential <> 1 then return 2; end if;
1241:
1242: select application_id, logical_flow_name
1243: into l_app_id, l_flow_name
1244: from jtf_dpf_logical_flows_b
1245: where logical_flow_id = p_flow_id;
1246:
1247:
1248: -- deactivate all flows with the same appid and name as this one

Line 1249: update jtf_dpf_logical_flows_b

1245: where logical_flow_id = p_flow_id;
1246:
1247:
1248: -- deactivate all flows with the same appid and name as this one
1249: update jtf_dpf_logical_flows_b
1250: set enabled_clone_flag = 'F',
1251: object_version_number = OBJECT_VERSION_NUMBER+1,
1252: last_update_date = sysdate,
1253: last_updated_by = fnd_global.user_id,

Line 1258: update jtf_dpf_logical_flows_b

1254: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
1255: where application_id = l_app_id and logical_flow_name = l_flow_name;
1256:
1257: -- activate this one
1258: update jtf_dpf_logical_flows_b
1259: set enabled_clone_flag = 'T',
1260: object_version_number = OBJECT_VERSION_NUMBER+1,
1261: last_update_date = sysdate,
1262: last_updated_by = fnd_global.user_id,