[Home] [Help]
6351: l_csi_item_instance_h_id :=
6352: csi_item_instance_vld_pvt.get_csi_item_instance_h_id;
6353:
6354: -- Create a row in csi_item_instances_history table
6355: CSI_ITEM_INSTANCES_H_PKG.Insert_Row
6356: ( px_INSTANCE_HISTORY_ID => l_csi_item_instance_h_id
6357: ,p_INSTANCE_ID => p_instance_rec.INSTANCE_ID
6358: ,p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID
6359: ,p_OLD_INSTANCE_NUMBER => NULL
8027: CLOSE ins_hist_csr;
8028:
8029: IF l_ins_hist_csr.full_dump_flag = 'Y'
8030: THEN
8031: CSI_ITEM_INSTANCES_H_PKG.Update_Row
8032: ( p_INSTANCE_HISTORY_ID => l_ins_hist_id
8033: ,p_INSTANCE_ID => fnd_api.g_miss_num
8034: ,p_TRANSACTION_ID => fnd_api.g_miss_num
8035: ,p_OLD_INSTANCE_NUMBER => fnd_api.g_miss_char
8655: l_ins_hist_csr.new_operational_status_code := p_instance_rec.operational_status_code;
8656: END IF;
8657:
8658:
8659: CSI_ITEM_INSTANCES_H_PKG.Update_Row
8660: ( p_INSTANCE_HISTORY_ID => l_ins_hist_id
8661: ,p_INSTANCE_ID => fnd_api.g_miss_num
8662: ,p_TRANSACTION_ID => fnd_api.g_miss_num
8663: ,p_OLD_INSTANCE_NUMBER => fnd_api.g_miss_char
9052: -- p_instance_rec.OPERATIONAL_STATUS_CODE := l_curr_instance_rec.OPERATIONAL_STATUS_CODE;
9053: -- End addition of columns for FA Integration
9054:
9055: /* Commented out to implement bulk processing.... Bug:5615169
9056: CSI_ITEM_INSTANCES_H_PKG.Insert_Row
9057: ( px_INSTANCE_HISTORY_ID => l_csi_item_instance_h_id
9058: ,p_INSTANCE_ID => l_rel_tbl(j).subject_id
9059: ,p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID
9060: ,p_OLD_INSTANCE_NUMBER => l_curr_instance_rec.INSTANCE_NUMBER
9766: l_instance_hist_rec.new_operational_status_code := p_instance_rec.operational_status_code ;
9767: END IF;
9768:
9769: /* Commented to implement bulk operations...Bug:;
9770: CSI_ITEM_INSTANCES_H_PKG.Insert_Row
9771: ( px_INSTANCE_HISTORY_ID => l_csi_item_instance_h_id
9772: ,p_INSTANCE_ID => l_rel_tbl(j).SUBJECT_ID
9773: ,p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID
9774: ,p_OLD_INSTANCE_NUMBER => FND_API.G_MISS_CHAR
15127: CLOSE ins_hist_csr;
15128:
15129: IF l_ins_hist_csr.full_dump_flag = 'Y'
15130: THEN
15131: CSI_ITEM_INSTANCES_H_PKG.Update_Row
15132: ( p_INSTANCE_HISTORY_ID => l_ins_hist_id
15133: ,p_INSTANCE_ID => fnd_api.g_miss_num
15134: ,p_TRANSACTION_ID => fnd_api.g_miss_num
15135: ,p_OLD_INSTANCE_NUMBER => fnd_api.g_miss_char
16858:
16859:
16860:
16861: -- End addition for bug 2671179
16862: CSI_ITEM_INSTANCES_H_PKG.Update_Row
16863: ( p_INSTANCE_HISTORY_ID => l_ins_hist_id
16864: ,p_INSTANCE_ID => fnd_api.g_miss_num
16865: ,p_TRANSACTION_ID => fnd_api.g_miss_num
16866: ,p_OLD_INSTANCE_NUMBER => l_ins_hist_csr.OLD_INSTANCE_NUMBER
17408: p_instance_rec.OPERATIONAL_STATUS_CODE := l_curr_instance_rec.OPERATIONAL_STATUS_CODE;
17409: END IF;
17410: -- End addition of columns for FA Integration
17411:
17412: CSI_ITEM_INSTANCES_H_PKG.Insert_Row
17413: ( px_INSTANCE_HISTORY_ID => l_csi_item_instance_h_id
17414: ,p_INSTANCE_ID => p_instance_rec.instance_id
17415: ,p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID
17416: ,p_OLD_INSTANCE_NUMBER => l_curr_instance_rec.INSTANCE_NUMBER
18719: l_instance_hist_rec.new_operational_status_code := p_instance_rec.operational_status_code ;
18720: END IF;
18721: -- End addition of columns for FA Integration
18722:
18723: CSI_ITEM_INSTANCES_H_PKG.Insert_Row
18724: ( px_INSTANCE_HISTORY_ID => l_csi_item_instance_h_id
18725: ,p_INSTANCE_ID => p_instance_rec.instance_id
18726: ,p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID
18727: ,p_OLD_INSTANCE_NUMBER => l_instance_hist_rec.OLD_INSTANCE_NUMBER
19857: -- If the mod value is 0 then dump all the columns both changed and unchanged
19858: -- changed columns have old and new values while the unchanged values have old and new values
19859: -- exactly same
19860:
19861: CSI_ITEM_INSTANCES_H_PKG.Insert_Row
19862: ( px_INSTANCE_HISTORY_ID => l_csi_item_instance_h_id
19863: ,p_INSTANCE_ID => l_rel_tbl(j).subject_id
19864: ,p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID
19865: ,p_OLD_INSTANCE_NUMBER => l_curr_instance_rec.INSTANCE_NUMBER
20078: ELSE
20079: -- If the mod value is not equal to zero then dump only the changed columns
20080: -- while the unchanged values have old and new values as null
20081:
20082: CSI_ITEM_INSTANCES_H_PKG.Insert_Row
20083: ( px_INSTANCE_HISTORY_ID => l_csi_item_instance_h_id
20084: ,p_INSTANCE_ID => l_rel_tbl(j).subject_id
20085: ,p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID
20086: ,p_OLD_INSTANCE_NUMBER => FND_API.G_MISS_CHAR
21152: FROM csi_item_instances_h h
21153: WHERE h.transaction_id = p_txn_rec.transaction_id
21154: AND h.instance_id = p_instance_rec.instance_id;
21155:
21156: CSI_ITEM_INSTANCES_H_PKG.Update_Row
21157: ( p_INSTANCE_HISTORY_ID => l_ins_hist_id
21158: ,p_INSTANCE_ID => fnd_api.g_miss_num
21159: ,p_TRANSACTION_ID => fnd_api.g_miss_num
21160: ,p_OLD_INSTANCE_NUMBER => fnd_api.g_miss_char
21379: IF (l_mod_value = 0) THEN
21380: -- If the mod value is 0 then dump all the columns both changed and unchanged
21381: -- changed columns have old and new values while the unchanged values have old and new values
21382: -- exactly same
21383: CSI_ITEM_INSTANCES_H_PKG.Insert_Row
21384: ( px_INSTANCE_HISTORY_ID => l_csi_item_instance_h_id
21385: ,p_INSTANCE_ID => p_instance_rec.instance_id
21386: ,p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID
21387: ,p_OLD_INSTANCE_NUMBER => l_curr_instance_rec.INSTANCE_NUMBER
21601:
21602: ELSE
21603: -- If the mod value is not equal to zero then dump only the changed columns
21604: -- while the unchanged values have old and new values as null
21605: CSI_ITEM_INSTANCES_H_PKG.Insert_Row
21606: ( px_INSTANCE_HISTORY_ID => l_csi_item_instance_h_id
21607: ,p_INSTANCE_ID => p_instance_rec.instance_id
21608: ,p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID
21609: ,p_OLD_INSTANCE_NUMBER => l_instance_rec.INSTANCE_NUMBER