PACKAGE: APPS.AR_SUBMIT_LOCKBOX

Source

1 PACKAGE AR_SUBMIT_LOCKBOX AUTHID CURRENT_USER AS
2 /* $Header: ARSULBS.pls 120.0.12020000.4 2013/03/14 12:36:59 ashlkuma noship $ */
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),
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),
19     lockbox            ar_lockboxes.lockbox_number%TYPE,
20     lockbox_id         ar_lockboxes.lockbox_id%TYPE,
21     gl_date            DATE,
22     complete_batches   VARCHAR2(1),
23     report_format      VARCHAR2(1),
24     inv_trxn_handling  VARCHAR2(1),
25     submit_postbatch   VARCHAR2(1),
26     org_id             ar_lockboxes.org_id%TYPE,
27     app_unearn_disc    VARCHAR2(1),
28     no_of_instances    NUMBER(3)
29   );
30 
31   PROCEDURE submit_lockbox_via_srs(
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,
41     p_alt_name_search       IN  VARCHAR2,
42     p_ussgl_trx_code        IN  VARCHAR2,
43     p_submit_validation     IN  VARCHAR2 DEFAULT 'N',
44     p_lockbox_id            IN  ar_lockboxes.lockbox_id%TYPE,
45     p_gl_date               IN  VARCHAR2,
46     p_pay_unrelated_inv     IN  VARCHAR2 DEFAULT 'N',
47     p_complete_batches      IN  VARCHAR2 DEFAULT 'N',
48     p_report_format         IN  VARCHAR2 DEFAULT 'R',
49     p_invalid_trxn_handling IN  VARCHAR2 DEFAULT 'N',
50     p_submit_postbatch      IN  VARCHAR2 DEFAULT 'N',
51     p_app_unearned_disc     IN  VARCHAR2 DEFAULT 'N',
52     p_no_of_instances       IN  NUMBER
53   );
54 
55 END AR_SUBMIT_LOCKBOX;