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_TXL_ASSETS_TL

Line 6006: -- For okl_txl_assets_tl Begin

6002:
6003: -- For okl_txl_assets_b End
6004:
6005:
6006: -- For okl_txl_assets_tl Begin
6007:
6008: TYPE l_tlid_type IS TABLE OF okl_txl_assets_tl.id%TYPE INDEX BY BINARY_INTEGER;
6009: TYPE l_tllanguage_type IS TABLE OF okl_txl_assets_tl.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
6010: TYPE l_tlsource_lang_type IS TABLE OF okl_txl_assets_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;

Line 6008: TYPE l_tlid_type IS TABLE OF okl_txl_assets_tl.id%TYPE INDEX BY BINARY_INTEGER;

6004:
6005:
6006: -- For okl_txl_assets_tl Begin
6007:
6008: TYPE l_tlid_type IS TABLE OF okl_txl_assets_tl.id%TYPE INDEX BY BINARY_INTEGER;
6009: TYPE l_tllanguage_type IS TABLE OF okl_txl_assets_tl.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
6010: TYPE l_tlsource_lang_type IS TABLE OF okl_txl_assets_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;
6011: TYPE l_tlsfwt_flag_type IS TABLE OF okl_txl_assets_tl.sfwt_flag%TYPE INDEX BY BINARY_INTEGER;
6012: TYPE l_tldescription_type IS TABLE OF okl_txl_assets_tl.description%TYPE INDEX BY BINARY_INTEGER;

Line 6009: TYPE l_tllanguage_type IS TABLE OF okl_txl_assets_tl.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;

6005:
6006: -- For okl_txl_assets_tl Begin
6007:
6008: TYPE l_tlid_type IS TABLE OF okl_txl_assets_tl.id%TYPE INDEX BY BINARY_INTEGER;
6009: TYPE l_tllanguage_type IS TABLE OF okl_txl_assets_tl.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
6010: TYPE l_tlsource_lang_type IS TABLE OF okl_txl_assets_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;
6011: TYPE l_tlsfwt_flag_type IS TABLE OF okl_txl_assets_tl.sfwt_flag%TYPE INDEX BY BINARY_INTEGER;
6012: TYPE l_tldescription_type IS TABLE OF okl_txl_assets_tl.description%TYPE INDEX BY BINARY_INTEGER;
6013: TYPE l_tlcreated_by_type IS TABLE OF okl_txl_assets_tl.created_by%TYPE INDEX BY BINARY_INTEGER;

Line 6010: TYPE l_tlsource_lang_type IS TABLE OF okl_txl_assets_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;

6006: -- For okl_txl_assets_tl Begin
6007:
6008: TYPE l_tlid_type IS TABLE OF okl_txl_assets_tl.id%TYPE INDEX BY BINARY_INTEGER;
6009: TYPE l_tllanguage_type IS TABLE OF okl_txl_assets_tl.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
6010: TYPE l_tlsource_lang_type IS TABLE OF okl_txl_assets_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;
6011: TYPE l_tlsfwt_flag_type IS TABLE OF okl_txl_assets_tl.sfwt_flag%TYPE INDEX BY BINARY_INTEGER;
6012: TYPE l_tldescription_type IS TABLE OF okl_txl_assets_tl.description%TYPE INDEX BY BINARY_INTEGER;
6013: TYPE l_tlcreated_by_type IS TABLE OF okl_txl_assets_tl.created_by%TYPE INDEX BY BINARY_INTEGER;
6014: TYPE l_tlcreation_date_type IS TABLE OF okl_txl_assets_tl.creation_date%TYPE INDEX BY BINARY_INTEGER;

Line 6011: TYPE l_tlsfwt_flag_type IS TABLE OF okl_txl_assets_tl.sfwt_flag%TYPE INDEX BY BINARY_INTEGER;

6007:
6008: TYPE l_tlid_type IS TABLE OF okl_txl_assets_tl.id%TYPE INDEX BY BINARY_INTEGER;
6009: TYPE l_tllanguage_type IS TABLE OF okl_txl_assets_tl.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
6010: TYPE l_tlsource_lang_type IS TABLE OF okl_txl_assets_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;
6011: TYPE l_tlsfwt_flag_type IS TABLE OF okl_txl_assets_tl.sfwt_flag%TYPE INDEX BY BINARY_INTEGER;
6012: TYPE l_tldescription_type IS TABLE OF okl_txl_assets_tl.description%TYPE INDEX BY BINARY_INTEGER;
6013: TYPE l_tlcreated_by_type IS TABLE OF okl_txl_assets_tl.created_by%TYPE INDEX BY BINARY_INTEGER;
6014: TYPE l_tlcreation_date_type IS TABLE OF okl_txl_assets_tl.creation_date%TYPE INDEX BY BINARY_INTEGER;
6015: TYPE l_tllast_updated_by_type IS TABLE OF okl_txl_assets_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;

Line 6012: TYPE l_tldescription_type IS TABLE OF okl_txl_assets_tl.description%TYPE INDEX BY BINARY_INTEGER;

6008: TYPE l_tlid_type IS TABLE OF okl_txl_assets_tl.id%TYPE INDEX BY BINARY_INTEGER;
6009: TYPE l_tllanguage_type IS TABLE OF okl_txl_assets_tl.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
6010: TYPE l_tlsource_lang_type IS TABLE OF okl_txl_assets_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;
6011: TYPE l_tlsfwt_flag_type IS TABLE OF okl_txl_assets_tl.sfwt_flag%TYPE INDEX BY BINARY_INTEGER;
6012: TYPE l_tldescription_type IS TABLE OF okl_txl_assets_tl.description%TYPE INDEX BY BINARY_INTEGER;
6013: TYPE l_tlcreated_by_type IS TABLE OF okl_txl_assets_tl.created_by%TYPE INDEX BY BINARY_INTEGER;
6014: TYPE l_tlcreation_date_type IS TABLE OF okl_txl_assets_tl.creation_date%TYPE INDEX BY BINARY_INTEGER;
6015: TYPE l_tllast_updated_by_type IS TABLE OF okl_txl_assets_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
6016: TYPE l_tllast_update_date_type IS TABLE OF okl_txl_assets_tl.last_update_date%TYPE INDEX BY BINARY_INTEGER;

Line 6013: TYPE l_tlcreated_by_type IS TABLE OF okl_txl_assets_tl.created_by%TYPE INDEX BY BINARY_INTEGER;

6009: TYPE l_tllanguage_type IS TABLE OF okl_txl_assets_tl.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
6010: TYPE l_tlsource_lang_type IS TABLE OF okl_txl_assets_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;
6011: TYPE l_tlsfwt_flag_type IS TABLE OF okl_txl_assets_tl.sfwt_flag%TYPE INDEX BY BINARY_INTEGER;
6012: TYPE l_tldescription_type IS TABLE OF okl_txl_assets_tl.description%TYPE INDEX BY BINARY_INTEGER;
6013: TYPE l_tlcreated_by_type IS TABLE OF okl_txl_assets_tl.created_by%TYPE INDEX BY BINARY_INTEGER;
6014: TYPE l_tlcreation_date_type IS TABLE OF okl_txl_assets_tl.creation_date%TYPE INDEX BY BINARY_INTEGER;
6015: TYPE l_tllast_updated_by_type IS TABLE OF okl_txl_assets_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
6016: TYPE l_tllast_update_date_type IS TABLE OF okl_txl_assets_tl.last_update_date%TYPE INDEX BY BINARY_INTEGER;
6017: TYPE l_tllast_update_login_type IS TABLE OF okl_txl_assets_tl.last_update_login%TYPE INDEX BY BINARY_INTEGER;

Line 6014: TYPE l_tlcreation_date_type IS TABLE OF okl_txl_assets_tl.creation_date%TYPE INDEX BY BINARY_INTEGER;

6010: TYPE l_tlsource_lang_type IS TABLE OF okl_txl_assets_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;
6011: TYPE l_tlsfwt_flag_type IS TABLE OF okl_txl_assets_tl.sfwt_flag%TYPE INDEX BY BINARY_INTEGER;
6012: TYPE l_tldescription_type IS TABLE OF okl_txl_assets_tl.description%TYPE INDEX BY BINARY_INTEGER;
6013: TYPE l_tlcreated_by_type IS TABLE OF okl_txl_assets_tl.created_by%TYPE INDEX BY BINARY_INTEGER;
6014: TYPE l_tlcreation_date_type IS TABLE OF okl_txl_assets_tl.creation_date%TYPE INDEX BY BINARY_INTEGER;
6015: TYPE l_tllast_updated_by_type IS TABLE OF okl_txl_assets_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
6016: TYPE l_tllast_update_date_type IS TABLE OF okl_txl_assets_tl.last_update_date%TYPE INDEX BY BINARY_INTEGER;
6017: TYPE l_tllast_update_login_type IS TABLE OF okl_txl_assets_tl.last_update_login%TYPE INDEX BY BINARY_INTEGER;
6018:

Line 6015: TYPE l_tllast_updated_by_type IS TABLE OF okl_txl_assets_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;

6011: TYPE l_tlsfwt_flag_type IS TABLE OF okl_txl_assets_tl.sfwt_flag%TYPE INDEX BY BINARY_INTEGER;
6012: TYPE l_tldescription_type IS TABLE OF okl_txl_assets_tl.description%TYPE INDEX BY BINARY_INTEGER;
6013: TYPE l_tlcreated_by_type IS TABLE OF okl_txl_assets_tl.created_by%TYPE INDEX BY BINARY_INTEGER;
6014: TYPE l_tlcreation_date_type IS TABLE OF okl_txl_assets_tl.creation_date%TYPE INDEX BY BINARY_INTEGER;
6015: TYPE l_tllast_updated_by_type IS TABLE OF okl_txl_assets_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
6016: TYPE l_tllast_update_date_type IS TABLE OF okl_txl_assets_tl.last_update_date%TYPE INDEX BY BINARY_INTEGER;
6017: TYPE l_tllast_update_login_type IS TABLE OF okl_txl_assets_tl.last_update_login%TYPE INDEX BY BINARY_INTEGER;
6018:
6019: -- For okl_txl_assets_tl End

Line 6016: TYPE l_tllast_update_date_type IS TABLE OF okl_txl_assets_tl.last_update_date%TYPE INDEX BY BINARY_INTEGER;

6012: TYPE l_tldescription_type IS TABLE OF okl_txl_assets_tl.description%TYPE INDEX BY BINARY_INTEGER;
6013: TYPE l_tlcreated_by_type IS TABLE OF okl_txl_assets_tl.created_by%TYPE INDEX BY BINARY_INTEGER;
6014: TYPE l_tlcreation_date_type IS TABLE OF okl_txl_assets_tl.creation_date%TYPE INDEX BY BINARY_INTEGER;
6015: TYPE l_tllast_updated_by_type IS TABLE OF okl_txl_assets_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
6016: TYPE l_tllast_update_date_type IS TABLE OF okl_txl_assets_tl.last_update_date%TYPE INDEX BY BINARY_INTEGER;
6017: TYPE l_tllast_update_login_type IS TABLE OF okl_txl_assets_tl.last_update_login%TYPE INDEX BY BINARY_INTEGER;
6018:
6019: -- For okl_txl_assets_tl End
6020:

Line 6017: TYPE l_tllast_update_login_type IS TABLE OF okl_txl_assets_tl.last_update_login%TYPE INDEX BY BINARY_INTEGER;

6013: TYPE l_tlcreated_by_type IS TABLE OF okl_txl_assets_tl.created_by%TYPE INDEX BY BINARY_INTEGER;
6014: TYPE l_tlcreation_date_type IS TABLE OF okl_txl_assets_tl.creation_date%TYPE INDEX BY BINARY_INTEGER;
6015: TYPE l_tllast_updated_by_type IS TABLE OF okl_txl_assets_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
6016: TYPE l_tllast_update_date_type IS TABLE OF okl_txl_assets_tl.last_update_date%TYPE INDEX BY BINARY_INTEGER;
6017: TYPE l_tllast_update_login_type IS TABLE OF okl_txl_assets_tl.last_update_login%TYPE INDEX BY BINARY_INTEGER;
6018:
6019: -- For okl_txl_assets_tl End
6020:
6021: -- For okl_txd_assets_b Begin

Line 6019: -- For okl_txl_assets_tl End

6015: TYPE l_tllast_updated_by_type IS TABLE OF okl_txl_assets_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
6016: TYPE l_tllast_update_date_type IS TABLE OF okl_txl_assets_tl.last_update_date%TYPE INDEX BY BINARY_INTEGER;
6017: TYPE l_tllast_update_login_type IS TABLE OF okl_txl_assets_tl.last_update_login%TYPE INDEX BY BINARY_INTEGER;
6018:
6019: -- For okl_txl_assets_tl End
6020:
6021: -- For okl_txd_assets_b Begin
6022:
6023: TYPE l_dbid_type IS TABLE OF okl_txd_assets_b.id%TYPE INDEX BY BINARY_INTEGER;

Line 6782: -- For okl_txl_assets_tl Begin

6778: l_tb2fa_cost_tab l_tbfa_cost_type;
6779:
6780: -- For okl_txl_assets_b End
6781:
6782: -- For okl_txl_assets_tl Begin
6783:
6784: l_tlid_tab l_tlid_type;
6785: l_tllanguage_tab l_tllanguage_type;
6786: l_tlsource_lang_tab l_tlsource_lang_type;

Line 6797: -- For okl_txl_assets_tl End

6793: l_tllast_update_login_tab l_tllast_update_login_type;
6794:
6795: l_txl_assets_tl_counter NUMBER := 1;
6796:
6797: -- For okl_txl_assets_tl End
6798:
6799: -- For okl_txd_assets_b Begin
6800:
6801: l_dbid_tab3 l_dbid_type;

Line 15946: PROCEDURE insert_okl_txl_assets_tl(p_old_id IN okl_txl_assets_b.id%TYPE,

15942: END LOOP;
15943: RETURN -1;
15944: END; /* find_txl_mapping_id */
15945:
15946: PROCEDURE insert_okl_txl_assets_tl(p_old_id IN okl_txl_assets_b.id%TYPE,
15947: p_new_id IN okl_txl_assets_b.id%TYPE,
15948: p_flush IN VARCHAR2 ) IS
15949: CURSOR c19(p_id NUMBER) IS
15950: SELECT

Line 15955: FROM okl_txl_assets_tl

15951: id, LANGUAGE, source_lang,
15952: sfwt_flag, description, created_by,
15953: creation_date, last_updated_by, last_update_date,
15954: last_update_login
15955: FROM okl_txl_assets_tl
15956: WHERE id = p_id;
15957:
15958: l_tlid_tab2 l_tlid_type;
15959: l_tllanguage_tab2 l_tllanguage_type;

Line 16011: INSERT INTO okl_txl_assets_tl (

16007: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
16008: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_txl_assets_tl_counter=' || l_txl_assets_tl_counter || ' l_tlid_tab.count=' || l_tlid_tab.COUNT);
16009: END IF;
16010: forall i IN l_tlid_tab.first..l_tlid_tab.last
16011: INSERT INTO okl_txl_assets_tl (
16012: id, LANGUAGE, source_lang,
16013: sfwt_flag, description, created_by,
16014: creation_date, last_updated_by, last_update_date,
16015: last_update_login

Line 16031: p_token1_value => 'insert_okl_txl_assets_tl');*/

16027: x_return_status := OKL_API.G_RET_STS_ERROR;
16028: /*OKL_API.set_message(p_app_name => 'OKL',
16029: p_msg_name => 'OKL_AM_NO_OLD_SALVAGE_VALUE',
16030: p_token1 => 'ASSET_NUMBER',
16031: p_token1_value => 'insert_okl_txl_assets_tl');*/
16032: /* DEBUG */
16033: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
16034: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'sqlcode=' || SQLCODE || ':sqlerrm=' || SQLERRM);
16035: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Printing insert_okl-txl_assets_tl:l_tlid_tab.count=' || l_tlid_tab.COUNT || ' ...');

Line 16035: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Printing insert_okl-txl_assets_tl:l_tlid_tab.count=' || l_tlid_tab.COUNT || ' ...');

16031: p_token1_value => 'insert_okl_txl_assets_tl');*/
16032: /* DEBUG */
16033: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
16034: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'sqlcode=' || SQLCODE || ':sqlerrm=' || SQLERRM);
16035: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Printing insert_okl-txl_assets_tl:l_tlid_tab.count=' || l_tlid_tab.COUNT || ' ...');
16036: END IF;
16037: IF (l_tlid_tab.COUNT > 0) THEN
16038: FOR i IN l_tlid_tab.first..l_tlid_tab.last
16039: LOOP

Line 16052: END; /* insert_okl_txl_assets_tl */

16048: END IF;
16049:
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

Line 16963: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting okl_txl_assets_tl...' || TO_CHAR(SYSDATE,'HH24:MI:SS'));

16959: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting okl_txl_assets_b done...' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
16960: END IF;
16961: sort_txl_id_mapping_tab;
16962: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
16963: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting okl_txl_assets_tl...' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
16964: END IF;
16965: FOR i IN l_tbid_tab.first..l_tbid_tab.last
16966: LOOP
16967: IF (i = l_tbid_tab.last) THEN

Line 16968: insert_okl_txl_assets_tl(l_tbid_tab3(i), l_tbid_tab(i), 'Y');

16964: END IF;
16965: FOR i IN l_tbid_tab.first..l_tbid_tab.last
16966: LOOP
16967: IF (i = l_tbid_tab.last) THEN
16968: insert_okl_txl_assets_tl(l_tbid_tab3(i), l_tbid_tab(i), 'Y');
16969: ELSE
16970: insert_okl_txl_assets_tl(l_tbid_tab3(i), l_tbid_tab(i), 'N');
16971: END IF;
16972: END LOOP;

Line 16970: insert_okl_txl_assets_tl(l_tbid_tab3(i), l_tbid_tab(i), 'N');

16966: LOOP
16967: IF (i = l_tbid_tab.last) THEN
16968: insert_okl_txl_assets_tl(l_tbid_tab3(i), l_tbid_tab(i), 'Y');
16969: ELSE
16970: insert_okl_txl_assets_tl(l_tbid_tab3(i), l_tbid_tab(i), 'N');
16971: END IF;
16972: END LOOP;
16973:
16974: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 18298: -- okl_txl_assets_tl

18294:
18295: l_new_id NUMBER;
18296: l_t3id_tab l_tid_type;
18297:
18298: -- okl_txl_assets_tl
18299: l_tl2id_tab l_tlid_type;
18300: l_tl2description_tab l_tldescription_type;
18301: l_tl2language_tab l_tllanguage_type;
18302:

Line 18938: INSERT INTO okl_txl_assets_tl (

18934: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_txl_assets_tl_counter4=' || l_txl_assets_tl_counter4 || ' l_tl2id_tab.count=' || l_tl2id_tab.COUNT);
18935: END IF;
18936: IF (l_tl2id_tab.COUNT > 0) THEN
18937: forall i IN l_tl2id_tab.first..l_tl2id_tab.last
18938: INSERT INTO okl_txl_assets_tl (
18939: id, LANGUAGE, source_lang,
18940: sfwt_flag, description, created_by,
18941: creation_date, last_updated_by, last_update_date,
18942: last_update_login