DBA Data[Home] [Help]

APPS.AR_SUBMIT_LOCKBOX dependencies on AR_TRANSMISSIONS

Line 7: transmission_name ar_transmissions.transmission_name%TYPE,

3: /* This record will hold all necessary parameters used for submitting
4: 'Process Lockboxes' */
5: TYPE lb_sub_rec IS RECORD(
6: new_transmission VARCHAR2(1),
7: transmission_name ar_transmissions.transmission_name%TYPE,
8: transmission_id ar_transmissions.transmission_id%TYPE,
9: orig_request_id ar_transmissions.transmission_request_id%TYPE,
10: submit_import VARCHAR2(1),
11: data_file_path VARCHAR2(240),

Line 8: transmission_id ar_transmissions.transmission_id%TYPE,

4: 'Process Lockboxes' */
5: TYPE lb_sub_rec IS RECORD(
6: new_transmission VARCHAR2(1),
7: transmission_name ar_transmissions.transmission_name%TYPE,
8: transmission_id ar_transmissions.transmission_id%TYPE,
9: orig_request_id ar_transmissions.transmission_request_id%TYPE,
10: submit_import VARCHAR2(1),
11: data_file_path VARCHAR2(240),
12: control_file VARCHAR2(100),

Line 9: orig_request_id ar_transmissions.transmission_request_id%TYPE,

5: TYPE lb_sub_rec IS RECORD(
6: new_transmission VARCHAR2(1),
7: transmission_name ar_transmissions.transmission_name%TYPE,
8: transmission_id ar_transmissions.transmission_id%TYPE,
9: orig_request_id ar_transmissions.transmission_request_id%TYPE,
10: submit_import VARCHAR2(1),
11: data_file_path VARCHAR2(240),
12: control_file VARCHAR2(100),
13: trans_format_name ar_transmission_formats.format_name%TYPE,

Line 14: trans_format_id ar_transmissions.requested_trans_format_id%TYPE,

10: submit_import VARCHAR2(1),
11: data_file_path VARCHAR2(240),
12: control_file VARCHAR2(100),
13: trans_format_name ar_transmission_formats.format_name%TYPE,
14: trans_format_id ar_transmissions.requested_trans_format_id%TYPE,
15: alt_name_search VARCHAR2(1),
16: ussgl_trans_code VARCHAR2(100),
17: submit_validation VARCHAR2(1),
18: pay_unrelated_inv VARCHAR2(1),

Line 36: p_transmission_name IN ar_transmissions.transmission_name%TYPE,

32: P_ERRBUF OUT NOCOPY VARCHAR2,
33: P_RETCODE OUT NOCOPY NUMBER,
34: p_org_id IN NUMBER,
35: p_new_transmission IN VARCHAR2,
36: p_transmission_name IN ar_transmissions.transmission_name%TYPE,
37: p_submit_import IN VARCHAR2 DEFAULT 'N',
38: p_transmission_format IN ar_transmission_formats.transmission_format_id%TYPE,
39: p_data_file IN VARCHAR2,
40: p_control_file IN VARCHAR2,