APPS.FUN_SEQ_BATCH dependencies on FUN_SEQ_BT_TBL_TYPE

Line 1893: l_temp_tab fun_seq_bt_tbl_type;

1889: x_ae_header_id_tbl OUT NOCOPY ae_header_id_tbl_type,
1890: x_assign_id_tbl OUT NOCOPY assign_id_tbl_type,
1891: x_seq_ver_id_tbl OUT NOCOPY seq_ver_id_tbl_type) IS
1892:
1893: l_temp_tab fun_seq_bt_tbl_type;
1894:
1895: BEGIN
1896: l_temp_tab := fun_seq_bt_tbl_type();
1897: --

Line 1896: l_temp_tab := fun_seq_bt_tbl_type();

1892:
1893: l_temp_tab fun_seq_bt_tbl_type;
1894:
1895: BEGIN
1896: l_temp_tab := fun_seq_bt_tbl_type();
1897: --
1898: -- Debug Information
1899: --
1900: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1963: FROM THE (SELECT CAST( l_temp_tab as fun_seq_bt_tbl_type)

1959: BULK COLLECT
1960: INTO x_ae_header_id_tbl,
1961: x_assign_id_tbl,
1962: x_seq_ver_id_tbl
1963: FROM THE (SELECT CAST( l_temp_tab as fun_seq_bt_tbl_type)
1964: FROM dual ) sqtmp
1965: ORDER BY
1966: sqtmp.seq_version_id,
1967: sqtmp.sorting_key;

Line 2006: FROM THE (SELECT CAST( l_temp_tab as fun_seq_bt_tbl_type)

2002: INTO x_application_id_tbl,
2003: x_ae_header_id_tbl,
2004: x_assign_id_tbl,
2005: x_seq_ver_id_tbl
2006: FROM THE (SELECT CAST( l_temp_tab as fun_seq_bt_tbl_type)
2007: FROM dual ) sqtmp
2008: ORDER BY
2009: sqtmp.seq_version_id,
2010: sqtmp.sorting_key;