[Home] [Help]
39: NEW_attribute12,
40: NEW_attribute13,
41: NEW_attribute14,
42: NEW_attribute15
43: FROM csi_i_org_assignments_h
44: WHERE instance_ou_id = p_ou_id
45: ORDER BY creation_date;
46:
47: BEGIN
112: NEW_attribute12,
113: NEW_attribute13,
114: NEW_attribute14,
115: NEW_attribute15
116: FROM csi_i_org_assignments_h
117: WHERE instance_ou_history_id = p_ou_hist_id
118: AND full_dump_flag = 'Y';
119:
120: BEGIN
166: Process_next EXCEPTION;
167:
168: CURSOR get_nearest_full_dump(p_inst_ou_id IN NUMBER ,p_time IN DATE) IS
169: SELECT MAX(instance_ou_history_id)
170: FROM csi_i_org_assignments_h
171: WHERE creation_date <= p_time
172: AND instance_ou_id = p_inst_ou_id
173: AND full_dump_flag = 'Y';
174:
216: OLD_ATTRIBUTE14 ,
217: NEW_ATTRIBUTE14 ,
218: OLD_ATTRIBUTE15 ,
219: NEW_ATTRIBUTE15
220: FROM CSI_I_ORG_ASSIGNMENTS_H
221: WHERE creation_date <= p_time
222: AND creation_date >= p_nearest_full_dump
223: AND instance_ou_id = p_inst_ou_id
224: ORDER BY creation_date;
1004: -- Get a unique org_assignment history number from the sequence
1005: l_csi_i_org_assign_h_id := csi_org_unit_vld_pvt.get_cis_i_org_assign_h_id;
1006: l_dump_frequency_flag := 'N';
1007: -- Create a row in csi_i_org_assignment history table
1008: CSI_I_ORG_ASSIGNMENTS_H_PKG.Insert_Row(
1009: l_csi_i_org_assign_h_id
1010: ,l_instance_ou_id
1011: ,p_txn_rec.TRANSACTION_ID
1012: ,NULL
1201: ,old_attribute15
1202: ,new_attribute15
1203: ,full_dump_flag
1204: ,object_version_number
1205: FROM csi_i_org_assignments_h
1206: WHERE csi_i_org_assignments_h.instance_ou_history_id = p_org_hist_id
1207: FOR UPDATE OF object_version_number ;
1208: l_org_hist_csr org_hist_csr%ROWTYPE;
1209: l_org_hist_id NUMBER;
1202: ,new_attribute15
1203: ,full_dump_flag
1204: ,object_version_number
1205: FROM csi_i_org_assignments_h
1206: WHERE csi_i_org_assignments_h.instance_ou_history_id = p_org_hist_id
1207: FOR UPDATE OF object_version_number ;
1208: l_org_hist_csr org_hist_csr%ROWTYPE;
1209: l_org_hist_id NUMBER;
1210:
1546: -- Start of modifications for Bug#2547034 on 09/20/02 - rtalluri
1547: BEGIN
1548: SELECT instance_ou_history_id
1549: INTO l_org_hist_id
1550: FROM csi_i_org_assignments_h h
1551: WHERE h.transaction_id = p_txn_rec.transaction_id
1552: AND h.instance_ou_id = p_org_unit_rec.instance_ou_id;
1553:
1554: OPEN org_hist_csr(l_org_hist_id);
1555: FETCH org_hist_csr INTO l_org_hist_csr ;
1556: CLOSE org_hist_csr;
1557: IF l_org_hist_csr.full_dump_flag = 'Y'
1558: THEN
1559: csi_i_org_assignments_h_pkg.update_row(
1560: p_instance_ou_history_id => l_org_hist_id ,
1561: p_instance_ou_id => fnd_api.g_miss_num ,
1562: p_transaction_id => fnd_api.g_miss_num ,
1563: p_old_operating_unit_id => fnd_api.g_miss_num ,
1910: l_org_hist_csr.new_attribute15 := l_temp_org_unit_rec.attribute15;
1911: END IF;
1912: --
1913:
1914: csi_i_org_assignments_h_pkg.update_row(
1915: p_instance_ou_history_id => l_org_hist_id ,
1916: p_instance_ou_id => fnd_api.g_miss_num ,
1917: p_transaction_id => fnd_api.g_miss_num ,
1918: p_old_operating_unit_id => l_org_hist_csr.old_operating_unit_id ,
2051: l_temp_org_unit_rec.ATTRIBUTE15 := l_org_unit_rec.ATTRIBUTE15;
2052: END IF;
2053:
2054: -- Create a row in csi_i_org_assignment history table
2055: CSI_I_ORG_ASSIGNMENTS_H_PKG.Insert_Row(
2056: l_csi_i_org_assign_h_id
2057: ,l_instance_ou_id
2058: ,p_txn_rec.TRANSACTION_ID
2059: ,l_org_unit_rec.OPERATING_UNIT_ID
2310: END IF;
2311: --
2312:
2313: -- Create a row in csi_i_org_assignment history table
2314: CSI_I_ORG_ASSIGNMENTS_H_PKG.Insert_Row(
2315: l_csi_i_org_assign_h_id
2316: ,l_instance_ou_id
2317: ,p_txn_rec.transaction_id
2318: ,l_org_units_hist_rec.old_operating_unit_id
2694: oah.NEW_ATTRIBUTE15 ,
2695: oah.FULL_DUMP_FLAG ,
2696: oah.OBJECT_VERSION_NUMBER,
2697: oa.INSTANCE_ID
2698: FROM csi_i_org_assignments_h oah,
2699: csi_i_org_assignments oa
2700: WHERE oah.transaction_id = i_transaction_id
2701: AND oah.instance_ou_id = oa.instance_ou_id;
2702: