APPS.JTF_DPF dependencies on JTF_DPF_LOGICAL_FLOWS_TL

Line 10: t_log_descr jtf_dpf_logical_flows_tl.logical_flow_description%type;

6: t_head_log_asn fnd_application.application_short_name%type;
7: t_head_log_name jtf_dpf_logical_pages_b.logical_page_name%type;
8: t_rtn_log_asn fnd_application.application_short_name%type;
9: t_rtn_log_name jtf_dpf_logical_pages_b.logical_page_name%type;
10: t_log_descr jtf_dpf_logical_flows_tl.logical_flow_description%type;
11:
12: cursor c1 (pp_asn varchar2) is
13: select
14: lf.logical_flow_id,

Line 31: from jtf_dpf_logical_flows_tl lftl

27: where fa2.application_short_name = pp_asn);
28: begin
29: for c1_rec in c1(asn) loop
30: select logical_flow_description into t_log_descr
31: from jtf_dpf_logical_flows_tl lftl
32: where lftl.logical_flow_id = c1_rec.logical_flow_id
33: and lftl.language = p_lang;
34:
35: select application_short_name

Line 875: delete from jtf_dpf_logical_flows_tl

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
878: where logical_flow_id = p_logical_flow_id;
879: -- commit;

Line 953: update jtf_dpf_logical_flows_tl

949: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
950: where logical_flow_id = p_logical_flow_id;
951:
952: if upd.p_new_descr is null or fnd_api.g_miss_char <> upd.p_new_descr then
953: update jtf_dpf_logical_flows_tl
954: set
955: logical_flow_description = upd.p_new_descr,
956: -- object_version_number = OBJECT_VERSION_NUMBER+1,
957: last_update_date = sysdate,

Line 1083: -- insert into jtf_dpf_logical_flows_tl(

1079: -- SYSDATE,
1080: -- FND_GLOBAL.USER_ID,
1081: -- FND_GLOBAL.CONC_LOGIN_ID);
1082: --
1083: -- insert into jtf_dpf_logical_flows_tl(
1084: -- logical_flow_id,
1085: -- language,
1086: -- source_lang,
1087: -- logical_flow_description,

Line 1122: -- same number of rows that're already in jtf_dpf_logical_flows_tl

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;
1126:

Line 1168: insert into jtf_dpf_logical_flows_tl(

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,
1170: language,
1171: source_lang,
1172: logical_flow_description,

Line 1190: from jtf_dpf_logical_flows_tl o

1186: -- SYSDATE,
1187: SYSDATE,
1188: FND_GLOBAL.USER_ID,
1189: FND_GLOBAL.CONC_LOGIN_ID
1190: from jtf_dpf_logical_flows_tl o
1191: where o.logical_flow_id = p_flow_id;
1192:
1193: -- insert N new rows into table jtf_dpf_lgcl_next_rules with
1194: -- flow_id = new_flow_id, one for each row that's currently present for