DBA Data[Home] [Help]

APPS.PO_R12_CAT_UPG_VAL_PVT dependencies on AP_TERMS_TL

Line 2033: FROM AP_TERMS_TL

2029: l_progress := '020';
2030: BEGIN
2031: SELECT name
2032: INTO x_terms_name
2033: FROM AP_TERMS_TL
2034: WHERE term_id = p_terms_id
2035: AND language = userenv('LANG');
2036: EXCEPTION
2037: WHEN OTHERS THEN

Line 2039: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Exception while getting name from AP_TERMS_TL: '||SQLERRM); END IF;

2035: AND language = userenv('LANG');
2036: EXCEPTION
2037: WHEN OTHERS THEN
2038: l_progress := '030';
2039: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Exception while getting name from AP_TERMS_TL: '||SQLERRM); END IF;
2040:
2041: x_terms_name := p_terms_id;
2042: END;
2043: -- ECO bug 5584556: End

Line 2099: l_terms_name AP_TERMS_TL.name%TYPE;

2095: l_index NUMBER;
2096: i NUMBER;
2097: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2098:
2099: l_terms_name AP_TERMS_TL.name%TYPE;
2100: BEGIN
2101: l_progress := '010';
2102: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
2103: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Validating a defaulted field -- SHIP_VIA_LOOKUP_CODE (freight_carrier)'); END IF;