APPS.JTF_DIAGNOSTIC_MIGRATE dependencies on JTF_DIAGNOSTIC_ARG

Line 701: -- database table jtf_diagnostic_arg

697: end loop;
698:
699: -- send all this information to the next plsql procedure
700: -- that loops thru and makes the argument row migration to the
701: -- database table jtf_diagnostic_arg
702:
703: for v_counter in 1..v_count loop
704: migrate_test_arg_row(v_argument_names,
705: p_asn, p_grpname,

Line 777: select count(*) into v_count from jtf_diagnostic_arg

773: -- irrespective of last_migrate date
774:
775: v_rowcounter := argvallist%rowcount;
776:
777: select count(*) into v_count from jtf_diagnostic_arg
778: where testclassname = p_classname and
779: groupname = p_grpname and
780: appid = p_asn and
781: argname = v_argument_names(v_rowcounter) and

Line 788: insert into jtf_diagnostic_arg(

784: if v_last_migrate_date < x.last_update_date or v_count = 0 then
785:
786: if v_count = 0 then
787:
788: insert into jtf_diagnostic_arg(
789: SEQUENCE, TESTCLASSNAME, GROUPNAME,
790: APPID, ARGNAME, ARGVALUE,
791: ROWNUMBER, VALUESETNUMBER,
792: OBJECT_VERSION_NUMBER, CREATED_BY,

Line 796: jtf_diagnostic_arg_s.nextval,

792: OBJECT_VERSION_NUMBER, CREATED_BY,
793: LAST_UPDATE_DATE, LAST_UPDATED_BY,
794: LAST_UPDATE_LOGIN, CREATION_DATE)
795: values(
796: jtf_diagnostic_arg_s.nextval,
797: p_classname, p_grpname,
798: p_asn,
799: v_argument_names(v_rowcounter),
800: x.attribute_value, p_rownum, 1,

Line 806: update jtf_diagnostic_arg set

802: x.last_update_date, x.created_by,
803: null, x.last_update_date);
804:
805: else
806: update jtf_diagnostic_arg set
807: argvalue = x.attribute_value,
808: last_updated_by = x.last_updated_by,
809: object_version_number = x.object_version_number,
810: last_update_date = x.last_update_date