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 17: --This procedure deletes the data from ra_cust_trx_line_gl_dist_all, ra_customer_trx_lines_all

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

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

17: --This procedure deletes the data from ra_cust_trx_line_gl_dist_all, ra_customer_trx_lines_all
18: --Also deletes the MRC data from ra_cust_trx_line_gl_dist
19: PROCEDURE delete_trx_data(
20: p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
21: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE DEFAULT NULL,
22: p_process_status OUT NOCOPY VARCHAR2,
23: p_process_message OUT NOCOPY VARCHAR2)
24: IS
25: BEGIN

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

26: null ;
27: END ;
28:
29:
30: --This procedure inserts the data into ra_customer_trx_lines_all
31: PROCEDURE insert_trx_lines(
32: p_extended_amount IN ra_customer_trx_lines_all.extended_amount%TYPE,
33: p_taxable_amount IN ra_customer_trx_lines_all.taxable_amount%TYPE,
34: p_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,

Line 32: p_extended_amount IN ra_customer_trx_lines_all.extended_amount%TYPE,

28:
29:
30: --This procedure inserts the data into ra_customer_trx_lines_all
31: PROCEDURE insert_trx_lines(
32: p_extended_amount IN ra_customer_trx_lines_all.extended_amount%TYPE,
33: p_taxable_amount IN ra_customer_trx_lines_all.taxable_amount%TYPE,
34: p_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,
35: p_last_update_date IN ra_customer_trx_lines_all.last_update_date%TYPE,
36: p_last_updated_by IN ra_customer_trx_lines_all.last_updated_by%TYPE,

Line 33: p_taxable_amount IN ra_customer_trx_lines_all.taxable_amount%TYPE,

29:
30: --This procedure inserts the data into ra_customer_trx_lines_all
31: PROCEDURE insert_trx_lines(
32: p_extended_amount IN ra_customer_trx_lines_all.extended_amount%TYPE,
33: p_taxable_amount IN ra_customer_trx_lines_all.taxable_amount%TYPE,
34: p_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,
35: p_last_update_date IN ra_customer_trx_lines_all.last_update_date%TYPE,
36: p_last_updated_by IN ra_customer_trx_lines_all.last_updated_by%TYPE,
37: p_creation_date IN ra_customer_trx_lines_all.creation_date%TYPE,

Line 34: p_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,

30: --This procedure inserts the data into ra_customer_trx_lines_all
31: PROCEDURE insert_trx_lines(
32: p_extended_amount IN ra_customer_trx_lines_all.extended_amount%TYPE,
33: p_taxable_amount IN ra_customer_trx_lines_all.taxable_amount%TYPE,
34: p_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,
35: p_last_update_date IN ra_customer_trx_lines_all.last_update_date%TYPE,
36: p_last_updated_by IN ra_customer_trx_lines_all.last_updated_by%TYPE,
37: p_creation_date IN ra_customer_trx_lines_all.creation_date%TYPE,
38: p_created_by IN ra_customer_trx_lines_all.created_by%TYPE,

Line 35: p_last_update_date IN ra_customer_trx_lines_all.last_update_date%TYPE,

31: PROCEDURE insert_trx_lines(
32: p_extended_amount IN ra_customer_trx_lines_all.extended_amount%TYPE,
33: p_taxable_amount IN ra_customer_trx_lines_all.taxable_amount%TYPE,
34: p_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,
35: p_last_update_date IN ra_customer_trx_lines_all.last_update_date%TYPE,
36: p_last_updated_by IN ra_customer_trx_lines_all.last_updated_by%TYPE,
37: p_creation_date IN ra_customer_trx_lines_all.creation_date%TYPE,
38: p_created_by IN ra_customer_trx_lines_all.created_by%TYPE,
39: p_last_update_login IN ra_customer_trx_lines_all.last_update_login%TYPE,

Line 36: p_last_updated_by IN ra_customer_trx_lines_all.last_updated_by%TYPE,

32: p_extended_amount IN ra_customer_trx_lines_all.extended_amount%TYPE,
33: p_taxable_amount IN ra_customer_trx_lines_all.taxable_amount%TYPE,
34: p_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,
35: p_last_update_date IN ra_customer_trx_lines_all.last_update_date%TYPE,
36: p_last_updated_by IN ra_customer_trx_lines_all.last_updated_by%TYPE,
37: p_creation_date IN ra_customer_trx_lines_all.creation_date%TYPE,
38: p_created_by IN ra_customer_trx_lines_all.created_by%TYPE,
39: p_last_update_login IN ra_customer_trx_lines_all.last_update_login%TYPE,
40: p_customer_trx_id IN ra_customer_trx_lines_all.customer_trx_id%TYPE,

Line 37: p_creation_date IN ra_customer_trx_lines_all.creation_date%TYPE,

33: p_taxable_amount IN ra_customer_trx_lines_all.taxable_amount%TYPE,
34: p_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,
35: p_last_update_date IN ra_customer_trx_lines_all.last_update_date%TYPE,
36: p_last_updated_by IN ra_customer_trx_lines_all.last_updated_by%TYPE,
37: p_creation_date IN ra_customer_trx_lines_all.creation_date%TYPE,
38: p_created_by IN ra_customer_trx_lines_all.created_by%TYPE,
39: p_last_update_login IN ra_customer_trx_lines_all.last_update_login%TYPE,
40: p_customer_trx_id IN ra_customer_trx_lines_all.customer_trx_id%TYPE,
41: p_line_number IN ra_customer_trx_lines_all.line_number%TYPE,

Line 38: p_created_by IN ra_customer_trx_lines_all.created_by%TYPE,

34: p_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,
35: p_last_update_date IN ra_customer_trx_lines_all.last_update_date%TYPE,
36: p_last_updated_by IN ra_customer_trx_lines_all.last_updated_by%TYPE,
37: p_creation_date IN ra_customer_trx_lines_all.creation_date%TYPE,
38: p_created_by IN ra_customer_trx_lines_all.created_by%TYPE,
39: p_last_update_login IN ra_customer_trx_lines_all.last_update_login%TYPE,
40: p_customer_trx_id IN ra_customer_trx_lines_all.customer_trx_id%TYPE,
41: p_line_number IN ra_customer_trx_lines_all.line_number%TYPE,
42: p_set_of_books_id IN ra_customer_trx_lines_all.set_of_books_id%TYPE,

Line 39: p_last_update_login IN ra_customer_trx_lines_all.last_update_login%TYPE,

35: p_last_update_date IN ra_customer_trx_lines_all.last_update_date%TYPE,
36: p_last_updated_by IN ra_customer_trx_lines_all.last_updated_by%TYPE,
37: p_creation_date IN ra_customer_trx_lines_all.creation_date%TYPE,
38: p_created_by IN ra_customer_trx_lines_all.created_by%TYPE,
39: p_last_update_login IN ra_customer_trx_lines_all.last_update_login%TYPE,
40: p_customer_trx_id IN ra_customer_trx_lines_all.customer_trx_id%TYPE,
41: p_line_number IN ra_customer_trx_lines_all.line_number%TYPE,
42: p_set_of_books_id IN ra_customer_trx_lines_all.set_of_books_id%TYPE,
43: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE,

Line 40: p_customer_trx_id IN ra_customer_trx_lines_all.customer_trx_id%TYPE,

36: p_last_updated_by IN ra_customer_trx_lines_all.last_updated_by%TYPE,
37: p_creation_date IN ra_customer_trx_lines_all.creation_date%TYPE,
38: p_created_by IN ra_customer_trx_lines_all.created_by%TYPE,
39: p_last_update_login IN ra_customer_trx_lines_all.last_update_login%TYPE,
40: p_customer_trx_id IN ra_customer_trx_lines_all.customer_trx_id%TYPE,
41: p_line_number IN ra_customer_trx_lines_all.line_number%TYPE,
42: p_set_of_books_id IN ra_customer_trx_lines_all.set_of_books_id%TYPE,
43: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE,
44: p_line_type IN ra_customer_trx_lines_all.line_type%TYPE,

Line 41: p_line_number IN ra_customer_trx_lines_all.line_number%TYPE,

37: p_creation_date IN ra_customer_trx_lines_all.creation_date%TYPE,
38: p_created_by IN ra_customer_trx_lines_all.created_by%TYPE,
39: p_last_update_login IN ra_customer_trx_lines_all.last_update_login%TYPE,
40: p_customer_trx_id IN ra_customer_trx_lines_all.customer_trx_id%TYPE,
41: p_line_number IN ra_customer_trx_lines_all.line_number%TYPE,
42: p_set_of_books_id IN ra_customer_trx_lines_all.set_of_books_id%TYPE,
43: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE,
44: p_line_type IN ra_customer_trx_lines_all.line_type%TYPE,
45: p_org_id IN ra_customer_trx_lines_all.org_id%TYPE,

Line 42: p_set_of_books_id IN ra_customer_trx_lines_all.set_of_books_id%TYPE,

38: p_created_by IN ra_customer_trx_lines_all.created_by%TYPE,
39: p_last_update_login IN ra_customer_trx_lines_all.last_update_login%TYPE,
40: p_customer_trx_id IN ra_customer_trx_lines_all.customer_trx_id%TYPE,
41: p_line_number IN ra_customer_trx_lines_all.line_number%TYPE,
42: p_set_of_books_id IN ra_customer_trx_lines_all.set_of_books_id%TYPE,
43: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE,
44: p_line_type IN ra_customer_trx_lines_all.line_type%TYPE,
45: p_org_id IN ra_customer_trx_lines_all.org_id%TYPE,
46: p_uom_code IN ra_customer_trx_lines_all.uom_code%TYPE,

Line 43: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE,

39: p_last_update_login IN ra_customer_trx_lines_all.last_update_login%TYPE,
40: p_customer_trx_id IN ra_customer_trx_lines_all.customer_trx_id%TYPE,
41: p_line_number IN ra_customer_trx_lines_all.line_number%TYPE,
42: p_set_of_books_id IN ra_customer_trx_lines_all.set_of_books_id%TYPE,
43: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE,
44: p_line_type IN ra_customer_trx_lines_all.line_type%TYPE,
45: p_org_id IN ra_customer_trx_lines_all.org_id%TYPE,
46: p_uom_code IN ra_customer_trx_lines_all.uom_code%TYPE,
47: p_autotax IN ra_customer_trx_lines_all.autotax%TYPE,

Line 44: p_line_type IN ra_customer_trx_lines_all.line_type%TYPE,

40: p_customer_trx_id IN ra_customer_trx_lines_all.customer_trx_id%TYPE,
41: p_line_number IN ra_customer_trx_lines_all.line_number%TYPE,
42: p_set_of_books_id IN ra_customer_trx_lines_all.set_of_books_id%TYPE,
43: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE,
44: p_line_type IN ra_customer_trx_lines_all.line_type%TYPE,
45: p_org_id IN ra_customer_trx_lines_all.org_id%TYPE,
46: p_uom_code IN ra_customer_trx_lines_all.uom_code%TYPE,
47: p_autotax IN ra_customer_trx_lines_all.autotax%TYPE,
48: p_vat_tax_id IN ra_customer_trx_lines_all.vat_tax_id%TYPE,

Line 45: p_org_id IN ra_customer_trx_lines_all.org_id%TYPE,

41: p_line_number IN ra_customer_trx_lines_all.line_number%TYPE,
42: p_set_of_books_id IN ra_customer_trx_lines_all.set_of_books_id%TYPE,
43: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE,
44: p_line_type IN ra_customer_trx_lines_all.line_type%TYPE,
45: p_org_id IN ra_customer_trx_lines_all.org_id%TYPE,
46: p_uom_code IN ra_customer_trx_lines_all.uom_code%TYPE,
47: p_autotax IN ra_customer_trx_lines_all.autotax%TYPE,
48: p_vat_tax_id IN ra_customer_trx_lines_all.vat_tax_id%TYPE,
49: p_interface_line_context IN ra_customer_trx_lines_all.interface_line_context%TYPE DEFAULT NULL,

Line 46: p_uom_code IN ra_customer_trx_lines_all.uom_code%TYPE,

42: p_set_of_books_id IN ra_customer_trx_lines_all.set_of_books_id%TYPE,
43: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE,
44: p_line_type IN ra_customer_trx_lines_all.line_type%TYPE,
45: p_org_id IN ra_customer_trx_lines_all.org_id%TYPE,
46: p_uom_code IN ra_customer_trx_lines_all.uom_code%TYPE,
47: p_autotax IN ra_customer_trx_lines_all.autotax%TYPE,
48: p_vat_tax_id IN ra_customer_trx_lines_all.vat_tax_id%TYPE,
49: p_interface_line_context IN ra_customer_trx_lines_all.interface_line_context%TYPE DEFAULT NULL,
50: p_interface_line_attribute6 IN ra_customer_trx_lines_all.interface_line_attribute6%TYPE DEFAULT NULL,

Line 47: p_autotax IN ra_customer_trx_lines_all.autotax%TYPE,

43: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE,
44: p_line_type IN ra_customer_trx_lines_all.line_type%TYPE,
45: p_org_id IN ra_customer_trx_lines_all.org_id%TYPE,
46: p_uom_code IN ra_customer_trx_lines_all.uom_code%TYPE,
47: p_autotax IN ra_customer_trx_lines_all.autotax%TYPE,
48: p_vat_tax_id IN ra_customer_trx_lines_all.vat_tax_id%TYPE,
49: p_interface_line_context IN ra_customer_trx_lines_all.interface_line_context%TYPE DEFAULT NULL,
50: p_interface_line_attribute6 IN ra_customer_trx_lines_all.interface_line_attribute6%TYPE DEFAULT NULL,
51: p_interface_line_attribute3 IN ra_customer_trx_lines_all.interface_line_attribute3%TYPE DEFAULT NULL,

Line 48: p_vat_tax_id IN ra_customer_trx_lines_all.vat_tax_id%TYPE,

44: p_line_type IN ra_customer_trx_lines_all.line_type%TYPE,
45: p_org_id IN ra_customer_trx_lines_all.org_id%TYPE,
46: p_uom_code IN ra_customer_trx_lines_all.uom_code%TYPE,
47: p_autotax IN ra_customer_trx_lines_all.autotax%TYPE,
48: p_vat_tax_id IN ra_customer_trx_lines_all.vat_tax_id%TYPE,
49: p_interface_line_context IN ra_customer_trx_lines_all.interface_line_context%TYPE DEFAULT NULL,
50: p_interface_line_attribute6 IN ra_customer_trx_lines_all.interface_line_attribute6%TYPE DEFAULT NULL,
51: p_interface_line_attribute3 IN ra_customer_trx_lines_all.interface_line_attribute3%TYPE DEFAULT NULL,
52: p_process_status OUT NOCOPY VARCHAR2,

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

45: p_org_id IN ra_customer_trx_lines_all.org_id%TYPE,
46: p_uom_code IN ra_customer_trx_lines_all.uom_code%TYPE,
47: p_autotax IN ra_customer_trx_lines_all.autotax%TYPE,
48: p_vat_tax_id IN ra_customer_trx_lines_all.vat_tax_id%TYPE,
49: p_interface_line_context IN ra_customer_trx_lines_all.interface_line_context%TYPE DEFAULT NULL,
50: p_interface_line_attribute6 IN ra_customer_trx_lines_all.interface_line_attribute6%TYPE DEFAULT NULL,
51: p_interface_line_attribute3 IN ra_customer_trx_lines_all.interface_line_attribute3%TYPE DEFAULT NULL,
52: p_process_status OUT NOCOPY VARCHAR2,
53: p_process_message OUT NOCOPY VARCHAR2)

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

46: p_uom_code IN ra_customer_trx_lines_all.uom_code%TYPE,
47: p_autotax IN ra_customer_trx_lines_all.autotax%TYPE,
48: p_vat_tax_id IN ra_customer_trx_lines_all.vat_tax_id%TYPE,
49: p_interface_line_context IN ra_customer_trx_lines_all.interface_line_context%TYPE DEFAULT NULL,
50: p_interface_line_attribute6 IN ra_customer_trx_lines_all.interface_line_attribute6%TYPE DEFAULT NULL,
51: p_interface_line_attribute3 IN ra_customer_trx_lines_all.interface_line_attribute3%TYPE DEFAULT NULL,
52: p_process_status OUT NOCOPY VARCHAR2,
53: p_process_message OUT NOCOPY VARCHAR2)
54: IS

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

47: p_autotax IN ra_customer_trx_lines_all.autotax%TYPE,
48: p_vat_tax_id IN ra_customer_trx_lines_all.vat_tax_id%TYPE,
49: p_interface_line_context IN ra_customer_trx_lines_all.interface_line_context%TYPE DEFAULT NULL,
50: p_interface_line_attribute6 IN ra_customer_trx_lines_all.interface_line_attribute6%TYPE DEFAULT NULL,
51: p_interface_line_attribute3 IN ra_customer_trx_lines_all.interface_line_attribute3%TYPE DEFAULT NULL,
52: p_process_status OUT NOCOPY VARCHAR2,
53: p_process_message OUT NOCOPY VARCHAR2)
54: IS
55: BEGIN