APPS.PO_COMPARE_REVISIONS dependencies on AP_TERMS

Line 212: * get_ap_terms

208:
209:
210: /*********************************************************************
211: * NAME
212: * get_ap_terms
213: *
214: * PURPOSE
215: * Resolves the payment terms.
216: *

Line 228: FUNCTION get_ap_terms( p_term_id IN NUMBER )

224: * HISTORY
225: * 08-AUG-97 Nilo Paredes Created
226: * 22-SEP-97 Rami Haddad Return NULL if no values found.
227: ********************************************************************/
228: FUNCTION get_ap_terms( p_term_id IN NUMBER )
229: RETURN VARCHAR2 AS
230:
231: v_ap_terms ap_terms.description%TYPE;
232: v_progress varchar2(3);

Line 231: v_ap_terms ap_terms.description%TYPE;

227: ********************************************************************/
228: FUNCTION get_ap_terms( p_term_id IN NUMBER )
229: RETURN VARCHAR2 AS
230:
231: v_ap_terms ap_terms.description%TYPE;
232: v_progress varchar2(3);
233:
234: BEGIN
235:

Line 239: INTO v_ap_terms

235:
236: v_progress := '060';
237:
238: SELECT description
239: INTO v_ap_terms
240: FROM ap_terms
241: WHERE term_id = p_term_id;
242:
243: RETURN v_ap_terms;

Line 240: FROM ap_terms

236: v_progress := '060';
237:
238: SELECT description
239: INTO v_ap_terms
240: FROM ap_terms
241: WHERE term_id = p_term_id;
242:
243: RETURN v_ap_terms;
244:

Line 243: RETURN v_ap_terms;

239: INTO v_ap_terms
240: FROM ap_terms
241: WHERE term_id = p_term_id;
242:
243: RETURN v_ap_terms;
244:
245: EXCEPTION
246: WHEN no_data_found THEN
247: RETURN NULL;

Line 250: 'PO_COMPARE_REVISIONS.GET_AP_TERMS',

246: WHEN no_data_found THEN
247: RETURN NULL;
248: WHEN others THEN
249: PO_MESSAGE_S.SQL_ERROR(
250: 'PO_COMPARE_REVISIONS.GET_AP_TERMS',
251: v_progress,
252: sqlcode );
253: RAISE;
254:

Line 255: END get_ap_terms;

251: v_progress,
252: sqlcode );
253: RAISE;
254:
255: END get_ap_terms;
256:
257:
258:
259: /*********************************************************************

Line 1166: get_ap_terms( p_po_from.terms_id ),

1162: c_distribution_num,
1163: c_level_altered,
1164: --fnd_message.get_String('PO', 'POS_PAYMENT_TERMS'),
1165: 'ICX_PAYMENT_TERMS',
1166: get_ap_terms( p_po_from.terms_id ),
1167: get_ap_terms( p_po_to.terms_id )
1168: );
1169: END IF;
1170:

Line 1167: get_ap_terms( p_po_to.terms_id )

1163: c_level_altered,
1164: --fnd_message.get_String('PO', 'POS_PAYMENT_TERMS'),
1165: 'ICX_PAYMENT_TERMS',
1166: get_ap_terms( p_po_from.terms_id ),
1167: get_ap_terms( p_po_to.terms_id )
1168: );
1169: END IF;
1170:
1171: /* Amount */