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 OKC_K_LINES_TL

Line 5380: okc_k_lines_tl c

5376: a.ship_to_site_use_id, a.payment_term_id, b.fee_type,
5377: c.name
5378: FROM okc_k_lines_b a,
5379: okl_k_lines b,
5380: okc_k_lines_tl c
5381: WHERE a.dnz_chr_id = p_chr_id
5382: AND a.id = b.id
5383: AND a.id = c.id
5384: AND c.LANGUAGE = USERENV('LANG');

Line 5495: TYPE l_name_type IS TABLE OF okc_k_lines_tl.name%TYPE INDEX BY BINARY_INTEGER;

5491: TYPE l_line_renewal_type_code_type IS TABLE OF okc_k_lines_b.line_renewal_type_code%TYPE INDEX BY BINARY_INTEGER;
5492: TYPE l_ship_to_site_use_id_type IS TABLE OF okc_k_lines_b.ship_to_site_use_id%TYPE INDEX BY BINARY_INTEGER;
5493: TYPE l_payment_term_id_type IS TABLE OF okc_k_lines_b.payment_term_id%TYPE INDEX BY BINARY_INTEGER;
5494: TYPE l_fee_type_type IS TABLE OF okl_k_lines.fee_type%TYPE INDEX BY BINARY_INTEGER;
5495: TYPE l_name_type IS TABLE OF okc_k_lines_tl.name%TYPE INDEX BY BINARY_INTEGER;
5496:
5497: -- For okl_k_lines whole record
5498: TYPE l_okl_k_lines_rec_type IS RECORD (
5499: --id okl_k_lines.id%type := OKC_API.G_MISS_NUM,

Line 5503: item_description okc_k_lines_tl.item_description%TYPE := OKC_API.G_MISS_CHAR

5499: --id okl_k_lines.id%type := OKC_API.G_MISS_NUM,
5500: id NUMBER := OKC_API.G_MISS_NUM,
5501: oec okl_k_lines.oec%TYPE,
5502: year_built okl_k_lines.year_built%TYPE,
5503: item_description okc_k_lines_tl.item_description%TYPE := OKC_API.G_MISS_CHAR
5504: );
5505: /*
5506: TYPE lines_rec_type is record (
5507: id okl_k_lines.id%type := OKC_API.G_MISS_NUM,

Line 5528: TYPE l_bid_mapping_type IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_k_lines_tl.name%TYPE := OKC_API.G_MISS_CHAR);

5524: TYPE l_okc_k_items_rec_tab IS TABLE OF l_okc_k_items_rec_type INDEX BY BINARY_INTEGER;
5525: -- For okc_k_items whole record
5526:
5527:
5528: TYPE l_bid_mapping_type IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_k_lines_tl.name%TYPE := OKC_API.G_MISS_CHAR);
5529: TYPE l_cle_lse_mapping_type IS RECORD (cle_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, lse_id NUMBER := OKC_API.G_MISS_NUM, id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM);
5530: TYPE l_ssid_mapping_type IS RECORD (cle_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, object1_id1 okc_k_rel_objs_v.object1_id1%TYPE := OKC_API.G_MISS_CHAR);
5531: TYPE l_sid_mapping_type IS RECORD (id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, lse_id okc_k_lines_b.lse_id%TYPE := OKC_API.G_MISS_NUM);
5532: TYPE l_tid_mapping_type IS RECORD (rgd_code okc_rule_groups_b.rgd_code%TYPE := OKC_API.G_MISS_CHAR, id okc_rule_groups_b.id%TYPE := OKC_API.G_MISS_NUM);

Line 5541: TYPE l_aid_mapping_type IS RECORD (old_id okc_k_lines_tl.name%TYPE := OKC_API.G_MISS_CHAR, new_id okc_k_lines_tl.name%TYPE := OKC_API.G_MISS_CHAR);

5537: TYPE l_rid_mapping_type IS RECORD (old_id okc_rule_groups_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_rule_groups_b.id%TYPE := OKC_API.G_MISS_NUM);
5538: TYPE l_id_mapping_type IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM);
5539: TYPE l_orig_system_rec_type IS RECORD (orig_system_id1 okc_k_lines_b.orig_system_id1%TYPE := OKC_API.G_MISS_NUM, id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM);
5540: TYPE l_rrid_mapping_type IS RECORD (old_id okc_rules_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okc_rules_b.id%TYPE := OKC_API.G_MISS_NUM);
5541: TYPE l_aid_mapping_type IS RECORD (old_id okc_k_lines_tl.name%TYPE := OKC_API.G_MISS_CHAR, new_id okc_k_lines_tl.name%TYPE := OKC_API.G_MISS_CHAR);
5542: TYPE l_oid_mapping_type IS RECORD (cle_id okc_k_items.cle_id%TYPE := OKC_API.G_MISS_NUM, object1_id1 okc_k_items.object1_id1%TYPE := OKC_API.G_MISS_CHAR);
5543: TYPE l_cle_mapping_type IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okl_trx_assets.id%TYPE := OKC_API.G_MISS_NUM, line_number NUMBER := OKC_API.G_MISS_NUM);
5544: TYPE l_cle_mapping_type2 IS RECORD (old_id okc_k_lines_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okl_trx_assets.id%TYPE := OKC_API.G_MISS_NUM);
5545:

Line 6226: -- For okc_k_lines_tl begin

6222: TYPE l_gsecurity_group_id_type IS TABLE OF okc_rg_party_roles.security_group_id%TYPE INDEX BY BINARY_INTEGER;
6223:
6224: -- For okc_rg_party_roles End
6225:
6226: -- For okc_k_lines_tl begin
6227:
6228: TYPE l_olid_type IS TABLE OF okc_k_lines_tl.id%TYPE INDEX BY BINARY_INTEGER;
6229: TYPE l_ollanguage_type IS TABLE OF okc_k_lines_tl.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
6230: TYPE l_olsource_lang_type IS TABLE OF okc_k_lines_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;

Line 6228: TYPE l_olid_type IS TABLE OF okc_k_lines_tl.id%TYPE INDEX BY BINARY_INTEGER;

6224: -- For okc_rg_party_roles End
6225:
6226: -- For okc_k_lines_tl begin
6227:
6228: TYPE l_olid_type IS TABLE OF okc_k_lines_tl.id%TYPE INDEX BY BINARY_INTEGER;
6229: TYPE l_ollanguage_type IS TABLE OF okc_k_lines_tl.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
6230: TYPE l_olsource_lang_type IS TABLE OF okc_k_lines_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;
6231: TYPE l_olsfwt_flag_type IS TABLE OF okc_k_lines_tl.sfwt_flag%TYPE INDEX BY BINARY_INTEGER;
6232: TYPE l_olname_type IS TABLE OF okc_k_lines_tl.name%TYPE INDEX BY BINARY_INTEGER;

Line 6229: TYPE l_ollanguage_type IS TABLE OF okc_k_lines_tl.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;

6225:
6226: -- For okc_k_lines_tl begin
6227:
6228: TYPE l_olid_type IS TABLE OF okc_k_lines_tl.id%TYPE INDEX BY BINARY_INTEGER;
6229: TYPE l_ollanguage_type IS TABLE OF okc_k_lines_tl.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
6230: TYPE l_olsource_lang_type IS TABLE OF okc_k_lines_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;
6231: TYPE l_olsfwt_flag_type IS TABLE OF okc_k_lines_tl.sfwt_flag%TYPE INDEX BY BINARY_INTEGER;
6232: TYPE l_olname_type IS TABLE OF okc_k_lines_tl.name%TYPE INDEX BY BINARY_INTEGER;
6233: TYPE l_olcomments_type IS TABLE OF okc_k_lines_tl.comments%TYPE INDEX BY BINARY_INTEGER;

Line 6230: TYPE l_olsource_lang_type IS TABLE OF okc_k_lines_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;

6226: -- For okc_k_lines_tl begin
6227:
6228: TYPE l_olid_type IS TABLE OF okc_k_lines_tl.id%TYPE INDEX BY BINARY_INTEGER;
6229: TYPE l_ollanguage_type IS TABLE OF okc_k_lines_tl.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
6230: TYPE l_olsource_lang_type IS TABLE OF okc_k_lines_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;
6231: TYPE l_olsfwt_flag_type IS TABLE OF okc_k_lines_tl.sfwt_flag%TYPE INDEX BY BINARY_INTEGER;
6232: TYPE l_olname_type IS TABLE OF okc_k_lines_tl.name%TYPE INDEX BY BINARY_INTEGER;
6233: TYPE l_olcomments_type IS TABLE OF okc_k_lines_tl.comments%TYPE INDEX BY BINARY_INTEGER;
6234: TYPE l_olitem_description_type IS TABLE OF okc_k_lines_tl.item_description%TYPE INDEX BY BINARY_INTEGER;

Line 6231: TYPE l_olsfwt_flag_type IS TABLE OF okc_k_lines_tl.sfwt_flag%TYPE INDEX BY BINARY_INTEGER;

6227:
6228: TYPE l_olid_type IS TABLE OF okc_k_lines_tl.id%TYPE INDEX BY BINARY_INTEGER;
6229: TYPE l_ollanguage_type IS TABLE OF okc_k_lines_tl.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
6230: TYPE l_olsource_lang_type IS TABLE OF okc_k_lines_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;
6231: TYPE l_olsfwt_flag_type IS TABLE OF okc_k_lines_tl.sfwt_flag%TYPE INDEX BY BINARY_INTEGER;
6232: TYPE l_olname_type IS TABLE OF okc_k_lines_tl.name%TYPE INDEX BY BINARY_INTEGER;
6233: TYPE l_olcomments_type IS TABLE OF okc_k_lines_tl.comments%TYPE INDEX BY BINARY_INTEGER;
6234: TYPE l_olitem_description_type IS TABLE OF okc_k_lines_tl.item_description%TYPE INDEX BY BINARY_INTEGER;
6235: TYPE l_olblock23text_type IS TABLE OF okc_k_lines_tl.block23text%TYPE INDEX BY BINARY_INTEGER;

Line 6232: TYPE l_olname_type IS TABLE OF okc_k_lines_tl.name%TYPE INDEX BY BINARY_INTEGER;

6228: TYPE l_olid_type IS TABLE OF okc_k_lines_tl.id%TYPE INDEX BY BINARY_INTEGER;
6229: TYPE l_ollanguage_type IS TABLE OF okc_k_lines_tl.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
6230: TYPE l_olsource_lang_type IS TABLE OF okc_k_lines_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;
6231: TYPE l_olsfwt_flag_type IS TABLE OF okc_k_lines_tl.sfwt_flag%TYPE INDEX BY BINARY_INTEGER;
6232: TYPE l_olname_type IS TABLE OF okc_k_lines_tl.name%TYPE INDEX BY BINARY_INTEGER;
6233: TYPE l_olcomments_type IS TABLE OF okc_k_lines_tl.comments%TYPE INDEX BY BINARY_INTEGER;
6234: TYPE l_olitem_description_type IS TABLE OF okc_k_lines_tl.item_description%TYPE INDEX BY BINARY_INTEGER;
6235: TYPE l_olblock23text_type IS TABLE OF okc_k_lines_tl.block23text%TYPE INDEX BY BINARY_INTEGER;
6236: TYPE l_olcreated_by_type IS TABLE OF okc_k_lines_tl.created_by%TYPE INDEX BY BINARY_INTEGER;

Line 6233: TYPE l_olcomments_type IS TABLE OF okc_k_lines_tl.comments%TYPE INDEX BY BINARY_INTEGER;

6229: TYPE l_ollanguage_type IS TABLE OF okc_k_lines_tl.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
6230: TYPE l_olsource_lang_type IS TABLE OF okc_k_lines_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;
6231: TYPE l_olsfwt_flag_type IS TABLE OF okc_k_lines_tl.sfwt_flag%TYPE INDEX BY BINARY_INTEGER;
6232: TYPE l_olname_type IS TABLE OF okc_k_lines_tl.name%TYPE INDEX BY BINARY_INTEGER;
6233: TYPE l_olcomments_type IS TABLE OF okc_k_lines_tl.comments%TYPE INDEX BY BINARY_INTEGER;
6234: TYPE l_olitem_description_type IS TABLE OF okc_k_lines_tl.item_description%TYPE INDEX BY BINARY_INTEGER;
6235: TYPE l_olblock23text_type IS TABLE OF okc_k_lines_tl.block23text%TYPE INDEX BY BINARY_INTEGER;
6236: TYPE l_olcreated_by_type IS TABLE OF okc_k_lines_tl.created_by%TYPE INDEX BY BINARY_INTEGER;
6237: TYPE l_olcreation_date_type IS TABLE OF okc_k_lines_tl.creation_date%TYPE INDEX BY BINARY_INTEGER;

Line 6234: TYPE l_olitem_description_type IS TABLE OF okc_k_lines_tl.item_description%TYPE INDEX BY BINARY_INTEGER;

6230: TYPE l_olsource_lang_type IS TABLE OF okc_k_lines_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;
6231: TYPE l_olsfwt_flag_type IS TABLE OF okc_k_lines_tl.sfwt_flag%TYPE INDEX BY BINARY_INTEGER;
6232: TYPE l_olname_type IS TABLE OF okc_k_lines_tl.name%TYPE INDEX BY BINARY_INTEGER;
6233: TYPE l_olcomments_type IS TABLE OF okc_k_lines_tl.comments%TYPE INDEX BY BINARY_INTEGER;
6234: TYPE l_olitem_description_type IS TABLE OF okc_k_lines_tl.item_description%TYPE INDEX BY BINARY_INTEGER;
6235: TYPE l_olblock23text_type IS TABLE OF okc_k_lines_tl.block23text%TYPE INDEX BY BINARY_INTEGER;
6236: TYPE l_olcreated_by_type IS TABLE OF okc_k_lines_tl.created_by%TYPE INDEX BY BINARY_INTEGER;
6237: TYPE l_olcreation_date_type IS TABLE OF okc_k_lines_tl.creation_date%TYPE INDEX BY BINARY_INTEGER;
6238: TYPE l_ollast_updated_by_type IS TABLE OF okc_k_lines_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;

Line 6235: TYPE l_olblock23text_type IS TABLE OF okc_k_lines_tl.block23text%TYPE INDEX BY BINARY_INTEGER;

6231: TYPE l_olsfwt_flag_type IS TABLE OF okc_k_lines_tl.sfwt_flag%TYPE INDEX BY BINARY_INTEGER;
6232: TYPE l_olname_type IS TABLE OF okc_k_lines_tl.name%TYPE INDEX BY BINARY_INTEGER;
6233: TYPE l_olcomments_type IS TABLE OF okc_k_lines_tl.comments%TYPE INDEX BY BINARY_INTEGER;
6234: TYPE l_olitem_description_type IS TABLE OF okc_k_lines_tl.item_description%TYPE INDEX BY BINARY_INTEGER;
6235: TYPE l_olblock23text_type IS TABLE OF okc_k_lines_tl.block23text%TYPE INDEX BY BINARY_INTEGER;
6236: TYPE l_olcreated_by_type IS TABLE OF okc_k_lines_tl.created_by%TYPE INDEX BY BINARY_INTEGER;
6237: TYPE l_olcreation_date_type IS TABLE OF okc_k_lines_tl.creation_date%TYPE INDEX BY BINARY_INTEGER;
6238: TYPE l_ollast_updated_by_type IS TABLE OF okc_k_lines_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
6239: TYPE l_ollast_update_date_type IS TABLE OF okc_k_lines_tl.last_update_date%TYPE INDEX BY BINARY_INTEGER;

Line 6236: TYPE l_olcreated_by_type IS TABLE OF okc_k_lines_tl.created_by%TYPE INDEX BY BINARY_INTEGER;

6232: TYPE l_olname_type IS TABLE OF okc_k_lines_tl.name%TYPE INDEX BY BINARY_INTEGER;
6233: TYPE l_olcomments_type IS TABLE OF okc_k_lines_tl.comments%TYPE INDEX BY BINARY_INTEGER;
6234: TYPE l_olitem_description_type IS TABLE OF okc_k_lines_tl.item_description%TYPE INDEX BY BINARY_INTEGER;
6235: TYPE l_olblock23text_type IS TABLE OF okc_k_lines_tl.block23text%TYPE INDEX BY BINARY_INTEGER;
6236: TYPE l_olcreated_by_type IS TABLE OF okc_k_lines_tl.created_by%TYPE INDEX BY BINARY_INTEGER;
6237: TYPE l_olcreation_date_type IS TABLE OF okc_k_lines_tl.creation_date%TYPE INDEX BY BINARY_INTEGER;
6238: TYPE l_ollast_updated_by_type IS TABLE OF okc_k_lines_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
6239: TYPE l_ollast_update_date_type IS TABLE OF okc_k_lines_tl.last_update_date%TYPE INDEX BY BINARY_INTEGER;
6240: TYPE l_ollast_update_login_type IS TABLE OF okc_k_lines_tl.last_update_login%TYPE INDEX BY BINARY_INTEGER;

Line 6237: TYPE l_olcreation_date_type IS TABLE OF okc_k_lines_tl.creation_date%TYPE INDEX BY BINARY_INTEGER;

6233: TYPE l_olcomments_type IS TABLE OF okc_k_lines_tl.comments%TYPE INDEX BY BINARY_INTEGER;
6234: TYPE l_olitem_description_type IS TABLE OF okc_k_lines_tl.item_description%TYPE INDEX BY BINARY_INTEGER;
6235: TYPE l_olblock23text_type IS TABLE OF okc_k_lines_tl.block23text%TYPE INDEX BY BINARY_INTEGER;
6236: TYPE l_olcreated_by_type IS TABLE OF okc_k_lines_tl.created_by%TYPE INDEX BY BINARY_INTEGER;
6237: TYPE l_olcreation_date_type IS TABLE OF okc_k_lines_tl.creation_date%TYPE INDEX BY BINARY_INTEGER;
6238: TYPE l_ollast_updated_by_type IS TABLE OF okc_k_lines_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
6239: TYPE l_ollast_update_date_type IS TABLE OF okc_k_lines_tl.last_update_date%TYPE INDEX BY BINARY_INTEGER;
6240: TYPE l_ollast_update_login_type IS TABLE OF okc_k_lines_tl.last_update_login%TYPE INDEX BY BINARY_INTEGER;
6241: TYPE l_olsecurity_group_id_type IS TABLE OF okc_k_lines_tl.security_group_id%TYPE INDEX BY BINARY_INTEGER;

Line 6238: TYPE l_ollast_updated_by_type IS TABLE OF okc_k_lines_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;

6234: TYPE l_olitem_description_type IS TABLE OF okc_k_lines_tl.item_description%TYPE INDEX BY BINARY_INTEGER;
6235: TYPE l_olblock23text_type IS TABLE OF okc_k_lines_tl.block23text%TYPE INDEX BY BINARY_INTEGER;
6236: TYPE l_olcreated_by_type IS TABLE OF okc_k_lines_tl.created_by%TYPE INDEX BY BINARY_INTEGER;
6237: TYPE l_olcreation_date_type IS TABLE OF okc_k_lines_tl.creation_date%TYPE INDEX BY BINARY_INTEGER;
6238: TYPE l_ollast_updated_by_type IS TABLE OF okc_k_lines_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
6239: TYPE l_ollast_update_date_type IS TABLE OF okc_k_lines_tl.last_update_date%TYPE INDEX BY BINARY_INTEGER;
6240: TYPE l_ollast_update_login_type IS TABLE OF okc_k_lines_tl.last_update_login%TYPE INDEX BY BINARY_INTEGER;
6241: TYPE l_olsecurity_group_id_type IS TABLE OF okc_k_lines_tl.security_group_id%TYPE INDEX BY BINARY_INTEGER;
6242: TYPE l_oloke_boe_description_type IS TABLE OF okc_k_lines_tl.oke_boe_description%TYPE INDEX BY BINARY_INTEGER;

Line 6239: TYPE l_ollast_update_date_type IS TABLE OF okc_k_lines_tl.last_update_date%TYPE INDEX BY BINARY_INTEGER;

6235: TYPE l_olblock23text_type IS TABLE OF okc_k_lines_tl.block23text%TYPE INDEX BY BINARY_INTEGER;
6236: TYPE l_olcreated_by_type IS TABLE OF okc_k_lines_tl.created_by%TYPE INDEX BY BINARY_INTEGER;
6237: TYPE l_olcreation_date_type IS TABLE OF okc_k_lines_tl.creation_date%TYPE INDEX BY BINARY_INTEGER;
6238: TYPE l_ollast_updated_by_type IS TABLE OF okc_k_lines_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
6239: TYPE l_ollast_update_date_type IS TABLE OF okc_k_lines_tl.last_update_date%TYPE INDEX BY BINARY_INTEGER;
6240: TYPE l_ollast_update_login_type IS TABLE OF okc_k_lines_tl.last_update_login%TYPE INDEX BY BINARY_INTEGER;
6241: TYPE l_olsecurity_group_id_type IS TABLE OF okc_k_lines_tl.security_group_id%TYPE INDEX BY BINARY_INTEGER;
6242: TYPE l_oloke_boe_description_type IS TABLE OF okc_k_lines_tl.oke_boe_description%TYPE INDEX BY BINARY_INTEGER;
6243: TYPE l_olcognomen_type IS TABLE OF okc_k_lines_tl.cognomen%TYPE INDEX BY BINARY_INTEGER;

Line 6240: TYPE l_ollast_update_login_type IS TABLE OF okc_k_lines_tl.last_update_login%TYPE INDEX BY BINARY_INTEGER;

6236: TYPE l_olcreated_by_type IS TABLE OF okc_k_lines_tl.created_by%TYPE INDEX BY BINARY_INTEGER;
6237: TYPE l_olcreation_date_type IS TABLE OF okc_k_lines_tl.creation_date%TYPE INDEX BY BINARY_INTEGER;
6238: TYPE l_ollast_updated_by_type IS TABLE OF okc_k_lines_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
6239: TYPE l_ollast_update_date_type IS TABLE OF okc_k_lines_tl.last_update_date%TYPE INDEX BY BINARY_INTEGER;
6240: TYPE l_ollast_update_login_type IS TABLE OF okc_k_lines_tl.last_update_login%TYPE INDEX BY BINARY_INTEGER;
6241: TYPE l_olsecurity_group_id_type IS TABLE OF okc_k_lines_tl.security_group_id%TYPE INDEX BY BINARY_INTEGER;
6242: TYPE l_oloke_boe_description_type IS TABLE OF okc_k_lines_tl.oke_boe_description%TYPE INDEX BY BINARY_INTEGER;
6243: TYPE l_olcognomen_type IS TABLE OF okc_k_lines_tl.cognomen%TYPE INDEX BY BINARY_INTEGER;
6244: -- For okc_k_lines_tl End

Line 6241: TYPE l_olsecurity_group_id_type IS TABLE OF okc_k_lines_tl.security_group_id%TYPE INDEX BY BINARY_INTEGER;

6237: TYPE l_olcreation_date_type IS TABLE OF okc_k_lines_tl.creation_date%TYPE INDEX BY BINARY_INTEGER;
6238: TYPE l_ollast_updated_by_type IS TABLE OF okc_k_lines_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
6239: TYPE l_ollast_update_date_type IS TABLE OF okc_k_lines_tl.last_update_date%TYPE INDEX BY BINARY_INTEGER;
6240: TYPE l_ollast_update_login_type IS TABLE OF okc_k_lines_tl.last_update_login%TYPE INDEX BY BINARY_INTEGER;
6241: TYPE l_olsecurity_group_id_type IS TABLE OF okc_k_lines_tl.security_group_id%TYPE INDEX BY BINARY_INTEGER;
6242: TYPE l_oloke_boe_description_type IS TABLE OF okc_k_lines_tl.oke_boe_description%TYPE INDEX BY BINARY_INTEGER;
6243: TYPE l_olcognomen_type IS TABLE OF okc_k_lines_tl.cognomen%TYPE INDEX BY BINARY_INTEGER;
6244: -- For okc_k_lines_tl End
6245:

Line 6242: TYPE l_oloke_boe_description_type IS TABLE OF okc_k_lines_tl.oke_boe_description%TYPE INDEX BY BINARY_INTEGER;

6238: TYPE l_ollast_updated_by_type IS TABLE OF okc_k_lines_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
6239: TYPE l_ollast_update_date_type IS TABLE OF okc_k_lines_tl.last_update_date%TYPE INDEX BY BINARY_INTEGER;
6240: TYPE l_ollast_update_login_type IS TABLE OF okc_k_lines_tl.last_update_login%TYPE INDEX BY BINARY_INTEGER;
6241: TYPE l_olsecurity_group_id_type IS TABLE OF okc_k_lines_tl.security_group_id%TYPE INDEX BY BINARY_INTEGER;
6242: TYPE l_oloke_boe_description_type IS TABLE OF okc_k_lines_tl.oke_boe_description%TYPE INDEX BY BINARY_INTEGER;
6243: TYPE l_olcognomen_type IS TABLE OF okc_k_lines_tl.cognomen%TYPE INDEX BY BINARY_INTEGER;
6244: -- For okc_k_lines_tl End
6245:
6246: -- okc_k_party_roles_b Begin

Line 6243: TYPE l_olcognomen_type IS TABLE OF okc_k_lines_tl.cognomen%TYPE INDEX BY BINARY_INTEGER;

6239: TYPE l_ollast_update_date_type IS TABLE OF okc_k_lines_tl.last_update_date%TYPE INDEX BY BINARY_INTEGER;
6240: TYPE l_ollast_update_login_type IS TABLE OF okc_k_lines_tl.last_update_login%TYPE INDEX BY BINARY_INTEGER;
6241: TYPE l_olsecurity_group_id_type IS TABLE OF okc_k_lines_tl.security_group_id%TYPE INDEX BY BINARY_INTEGER;
6242: TYPE l_oloke_boe_description_type IS TABLE OF okc_k_lines_tl.oke_boe_description%TYPE INDEX BY BINARY_INTEGER;
6243: TYPE l_olcognomen_type IS TABLE OF okc_k_lines_tl.cognomen%TYPE INDEX BY BINARY_INTEGER;
6244: -- For okc_k_lines_tl End
6245:
6246: -- okc_k_party_roles_b Begin
6247: TYPE l_prid_type IS TABLE OF okc_k_party_roles_b.id%TYPE INDEX BY BINARY_INTEGER;

Line 6244: -- For okc_k_lines_tl End

6240: TYPE l_ollast_update_login_type IS TABLE OF okc_k_lines_tl.last_update_login%TYPE INDEX BY BINARY_INTEGER;
6241: TYPE l_olsecurity_group_id_type IS TABLE OF okc_k_lines_tl.security_group_id%TYPE INDEX BY BINARY_INTEGER;
6242: TYPE l_oloke_boe_description_type IS TABLE OF okc_k_lines_tl.oke_boe_description%TYPE INDEX BY BINARY_INTEGER;
6243: TYPE l_olcognomen_type IS TABLE OF okc_k_lines_tl.cognomen%TYPE INDEX BY BINARY_INTEGER;
6244: -- For okc_k_lines_tl End
6245:
6246: -- okc_k_party_roles_b Begin
6247: TYPE l_prid_type IS TABLE OF okc_k_party_roles_b.id%TYPE INDEX BY BINARY_INTEGER;
6248: TYPE l_probject1_id1_type IS TABLE OF okc_k_party_roles_b.object1_id1%TYPE INDEX BY BINARY_INTEGER;

Line 6933: -- For okc_k_lines_tl Begin

6929: l_txl_itm_insts_counter2 NUMBER := 1;
6930:
6931: -- For okl_txl_itm_insts End
6932:
6933: -- For okc_k_lines_tl Begin
6934:
6935: l_olid_tab l_olid_type;
6936: l_ollanguage_tab l_ollanguage_type;
6937: l_olsource_lang_tab l_olsource_lang_type;

Line 6959: l_okc_k_lines_tl_counter NUMBER := 1;

6955: --avsingh: Bug 5710213: end
6956: l_olsts_code_tab l_sts_code_type;
6957: l_olfee_type_tab l_fee_type_type;
6958:
6959: l_okc_k_lines_tl_counter NUMBER := 1;
6960: -- For okc_k_lines_tl End
6961:
6962: -- For okl_party_payment_dtls Begin
6963:

Line 6960: -- For okc_k_lines_tl End

6956: l_olsts_code_tab l_sts_code_type;
6957: l_olfee_type_tab l_fee_type_type;
6958:
6959: l_okc_k_lines_tl_counter NUMBER := 1;
6960: -- For okc_k_lines_tl End
6961:
6962: -- For okl_party_payment_dtls Begin
6963:
6964: l_ppid_tab l_ppid_type;

Line 9000: PROCEDURE insert_okc_k_lines_tl(p_old_id IN okc_k_lines_b.id%TYPE) IS

8996: END LOOP;
8997: RETURN -1;
8998: END; /* find_mapping_id */
8999:
9000: PROCEDURE insert_okc_k_lines_tl(p_old_id IN okc_k_lines_b.id%TYPE) IS
9001: CURSOR c5(p_id NUMBER) IS
9002: SELECT
9003: a.id, a.LANGUAGE, a.source_lang,
9004: a.sfwt_flag, a.name, a.comments,

