[Home] [Help]
817: l_count NUMBER;
818: l_hist_id NUMBER;
819: BEGIN
820: l_count := p_inst_hist_tbl.count + 1;
821: select CSI_ITEM_INSTANCES_H_S.nextval
822: into l_hist_id
823: from sys.dual;
824: p_inst_hist_tbl(l_count).instance_id := p_inst_rec.instance_id;
825: p_inst_hist_tbl(l_count).instance_history_id := l_hist_id;
3146: );
3147: --
3148: l_ctr := l_inst_rec_tab.instance_id.count;
3149: FORALL i in 1 .. l_ctr
3150: INSERT INTO CSI_ITEM_INSTANCES(
3151: INSTANCE_ID,
3152: INSTANCE_NUMBER,
3153: EXTERNAL_REFERENCE,
3154: INVENTORY_ITEM_ID,
3477: --
3478: l_ctr := l_inst_hist_rec_tab.instance_history_id.count;
3479: --
3480: FORALL i in 1 .. l_ctr
3481: INSERT INTO CSI_ITEM_INSTANCES_H(
3482: INSTANCE_HISTORY_ID,
3483: INSTANCE_ID,
3484: TRANSACTION_ID,
3485: OLD_INSTANCE_NUMBER,
4378: --
4379: l_ctr := l_owner_pty_acct_rec_tab.instance_id.count;
4380: --
4381: FORALL i in 1 .. l_ctr
4382: UPDATE CSI_ITEM_INSTANCES
4383: SET owner_party_id = l_owner_pty_acct_rec_tab.party_id(i)
4384: ,owner_party_source_table = l_owner_pty_acct_rec_tab.party_source_table(i)
4385: ,owner_party_account_id = l_owner_pty_acct_rec_tab.account_id(i)
4386: WHERE instance_id = l_owner_pty_acct_rec_tab.instance_id(i);
5998: OTHER_ERROR EXCEPTION; -- Added for bug 3579121(rel 11.5.9)
5999:
6000: CURSOR instance_csr (p_ins_id IN NUMBER) IS
6001: SELECT *
6002: FROM csi_item_instances
6003: WHERE instance_id = p_ins_id;
6004: --
6005: l_instance_csr instance_csr%ROWTYPE;
6006: --
7226: --
7227: -- Asset Open Interface should have this validation as False
7228: --
7229: -- Since the item instance is not yet created, the set_fa_sync_flag routine
7230: -- that looks at csi_item_instances cannot be used directly. Hence calling the
7231: -- same with the location_id.
7232: --
7233: IF p_asset_assignment_tbl(tab_row).fa_sync_validation_reqd = fnd_api.g_true THEN
7234: IF p_instance_tbl(inst_tab_row).location_type_code = 'HZ_PARTY_SITES' THEN
8071: -- Delete the Instances failed in Counter and Contracts creation.
8072: IF l_del_inst_tbl.count > 0 THEN
8073: BEGIN
8074: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
8075: DELETE FROM CSI_ITEM_INSTANCES WHERE instance_id = l_del_inst_tbl(j);
8076: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
8077: DELETE FROM CSI_IP_ACCOUNTS WHERE instance_party_id in (SELECT instance_party_id
8078: from CSI_I_PARTIES WHERE instance_id = l_del_inst_tbl(j));
8079: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
8088: DELETE FROM CSI_IEA_VALUES WHERE instance_id = l_del_inst_tbl(j);
8089: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
8090: DELETE FROM CSI_I_ASSETS WHERE instance_id = l_del_inst_tbl(j);
8091: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
8092: DELETE FROM CSI_ITEM_INSTANCES_H WHERE transaction_id = l_del_txn_tbl(j);
8093: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
8094: DELETE FROM CSI_I_PARTIES_H WHERE transaction_id = l_del_txn_tbl(j);
8095: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
8096: DELETE FROM CSI_IP_ACCOUNTS_H WHERE transaction_id = l_del_txn_tbl(j);
8368: ,OWNER_PARTY_ACCOUNT_ID
8369: ,LAST_VLD_ORGANIZATION_ID
8370: ,MIGRATED_FLAG
8371: ,NULL PROCESSED_FLAG
8372: from CSI_ITEM_INSTANCES
8373: where instance_id = p_ins_id;
8374: --
8375: l_instance_csr instance_csr%ROWTYPE;
8376: --
8453: ,OWNER_PARTY_ACCOUNT_ID
8454: ,LAST_VLD_ORGANIZATION_ID
8455: ,MIGRATED_FLAG
8456: ,NULL PROCESSED_FLAG
8457: FROM CSI_ITEM_INSTANCES
8458: WHERE instance_id = p_ins_id;
8459: l_old_ins_csr old_ins_csr%ROWTYPE;
8460: --
8461: l_iface_error_text VARCHAR2(2000);
8627: --
8628: IF l_child_exists = 'Y' THEN -- Call update API with the New object version Number
8629: select object_version_number
8630: into l_new_instance_rec.object_version_number
8631: from CSI_ITEM_INSTANCES
8632: where instance_id = l_new_instance_rec.instance_id;
8633: END IF;
8634: -- Call the update_item_instance private API to update the instances
8635: l_iface_error_text := NULL;
9263: l_new_instance_rec := l_temp_instance_rec;
9264: Begin
9265: select active_end_date,object_version_number
9266: into l_new_instance_rec.active_end_date,l_new_instance_rec.object_version_number
9267: from CSI_ITEM_INSTANCES
9268: where instance_id = l_exp_tbl(k).instance_id;
9269: Exception
9270: when no_data_found then
9271: p_instance_tbl(k).processed_flag := 'E';
10813: For ins_tab in l_ins_tbl.FIRST .. l_ins_tbl.LAST
10814: Loop
10815: l_grp_ctr := l_grp_ctr + 1;
10816: l_grp_ins_tbl(l_grp_ctr) := p_instance_rec;
10817: select CSI_ITEM_INSTANCES_S.nextval
10818: into l_grp_ins_tbl(l_grp_ctr).instance_id
10819: from dual;
10820: --
10821: