APPS.JTF_PREFAB_CA_COMPS_PKG dependencies on JTF_PREFAB_HA_COMPS

Line 399: -- cursor c_ha is select nvl(max(HA_COMP_ID), 0) from jtf_prefab_ha_comps where HA_COMP_ID < 10000;

395: l_ca_comp_id NUMBER;
396: l_host_app_id NUMBER;
397:
398: -- cursor c is select nvl(max(CA_COMP_ID), 0) from jtf_prefab_ca_comps_b where CA_COMP_ID < 10000;
399: -- cursor c_ha is select nvl(max(HA_COMP_ID), 0) from jtf_prefab_ha_comps where HA_COMP_ID < 10000;
400: l_pseudo_seq NUMBER := NULL;
401: l_pseudo_seq_ha NUMBER := NULL;
402:
403: CURSOR host_apps_cursor IS

Line 500: INSERT INTO jtf_prefab_ha_comps (ha_comp_id,

496:
497: WHILE host_apps_cursor%FOUND LOOP
498: -- we are inserting into only one table so get the value from JTF.HA_COMP_ID_SEQ
499: -- l_pseudo_seq_ha := l_pseudo_seq_ha + 1;
500: INSERT INTO jtf_prefab_ha_comps (ha_comp_id,
501: object_version_number,
502: created_by,
503: creation_date,
504: last_updated_by,

Line 540: INSERT INTO jtf_prefab_ha_comps (ha_comp_id,

536:
537: WHILE host_apps_cursor_gen%FOUND LOOP
538: -- we are inserting into only one table so get the value from JTF.HA_COMP_ID_SEQ
539: -- l_pseudo_seq_ha := l_pseudo_seq_ha + 1;
540: INSERT INTO jtf_prefab_ha_comps (ha_comp_id,
541: object_version_number,
542: created_by,
543: creation_date,
544: last_updated_by,