Line 9012: FROM okc_k_lines_tl a,

9008: a.cognomen, b.lse_id, b.sts_code, c.fee_type
9009: --avsingh: Bug 5710213: start
9010: , lsb.lty_code
9011: --avsingh: Bug 5710213: end
9012: FROM okc_k_lines_tl a,
9013: okc_k_lines_b b,
9014: okl_k_lines c,
9015: fnd_languages d
9016: --avsingh: Bug 5710213: start

Line 9038: FROM okc_k_lines_tl a,

9034: WHERE installed_flag IN ('B', 'I');
9035:
9036: CURSOR c7(p_id NUMBER) IS
9037: SELECT DISTINCT a.name
9038: FROM okc_k_lines_tl a,
9039: okc_k_lines_b b
9040: WHERE a.id = b.id
9041: AND b.dnz_chr_id = p_id
9042: -- gboomina Bug 6353660 - Start

Line 9105: l_olid_tab(l_okc_k_lines_tl_counter) := l_olid_tab2(i);

9101: --(l_olsts_code_tab2(i) = 'ABANDONED') or
9102: --(l_ollse_id_tab2(i) = 47) ) then
9103: --null;
9104: --else
9105: l_olid_tab(l_okc_k_lines_tl_counter) := l_olid_tab2(i);
9106: -- Change id
9107: l_new_id := find_mapping_id(l_olid_tab(l_okc_k_lines_tl_counter));
9108: --print('okc_k_lines_tl:l_new_id=' || l_new_id);
9109: l_olid_tab(l_okc_k_lines_tl_counter) := l_new_id;

Line 9107: l_new_id := find_mapping_id(l_olid_tab(l_okc_k_lines_tl_counter));

9103: --null;
9104: --else
9105: l_olid_tab(l_okc_k_lines_tl_counter) := l_olid_tab2(i);
9106: -- Change id
9107: l_new_id := find_mapping_id(l_olid_tab(l_okc_k_lines_tl_counter));
9108: --print('okc_k_lines_tl:l_new_id=' || l_new_id);
9109: l_olid_tab(l_okc_k_lines_tl_counter) := l_new_id;
9110:
9111: l_ollanguage_tab(l_okc_k_lines_tl_counter) := l_ollanguage_tab2(i);

Line 9108: --print('okc_k_lines_tl:l_new_id=' || l_new_id);

9104: --else
9105: l_olid_tab(l_okc_k_lines_tl_counter) := l_olid_tab2(i);
9106: -- Change id
9107: l_new_id := find_mapping_id(l_olid_tab(l_okc_k_lines_tl_counter));
9108: --print('okc_k_lines_tl:l_new_id=' || l_new_id);
9109: l_olid_tab(l_okc_k_lines_tl_counter) := l_new_id;
9110:
9111: l_ollanguage_tab(l_okc_k_lines_tl_counter) := l_ollanguage_tab2(i);
9112: l_olsource_lang_tab(l_okc_k_lines_tl_counter) := l_olsource_lang_tab2(i);

Line 9109: l_olid_tab(l_okc_k_lines_tl_counter) := l_new_id;

9105: l_olid_tab(l_okc_k_lines_tl_counter) := l_olid_tab2(i);
9106: -- Change id
9107: l_new_id := find_mapping_id(l_olid_tab(l_okc_k_lines_tl_counter));
9108: --print('okc_k_lines_tl:l_new_id=' || l_new_id);
9109: l_olid_tab(l_okc_k_lines_tl_counter) := l_new_id;
9110:
9111: l_ollanguage_tab(l_okc_k_lines_tl_counter) := l_ollanguage_tab2(i);
9112: l_olsource_lang_tab(l_okc_k_lines_tl_counter) := l_olsource_lang_tab2(i);
9113: l_olsfwt_flag_tab(l_okc_k_lines_tl_counter) := l_olsfwt_flag_tab2(i);

Line 9111: l_ollanguage_tab(l_okc_k_lines_tl_counter) := l_ollanguage_tab2(i);

9107: l_new_id := find_mapping_id(l_olid_tab(l_okc_k_lines_tl_counter));
9108: --print('okc_k_lines_tl:l_new_id=' || l_new_id);
9109: l_olid_tab(l_okc_k_lines_tl_counter) := l_new_id;
9110:
9111: l_ollanguage_tab(l_okc_k_lines_tl_counter) := l_ollanguage_tab2(i);
9112: l_olsource_lang_tab(l_okc_k_lines_tl_counter) := l_olsource_lang_tab2(i);
9113: l_olsfwt_flag_tab(l_okc_k_lines_tl_counter) := l_olsfwt_flag_tab2(i);
9114: l_olname_tab(l_okc_k_lines_tl_counter) := l_olname_tab2(i);
9115: l_olcomments_tab(l_okc_k_lines_tl_counter) := l_olcomments_tab2(i);

Line 9112: l_olsource_lang_tab(l_okc_k_lines_tl_counter) := l_olsource_lang_tab2(i);

9108: --print('okc_k_lines_tl:l_new_id=' || l_new_id);
9109: l_olid_tab(l_okc_k_lines_tl_counter) := l_new_id;
9110:
9111: l_ollanguage_tab(l_okc_k_lines_tl_counter) := l_ollanguage_tab2(i);
9112: l_olsource_lang_tab(l_okc_k_lines_tl_counter) := l_olsource_lang_tab2(i);
9113: l_olsfwt_flag_tab(l_okc_k_lines_tl_counter) := l_olsfwt_flag_tab2(i);
9114: l_olname_tab(l_okc_k_lines_tl_counter) := l_olname_tab2(i);
9115: l_olcomments_tab(l_okc_k_lines_tl_counter) := l_olcomments_tab2(i);
9116: l_olitem_description_tab(l_okc_k_lines_tl_counter) := l_olitem_description_tab2(i);

Line 9113: l_olsfwt_flag_tab(l_okc_k_lines_tl_counter) := l_olsfwt_flag_tab2(i);

9109: l_olid_tab(l_okc_k_lines_tl_counter) := l_new_id;
9110:
9111: l_ollanguage_tab(l_okc_k_lines_tl_counter) := l_ollanguage_tab2(i);
9112: l_olsource_lang_tab(l_okc_k_lines_tl_counter) := l_olsource_lang_tab2(i);
9113: l_olsfwt_flag_tab(l_okc_k_lines_tl_counter) := l_olsfwt_flag_tab2(i);
9114: l_olname_tab(l_okc_k_lines_tl_counter) := l_olname_tab2(i);
9115: l_olcomments_tab(l_okc_k_lines_tl_counter) := l_olcomments_tab2(i);
9116: l_olitem_description_tab(l_okc_k_lines_tl_counter) := l_olitem_description_tab2(i);
9117: l_olblock23text_tab(l_okc_k_lines_tl_counter) := l_olblock23text_tab2(i);

Line 9114: l_olname_tab(l_okc_k_lines_tl_counter) := l_olname_tab2(i);

9110:
9111: l_ollanguage_tab(l_okc_k_lines_tl_counter) := l_ollanguage_tab2(i);
9112: l_olsource_lang_tab(l_okc_k_lines_tl_counter) := l_olsource_lang_tab2(i);
9113: l_olsfwt_flag_tab(l_okc_k_lines_tl_counter) := l_olsfwt_flag_tab2(i);
9114: l_olname_tab(l_okc_k_lines_tl_counter) := l_olname_tab2(i);
9115: l_olcomments_tab(l_okc_k_lines_tl_counter) := l_olcomments_tab2(i);
9116: l_olitem_description_tab(l_okc_k_lines_tl_counter) := l_olitem_description_tab2(i);
9117: l_olblock23text_tab(l_okc_k_lines_tl_counter) := l_olblock23text_tab2(i);
9118: l_olcreated_by_tab(l_okc_k_lines_tl_counter) := l_olcreated_by_tab2(i);

Line 9115: l_olcomments_tab(l_okc_k_lines_tl_counter) := l_olcomments_tab2(i);

9111: l_ollanguage_tab(l_okc_k_lines_tl_counter) := l_ollanguage_tab2(i);
9112: l_olsource_lang_tab(l_okc_k_lines_tl_counter) := l_olsource_lang_tab2(i);
9113: l_olsfwt_flag_tab(l_okc_k_lines_tl_counter) := l_olsfwt_flag_tab2(i);
9114: l_olname_tab(l_okc_k_lines_tl_counter) := l_olname_tab2(i);
9115: l_olcomments_tab(l_okc_k_lines_tl_counter) := l_olcomments_tab2(i);
9116: l_olitem_description_tab(l_okc_k_lines_tl_counter) := l_olitem_description_tab2(i);
9117: l_olblock23text_tab(l_okc_k_lines_tl_counter) := l_olblock23text_tab2(i);
9118: l_olcreated_by_tab(l_okc_k_lines_tl_counter) := l_olcreated_by_tab2(i);
9119: l_olcreation_date_tab(l_okc_k_lines_tl_counter) := l_olcreation_date_tab2(i);

Line 9116: l_olitem_description_tab(l_okc_k_lines_tl_counter) := l_olitem_description_tab2(i);

9112: l_olsource_lang_tab(l_okc_k_lines_tl_counter) := l_olsource_lang_tab2(i);
9113: l_olsfwt_flag_tab(l_okc_k_lines_tl_counter) := l_olsfwt_flag_tab2(i);
9114: l_olname_tab(l_okc_k_lines_tl_counter) := l_olname_tab2(i);
9115: l_olcomments_tab(l_okc_k_lines_tl_counter) := l_olcomments_tab2(i);
9116: l_olitem_description_tab(l_okc_k_lines_tl_counter) := l_olitem_description_tab2(i);
9117: l_olblock23text_tab(l_okc_k_lines_tl_counter) := l_olblock23text_tab2(i);
9118: l_olcreated_by_tab(l_okc_k_lines_tl_counter) := l_olcreated_by_tab2(i);
9119: l_olcreation_date_tab(l_okc_k_lines_tl_counter) := l_olcreation_date_tab2(i);
9120: l_ollast_updated_by_tab(l_okc_k_lines_tl_counter) := l_ollast_updated_by_tab2(i);

Line 9117: l_olblock23text_tab(l_okc_k_lines_tl_counter) := l_olblock23text_tab2(i);

9113: l_olsfwt_flag_tab(l_okc_k_lines_tl_counter) := l_olsfwt_flag_tab2(i);
9114: l_olname_tab(l_okc_k_lines_tl_counter) := l_olname_tab2(i);
9115: l_olcomments_tab(l_okc_k_lines_tl_counter) := l_olcomments_tab2(i);
9116: l_olitem_description_tab(l_okc_k_lines_tl_counter) := l_olitem_description_tab2(i);
9117: l_olblock23text_tab(l_okc_k_lines_tl_counter) := l_olblock23text_tab2(i);
9118: l_olcreated_by_tab(l_okc_k_lines_tl_counter) := l_olcreated_by_tab2(i);
9119: l_olcreation_date_tab(l_okc_k_lines_tl_counter) := l_olcreation_date_tab2(i);
9120: l_ollast_updated_by_tab(l_okc_k_lines_tl_counter) := l_ollast_updated_by_tab2(i);
9121: l_ollast_update_date_tab(l_okc_k_lines_tl_counter) := l_ollast_update_date_tab2(i);

Line 9118: l_olcreated_by_tab(l_okc_k_lines_tl_counter) := l_olcreated_by_tab2(i);

9114: l_olname_tab(l_okc_k_lines_tl_counter) := l_olname_tab2(i);
9115: l_olcomments_tab(l_okc_k_lines_tl_counter) := l_olcomments_tab2(i);
9116: l_olitem_description_tab(l_okc_k_lines_tl_counter) := l_olitem_description_tab2(i);
9117: l_olblock23text_tab(l_okc_k_lines_tl_counter) := l_olblock23text_tab2(i);
9118: l_olcreated_by_tab(l_okc_k_lines_tl_counter) := l_olcreated_by_tab2(i);
9119: l_olcreation_date_tab(l_okc_k_lines_tl_counter) := l_olcreation_date_tab2(i);
9120: l_ollast_updated_by_tab(l_okc_k_lines_tl_counter) := l_ollast_updated_by_tab2(i);
9121: l_ollast_update_date_tab(l_okc_k_lines_tl_counter) := l_ollast_update_date_tab2(i);
9122: l_ollast_update_login_tab(l_okc_k_lines_tl_counter) := l_ollast_update_login_tab2(i);

