APPS.AR_SUBMIT_LOCKBOX dependencies on AR_LOCKBOXES

Line 244: p_lockbox_id IN ar_lockboxes.lockbox_id%TYPE,

240: | |
241: | MODIFICATION HISTORY - 22/01/2013 - Created by ASHLESH |
242: +=======================================================================*/
243: FUNCTION validate_validation( p_submit_validation IN VARCHAR2,
244: p_lockbox_id IN ar_lockboxes.lockbox_id%TYPE,
245: p_gl_date IN DATE,
246: p_pay_unrelated_inv IN VARCHAR2,
247: p_complete_batches IN VARCHAR2,
248: p_report_format IN VARCHAR2,

Line 255: l_lockbox_id ar_lockboxes.lockbox_id%TYPE;

251: l_trans_format_id ar_transmission_formats.transmission_format_id%TYPE;
252: l_lb_num_exists VARCHAR2(1);
253: l_pay_unrelated_inv VARCHAR2(1);
254: l_gl_date_source VARCHAR2(30);
255: l_lockbox_id ar_lockboxes.lockbox_id%TYPE;
256: l_dep_date_exists VARCHAR2(1);
257: l_msg_text fnd_new_messages.message_text%type;
258: BEGIN
259: IF PG_DEBUG IN ('Y', 'C') THEN

Line 322: FROM ar_lockboxes loc

318: RETURN 1;
319: END IF;
320: SELECT loc.gl_date_source
321: INTO l_gl_date_source
322: FROM ar_lockboxes loc
323: WHERE loc.lockbox_id = l_lockbox_id;
324: IF l_gl_date_source = 'CON' THEN
325: IF p_gl_date IS NULL THEN
326: FND_MESSAGE.SET_NAME('AR','AR_OPLB_GL_EXISTS');

Line 484: p_lockbox_id IN ar_lockboxes.lockbox_id%TYPE,

480: p_control_file IN VARCHAR2,
481: p_alt_name_search IN VARCHAR2,
482: p_ussgl_trx_code IN VARCHAR2,
483: p_submit_validation IN VARCHAR2 DEFAULT 'N',
484: p_lockbox_id IN ar_lockboxes.lockbox_id%TYPE,
485: p_gl_date IN VARCHAR2,
486: p_pay_unrelated_inv IN VARCHAR2 DEFAULT 'N',
487: p_complete_batches IN VARCHAR2 DEFAULT 'N',
488: p_report_format IN VARCHAR2 DEFAULT 'R',