APPS.PO_VENDORS_SV dependencies on AP_TERMS

Line 316: po_terms_sv.val_ap_terms(X_vs_terms_id, X_res_terms_id);

312: ** If not available or vendor site Terms Id is inactive,
313: ** validate the vendor Terms Id */
314:
315: if X_vs_terms_id is not null then
316: po_terms_sv.val_ap_terms(X_vs_terms_id, X_res_terms_id);
317: end if;
318:
319: if ((X_res_terms_id is null) and
320: (X_terms_id is not null)) then

Line 321: po_terms_sv.val_ap_terms(X_terms_id, X_res_terms_id);

317: end if;
318:
319: if ((X_res_terms_id is null) and
320: (X_terms_id is not null)) then
321: po_terms_sv.val_ap_terms(X_terms_id, X_res_terms_id);
322: end if;
323:
324:
325: /* Obtain displayed values for the valid ids */

Line 702: from ap_terms

698: /* Get the displayed value for a given Terms Id*/
699:
700: select name
701: into X_terms_dsp
702: from ap_terms
703: where term_id = X_res_terms_id;
704:
705: exception
706:

Line 728: p_terms_id AP_TERMS.term_id%TYPE

724:
725: =============================================================================*/
726: FUNCTION get_terms_dsp
727: (
728: p_terms_id AP_TERMS.term_id%TYPE
729: )
730: RETURN AP_TERMS.name%TYPE
731: IS
732: x_terms_dsp AP_TERMS.name%TYPE;

Line 730: RETURN AP_TERMS.name%TYPE

726: FUNCTION get_terms_dsp
727: (
728: p_terms_id AP_TERMS.term_id%TYPE
729: )
730: RETURN AP_TERMS.name%TYPE
731: IS
732: x_terms_dsp AP_TERMS.name%TYPE;
733:
734: BEGIN

Line 732: x_terms_dsp AP_TERMS.name%TYPE;

728: p_terms_id AP_TERMS.term_id%TYPE
729: )
730: RETURN AP_TERMS.name%TYPE
731: IS
732: x_terms_dsp AP_TERMS.name%TYPE;
733:
734: BEGIN
735:
736: SELECT name

Line 738: FROM ap_terms

734: BEGIN
735:
736: SELECT name
737: INTO x_terms_dsp
738: FROM ap_terms
739: WHERE term_id = p_terms_id;
740:
741: return (x_terms_dsp);
742: