APPS.PO_TERMS_SV dependencies on AP_TERMS

Line 115: FUNCTION val_payment_terms(X_ap_terms_id IN NUMBER) return BOOLEAN IS

111: FUNCTION NAME: val_payment_terms()
112:
113: ===========================================================================*/
114:
115: FUNCTION val_payment_terms(X_ap_terms_id IN NUMBER) return BOOLEAN IS
116:
117: X_progress varchar2(3) := NULL;
118: X_ap_terms_val number := NULL;
119:

Line 118: X_ap_terms_val number := NULL;

114:
115: FUNCTION val_payment_terms(X_ap_terms_id IN NUMBER) return BOOLEAN IS
116:
117: X_progress varchar2(3) := NULL;
118: X_ap_terms_val number := NULL;
119:
120: BEGIN
121:
122: X_progress := '010';

Line 124: po_terms_sv.val_ap_terms(X_ap_terms_id, X_ap_terms_val);

120: BEGIN
121:
122: X_progress := '010';
123:
124: po_terms_sv.val_ap_terms(X_ap_terms_id, X_ap_terms_val);
125:
126: if (X_ap_terms_val is not null) then
127: return (TRUE);
128: else

Line 126: if (X_ap_terms_val is not null) then

122: X_progress := '010';
123:
124: po_terms_sv.val_ap_terms(X_ap_terms_id, X_ap_terms_val);
125:
126: if (X_ap_terms_val is not null) then
127: return (TRUE);
128: else
129: return (FALSE);
130: end if;

Line 142: PROCEDURE NAME: val_ap_terms()

138: END val_payment_terms;
139:
140: /*===========================================================================
141:
142: PROCEDURE NAME: val_ap_terms()
143:
144: ===========================================================================*/
145:
146:

Line 147: procedure val_ap_terms (X_temp_terms_id IN number, X_res_terms_id IN OUT NOCOPY number) is

143:
144: ===========================================================================*/
145:
146:
147: procedure val_ap_terms (X_temp_terms_id IN number, X_res_terms_id IN OUT NOCOPY number) is
148: X_progress varchar2(3) := '';
149: begin
150: X_progress := '010';
151:

Line 156: FROM ap_terms

152: /* Check if the given Terms Id is active */
153:
154: SELECT term_id
155: INTO X_res_terms_id
156: FROM ap_terms
157: WHERE sysdate BETWEEN nvl(start_date_active, sysdate - 1)
158: AND nvl(end_date_active, sysdate + 1)
159: AND term_id = X_temp_terms_id;
160:

Line 168: po_message_s.sql_error('val_ap_terms',X_progress,sqlcode);

164: X_res_terms_id := '';
165: when too_many_rows then
166: X_res_terms_id := '';
167: when others then
168: po_message_s.sql_error('val_ap_terms',X_progress,sqlcode);
169: raise;
170:
171: end val_ap_terms;
172:

Line 171: end val_ap_terms;

167: when others then
168: po_message_s.sql_error('val_ap_terms',X_progress,sqlcode);
169: raise;
170:
171: end val_ap_terms;
172:
173: /*===========================================================================
174:
175: PROCEDURE NAME: get_terms_name()

Line 194: FROM ap_terms

190: IF (X_terms_id is not NULL) THEN
191:
192: SELECT name
193: INTO X_terms_name
194: FROM ap_terms
195: WHERE term_id = X_terms_id;
196:
197: END IF;
198:

Line 225: sql_str := 'SELECT name, term_id FROM ap_terms WHERE ';

221: Pay_id_null BOOLEAN := TRUE;
222:
223: BEGIN
224:
225: sql_str := 'SELECT name, term_id FROM ap_terms WHERE ';
226:
227: IF p_pay_record.payment_term_name IS NULL and
228: p_pay_record.payment_term_id IS NULL THEN
229:

Line 348: X_sql_str := 'SELECT start_date_active, end_date_active, enabled_flag FROM ap_terms WHERE ';

344: X_sysdate DATE := sysdate;
345:
346: BEGIN
347:
348: X_sql_str := 'SELECT start_date_active, end_date_active, enabled_flag FROM ap_terms WHERE ';
349:
350: IF p_pay_record.payment_term_name IS NULL and
351: p_pay_record.payment_term_id IS NULL THEN
352: