APPS.CSI_TXN_HISTORY_PURGE_PVT dependencies on CSI_HISTORY_ARCHIVE_S

Line 700: Select csi_history_archive_s.Nextval

696: Loop
697:
698: l_ctr := l_ctr + 1;
699:
700: Select csi_history_archive_s.Nextval
701: Into l_archive_id_tbl(l_ctr)
702: From dual;
703:
704: l_inst_hist_rec_tab.instance_id(l_ctr) := i.instance_id;

Line 1524: Select csi_history_archive_s.Nextval

1520: Loop
1521: --
1522: l_ctr := l_ctr + 1;
1523: --
1524: Select csi_history_archive_s.Nextval
1525: Into l_archive_id_tbl(l_ctr)
1526: From dual;
1527: --
1528: l_pty_hist_rec_tab.instance_party_history_id(l_ctr) := i.instance_party_history_id;

Line 1964: Select csi_history_archive_s.Nextval

1960: Loop
1961: --
1962: l_ctr := l_ctr + 1;
1963: --
1964: Select csi_history_archive_s.Nextval
1965: Into l_archive_id_tbl(l_ctr)
1966: From dual;
1967: --
1968: l_acct_hist_rec_tab.ip_account_history_id(l_ctr) := i.ip_account_history_id;

Line 2384: Select csi_history_archive_s.Nextval

2380: Loop
2381: --
2382: l_ctr := l_ctr + 1;
2383: --
2384: Select csi_history_archive_s.Nextval
2385: Into l_archive_id_tbl(l_ctr)
2386: From dual;
2387: --
2388: l_org_units_hist_rec_tab.instance_ou_history_id(l_ctr) := i.instance_ou_history_id;

Line 2785: Select csi_history_archive_s.Nextval

2781: Loop
2782: --
2783: l_ctr := l_ctr + 1;
2784: --
2785: Select csi_history_archive_s.Nextval
2786: Into l_archive_id_tbl(l_ctr)
2787: From dual;
2788: --
2789: l_ext_attrib_hist_rec_tab.attribute_value_history_id(l_ctr) := i.attribute_value_history_id;

Line 3381: Select csi_history_archive_s.Nextval

3377: Loop
3378: --
3379: l_ctr := l_ctr + 1;
3380: --
3381: Select csi_history_archive_s.Nextval
3382: Into l_archive_id_tbl(l_ctr)
3383: From dual;
3384: --
3385: l_pri_attribs_hist_rec_tab.price_attrib_history_id(l_ctr) := i.price_attrib_history_id;

Line 4354: Select csi_history_archive_s.Nextval

4350: Loop
4351: --
4352: l_ctr := l_ctr + 1;
4353: --
4354: Select csi_history_archive_s.Nextval
4355: Into l_archive_id_tbl(l_ctr)
4356: From dual;
4357: --
4358: l_ins_asset_hist_rec_tab.instance_asset_history_id(l_ctr) := i.instance_asset_history_id;

Line 4683: Select csi_history_archive_s.Nextval

4679: Loop
4680: --
4681: l_ctr := l_ctr + 1;
4682: --
4683: Select csi_history_archive_s.Nextval
4684: Into l_archive_id_tbl(l_ctr)
4685: From dual;
4686: --
4687: l_ver_label_hist_rec_tab.version_label_history_id(l_ctr) := i.version_label_history_id;

Line 5095: Select csi_history_archive_s.Nextval

5091: Loop
5092: --
5093: l_ctr := l_ctr + 1;
5094: --
5095: Select csi_history_archive_s.Nextval
5096: Into l_archive_id_tbl(l_ctr)
5097: From dual;
5098: --
5099: l_rel_hist_rec_tab.relationship_history_id(l_ctr) := i.relationship_history_id;

Line 5534: Select csi_history_archive_s.Nextval

5530: Loop
5531: --
5532: l_ctr := l_ctr + 1;
5533: --
5534: Select csi_history_archive_s.Nextval
5535: Into l_archive_id_tbl(l_ctr)
5536: From dual;
5537: --
5538: l_sys_hist_rec_tab.system_history_id(l_ctr) := i.system_history_id;