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.

APPS.CSI_TXN_HISTORY_PURGE_PVT dependencies on CSI_HISTORY_ARCHIVE

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 904: Insert Into CSI_HISTORY_ARCHIVE

900:
901: -- Archive the Instance History Data for the Transaction range
902: FORALL i IN 1 .. l_cnt
903:
904: Insert Into CSI_HISTORY_ARCHIVE
905: (
906: HISTORY_ARCHIVE_ID
907: ,OBJECT_ID
908: ,ENTITY_HISTORY_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 1606: Insert Into CSI_HISTORY_ARCHIVE

1602: If l_cnt > 0 Then
1603:
1604: FORALL i IN 1 .. l_cnt
1605:
1606: Insert Into CSI_HISTORY_ARCHIVE
1607: (
1608: HISTORY_ARCHIVE_ID
1609: ,OBJECT_ID
1610: ,ENTITY_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 2042: Insert Into CSI_HISTORY_ARCHIVE

2038: If l_cnt > 0 Then
2039:
2040: FORALL i IN 1 .. l_cnt
2041:
2042: Insert Into CSI_HISTORY_ARCHIVE
2043: (
2044: HISTORY_ARCHIVE_ID
2045: ,OBJECT_ID
2046: ,ENTITY_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 2456: Insert Into CSI_HISTORY_ARCHIVE

2452: If l_cnt > 0 Then
2453:
2454: FORALL i IN 1 .. l_cnt
2455:
2456: Insert Into CSI_HISTORY_ARCHIVE
2457: (
2458: HISTORY_ARCHIVE_ID
2459: ,OBJECT_ID
2460: ,ENTITY_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 2856: Insert Into CSI_HISTORY_ARCHIVE

2852: If l_cnt > 0 Then
2853:
2854: FORALL i IN 1 .. l_cnt
2855:
2856: Insert Into CSI_HISTORY_ARCHIVE
2857: (
2858: HISTORY_ARCHIVE_ID
2859: ,OBJECT_ID
2860: ,ENTITY_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 3651: Insert Into CSI_HISTORY_ARCHIVE

3647: If l_cnt > 0 Then
3648:
3649: FORALL i IN 1 .. l_cnt
3650:
3651: Insert Into CSI_HISTORY_ARCHIVE
3652: (
3653: HISTORY_ARCHIVE_ID
3654: ,OBJECT_ID
3655: ,ENTITY_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 4402: Insert Into CSI_HISTORY_ARCHIVE

4398: If l_cnt > 0 Then
4399:
4400: FORALL i IN 1 .. l_cnt
4401:
4402: Insert Into CSI_HISTORY_ARCHIVE
4403: (
4404:
4405: HISTORY_ARCHIVE_ID
4406: ,OBJECT_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 4757: Insert Into CSI_HISTORY_ARCHIVE

4753: If l_cnt > 0 Then
4754:
4755: FORALL i IN 1 .. l_cnt
4756:
4757: Insert Into CSI_HISTORY_ARCHIVE
4758: (
4759: HISTORY_ARCHIVE_ID
4760: ,OBJECT_ID
4761: ,ENTITY_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 5169: Insert Into CSI_HISTORY_ARCHIVE

5165: If l_cnt > 0 Then
5166:
5167: FORALL i IN 1 .. l_cnt
5168:
5169: Insert Into CSI_HISTORY_ARCHIVE
5170: (
5171: HISTORY_ARCHIVE_ID
5172: ,OBJECT_ID
5173: ,ENTITY_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;

Line 5636: Insert Into CSI_HISTORY_ARCHIVE

5632: If l_cnt > 0 Then
5633:
5634: FORALL i IN 1 .. l_cnt
5635:
5636: Insert Into CSI_HISTORY_ARCHIVE
5637: (
5638: HISTORY_ARCHIVE_ID
5639: ,OBJECT_ID
5640: ,ENTITY_HISTORY_ID