[Home] [Help]
52: ,org_unit_cd
53: ,cost_centre
54: ,subject
55: ,proportion
56: FROM igs_he_unt_ou_cc
57: WHERE unit_cd = p_c_old_unit_cd
58: AND version_number = p_n_old_version_number
59: AND NOT EXISTS (
60: SELECT 'x'
57: WHERE unit_cd = p_c_old_unit_cd
58: AND version_number = p_n_old_version_number
59: AND NOT EXISTS (
60: SELECT 'x'
61: FROM igs_he_unt_ou_cc
62: WHERE unit_cd = p_c_new_unit_cd
63: AND version_number = p_n_new_version_number
64: );
65:
109: FOR x_c2_rec IN x_c2 LOOP
110:
111: -- IGSWI46B.pls
112: -- p_c_message := 'WILL NOW INSERT INTO IGS_HE_ST_UV_CC_ALL';
113: IGS_HE_UNT_OU_CC_PKG.Insert_Row(
114: X_ROWID => x_c2_rec.rowid,
115: X_HESA_UNIT_CC_ID => x_seq_id, --Sequence generated in handler!!
116: X_UNIT_CD => p_c_new_unit_cd,
117: X_VERSION_NUMBER => p_n_new_version_number,