[Home] [Help]
6278: l_csi_item_instance_h_id :=
6279: csi_item_instance_vld_pvt.get_csi_item_instance_h_id;
6280:
6281: -- Create a row in csi_item_instances_history table
6282: CSI_ITEM_INSTANCES_H_PKG.Insert_Row
6283: ( px_INSTANCE_HISTORY_ID => l_csi_item_instance_h_id
6284: ,p_INSTANCE_ID => p_instance_rec.INSTANCE_ID
6285: ,p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID
6286: ,p_OLD_INSTANCE_NUMBER => NULL
7812: CLOSE ins_hist_csr;
7813:
7814: IF l_ins_hist_csr.full_dump_flag = 'Y'
7815: THEN
7816: CSI_ITEM_INSTANCES_H_PKG.Update_Row
7817: ( p_INSTANCE_HISTORY_ID => l_ins_hist_id
7818: ,p_INSTANCE_ID => fnd_api.g_miss_num
7819: ,p_TRANSACTION_ID => fnd_api.g_miss_num
7820: ,p_OLD_INSTANCE_NUMBER => fnd_api.g_miss_char
8440: l_ins_hist_csr.new_operational_status_code := p_instance_rec.operational_status_code;
8441: END IF;
8442:
8443:
8444: CSI_ITEM_INSTANCES_H_PKG.Update_Row
8445: ( p_INSTANCE_HISTORY_ID => l_ins_hist_id
8446: ,p_INSTANCE_ID => fnd_api.g_miss_num
8447: ,p_TRANSACTION_ID => fnd_api.g_miss_num
8448: ,p_OLD_INSTANCE_NUMBER => fnd_api.g_miss_char
8835: -- p_instance_rec.OPERATIONAL_STATUS_CODE := l_curr_instance_rec.OPERATIONAL_STATUS_CODE;
8836: -- End addition of columns for FA Integration
8837:
8838: /* Commented out to implement bulk processing.... Bug:5615169
8839: CSI_ITEM_INSTANCES_H_PKG.Insert_Row
8840: ( px_INSTANCE_HISTORY_ID => l_csi_item_instance_h_id
8841: ,p_INSTANCE_ID => l_rel_tbl(j).subject_id
8842: ,p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID
8843: ,p_OLD_INSTANCE_NUMBER => l_curr_instance_rec.INSTANCE_NUMBER
9549: l_instance_hist_rec.new_operational_status_code := p_instance_rec.operational_status_code ;
9550: END IF;
9551:
9552: /* Commented to implement bulk operations...Bug:;
9553: CSI_ITEM_INSTANCES_H_PKG.Insert_Row
9554: ( px_INSTANCE_HISTORY_ID => l_csi_item_instance_h_id
9555: ,p_INSTANCE_ID => l_rel_tbl(j).SUBJECT_ID
9556: ,p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID
9557: ,p_OLD_INSTANCE_NUMBER => FND_API.G_MISS_CHAR
14671: CLOSE ins_hist_csr;
14672:
14673: IF l_ins_hist_csr.full_dump_flag = 'Y'
14674: THEN
14675: CSI_ITEM_INSTANCES_H_PKG.Update_Row
14676: ( p_INSTANCE_HISTORY_ID => l_ins_hist_id
14677: ,p_INSTANCE_ID => fnd_api.g_miss_num
14678: ,p_TRANSACTION_ID => fnd_api.g_miss_num
14679: ,p_OLD_INSTANCE_NUMBER => fnd_api.g_miss_char
16402:
16403:
16404:
16405: -- End addition for bug 2671179
16406: CSI_ITEM_INSTANCES_H_PKG.Update_Row
16407: ( p_INSTANCE_HISTORY_ID => l_ins_hist_id
16408: ,p_INSTANCE_ID => fnd_api.g_miss_num
16409: ,p_TRANSACTION_ID => fnd_api.g_miss_num
16410: ,p_OLD_INSTANCE_NUMBER => l_ins_hist_csr.OLD_INSTANCE_NUMBER
16952: p_instance_rec.OPERATIONAL_STATUS_CODE := l_curr_instance_rec.OPERATIONAL_STATUS_CODE;
16953: END IF;
16954: -- End addition of columns for FA Integration
16955:
16956: CSI_ITEM_INSTANCES_H_PKG.Insert_Row
16957: ( px_INSTANCE_HISTORY_ID => l_csi_item_instance_h_id
16958: ,p_INSTANCE_ID => p_instance_rec.instance_id
16959: ,p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID
16960: ,p_OLD_INSTANCE_NUMBER => l_curr_instance_rec.INSTANCE_NUMBER
18263: l_instance_hist_rec.new_operational_status_code := p_instance_rec.operational_status_code ;
18264: END IF;
18265: -- End addition of columns for FA Integration
18266:
18267: CSI_ITEM_INSTANCES_H_PKG.Insert_Row
18268: ( px_INSTANCE_HISTORY_ID => l_csi_item_instance_h_id
18269: ,p_INSTANCE_ID => p_instance_rec.instance_id
18270: ,p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID
18271: ,p_OLD_INSTANCE_NUMBER => l_instance_hist_rec.OLD_INSTANCE_NUMBER
19360: -- If the mod value is 0 then dump all the columns both changed and unchanged
19361: -- changed columns have old and new values while the unchanged values have old and new values
19362: -- exactly same
19363:
19364: CSI_ITEM_INSTANCES_H_PKG.Insert_Row
19365: ( px_INSTANCE_HISTORY_ID => l_csi_item_instance_h_id
19366: ,p_INSTANCE_ID => l_rel_tbl(j).subject_id
19367: ,p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID
19368: ,p_OLD_INSTANCE_NUMBER => l_curr_instance_rec.INSTANCE_NUMBER
19581: ELSE
19582: -- If the mod value is not equal to zero then dump only the changed columns
19583: -- while the unchanged values have old and new values as null
19584:
19585: CSI_ITEM_INSTANCES_H_PKG.Insert_Row
19586: ( px_INSTANCE_HISTORY_ID => l_csi_item_instance_h_id
19587: ,p_INSTANCE_ID => l_rel_tbl(j).subject_id
19588: ,p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID
19589: ,p_OLD_INSTANCE_NUMBER => FND_API.G_MISS_CHAR
20615: FROM csi_item_instances_h h
20616: WHERE h.transaction_id = p_txn_rec.transaction_id
20617: AND h.instance_id = p_instance_rec.instance_id;
20618:
20619: CSI_ITEM_INSTANCES_H_PKG.Update_Row
20620: ( p_INSTANCE_HISTORY_ID => l_ins_hist_id
20621: ,p_INSTANCE_ID => fnd_api.g_miss_num
20622: ,p_TRANSACTION_ID => fnd_api.g_miss_num
20623: ,p_OLD_INSTANCE_NUMBER => fnd_api.g_miss_char
20842: IF (l_mod_value = 0) THEN
20843: -- If the mod value is 0 then dump all the columns both changed and unchanged
20844: -- changed columns have old and new values while the unchanged values have old and new values
20845: -- exactly same
20846: CSI_ITEM_INSTANCES_H_PKG.Insert_Row
20847: ( px_INSTANCE_HISTORY_ID => l_csi_item_instance_h_id
20848: ,p_INSTANCE_ID => p_instance_rec.instance_id
20849: ,p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID
20850: ,p_OLD_INSTANCE_NUMBER => l_curr_instance_rec.INSTANCE_NUMBER
21064:
21065: ELSE
21066: -- If the mod value is not equal to zero then dump only the changed columns
21067: -- while the unchanged values have old and new values as null
21068: CSI_ITEM_INSTANCES_H_PKG.Insert_Row
21069: ( px_INSTANCE_HISTORY_ID => l_csi_item_instance_h_id
21070: ,p_INSTANCE_ID => p_instance_rec.instance_id
21071: ,p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID
21072: ,p_OLD_INSTANCE_NUMBER => l_instance_rec.INSTANCE_NUMBER