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.OKL_COPY_CONTRACT_PVT dependencies on OKL_TXD_ASSETS_TL

Line 6066: -- For okl_txd_assets_tl Begin

6062: TYPE l_dbcurrency_convers_date_type IS TABLE OF okl_txd_assets_b.currency_conversion_date%TYPE INDEX BY BINARY_INTEGER;
6063:
6064: -- For okl_txd_assets_b End
6065:
6066: -- For okl_txd_assets_tl Begin
6067:
6068: TYPE l_dlid_type IS TABLE OF okl_txd_assets_tl.id%TYPE INDEX BY BINARY_INTEGER;
6069: TYPE l_dllanguage_type IS TABLE OF okl_txd_assets_tl.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
6070: TYPE l_dlsource_lang_type IS TABLE OF okl_txd_assets_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;

Line 6068: TYPE l_dlid_type IS TABLE OF okl_txd_assets_tl.id%TYPE INDEX BY BINARY_INTEGER;

6064: -- For okl_txd_assets_b End
6065:
6066: -- For okl_txd_assets_tl Begin
6067:
6068: TYPE l_dlid_type IS TABLE OF okl_txd_assets_tl.id%TYPE INDEX BY BINARY_INTEGER;
6069: TYPE l_dllanguage_type IS TABLE OF okl_txd_assets_tl.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
6070: TYPE l_dlsource_lang_type IS TABLE OF okl_txd_assets_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;
6071: TYPE l_dlsfwt_flag_type IS TABLE OF okl_txd_assets_tl.sfwt_flag%TYPE INDEX BY BINARY_INTEGER;
6072: TYPE l_dldescription_type IS TABLE OF okl_txd_assets_tl.description%TYPE INDEX BY BINARY_INTEGER;

Line 6069: TYPE l_dllanguage_type IS TABLE OF okl_txd_assets_tl.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;

6065:
6066: -- For okl_txd_assets_tl Begin
6067:
6068: TYPE l_dlid_type IS TABLE OF okl_txd_assets_tl.id%TYPE INDEX BY BINARY_INTEGER;
6069: TYPE l_dllanguage_type IS TABLE OF okl_txd_assets_tl.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
6070: TYPE l_dlsource_lang_type IS TABLE OF okl_txd_assets_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;
6071: TYPE l_dlsfwt_flag_type IS TABLE OF okl_txd_assets_tl.sfwt_flag%TYPE INDEX BY BINARY_INTEGER;
6072: TYPE l_dldescription_type IS TABLE OF okl_txd_assets_tl.description%TYPE INDEX BY BINARY_INTEGER;
6073: TYPE l_dlcreated_by_type IS TABLE OF okl_txd_assets_tl.created_by%TYPE INDEX BY BINARY_INTEGER;

Line 6070: TYPE l_dlsource_lang_type IS TABLE OF okl_txd_assets_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;

6066: -- For okl_txd_assets_tl Begin
6067:
6068: TYPE l_dlid_type IS TABLE OF okl_txd_assets_tl.id%TYPE INDEX BY BINARY_INTEGER;
6069: TYPE l_dllanguage_type IS TABLE OF okl_txd_assets_tl.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
6070: TYPE l_dlsource_lang_type IS TABLE OF okl_txd_assets_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;
6071: TYPE l_dlsfwt_flag_type IS TABLE OF okl_txd_assets_tl.sfwt_flag%TYPE INDEX BY BINARY_INTEGER;
6072: TYPE l_dldescription_type IS TABLE OF okl_txd_assets_tl.description%TYPE INDEX BY BINARY_INTEGER;
6073: TYPE l_dlcreated_by_type IS TABLE OF okl_txd_assets_tl.created_by%TYPE INDEX BY BINARY_INTEGER;
6074: TYPE l_dlcreation_date_type IS TABLE OF okl_txd_assets_tl.creation_date%TYPE INDEX BY BINARY_INTEGER;

Line 6071: TYPE l_dlsfwt_flag_type IS TABLE OF okl_txd_assets_tl.sfwt_flag%TYPE INDEX BY BINARY_INTEGER;

6067:
6068: TYPE l_dlid_type IS TABLE OF okl_txd_assets_tl.id%TYPE INDEX BY BINARY_INTEGER;
6069: TYPE l_dllanguage_type IS TABLE OF okl_txd_assets_tl.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
6070: TYPE l_dlsource_lang_type IS TABLE OF okl_txd_assets_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;
6071: TYPE l_dlsfwt_flag_type IS TABLE OF okl_txd_assets_tl.sfwt_flag%TYPE INDEX BY BINARY_INTEGER;
6072: TYPE l_dldescription_type IS TABLE OF okl_txd_assets_tl.description%TYPE INDEX BY BINARY_INTEGER;
6073: TYPE l_dlcreated_by_type IS TABLE OF okl_txd_assets_tl.created_by%TYPE INDEX BY BINARY_INTEGER;
6074: TYPE l_dlcreation_date_type IS TABLE OF okl_txd_assets_tl.creation_date%TYPE INDEX BY BINARY_INTEGER;
6075: TYPE l_dllast_updated_by_type IS TABLE OF okl_txd_assets_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;

Line 6072: TYPE l_dldescription_type IS TABLE OF okl_txd_assets_tl.description%TYPE INDEX BY BINARY_INTEGER;

6068: TYPE l_dlid_type IS TABLE OF okl_txd_assets_tl.id%TYPE INDEX BY BINARY_INTEGER;
6069: TYPE l_dllanguage_type IS TABLE OF okl_txd_assets_tl.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
6070: TYPE l_dlsource_lang_type IS TABLE OF okl_txd_assets_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;
6071: TYPE l_dlsfwt_flag_type IS TABLE OF okl_txd_assets_tl.sfwt_flag%TYPE INDEX BY BINARY_INTEGER;
6072: TYPE l_dldescription_type IS TABLE OF okl_txd_assets_tl.description%TYPE INDEX BY BINARY_INTEGER;
6073: TYPE l_dlcreated_by_type IS TABLE OF okl_txd_assets_tl.created_by%TYPE INDEX BY BINARY_INTEGER;
6074: TYPE l_dlcreation_date_type IS TABLE OF okl_txd_assets_tl.creation_date%TYPE INDEX BY BINARY_INTEGER;
6075: TYPE l_dllast_updated_by_type IS TABLE OF okl_txd_assets_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
6076: TYPE l_dllast_update_date_type IS TABLE OF okl_txd_assets_tl.last_update_date%TYPE INDEX BY BINARY_INTEGER;

Line 6073: TYPE l_dlcreated_by_type IS TABLE OF okl_txd_assets_tl.created_by%TYPE INDEX BY BINARY_INTEGER;

6069: TYPE l_dllanguage_type IS TABLE OF okl_txd_assets_tl.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
6070: TYPE l_dlsource_lang_type IS TABLE OF okl_txd_assets_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;
6071: TYPE l_dlsfwt_flag_type IS TABLE OF okl_txd_assets_tl.sfwt_flag%TYPE INDEX BY BINARY_INTEGER;
6072: TYPE l_dldescription_type IS TABLE OF okl_txd_assets_tl.description%TYPE INDEX BY BINARY_INTEGER;
6073: TYPE l_dlcreated_by_type IS TABLE OF okl_txd_assets_tl.created_by%TYPE INDEX BY BINARY_INTEGER;
6074: TYPE l_dlcreation_date_type IS TABLE OF okl_txd_assets_tl.creation_date%TYPE INDEX BY BINARY_INTEGER;
6075: TYPE l_dllast_updated_by_type IS TABLE OF okl_txd_assets_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
6076: TYPE l_dllast_update_date_type IS TABLE OF okl_txd_assets_tl.last_update_date%TYPE INDEX BY BINARY_INTEGER;
6077: TYPE l_dllast_update_login_type IS TABLE OF okl_txd_assets_tl.last_update_login%TYPE INDEX BY BINARY_INTEGER;

Line 6074: TYPE l_dlcreation_date_type IS TABLE OF okl_txd_assets_tl.creation_date%TYPE INDEX BY BINARY_INTEGER;

6070: TYPE l_dlsource_lang_type IS TABLE OF okl_txd_assets_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;
6071: TYPE l_dlsfwt_flag_type IS TABLE OF okl_txd_assets_tl.sfwt_flag%TYPE INDEX BY BINARY_INTEGER;
6072: TYPE l_dldescription_type IS TABLE OF okl_txd_assets_tl.description%TYPE INDEX BY BINARY_INTEGER;
6073: TYPE l_dlcreated_by_type IS TABLE OF okl_txd_assets_tl.created_by%TYPE INDEX BY BINARY_INTEGER;
6074: TYPE l_dlcreation_date_type IS TABLE OF okl_txd_assets_tl.creation_date%TYPE INDEX BY BINARY_INTEGER;
6075: TYPE l_dllast_updated_by_type IS TABLE OF okl_txd_assets_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
6076: TYPE l_dllast_update_date_type IS TABLE OF okl_txd_assets_tl.last_update_date%TYPE INDEX BY BINARY_INTEGER;
6077: TYPE l_dllast_update_login_type IS TABLE OF okl_txd_assets_tl.last_update_login%TYPE INDEX BY BINARY_INTEGER;
6078:

Line 6075: TYPE l_dllast_updated_by_type IS TABLE OF okl_txd_assets_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;

6071: TYPE l_dlsfwt_flag_type IS TABLE OF okl_txd_assets_tl.sfwt_flag%TYPE INDEX BY BINARY_INTEGER;
6072: TYPE l_dldescription_type IS TABLE OF okl_txd_assets_tl.description%TYPE INDEX BY BINARY_INTEGER;
6073: TYPE l_dlcreated_by_type IS TABLE OF okl_txd_assets_tl.created_by%TYPE INDEX BY BINARY_INTEGER;
6074: TYPE l_dlcreation_date_type IS TABLE OF okl_txd_assets_tl.creation_date%TYPE INDEX BY BINARY_INTEGER;
6075: TYPE l_dllast_updated_by_type IS TABLE OF okl_txd_assets_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
6076: TYPE l_dllast_update_date_type IS TABLE OF okl_txd_assets_tl.last_update_date%TYPE INDEX BY BINARY_INTEGER;
6077: TYPE l_dllast_update_login_type IS TABLE OF okl_txd_assets_tl.last_update_login%TYPE INDEX BY BINARY_INTEGER;
6078:
6079: -- For okl_txd_assets_tl End

Line 6076: TYPE l_dllast_update_date_type IS TABLE OF okl_txd_assets_tl.last_update_date%TYPE INDEX BY BINARY_INTEGER;

6072: TYPE l_dldescription_type IS TABLE OF okl_txd_assets_tl.description%TYPE INDEX BY BINARY_INTEGER;
6073: TYPE l_dlcreated_by_type IS TABLE OF okl_txd_assets_tl.created_by%TYPE INDEX BY BINARY_INTEGER;
6074: TYPE l_dlcreation_date_type IS TABLE OF okl_txd_assets_tl.creation_date%TYPE INDEX BY BINARY_INTEGER;
6075: TYPE l_dllast_updated_by_type IS TABLE OF okl_txd_assets_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
6076: TYPE l_dllast_update_date_type IS TABLE OF okl_txd_assets_tl.last_update_date%TYPE INDEX BY BINARY_INTEGER;
6077: TYPE l_dllast_update_login_type IS TABLE OF okl_txd_assets_tl.last_update_login%TYPE INDEX BY BINARY_INTEGER;
6078:
6079: -- For okl_txd_assets_tl End
6080:

Line 6077: TYPE l_dllast_update_login_type IS TABLE OF okl_txd_assets_tl.last_update_login%TYPE INDEX BY BINARY_INTEGER;

6073: TYPE l_dlcreated_by_type IS TABLE OF okl_txd_assets_tl.created_by%TYPE INDEX BY BINARY_INTEGER;
6074: TYPE l_dlcreation_date_type IS TABLE OF okl_txd_assets_tl.creation_date%TYPE INDEX BY BINARY_INTEGER;
6075: TYPE l_dllast_updated_by_type IS TABLE OF okl_txd_assets_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
6076: TYPE l_dllast_update_date_type IS TABLE OF okl_txd_assets_tl.last_update_date%TYPE INDEX BY BINARY_INTEGER;
6077: TYPE l_dllast_update_login_type IS TABLE OF okl_txd_assets_tl.last_update_login%TYPE INDEX BY BINARY_INTEGER;
6078:
6079: -- For okl_txd_assets_tl End
6080:
6081: -- For okl_txl_itm_insts Begin

Line 6079: -- For okl_txd_assets_tl End

6075: TYPE l_dllast_updated_by_type IS TABLE OF okl_txd_assets_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
6076: TYPE l_dllast_update_date_type IS TABLE OF okl_txd_assets_tl.last_update_date%TYPE INDEX BY BINARY_INTEGER;
6077: TYPE l_dllast_update_login_type IS TABLE OF okl_txd_assets_tl.last_update_login%TYPE INDEX BY BINARY_INTEGER;
6078:
6079: -- For okl_txd_assets_tl End
6080:
6081: -- For okl_txl_itm_insts Begin
6082:
6083: TYPE l_tiid_type IS TABLE OF okl_txl_itm_insts.id%TYPE INDEX BY BINARY_INTEGER;

Line 6847: -- For okl_txd_assets_tl Begin

6843: l_txd_assets_b_counter NUMBER := 1;
6844:
6845: -- For okl_txd_assets_b End
6846:
6847: -- For okl_txd_assets_tl Begin
6848:
6849: l_dlid_tab l_dlid_type;
6850: l_dllanguage_tab l_dllanguage_type;
6851: l_dlsource_lang_tab l_dlsource_lang_type;

Line 6862: -- For okl_txd_assets_tl End

6858: l_dllast_update_login_tab l_dllast_update_login_type;
6859:
6860: l_txd_assets_tl_counter NUMBER := 1;
6861:
6862: -- For okl_txd_assets_tl End
6863:
6864: -- For okl_txl_itm_insts Begin
6865:
6866: l_tiid_tab l_tiid_type;

Line 16054: PROCEDURE insert_okl_txd_assets_tl(p_old_id IN okc_k_headers_b.id%TYPE,

16050: RAISE OKC_API.G_EXCEPTION_ERROR;
16051:
16052: END; /* insert_okl_txl_assets_tl */
16053:
16054: PROCEDURE insert_okl_txd_assets_tl(p_old_id IN okc_k_headers_b.id%TYPE,
16055: p_new_id IN okc_k_headers_b.id%TYPE,
16056: p_flush IN VARCHAR2) IS
16057: CURSOR c21(p_id NUMBER) IS
16058: SELECT

Line 16063: FROM okl_txd_assets_tl

16059: id, LANGUAGE, source_lang,
16060: sfwt_flag, description, created_by,
16061: creation_date, last_updated_by, last_update_date,
16062: last_update_login
16063: FROM okl_txd_assets_tl
16064: WHERE id = p_id
16065: AND id IN (
16066: SELECT b.id FROM okl_txd_assets_b b, okl_txl_assets_b c
16067: WHERE b.id = p_id

Line 16124: INSERT INTO okl_txd_assets_tl (

16120: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_txd_assets_tl_counter=' || l_txd_assets_tl_counter || ' l_dlid_tab.count=' || l_dlid_tab.COUNT);
16121: END IF;
16122: IF (l_txd_assets_tl_counter > 1) THEN
16123: forall i IN l_dlid_tab.first..l_dlid_tab.last
16124: INSERT INTO okl_txd_assets_tl (
16125: id, LANGUAGE, source_lang,
16126: sfwt_flag, description, created_by,
16127: creation_date, last_updated_by, last_update_date,
16128: last_update_login

Line 16143: p_token1_value => 'insert_okl_txd_assets_tl');*/

16139: x_return_status := OKL_API.G_RET_STS_ERROR;
16140: /*OKL_API.set_message(p_app_name => 'OKL',
16141: p_msg_name => 'OKL_AM_NO_OLD_SALVAGE_VALUE',
16142: p_token1 => 'ASSET_NUMBER',
16143: p_token1_value => 'insert_okl_txd_assets_tl');*/
16144: /* DEBUG */
16145: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
16146: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'sqlcode=' || SQLCODE || ':sqlerrm=' || SQLERRM);
16147: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Printing insert_okl_txd_assets_tl:l_dlid_tab.count=' || l_dlid_tab.COUNT || ' ...');

Line 16147: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Printing insert_okl_txd_assets_tl:l_dlid_tab.count=' || l_dlid_tab.COUNT || ' ...');

16143: p_token1_value => 'insert_okl_txd_assets_tl');*/
16144: /* DEBUG */
16145: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
16146: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'sqlcode=' || SQLCODE || ':sqlerrm=' || SQLERRM);
16147: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Printing insert_okl_txd_assets_tl:l_dlid_tab.count=' || l_dlid_tab.COUNT || ' ...');
16148: END IF;
16149: IF (l_dlid_tab.COUNT > 0) THEN
16150: FOR i IN l_dlid_tab.first..l_dlid_tab.last
16151: LOOP

Line 16164: END; /* insert_okl_txd_assets_tl */

16160: END IF;
16161:
16162: RAISE OKC_API.G_EXCEPTION_ERROR;
16163:
16164: END; /* insert_okl_txd_assets_tl */
16165:
16166: PROCEDURE insert_okl_txd_assets_b(p_old_id IN okc_k_headers_b.id%TYPE,
16167: p_new_id IN okc_k_headers_b.id%TYPE) IS
16168: CURSOR c20(p_id NUMBER) IS

Line 16373: insert_okl_txd_assets_tl(l_dbid_tab3(i),l_dbid_tab(i), 'Y');

16369: );
16370: FOR i IN l_dbid_tab.first..l_dbid_tab.last
16371: LOOP
16372: IF (i = l_dbid_tab.last) THEN
16373: insert_okl_txd_assets_tl(l_dbid_tab3(i),l_dbid_tab(i), 'Y');
16374: ELSE
16375: insert_okl_txd_assets_tl(l_dbid_tab3(i),l_dbid_tab(i), 'N');
16376: END IF;
16377: END LOOP;

Line 16375: insert_okl_txd_assets_tl(l_dbid_tab3(i),l_dbid_tab(i), 'N');

16371: LOOP
16372: IF (i = l_dbid_tab.last) THEN
16373: insert_okl_txd_assets_tl(l_dbid_tab3(i),l_dbid_tab(i), 'Y');
16374: ELSE
16375: insert_okl_txd_assets_tl(l_dbid_tab3(i),l_dbid_tab(i), 'N');
16376: END IF;
16377: END LOOP;
16378: END IF;
16379: EXCEPTION WHEN OTHERS THEN

Line 18332: -- okl_txd_assets_tl

18328: l_new_tal_id NUMBER;
18329: l_new_line_number NUMBER;
18330: l_junk_cost NUMBER;
18331:
18332: -- okl_txd_assets_tl
18333: l_dl2id_tab l_dlid_type;
18334: l_dl2description_tab l_dldescription_type;
18335: l_dl2language_tab l_dllanguage_type;
18336:

Line 18654: -- Populate okl_txd_assets_tl

18650: l_life_in_months);
18651: l_db2deprn_rate_tax_tab(l_txd_assets_b_counter4) := l_deprn_rate;
18652: l_db2life_in_months_tax_tab(l_txd_assets_b_counter4) := l_life_in_months;
18653:
18654: -- Populate okl_txd_assets_tl
18655: FOR j IN l_lang_tab.first..l_lang_tab.last
18656: LOOP
18657: l_dl2id_tab(l_txd_assets_tl_counter4) := l_db2id_tab(l_txd_assets_b_counter4);
18658: l_dl2description_tab(l_txd_assets_tl_counter4) := l_DESCRIPTION_tab(i);

Line 18984: INSERT INTO okl_txd_assets_tl (

18980: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_txd_assets_tl_counter4=' || l_txd_assets_tl_counter4 || ' l_dl2id_tab.count=' || l_dl2id_tab.COUNT);
18981: END IF;
18982: IF (l_dl2id_tab.COUNT > 0) THEN
18983: forall i IN l_dl2id_tab.first..l_dl2id_tab.last
18984: INSERT INTO okl_txd_assets_tl (
18985: id, LANGUAGE, source_lang,
18986: sfwt_flag, description, created_by,
18987: creation_date, last_updated_by, last_update_date,
18988: last_update_login