eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AR_PROCESSING_PKG dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 13: --This procedure deletes the data from ra_cust_trx_line_gl_dist_all, ra_customer_trx_lines_all

9: p_all_orgs IN VARCHAR2,
10: p_debug IN VARCHAR2 DEFAULT NULL);
11:
12:
13: --This procedure deletes the data from ra_cust_trx_line_gl_dist_all, ra_customer_trx_lines_all
14: --Also deletes the MRC data from ra_cust_trx_line_gl_dist
15: PROCEDURE delete_trx_data(
16: p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
17: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE DEFAULT NULL,

Line 17: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE DEFAULT NULL,

13: --This procedure deletes the data from ra_cust_trx_line_gl_dist_all, ra_customer_trx_lines_all
14: --Also deletes the MRC data from ra_cust_trx_line_gl_dist
15: PROCEDURE delete_trx_data(
16: p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
17: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE DEFAULT NULL,
18: p_process_status OUT NOCOPY VARCHAR2,
19: p_process_message OUT NOCOPY VARCHAR2);
20:
21:

Line 22: --This procedure inserts the data into ra_customer_trx_lines_all

18: p_process_status OUT NOCOPY VARCHAR2,
19: p_process_message OUT NOCOPY VARCHAR2);
20:
21:
22: --This procedure inserts the data into ra_customer_trx_lines_all
23: PROCEDURE insert_trx_lines(
24: p_extended_amount IN ra_customer_trx_lines_all.extended_amount%TYPE,
25: p_taxable_amount IN ra_customer_trx_lines_all.taxable_amount%TYPE,
26: p_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,

Line 24: p_extended_amount IN ra_customer_trx_lines_all.extended_amount%TYPE,

20:
21:
22: --This procedure inserts the data into ra_customer_trx_lines_all
23: PROCEDURE insert_trx_lines(
24: p_extended_amount IN ra_customer_trx_lines_all.extended_amount%TYPE,
25: p_taxable_amount IN ra_customer_trx_lines_all.taxable_amount%TYPE,
26: p_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,
27: p_last_update_date IN ra_customer_trx_lines_all.last_update_date%TYPE,
28: p_last_updated_by IN ra_customer_trx_lines_all.last_updated_by%TYPE,

Line 25: p_taxable_amount IN ra_customer_trx_lines_all.taxable_amount%TYPE,

21:
22: --This procedure inserts the data into ra_customer_trx_lines_all
23: PROCEDURE insert_trx_lines(
24: p_extended_amount IN ra_customer_trx_lines_all.extended_amount%TYPE,
25: p_taxable_amount IN ra_customer_trx_lines_all.taxable_amount%TYPE,
26: p_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,
27: p_last_update_date IN ra_customer_trx_lines_all.last_update_date%TYPE,
28: p_last_updated_by IN ra_customer_trx_lines_all.last_updated_by%TYPE,
29: p_creation_date IN ra_customer_trx_lines_all.creation_date%TYPE,

Line 26: p_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,

22: --This procedure inserts the data into ra_customer_trx_lines_all
23: PROCEDURE insert_trx_lines(
24: p_extended_amount IN ra_customer_trx_lines_all.extended_amount%TYPE,
25: p_taxable_amount IN ra_customer_trx_lines_all.taxable_amount%TYPE,
26: p_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,
27: p_last_update_date IN ra_customer_trx_lines_all.last_update_date%TYPE,
28: p_last_updated_by IN ra_customer_trx_lines_all.last_updated_by%TYPE,
29: p_creation_date IN ra_customer_trx_lines_all.creation_date%TYPE,
30: p_created_by IN ra_customer_trx_lines_all.created_by%TYPE,

Line 27: p_last_update_date IN ra_customer_trx_lines_all.last_update_date%TYPE,

23: PROCEDURE insert_trx_lines(
24: p_extended_amount IN ra_customer_trx_lines_all.extended_amount%TYPE,
25: p_taxable_amount IN ra_customer_trx_lines_all.taxable_amount%TYPE,
26: p_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,
27: p_last_update_date IN ra_customer_trx_lines_all.last_update_date%TYPE,
28: p_last_updated_by IN ra_customer_trx_lines_all.last_updated_by%TYPE,
29: p_creation_date IN ra_customer_trx_lines_all.creation_date%TYPE,
30: p_created_by IN ra_customer_trx_lines_all.created_by%TYPE,
31: p_last_update_login IN ra_customer_trx_lines_all.last_update_login%TYPE,

Line 28: p_last_updated_by IN ra_customer_trx_lines_all.last_updated_by%TYPE,

24: p_extended_amount IN ra_customer_trx_lines_all.extended_amount%TYPE,
25: p_taxable_amount IN ra_customer_trx_lines_all.taxable_amount%TYPE,
26: p_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,
27: p_last_update_date IN ra_customer_trx_lines_all.last_update_date%TYPE,
28: p_last_updated_by IN ra_customer_trx_lines_all.last_updated_by%TYPE,
29: p_creation_date IN ra_customer_trx_lines_all.creation_date%TYPE,
30: p_created_by IN ra_customer_trx_lines_all.created_by%TYPE,
31: p_last_update_login IN ra_customer_trx_lines_all.last_update_login%TYPE,
32: p_customer_trx_id IN ra_customer_trx_lines_all.customer_trx_id%TYPE,

Line 29: p_creation_date IN ra_customer_trx_lines_all.creation_date%TYPE,

25: p_taxable_amount IN ra_customer_trx_lines_all.taxable_amount%TYPE,
26: p_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,
27: p_last_update_date IN ra_customer_trx_lines_all.last_update_date%TYPE,
28: p_last_updated_by IN ra_customer_trx_lines_all.last_updated_by%TYPE,
29: p_creation_date IN ra_customer_trx_lines_all.creation_date%TYPE,
30: p_created_by IN ra_customer_trx_lines_all.created_by%TYPE,
31: p_last_update_login IN ra_customer_trx_lines_all.last_update_login%TYPE,
32: p_customer_trx_id IN ra_customer_trx_lines_all.customer_trx_id%TYPE,
33: p_line_number IN ra_customer_trx_lines_all.line_number%TYPE,

Line 30: p_created_by IN ra_customer_trx_lines_all.created_by%TYPE,

26: p_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,
27: p_last_update_date IN ra_customer_trx_lines_all.last_update_date%TYPE,
28: p_last_updated_by IN ra_customer_trx_lines_all.last_updated_by%TYPE,
29: p_creation_date IN ra_customer_trx_lines_all.creation_date%TYPE,
30: p_created_by IN ra_customer_trx_lines_all.created_by%TYPE,
31: p_last_update_login IN ra_customer_trx_lines_all.last_update_login%TYPE,
32: p_customer_trx_id IN ra_customer_trx_lines_all.customer_trx_id%TYPE,
33: p_line_number IN ra_customer_trx_lines_all.line_number%TYPE,
34: p_set_of_books_id IN ra_customer_trx_lines_all.set_of_books_id%TYPE,

Line 31: p_last_update_login IN ra_customer_trx_lines_all.last_update_login%TYPE,

27: p_last_update_date IN ra_customer_trx_lines_all.last_update_date%TYPE,
28: p_last_updated_by IN ra_customer_trx_lines_all.last_updated_by%TYPE,
29: p_creation_date IN ra_customer_trx_lines_all.creation_date%TYPE,
30: p_created_by IN ra_customer_trx_lines_all.created_by%TYPE,
31: p_last_update_login IN ra_customer_trx_lines_all.last_update_login%TYPE,
32: p_customer_trx_id IN ra_customer_trx_lines_all.customer_trx_id%TYPE,
33: p_line_number IN ra_customer_trx_lines_all.line_number%TYPE,
34: p_set_of_books_id IN ra_customer_trx_lines_all.set_of_books_id%TYPE,
35: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE,

Line 32: p_customer_trx_id IN ra_customer_trx_lines_all.customer_trx_id%TYPE,

28: p_last_updated_by IN ra_customer_trx_lines_all.last_updated_by%TYPE,
29: p_creation_date IN ra_customer_trx_lines_all.creation_date%TYPE,
30: p_created_by IN ra_customer_trx_lines_all.created_by%TYPE,
31: p_last_update_login IN ra_customer_trx_lines_all.last_update_login%TYPE,
32: p_customer_trx_id IN ra_customer_trx_lines_all.customer_trx_id%TYPE,
33: p_line_number IN ra_customer_trx_lines_all.line_number%TYPE,
34: p_set_of_books_id IN ra_customer_trx_lines_all.set_of_books_id%TYPE,
35: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE,
36: p_line_type IN ra_customer_trx_lines_all.line_type%TYPE,

Line 33: p_line_number IN ra_customer_trx_lines_all.line_number%TYPE,

29: p_creation_date IN ra_customer_trx_lines_all.creation_date%TYPE,
30: p_created_by IN ra_customer_trx_lines_all.created_by%TYPE,
31: p_last_update_login IN ra_customer_trx_lines_all.last_update_login%TYPE,
32: p_customer_trx_id IN ra_customer_trx_lines_all.customer_trx_id%TYPE,
33: p_line_number IN ra_customer_trx_lines_all.line_number%TYPE,
34: p_set_of_books_id IN ra_customer_trx_lines_all.set_of_books_id%TYPE,
35: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE,
36: p_line_type IN ra_customer_trx_lines_all.line_type%TYPE,
37: p_org_id IN ra_customer_trx_lines_all.org_id%TYPE,

Line 34: p_set_of_books_id IN ra_customer_trx_lines_all.set_of_books_id%TYPE,

30: p_created_by IN ra_customer_trx_lines_all.created_by%TYPE,
31: p_last_update_login IN ra_customer_trx_lines_all.last_update_login%TYPE,
32: p_customer_trx_id IN ra_customer_trx_lines_all.customer_trx_id%TYPE,
33: p_line_number IN ra_customer_trx_lines_all.line_number%TYPE,
34: p_set_of_books_id IN ra_customer_trx_lines_all.set_of_books_id%TYPE,
35: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE,
36: p_line_type IN ra_customer_trx_lines_all.line_type%TYPE,
37: p_org_id IN ra_customer_trx_lines_all.org_id%TYPE,
38: p_uom_code IN ra_customer_trx_lines_all.uom_code%TYPE,

Line 35: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE,

31: p_last_update_login IN ra_customer_trx_lines_all.last_update_login%TYPE,
32: p_customer_trx_id IN ra_customer_trx_lines_all.customer_trx_id%TYPE,
33: p_line_number IN ra_customer_trx_lines_all.line_number%TYPE,
34: p_set_of_books_id IN ra_customer_trx_lines_all.set_of_books_id%TYPE,
35: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE,
36: p_line_type IN ra_customer_trx_lines_all.line_type%TYPE,
37: p_org_id IN ra_customer_trx_lines_all.org_id%TYPE,
38: p_uom_code IN ra_customer_trx_lines_all.uom_code%TYPE,
39: p_autotax IN ra_customer_trx_lines_all.autotax%TYPE,

Line 36: p_line_type IN ra_customer_trx_lines_all.line_type%TYPE,

32: p_customer_trx_id IN ra_customer_trx_lines_all.customer_trx_id%TYPE,
33: p_line_number IN ra_customer_trx_lines_all.line_number%TYPE,
34: p_set_of_books_id IN ra_customer_trx_lines_all.set_of_books_id%TYPE,
35: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE,
36: p_line_type IN ra_customer_trx_lines_all.line_type%TYPE,
37: p_org_id IN ra_customer_trx_lines_all.org_id%TYPE,
38: p_uom_code IN ra_customer_trx_lines_all.uom_code%TYPE,
39: p_autotax IN ra_customer_trx_lines_all.autotax%TYPE,
40: p_vat_tax_id IN ra_customer_trx_lines_all.vat_tax_id%TYPE,

Line 37: p_org_id IN ra_customer_trx_lines_all.org_id%TYPE,

33: p_line_number IN ra_customer_trx_lines_all.line_number%TYPE,
34: p_set_of_books_id IN ra_customer_trx_lines_all.set_of_books_id%TYPE,
35: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE,
36: p_line_type IN ra_customer_trx_lines_all.line_type%TYPE,
37: p_org_id IN ra_customer_trx_lines_all.org_id%TYPE,
38: p_uom_code IN ra_customer_trx_lines_all.uom_code%TYPE,
39: p_autotax IN ra_customer_trx_lines_all.autotax%TYPE,
40: p_vat_tax_id IN ra_customer_trx_lines_all.vat_tax_id%TYPE,
41: p_interface_line_context IN ra_customer_trx_lines_all.interface_line_context%TYPE DEFAULT NULL,

Line 38: p_uom_code IN ra_customer_trx_lines_all.uom_code%TYPE,

34: p_set_of_books_id IN ra_customer_trx_lines_all.set_of_books_id%TYPE,
35: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE,
36: p_line_type IN ra_customer_trx_lines_all.line_type%TYPE,
37: p_org_id IN ra_customer_trx_lines_all.org_id%TYPE,
38: p_uom_code IN ra_customer_trx_lines_all.uom_code%TYPE,
39: p_autotax IN ra_customer_trx_lines_all.autotax%TYPE,
40: p_vat_tax_id IN ra_customer_trx_lines_all.vat_tax_id%TYPE,
41: p_interface_line_context IN ra_customer_trx_lines_all.interface_line_context%TYPE DEFAULT NULL,
42: p_interface_line_attribute6 IN ra_customer_trx_lines_all.interface_line_attribute6%TYPE DEFAULT NULL,

Line 39: p_autotax IN ra_customer_trx_lines_all.autotax%TYPE,

35: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE,
36: p_line_type IN ra_customer_trx_lines_all.line_type%TYPE,
37: p_org_id IN ra_customer_trx_lines_all.org_id%TYPE,
38: p_uom_code IN ra_customer_trx_lines_all.uom_code%TYPE,
39: p_autotax IN ra_customer_trx_lines_all.autotax%TYPE,
40: p_vat_tax_id IN ra_customer_trx_lines_all.vat_tax_id%TYPE,
41: p_interface_line_context IN ra_customer_trx_lines_all.interface_line_context%TYPE DEFAULT NULL,
42: p_interface_line_attribute6 IN ra_customer_trx_lines_all.interface_line_attribute6%TYPE DEFAULT NULL,
43: p_interface_line_attribute3 IN ra_customer_trx_lines_all.interface_line_attribute3%TYPE DEFAULT NULL,

Line 40: p_vat_tax_id IN ra_customer_trx_lines_all.vat_tax_id%TYPE,

36: p_line_type IN ra_customer_trx_lines_all.line_type%TYPE,
37: p_org_id IN ra_customer_trx_lines_all.org_id%TYPE,
38: p_uom_code IN ra_customer_trx_lines_all.uom_code%TYPE,
39: p_autotax IN ra_customer_trx_lines_all.autotax%TYPE,
40: p_vat_tax_id IN ra_customer_trx_lines_all.vat_tax_id%TYPE,
41: p_interface_line_context IN ra_customer_trx_lines_all.interface_line_context%TYPE DEFAULT NULL,
42: p_interface_line_attribute6 IN ra_customer_trx_lines_all.interface_line_attribute6%TYPE DEFAULT NULL,
43: p_interface_line_attribute3 IN ra_customer_trx_lines_all.interface_line_attribute3%TYPE DEFAULT NULL,
44: p_process_status OUT NOCOPY VARCHAR2,

Line 41: p_interface_line_context IN ra_customer_trx_lines_all.interface_line_context%TYPE DEFAULT NULL,

37: p_org_id IN ra_customer_trx_lines_all.org_id%TYPE,
38: p_uom_code IN ra_customer_trx_lines_all.uom_code%TYPE,
39: p_autotax IN ra_customer_trx_lines_all.autotax%TYPE,
40: p_vat_tax_id IN ra_customer_trx_lines_all.vat_tax_id%TYPE,
41: p_interface_line_context IN ra_customer_trx_lines_all.interface_line_context%TYPE DEFAULT NULL,
42: p_interface_line_attribute6 IN ra_customer_trx_lines_all.interface_line_attribute6%TYPE DEFAULT NULL,
43: p_interface_line_attribute3 IN ra_customer_trx_lines_all.interface_line_attribute3%TYPE DEFAULT NULL,
44: p_process_status OUT NOCOPY VARCHAR2,
45: p_process_message OUT NOCOPY VARCHAR2);

Line 42: p_interface_line_attribute6 IN ra_customer_trx_lines_all.interface_line_attribute6%TYPE DEFAULT NULL,

38: p_uom_code IN ra_customer_trx_lines_all.uom_code%TYPE,
39: p_autotax IN ra_customer_trx_lines_all.autotax%TYPE,
40: p_vat_tax_id IN ra_customer_trx_lines_all.vat_tax_id%TYPE,
41: p_interface_line_context IN ra_customer_trx_lines_all.interface_line_context%TYPE DEFAULT NULL,
42: p_interface_line_attribute6 IN ra_customer_trx_lines_all.interface_line_attribute6%TYPE DEFAULT NULL,
43: p_interface_line_attribute3 IN ra_customer_trx_lines_all.interface_line_attribute3%TYPE DEFAULT NULL,
44: p_process_status OUT NOCOPY VARCHAR2,
45: p_process_message OUT NOCOPY VARCHAR2);
46:

Line 43: p_interface_line_attribute3 IN ra_customer_trx_lines_all.interface_line_attribute3%TYPE DEFAULT NULL,

39: p_autotax IN ra_customer_trx_lines_all.autotax%TYPE,
40: p_vat_tax_id IN ra_customer_trx_lines_all.vat_tax_id%TYPE,
41: p_interface_line_context IN ra_customer_trx_lines_all.interface_line_context%TYPE DEFAULT NULL,
42: p_interface_line_attribute6 IN ra_customer_trx_lines_all.interface_line_attribute6%TYPE DEFAULT NULL,
43: p_interface_line_attribute3 IN ra_customer_trx_lines_all.interface_line_attribute3%TYPE DEFAULT NULL,
44: p_process_status OUT NOCOPY VARCHAR2,
45: p_process_message OUT NOCOPY VARCHAR2);
46:
47: