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 5304: okc_k_lines_tl c

5300: a.ship_to_site_use_id, a.payment_term_id, b.fee_type,
5301: c.name
5302: FROM okc_k_lines_b a,
5303: okl_k_lines b,
5304: okc_k_lines_tl c
5305: WHERE a.dnz_chr_id = p_chr_id
5306: AND a.id = b.id
5307: AND a.id = c.id
5308: AND c.LANGUAGE = USERENV('LANG');

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

5415: TYPE l_line_renewal_type_code_type IS TABLE OF okc_k_lines_b.line_renewal_type_code%TYPE INDEX BY BINARY_INTEGER;
5416: 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;
5417: TYPE l_payment_term_id_type IS TABLE OF okc_k_lines_b.payment_term_id%TYPE INDEX BY BINARY_INTEGER;
5418: TYPE l_fee_type_type IS TABLE OF okl_k_lines.fee_type%TYPE INDEX BY BINARY_INTEGER;
5419: TYPE l_name_type IS TABLE OF okc_k_lines_tl.name%TYPE INDEX BY BINARY_INTEGER;
5420:
5421: -- For okl_k_lines whole record
5422: TYPE l_okl_k_lines_rec_type IS RECORD (
5423: --id okl_k_lines.id%type := OKC_API.G_MISS_NUM,

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

5423: --id okl_k_lines.id%type := OKC_API.G_MISS_NUM,
5424: id NUMBER := OKC_API.G_MISS_NUM,
5425: oec okl_k_lines.oec%TYPE,
5426: year_built okl_k_lines.year_built%TYPE,
5427: item_description okc_k_lines_tl.item_description%TYPE := OKC_API.G_MISS_CHAR
5428: );
5429: /*
5430: TYPE lines_rec_type is record (
5431: id okl_k_lines.id%type := OKC_API.G_MISS_NUM,

Line 5452: 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);

5448: TYPE l_okc_k_items_rec_tab IS TABLE OF l_okc_k_items_rec_type INDEX BY BINARY_INTEGER;
5449: -- For okc_k_items whole record
5450:
5451:
5452: 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);
5453: 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);
5454: 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);
5455: 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);
5456: 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 5465: 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);

5461: 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);
5462: 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);
5463: 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);
5464: 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);
5465: 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);
5466: 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);
5467: 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);
5468: 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);
5469:

Line 6146: -- For okc_k_lines_tl begin

6142: TYPE l_gsecurity_group_id_type IS TABLE OF okc_rg_party_roles.security_group_id%TYPE INDEX BY BINARY_INTEGER;
6143:
6144: -- For okc_rg_party_roles End
6145:
6146: -- For okc_k_lines_tl begin
6147:
6148: TYPE l_olid_type IS TABLE OF okc_k_lines_tl.id%TYPE INDEX BY BINARY_INTEGER;
6149: TYPE l_ollanguage_type IS TABLE OF okc_k_lines_tl.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
6150: TYPE l_olsource_lang_type IS TABLE OF okc_k_lines_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;

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

6144: -- For okc_rg_party_roles End
6145:
6146: -- For okc_k_lines_tl begin
6147:
6148: TYPE l_olid_type IS TABLE OF okc_k_lines_tl.id%TYPE INDEX BY BINARY_INTEGER;
6149: TYPE l_ollanguage_type IS TABLE OF okc_k_lines_tl.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
6150: TYPE l_olsource_lang_type IS TABLE OF okc_k_lines_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;
6151: TYPE l_olsfwt_flag_type IS TABLE OF okc_k_lines_tl.sfwt_flag%TYPE INDEX BY BINARY_INTEGER;
6152: TYPE l_olname_type IS TABLE OF okc_k_lines_tl.name%TYPE INDEX BY BINARY_INTEGER;

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

6145:
6146: -- For okc_k_lines_tl begin
6147:
6148: TYPE l_olid_type IS TABLE OF okc_k_lines_tl.id%TYPE INDEX BY BINARY_INTEGER;
6149: TYPE l_ollanguage_type IS TABLE OF okc_k_lines_tl.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
6150: TYPE l_olsource_lang_type IS TABLE OF okc_k_lines_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;
6151: TYPE l_olsfwt_flag_type IS TABLE OF okc_k_lines_tl.sfwt_flag%TYPE INDEX BY BINARY_INTEGER;
6152: TYPE l_olname_type IS TABLE OF okc_k_lines_tl.name%TYPE INDEX BY BINARY_INTEGER;
6153: TYPE l_olcomments_type IS TABLE OF okc_k_lines_tl.comments%TYPE INDEX BY BINARY_INTEGER;

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

6146: -- For okc_k_lines_tl begin
6147:
6148: TYPE l_olid_type IS TABLE OF okc_k_lines_tl.id%TYPE INDEX BY BINARY_INTEGER;
6149: TYPE l_ollanguage_type IS TABLE OF okc_k_lines_tl.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
6150: TYPE l_olsource_lang_type IS TABLE OF okc_k_lines_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;
6151: TYPE l_olsfwt_flag_type IS TABLE OF okc_k_lines_tl.sfwt_flag%TYPE INDEX BY BINARY_INTEGER;
6152: TYPE l_olname_type IS TABLE OF okc_k_lines_tl.name%TYPE INDEX BY BINARY_INTEGER;
6153: TYPE l_olcomments_type IS TABLE OF okc_k_lines_tl.comments%TYPE INDEX BY BINARY_INTEGER;
6154: TYPE l_olitem_description_type IS TABLE OF okc_k_lines_tl.item_description%TYPE INDEX BY BINARY_INTEGER;

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

6147:
6148: TYPE l_olid_type IS TABLE OF okc_k_lines_tl.id%TYPE INDEX BY BINARY_INTEGER;
6149: TYPE l_ollanguage_type IS TABLE OF okc_k_lines_tl.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
6150: TYPE l_olsource_lang_type IS TABLE OF okc_k_lines_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;
6151: TYPE l_olsfwt_flag_type IS TABLE OF okc_k_lines_tl.sfwt_flag%TYPE INDEX BY BINARY_INTEGER;
6152: TYPE l_olname_type IS TABLE OF okc_k_lines_tl.name%TYPE INDEX BY BINARY_INTEGER;
6153: TYPE l_olcomments_type IS TABLE OF okc_k_lines_tl.comments%TYPE INDEX BY BINARY_INTEGER;
6154: TYPE l_olitem_description_type IS TABLE OF okc_k_lines_tl.item_description%TYPE INDEX BY BINARY_INTEGER;
6155: TYPE l_olblock23text_type IS TABLE OF okc_k_lines_tl.block23text%TYPE INDEX BY BINARY_INTEGER;

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

6148: TYPE l_olid_type IS TABLE OF okc_k_lines_tl.id%TYPE INDEX BY BINARY_INTEGER;
6149: TYPE l_ollanguage_type IS TABLE OF okc_k_lines_tl.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
6150: TYPE l_olsource_lang_type IS TABLE OF okc_k_lines_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;
6151: TYPE l_olsfwt_flag_type IS TABLE OF okc_k_lines_tl.sfwt_flag%TYPE INDEX BY BINARY_INTEGER;
6152: TYPE l_olname_type IS TABLE OF okc_k_lines_tl.name%TYPE INDEX BY BINARY_INTEGER;
6153: TYPE l_olcomments_type IS TABLE OF okc_k_lines_tl.comments%TYPE INDEX BY BINARY_INTEGER;
6154: TYPE l_olitem_description_type IS TABLE OF okc_k_lines_tl.item_description%TYPE INDEX BY BINARY_INTEGER;
6155: TYPE l_olblock23text_type IS TABLE OF okc_k_lines_tl.block23text%TYPE INDEX BY BINARY_INTEGER;
6156: TYPE l_olcreated_by_type IS TABLE OF okc_k_lines_tl.created_by%TYPE INDEX BY BINARY_INTEGER;

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

6149: TYPE l_ollanguage_type IS TABLE OF okc_k_lines_tl.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
6150: TYPE l_olsource_lang_type IS TABLE OF okc_k_lines_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;
6151: TYPE l_olsfwt_flag_type IS TABLE OF okc_k_lines_tl.sfwt_flag%TYPE INDEX BY BINARY_INTEGER;
6152: TYPE l_olname_type IS TABLE OF okc_k_lines_tl.name%TYPE INDEX BY BINARY_INTEGER;
6153: TYPE l_olcomments_type IS TABLE OF okc_k_lines_tl.comments%TYPE INDEX BY BINARY_INTEGER;
6154: TYPE l_olitem_description_type IS TABLE OF okc_k_lines_tl.item_description%TYPE INDEX BY BINARY_INTEGER;
6155: TYPE l_olblock23text_type IS TABLE OF okc_k_lines_tl.block23text%TYPE INDEX BY BINARY_INTEGER;
6156: TYPE l_olcreated_by_type IS TABLE OF okc_k_lines_tl.created_by%TYPE INDEX BY BINARY_INTEGER;
6157: TYPE l_olcreation_date_type IS TABLE OF okc_k_lines_tl.creation_date%TYPE INDEX BY BINARY_INTEGER;

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

6150: TYPE l_olsource_lang_type IS TABLE OF okc_k_lines_tl.source_lang%TYPE INDEX BY BINARY_INTEGER;
6151: TYPE l_olsfwt_flag_type IS TABLE OF okc_k_lines_tl.sfwt_flag%TYPE INDEX BY BINARY_INTEGER;
6152: TYPE l_olname_type IS TABLE OF okc_k_lines_tl.name%TYPE INDEX BY BINARY_INTEGER;
6153: TYPE l_olcomments_type IS TABLE OF okc_k_lines_tl.comments%TYPE INDEX BY BINARY_INTEGER;
6154: TYPE l_olitem_description_type IS TABLE OF okc_k_lines_tl.item_description%TYPE INDEX BY BINARY_INTEGER;
6155: TYPE l_olblock23text_type IS TABLE OF okc_k_lines_tl.block23text%TYPE INDEX BY BINARY_INTEGER;
6156: TYPE l_olcreated_by_type IS TABLE OF okc_k_lines_tl.created_by%TYPE INDEX BY BINARY_INTEGER;
6157: TYPE l_olcreation_date_type IS TABLE OF okc_k_lines_tl.creation_date%TYPE INDEX BY BINARY_INTEGER;
6158: TYPE l_ollast_updated_by_type IS TABLE OF okc_k_lines_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;

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

6151: TYPE l_olsfwt_flag_type IS TABLE OF okc_k_lines_tl.sfwt_flag%TYPE INDEX BY BINARY_INTEGER;
6152: TYPE l_olname_type IS TABLE OF okc_k_lines_tl.name%TYPE INDEX BY BINARY_INTEGER;
6153: TYPE l_olcomments_type IS TABLE OF okc_k_lines_tl.comments%TYPE INDEX BY BINARY_INTEGER;
6154: TYPE l_olitem_description_type IS TABLE OF okc_k_lines_tl.item_description%TYPE INDEX BY BINARY_INTEGER;
6155: TYPE l_olblock23text_type IS TABLE OF okc_k_lines_tl.block23text%TYPE INDEX BY BINARY_INTEGER;
6156: TYPE l_olcreated_by_type IS TABLE OF okc_k_lines_tl.created_by%TYPE INDEX BY BINARY_INTEGER;
6157: TYPE l_olcreation_date_type IS TABLE OF okc_k_lines_tl.creation_date%TYPE INDEX BY BINARY_INTEGER;
6158: TYPE l_ollast_updated_by_type IS TABLE OF okc_k_lines_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
6159: TYPE l_ollast_update_date_type IS TABLE OF okc_k_lines_tl.last_update_date%TYPE INDEX BY BINARY_INTEGER;

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

6152: TYPE l_olname_type IS TABLE OF okc_k_lines_tl.name%TYPE INDEX BY BINARY_INTEGER;
6153: TYPE l_olcomments_type IS TABLE OF okc_k_lines_tl.comments%TYPE INDEX BY BINARY_INTEGER;
6154: TYPE l_olitem_description_type IS TABLE OF okc_k_lines_tl.item_description%TYPE INDEX BY BINARY_INTEGER;
6155: TYPE l_olblock23text_type IS TABLE OF okc_k_lines_tl.block23text%TYPE INDEX BY BINARY_INTEGER;
6156: TYPE l_olcreated_by_type IS TABLE OF okc_k_lines_tl.created_by%TYPE INDEX BY BINARY_INTEGER;
6157: TYPE l_olcreation_date_type IS TABLE OF okc_k_lines_tl.creation_date%TYPE INDEX BY BINARY_INTEGER;
6158: TYPE l_ollast_updated_by_type IS TABLE OF okc_k_lines_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
6159: TYPE l_ollast_update_date_type IS TABLE OF okc_k_lines_tl.last_update_date%TYPE INDEX BY BINARY_INTEGER;
6160: TYPE l_ollast_update_login_type IS TABLE OF okc_k_lines_tl.last_update_login%TYPE INDEX BY BINARY_INTEGER;

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

6153: TYPE l_olcomments_type IS TABLE OF okc_k_lines_tl.comments%TYPE INDEX BY BINARY_INTEGER;
6154: TYPE l_olitem_description_type IS TABLE OF okc_k_lines_tl.item_description%TYPE INDEX BY BINARY_INTEGER;
6155: TYPE l_olblock23text_type IS TABLE OF okc_k_lines_tl.block23text%TYPE INDEX BY BINARY_INTEGER;
6156: TYPE l_olcreated_by_type IS TABLE OF okc_k_lines_tl.created_by%TYPE INDEX BY BINARY_INTEGER;
6157: TYPE l_olcreation_date_type IS TABLE OF okc_k_lines_tl.creation_date%TYPE INDEX BY BINARY_INTEGER;
6158: TYPE l_ollast_updated_by_type IS TABLE OF okc_k_lines_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
6159: TYPE l_ollast_update_date_type IS TABLE OF okc_k_lines_tl.last_update_date%TYPE INDEX BY BINARY_INTEGER;
6160: TYPE l_ollast_update_login_type IS TABLE OF okc_k_lines_tl.last_update_login%TYPE INDEX BY BINARY_INTEGER;
6161: TYPE l_olsecurity_group_id_type IS TABLE OF okc_k_lines_tl.security_group_id%TYPE INDEX BY BINARY_INTEGER;

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

6154: TYPE l_olitem_description_type IS TABLE OF okc_k_lines_tl.item_description%TYPE INDEX BY BINARY_INTEGER;
6155: TYPE l_olblock23text_type IS TABLE OF okc_k_lines_tl.block23text%TYPE INDEX BY BINARY_INTEGER;
6156: TYPE l_olcreated_by_type IS TABLE OF okc_k_lines_tl.created_by%TYPE INDEX BY BINARY_INTEGER;
6157: TYPE l_olcreation_date_type IS TABLE OF okc_k_lines_tl.creation_date%TYPE INDEX BY BINARY_INTEGER;
6158: TYPE l_ollast_updated_by_type IS TABLE OF okc_k_lines_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
6159: TYPE l_ollast_update_date_type IS TABLE OF okc_k_lines_tl.last_update_date%TYPE INDEX BY BINARY_INTEGER;
6160: TYPE l_ollast_update_login_type IS TABLE OF okc_k_lines_tl.last_update_login%TYPE INDEX BY BINARY_INTEGER;
6161: TYPE l_olsecurity_group_id_type IS TABLE OF okc_k_lines_tl.security_group_id%TYPE INDEX BY BINARY_INTEGER;
6162: TYPE l_oloke_boe_description_type IS TABLE OF okc_k_lines_tl.oke_boe_description%TYPE INDEX BY BINARY_INTEGER;

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

6155: TYPE l_olblock23text_type IS TABLE OF okc_k_lines_tl.block23text%TYPE INDEX BY BINARY_INTEGER;
6156: TYPE l_olcreated_by_type IS TABLE OF okc_k_lines_tl.created_by%TYPE INDEX BY BINARY_INTEGER;
6157: TYPE l_olcreation_date_type IS TABLE OF okc_k_lines_tl.creation_date%TYPE INDEX BY BINARY_INTEGER;
6158: TYPE l_ollast_updated_by_type IS TABLE OF okc_k_lines_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
6159: TYPE l_ollast_update_date_type IS TABLE OF okc_k_lines_tl.last_update_date%TYPE INDEX BY BINARY_INTEGER;
6160: TYPE l_ollast_update_login_type IS TABLE OF okc_k_lines_tl.last_update_login%TYPE INDEX BY BINARY_INTEGER;
6161: TYPE l_olsecurity_group_id_type IS TABLE OF okc_k_lines_tl.security_group_id%TYPE INDEX BY BINARY_INTEGER;
6162: TYPE l_oloke_boe_description_type IS TABLE OF okc_k_lines_tl.oke_boe_description%TYPE INDEX BY BINARY_INTEGER;
6163: TYPE l_olcognomen_type IS TABLE OF okc_k_lines_tl.cognomen%TYPE INDEX BY BINARY_INTEGER;

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

6156: TYPE l_olcreated_by_type IS TABLE OF okc_k_lines_tl.created_by%TYPE INDEX BY BINARY_INTEGER;
6157: TYPE l_olcreation_date_type IS TABLE OF okc_k_lines_tl.creation_date%TYPE INDEX BY BINARY_INTEGER;
6158: TYPE l_ollast_updated_by_type IS TABLE OF okc_k_lines_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
6159: TYPE l_ollast_update_date_type IS TABLE OF okc_k_lines_tl.last_update_date%TYPE INDEX BY BINARY_INTEGER;
6160: TYPE l_ollast_update_login_type IS TABLE OF okc_k_lines_tl.last_update_login%TYPE INDEX BY BINARY_INTEGER;
6161: TYPE l_olsecurity_group_id_type IS TABLE OF okc_k_lines_tl.security_group_id%TYPE INDEX BY BINARY_INTEGER;
6162: TYPE l_oloke_boe_description_type IS TABLE OF okc_k_lines_tl.oke_boe_description%TYPE INDEX BY BINARY_INTEGER;
6163: TYPE l_olcognomen_type IS TABLE OF okc_k_lines_tl.cognomen%TYPE INDEX BY BINARY_INTEGER;
6164: -- For okc_k_lines_tl End

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

6157: TYPE l_olcreation_date_type IS TABLE OF okc_k_lines_tl.creation_date%TYPE INDEX BY BINARY_INTEGER;
6158: TYPE l_ollast_updated_by_type IS TABLE OF okc_k_lines_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
6159: TYPE l_ollast_update_date_type IS TABLE OF okc_k_lines_tl.last_update_date%TYPE INDEX BY BINARY_INTEGER;
6160: TYPE l_ollast_update_login_type IS TABLE OF okc_k_lines_tl.last_update_login%TYPE INDEX BY BINARY_INTEGER;
6161: TYPE l_olsecurity_group_id_type IS TABLE OF okc_k_lines_tl.security_group_id%TYPE INDEX BY BINARY_INTEGER;
6162: TYPE l_oloke_boe_description_type IS TABLE OF okc_k_lines_tl.oke_boe_description%TYPE INDEX BY BINARY_INTEGER;
6163: TYPE l_olcognomen_type IS TABLE OF okc_k_lines_tl.cognomen%TYPE INDEX BY BINARY_INTEGER;
6164: -- For okc_k_lines_tl End
6165:

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

6158: TYPE l_ollast_updated_by_type IS TABLE OF okc_k_lines_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
6159: TYPE l_ollast_update_date_type IS TABLE OF okc_k_lines_tl.last_update_date%TYPE INDEX BY BINARY_INTEGER;
6160: TYPE l_ollast_update_login_type IS TABLE OF okc_k_lines_tl.last_update_login%TYPE INDEX BY BINARY_INTEGER;
6161: TYPE l_olsecurity_group_id_type IS TABLE OF okc_k_lines_tl.security_group_id%TYPE INDEX BY BINARY_INTEGER;
6162: TYPE l_oloke_boe_description_type IS TABLE OF okc_k_lines_tl.oke_boe_description%TYPE INDEX BY BINARY_INTEGER;
6163: TYPE l_olcognomen_type IS TABLE OF okc_k_lines_tl.cognomen%TYPE INDEX BY BINARY_INTEGER;
6164: -- For okc_k_lines_tl End
6165:
6166: -- okc_k_party_roles_b Begin

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

6159: TYPE l_ollast_update_date_type IS TABLE OF okc_k_lines_tl.last_update_date%TYPE INDEX BY BINARY_INTEGER;
6160: TYPE l_ollast_update_login_type IS TABLE OF okc_k_lines_tl.last_update_login%TYPE INDEX BY BINARY_INTEGER;
6161: TYPE l_olsecurity_group_id_type IS TABLE OF okc_k_lines_tl.security_group_id%TYPE INDEX BY BINARY_INTEGER;
6162: TYPE l_oloke_boe_description_type IS TABLE OF okc_k_lines_tl.oke_boe_description%TYPE INDEX BY BINARY_INTEGER;
6163: TYPE l_olcognomen_type IS TABLE OF okc_k_lines_tl.cognomen%TYPE INDEX BY BINARY_INTEGER;
6164: -- For okc_k_lines_tl End
6165:
6166: -- okc_k_party_roles_b Begin
6167: TYPE l_prid_type IS TABLE OF okc_k_party_roles_b.id%TYPE INDEX BY BINARY_INTEGER;

Line 6164: -- For okc_k_lines_tl End

6160: TYPE l_ollast_update_login_type IS TABLE OF okc_k_lines_tl.last_update_login%TYPE INDEX BY BINARY_INTEGER;
6161: TYPE l_olsecurity_group_id_type IS TABLE OF okc_k_lines_tl.security_group_id%TYPE INDEX BY BINARY_INTEGER;
6162: TYPE l_oloke_boe_description_type IS TABLE OF okc_k_lines_tl.oke_boe_description%TYPE INDEX BY BINARY_INTEGER;
6163: TYPE l_olcognomen_type IS TABLE OF okc_k_lines_tl.cognomen%TYPE INDEX BY BINARY_INTEGER;
6164: -- For okc_k_lines_tl End
6165:
6166: -- okc_k_party_roles_b Begin
6167: TYPE l_prid_type IS TABLE OF okc_k_party_roles_b.id%TYPE INDEX BY BINARY_INTEGER;
6168: TYPE l_probject1_id1_type IS TABLE OF okc_k_party_roles_b.object1_id1%TYPE INDEX BY BINARY_INTEGER;

Line 6853: -- For okc_k_lines_tl Begin

6849: l_txl_itm_insts_counter2 NUMBER := 1;
6850:
6851: -- For okl_txl_itm_insts End
6852:
6853: -- For okc_k_lines_tl Begin
6854:
6855: l_olid_tab l_olid_type;
6856: l_ollanguage_tab l_ollanguage_type;
6857: l_olsource_lang_tab l_olsource_lang_type;

Line 6879: l_okc_k_lines_tl_counter NUMBER := 1;

6875: --avsingh: Bug 5710213: end
6876: l_olsts_code_tab l_sts_code_type;
6877: l_olfee_type_tab l_fee_type_type;
6878:
6879: l_okc_k_lines_tl_counter NUMBER := 1;
6880: -- For okc_k_lines_tl End
6881:
6882: -- For okl_party_payment_dtls Begin
6883:

Line 6880: -- For okc_k_lines_tl End

6876: l_olsts_code_tab l_sts_code_type;
6877: l_olfee_type_tab l_fee_type_type;
6878:
6879: l_okc_k_lines_tl_counter NUMBER := 1;
6880: -- For okc_k_lines_tl End
6881:
6882: -- For okl_party_payment_dtls Begin
6883:
6884: l_ppid_tab l_ppid_type;

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

8909: END LOOP;
8910: RETURN -1;
8911: END; /* find_mapping_id */
8912:
8913: PROCEDURE insert_okc_k_lines_tl(p_old_id IN okc_k_lines_b.id%TYPE) IS
8914: CURSOR c5(p_id NUMBER) IS
8915: SELECT
8916: a.id, a.LANGUAGE, a.source_lang,
8917: a.sfwt_flag, a.name, a.comments,

Line 8925: FROM okc_k_lines_tl a,

8921: a.cognomen, b.lse_id, b.sts_code, c.fee_type
8922: --avsingh: Bug 5710213: start
8923: , lsb.lty_code
8924: --avsingh: Bug 5710213: end
8925: FROM okc_k_lines_tl a,
8926: okc_k_lines_b b,
8927: okl_k_lines c,
8928: fnd_languages d
8929: --avsingh: Bug 5710213: start

Line 8951: FROM okc_k_lines_tl a,

8947: WHERE installed_flag IN ('B', 'I');
8948:
8949: CURSOR c7(p_id NUMBER) IS
8950: SELECT DISTINCT a.name
8951: FROM okc_k_lines_tl a,
8952: okc_k_lines_b b
8953: WHERE a.id = b.id
8954: AND b.dnz_chr_id = p_id
8955: -- gboomina Bug 6353660 - Start

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

9014: --(l_olsts_code_tab2(i) = 'ABANDONED') or
9015: --(l_ollse_id_tab2(i) = 47) ) then
9016: --null;
9017: --else
9018: l_olid_tab(l_okc_k_lines_tl_counter) := l_olid_tab2(i);
9019: -- Change id
9020: l_new_id := find_mapping_id(l_olid_tab(l_okc_k_lines_tl_counter));
9021: --print('okc_k_lines_tl:l_new_id=' || l_new_id);
9022: l_olid_tab(l_okc_k_lines_tl_counter) := l_new_id;

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

9016: --null;
9017: --else
9018: l_olid_tab(l_okc_k_lines_tl_counter) := l_olid_tab2(i);
9019: -- Change id
9020: l_new_id := find_mapping_id(l_olid_tab(l_okc_k_lines_tl_counter));
9021: --print('okc_k_lines_tl:l_new_id=' || l_new_id);
9022: l_olid_tab(l_okc_k_lines_tl_counter) := l_new_id;
9023:
9024: l_ollanguage_tab(l_okc_k_lines_tl_counter) := l_ollanguage_tab2(i);

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

9017: --else
9018: l_olid_tab(l_okc_k_lines_tl_counter) := l_olid_tab2(i);
9019: -- Change id
9020: l_new_id := find_mapping_id(l_olid_tab(l_okc_k_lines_tl_counter));
9021: --print('okc_k_lines_tl:l_new_id=' || l_new_id);
9022: l_olid_tab(l_okc_k_lines_tl_counter) := l_new_id;
9023:
9024: l_ollanguage_tab(l_okc_k_lines_tl_counter) := l_ollanguage_tab2(i);
9025: l_olsource_lang_tab(l_okc_k_lines_tl_counter) := l_olsource_lang_tab2(i);

Line 9022: l_olid_tab(l_okc_k_lines_tl_counter) := l_new_id;

9018: l_olid_tab(l_okc_k_lines_tl_counter) := l_olid_tab2(i);
9019: -- Change id
9020: l_new_id := find_mapping_id(l_olid_tab(l_okc_k_lines_tl_counter));
9021: --print('okc_k_lines_tl:l_new_id=' || l_new_id);
9022: l_olid_tab(l_okc_k_lines_tl_counter) := l_new_id;
9023:
9024: l_ollanguage_tab(l_okc_k_lines_tl_counter) := l_ollanguage_tab2(i);
9025: l_olsource_lang_tab(l_okc_k_lines_tl_counter) := l_olsource_lang_tab2(i);
9026: l_olsfwt_flag_tab(l_okc_k_lines_tl_counter) := l_olsfwt_flag_tab2(i);

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

9020: l_new_id := find_mapping_id(l_olid_tab(l_okc_k_lines_tl_counter));
9021: --print('okc_k_lines_tl:l_new_id=' || l_new_id);
9022: l_olid_tab(l_okc_k_lines_tl_counter) := l_new_id;
9023:
9024: l_ollanguage_tab(l_okc_k_lines_tl_counter) := l_ollanguage_tab2(i);
9025: l_olsource_lang_tab(l_okc_k_lines_tl_counter) := l_olsource_lang_tab2(i);
9026: l_olsfwt_flag_tab(l_okc_k_lines_tl_counter) := l_olsfwt_flag_tab2(i);
9027: l_olname_tab(l_okc_k_lines_tl_counter) := l_olname_tab2(i);
9028: l_olcomments_tab(l_okc_k_lines_tl_counter) := l_olcomments_tab2(i);

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

9021: --print('okc_k_lines_tl:l_new_id=' || l_new_id);
9022: l_olid_tab(l_okc_k_lines_tl_counter) := l_new_id;
9023:
9024: l_ollanguage_tab(l_okc_k_lines_tl_counter) := l_ollanguage_tab2(i);
9025: l_olsource_lang_tab(l_okc_k_lines_tl_counter) := l_olsource_lang_tab2(i);
9026: l_olsfwt_flag_tab(l_okc_k_lines_tl_counter) := l_olsfwt_flag_tab2(i);
9027: l_olname_tab(l_okc_k_lines_tl_counter) := l_olname_tab2(i);
9028: l_olcomments_tab(l_okc_k_lines_tl_counter) := l_olcomments_tab2(i);
9029: l_olitem_description_tab(l_okc_k_lines_tl_counter) := l_olitem_description_tab2(i);

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

9022: l_olid_tab(l_okc_k_lines_tl_counter) := l_new_id;
9023:
9024: l_ollanguage_tab(l_okc_k_lines_tl_counter) := l_ollanguage_tab2(i);
9025: l_olsource_lang_tab(l_okc_k_lines_tl_counter) := l_olsource_lang_tab2(i);
9026: l_olsfwt_flag_tab(l_okc_k_lines_tl_counter) := l_olsfwt_flag_tab2(i);
9027: l_olname_tab(l_okc_k_lines_tl_counter) := l_olname_tab2(i);
9028: l_olcomments_tab(l_okc_k_lines_tl_counter) := l_olcomments_tab2(i);
9029: l_olitem_description_tab(l_okc_k_lines_tl_counter) := l_olitem_description_tab2(i);
9030: l_olblock23text_tab(l_okc_k_lines_tl_counter) := l_olblock23text_tab2(i);

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

9023:
9024: l_ollanguage_tab(l_okc_k_lines_tl_counter) := l_ollanguage_tab2(i);
9025: l_olsource_lang_tab(l_okc_k_lines_tl_counter) := l_olsource_lang_tab2(i);
9026: l_olsfwt_flag_tab(l_okc_k_lines_tl_counter) := l_olsfwt_flag_tab2(i);
9027: l_olname_tab(l_okc_k_lines_tl_counter) := l_olname_tab2(i);
9028: l_olcomments_tab(l_okc_k_lines_tl_counter) := l_olcomments_tab2(i);
9029: l_olitem_description_tab(l_okc_k_lines_tl_counter) := l_olitem_description_tab2(i);
9030: l_olblock23text_tab(l_okc_k_lines_tl_counter) := l_olblock23text_tab2(i);
9031: l_olcreated_by_tab(l_okc_k_lines_tl_counter) := l_olcreated_by_tab2(i);

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

9024: l_ollanguage_tab(l_okc_k_lines_tl_counter) := l_ollanguage_tab2(i);
9025: l_olsource_lang_tab(l_okc_k_lines_tl_counter) := l_olsource_lang_tab2(i);
9026: l_olsfwt_flag_tab(l_okc_k_lines_tl_counter) := l_olsfwt_flag_tab2(i);
9027: l_olname_tab(l_okc_k_lines_tl_counter) := l_olname_tab2(i);
9028: l_olcomments_tab(l_okc_k_lines_tl_counter) := l_olcomments_tab2(i);
9029: l_olitem_description_tab(l_okc_k_lines_tl_counter) := l_olitem_description_tab2(i);
9030: l_olblock23text_tab(l_okc_k_lines_tl_counter) := l_olblock23text_tab2(i);
9031: l_olcreated_by_tab(l_okc_k_lines_tl_counter) := l_olcreated_by_tab2(i);
9032: l_olcreation_date_tab(l_okc_k_lines_tl_counter) := l_olcreation_date_tab2(i);

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

9025: l_olsource_lang_tab(l_okc_k_lines_tl_counter) := l_olsource_lang_tab2(i);
9026: l_olsfwt_flag_tab(l_okc_k_lines_tl_counter) := l_olsfwt_flag_tab2(i);
9027: l_olname_tab(l_okc_k_lines_tl_counter) := l_olname_tab2(i);
9028: l_olcomments_tab(l_okc_k_lines_tl_counter) := l_olcomments_tab2(i);
9029: l_olitem_description_tab(l_okc_k_lines_tl_counter) := l_olitem_description_tab2(i);
9030: l_olblock23text_tab(l_okc_k_lines_tl_counter) := l_olblock23text_tab2(i);
9031: l_olcreated_by_tab(l_okc_k_lines_tl_counter) := l_olcreated_by_tab2(i);
9032: l_olcreation_date_tab(l_okc_k_lines_tl_counter) := l_olcreation_date_tab2(i);
9033: l_ollast_updated_by_tab(l_okc_k_lines_tl_counter) := l_ollast_updated_by_tab2(i);

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

9026: l_olsfwt_flag_tab(l_okc_k_lines_tl_counter) := l_olsfwt_flag_tab2(i);
9027: l_olname_tab(l_okc_k_lines_tl_counter) := l_olname_tab2(i);
9028: l_olcomments_tab(l_okc_k_lines_tl_counter) := l_olcomments_tab2(i);
9029: l_olitem_description_tab(l_okc_k_lines_tl_counter) := l_olitem_description_tab2(i);
9030: l_olblock23text_tab(l_okc_k_lines_tl_counter) := l_olblock23text_tab2(i);
9031: l_olcreated_by_tab(l_okc_k_lines_tl_counter) := l_olcreated_by_tab2(i);
9032: l_olcreation_date_tab(l_okc_k_lines_tl_counter) := l_olcreation_date_tab2(i);
9033: l_ollast_updated_by_tab(l_okc_k_lines_tl_counter) := l_ollast_updated_by_tab2(i);
9034: l_ollast_update_date_tab(l_okc_k_lines_tl_counter) := l_ollast_update_date_tab2(i);

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

9027: l_olname_tab(l_okc_k_lines_tl_counter) := l_olname_tab2(i);
9028: l_olcomments_tab(l_okc_k_lines_tl_counter) := l_olcomments_tab2(i);
9029: l_olitem_description_tab(l_okc_k_lines_tl_counter) := l_olitem_description_tab2(i);
9030: l_olblock23text_tab(l_okc_k_lines_tl_counter) := l_olblock23text_tab2(i);
9031: l_olcreated_by_tab(l_okc_k_lines_tl_counter) := l_olcreated_by_tab2(i);
9032: l_olcreation_date_tab(l_okc_k_lines_tl_counter) := l_olcreation_date_tab2(i);
9033: l_ollast_updated_by_tab(l_okc_k_lines_tl_counter) := l_ollast_updated_by_tab2(i);
9034: l_ollast_update_date_tab(l_okc_k_lines_tl_counter) := l_ollast_update_date_tab2(i);
9035: l_ollast_update_login_tab(l_okc_k_lines_tl_counter) := l_ollast_update_login_tab2(i);

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

9028: l_olcomments_tab(l_okc_k_lines_tl_counter) := l_olcomments_tab2(i);
9029: l_olitem_description_tab(l_okc_k_lines_tl_counter) := l_olitem_description_tab2(i);
9030: l_olblock23text_tab(l_okc_k_lines_tl_counter) := l_olblock23text_tab2(i);
9031: l_olcreated_by_tab(l_okc_k_lines_tl_counter) := l_olcreated_by_tab2(i);
9032: l_olcreation_date_tab(l_okc_k_lines_tl_counter) := l_olcreation_date_tab2(i);
9033: l_ollast_updated_by_tab(l_okc_k_lines_tl_counter) := l_ollast_updated_by_tab2(i);
9034: l_ollast_update_date_tab(l_okc_k_lines_tl_counter) := l_ollast_update_date_tab2(i);
9035: l_ollast_update_login_tab(l_okc_k_lines_tl_counter) := l_ollast_update_login_tab2(i);
9036: l_olsecurity_group_id_tab(l_okc_k_lines_tl_counter) := l_olsecurity_group_id_tab2(i);

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

9029: l_olitem_description_tab(l_okc_k_lines_tl_counter) := l_olitem_description_tab2(i);
9030: l_olblock23text_tab(l_okc_k_lines_tl_counter) := l_olblock23text_tab2(i);
9031: l_olcreated_by_tab(l_okc_k_lines_tl_counter) := l_olcreated_by_tab2(i);
9032: l_olcreation_date_tab(l_okc_k_lines_tl_counter) := l_olcreation_date_tab2(i);
9033: l_ollast_updated_by_tab(l_okc_k_lines_tl_counter) := l_ollast_updated_by_tab2(i);
9034: l_ollast_update_date_tab(l_okc_k_lines_tl_counter) := l_ollast_update_date_tab2(i);
9035: l_ollast_update_login_tab(l_okc_k_lines_tl_counter) := l_ollast_update_login_tab2(i);
9036: l_olsecurity_group_id_tab(l_okc_k_lines_tl_counter) := l_olsecurity_group_id_tab2(i);
9037: l_oloke_boe_description_tab(l_okc_k_lines_tl_counter) := l_oloke_boe_description_tab2(i);

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

9030: l_olblock23text_tab(l_okc_k_lines_tl_counter) := l_olblock23text_tab2(i);
9031: l_olcreated_by_tab(l_okc_k_lines_tl_counter) := l_olcreated_by_tab2(i);
9032: l_olcreation_date_tab(l_okc_k_lines_tl_counter) := l_olcreation_date_tab2(i);
9033: l_ollast_updated_by_tab(l_okc_k_lines_tl_counter) := l_ollast_updated_by_tab2(i);
9034: l_ollast_update_date_tab(l_okc_k_lines_tl_counter) := l_ollast_update_date_tab2(i);
9035: l_ollast_update_login_tab(l_okc_k_lines_tl_counter) := l_ollast_update_login_tab2(i);
9036: l_olsecurity_group_id_tab(l_okc_k_lines_tl_counter) := l_olsecurity_group_id_tab2(i);
9037: l_oloke_boe_description_tab(l_okc_k_lines_tl_counter) := l_oloke_boe_description_tab2(i);
9038: l_olcognomen_tab(l_okc_k_lines_tl_counter) := l_olcognomen_tab2(i);

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

9031: l_olcreated_by_tab(l_okc_k_lines_tl_counter) := l_olcreated_by_tab2(i);
9032: l_olcreation_date_tab(l_okc_k_lines_tl_counter) := l_olcreation_date_tab2(i);
9033: l_ollast_updated_by_tab(l_okc_k_lines_tl_counter) := l_ollast_updated_by_tab2(i);
9034: l_ollast_update_date_tab(l_okc_k_lines_tl_counter) := l_ollast_update_date_tab2(i);
9035: l_ollast_update_login_tab(l_okc_k_lines_tl_counter) := l_ollast_update_login_tab2(i);
9036: l_olsecurity_group_id_tab(l_okc_k_lines_tl_counter) := l_olsecurity_group_id_tab2(i);
9037: l_oloke_boe_description_tab(l_okc_k_lines_tl_counter) := l_oloke_boe_description_tab2(i);
9038: l_olcognomen_tab(l_okc_k_lines_tl_counter) := l_olcognomen_tab2(i);
9039:

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

9032: l_olcreation_date_tab(l_okc_k_lines_tl_counter) := l_olcreation_date_tab2(i);
9033: l_ollast_updated_by_tab(l_okc_k_lines_tl_counter) := l_ollast_updated_by_tab2(i);
9034: l_ollast_update_date_tab(l_okc_k_lines_tl_counter) := l_ollast_update_date_tab2(i);
9035: l_ollast_update_login_tab(l_okc_k_lines_tl_counter) := l_ollast_update_login_tab2(i);
9036: l_olsecurity_group_id_tab(l_okc_k_lines_tl_counter) := l_olsecurity_group_id_tab2(i);
9037: l_oloke_boe_description_tab(l_okc_k_lines_tl_counter) := l_oloke_boe_description_tab2(i);
9038: l_olcognomen_tab(l_okc_k_lines_tl_counter) := l_olcognomen_tab2(i);
9039:
9040: l_ollse_id_tab(l_okc_k_lines_tl_counter) := l_ollse_id_tab2(i);

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

9033: l_ollast_updated_by_tab(l_okc_k_lines_tl_counter) := l_ollast_updated_by_tab2(i);
9034: l_ollast_update_date_tab(l_okc_k_lines_tl_counter) := l_ollast_update_date_tab2(i);
9035: l_ollast_update_login_tab(l_okc_k_lines_tl_counter) := l_ollast_update_login_tab2(i);
9036: l_olsecurity_group_id_tab(l_okc_k_lines_tl_counter) := l_olsecurity_group_id_tab2(i);
9037: l_oloke_boe_description_tab(l_okc_k_lines_tl_counter) := l_oloke_boe_description_tab2(i);
9038: l_olcognomen_tab(l_okc_k_lines_tl_counter) := l_olcognomen_tab2(i);
9039:
9040: l_ollse_id_tab(l_okc_k_lines_tl_counter) := l_ollse_id_tab2(i);
9041: --avsingh: Bug 5710213: start

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

9034: l_ollast_update_date_tab(l_okc_k_lines_tl_counter) := l_ollast_update_date_tab2(i);
9035: l_ollast_update_login_tab(l_okc_k_lines_tl_counter) := l_ollast_update_login_tab2(i);
9036: l_olsecurity_group_id_tab(l_okc_k_lines_tl_counter) := l_olsecurity_group_id_tab2(i);
9037: l_oloke_boe_description_tab(l_okc_k_lines_tl_counter) := l_oloke_boe_description_tab2(i);
9038: l_olcognomen_tab(l_okc_k_lines_tl_counter) := l_olcognomen_tab2(i);
9039:
9040: l_ollse_id_tab(l_okc_k_lines_tl_counter) := l_ollse_id_tab2(i);
9041: --avsingh: Bug 5710213: start
9042: l_ollty_code_tab(l_okc_k_lines_tl_counter) := l_ollty_code_tab2(i);

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

9036: l_olsecurity_group_id_tab(l_okc_k_lines_tl_counter) := l_olsecurity_group_id_tab2(i);
9037: l_oloke_boe_description_tab(l_okc_k_lines_tl_counter) := l_oloke_boe_description_tab2(i);
9038: l_olcognomen_tab(l_okc_k_lines_tl_counter) := l_olcognomen_tab2(i);
9039:
9040: l_ollse_id_tab(l_okc_k_lines_tl_counter) := l_ollse_id_tab2(i);
9041: --avsingh: Bug 5710213: start
9042: l_ollty_code_tab(l_okc_k_lines_tl_counter) := l_ollty_code_tab2(i);
9043: --avsingh: Bug 5710213: end
9044: l_olsts_code_tab(l_okc_k_lines_tl_counter) := l_olsts_code_tab2(i);

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

9038: l_olcognomen_tab(l_okc_k_lines_tl_counter) := l_olcognomen_tab2(i);
9039:
9040: l_ollse_id_tab(l_okc_k_lines_tl_counter) := l_ollse_id_tab2(i);
9041: --avsingh: Bug 5710213: start
9042: l_ollty_code_tab(l_okc_k_lines_tl_counter) := l_ollty_code_tab2(i);
9043: --avsingh: Bug 5710213: end
9044: l_olsts_code_tab(l_okc_k_lines_tl_counter) := l_olsts_code_tab2(i);
9045: l_olfee_type_tab(l_okc_k_lines_tl_counter) := l_olfee_type_tab2(i);
9046:

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

9040: l_ollse_id_tab(l_okc_k_lines_tl_counter) := l_ollse_id_tab2(i);
9041: --avsingh: Bug 5710213: start
9042: l_ollty_code_tab(l_okc_k_lines_tl_counter) := l_ollty_code_tab2(i);
9043: --avsingh: Bug 5710213: end
9044: l_olsts_code_tab(l_okc_k_lines_tl_counter) := l_olsts_code_tab2(i);
9045: l_olfee_type_tab(l_okc_k_lines_tl_counter) := l_olfee_type_tab2(i);
9046:
9047: l_okc_k_lines_tl_counter := l_okc_k_lines_tl_counter + 1;
9048:

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

9041: --avsingh: Bug 5710213: start
9042: l_ollty_code_tab(l_okc_k_lines_tl_counter) := l_ollty_code_tab2(i);
9043: --avsingh: Bug 5710213: end
9044: l_olsts_code_tab(l_okc_k_lines_tl_counter) := l_olsts_code_tab2(i);
9045: l_olfee_type_tab(l_okc_k_lines_tl_counter) := l_olfee_type_tab2(i);
9046:
9047: l_okc_k_lines_tl_counter := l_okc_k_lines_tl_counter + 1;
9048:
9049: --end if;

Line 9047: l_okc_k_lines_tl_counter := l_okc_k_lines_tl_counter + 1;

9043: --avsingh: Bug 5710213: end
9044: l_olsts_code_tab(l_okc_k_lines_tl_counter) := l_olsts_code_tab2(i);
9045: l_olfee_type_tab(l_okc_k_lines_tl_counter) := l_olfee_type_tab2(i);
9046:
9047: l_okc_k_lines_tl_counter := l_okc_k_lines_tl_counter + 1;
9048:
9049: --end if;
9050: END LOOP;
9051: END LOOP;

Line 9054: IF (l_okc_k_lines_tl_counter < 2) THEN

9050: END LOOP;
9051: END LOOP;
9052: CLOSE c5;
9053:
9054: IF (l_okc_k_lines_tl_counter < 2) THEN
9055: RETURN;
9056: END IF;
9057:
9058: --print('Opening c7 with p_old_id=' || p_old_id);

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

9082: CLOSE c7;
9083: sort_aid_mapping_tab;
9084: /* Debug only */
9085: /*
9086: print('Printing insert_okc_k_lines_tl:l_olid_tab ...');
9087: for i in l_olid_tab.first..l_olid_tab.last
9088: loop
9089: print('l_olid_tab('||i||')=' || l_olid_tab(i));
9090: print('l_olfee_type_tab('||i||')=' || l_olfee_type_tab(i));

Line 9122: IF (l_okc_k_lines_tl_counter > 1) THEN

9118: END IF;
9119: END LOOP;
9120: END IF;
9121:
9122: IF (l_okc_k_lines_tl_counter > 1) THEN
9123: FOR r IN c6
9124: LOOP
9125: --print('r.language_code=' || r.language_code);
9126: forall i IN l_olid_tab.first..l_olid_tab.last

Line 9127: INSERT INTO okc_k_lines_tl (

9123: FOR r IN c6
9124: LOOP
9125: --print('r.language_code=' || r.language_code);
9126: forall i IN l_olid_tab.first..l_olid_tab.last
9127: INSERT INTO okc_k_lines_tl (
9128: id, LANGUAGE, source_lang,
9129: sfwt_flag, name, comments,
9130: item_description, block23text, created_by,
9131: creation_date, last_updated_by, last_update_date,

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

9147: x_return_status := OKL_API.G_RET_STS_ERROR;
9148: /*OKL_API.set_message(p_app_name => 'OKL',
9149: p_msg_name => 'OKL_AM_NO_OLD_SALVAGE_VALUE',
9150: p_token1 => 'ASSET_NUMBER',
9151: p_token1_value => 'insert_okc_k_lines_tl');*/
9152: /* DEBUG */
9153: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
9154: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'sqlcode=' || SQLCODE || ':sqlerrm=' || SQLERRM);
9155: 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 9155: 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 || ' ...');

9151: p_token1_value => 'insert_okc_k_lines_tl');*/
9152: /* DEBUG */
9153: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
9154: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'sqlcode=' || SQLCODE || ':sqlerrm=' || SQLERRM);
9155: 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 || ' ...');
9156: END IF;
9157: IF (l_olid_tab.COUNT > 0) THEN
9158: FOR i IN l_olid_tab.first..l_olid_tab.last
9159: LOOP

Line 9177: END; /* insert okc_k_lines_tl */

9173:
9174:
9175: RAISE OKC_API.G_EXCEPTION_ERROR;
9176:
9177: END; /* insert okc_k_lines_tl */
9178:
9179: PROCEDURE insert_okc_k_lines_tl_old(p_old_id IN okc_k_lines_b.id%TYPE,
9180: p_new_id IN okc_k_lines_b.id%TYPE,
9181: p_flush IN VARCHAR2 ) IS

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

9175: RAISE OKC_API.G_EXCEPTION_ERROR;
9176:
9177: END; /* insert okc_k_lines_tl */
9178:
9179: PROCEDURE insert_okc_k_lines_tl_old(p_old_id IN okc_k_lines_b.id%TYPE,
9180: p_new_id IN okc_k_lines_b.id%TYPE,
9181: p_flush IN VARCHAR2 ) IS
9182: CURSOR c5(p_id okc_k_lines_b.id%TYPE) IS
9183: SELECT

Line 9190: FROM okc_k_lines_tl a,

9186: a.item_description, a.block23text, a.created_by,
9187: a.creation_date, a.last_updated_by, a.last_update_date,
9188: a.last_update_login, a.security_group_id, a.oke_boe_description,
9189: a.cognomen, b.lse_id
9190: FROM okc_k_lines_tl a,
9191: okc_k_lines_b b
9192: WHERE a.id = p_id
9193: AND a.id = b.id;
9194:

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

9233: --print('okc_k_lines_tab:l_id_tab.count='||l_id_tab.count);
9234: FOR i IN l_olid_tab2.first..l_olid_tab2.last LOOP
9235: -- Change id
9236: l_olid_tab2(i) := p_new_id;
9237: l_olid_tab(l_okc_k_lines_tl_counter) := l_olid_tab2(i);
9238:
9239: l_ollanguage_tab(l_okc_k_lines_tl_counter) := l_ollanguage_tab2(i);
9240: l_olsource_lang_tab(l_okc_k_lines_tl_counter) := l_olsource_lang_tab2(i);
9241: l_olsfwt_flag_tab(l_okc_k_lines_tl_counter) := l_olsfwt_flag_tab2(i);

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

9235: -- Change id
9236: l_olid_tab2(i) := p_new_id;
9237: l_olid_tab(l_okc_k_lines_tl_counter) := l_olid_tab2(i);
9238:
9239: l_ollanguage_tab(l_okc_k_lines_tl_counter) := l_ollanguage_tab2(i);
9240: l_olsource_lang_tab(l_okc_k_lines_tl_counter) := l_olsource_lang_tab2(i);
9241: l_olsfwt_flag_tab(l_okc_k_lines_tl_counter) := l_olsfwt_flag_tab2(i);
9242: l_olname_tab(l_okc_k_lines_tl_counter) := l_olname_tab2(i);
9243:

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

9236: l_olid_tab2(i) := p_new_id;
9237: l_olid_tab(l_okc_k_lines_tl_counter) := l_olid_tab2(i);
9238:
9239: l_ollanguage_tab(l_okc_k_lines_tl_counter) := l_ollanguage_tab2(i);
9240: l_olsource_lang_tab(l_okc_k_lines_tl_counter) := l_olsource_lang_tab2(i);
9241: l_olsfwt_flag_tab(l_okc_k_lines_tl_counter) := l_olsfwt_flag_tab2(i);
9242: l_olname_tab(l_okc_k_lines_tl_counter) := l_olname_tab2(i);
9243:
9244: /* AKP - to do: Put okl_copy_asset_pvt.generate_asset_number as public api

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

9237: l_olid_tab(l_okc_k_lines_tl_counter) := l_olid_tab2(i);
9238:
9239: l_ollanguage_tab(l_okc_k_lines_tl_counter) := l_ollanguage_tab2(i);
9240: l_olsource_lang_tab(l_okc_k_lines_tl_counter) := l_olsource_lang_tab2(i);
9241: l_olsfwt_flag_tab(l_okc_k_lines_tl_counter) := l_olsfwt_flag_tab2(i);
9242: l_olname_tab(l_okc_k_lines_tl_counter) := l_olname_tab2(i);
9243:
9244: /* AKP - to do: Put okl_copy_asset_pvt.generate_asset_number as public api
9245: Call okl_copy_asset_pvt.generate_asset_number instead of local procedure */

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

