[Home] [Help]
538: last_updated_by = fnd_global.user_id,
539: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
540: where rule_id = p_rule_id;
541:
542: if upd.p_new_descr is null or fnd_api.g_miss_char <> upd.p_new_descr then
543: update jtf_dpf_rules_tl
544: set rule_description = upd.p_new_descr,
545: -- object_version_number = OBJECT_VERSION_NUMBER+1,
546: last_update_date = sysdate,
720: last_updated_by = fnd_global.user_id,
721: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
722: where physical_page_id = p_ppid;
723:
724: if upd.p_descr is null or fnd_api.g_miss_char <> upd.p_descr then
725: update jtf_dpf_physical_pages_tl
726: set
727: physical_page_description = upd.p_descr,
728: -- object_version_number = OBJECT_VERSION_NUMBER+1,
900: upd.p_rtn_to_logical_page_id is null then
901: return 4;
902: end if;
903:
904: if fnd_api.g_miss_num <> upd.p_new_header_logical_page_id then
905: select count(*) into existential
906: from jtf_dpf_logical_pages_b
907: where logical_page_id = upd.p_new_header_logical_page_id;
908: if existential = 0 then return 4; end if;
907: where logical_page_id = upd.p_new_header_logical_page_id;
908: if existential = 0 then return 4; end if;
909: end if;
910:
911: if fnd_api.g_miss_num <> upd.p_rtn_to_logical_page_id then
912: select count(*) into existential
913: from jtf_dpf_logical_pages_b
914: where logical_page_id = upd.p_rtn_to_logical_page_id;
915: if existential = 0 then return 4; end if;
948: last_updated_by = fnd_global.user_id,
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,
961: language=userenv('LANG');
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;
968: where logical_flow_id = p_logical_flow_id;
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;
1295: return 3;
1296: end if;
1297:
1298: -- if there's no such phyiscal_id, then return 4
1299: if fnd_api.g_miss_num <> upd.p_default_physical_id then
1300: select count(*) into existential
1301: from jtf_dpf_physical_pages_b
1302: where physical_page_id = upd.p_default_physical_id;
1303:
1330: last_updated_by = fnd_global.user_id,
1331: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
1332: where logical_page_id = p_logical_page_id;
1333:
1334: if upd.p_new_descr is null or fnd_api.g_miss_char <> upd.p_new_descr then
1335: update jtf_dpf_logical_pages_tl set
1336: logical_page_description = upd.p_new_descr,
1337: -- object_version_number = OBJECT_VERSION_NUMBER+1,
1338: last_update_date = sysdate,
1341: where logical_page_id = p_logical_page_id and
1342: language = userenv('LANG');
1343: end if;
1344:
1345: if fnd_api.g_miss_num <> upd.p_default_physical_id then
1346: delete from jtf_dpf_lgcl_phy_rules where
1347: default_page_flag = 'T' and
1348: logical_page_id = p_logical_page_id;
1349: