APPS.FA_MASSADD_PREP_ENERGY_PKG dependencies on FA_ASSET_KEYWORDS

Line 222: l_key_ccid FA_Asset_Keywords.Code_Combination_ID%TYPE;

218: l_dyanmic_cur number;
219:
220: l_segment varchar30_tbl;
221: l_category FA_Categories.Category_ID%TYPE;
222: l_key_ccid FA_Asset_Keywords.Code_Combination_ID%TYPE;
223: l_asset_type FA_Mass_Additions.Asset_Type%TYPE;
224:
225: l_mass_addition_id FA_Mass_Additions.Mass_Addition_ID%TYPE;
226: l_invoice_number FA_Mass_Additions.Invoice_Number%TYPE;

Line 347: FROM fa_asset_keywords

343: p_log_level_rec => p_log_level_rec);
344: end if;
345: SELECT code_combination_id
346: INTO l_akey_ccid
347: FROM fa_asset_keywords
348: WHERE nvl(segment1, '-1') = nvl(l_akey_segment(1), '-1')
349: and nvl(segment2, '-1') = nvl(l_akey_segment(2), '-1')
350: and nvl(segment3, '-1') = nvl(l_akey_segment(3), '-1')
351: and nvl(segment4, '-1') = nvl(l_akey_segment(4), '-1')

Line 361: SELECT FA_Asset_keywords_S.Nextval

357: and nvl(segment10, '-1') = nvl(l_akey_segment(10), '-1');
358: px_mass_add_rec.asset_key_ccid := l_akey_ccid;
359: EXCEPTION
360: WHEN no_data_found THEN
361: SELECT FA_Asset_keywords_S.Nextval
362: INTO akey_ccid_seq
363: FROM DUAL;
364: l_debug_str := 'Insert the asset key';
365: if (p_log_level_rec.statement_level) then

Line 371: INSERT INTO fa_asset_keywords

367: l_debug_str,
368: '',
369: p_log_level_rec => p_log_level_rec);
370: end if;
371: INSERT INTO fa_asset_keywords
372: (CODE_COMBINATION_ID,
373: SEGMENT1,
374: SEGMENT2,
375: SEGMENT3,

Line 441: FROM fa_asset_keywords

437:
438: BEGIN
439: SELECT code_combination_id
440: INTO px_mass_add_rec.asset_key_ccid
441: FROM fa_asset_keywords
442: WHERE nvl(segment1, '-1') = nvl(l_asset_key_segment1, '-1')
443: and nvl(segment2, '-1') = nvl(l_asset_key_segment2, '-1')
444: and nvl(segment3, '-1') = nvl(l_asset_key_segment3, '-1')
445: and nvl(segment4, '-1') = nvl(l_asset_key_segment4, '-1')

Line 455: SELECT FA_Asset_keywords_S.Nextval

451: and nvl(segment10, '-1') = nvl(l_asset_key_segment10, '-1');
452:
453: exception
454: when no_data_found then
455: SELECT FA_Asset_keywords_S.Nextval
456: INTO akey_ccid_seq
457: FROM DUAL;
458: INSERT INTO fa_asset_keywords
459: (CODE_COMBINATION_ID,

Line 458: INSERT INTO fa_asset_keywords

454: when no_data_found then
455: SELECT FA_Asset_keywords_S.Nextval
456: INTO akey_ccid_seq
457: FROM DUAL;
458: INSERT INTO fa_asset_keywords
459: (CODE_COMBINATION_ID,
460: SEGMENT1,
461: SEGMENT2,
462: SEGMENT3,