[Home] [Help]
490: --
491: Begin
492: Select fnd_profile.value('CSI_TXN_HISTORY_PURGE_BATCH_SIZE')
493: Into v_batch
494: From dual;
495: Exception
496: When no_data_found Then
497: v_batch := 15000;
498: End;
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;
705: l_inst_hist_rec_tab.old_instance_number(l_ctr) := i.old_instance_number;
706: l_inst_hist_rec_tab.new_instance_number(l_ctr) := i.new_instance_number;
1433: --
1434: Begin
1435: Select fnd_profile.value('CSI_TXN_HISTORY_PURGE_BATCH_SIZE')
1436: Into v_batch
1437: From dual;
1438: Exception
1439: When no_data_found Then
1440: v_batch := 15000;
1441: End;
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;
1529: l_pty_hist_rec_tab.transaction_id(l_ctr) := i.transaction_id;
1530: l_pty_hist_rec_tab.instance_party_id(l_ctr) := i.instance_party_id;
1877: --
1878: Begin
1879: Select fnd_profile.value('CSI_TXN_HISTORY_PURGE_BATCH_SIZE')
1880: Into v_batch
1881: From dual;
1882: Exception
1883: When no_data_found Then
1884: v_batch := 15000;
1885: End;
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;
1969: l_acct_hist_rec_tab.ip_account_id(l_ctr) := i.ip_account_id;
1970: l_acct_hist_rec_tab.transaction_id(l_ctr) := i.transaction_id;
2303: --
2304: Begin
2305: Select fnd_profile.value('CSI_TXN_HISTORY_PURGE_BATCH_SIZE')
2306: Into v_batch
2307: From dual;
2308: Exception
2309: When no_data_found Then
2310: v_batch := 15000;
2311: End;
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;
2389: l_org_units_hist_rec_tab.instance_ou_id(l_ctr) := i.instance_ou_id;
2390: l_org_units_hist_rec_tab.transaction_id(l_ctr) := i.transaction_id;
2706: --
2707: Begin
2708: Select fnd_profile.value('CSI_TXN_HISTORY_PURGE_BATCH_SIZE')
2709: Into v_batch
2710: From dual;
2711: Exception
2712: When no_data_found Then
2713: v_batch := 15000;
2714: End;
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;
2790: l_ext_attrib_hist_rec_tab.attribute_value_id(l_ctr) := i.attribute_value_id;
2791: l_ext_attrib_hist_rec_tab.transaction_id(l_ctr) := i.transaction_id;
3102: --
3103: Begin
3104: Select fnd_profile.value('CSI_TXN_HISTORY_PURGE_BATCH_SIZE')
3105: Into v_batch
3106: From dual;
3107: Exception
3108: When no_data_found Then
3109: v_batch := 15000;
3110: End;
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;
3386: l_pri_attribs_hist_rec_tab.pricing_attribute_id(l_ctr) := i.pricing_attribute_id;
3387: l_pri_attribs_hist_rec_tab.transaction_id(l_ctr) := i.transaction_id;
4297: --
4298: Begin
4299: Select fnd_profile.value('CSI_TXN_HISTORY_PURGE_BATCH_SIZE')
4300: Into v_batch
4301: From dual;
4302: Exception
4303: When no_data_found Then
4304: v_batch := 15000;
4305: End;
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;
4359: l_ins_asset_hist_rec_tab.instance_asset_id(l_ctr) := i.instance_asset_id;
4360: l_ins_asset_hist_rec_tab.transaction_id(l_ctr) := i.transaction_id;
4600: --
4601: Begin
4602: Select fnd_profile.value('CSI_TXN_HISTORY_PURGE_BATCH_SIZE')
4603: Into v_batch
4604: From dual;
4605: Exception
4606: When no_data_found Then
4607: v_batch := 15000;
4608: End;
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;
4688: l_ver_label_hist_rec_tab.version_label_id(l_ctr) := i.version_label_id;
4689: l_ver_label_hist_rec_tab.transaction_id(l_ctr) := i.transaction_id;
5012: --
5013: Begin
5014: Select fnd_profile.value('CSI_TXN_HISTORY_PURGE_BATCH_SIZE')
5015: Into v_batch
5016: From dual;
5017: Exception
5018: When no_data_found Then
5019: v_batch := 15000;
5020: End;
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;
5100: l_rel_hist_rec_tab.relationship_id(l_ctr) := i.relationship_id;
5101: l_rel_hist_rec_tab.transaction_id(l_ctr) := i.transaction_id;
5423: --
5424: Begin
5425: Select fnd_profile.value('CSI_TXN_HISTORY_PURGE_BATCH_SIZE')
5426: Into v_batch
5427: From dual;
5428: Exception
5429: When no_data_found Then
5430: v_batch := 15000;
5431: End;
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;
5539: l_sys_hist_rec_tab.system_id(l_ctr) := i.system_id;
5540: l_sys_hist_rec_tab.transaction_id(l_ctr) := i.transaction_id;