APPS.PO_ATTRIBUTE_VALUES_PVT dependencies on FND_PROFILE

Line 2688: l_onetime_item_all_languages FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;

2684: d_mod CONSTANT VARCHAR2(100) := D_get_translations;
2685: l_progress VARCHAR2(4);
2686:
2687: l_key PO_SESSION_GT.key%TYPE;
2688: l_onetime_item_all_languages FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;
2689: BEGIN
2690: l_progress := '010';
2691:
2692: IF PO_LOG.d_proc THEN

Line 2697: l_onetime_item_all_languages := NVL(FND_PROFILE.value('POR_LOAD_ONETIME_ITEM_ALL_LANG'), 'N');

2693: PO_LOG.proc_begin(d_mod,'p_attr_values_tlp_id_list',p_attr_values_tlp_id_list);
2694: END IF;
2695:
2696: -- Get the profile value for "POR: Load One-Time Items in All Languages"
2697: l_onetime_item_all_languages := NVL(FND_PROFILE.value('POR_LOAD_ONETIME_ITEM_ALL_LANG'), 'N');
2698: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Profile POR_LOAD_ONETIME_ITEM_ALL_LANG='||l_onetime_item_all_languages); END IF;
2699:
2700: -- SQL What: Pick a new key from session GT sequence .
2701: -- SQL Why : To get tlp_id's