eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.CSI_ITEM_INSTANCE_GRP dependencies on DUAL

Line 166: from dual

162: IF l_base_item_id IS NOT NULL THEN
163: Begin
164: select 1
165: into l_count
166: from dual
167: where exists (select 'x' from mtl_system_items_b msi
168: where msi.base_item_id = l_base_item_id
169: and msi.inventory_item_id = p_instance_tbl(j).inventory_item_id);
170: Exception

Line 820: from sys.dual;

816: BEGIN
817: l_count := p_inst_hist_tbl.count + 1;
818: select CSI_ITEM_INSTANCES_H_S.nextval
819: into l_hist_id
820: from sys.dual;
821: p_inst_hist_tbl(l_count).instance_id := p_inst_rec.instance_id;
822: p_inst_hist_tbl(l_count).instance_history_id := l_hist_id;
823: p_inst_hist_tbl(l_count).transaction_id := p_txn_id;
824: p_inst_hist_tbl(l_count).old_instance_number := null;

Line 1034: from sys.dual;

1030: BEGIN
1031: l_count := p_ver_label_history_tbl.count + 1;
1032: select CSI_I_VERSION_LABELS_H_S.nextval
1033: into l_hist_id
1034: from sys.dual;
1035: --
1036: p_ver_label_history_tbl(l_count).VERSION_LABEL_HISTORY_ID := l_hist_id;
1037: p_ver_label_history_tbl(l_count).VERSION_LABEL_ID := p_version_label_rec.VERSION_LABEL_ID;
1038: p_ver_label_history_tbl(l_count).TRANSACTION_ID := p_txn_id;

Line 1094: from sys.dual;

1090: BEGIN
1091: l_count := p_party_hist_tbl.count + 1;
1092: select CSI_I_PARTIES_H_S.nextval
1093: into l_hist_id
1094: from sys.dual;
1095: --
1096: p_party_hist_tbl(l_count).INSTANCE_PARTY_HISTORY_ID := l_hist_id;
1097: p_party_hist_tbl(l_count).INSTANCE_PARTY_ID := p_party_rec.INSTANCE_PARTY_ID;
1098: p_party_hist_tbl(l_count).TRANSACTION_ID := p_txn_id;

Line 1163: from sys.dual;

1159: BEGIN
1160: l_count := p_acct_hist_tbl.count + 1;
1161: select CSI_IP_ACCOUNTS_H_S.nextval
1162: into l_hist_id
1163: from sys.dual;
1164: --
1165: p_acct_hist_tbl(l_count).IP_ACCOUNT_HISTORY_ID := l_hist_id;
1166: p_acct_hist_tbl(l_count).IP_ACCOUNT_ID := p_acct_rec.IP_ACCOUNT_ID;
1167: p_acct_hist_tbl(l_count).TRANSACTION_ID := p_txn_id;

Line 1227: from sys.dual;

1223: BEGIN
1224: l_count := p_org_hist_tbl.count + 1;
1225: select CSI_I_ORG_ASSIGNMENTS_H_S.nextval
1226: into l_hist_id
1227: from sys.dual;
1228:
1229: p_org_hist_tbl(l_count).instance_ou_history_id := l_hist_id;
1230: p_org_hist_tbl(l_count).instance_ou_id := p_org_rec.instance_ou_id;
1231: p_org_hist_tbl(l_count).transaction_id := p_txn_id;

Line 1287: from sys.dual;

1283: BEGIN
1284: l_count := p_pricing_hist_tbl.count + 1;
1285: select CSI_I_PRICING_ATTRIBS_H_S.nextval
1286: into l_hist_id
1287: from sys.dual;
1288:
1289: p_pricing_hist_tbl(l_count).PRICE_ATTRIB_HISTORY_ID := l_hist_id;
1290: p_pricing_hist_tbl(l_count).PRICING_ATTRIBUTE_ID := p_pricing_rec.pricing_attribute_id;
1291: p_pricing_hist_tbl(l_count).TRANSACTION_ID := p_txn_id;

Line 1545: from sys.dual;

1541: BEGIN
1542: l_count := p_ext_attr_hist_tbl.count + 1;
1543: select CSI_IEA_VALUES_H_S.nextval
1544: into l_hist_id
1545: from sys.dual;
1546:
1547: p_ext_attr_hist_tbl(l_count).attribute_value_history_id := l_hist_id;
1548: p_ext_attr_hist_tbl(l_count).attribute_value_id := p_ext_attr_rec.attribute_value_id;
1549: p_ext_attr_hist_tbl(l_count).transaction_id := p_txn_id;

Line 1605: from sys.dual;

1601: BEGIN
1602: l_count := p_asset_hist_tbl.count + 1;
1603: select CSI_I_ASSETS_H_S.nextval
1604: into l_hist_id
1605: from sys.dual;
1606:
1607: p_asset_hist_tbl(l_count).instance_asset_history_id := l_hist_id;
1608: p_asset_hist_tbl(l_count).transaction_id := p_txn_id;
1609: p_asset_hist_tbl(l_count).instance_asset_id := p_asset_rec.instance_asset_id;

Line 6981: from sys.dual;

6977: IF p_txn_tbl(inst_tab_row).transaction_id IS NULL OR
6978: p_txn_tbl(inst_tab_row).transaction_id = FND_API.G_MISS_NUM THEN
6979: select CSI_TRANSACTIONS_S.nextval
6980: into p_txn_tbl(inst_tab_row).transaction_id
6981: from sys.dual;
6982: END IF;
6983: --
6984: l_bulk_txn_tbl(l_bulk_inst_count) := p_txn_tbl(inst_tab_row);
6985: --

Line 6988: from sys.dual;

6984: l_bulk_txn_tbl(l_bulk_inst_count) := p_txn_tbl(inst_tab_row);
6985: --
6986: select CSI_I_VERSION_LABELS_S.nextval
6987: into l_bulk_version_label_tbl(l_bulk_inst_count).version_label_id
6988: from sys.dual;
6989: --
6990: l_bulk_version_label_tbl(l_bulk_inst_count).version_label := p_instance_tbl(inst_tab_row).version_label;
6991: l_bulk_version_label_tbl(l_bulk_inst_count).active_start_date := p_instance_tbl(inst_tab_row).active_start_date;
6992: l_bulk_version_label_tbl(l_bulk_inst_count).date_time_stamp := SYSDATE;

Line 7319: into l_ctr_id(l_counter) from sys.dual;

7315: ELSE
7316: -- Build the PL/SQL table for Inserting into Counters Temp table
7317: l_counter := l_counter + 1;
7318: select CSI_CTR_UPLOAD_INSTANCES_S.nextval
7319: into l_ctr_id(l_counter) from sys.dual;
7320: --
7321: l_ctr_ins_id(l_counter) := p_instance_tbl(inst_row).instance_id;
7322: l_ctr_item_id(l_counter) := p_instance_tbl(inst_row).inventory_item_id;
7323: l_ctr_org_id(l_counter) := p_instance_tbl(inst_row).vld_organization_id;

Line 10254: from dual;

10250: l_grp_ctr := l_grp_ctr + 1;
10251: l_grp_ins_tbl(l_grp_ctr) := p_instance_rec;
10252: select CSI_ITEM_INSTANCES_S.nextval
10253: into l_grp_ins_tbl(l_grp_ctr).instance_id
10254: from dual;
10255: --
10256: l_grp_ins_tbl(l_grp_ctr).instance_number := l_grp_ins_tbl(l_grp_ctr).instance_id;
10257: l_grp_ins_tbl(l_grp_ctr).external_reference := fnd_api.g_miss_char;
10258: l_grp_ins_tbl(l_grp_ctr).object_version_number := fnd_api.g_miss_num;