9238:
9239: l_ollanguage_tab(l_okc_k_lines_tl_counter) := l_ollanguage_tab2(i);
9240: l_olsource_lang_tab(l_okc_k_lines_tl_counter) := l_olsource_lang_tab2(i);
9241: l_olsfwt_flag_tab(l_okc_k_lines_tl_counter) := l_olsfwt_flag_tab2(i);
9242: l_olname_tab(l_okc_k_lines_tl_counter) := l_olname_tab2(i);
9243:
9244: /* AKP - to do: Put okl_copy_asset_pvt.generate_asset_number as public api
9245: Call okl_copy_asset_pvt.generate_asset_number instead of local procedure */
9246: IF (p_trans_type NOT IN ('CRB','CRL','CSP','CRV','ALI') AND

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

9248: -- Generate asset_number
9249: --l_ret_status := okl_copy_asset_pvt.generate_asset_number(
9250: IF (NOT(l_done_generating)) THEN
9251: IF (l_asset_counter > 1) THEN
9252: l_new_asset_name := find_aid_mapping_id(l_olname_tab(l_okc_k_lines_tl_counter));
9253: IF (l_new_asset_name = '-1') THEN
9254: l_ret_status := generate_asset_number(
9255: l_new_asset_name
9256: );

Line 9275: l_old_asset_name := l_olname_tab(l_okc_k_lines_tl_counter);

9271: END IF;
9272: END IF;
9273: l_done_generating := TRUE;
9274: END IF;
9275: l_old_asset_name := l_olname_tab(l_okc_k_lines_tl_counter);
9276: l_olname_tab(l_okc_k_lines_tl_counter) := l_new_asset_name;
9277: --print('Old Asset=' || l_old_asset_name);
9278: --print('New Asset=' || l_new_asset_name);
9279:

Line 9276: l_olname_tab(l_okc_k_lines_tl_counter) := l_new_asset_name;

9272: END IF;
9273: l_done_generating := TRUE;
9274: END IF;
9275: l_old_asset_name := l_olname_tab(l_okc_k_lines_tl_counter);
9276: l_olname_tab(l_okc_k_lines_tl_counter) := l_new_asset_name;
9277: --print('Old Asset=' || l_old_asset_name);
9278: --print('New Asset=' || l_new_asset_name);
9279:
9280: -- Store line id to asset_number mapping

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

9287:
9288: IF (l_asset_counter > 1) THEN
9289: sort_aid_mapping_tab;
9290: END IF;
9291: l_olcomments_tab(l_okc_k_lines_tl_counter) := l_olcomments_tab2(i);
9292: l_olitem_description_tab(l_okc_k_lines_tl_counter) := l_olitem_description_tab2(i);
9293: l_olblock23text_tab(l_okc_k_lines_tl_counter) := l_olblock23text_tab2(i);
9294: l_olcreated_by_tab(l_okc_k_lines_tl_counter) := l_olcreated_by_tab2(i);
9295: l_olcreation_date_tab(l_okc_k_lines_tl_counter) := l_olcreation_date_tab2(i);

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

9288: IF (l_asset_counter > 1) THEN
9289: sort_aid_mapping_tab;
9290: END IF;
9291: l_olcomments_tab(l_okc_k_lines_tl_counter) := l_olcomments_tab2(i);
9292: l_olitem_description_tab(l_okc_k_lines_tl_counter) := l_olitem_description_tab2(i);
9293: l_olblock23text_tab(l_okc_k_lines_tl_counter) := l_olblock23text_tab2(i);
9294: l_olcreated_by_tab(l_okc_k_lines_tl_counter) := l_olcreated_by_tab2(i);
9295: l_olcreation_date_tab(l_okc_k_lines_tl_counter) := l_olcreation_date_tab2(i);
9296: l_ollast_updated_by_tab(l_okc_k_lines_tl_counter) := l_ollast_updated_by_tab2(i);

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

9289: sort_aid_mapping_tab;
9290: END IF;
9291: l_olcomments_tab(l_okc_k_lines_tl_counter) := l_olcomments_tab2(i);
9292: l_olitem_description_tab(l_okc_k_lines_tl_counter) := l_olitem_description_tab2(i);
9293: l_olblock23text_tab(l_okc_k_lines_tl_counter) := l_olblock23text_tab2(i);
9294: l_olcreated_by_tab(l_okc_k_lines_tl_counter) := l_olcreated_by_tab2(i);
9295: l_olcreation_date_tab(l_okc_k_lines_tl_counter) := l_olcreation_date_tab2(i);
9296: l_ollast_updated_by_tab(l_okc_k_lines_tl_counter) := l_ollast_updated_by_tab2(i);
9297: l_ollast_update_date_tab(l_okc_k_lines_tl_counter) := l_ollast_update_date_tab2(i);

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

9290: END IF;
9291: l_olcomments_tab(l_okc_k_lines_tl_counter) := l_olcomments_tab2(i);
9292: l_olitem_description_tab(l_okc_k_lines_tl_counter) := l_olitem_description_tab2(i);
9293: l_olblock23text_tab(l_okc_k_lines_tl_counter) := l_olblock23text_tab2(i);
9294: l_olcreated_by_tab(l_okc_k_lines_tl_counter) := l_olcreated_by_tab2(i);
9295: l_olcreation_date_tab(l_okc_k_lines_tl_counter) := l_olcreation_date_tab2(i);
9296: l_ollast_updated_by_tab(l_okc_k_lines_tl_counter) := l_ollast_updated_by_tab2(i);
9297: l_ollast_update_date_tab(l_okc_k_lines_tl_counter) := l_ollast_update_date_tab2(i);
9298: l_ollast_update_login_tab(l_okc_k_lines_tl_counter) := l_ollast_update_login_tab2(i);

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

9291: l_olcomments_tab(l_okc_k_lines_tl_counter) := l_olcomments_tab2(i);
9292: l_olitem_description_tab(l_okc_k_lines_tl_counter) := l_olitem_description_tab2(i);
9293: l_olblock23text_tab(l_okc_k_lines_tl_counter) := l_olblock23text_tab2(i);
9294: l_olcreated_by_tab(l_okc_k_lines_tl_counter) := l_olcreated_by_tab2(i);
9295: l_olcreation_date_tab(l_okc_k_lines_tl_counter) := l_olcreation_date_tab2(i);
9296: l_ollast_updated_by_tab(l_okc_k_lines_tl_counter) := l_ollast_updated_by_tab2(i);
9297: l_ollast_update_date_tab(l_okc_k_lines_tl_counter) := l_ollast_update_date_tab2(i);
9298: l_ollast_update_login_tab(l_okc_k_lines_tl_counter) := l_ollast_update_login_tab2(i);
9299: l_olsecurity_group_id_tab(l_okc_k_lines_tl_counter) := l_olsecurity_group_id_tab2(i);

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

9292: l_olitem_description_tab(l_okc_k_lines_tl_counter) := l_olitem_description_tab2(i);
9293: l_olblock23text_tab(l_okc_k_lines_tl_counter) := l_olblock23text_tab2(i);
9294: l_olcreated_by_tab(l_okc_k_lines_tl_counter) := l_olcreated_by_tab2(i);
9295: l_olcreation_date_tab(l_okc_k_lines_tl_counter) := l_olcreation_date_tab2(i);
9296: l_ollast_updated_by_tab(l_okc_k_lines_tl_counter) := l_ollast_updated_by_tab2(i);
9297: l_ollast_update_date_tab(l_okc_k_lines_tl_counter) := l_ollast_update_date_tab2(i);
9298: l_ollast_update_login_tab(l_okc_k_lines_tl_counter) := l_ollast_update_login_tab2(i);
9299: l_olsecurity_group_id_tab(l_okc_k_lines_tl_counter) := l_olsecurity_group_id_tab2(i);
9300: l_oloke_boe_description_tab(l_okc_k_lines_tl_counter) := l_oloke_boe_description_tab2(i);

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

9293: l_olblock23text_tab(l_okc_k_lines_tl_counter) := l_olblock23text_tab2(i);
9294: l_olcreated_by_tab(l_okc_k_lines_tl_counter) := l_olcreated_by_tab2(i);
9295: l_olcreation_date_tab(l_okc_k_lines_tl_counter) := l_olcreation_date_tab2(i);
9296: l_ollast_updated_by_tab(l_okc_k_lines_tl_counter) := l_ollast_updated_by_tab2(i);
9297: l_ollast_update_date_tab(l_okc_k_lines_tl_counter) := l_ollast_update_date_tab2(i);
9298: l_ollast_update_login_tab(l_okc_k_lines_tl_counter) := l_ollast_update_login_tab2(i);
9299: l_olsecurity_group_id_tab(l_okc_k_lines_tl_counter) := l_olsecurity_group_id_tab2(i);
9300: l_oloke_boe_description_tab(l_okc_k_lines_tl_counter) := l_oloke_boe_description_tab2(i);
9301: l_olcognomen_tab(l_okc_k_lines_tl_counter) := l_olcognomen_tab2(i);

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

9294: l_olcreated_by_tab(l_okc_k_lines_tl_counter) := l_olcreated_by_tab2(i);
9295: l_olcreation_date_tab(l_okc_k_lines_tl_counter) := l_olcreation_date_tab2(i);
9296: l_ollast_updated_by_tab(l_okc_k_lines_tl_counter) := l_ollast_updated_by_tab2(i);
9297: l_ollast_update_date_tab(l_okc_k_lines_tl_counter) := l_ollast_update_date_tab2(i);
9298: l_ollast_update_login_tab(l_okc_k_lines_tl_counter) := l_ollast_update_login_tab2(i);
9299: l_olsecurity_group_id_tab(l_okc_k_lines_tl_counter) := l_olsecurity_group_id_tab2(i);
9300: l_oloke_boe_description_tab(l_okc_k_lines_tl_counter) := l_oloke_boe_description_tab2(i);
9301: l_olcognomen_tab(l_okc_k_lines_tl_counter) := l_olcognomen_tab2(i);
9302:

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

9295: l_olcreation_date_tab(l_okc_k_lines_tl_counter) := l_olcreation_date_tab2(i);
9296: l_ollast_updated_by_tab(l_okc_k_lines_tl_counter) := l_ollast_updated_by_tab2(i);
9297: l_ollast_update_date_tab(l_okc_k_lines_tl_counter) := l_ollast_update_date_tab2(i);
9298: l_ollast_update_login_tab(l_okc_k_lines_tl_counter) := l_ollast_update_login_tab2(i);
9299: l_olsecurity_group_id_tab(l_okc_k_lines_tl_counter) := l_olsecurity_group_id_tab2(i);
9300: l_oloke_boe_description_tab(l_okc_k_lines_tl_counter) := l_oloke_boe_description_tab2(i);
9301: l_olcognomen_tab(l_okc_k_lines_tl_counter) := l_olcognomen_tab2(i);
9302:
9303: l_okc_k_lines_tl_counter := l_okc_k_lines_tl_counter + 1;

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

9296: l_ollast_updated_by_tab(l_okc_k_lines_tl_counter) := l_ollast_updated_by_tab2(i);
9297: l_ollast_update_date_tab(l_okc_k_lines_tl_counter) := l_ollast_update_date_tab2(i);
9298: l_ollast_update_login_tab(l_okc_k_lines_tl_counter) := l_ollast_update_login_tab2(i);
9299: l_olsecurity_group_id_tab(l_okc_k_lines_tl_counter) := l_olsecurity_group_id_tab2(i);
9300: l_oloke_boe_description_tab(l_okc_k_lines_tl_counter) := l_oloke_boe_description_tab2(i);
9301: l_olcognomen_tab(l_okc_k_lines_tl_counter) := l_olcognomen_tab2(i);
9302:
9303: l_okc_k_lines_tl_counter := l_okc_k_lines_tl_counter + 1;
9304:

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

9297: l_ollast_update_date_tab(l_okc_k_lines_tl_counter) := l_ollast_update_date_tab2(i);
9298: l_ollast_update_login_tab(l_okc_k_lines_tl_counter) := l_ollast_update_login_tab2(i);
9299: l_olsecurity_group_id_tab(l_okc_k_lines_tl_counter) := l_olsecurity_group_id_tab2(i);
9300: l_oloke_boe_description_tab(l_okc_k_lines_tl_counter) := l_oloke_boe_description_tab2(i);
9301: l_olcognomen_tab(l_okc_k_lines_tl_counter) := l_olcognomen_tab2(i);
9302:
9303: l_okc_k_lines_tl_counter := l_okc_k_lines_tl_counter + 1;
9304:
9305: END LOOP;

Line 9303: l_okc_k_lines_tl_counter := l_okc_k_lines_tl_counter + 1;

9299: l_olsecurity_group_id_tab(l_okc_k_lines_tl_counter) := l_olsecurity_group_id_tab2(i);
9300: l_oloke_boe_description_tab(l_okc_k_lines_tl_counter) := l_oloke_boe_description_tab2(i);
9301: l_olcognomen_tab(l_okc_k_lines_tl_counter) := l_olcognomen_tab2(i);
9302:
9303: l_okc_k_lines_tl_counter := l_okc_k_lines_tl_counter + 1;
9304:
9305: END LOOP;
9306:
9307: IF (p_flush = 'Y') THEN

Line 9309: 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);

9305: END LOOP;
9306:
9307: IF (p_flush = 'Y') THEN
9308: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
9309: 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);
9310: END IF;
9311: IF (l_okc_k_lines_tl_counter > 1) THEN
9312: forall i IN l_olid_tab.first..l_olid_tab.last
9313: INSERT INTO okc_k_lines_tl (

Line 9311: IF (l_okc_k_lines_tl_counter > 1) THEN

9307: IF (p_flush = 'Y') THEN
9308: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
9309: 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);
9310: END IF;
9311: IF (l_okc_k_lines_tl_counter > 1) THEN
9312: forall i IN l_olid_tab.first..l_olid_tab.last
9313: INSERT INTO okc_k_lines_tl (
9314: id, LANGUAGE, source_lang,
9315: sfwt_flag, name, comments,

Line 9313: INSERT INTO okc_k_lines_tl (

9309: 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);
9310: END IF;
9311: IF (l_okc_k_lines_tl_counter > 1) THEN
9312: forall i IN l_olid_tab.first..l_olid_tab.last
9313: INSERT INTO okc_k_lines_tl (
9314: id, LANGUAGE, source_lang,
9315: sfwt_flag, name, comments,
9316: item_description, block23text, created_by,
9317: creation_date, last_updated_by, last_update_date,

Line 9332: END; /* insert_okc_k_lines_tl_old */

9328: END IF;
9329: END IF;
9330:
9331:
9332: END; /* insert_okc_k_lines_tl_old */
9333:
9334:
9335: PROCEDURE insert_okc_k_headers_tl(p_old_id IN okc_k_headers_tl.id%TYPE,
9336: p_new_id IN okc_k_headers_tl.id%TYPE) IS

Line 10276: W4 okc_k_lines_tl.item_description%TYPE;

10272: P NUMBER;
10273: W NUMBER;
10274: W2 NUMBER;
10275: W3 NUMBER;
10276: W4 okc_k_lines_tl.item_description%TYPE;
10277: X NUMBER;
10278: I NUMBER;
10279: J NUMBER;
10280: BEGIN

Line 10484: okc_k_lines_tl c

10480: a.fee_purpose_code, a.date_funding_expected, a.manufacturer_name,
10481: a.model_number, a.down_payment_receiver_code, a.capitalize_down_payment_yn
10482: FROM okl_k_lines a,
10483: okc_k_lines_b b,
10484: okc_k_lines_tl c
10485: WHERE b.id = a.id
10486: AND b.dnz_chr_id = p_id
10487: AND b.id = c.id
10488: AND c.LANGUAGE = USERENV('LANG');

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

10605: TYPE l_qte_id_type IS TABLE OF okl_k_lines.qte_id%TYPE INDEX BY BINARY_INTEGER;
10606: TYPE l_funding_date_type IS TABLE OF okl_k_lines.funding_date%TYPE INDEX BY BINARY_INTEGER;
10607: TYPE l_stream_type_subclass_type IS TABLE OF okl_k_lines.stream_type_subclass%TYPE INDEX BY BINARY_INTEGER;
10608: TYPE l_lse_id_type IS TABLE OF okc_k_lines_b.lse_id%TYPE INDEX BY BINARY_INTEGER;
10609: TYPE l_item_description_type IS TABLE OF okc_k_lines_tl.item_description%TYPE INDEX BY BINARY_INTEGER;
10610: TYPE l_fee_purpose_code_type IS TABLE OF okl_k_lines.fee_purpose_code%TYPE INDEX BY BINARY_INTEGER;
10611: TYPE l_date_funding_expected_type is table of okl_k_lines.date_funding_expected%TYPE index by binary_integer;
10612: TYPE l_manufacturer_name_type is table of okl_k_lines.manufacturer_name%TYPE index by binary_integer;
10613: TYPE l_model_number_type is table of okl_k_lines.model_number%TYPE index by binary_integer;

Line 18172: l_asset_name_old okc_k_lines_tl.name%TYPE;

18168: l_new_33_id NUMBER;
18169: l_tmp_okl_33_rec l_okl_k_lines_rec_type;
18170: l_tmp_okc_34_rec l_okc_k_items_rec_type;
18171: l_new_34_id NUMBER;
18172: l_asset_name_old okc_k_lines_tl.name%TYPE;
18173: l_multi_gaap_profile okl_txd_assets_b.tax_book%TYPE;
18174:
18175: --Added by dpsingh for LE Uptake
18176: CURSOR contract_num_csr (p_ctr_id1 NUMBER) IS

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

21226: END;
21227: END IF;
21228:
21229: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
21230: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting okc_k_lines_tl...' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
21231: END IF;
21232: -- Now insert okc_k_lines_tl
21233: /*
21234: for i in 1..l_counter-1 loop

Line 21232: -- Now insert okc_k_lines_tl

21228:
21229: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
21230: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting okc_k_lines_tl...' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
21231: END IF;
21232: -- Now insert okc_k_lines_tl
21233: /*
21234: for i in 1..l_counter-1 loop
21235: --old id to be used to query, new id to update
21236: -- Store okc_k_lines_b l_id_tab into l_id_tab3 for future reference

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

21234: for i in 1..l_counter-1 loop
21235: --old id to be used to query, new id to update
21236: -- Store okc_k_lines_b l_id_tab into l_id_tab3 for future reference
21237: if (i = l_counter - 1) then
21238: insert_okc_k_lines_tl_old(l_id_tab3(i), l_id_tab(i), 'Y');
21239: else
21240: insert_okc_k_lines_tl_old(l_id_tab3(i), l_id_tab(i), 'N');
21241: end if;
21242: end loop;

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

21236: -- Store okc_k_lines_b l_id_tab into l_id_tab3 for future reference
21237: if (i = l_counter - 1) then
21238: insert_okc_k_lines_tl_old(l_id_tab3(i), l_id_tab(i), 'Y');
21239: else
21240: insert_okc_k_lines_tl_old(l_id_tab3(i), l_id_tab(i), 'N');
21241: end if;
21242: end loop;
21243: */
21244: l_curr_pos := 'okl_copy_lease_contract:37';

Line 21246: insert_okc_k_lines_tl(p_chr_id);

21242: end loop;
21243: */
21244: l_curr_pos := 'okl_copy_lease_contract:37';
21245: l_message := 'OKL_NEW_COPY_CLE_ERROR';
21246: insert_okc_k_lines_tl(p_chr_id);
21247: --sort_aid_mapping_tab;
21248: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
21249: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After sort_aid_mapping_tab...' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
21250: END IF;