Line 9119: l_olcreation_date_tab(l_okc_k_lines_tl_counter) := l_olcreation_date_tab2(i);

9115: l_olcomments_tab(l_okc_k_lines_tl_counter) := l_olcomments_tab2(i);
9116: l_olitem_description_tab(l_okc_k_lines_tl_counter) := l_olitem_description_tab2(i);
9117: l_olblock23text_tab(l_okc_k_lines_tl_counter) := l_olblock23text_tab2(i);
9118: l_olcreated_by_tab(l_okc_k_lines_tl_counter) := l_olcreated_by_tab2(i);
9119: l_olcreation_date_tab(l_okc_k_lines_tl_counter) := l_olcreation_date_tab2(i);
9120: l_ollast_updated_by_tab(l_okc_k_lines_tl_counter) := l_ollast_updated_by_tab2(i);
9121: l_ollast_update_date_tab(l_okc_k_lines_tl_counter) := l_ollast_update_date_tab2(i);
9122: l_ollast_update_login_tab(l_okc_k_lines_tl_counter) := l_ollast_update_login_tab2(i);
9123: l_olsecurity_group_id_tab(l_okc_k_lines_tl_counter) := l_olsecurity_group_id_tab2(i);

Line 9120: l_ollast_updated_by_tab(l_okc_k_lines_tl_counter) := l_ollast_updated_by_tab2(i);

9116: l_olitem_description_tab(l_okc_k_lines_tl_counter) := l_olitem_description_tab2(i);
9117: l_olblock23text_tab(l_okc_k_lines_tl_counter) := l_olblock23text_tab2(i);
9118: l_olcreated_by_tab(l_okc_k_lines_tl_counter) := l_olcreated_by_tab2(i);
9119: l_olcreation_date_tab(l_okc_k_lines_tl_counter) := l_olcreation_date_tab2(i);
9120: l_ollast_updated_by_tab(l_okc_k_lines_tl_counter) := l_ollast_updated_by_tab2(i);
9121: l_ollast_update_date_tab(l_okc_k_lines_tl_counter) := l_ollast_update_date_tab2(i);
9122: l_ollast_update_login_tab(l_okc_k_lines_tl_counter) := l_ollast_update_login_tab2(i);
9123: l_olsecurity_group_id_tab(l_okc_k_lines_tl_counter) := l_olsecurity_group_id_tab2(i);
9124: l_oloke_boe_description_tab(l_okc_k_lines_tl_counter) := l_oloke_boe_description_tab2(i);

Line 9121: l_ollast_update_date_tab(l_okc_k_lines_tl_counter) := l_ollast_update_date_tab2(i);

9117: l_olblock23text_tab(l_okc_k_lines_tl_counter) := l_olblock23text_tab2(i);
9118: l_olcreated_by_tab(l_okc_k_lines_tl_counter) := l_olcreated_by_tab2(i);
9119: l_olcreation_date_tab(l_okc_k_lines_tl_counter) := l_olcreation_date_tab2(i);
9120: l_ollast_updated_by_tab(l_okc_k_lines_tl_counter) := l_ollast_updated_by_tab2(i);
9121: l_ollast_update_date_tab(l_okc_k_lines_tl_counter) := l_ollast_update_date_tab2(i);
9122: l_ollast_update_login_tab(l_okc_k_lines_tl_counter) := l_ollast_update_login_tab2(i);
9123: l_olsecurity_group_id_tab(l_okc_k_lines_tl_counter) := l_olsecurity_group_id_tab2(i);
9124: l_oloke_boe_description_tab(l_okc_k_lines_tl_counter) := l_oloke_boe_description_tab2(i);
9125: l_olcognomen_tab(l_okc_k_lines_tl_counter) := l_olcognomen_tab2(i);

Line 9122: l_ollast_update_login_tab(l_okc_k_lines_tl_counter) := l_ollast_update_login_tab2(i);

9118: l_olcreated_by_tab(l_okc_k_lines_tl_counter) := l_olcreated_by_tab2(i);
9119: l_olcreation_date_tab(l_okc_k_lines_tl_counter) := l_olcreation_date_tab2(i);
9120: l_ollast_updated_by_tab(l_okc_k_lines_tl_counter) := l_ollast_updated_by_tab2(i);
9121: l_ollast_update_date_tab(l_okc_k_lines_tl_counter) := l_ollast_update_date_tab2(i);
9122: l_ollast_update_login_tab(l_okc_k_lines_tl_counter) := l_ollast_update_login_tab2(i);
9123: l_olsecurity_group_id_tab(l_okc_k_lines_tl_counter) := l_olsecurity_group_id_tab2(i);
9124: l_oloke_boe_description_tab(l_okc_k_lines_tl_counter) := l_oloke_boe_description_tab2(i);
9125: l_olcognomen_tab(l_okc_k_lines_tl_counter) := l_olcognomen_tab2(i);
9126:

Line 9123: l_olsecurity_group_id_tab(l_okc_k_lines_tl_counter) := l_olsecurity_group_id_tab2(i);

9119: l_olcreation_date_tab(l_okc_k_lines_tl_counter) := l_olcreation_date_tab2(i);
9120: l_ollast_updated_by_tab(l_okc_k_lines_tl_counter) := l_ollast_updated_by_tab2(i);
9121: l_ollast_update_date_tab(l_okc_k_lines_tl_counter) := l_ollast_update_date_tab2(i);
9122: l_ollast_update_login_tab(l_okc_k_lines_tl_counter) := l_ollast_update_login_tab2(i);
9123: l_olsecurity_group_id_tab(l_okc_k_lines_tl_counter) := l_olsecurity_group_id_tab2(i);
9124: l_oloke_boe_description_tab(l_okc_k_lines_tl_counter) := l_oloke_boe_description_tab2(i);
9125: l_olcognomen_tab(l_okc_k_lines_tl_counter) := l_olcognomen_tab2(i);
9126:
9127: l_ollse_id_tab(l_okc_k_lines_tl_counter) := l_ollse_id_tab2(i);

Line 9124: l_oloke_boe_description_tab(l_okc_k_lines_tl_counter) := l_oloke_boe_description_tab2(i);

9120: l_ollast_updated_by_tab(l_okc_k_lines_tl_counter) := l_ollast_updated_by_tab2(i);
9121: l_ollast_update_date_tab(l_okc_k_lines_tl_counter) := l_ollast_update_date_tab2(i);
9122: l_ollast_update_login_tab(l_okc_k_lines_tl_counter) := l_ollast_update_login_tab2(i);
9123: l_olsecurity_group_id_tab(l_okc_k_lines_tl_counter) := l_olsecurity_group_id_tab2(i);
9124: l_oloke_boe_description_tab(l_okc_k_lines_tl_counter) := l_oloke_boe_description_tab2(i);
9125: l_olcognomen_tab(l_okc_k_lines_tl_counter) := l_olcognomen_tab2(i);
9126:
9127: l_ollse_id_tab(l_okc_k_lines_tl_counter) := l_ollse_id_tab2(i);
9128: --avsingh: Bug 5710213: start

Line 9125: l_olcognomen_tab(l_okc_k_lines_tl_counter) := l_olcognomen_tab2(i);

9121: l_ollast_update_date_tab(l_okc_k_lines_tl_counter) := l_ollast_update_date_tab2(i);
9122: l_ollast_update_login_tab(l_okc_k_lines_tl_counter) := l_ollast_update_login_tab2(i);
9123: l_olsecurity_group_id_tab(l_okc_k_lines_tl_counter) := l_olsecurity_group_id_tab2(i);
9124: l_oloke_boe_description_tab(l_okc_k_lines_tl_counter) := l_oloke_boe_description_tab2(i);
9125: l_olcognomen_tab(l_okc_k_lines_tl_counter) := l_olcognomen_tab2(i);
9126:
9127: l_ollse_id_tab(l_okc_k_lines_tl_counter) := l_ollse_id_tab2(i);
9128: --avsingh: Bug 5710213: start
9129: l_ollty_code_tab(l_okc_k_lines_tl_counter) := l_ollty_code_tab2(i);

Line 9127: l_ollse_id_tab(l_okc_k_lines_tl_counter) := l_ollse_id_tab2(i);

9123: l_olsecurity_group_id_tab(l_okc_k_lines_tl_counter) := l_olsecurity_group_id_tab2(i);
9124: l_oloke_boe_description_tab(l_okc_k_lines_tl_counter) := l_oloke_boe_description_tab2(i);
9125: l_olcognomen_tab(l_okc_k_lines_tl_counter) := l_olcognomen_tab2(i);
9126:
9127: l_ollse_id_tab(l_okc_k_lines_tl_counter) := l_ollse_id_tab2(i);
9128: --avsingh: Bug 5710213: start
9129: l_ollty_code_tab(l_okc_k_lines_tl_counter) := l_ollty_code_tab2(i);
9130: --avsingh: Bug 5710213: end
9131: l_olsts_code_tab(l_okc_k_lines_tl_counter) := l_olsts_code_tab2(i);

Line 9129: l_ollty_code_tab(l_okc_k_lines_tl_counter) := l_ollty_code_tab2(i);

9125: l_olcognomen_tab(l_okc_k_lines_tl_counter) := l_olcognomen_tab2(i);
9126:
9127: l_ollse_id_tab(l_okc_k_lines_tl_counter) := l_ollse_id_tab2(i);
9128: --avsingh: Bug 5710213: start
9129: l_ollty_code_tab(l_okc_k_lines_tl_counter) := l_ollty_code_tab2(i);
9130: --avsingh: Bug 5710213: end
9131: l_olsts_code_tab(l_okc_k_lines_tl_counter) := l_olsts_code_tab2(i);
9132: l_olfee_type_tab(l_okc_k_lines_tl_counter) := l_olfee_type_tab2(i);
9133:

Line 9131: l_olsts_code_tab(l_okc_k_lines_tl_counter) := l_olsts_code_tab2(i);

9127: l_ollse_id_tab(l_okc_k_lines_tl_counter) := l_ollse_id_tab2(i);
9128: --avsingh: Bug 5710213: start
9129: l_ollty_code_tab(l_okc_k_lines_tl_counter) := l_ollty_code_tab2(i);
9130: --avsingh: Bug 5710213: end
9131: l_olsts_code_tab(l_okc_k_lines_tl_counter) := l_olsts_code_tab2(i);
9132: l_olfee_type_tab(l_okc_k_lines_tl_counter) := l_olfee_type_tab2(i);
9133:
9134: l_okc_k_lines_tl_counter := l_okc_k_lines_tl_counter + 1;
9135:

Line 9132: l_olfee_type_tab(l_okc_k_lines_tl_counter) := l_olfee_type_tab2(i);

9128: --avsingh: Bug 5710213: start
9129: l_ollty_code_tab(l_okc_k_lines_tl_counter) := l_ollty_code_tab2(i);
9130: --avsingh: Bug 5710213: end
9131: l_olsts_code_tab(l_okc_k_lines_tl_counter) := l_olsts_code_tab2(i);
9132: l_olfee_type_tab(l_okc_k_lines_tl_counter) := l_olfee_type_tab2(i);
9133:
9134: l_okc_k_lines_tl_counter := l_okc_k_lines_tl_counter + 1;
9135:
9136: --end if;

Line 9134: l_okc_k_lines_tl_counter := l_okc_k_lines_tl_counter + 1;

9130: --avsingh: Bug 5710213: end
9131: l_olsts_code_tab(l_okc_k_lines_tl_counter) := l_olsts_code_tab2(i);
9132: l_olfee_type_tab(l_okc_k_lines_tl_counter) := l_olfee_type_tab2(i);
9133:
9134: l_okc_k_lines_tl_counter := l_okc_k_lines_tl_counter + 1;
9135:
9136: --end if;
9137: END LOOP;
9138: END LOOP;

Line 9141: IF (l_okc_k_lines_tl_counter < 2) THEN

9137: END LOOP;
9138: END LOOP;
9139: CLOSE c5;
9140:
9141: IF (l_okc_k_lines_tl_counter < 2) THEN
9142: RETURN;
9143: END IF;
9144:
9145: --print('Opening c7 with p_old_id=' || p_old_id);

Line 9173: print('Printing insert_okc_k_lines_tl:l_olid_tab ...');

9169: CLOSE c7;
9170: sort_aid_mapping_tab;
9171: /* Debug only */
9172: /*
9173: print('Printing insert_okc_k_lines_tl:l_olid_tab ...');
9174: for i in l_olid_tab.first..l_olid_tab.last
9175: loop
9176: print('l_olid_tab('||i||')=' || l_olid_tab(i));
9177: print('l_olfee_type_tab('||i||')=' || l_olfee_type_tab(i));

Line 9209: IF (l_okc_k_lines_tl_counter > 1) THEN

9205: END IF;
9206: END LOOP;
9207: END IF;
9208:
9209: IF (l_okc_k_lines_tl_counter > 1) THEN
9210: FOR r IN c6
9211: LOOP
9212: --print('r.language_code=' || r.language_code);
9213: forall i IN l_olid_tab.first..l_olid_tab.last

Line 9214: INSERT INTO okc_k_lines_tl (

9210: FOR r IN c6
9211: LOOP
9212: --print('r.language_code=' || r.language_code);
9213: forall i IN l_olid_tab.first..l_olid_tab.last
9214: INSERT INTO okc_k_lines_tl (
9215: id, LANGUAGE, source_lang,
9216: sfwt_flag, name, comments,
9217: item_description, block23text, created_by,
9218: creation_date, last_updated_by, last_update_date,

Line 9238: p_token1_value => 'insert_okc_k_lines_tl');*/

9234: x_return_status := OKL_API.G_RET_STS_ERROR;
9235: /*OKL_API.set_message(p_app_name => 'OKL',
9236: p_msg_name => 'OKL_AM_NO_OLD_SALVAGE_VALUE',
9237: p_token1 => 'ASSET_NUMBER',
9238: p_token1_value => 'insert_okc_k_lines_tl');*/
9239: /* DEBUG */
9240: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
9241: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'sqlcode=' || SQLCODE || ':sqlerrm=' || SQLERRM);
9242: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Printing insert_okc_k_lines_tl:l_olid_tab.count=' || l_olid_tab.COUNT || ' ...');

Line 9242: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Printing insert_okc_k_lines_tl:l_olid_tab.count=' || l_olid_tab.COUNT || ' ...');

9238: p_token1_value => 'insert_okc_k_lines_tl');*/
9239: /* DEBUG */
9240: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
9241: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'sqlcode=' || SQLCODE || ':sqlerrm=' || SQLERRM);
9242: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Printing insert_okc_k_lines_tl:l_olid_tab.count=' || l_olid_tab.COUNT || ' ...');
9243: END IF;
9244: IF (l_olid_tab.COUNT > 0) THEN
9245: FOR i IN l_olid_tab.first..l_olid_tab.last
9246: LOOP

Line 9264: END; /* insert okc_k_lines_tl */

9260:
9261:
9262: RAISE OKC_API.G_EXCEPTION_ERROR;
9263:
9264: END; /* insert okc_k_lines_tl */
9265:
9266: PROCEDURE insert_okc_k_lines_tl_old(p_old_id IN okc_k_lines_b.id%TYPE,
9267: p_new_id IN okc_k_lines_b.id%TYPE,
9268: p_flush IN VARCHAR2 ) IS

Line 9266: PROCEDURE insert_okc_k_lines_tl_old(p_old_id IN okc_k_lines_b.id%TYPE,

9262: RAISE OKC_API.G_EXCEPTION_ERROR;
9263:
9264: END; /* insert okc_k_lines_tl */
9265:
9266: PROCEDURE insert_okc_k_lines_tl_old(p_old_id IN okc_k_lines_b.id%TYPE,
9267: p_new_id IN okc_k_lines_b.id%TYPE,
9268: p_flush IN VARCHAR2 ) IS
9269: CURSOR c5(p_id okc_k_lines_b.id%TYPE) IS
9270: SELECT

Line 9277: FROM okc_k_lines_tl a,

9273: a.item_description, a.block23text, a.created_by,
9274: a.creation_date, a.last_updated_by, a.last_update_date,
9275: a.last_update_login, a.security_group_id, a.oke_boe_description,
9276: a.cognomen, b.lse_id
9277: FROM okc_k_lines_tl a,
9278: okc_k_lines_b b
9279: WHERE a.id = p_id
9280: AND a.id = b.id;
9281:

Line 9324: l_olid_tab(l_okc_k_lines_tl_counter) := l_olid_tab2(i);

9320: --print('okc_k_lines_tab:l_id_tab.count='||l_id_tab.count);
9321: FOR i IN l_olid_tab2.first..l_olid_tab2.last LOOP
9322: -- Change id
9323: l_olid_tab2(i) := p_new_id;
9324: l_olid_tab(l_okc_k_lines_tl_counter) := l_olid_tab2(i);
9325:
9326: l_ollanguage_tab(l_okc_k_lines_tl_counter) := l_ollanguage_tab2(i);
9327: l_olsource_lang_tab(l_okc_k_lines_tl_counter) := l_olsource_lang_tab2(i);
9328: l_olsfwt_flag_tab(l_okc_k_lines_tl_counter) := l_olsfwt_flag_tab2(i);

Line 9326: l_ollanguage_tab(l_okc_k_lines_tl_counter) := l_ollanguage_tab2(i);

9322: -- Change id
9323: l_olid_tab2(i) := p_new_id;
9324: l_olid_tab(l_okc_k_lines_tl_counter) := l_olid_tab2(i);
9325:
9326: l_ollanguage_tab(l_okc_k_lines_tl_counter) := l_ollanguage_tab2(i);
9327: l_olsource_lang_tab(l_okc_k_lines_tl_counter) := l_olsource_lang_tab2(i);
9328: l_olsfwt_flag_tab(l_okc_k_lines_tl_counter) := l_olsfwt_flag_tab2(i);
9329: l_olname_tab(l_okc_k_lines_tl_counter) := l_olname_tab2(i);
9330:

Line 9327: l_olsource_lang_tab(l_okc_k_lines_tl_counter) := l_olsource_lang_tab2(i);

9323: l_olid_tab2(i) := p_new_id;
9324: l_olid_tab(l_okc_k_lines_tl_counter) := l_olid_tab2(i);
9325:
9326: l_ollanguage_tab(l_okc_k_lines_tl_counter) := l_ollanguage_tab2(i);
9327: l_olsource_lang_tab(l_okc_k_lines_tl_counter) := l_olsource_lang_tab2(i);
9328: l_olsfwt_flag_tab(l_okc_k_lines_tl_counter) := l_olsfwt_flag_tab2(i);
9329: l_olname_tab(l_okc_k_lines_tl_counter) := l_olname_tab2(i);
9330:
9331: /* AKP - to do: Put okl_copy_asset_pvt.generate_asset_number as public api

Line 9328: l_olsfwt_flag_tab(l_okc_k_lines_tl_counter) := l_olsfwt_flag_tab2(i);

9324: l_olid_tab(l_okc_k_lines_tl_counter) := l_olid_tab2(i);
9325:
9326: l_ollanguage_tab(l_okc_k_lines_tl_counter) := l_ollanguage_tab2(i);
9327: l_olsource_lang_tab(l_okc_k_lines_tl_counter) := l_olsource_lang_tab2(i);
9328: l_olsfwt_flag_tab(l_okc_k_lines_tl_counter) := l_olsfwt_flag_tab2(i);
9329: l_olname_tab(l_okc_k_lines_tl_counter) := l_olname_tab2(i);
9330:
9331: /* AKP - to do: Put okl_copy_asset_pvt.generate_asset_number as public api
9332: Call okl_copy_asset_pvt.generate_asset_number instead of local procedure */

Line 9329: l_olname_tab(l_okc_k_lines_tl_counter) := l_olname_tab2(i);

9325:
9326: l_ollanguage_tab(l_okc_k_lines_tl_counter) := l_ollanguage_tab2(i);
9327: l_olsource_lang_tab(l_okc_k_lines_tl_counter) := l_olsource_lang_tab2(i);
9328: l_olsfwt_flag_tab(l_okc_k_lines_tl_counter) := l_olsfwt_flag_tab2(i);
9329: l_olname_tab(l_okc_k_lines_tl_counter) := l_olname_tab2(i);
9330:
9331: /* AKP - to do: Put okl_copy_asset_pvt.generate_asset_number as public api
9332: Call okl_copy_asset_pvt.generate_asset_number instead of local procedure */
9333: IF (p_trans_type NOT IN ('CRB','CRL','CSP','CRV','ALI') AND

Line 9339: l_new_asset_name := find_aid_mapping_id(l_olname_tab(l_okc_k_lines_tl_counter));

9335: -- Generate asset_number
9336: --l_ret_status := okl_copy_asset_pvt.generate_asset_number(
9337: IF (NOT(l_done_generating)) THEN
9338: IF (l_asset_counter > 1) THEN
9339: l_new_asset_name := find_aid_mapping_id(l_olname_tab(l_okc_k_lines_tl_counter));
9340: IF (l_new_asset_name = '-1') THEN
9341: l_ret_status := generate_asset_number(
9342: l_new_asset_name
9343: );

Line 9362: l_old_asset_name := l_olname_tab(l_okc_k_lines_tl_counter);

9358: END IF;
9359: END IF;
9360: l_done_generating := TRUE;
9361: END IF;
9362: l_old_asset_name := l_olname_tab(l_okc_k_lines_tl_counter);
9363: l_olname_tab(l_okc_k_lines_tl_counter) := l_new_asset_name;
9364: --print('Old Asset=' || l_old_asset_name);
9365: --print('New Asset=' || l_new_asset_name);
9366:

Line 9363: l_olname_tab(l_okc_k_lines_tl_counter) := l_new_asset_name;

9359: END IF;
9360: l_done_generating := TRUE;
9361: END IF;
9362: l_old_asset_name := l_olname_tab(l_okc_k_lines_tl_counter);
9363: l_olname_tab(l_okc_k_lines_tl_counter) := l_new_asset_name;
9364: --print('Old Asset=' || l_old_asset_name);
9365: --print('New Asset=' || l_new_asset_name);
9366:
9367: -- Store line id to asset_number mapping

Line 9378: l_olcomments_tab(l_okc_k_lines_tl_counter) := l_olcomments_tab2(i);

9374:
9375: IF (l_asset_counter > 1) THEN
9376: sort_aid_mapping_tab;
9377: END IF;
9378: l_olcomments_tab(l_okc_k_lines_tl_counter) := l_olcomments_tab2(i);
9379: l_olitem_description_tab(l_okc_k_lines_tl_counter) := l_olitem_description_tab2(i);
9380: l_olblock23text_tab(l_okc_k_lines_tl_counter) := l_olblock23text_tab2(i);
9381: l_olcreated_by_tab(l_okc_k_lines_tl_counter) := l_olcreated_by_tab2(i);
9382: l_olcreation_date_tab(l_okc_k_lines_tl_counter) := l_olcreation_date_tab2(i);

Line 9379: l_olitem_description_tab(l_okc_k_lines_tl_counter) := l_olitem_description_tab2(i);

9375: IF (l_asset_counter > 1) THEN
9376: sort_aid_mapping_tab;
9377: END IF;
9378: l_olcomments_tab(l_okc_k_lines_tl_counter) := l_olcomments_tab2(i);
9379: l_olitem_description_tab(l_okc_k_lines_tl_counter) := l_olitem_description_tab2(i);
9380: l_olblock23text_tab(l_okc_k_lines_tl_counter) := l_olblock23text_tab2(i);
9381: l_olcreated_by_tab(l_okc_k_lines_tl_counter) := l_olcreated_by_tab2(i);
9382: l_olcreation_date_tab(l_okc_k_lines_tl_counter) := l_olcreation_date_tab2(i);
9383: l_ollast_updated_by_tab(l_okc_k_lines_tl_counter) := l_ollast_updated_by_tab2(i);

Line 9380: l_olblock23text_tab(l_okc_k_lines_tl_counter) := l_olblock23text_tab2(i);

9376: sort_aid_mapping_tab;
9377: END IF;
9378: l_olcomments_tab(l_okc_k_lines_tl_counter) := l_olcomments_tab2(i);
9379: l_olitem_description_tab(l_okc_k_lines_tl_counter) := l_olitem_description_tab2(i);
9380: l_olblock23text_tab(l_okc_k_lines_tl_counter) := l_olblock23text_tab2(i);
9381: l_olcreated_by_tab(l_okc_k_lines_tl_counter) := l_olcreated_by_tab2(i);
9382: l_olcreation_date_tab(l_okc_k_lines_tl_counter) := l_olcreation_date_tab2(i);
9383: l_ollast_updated_by_tab(l_okc_k_lines_tl_counter) := l_ollast_updated_by_tab2(i);
9384: l_ollast_update_date_tab(l_okc_k_lines_tl_counter) := l_ollast_update_date_tab2(i);

Line 9381: l_olcreated_by_tab(l_okc_k_lines_tl_counter) := l_olcreated_by_tab2(i);

9377: END IF;
9378: l_olcomments_tab(l_okc_k_lines_tl_counter) := l_olcomments_tab2(i);
9379: l_olitem_description_tab(l_okc_k_lines_tl_counter) := l_olitem_description_tab2(i);
9380: l_olblock23text_tab(l_okc_k_lines_tl_counter) := l_olblock23text_tab2(i);
9381: l_olcreated_by_tab(l_okc_k_lines_tl_counter) := l_olcreated_by_tab2(i);
9382: l_olcreation_date_tab(l_okc_k_lines_tl_counter) := l_olcreation_date_tab2(i);
9383: l_ollast_updated_by_tab(l_okc_k_lines_tl_counter) := l_ollast_updated_by_tab2(i);
9384: l_ollast_update_date_tab(l_okc_k_lines_tl_counter) := l_ollast_update_date_tab2(i);
9385: l_ollast_update_login_tab(l_okc_k_lines_tl_counter) := l_ollast_update_login_tab2(i);

Line 9382: l_olcreation_date_tab(l_okc_k_lines_tl_counter) := l_olcreation_date_tab2(i);

9378: l_olcomments_tab(l_okc_k_lines_tl_counter) := l_olcomments_tab2(i);
9379: l_olitem_description_tab(l_okc_k_lines_tl_counter) := l_olitem_description_tab2(i);
9380: l_olblock23text_tab(l_okc_k_lines_tl_counter) := l_olblock23text_tab2(i);
9381: l_olcreated_by_tab(l_okc_k_lines_tl_counter) := l_olcreated_by_tab2(i);
9382: l_olcreation_date_tab(l_okc_k_lines_tl_counter) := l_olcreation_date_tab2(i);
9383: l_ollast_updated_by_tab(l_okc_k_lines_tl_counter) := l_ollast_updated_by_tab2(i);
9384: l_ollast_update_date_tab(l_okc_k_lines_tl_counter) := l_ollast_update_date_tab2(i);
9385: l_ollast_update_login_tab(l_okc_k_lines_tl_counter) := l_ollast_update_login_tab2(i);
9386: l_olsecurity_group_id_tab(l_okc_k_lines_tl_counter) := l_olsecurity_group_id_tab2(i);

Line 9383: l_ollast_updated_by_tab(l_okc_k_lines_tl_counter) := l_ollast_updated_by_tab2(i);

9379: l_olitem_description_tab(l_okc_k_lines_tl_counter) := l_olitem_description_tab2(i);
9380: l_olblock23text_tab(l_okc_k_lines_tl_counter) := l_olblock23text_tab2(i);
9381: l_olcreated_by_tab(l_okc_k_lines_tl_counter) := l_olcreated_by_tab2(i);
9382: l_olcreation_date_tab(l_okc_k_lines_tl_counter) := l_olcreation_date_tab2(i);
9383: l_ollast_updated_by_tab(l_okc_k_lines_tl_counter) := l_ollast_updated_by_tab2(i);
9384: l_ollast_update_date_tab(l_okc_k_lines_tl_counter) := l_ollast_update_date_tab2(i);
9385: l_ollast_update_login_tab(l_okc_k_lines_tl_counter) := l_ollast_update_login_tab2(i);
9386: l_olsecurity_group_id_tab(l_okc_k_lines_tl_counter) := l_olsecurity_group_id_tab2(i);
9387: l_oloke_boe_description_tab(l_okc_k_lines_tl_counter) := l_oloke_boe_description_tab2(i);

Line 9384: l_ollast_update_date_tab(l_okc_k_lines_tl_counter) := l_ollast_update_date_tab2(i);

9380: l_olblock23text_tab(l_okc_k_lines_tl_counter) := l_olblock23text_tab2(i);
9381: l_olcreated_by_tab(l_okc_k_lines_tl_counter) := l_olcreated_by_tab2(i);
9382: l_olcreation_date_tab(l_okc_k_lines_tl_counter) := l_olcreation_date_tab2(i);
9383: l_ollast_updated_by_tab(l_okc_k_lines_tl_counter) := l_ollast_updated_by_tab2(i);
9384: l_ollast_update_date_tab(l_okc_k_lines_tl_counter) := l_ollast_update_date_tab2(i);
9385: l_ollast_update_login_tab(l_okc_k_lines_tl_counter) := l_ollast_update_login_tab2(i);
9386: l_olsecurity_group_id_tab(l_okc_k_lines_tl_counter) := l_olsecurity_group_id_tab2(i);
9387: l_oloke_boe_description_tab(l_okc_k_lines_tl_counter) := l_oloke_boe_description_tab2(i);
9388: l_olcognomen_tab(l_okc_k_lines_tl_counter) := l_olcognomen_tab2(i);

Line 9385: l_ollast_update_login_tab(l_okc_k_lines_tl_counter) := l_ollast_update_login_tab2(i);

9381: l_olcreated_by_tab(l_okc_k_lines_tl_counter) := l_olcreated_by_tab2(i);
9382: l_olcreation_date_tab(l_okc_k_lines_tl_counter) := l_olcreation_date_tab2(i);
9383: l_ollast_updated_by_tab(l_okc_k_lines_tl_counter) := l_ollast_updated_by_tab2(i);
9384: l_ollast_update_date_tab(l_okc_k_lines_tl_counter) := l_ollast_update_date_tab2(i);
9385: l_ollast_update_login_tab(l_okc_k_lines_tl_counter) := l_ollast_update_login_tab2(i);
9386: l_olsecurity_group_id_tab(l_okc_k_lines_tl_counter) := l_olsecurity_group_id_tab2(i);
9387: l_oloke_boe_description_tab(l_okc_k_lines_tl_counter) := l_oloke_boe_description_tab2(i);
9388: l_olcognomen_tab(l_okc_k_lines_tl_counter) := l_olcognomen_tab2(i);
9389:

Line 9386: l_olsecurity_group_id_tab(l_okc_k_lines_tl_counter) := l_olsecurity_group_id_tab2(i);

9382: l_olcreation_date_tab(l_okc_k_lines_tl_counter) := l_olcreation_date_tab2(i);
9383: l_ollast_updated_by_tab(l_okc_k_lines_tl_counter) := l_ollast_updated_by_tab2(i);
9384: l_ollast_update_date_tab(l_okc_k_lines_tl_counter) := l_ollast_update_date_tab2(i);
9385: l_ollast_update_login_tab(l_okc_k_lines_tl_counter) := l_ollast_update_login_tab2(i);
9386: l_olsecurity_group_id_tab(l_okc_k_lines_tl_counter) := l_olsecurity_group_id_tab2(i);
9387: l_oloke_boe_description_tab(l_okc_k_lines_tl_counter) := l_oloke_boe_description_tab2(i);
9388: l_olcognomen_tab(l_okc_k_lines_tl_counter) := l_olcognomen_tab2(i);
9389:
9390: l_okc_k_lines_tl_counter := l_okc_k_lines_tl_counter + 1;

Line 9387: l_oloke_boe_description_tab(l_okc_k_lines_tl_counter) := l_oloke_boe_description_tab2(i);

9383: l_ollast_updated_by_tab(l_okc_k_lines_tl_counter) := l_ollast_updated_by_tab2(i);
9384: l_ollast_update_date_tab(l_okc_k_lines_tl_counter) := l_ollast_update_date_tab2(i);
9385: l_ollast_update_login_tab(l_okc_k_lines_tl_counter) := l_ollast_update_login_tab2(i);
9386: l_olsecurity_group_id_tab(l_okc_k_lines_tl_counter) := l_olsecurity_group_id_tab2(i);
9387: l_oloke_boe_description_tab(l_okc_k_lines_tl_counter) := l_oloke_boe_description_tab2(i);
9388: l_olcognomen_tab(l_okc_k_lines_tl_counter) := l_olcognomen_tab2(i);
9389:
9390: l_okc_k_lines_tl_counter := l_okc_k_lines_tl_counter + 1;
9391:

Line 9388: l_olcognomen_tab(l_okc_k_lines_tl_counter) := l_olcognomen_tab2(i);

9384: l_ollast_update_date_tab(l_okc_k_lines_tl_counter) := l_ollast_update_date_tab2(i);
9385: l_ollast_update_login_tab(l_okc_k_lines_tl_counter) := l_ollast_update_login_tab2(i);
9386: l_olsecurity_group_id_tab(l_okc_k_lines_tl_counter) := l_olsecurity_group_id_tab2(i);
9387: l_oloke_boe_description_tab(l_okc_k_lines_tl_counter) := l_oloke_boe_description_tab2(i);
9388: l_olcognomen_tab(l_okc_k_lines_tl_counter) := l_olcognomen_tab2(i);
9389:
9390: l_okc_k_lines_tl_counter := l_okc_k_lines_tl_counter + 1;
9391:
9392: END LOOP;

Line 9390: l_okc_k_lines_tl_counter := l_okc_k_lines_tl_counter + 1;

9386: l_olsecurity_group_id_tab(l_okc_k_lines_tl_counter) := l_olsecurity_group_id_tab2(i);
9387: l_oloke_boe_description_tab(l_okc_k_lines_tl_counter) := l_oloke_boe_description_tab2(i);
9388: l_olcognomen_tab(l_okc_k_lines_tl_counter) := l_olcognomen_tab2(i);
9389:
9390: l_okc_k_lines_tl_counter := l_okc_k_lines_tl_counter + 1;
9391:
9392: END LOOP;
9393:
9394: IF (p_flush = 'Y') THEN

Line 9396: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_okc_k_lines_tl_counter='|| l_okc_k_lines_tl_counter || ' l_olid_tab.count=' || l_olid_tab.COUNT);

9392: END LOOP;
9393:
9394: IF (p_flush = 'Y') THEN
9395: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
9396: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_okc_k_lines_tl_counter='|| l_okc_k_lines_tl_counter || ' l_olid_tab.count=' || l_olid_tab.COUNT);
9397: END IF;
9398: IF (l_okc_k_lines_tl_counter > 1) THEN
9399: forall i IN l_olid_tab.first..l_olid_tab.last
9400: INSERT INTO okc_k_lines_tl (

Line 9398: IF (l_okc_k_lines_tl_counter > 1) THEN

9394: IF (p_flush = 'Y') THEN
9395: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
9396: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_okc_k_lines_tl_counter='|| l_okc_k_lines_tl_counter || ' l_olid_tab.count=' || l_olid_tab.COUNT);
9397: END IF;
9398: IF (l_okc_k_lines_tl_counter > 1) THEN
9399: forall i IN l_olid_tab.first..l_olid_tab.last
9400: INSERT INTO okc_k_lines_tl (
9401: id, LANGUAGE, source_lang,
9402: sfwt_flag, name, comments,

Line 9400: INSERT INTO okc_k_lines_tl (

9396: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_okc_k_lines_tl_counter='|| l_okc_k_lines_tl_counter || ' l_olid_tab.count=' || l_olid_tab.COUNT);
9397: END IF;
9398: IF (l_okc_k_lines_tl_counter > 1) THEN
9399: forall i IN l_olid_tab.first..l_olid_tab.last
9400: INSERT INTO okc_k_lines_tl (
9401: id, LANGUAGE, source_lang,
9402: sfwt_flag, name, comments,
9403: item_description, block23text, created_by,
9404: creation_date, last_updated_by, last_update_date,

Line 9419: END; /* insert_okc_k_lines_tl_old */

9415: END IF;
9416: END IF;
9417:
9418:
9419: END; /* insert_okc_k_lines_tl_old */
9420:
9421:
9422: PROCEDURE insert_okc_k_headers_tl(p_old_id IN okc_k_headers_tl.id%TYPE,
9423: p_new_id IN okc_k_headers_tl.id%TYPE) IS

Line 10363: W4 okc_k_lines_tl.item_description%TYPE;

10359: P NUMBER;
10360: W NUMBER;
10361: W2 NUMBER;
10362: W3 NUMBER;
10363: W4 okc_k_lines_tl.item_description%TYPE;
10364: X NUMBER;
10365: I NUMBER;
10366: J NUMBER;
10367: BEGIN

Line 10573: okc_k_lines_tl c

10569: a.ORIG_CONTRACT_LINE_ID --sechawla 17-Jul-09 PRB ESG enhancements : added this column
10570: ,a.origination_income -- Bug 12938353 : RGOOTY: End
10571: FROM okl_k_lines a,
10572: okc_k_lines_b b,
10573: okc_k_lines_tl c
10574: WHERE b.id = a.id
10575: AND b.dnz_chr_id = p_id
10576: AND b.id = c.id
10577: AND c.LANGUAGE = USERENV('LANG');

Line 10701: TYPE l_item_description_type IS TABLE OF okc_k_lines_tl.item_description%TYPE INDEX BY BINARY_INTEGER;

10697: TYPE l_qte_id_type IS TABLE OF okl_k_lines.qte_id%TYPE INDEX BY BINARY_INTEGER;
10698: TYPE l_funding_date_type IS TABLE OF okl_k_lines.funding_date%TYPE INDEX BY BINARY_INTEGER;
10699: TYPE l_stream_type_subclass_type IS TABLE OF okl_k_lines.stream_type_subclass%TYPE INDEX BY BINARY_INTEGER;
10700: TYPE l_lse_id_type IS TABLE OF okc_k_lines_b.lse_id%TYPE INDEX BY BINARY_INTEGER;
10701: TYPE l_item_description_type IS TABLE OF okc_k_lines_tl.item_description%TYPE INDEX BY BINARY_INTEGER;
10702: TYPE l_fee_purpose_code_type IS TABLE OF okl_k_lines.fee_purpose_code%TYPE INDEX BY BINARY_INTEGER;
10703: TYPE l_date_funding_expected_type is table of okl_k_lines.date_funding_expected%TYPE index by binary_integer;
10704: TYPE l_manufacturer_name_type is table of okl_k_lines.manufacturer_name%TYPE index by binary_integer;
10705: TYPE l_model_number_type is table of okl_k_lines.model_number%TYPE index by binary_integer;

Line 18349: l_asset_name_old okc_k_lines_tl.name%TYPE;

18345: l_new_33_id NUMBER;
18346: l_tmp_okl_33_rec l_okl_k_lines_rec_type;
18347: l_tmp_okc_34_rec l_okc_k_items_rec_type;
18348: l_new_34_id NUMBER;
18349: l_asset_name_old okc_k_lines_tl.name%TYPE;
18350: l_multi_gaap_profile okl_txd_assets_b.tax_book%TYPE;
18351:
18352: --Added by dpsingh for LE Uptake
18353: CURSOR contract_num_csr (p_ctr_id1 NUMBER) IS

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

21404: END;
21405: END IF;
21406:
21407: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
21408: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting okc_k_lines_tl...' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
21409: END IF;
21410: -- Now insert okc_k_lines_tl
21411: /*
21412: for i in 1..l_counter-1 loop

Line 21410: -- Now insert okc_k_lines_tl

21406:
21407: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
21408: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting okc_k_lines_tl...' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
21409: END IF;
21410: -- Now insert okc_k_lines_tl
21411: /*
21412: for i in 1..l_counter-1 loop
21413: --old id to be used to query, new id to update
21414: -- Store okc_k_lines_b l_id_tab into l_id_tab3 for future reference

Line 21416: insert_okc_k_lines_tl_old(l_id_tab3(i), l_id_tab(i), 'Y');

21412: for i in 1..l_counter-1 loop
21413: --old id to be used to query, new id to update
21414: -- Store okc_k_lines_b l_id_tab into l_id_tab3 for future reference
21415: if (i = l_counter - 1) then
21416: insert_okc_k_lines_tl_old(l_id_tab3(i), l_id_tab(i), 'Y');
21417: else
21418: insert_okc_k_lines_tl_old(l_id_tab3(i), l_id_tab(i), 'N');
21419: end if;
21420: end loop;

Line 21418: insert_okc_k_lines_tl_old(l_id_tab3(i), l_id_tab(i), 'N');

21414: -- Store okc_k_lines_b l_id_tab into l_id_tab3 for future reference
21415: if (i = l_counter - 1) then
21416: insert_okc_k_lines_tl_old(l_id_tab3(i), l_id_tab(i), 'Y');
21417: else
21418: insert_okc_k_lines_tl_old(l_id_tab3(i), l_id_tab(i), 'N');
21419: end if;
21420: end loop;
21421: */
21422: l_curr_pos := 'okl_copy_lease_contract:37';

Line 21424: insert_okc_k_lines_tl(p_chr_id);

21420: end loop;
21421: */
21422: l_curr_pos := 'okl_copy_lease_contract:37';
21423: l_message := 'OKL_NEW_COPY_CLE_ERROR';
21424: insert_okc_k_lines_tl(p_chr_id);
21425: --sort_aid_mapping_tab;
21426: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
21427: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After sort_aid_mapping_tab...' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
21428: END IF;