DBA Data[Home] [Help]

APPS.FA_LEASE_PVT dependencies on AP_TERMS

Line 161: P_TERMS_ID IN AP_TERMS.TERM_ID%TYPE

157: --------------------------------
158: -- CHECK FOR CHECK TERMS
159: --------------------------------
160: FUNCTION CHECK_TERMS_ID (
161: P_TERMS_ID IN AP_TERMS.TERM_ID%TYPE
162: ,p_log_level_rec IN fa_api_types.log_level_rec_type default null
163: ) RETURN BOOLEAN AS
164:
165: CURSOR C_CHECK_TERMS_ID IS

Line 167: AP_TERMS_BAT_PAY_TERMS_V

163: ) RETURN BOOLEAN AS
164:
165: CURSOR C_CHECK_TERMS_ID IS
166: SELECT TERM_ID FROM
167: AP_TERMS_BAT_PAY_TERMS_V
168: WHERE TERM_ID = P_TERMS_ID;
169:
170: L_TERMS_ID NUMBER:=NULL;
171:

Line 198: P_PAYMENT_TERMS IN AP_TERMS.NAME%TYPE,

194: ---------------------------------------
195: -- CHECK FOR CHECK PAYMENT TERMS
196: ---------------------------------------
197: FUNCTION CHECK_PAYMENT_TERMS(
198: P_PAYMENT_TERMS IN AP_TERMS.NAME%TYPE,
199: X_TERMS_ID OUT NOCOPY AP_TERMS.TERM_ID%TYPE
200: ,p_log_level_rec IN fa_api_types.log_level_rec_type default null
201: ) RETURN BOOLEAN AS
202:

Line 199: X_TERMS_ID OUT NOCOPY AP_TERMS.TERM_ID%TYPE

195: -- CHECK FOR CHECK PAYMENT TERMS
196: ---------------------------------------
197: FUNCTION CHECK_PAYMENT_TERMS(
198: P_PAYMENT_TERMS IN AP_TERMS.NAME%TYPE,
199: X_TERMS_ID OUT NOCOPY AP_TERMS.TERM_ID%TYPE
200: ,p_log_level_rec IN fa_api_types.log_level_rec_type default null
201: ) RETURN BOOLEAN AS
202:
203: CURSOR C_CHECK_PAYMENT_TERMS IS

Line 205: AP_TERMS_BAT_PAY_TERMS_V

201: ) RETURN BOOLEAN AS
202:
203: CURSOR C_CHECK_PAYMENT_TERMS IS
204: SELECT TERM_ID FROM
205: AP_TERMS_BAT_PAY_TERMS_V
206: WHERE TERMS = P_PAYMENT_TERMS;
207:
208: L_TERMS_ID NUMBER:=NULL;
209: