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.ARP_CT_PKG dependencies on RA_CUSTOMER_TRX

Line 46: | p_trx_rec - ra_customer_trx record |

42: | arp_util.debug |
43: | |
44: | ARGUMENTS : IN: |
45: | p_update_cursor - ID of the update cursor |
46: | p_trx_rec - ra_customer_trx record |
47: | OUT: |
48: | None |
49: | |
50: | RETURNS : NONE |

Line 84: p_trx_rec IN ra_customer_trx%rowtype) IS

80: +===========================================================================*/
81:
82:
83: PROCEDURE bind_trx_variables(p_update_cursor IN integer,
84: p_trx_rec IN ra_customer_trx%rowtype) IS
85:
86: BEGIN
87:
88: arp_util.debug('arp_ct_pkg.bind_trx_variables()+');

Line 699: 'UPDATE ra_customer_trx

695: BEGIN
696: arp_util.debug('arp_ct_pkg.construct_trx_update_stmt()+');
697:
698: update_text :=
699: 'UPDATE ra_customer_trx
700: SET customer_trx_id =
701: DECODE(:customer_trx_id,
702: :ar_number_dummy, customer_trx_id,
703: :customer_trx_id),

Line 1435: | This procedure Updates records in ra_customer_trx identified by the |

1431: | PROCEDURE |
1432: | generic_update |
1433: | |
1434: | DESCRIPTION |
1435: | This procedure Updates records in ra_customer_trx identified by the |
1436: | where clause that is passed in as a parameter. Only those columns in |
1437: | the trx record parameter that do not contain the special dummy values |
1438: | are updated. |
1439: | |

Line 1464: | RA_CUSTOMER_TRX processing |

1460: | |
1461: | MODIFICATION HISTORY |
1462: | 06-JUN-95 Charlie Tomberg Created |
1463: | 08-NOV-01 Debbie Jancis Added calls to MRC engine for |
1464: | RA_CUSTOMER_TRX processing |
1465: | |
1466: +===========================================================================*/
1467:
1468: PROCEDURE generic_update(p_update_cursor IN OUT NOCOPY integer,

Line 1471: p_trx_rec IN ra_customer_trx%rowtype) IS

1467:
1468: PROCEDURE generic_update(p_update_cursor IN OUT NOCOPY integer,
1469: p_where_clause IN varchar2,
1470: p_where1 IN number,
1471: p_trx_rec IN ra_customer_trx%rowtype) IS
1472:
1473: l_count number;
1474: l_update_statement_1 varchar2(30000);
1475: l_update_statement_2 varchar2(30000);

Line 1564: -- p_table_name => 'RA_CUSTOMER_TRX',

1560: | call mrc engine to update RA_MC_CUSTOMER_TRX |
1561: +------------------------------------------------*/
1562: -- ar_mrc_engine.maintain_mrc_data(
1563: -- p_event_mode => 'UPDATE',
1564: -- p_table_name => 'RA_CUSTOMER_TRX',
1565: -- p_mode => 'SINGLE',
1566: -- p_key_value => ctrx_array(I));
1567: -- END LOOP;
1568:

Line 1638: PROCEDURE set_to_dummy( p_trx_rec OUT NOCOPY ra_customer_trx%rowtype) IS

1634: | into the table handlers. |
1635: | 20-Jun-2002 Sahana Bug2427456 : Added Global Attribute Columns |
1636: +===========================================================================*/
1637:
1638: PROCEDURE set_to_dummy( p_trx_rec OUT NOCOPY ra_customer_trx%rowtype) IS
1639:
1640: BEGIN
1641:
1642: arp_util.debug('arp_ct_pkg.set_to_dummy()+');

Line 1831: | This procedure locks the ra_customer_trx row identified by the |

1827: | PROCEDURE |
1828: | lock_p |
1829: | |
1830: | DESCRIPTION |
1831: | This procedure locks the ra_customer_trx row identified by the |
1832: | p_customer_trx_id parameter. |
1833: | |
1834: | SCOPE - PUBLIC |
1835: | |

Line 1853: PROCEDURE lock_p( p_customer_trx_id IN ra_customer_trx.customer_trx_id%type )

1849: | 07-JUN-95 Charlie Tomberg Created |
1850: | |
1851: +===========================================================================*/
1852:
1853: PROCEDURE lock_p( p_customer_trx_id IN ra_customer_trx.customer_trx_id%type )
1854: IS
1855:
1856: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
1857:

Line 1856: l_customer_trx_id ra_customer_trx.customer_trx_id%type;

1852:
1853: PROCEDURE lock_p( p_customer_trx_id IN ra_customer_trx.customer_trx_id%type )
1854: IS
1855:
1856: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
1857:
1858: BEGIN
1859: arp_util.debug('arp_ct_pkg.lock_p()+');
1860:

Line 1864: FROM ra_customer_trx

1860:
1861:
1862: SELECT customer_trx_id
1863: INTO l_customer_trx_id
1864: FROM ra_customer_trx
1865: WHERE customer_trx_id = p_customer_trx_id
1866: FOR UPDATE OF customer_trx_id NOWAIT;
1867:
1868: arp_util.debug('arp_ct_pkg.lock_p()-');

Line 1881: | This procedure locks the ra_customer_trx row identified by the |

1877: | PROCEDURE |
1878: | lock_fetch_p |
1879: | |
1880: | DESCRIPTION |
1881: | This procedure locks the ra_customer_trx row identified by the |
1882: | p_ra_customer_trx parameter and populates the p_trx_rec parameter with |
1883: | the row that was locked. |
1884: | |
1885: | SCOPE - PUBLIC |

Line 1882: | p_ra_customer_trx parameter and populates the p_trx_rec parameter with |

1878: | lock_fetch_p |
1879: | |
1880: | DESCRIPTION |
1881: | This procedure locks the ra_customer_trx row identified by the |
1882: | p_ra_customer_trx parameter and populates the p_trx_rec parameter with |
1883: | the row that was locked. |
1884: | |
1885: | SCOPE - PUBLIC |
1886: | |

Line 1904: PROCEDURE lock_fetch_p( p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,

1900: | 07-JUN-95 Charlie Tomberg Created |
1901: | |
1902: +===========================================================================*/
1903:
1904: PROCEDURE lock_fetch_p( p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,
1905: p_customer_trx_id IN
1906: ra_customer_trx.customer_trx_id%type ) IS
1907:
1908: BEGIN

Line 1906: ra_customer_trx.customer_trx_id%type ) IS

1902: +===========================================================================*/
1903:
1904: PROCEDURE lock_fetch_p( p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,
1905: p_customer_trx_id IN
1906: ra_customer_trx.customer_trx_id%type ) IS
1907:
1908: BEGIN
1909: arp_util.debug('arp_ct_pkg.lock_fetch_p()+');
1910:

Line 1913: FROM ra_customer_trx

1909: arp_util.debug('arp_ct_pkg.lock_fetch_p()+');
1910:
1911: SELECT *
1912: INTO p_trx_rec
1913: FROM ra_customer_trx
1914: WHERE customer_trx_id = p_customer_trx_id
1915: FOR UPDATE OF customer_trx_id NOWAIT;
1916:
1917: arp_util.debug('arp_ct_pkg.lock_fetch_p()-');

Line 1930: | This procedure locks the ra_customer_trx row identified by the |

1926: | PROCEDURE |
1927: | lock_compare_p |
1928: | |
1929: | DESCRIPTION |
1930: | This procedure locks the ra_customer_trx row identified by the |
1931: | p_customer_trx_id parameter only if no columns in that row have |
1932: | changed from when they were first selected in the form. |
1933: | |
1934: | SCOPE - PUBLIC |

Line 1980: PROCEDURE lock_compare_p( p_trx_rec IN ra_customer_trx%rowtype,

1976: | 18-May-2005 Debbie Jancis Added Legal entity Id for LE project |
1977: | 09-Aug-2005 Surendra Rajan Added payment_trxn_extension_id |
1978: +============================================================================*/
1979:
1980: PROCEDURE lock_compare_p( p_trx_rec IN ra_customer_trx%rowtype,
1981: p_customer_trx_id IN
1982: ra_customer_trx.customer_trx_id%type,
1983: p_lock_trx_flag IN BOOLEAN DEFAULT TRUE) IS
1984:

Line 1982: ra_customer_trx.customer_trx_id%type,

1978: +============================================================================*/
1979:
1980: PROCEDURE lock_compare_p( p_trx_rec IN ra_customer_trx%rowtype,
1981: p_customer_trx_id IN
1982: ra_customer_trx.customer_trx_id%type,
1983: p_lock_trx_flag IN BOOLEAN DEFAULT TRUE) IS
1984:
1985: l_new_trx_rec ra_customer_trx%rowtype;
1986:

Line 1985: l_new_trx_rec ra_customer_trx%rowtype;

1981: p_customer_trx_id IN
1982: ra_customer_trx.customer_trx_id%type,
1983: p_lock_trx_flag IN BOOLEAN DEFAULT TRUE) IS
1984:
1985: l_new_trx_rec ra_customer_trx%rowtype;
1986:
1987: BEGIN
1988: arp_util.debug('arp_ct_pkg.lock_compare_p()+');
1989:

Line 1993: FROM ra_customer_trx trx

1989:
1990: IF p_lock_trx_flag THEN
1991: SELECT *
1992: INTO l_new_trx_rec
1993: FROM ra_customer_trx trx
1994: WHERE trx.customer_trx_id = p_customer_trx_id
1995: AND
1996: (
1997: NVL(trx.trx_number, AR_TEXT_DUMMY) =

Line 3336: FROM ra_customer_trx trx

3332: FOR UPDATE OF customer_trx_id NOWAIT;
3333: ELSE
3334: SELECT *
3335: INTO l_new_trx_rec
3336: FROM ra_customer_trx trx
3337: WHERE trx.customer_trx_id = p_customer_trx_id
3338: AND
3339: (
3340: NVL(trx.trx_number, AR_TEXT_DUMMY) =

Line 4702: | This procedure fetches a single row from ra_customer_trx into a |

4698: | PROCEDURE |
4699: | fetch_p |
4700: | |
4701: | DESCRIPTION |
4702: | This procedure fetches a single row from ra_customer_trx into a |
4703: | variable specified as a parameter based on the table's primary key, |
4704: | customer_trx_id. |
4705: | |
4706: | SCOPE - PUBLIC |

Line 4725: PROCEDURE fetch_p( p_trx_rec OUT NOCOPY ra_customer_trx%rowtype,

4721: | 07-JUN-95 Charlie Tomberg Created |
4722: | |
4723: +===========================================================================*/
4724:
4725: PROCEDURE fetch_p( p_trx_rec OUT NOCOPY ra_customer_trx%rowtype,
4726: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type )
4727: IS
4728:
4729: BEGIN

Line 4726: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type )

4722: | |
4723: +===========================================================================*/
4724:
4725: PROCEDURE fetch_p( p_trx_rec OUT NOCOPY ra_customer_trx%rowtype,
4726: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type )
4727: IS
4728:
4729: BEGIN
4730: arp_util.debug('arp_ct_pkg.fetch_p()+');

Line 4734: FROM ra_customer_trx

4730: arp_util.debug('arp_ct_pkg.fetch_p()+');
4731:
4732: SELECT *
4733: INTO p_trx_rec
4734: FROM ra_customer_trx
4735: WHERE customer_trx_id = p_customer_trx_id;
4736:
4737: arp_util.debug('arp_ct_pkg.fetch_p()-');
4738:

Line 4750: | This procedure deletes the ra_customeR_trx row identified by the |

4746: | PROCEDURE |
4747: | delete_p |
4748: | |
4749: | DESCRIPTION |
4750: | This procedure deletes the ra_customeR_trx row identified by the |
4751: | p_customer_trx_id parameter. |
4752: | |
4753: | SCOPE - PUBLIC |
4754: | |

Line 4770: | RA_CUSTOMER_TRX processing |

4766: | |
4767: | MODIFICATION HISTORY |
4768: | 07-JUN-95 Charlie Tomberg Created |
4769: | 08-NOV-01 Debbie Jancis Added calls to MRC engine for |
4770: | RA_CUSTOMER_TRX processing |
4771: | |
4772: +===========================================================================*/
4773:
4774: procedure delete_p( p_customer_trx_id IN ra_customer_trx.customer_trx_id%type)

Line 4774: procedure delete_p( p_customer_trx_id IN ra_customer_trx.customer_trx_id%type)

4770: | RA_CUSTOMER_TRX processing |
4771: | |
4772: +===========================================================================*/
4773:
4774: procedure delete_p( p_customer_trx_id IN ra_customer_trx.customer_trx_id%type)
4775: IS
4776:
4777:
4778: BEGIN

Line 4783: DELETE FROM ra_customer_trx

4779:
4780:
4781: arp_util.debug('arp_ct_pkg.delete_p()+');
4782:
4783: DELETE FROM ra_customer_trx
4784: WHERE customer_trx_id = p_customer_trx_id;
4785:
4786: /*---------------------------------+
4787: | Calling central MRC library |

Line 4793: -- p_table_name => 'RA_CUSTOMER_TRX',

4789: +---------------------------------*/
4790: --{BUG4301323
4791: -- ar_mrc_engine.maintain_mrc_data(
4792: -- p_event_mode => 'DELETE',
4793: -- p_table_name => 'RA_CUSTOMER_TRX',
4794: -- p_mode => 'SINGLE',
4795: -- p_key_value => p_customer_trx_id);
4796: --}
4797: --

Line 4813: | This procedure updates the ra_customer_trx row identified by the |

4809: | PROCEDURE |
4810: | update_p |
4811: | |
4812: | DESCRIPTION |
4813: | This procedure updates the ra_customer_trx row identified by the |
4814: | p_customer_trx_id parameter. |
4815: | |
4816: | SCOPE - PUBLIC |
4817: | |

Line 4838: PROCEDURE update_p( p_trx_rec IN ra_customer_trx%rowtype,

4834: | 06-JUN-95 Charlie Tomberg Created |
4835: | |
4836: +===========================================================================*/
4837:
4838: PROCEDURE update_p( p_trx_rec IN ra_customer_trx%rowtype,
4839: p_customer_trx_id IN
4840: ra_customer_trx.customer_trx_id%type) IS
4841:
4842: --2528261 begin

Line 4840: ra_customer_trx.customer_trx_id%type) IS

4836: +===========================================================================*/
4837:
4838: PROCEDURE update_p( p_trx_rec IN ra_customer_trx%rowtype,
4839: p_customer_trx_id IN
4840: ra_customer_trx.customer_trx_id%type) IS
4841:
4842: --2528261 begin
4843: l_ct_reference varchar2(150);
4844: --2528261 end

Line 4887: update ra_customer_trx

4883: when others then
4884: l_ct_reference:=null;
4885: end;
4886: --Bug 11066991
4887: update ra_customer_trx
4888: set ct_reference =l_ct_reference
4889: where customer_trx_id = p_trx_rec.customer_trx_id;
4890:
4891:

Line 4907: | This procedure updates the ra_customer_trx row identified by the |

4903: | PROCEDURE |
4904: | update_p_print |
4905: | |
4906: | DESCRIPTION |
4907: | This procedure updates the ra_customer_trx row identified by the |
4908: | p_customer_trx_id parameter. It calls update_p, then
4909: | arp_etax_util.global_document_update. |
4910: | |
4911: | SCOPE - PUBLIC |

Line 4928: | updating the ra_customer_trx.print-related fields to

Line 4936: PROCEDURE update_p_print( p_trx_rec IN ra_customer_trx%rowtype,

4932: | 24-JAN-06 M Raymond Created |
4933: | |
4934: +===========================================================================*/
4935:
4936: PROCEDURE update_p_print( p_trx_rec IN ra_customer_trx%rowtype,
4937: p_customer_trx_id IN
4938: ra_customer_trx.customer_trx_id%type) IS
4939: BEGIN
4940: /* Call update_p to carry out the actual update */

Line 4938: ra_customer_trx.customer_trx_id%type) IS

4934: +===========================================================================*/
4935:
4936: PROCEDURE update_p_print( p_trx_rec IN ra_customer_trx%rowtype,
4937: p_customer_trx_id IN
4938: ra_customer_trx.customer_trx_id%type) IS
4939: BEGIN
4940: /* Call update_p to carry out the actual update */
4941: update_p(p_trx_rec, p_customer_trx_id);
4942:

Line 4960: | This procedure inserts a row into ra_customer_trx that contains the |

4956: | PROCEDURE |
4957: | insert_p |
4958: | |
4959: | DESCRIPTION |
4960: | This procedure inserts a row into ra_customer_trx that contains the |
4961: | column values specified in the p_trx_rec parameter. |
4962: | |
4963: | SCOPE - PUBLIC |
4964: | |

Line 5008: | RA_CUSTOMER_TRX processing |

5004: | 6-Jul-2001 yreddy Bug1738914 - Added 'Copy doc num to |
5005: | Trx Number' |
5006: | functionality for chargebacks. |
5007: | 08-NOV-01 Debbie Jancis Added calls to MRC engine for |
5008: | RA_CUSTOMER_TRX processing |
5009: | |
5010: | 20-Jun-02 Sahana Bug2427456: Added global attribute columns |
5011: | 18-May-05 Debbie Jancis Added Legal Entity ID for LE project |
5012: +===========================================================================*/

Line 5015: p_trx_rec IN ra_customer_trx%rowtype,

5011: | 18-May-05 Debbie Jancis Added Legal Entity ID for LE project |
5012: +===========================================================================*/
5013:
5014: PROCEDURE insert_p(
5015: p_trx_rec IN ra_customer_trx%rowtype,
5016: p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,
5017: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type
5018: ) IS
5019:

Line 5016: p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,

5012: +===========================================================================*/
5013:
5014: PROCEDURE insert_p(
5015: p_trx_rec IN ra_customer_trx%rowtype,
5016: p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,
5017: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type
5018: ) IS
5019:
5020:

Line 5017: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type

5013:
5014: PROCEDURE insert_p(
5015: p_trx_rec IN ra_customer_trx%rowtype,
5016: p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,
5017: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type
5018: ) IS
5019:
5020:
5021: l_customer_trx_id ra_customer_trx.customer_trx_id%type;

Line 5021: l_customer_trx_id ra_customer_trx.customer_trx_id%type;

5017: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type
5018: ) IS
5019:
5020:
5021: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
5022: l_org_id integer;
5023: l_org_str varchar2(30);
5024: l_trx_num_cursor integer;
5025: l_dummy integer;

Line 5026: l_trx_number ra_customer_trx.trx_number%type;

5022: l_org_id integer;
5023: l_org_str varchar2(30);
5024: l_trx_num_cursor integer;
5025: l_dummy integer;
5026: l_trx_number ra_customer_trx.trx_number%type;
5027: l_trx_str VARCHAR2(1000);
5028: l_copy_doc_number_flag varchar2(1):='N'; --Bug1738914
5029: l_old_trx_number ra_customer_trx.old_trx_number%type; --Bug1738914
5030: l_ct_reference varchar2(150);

Line 5029: l_old_trx_number ra_customer_trx.old_trx_number%type; --Bug1738914

5025: l_dummy integer;
5026: l_trx_number ra_customer_trx.trx_number%type;
5027: l_trx_str VARCHAR2(1000);
5028: l_copy_doc_number_flag varchar2(1):='N'; --Bug1738914
5029: l_old_trx_number ra_customer_trx.old_trx_number%type; --Bug1738914
5030: l_ct_reference varchar2(150);
5031: l_legal_entity_id number;
5032:
5033: BEGIN

Line 5059: SELECT RA_CUSTOMER_TRX_S.NEXTVAL

5055: /*---------------------------*
5056: | Get the unique identifier |
5057: *---------------------------*/
5058:
5059: SELECT RA_CUSTOMER_TRX_S.NEXTVAL
5060: INTO l_customer_trx_id
5061: FROM DUAL;
5062:
5063: /*----------------------------*

Line 5171: INSERT INTO ra_customer_trx

5167: /*-------------------*
5168: | Insert the record |
5169: *-------------------*/
5170:
5171: INSERT INTO ra_customer_trx
5172: (
5173: customer_trx_id,
5174: trx_number,
5175: created_by,

Line 5527: -- p_table_name => 'RA_CUSTOMER_TRX',

5523: +---------------------------------*/
5524: --{BUG4301323
5525: -- ar_mrc_engine.maintain_mrc_data(
5526: -- p_event_mode => 'INSERT',
5527: -- p_table_name => 'RA_CUSTOMER_TRX',
5528: -- p_mode => 'SINGLE',
5529: -- p_key_value => l_customer_trx_id);
5530: --}
5531:

Line 5571: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type) IS

5567: | |
5568: +===========================================================================*/
5569:
5570: PROCEDURE display_header_p(
5571: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type) IS
5572:
5573: l_trx_rec ra_customer_trx%rowtype;
5574:
5575: BEGIN

Line 5573: l_trx_rec ra_customer_trx%rowtype;

5569:
5570: PROCEDURE display_header_p(
5571: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type) IS
5572:
5573: l_trx_rec ra_customer_trx%rowtype;
5574:
5575: BEGIN
5576:
5577: arp_util.debug('arp_ct_pkg.display_header_p()+');

Line 5639: PROCEDURE display_header_rec ( p_trx_rec IN ra_customer_trx%rowtype ) IS

5635: | wh_update_date |
5636: | into the table handlers. |
5637: +==========================================================================*/
5638:
5639: PROCEDURE display_header_rec ( p_trx_rec IN ra_customer_trx%rowtype ) IS
5640:
5641: BEGIN
5642:
5643: arp_util.debug('arp_ct_pkg.display_header_rec()+');

Line 5645: arp_util.debug(' Dump of ra_customer_trx record ');

5641: BEGIN
5642:
5643: arp_util.debug('arp_ct_pkg.display_header_rec()+');
5644:
5645: arp_util.debug('************ Dump of ra_customer_trx record ************');
5646: arp_util.debug('customer_trx_id: ' || p_trx_rec.customer_trx_id);
5647: arp_util.debug('trx_number: ' || p_trx_rec.trx_number);
5648: arp_util.debug('created_by: ' || p_trx_rec.created_by);
5649: arp_util.debug('last_updated_by: ' || p_trx_rec.last_updated_by);

Line 5852: arp_util.debug('* End ra_customer_trx record *');

5848: arp_util.debug('legal_entity_id: ' || to_char(p_trx_rec.legal_entity_id));
5849: arp_util.debug('payment_trxn_extension_id: ' || to_char(p_trx_rec.payment_trxn_extension_id));
5850: arp_util.debug('billing_date: ' || p_trx_rec.billing_date);
5851:
5852: arp_util.debug('************* End ra_customer_trx record *************');
5853:
5854: arp_util.debug('arp_ct_pkg.display_header_rec()-');
5855:
5856: EXCEPTION

Line 5896: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

5892: | 15-OCT-95 Subash Chadalavada Created |
5893: | |
5894: +===========================================================================*/
5895: PROCEDURE lock_compare_frt_cover(
5896: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
5897: p_ship_via IN ra_customer_trx.ship_via%type,
5898: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
5899: p_waybill_number IN ra_customer_trx.waybill_number%type,
5900: p_fob_point IN ra_customer_trx.fob_point%type)

Line 5897: p_ship_via IN ra_customer_trx.ship_via%type,

5893: | |
5894: +===========================================================================*/
5895: PROCEDURE lock_compare_frt_cover(
5896: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
5897: p_ship_via IN ra_customer_trx.ship_via%type,
5898: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
5899: p_waybill_number IN ra_customer_trx.waybill_number%type,
5900: p_fob_point IN ra_customer_trx.fob_point%type)
5901: IS

Line 5898: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,

5894: +===========================================================================*/
5895: PROCEDURE lock_compare_frt_cover(
5896: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
5897: p_ship_via IN ra_customer_trx.ship_via%type,
5898: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
5899: p_waybill_number IN ra_customer_trx.waybill_number%type,
5900: p_fob_point IN ra_customer_trx.fob_point%type)
5901: IS
5902: l_trx_rec ra_customer_trx%rowtype;

Line 5899: p_waybill_number IN ra_customer_trx.waybill_number%type,

5895: PROCEDURE lock_compare_frt_cover(
5896: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
5897: p_ship_via IN ra_customer_trx.ship_via%type,
5898: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
5899: p_waybill_number IN ra_customer_trx.waybill_number%type,
5900: p_fob_point IN ra_customer_trx.fob_point%type)
5901: IS
5902: l_trx_rec ra_customer_trx%rowtype;
5903: BEGIN

Line 5900: p_fob_point IN ra_customer_trx.fob_point%type)

5896: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
5897: p_ship_via IN ra_customer_trx.ship_via%type,
5898: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
5899: p_waybill_number IN ra_customer_trx.waybill_number%type,
5900: p_fob_point IN ra_customer_trx.fob_point%type)
5901: IS
5902: l_trx_rec ra_customer_trx%rowtype;
5903: BEGIN
5904: arp_util.debug('arp_ct_pkg.lock_compare_frt_cover()+');

Line 5902: l_trx_rec ra_customer_trx%rowtype;

5898: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
5899: p_waybill_number IN ra_customer_trx.waybill_number%type,
5900: p_fob_point IN ra_customer_trx.fob_point%type)
5901: IS
5902: l_trx_rec ra_customer_trx%rowtype;
5903: BEGIN
5904: arp_util.debug('arp_ct_pkg.lock_compare_frt_cover()+');
5905:
5906: /*------------------------------------------------+

Line 6077: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

6073: | |
6074: +===========================================================================*/
6075:
6076: PROCEDURE lock_compare_cover(
6077: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
6078: p_trx_number IN ra_customer_trx.trx_number%type,
6079: p_posting_control_id IN ra_customer_trx.posting_control_id%type,
6080: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
6081: p_complete_flag IN ra_customer_trx.complete_flag%type,

Line 6078: p_trx_number IN ra_customer_trx.trx_number%type,

6074: +===========================================================================*/
6075:
6076: PROCEDURE lock_compare_cover(
6077: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
6078: p_trx_number IN ra_customer_trx.trx_number%type,
6079: p_posting_control_id IN ra_customer_trx.posting_control_id%type,
6080: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
6081: p_complete_flag IN ra_customer_trx.complete_flag%type,
6082: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,

Line 6079: p_posting_control_id IN ra_customer_trx.posting_control_id%type,

6075:
6076: PROCEDURE lock_compare_cover(
6077: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
6078: p_trx_number IN ra_customer_trx.trx_number%type,
6079: p_posting_control_id IN ra_customer_trx.posting_control_id%type,
6080: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
6081: p_complete_flag IN ra_customer_trx.complete_flag%type,
6082: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
6083: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,

Line 6080: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,

6076: PROCEDURE lock_compare_cover(
6077: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
6078: p_trx_number IN ra_customer_trx.trx_number%type,
6079: p_posting_control_id IN ra_customer_trx.posting_control_id%type,
6080: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
6081: p_complete_flag IN ra_customer_trx.complete_flag%type,
6082: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
6083: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
6084: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,

Line 6081: p_complete_flag IN ra_customer_trx.complete_flag%type,

6077: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
6078: p_trx_number IN ra_customer_trx.trx_number%type,
6079: p_posting_control_id IN ra_customer_trx.posting_control_id%type,
6080: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
6081: p_complete_flag IN ra_customer_trx.complete_flag%type,
6082: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
6083: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
6084: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
6085: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,

Line 6082: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,

6078: p_trx_number IN ra_customer_trx.trx_number%type,
6079: p_posting_control_id IN ra_customer_trx.posting_control_id%type,
6080: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
6081: p_complete_flag IN ra_customer_trx.complete_flag%type,
6082: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
6083: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
6084: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
6085: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
6086: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,

Line 6083: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,

6079: p_posting_control_id IN ra_customer_trx.posting_control_id%type,
6080: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
6081: p_complete_flag IN ra_customer_trx.complete_flag%type,
6082: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
6083: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
6084: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
6085: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
6086: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
6087: p_batch_id IN ra_customer_trx.batch_id%type,

Line 6084: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,

6080: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
6081: p_complete_flag IN ra_customer_trx.complete_flag%type,
6082: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
6083: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
6084: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
6085: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
6086: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
6087: p_batch_id IN ra_customer_trx.batch_id%type,
6088: p_batch_source_id IN ra_customer_trx.batch_source_id%type,

Line 6085: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,

6081: p_complete_flag IN ra_customer_trx.complete_flag%type,
6082: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
6083: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
6084: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
6085: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
6086: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
6087: p_batch_id IN ra_customer_trx.batch_id%type,
6088: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
6089: p_agreement_id IN ra_customer_trx.agreement_id%type,

Line 6086: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,

6082: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
6083: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
6084: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
6085: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
6086: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
6087: p_batch_id IN ra_customer_trx.batch_id%type,
6088: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
6089: p_agreement_id IN ra_customer_trx.agreement_id%type,
6090: p_trx_date IN ra_customer_trx.trx_date%type,

Line 6087: p_batch_id IN ra_customer_trx.batch_id%type,

6083: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
6084: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
6085: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
6086: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
6087: p_batch_id IN ra_customer_trx.batch_id%type,
6088: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
6089: p_agreement_id IN ra_customer_trx.agreement_id%type,
6090: p_trx_date IN ra_customer_trx.trx_date%type,
6091: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,

Line 6088: p_batch_source_id IN ra_customer_trx.batch_source_id%type,

6084: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
6085: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
6086: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
6087: p_batch_id IN ra_customer_trx.batch_id%type,
6088: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
6089: p_agreement_id IN ra_customer_trx.agreement_id%type,
6090: p_trx_date IN ra_customer_trx.trx_date%type,
6091: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
6092: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,

Line 6089: p_agreement_id IN ra_customer_trx.agreement_id%type,

6085: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
6086: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
6087: p_batch_id IN ra_customer_trx.batch_id%type,
6088: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
6089: p_agreement_id IN ra_customer_trx.agreement_id%type,
6090: p_trx_date IN ra_customer_trx.trx_date%type,
6091: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
6092: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
6093: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,

Line 6090: p_trx_date IN ra_customer_trx.trx_date%type,

6086: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
6087: p_batch_id IN ra_customer_trx.batch_id%type,
6088: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
6089: p_agreement_id IN ra_customer_trx.agreement_id%type,
6090: p_trx_date IN ra_customer_trx.trx_date%type,
6091: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
6092: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
6093: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
6094: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,

Line 6091: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,

6087: p_batch_id IN ra_customer_trx.batch_id%type,
6088: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
6089: p_agreement_id IN ra_customer_trx.agreement_id%type,
6090: p_trx_date IN ra_customer_trx.trx_date%type,
6091: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
6092: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
6093: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
6094: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
6095: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,

Line 6092: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,

6088: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
6089: p_agreement_id IN ra_customer_trx.agreement_id%type,
6090: p_trx_date IN ra_customer_trx.trx_date%type,
6091: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
6092: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
6093: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
6094: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
6095: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
6096: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,

Line 6093: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,

6089: p_agreement_id IN ra_customer_trx.agreement_id%type,
6090: p_trx_date IN ra_customer_trx.trx_date%type,
6091: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
6092: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
6093: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
6094: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
6095: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
6096: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
6097: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,

Line 6094: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,

6090: p_trx_date IN ra_customer_trx.trx_date%type,
6091: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
6092: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
6093: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
6094: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
6095: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
6096: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
6097: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
6098: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,

Line 6095: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,

6091: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
6092: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
6093: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
6094: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
6095: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
6096: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
6097: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
6098: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
6099: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,

Line 6096: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,

6092: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
6093: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
6094: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
6095: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
6096: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
6097: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
6098: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
6099: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
6100: p_customer_reference IN ra_customer_trx.customer_reference%type,

Line 6097: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,

6093: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
6094: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
6095: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
6096: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
6097: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
6098: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
6099: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
6100: p_customer_reference IN ra_customer_trx.customer_reference%type,
6101: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,

Line 6098: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,

6094: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
6095: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
6096: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
6097: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
6098: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
6099: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
6100: p_customer_reference IN ra_customer_trx.customer_reference%type,
6101: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
6102: p_cr_method_for_installments IN

Line 6099: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,

6095: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
6096: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
6097: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
6098: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
6099: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
6100: p_customer_reference IN ra_customer_trx.customer_reference%type,
6101: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
6102: p_cr_method_for_installments IN
6103: ra_customer_trx.credit_method_for_installments%type,

Line 6100: p_customer_reference IN ra_customer_trx.customer_reference%type,

6096: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
6097: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
6098: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
6099: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
6100: p_customer_reference IN ra_customer_trx.customer_reference%type,
6101: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
6102: p_cr_method_for_installments IN
6103: ra_customer_trx.credit_method_for_installments%type,
6104: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,

Line 6101: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,

6097: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
6098: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
6099: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
6100: p_customer_reference IN ra_customer_trx.customer_reference%type,
6101: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
6102: p_cr_method_for_installments IN
6103: ra_customer_trx.credit_method_for_installments%type,
6104: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
6105: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,

Line 6103: ra_customer_trx.credit_method_for_installments%type,

6099: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
6100: p_customer_reference IN ra_customer_trx.customer_reference%type,
6101: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
6102: p_cr_method_for_installments IN
6103: ra_customer_trx.credit_method_for_installments%type,
6104: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
6105: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
6106: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
6107: p_exchange_date IN ra_customer_trx.exchange_date%type,

Line 6104: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,

6100: p_customer_reference IN ra_customer_trx.customer_reference%type,
6101: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
6102: p_cr_method_for_installments IN
6103: ra_customer_trx.credit_method_for_installments%type,
6104: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
6105: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
6106: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
6107: p_exchange_date IN ra_customer_trx.exchange_date%type,
6108: p_exchange_rate IN ra_customer_trx.exchange_rate%type,

Line 6105: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,

6101: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
6102: p_cr_method_for_installments IN
6103: ra_customer_trx.credit_method_for_installments%type,
6104: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
6105: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
6106: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
6107: p_exchange_date IN ra_customer_trx.exchange_date%type,
6108: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
6109: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,

Line 6106: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,

6102: p_cr_method_for_installments IN
6103: ra_customer_trx.credit_method_for_installments%type,
6104: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
6105: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
6106: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
6107: p_exchange_date IN ra_customer_trx.exchange_date%type,
6108: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
6109: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
6110: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,

Line 6107: p_exchange_date IN ra_customer_trx.exchange_date%type,

6103: ra_customer_trx.credit_method_for_installments%type,
6104: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
6105: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
6106: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
6107: p_exchange_date IN ra_customer_trx.exchange_date%type,
6108: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
6109: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
6110: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
6111: p_finance_charges IN ra_customer_trx.finance_charges%type,

Line 6108: p_exchange_rate IN ra_customer_trx.exchange_rate%type,

6104: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
6105: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
6106: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
6107: p_exchange_date IN ra_customer_trx.exchange_date%type,
6108: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
6109: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
6110: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
6111: p_finance_charges IN ra_customer_trx.finance_charges%type,
6112: p_fob_point IN ra_customer_trx.fob_point%type,

Line 6109: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,

6105: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
6106: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
6107: p_exchange_date IN ra_customer_trx.exchange_date%type,
6108: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
6109: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
6110: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
6111: p_finance_charges IN ra_customer_trx.finance_charges%type,
6112: p_fob_point IN ra_customer_trx.fob_point%type,
6113: p_comments IN ra_customer_trx.comments%type,

Line 6110: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,

6106: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
6107: p_exchange_date IN ra_customer_trx.exchange_date%type,
6108: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
6109: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
6110: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
6111: p_finance_charges IN ra_customer_trx.finance_charges%type,
6112: p_fob_point IN ra_customer_trx.fob_point%type,
6113: p_comments IN ra_customer_trx.comments%type,
6114: p_internal_notes IN ra_customer_trx.internal_notes%type,

Line 6111: p_finance_charges IN ra_customer_trx.finance_charges%type,

6107: p_exchange_date IN ra_customer_trx.exchange_date%type,
6108: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
6109: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
6110: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
6111: p_finance_charges IN ra_customer_trx.finance_charges%type,
6112: p_fob_point IN ra_customer_trx.fob_point%type,
6113: p_comments IN ra_customer_trx.comments%type,
6114: p_internal_notes IN ra_customer_trx.internal_notes%type,
6115: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,

Line 6112: p_fob_point IN ra_customer_trx.fob_point%type,

6108: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
6109: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
6110: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
6111: p_finance_charges IN ra_customer_trx.finance_charges%type,
6112: p_fob_point IN ra_customer_trx.fob_point%type,
6113: p_comments IN ra_customer_trx.comments%type,
6114: p_internal_notes IN ra_customer_trx.internal_notes%type,
6115: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
6116: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,

Line 6113: p_comments IN ra_customer_trx.comments%type,

6109: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
6110: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
6111: p_finance_charges IN ra_customer_trx.finance_charges%type,
6112: p_fob_point IN ra_customer_trx.fob_point%type,
6113: p_comments IN ra_customer_trx.comments%type,
6114: p_internal_notes IN ra_customer_trx.internal_notes%type,
6115: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
6116: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
6117: p_last_printed_sequence_num IN

Line 6114: p_internal_notes IN ra_customer_trx.internal_notes%type,

6110: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
6111: p_finance_charges IN ra_customer_trx.finance_charges%type,
6112: p_fob_point IN ra_customer_trx.fob_point%type,
6113: p_comments IN ra_customer_trx.comments%type,
6114: p_internal_notes IN ra_customer_trx.internal_notes%type,
6115: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
6116: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
6117: p_last_printed_sequence_num IN
6118: ra_customer_trx.last_printed_sequence_num%type,

Line 6115: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,

6111: p_finance_charges IN ra_customer_trx.finance_charges%type,
6112: p_fob_point IN ra_customer_trx.fob_point%type,
6113: p_comments IN ra_customer_trx.comments%type,
6114: p_internal_notes IN ra_customer_trx.internal_notes%type,
6115: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
6116: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
6117: p_last_printed_sequence_num IN
6118: ra_customer_trx.last_printed_sequence_num%type,
6119: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,

Line 6116: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,

6112: p_fob_point IN ra_customer_trx.fob_point%type,
6113: p_comments IN ra_customer_trx.comments%type,
6114: p_internal_notes IN ra_customer_trx.internal_notes%type,
6115: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
6116: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
6117: p_last_printed_sequence_num IN
6118: ra_customer_trx.last_printed_sequence_num%type,
6119: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
6120: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,

Line 6118: ra_customer_trx.last_printed_sequence_num%type,

6114: p_internal_notes IN ra_customer_trx.internal_notes%type,
6115: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
6116: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
6117: p_last_printed_sequence_num IN
6118: ra_customer_trx.last_printed_sequence_num%type,
6119: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
6120: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
6121: p_printing_count IN ra_customer_trx.printing_count%type,
6122: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,

Line 6119: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,

6115: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
6116: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
6117: p_last_printed_sequence_num IN
6118: ra_customer_trx.last_printed_sequence_num%type,
6119: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
6120: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
6121: p_printing_count IN ra_customer_trx.printing_count%type,
6122: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
6123: p_printing_option IN ra_customer_trx.printing_option%type,

Line 6120: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,

6116: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
6117: p_last_printed_sequence_num IN
6118: ra_customer_trx.last_printed_sequence_num%type,
6119: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
6120: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
6121: p_printing_count IN ra_customer_trx.printing_count%type,
6122: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
6123: p_printing_option IN ra_customer_trx.printing_option%type,
6124: p_printing_original_date IN ra_customer_trx.printing_original_date%type,

Line 6121: p_printing_count IN ra_customer_trx.printing_count%type,

6117: p_last_printed_sequence_num IN
6118: ra_customer_trx.last_printed_sequence_num%type,
6119: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
6120: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
6121: p_printing_count IN ra_customer_trx.printing_count%type,
6122: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
6123: p_printing_option IN ra_customer_trx.printing_option%type,
6124: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
6125: p_printing_pending IN ra_customer_trx.printing_pending%type,

Line 6122: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,

6118: ra_customer_trx.last_printed_sequence_num%type,
6119: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
6120: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
6121: p_printing_count IN ra_customer_trx.printing_count%type,
6122: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
6123: p_printing_option IN ra_customer_trx.printing_option%type,
6124: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
6125: p_printing_pending IN ra_customer_trx.printing_pending%type,
6126: p_purchase_order IN ra_customer_trx.purchase_order%type,

Line 6123: p_printing_option IN ra_customer_trx.printing_option%type,

6119: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
6120: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
6121: p_printing_count IN ra_customer_trx.printing_count%type,
6122: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
6123: p_printing_option IN ra_customer_trx.printing_option%type,
6124: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
6125: p_printing_pending IN ra_customer_trx.printing_pending%type,
6126: p_purchase_order IN ra_customer_trx.purchase_order%type,
6127: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,

Line 6124: p_printing_original_date IN ra_customer_trx.printing_original_date%type,

6120: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
6121: p_printing_count IN ra_customer_trx.printing_count%type,
6122: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
6123: p_printing_option IN ra_customer_trx.printing_option%type,
6124: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
6125: p_printing_pending IN ra_customer_trx.printing_pending%type,
6126: p_purchase_order IN ra_customer_trx.purchase_order%type,
6127: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
6128: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,

Line 6125: p_printing_pending IN ra_customer_trx.printing_pending%type,

6121: p_printing_count IN ra_customer_trx.printing_count%type,
6122: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
6123: p_printing_option IN ra_customer_trx.printing_option%type,
6124: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
6125: p_printing_pending IN ra_customer_trx.printing_pending%type,
6126: p_purchase_order IN ra_customer_trx.purchase_order%type,
6127: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
6128: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
6129: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,

Line 6126: p_purchase_order IN ra_customer_trx.purchase_order%type,

6122: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
6123: p_printing_option IN ra_customer_trx.printing_option%type,
6124: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
6125: p_printing_pending IN ra_customer_trx.printing_pending%type,
6126: p_purchase_order IN ra_customer_trx.purchase_order%type,
6127: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
6128: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
6129: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
6130: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,

Line 6127: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,

6123: p_printing_option IN ra_customer_trx.printing_option%type,
6124: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
6125: p_printing_pending IN ra_customer_trx.printing_pending%type,
6126: p_purchase_order IN ra_customer_trx.purchase_order%type,
6127: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
6128: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
6129: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
6130: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
6131: p_shipment_id IN ra_customer_trx.shipment_id%type,

Line 6128: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,

6124: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
6125: p_printing_pending IN ra_customer_trx.printing_pending%type,
6126: p_purchase_order IN ra_customer_trx.purchase_order%type,
6127: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
6128: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
6129: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
6130: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
6131: p_shipment_id IN ra_customer_trx.shipment_id%type,
6132: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,

Line 6129: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,

6125: p_printing_pending IN ra_customer_trx.printing_pending%type,
6126: p_purchase_order IN ra_customer_trx.purchase_order%type,
6127: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
6128: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
6129: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
6130: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
6131: p_shipment_id IN ra_customer_trx.shipment_id%type,
6132: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
6133: p_ship_via IN ra_customer_trx.ship_via%type,

Line 6130: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,

6126: p_purchase_order IN ra_customer_trx.purchase_order%type,
6127: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
6128: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
6129: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
6130: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
6131: p_shipment_id IN ra_customer_trx.shipment_id%type,
6132: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
6133: p_ship_via IN ra_customer_trx.ship_via%type,
6134: p_term_due_date IN ra_customer_trx.term_due_date%type,

Line 6131: p_shipment_id IN ra_customer_trx.shipment_id%type,

6127: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
6128: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
6129: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
6130: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
6131: p_shipment_id IN ra_customer_trx.shipment_id%type,
6132: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
6133: p_ship_via IN ra_customer_trx.ship_via%type,
6134: p_term_due_date IN ra_customer_trx.term_due_date%type,
6135: p_term_id IN ra_customer_trx.term_id%type,

Line 6132: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,

6128: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
6129: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
6130: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
6131: p_shipment_id IN ra_customer_trx.shipment_id%type,
6132: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
6133: p_ship_via IN ra_customer_trx.ship_via%type,
6134: p_term_due_date IN ra_customer_trx.term_due_date%type,
6135: p_term_id IN ra_customer_trx.term_id%type,
6136: p_territory_id IN ra_customer_trx.territory_id%type,

Line 6133: p_ship_via IN ra_customer_trx.ship_via%type,

6129: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
6130: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
6131: p_shipment_id IN ra_customer_trx.shipment_id%type,
6132: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
6133: p_ship_via IN ra_customer_trx.ship_via%type,
6134: p_term_due_date IN ra_customer_trx.term_due_date%type,
6135: p_term_id IN ra_customer_trx.term_id%type,
6136: p_territory_id IN ra_customer_trx.territory_id%type,
6137: p_waybill_number IN ra_customer_trx.waybill_number%type,

Line 6134: p_term_due_date IN ra_customer_trx.term_due_date%type,

6130: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
6131: p_shipment_id IN ra_customer_trx.shipment_id%type,
6132: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
6133: p_ship_via IN ra_customer_trx.ship_via%type,
6134: p_term_due_date IN ra_customer_trx.term_due_date%type,
6135: p_term_id IN ra_customer_trx.term_id%type,
6136: p_territory_id IN ra_customer_trx.territory_id%type,
6137: p_waybill_number IN ra_customer_trx.waybill_number%type,
6138: p_status_trx IN ra_customer_trx.status_trx%type,

Line 6135: p_term_id IN ra_customer_trx.term_id%type,

6131: p_shipment_id IN ra_customer_trx.shipment_id%type,
6132: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
6133: p_ship_via IN ra_customer_trx.ship_via%type,
6134: p_term_due_date IN ra_customer_trx.term_due_date%type,
6135: p_term_id IN ra_customer_trx.term_id%type,
6136: p_territory_id IN ra_customer_trx.territory_id%type,
6137: p_waybill_number IN ra_customer_trx.waybill_number%type,
6138: p_status_trx IN ra_customer_trx.status_trx%type,
6139: p_reason_code IN ra_customer_trx.reason_code%type,

Line 6136: p_territory_id IN ra_customer_trx.territory_id%type,

6132: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
6133: p_ship_via IN ra_customer_trx.ship_via%type,
6134: p_term_due_date IN ra_customer_trx.term_due_date%type,
6135: p_term_id IN ra_customer_trx.term_id%type,
6136: p_territory_id IN ra_customer_trx.territory_id%type,
6137: p_waybill_number IN ra_customer_trx.waybill_number%type,
6138: p_status_trx IN ra_customer_trx.status_trx%type,
6139: p_reason_code IN ra_customer_trx.reason_code%type,
6140: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,

Line 6137: p_waybill_number IN ra_customer_trx.waybill_number%type,

6133: p_ship_via IN ra_customer_trx.ship_via%type,
6134: p_term_due_date IN ra_customer_trx.term_due_date%type,
6135: p_term_id IN ra_customer_trx.term_id%type,
6136: p_territory_id IN ra_customer_trx.territory_id%type,
6137: p_waybill_number IN ra_customer_trx.waybill_number%type,
6138: p_status_trx IN ra_customer_trx.status_trx%type,
6139: p_reason_code IN ra_customer_trx.reason_code%type,
6140: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
6141: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,

Line 6138: p_status_trx IN ra_customer_trx.status_trx%type,

6134: p_term_due_date IN ra_customer_trx.term_due_date%type,
6135: p_term_id IN ra_customer_trx.term_id%type,
6136: p_territory_id IN ra_customer_trx.territory_id%type,
6137: p_waybill_number IN ra_customer_trx.waybill_number%type,
6138: p_status_trx IN ra_customer_trx.status_trx%type,
6139: p_reason_code IN ra_customer_trx.reason_code%type,
6140: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
6141: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
6142: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,

Line 6139: p_reason_code IN ra_customer_trx.reason_code%type,

6135: p_term_id IN ra_customer_trx.term_id%type,
6136: p_territory_id IN ra_customer_trx.territory_id%type,
6137: p_waybill_number IN ra_customer_trx.waybill_number%type,
6138: p_status_trx IN ra_customer_trx.status_trx%type,
6139: p_reason_code IN ra_customer_trx.reason_code%type,
6140: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
6141: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
6142: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
6143: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,

Line 6140: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,

6136: p_territory_id IN ra_customer_trx.territory_id%type,
6137: p_waybill_number IN ra_customer_trx.waybill_number%type,
6138: p_status_trx IN ra_customer_trx.status_trx%type,
6139: p_reason_code IN ra_customer_trx.reason_code%type,
6140: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
6141: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
6142: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
6143: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
6144: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,

Line 6141: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,

6137: p_waybill_number IN ra_customer_trx.waybill_number%type,
6138: p_status_trx IN ra_customer_trx.status_trx%type,
6139: p_reason_code IN ra_customer_trx.reason_code%type,
6140: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
6141: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
6142: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
6143: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
6144: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
6145: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,

Line 6142: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,

6138: p_status_trx IN ra_customer_trx.status_trx%type,
6139: p_reason_code IN ra_customer_trx.reason_code%type,
6140: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
6141: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
6142: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
6143: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
6144: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
6145: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,
6146: p_created_from IN ra_customer_trx.created_from%type,

Line 6143: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,

6139: p_reason_code IN ra_customer_trx.reason_code%type,
6140: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
6141: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
6142: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
6143: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
6144: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
6145: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,
6146: p_created_from IN ra_customer_trx.created_from%type,
6147: p_deflt_ussgl_trx_code_context IN

Line 6144: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,

6140: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
6141: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
6142: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
6143: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
6144: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
6145: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,
6146: p_created_from IN ra_customer_trx.created_from%type,
6147: p_deflt_ussgl_trx_code_context IN
6148: ra_customer_trx.default_ussgl_trx_code_context%type,

Line 6145: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,

6141: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
6142: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
6143: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
6144: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
6145: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,
6146: p_created_from IN ra_customer_trx.created_from%type,
6147: p_deflt_ussgl_trx_code_context IN
6148: ra_customer_trx.default_ussgl_trx_code_context%type,
6149: p_deflt_ussgl_transaction_code IN

Line 6146: p_created_from IN ra_customer_trx.created_from%type,

6142: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
6143: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
6144: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
6145: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,
6146: p_created_from IN ra_customer_trx.created_from%type,
6147: p_deflt_ussgl_trx_code_context IN
6148: ra_customer_trx.default_ussgl_trx_code_context%type,
6149: p_deflt_ussgl_transaction_code IN
6150: ra_customer_trx.default_ussgl_transaction_code%type,

Line 6148: ra_customer_trx.default_ussgl_trx_code_context%type,

6144: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
6145: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,
6146: p_created_from IN ra_customer_trx.created_from%type,
6147: p_deflt_ussgl_trx_code_context IN
6148: ra_customer_trx.default_ussgl_trx_code_context%type,
6149: p_deflt_ussgl_transaction_code IN
6150: ra_customer_trx.default_ussgl_transaction_code%type,
6151: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
6152: p_interface_header_context IN

Line 6150: ra_customer_trx.default_ussgl_transaction_code%type,

6146: p_created_from IN ra_customer_trx.created_from%type,
6147: p_deflt_ussgl_trx_code_context IN
6148: ra_customer_trx.default_ussgl_trx_code_context%type,
6149: p_deflt_ussgl_transaction_code IN
6150: ra_customer_trx.default_ussgl_transaction_code%type,
6151: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
6152: p_interface_header_context IN
6153: ra_customer_trx.interface_header_context%type,
6154: p_interface_header_attribute1 IN

Line 6151: p_old_trx_number IN ra_customer_trx.old_trx_number%type,

6147: p_deflt_ussgl_trx_code_context IN
6148: ra_customer_trx.default_ussgl_trx_code_context%type,
6149: p_deflt_ussgl_transaction_code IN
6150: ra_customer_trx.default_ussgl_transaction_code%type,
6151: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
6152: p_interface_header_context IN
6153: ra_customer_trx.interface_header_context%type,
6154: p_interface_header_attribute1 IN
6155: ra_customer_trx.interface_header_attribute1%type,

Line 6153: ra_customer_trx.interface_header_context%type,

6149: p_deflt_ussgl_transaction_code IN
6150: ra_customer_trx.default_ussgl_transaction_code%type,
6151: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
6152: p_interface_header_context IN
6153: ra_customer_trx.interface_header_context%type,
6154: p_interface_header_attribute1 IN
6155: ra_customer_trx.interface_header_attribute1%type,
6156: p_interface_header_attribute2 IN
6157: ra_customer_trx.interface_header_attribute2%type,

Line 6155: ra_customer_trx.interface_header_attribute1%type,

6151: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
6152: p_interface_header_context IN
6153: ra_customer_trx.interface_header_context%type,
6154: p_interface_header_attribute1 IN
6155: ra_customer_trx.interface_header_attribute1%type,
6156: p_interface_header_attribute2 IN
6157: ra_customer_trx.interface_header_attribute2%type,
6158: p_interface_header_attribute3 IN
6159: ra_customer_trx.interface_header_attribute3%type,

Line 6157: ra_customer_trx.interface_header_attribute2%type,

6153: ra_customer_trx.interface_header_context%type,
6154: p_interface_header_attribute1 IN
6155: ra_customer_trx.interface_header_attribute1%type,
6156: p_interface_header_attribute2 IN
6157: ra_customer_trx.interface_header_attribute2%type,
6158: p_interface_header_attribute3 IN
6159: ra_customer_trx.interface_header_attribute3%type,
6160: p_interface_header_attribute4 IN
6161: ra_customer_trx.interface_header_attribute4%type,

Line 6159: ra_customer_trx.interface_header_attribute3%type,

6155: ra_customer_trx.interface_header_attribute1%type,
6156: p_interface_header_attribute2 IN
6157: ra_customer_trx.interface_header_attribute2%type,
6158: p_interface_header_attribute3 IN
6159: ra_customer_trx.interface_header_attribute3%type,
6160: p_interface_header_attribute4 IN
6161: ra_customer_trx.interface_header_attribute4%type,
6162: p_interface_header_attribute5 IN
6163: ra_customer_trx.interface_header_attribute5%type,

Line 6161: ra_customer_trx.interface_header_attribute4%type,

6157: ra_customer_trx.interface_header_attribute2%type,
6158: p_interface_header_attribute3 IN
6159: ra_customer_trx.interface_header_attribute3%type,
6160: p_interface_header_attribute4 IN
6161: ra_customer_trx.interface_header_attribute4%type,
6162: p_interface_header_attribute5 IN
6163: ra_customer_trx.interface_header_attribute5%type,
6164: p_interface_header_attribute6 IN
6165: ra_customer_trx.interface_header_attribute6%type,

Line 6163: ra_customer_trx.interface_header_attribute5%type,

6159: ra_customer_trx.interface_header_attribute3%type,
6160: p_interface_header_attribute4 IN
6161: ra_customer_trx.interface_header_attribute4%type,
6162: p_interface_header_attribute5 IN
6163: ra_customer_trx.interface_header_attribute5%type,
6164: p_interface_header_attribute6 IN
6165: ra_customer_trx.interface_header_attribute6%type,
6166: p_interface_header_attribute7 IN
6167: ra_customer_trx.interface_header_attribute7%type,

Line 6165: ra_customer_trx.interface_header_attribute6%type,

6161: ra_customer_trx.interface_header_attribute4%type,
6162: p_interface_header_attribute5 IN
6163: ra_customer_trx.interface_header_attribute5%type,
6164: p_interface_header_attribute6 IN
6165: ra_customer_trx.interface_header_attribute6%type,
6166: p_interface_header_attribute7 IN
6167: ra_customer_trx.interface_header_attribute7%type,
6168: p_interface_header_attribute8 IN
6169: ra_customer_trx.interface_header_attribute8%type,

Line 6167: ra_customer_trx.interface_header_attribute7%type,

6163: ra_customer_trx.interface_header_attribute5%type,
6164: p_interface_header_attribute6 IN
6165: ra_customer_trx.interface_header_attribute6%type,
6166: p_interface_header_attribute7 IN
6167: ra_customer_trx.interface_header_attribute7%type,
6168: p_interface_header_attribute8 IN
6169: ra_customer_trx.interface_header_attribute8%type,
6170: p_interface_header_attribute9 IN
6171: ra_customer_trx.interface_header_attribute9%type,

Line 6169: ra_customer_trx.interface_header_attribute8%type,

6165: ra_customer_trx.interface_header_attribute6%type,
6166: p_interface_header_attribute7 IN
6167: ra_customer_trx.interface_header_attribute7%type,
6168: p_interface_header_attribute8 IN
6169: ra_customer_trx.interface_header_attribute8%type,
6170: p_interface_header_attribute9 IN
6171: ra_customer_trx.interface_header_attribute9%type,
6172: p_interface_header_attribute10 IN
6173: ra_customer_trx.interface_header_attribute10%type,

Line 6171: ra_customer_trx.interface_header_attribute9%type,

6167: ra_customer_trx.interface_header_attribute7%type,
6168: p_interface_header_attribute8 IN
6169: ra_customer_trx.interface_header_attribute8%type,
6170: p_interface_header_attribute9 IN
6171: ra_customer_trx.interface_header_attribute9%type,
6172: p_interface_header_attribute10 IN
6173: ra_customer_trx.interface_header_attribute10%type,
6174: p_interface_header_attribute11 IN
6175: ra_customer_trx.interface_header_attribute11%type,

Line 6173: ra_customer_trx.interface_header_attribute10%type,

6169: ra_customer_trx.interface_header_attribute8%type,
6170: p_interface_header_attribute9 IN
6171: ra_customer_trx.interface_header_attribute9%type,
6172: p_interface_header_attribute10 IN
6173: ra_customer_trx.interface_header_attribute10%type,
6174: p_interface_header_attribute11 IN
6175: ra_customer_trx.interface_header_attribute11%type,
6176: p_interface_header_attribute12 IN
6177: ra_customer_trx.interface_header_attribute12%type,

Line 6175: ra_customer_trx.interface_header_attribute11%type,

6171: ra_customer_trx.interface_header_attribute9%type,
6172: p_interface_header_attribute10 IN
6173: ra_customer_trx.interface_header_attribute10%type,
6174: p_interface_header_attribute11 IN
6175: ra_customer_trx.interface_header_attribute11%type,
6176: p_interface_header_attribute12 IN
6177: ra_customer_trx.interface_header_attribute12%type,
6178: p_interface_header_attribute13 IN
6179: ra_customer_trx.interface_header_attribute13%type,

Line 6177: ra_customer_trx.interface_header_attribute12%type,

6173: ra_customer_trx.interface_header_attribute10%type,
6174: p_interface_header_attribute11 IN
6175: ra_customer_trx.interface_header_attribute11%type,
6176: p_interface_header_attribute12 IN
6177: ra_customer_trx.interface_header_attribute12%type,
6178: p_interface_header_attribute13 IN
6179: ra_customer_trx.interface_header_attribute13%type,
6180: p_interface_header_attribute14 IN
6181: ra_customer_trx.interface_header_attribute14%type,

Line 6179: ra_customer_trx.interface_header_attribute13%type,

6175: ra_customer_trx.interface_header_attribute11%type,
6176: p_interface_header_attribute12 IN
6177: ra_customer_trx.interface_header_attribute12%type,
6178: p_interface_header_attribute13 IN
6179: ra_customer_trx.interface_header_attribute13%type,
6180: p_interface_header_attribute14 IN
6181: ra_customer_trx.interface_header_attribute14%type,
6182: p_interface_header_attribute15 IN
6183: ra_customer_trx.interface_header_attribute15%type,

Line 6181: ra_customer_trx.interface_header_attribute14%type,

6177: ra_customer_trx.interface_header_attribute12%type,
6178: p_interface_header_attribute13 IN
6179: ra_customer_trx.interface_header_attribute13%type,
6180: p_interface_header_attribute14 IN
6181: ra_customer_trx.interface_header_attribute14%type,
6182: p_interface_header_attribute15 IN
6183: ra_customer_trx.interface_header_attribute15%type,
6184: p_attribute_category IN ra_customer_trx.attribute_category%type,
6185: p_attribute1 IN ra_customer_trx.attribute1%type,

Line 6183: ra_customer_trx.interface_header_attribute15%type,

6179: ra_customer_trx.interface_header_attribute13%type,
6180: p_interface_header_attribute14 IN
6181: ra_customer_trx.interface_header_attribute14%type,
6182: p_interface_header_attribute15 IN
6183: ra_customer_trx.interface_header_attribute15%type,
6184: p_attribute_category IN ra_customer_trx.attribute_category%type,
6185: p_attribute1 IN ra_customer_trx.attribute1%type,
6186: p_attribute2 IN ra_customer_trx.attribute2%type,
6187: p_attribute3 IN ra_customer_trx.attribute3%type,

Line 6184: p_attribute_category IN ra_customer_trx.attribute_category%type,

6180: p_interface_header_attribute14 IN
6181: ra_customer_trx.interface_header_attribute14%type,
6182: p_interface_header_attribute15 IN
6183: ra_customer_trx.interface_header_attribute15%type,
6184: p_attribute_category IN ra_customer_trx.attribute_category%type,
6185: p_attribute1 IN ra_customer_trx.attribute1%type,
6186: p_attribute2 IN ra_customer_trx.attribute2%type,
6187: p_attribute3 IN ra_customer_trx.attribute3%type,
6188: p_attribute4 IN ra_customer_trx.attribute4%type,

Line 6185: p_attribute1 IN ra_customer_trx.attribute1%type,

6181: ra_customer_trx.interface_header_attribute14%type,
6182: p_interface_header_attribute15 IN
6183: ra_customer_trx.interface_header_attribute15%type,
6184: p_attribute_category IN ra_customer_trx.attribute_category%type,
6185: p_attribute1 IN ra_customer_trx.attribute1%type,
6186: p_attribute2 IN ra_customer_trx.attribute2%type,
6187: p_attribute3 IN ra_customer_trx.attribute3%type,
6188: p_attribute4 IN ra_customer_trx.attribute4%type,
6189: p_attribute5 IN ra_customer_trx.attribute5%type,

Line 6186: p_attribute2 IN ra_customer_trx.attribute2%type,

6182: p_interface_header_attribute15 IN
6183: ra_customer_trx.interface_header_attribute15%type,
6184: p_attribute_category IN ra_customer_trx.attribute_category%type,
6185: p_attribute1 IN ra_customer_trx.attribute1%type,
6186: p_attribute2 IN ra_customer_trx.attribute2%type,
6187: p_attribute3 IN ra_customer_trx.attribute3%type,
6188: p_attribute4 IN ra_customer_trx.attribute4%type,
6189: p_attribute5 IN ra_customer_trx.attribute5%type,
6190: p_attribute6 IN ra_customer_trx.attribute6%type,

Line 6187: p_attribute3 IN ra_customer_trx.attribute3%type,

6183: ra_customer_trx.interface_header_attribute15%type,
6184: p_attribute_category IN ra_customer_trx.attribute_category%type,
6185: p_attribute1 IN ra_customer_trx.attribute1%type,
6186: p_attribute2 IN ra_customer_trx.attribute2%type,
6187: p_attribute3 IN ra_customer_trx.attribute3%type,
6188: p_attribute4 IN ra_customer_trx.attribute4%type,
6189: p_attribute5 IN ra_customer_trx.attribute5%type,
6190: p_attribute6 IN ra_customer_trx.attribute6%type,
6191: p_attribute7 IN ra_customer_trx.attribute7%type,

Line 6188: p_attribute4 IN ra_customer_trx.attribute4%type,

6184: p_attribute_category IN ra_customer_trx.attribute_category%type,
6185: p_attribute1 IN ra_customer_trx.attribute1%type,
6186: p_attribute2 IN ra_customer_trx.attribute2%type,
6187: p_attribute3 IN ra_customer_trx.attribute3%type,
6188: p_attribute4 IN ra_customer_trx.attribute4%type,
6189: p_attribute5 IN ra_customer_trx.attribute5%type,
6190: p_attribute6 IN ra_customer_trx.attribute6%type,
6191: p_attribute7 IN ra_customer_trx.attribute7%type,
6192: p_attribute8 IN ra_customer_trx.attribute8%type,

Line 6189: p_attribute5 IN ra_customer_trx.attribute5%type,

6185: p_attribute1 IN ra_customer_trx.attribute1%type,
6186: p_attribute2 IN ra_customer_trx.attribute2%type,
6187: p_attribute3 IN ra_customer_trx.attribute3%type,
6188: p_attribute4 IN ra_customer_trx.attribute4%type,
6189: p_attribute5 IN ra_customer_trx.attribute5%type,
6190: p_attribute6 IN ra_customer_trx.attribute6%type,
6191: p_attribute7 IN ra_customer_trx.attribute7%type,
6192: p_attribute8 IN ra_customer_trx.attribute8%type,
6193: p_attribute9 IN ra_customer_trx.attribute9%type,

Line 6190: p_attribute6 IN ra_customer_trx.attribute6%type,

6186: p_attribute2 IN ra_customer_trx.attribute2%type,
6187: p_attribute3 IN ra_customer_trx.attribute3%type,
6188: p_attribute4 IN ra_customer_trx.attribute4%type,
6189: p_attribute5 IN ra_customer_trx.attribute5%type,
6190: p_attribute6 IN ra_customer_trx.attribute6%type,
6191: p_attribute7 IN ra_customer_trx.attribute7%type,
6192: p_attribute8 IN ra_customer_trx.attribute8%type,
6193: p_attribute9 IN ra_customer_trx.attribute9%type,
6194: p_attribute10 IN ra_customer_trx.attribute10%type,

Line 6191: p_attribute7 IN ra_customer_trx.attribute7%type,

6187: p_attribute3 IN ra_customer_trx.attribute3%type,
6188: p_attribute4 IN ra_customer_trx.attribute4%type,
6189: p_attribute5 IN ra_customer_trx.attribute5%type,
6190: p_attribute6 IN ra_customer_trx.attribute6%type,
6191: p_attribute7 IN ra_customer_trx.attribute7%type,
6192: p_attribute8 IN ra_customer_trx.attribute8%type,
6193: p_attribute9 IN ra_customer_trx.attribute9%type,
6194: p_attribute10 IN ra_customer_trx.attribute10%type,
6195: p_attribute11 IN ra_customer_trx.attribute11%type,

Line 6192: p_attribute8 IN ra_customer_trx.attribute8%type,

6188: p_attribute4 IN ra_customer_trx.attribute4%type,
6189: p_attribute5 IN ra_customer_trx.attribute5%type,
6190: p_attribute6 IN ra_customer_trx.attribute6%type,
6191: p_attribute7 IN ra_customer_trx.attribute7%type,
6192: p_attribute8 IN ra_customer_trx.attribute8%type,
6193: p_attribute9 IN ra_customer_trx.attribute9%type,
6194: p_attribute10 IN ra_customer_trx.attribute10%type,
6195: p_attribute11 IN ra_customer_trx.attribute11%type,
6196: p_attribute12 IN ra_customer_trx.attribute12%type,

Line 6193: p_attribute9 IN ra_customer_trx.attribute9%type,

6189: p_attribute5 IN ra_customer_trx.attribute5%type,
6190: p_attribute6 IN ra_customer_trx.attribute6%type,
6191: p_attribute7 IN ra_customer_trx.attribute7%type,
6192: p_attribute8 IN ra_customer_trx.attribute8%type,
6193: p_attribute9 IN ra_customer_trx.attribute9%type,
6194: p_attribute10 IN ra_customer_trx.attribute10%type,
6195: p_attribute11 IN ra_customer_trx.attribute11%type,
6196: p_attribute12 IN ra_customer_trx.attribute12%type,
6197: p_attribute13 IN ra_customer_trx.attribute13%type,

Line 6194: p_attribute10 IN ra_customer_trx.attribute10%type,

6190: p_attribute6 IN ra_customer_trx.attribute6%type,
6191: p_attribute7 IN ra_customer_trx.attribute7%type,
6192: p_attribute8 IN ra_customer_trx.attribute8%type,
6193: p_attribute9 IN ra_customer_trx.attribute9%type,
6194: p_attribute10 IN ra_customer_trx.attribute10%type,
6195: p_attribute11 IN ra_customer_trx.attribute11%type,
6196: p_attribute12 IN ra_customer_trx.attribute12%type,
6197: p_attribute13 IN ra_customer_trx.attribute13%type,
6198: p_attribute14 IN ra_customer_trx.attribute14%type,

Line 6195: p_attribute11 IN ra_customer_trx.attribute11%type,

6191: p_attribute7 IN ra_customer_trx.attribute7%type,
6192: p_attribute8 IN ra_customer_trx.attribute8%type,
6193: p_attribute9 IN ra_customer_trx.attribute9%type,
6194: p_attribute10 IN ra_customer_trx.attribute10%type,
6195: p_attribute11 IN ra_customer_trx.attribute11%type,
6196: p_attribute12 IN ra_customer_trx.attribute12%type,
6197: p_attribute13 IN ra_customer_trx.attribute13%type,
6198: p_attribute14 IN ra_customer_trx.attribute14%type,
6199: p_attribute15 IN ra_customer_trx.attribute15%type,

Line 6196: p_attribute12 IN ra_customer_trx.attribute12%type,

6192: p_attribute8 IN ra_customer_trx.attribute8%type,
6193: p_attribute9 IN ra_customer_trx.attribute9%type,
6194: p_attribute10 IN ra_customer_trx.attribute10%type,
6195: p_attribute11 IN ra_customer_trx.attribute11%type,
6196: p_attribute12 IN ra_customer_trx.attribute12%type,
6197: p_attribute13 IN ra_customer_trx.attribute13%type,
6198: p_attribute14 IN ra_customer_trx.attribute14%type,
6199: p_attribute15 IN ra_customer_trx.attribute15%type,
6200: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,

Line 6197: p_attribute13 IN ra_customer_trx.attribute13%type,

6193: p_attribute9 IN ra_customer_trx.attribute9%type,
6194: p_attribute10 IN ra_customer_trx.attribute10%type,
6195: p_attribute11 IN ra_customer_trx.attribute11%type,
6196: p_attribute12 IN ra_customer_trx.attribute12%type,
6197: p_attribute13 IN ra_customer_trx.attribute13%type,
6198: p_attribute14 IN ra_customer_trx.attribute14%type,
6199: p_attribute15 IN ra_customer_trx.attribute15%type,
6200: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,
6201: p_payment_trxn_extension_id IN ra_customer_trx.payment_trxn_extension_id%type,

Line 6198: p_attribute14 IN ra_customer_trx.attribute14%type,

6194: p_attribute10 IN ra_customer_trx.attribute10%type,
6195: p_attribute11 IN ra_customer_trx.attribute11%type,
6196: p_attribute12 IN ra_customer_trx.attribute12%type,
6197: p_attribute13 IN ra_customer_trx.attribute13%type,
6198: p_attribute14 IN ra_customer_trx.attribute14%type,
6199: p_attribute15 IN ra_customer_trx.attribute15%type,
6200: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,
6201: p_payment_trxn_extension_id IN ra_customer_trx.payment_trxn_extension_id%type,
6202: p_billing_date IN ra_customer_trx.billing_date%type,

Line 6199: p_attribute15 IN ra_customer_trx.attribute15%type,

6195: p_attribute11 IN ra_customer_trx.attribute11%type,
6196: p_attribute12 IN ra_customer_trx.attribute12%type,
6197: p_attribute13 IN ra_customer_trx.attribute13%type,
6198: p_attribute14 IN ra_customer_trx.attribute14%type,
6199: p_attribute15 IN ra_customer_trx.attribute15%type,
6200: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,
6201: p_payment_trxn_extension_id IN ra_customer_trx.payment_trxn_extension_id%type,
6202: p_billing_date IN ra_customer_trx.billing_date%type,
6203: p_lock_trx_flag IN BOOLEAN DEFAULT TRUE)

Line 6200: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,

6196: p_attribute12 IN ra_customer_trx.attribute12%type,
6197: p_attribute13 IN ra_customer_trx.attribute13%type,
6198: p_attribute14 IN ra_customer_trx.attribute14%type,
6199: p_attribute15 IN ra_customer_trx.attribute15%type,
6200: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,
6201: p_payment_trxn_extension_id IN ra_customer_trx.payment_trxn_extension_id%type,
6202: p_billing_date IN ra_customer_trx.billing_date%type,
6203: p_lock_trx_flag IN BOOLEAN DEFAULT TRUE)
6204:

Line 6201: p_payment_trxn_extension_id IN ra_customer_trx.payment_trxn_extension_id%type,

6197: p_attribute13 IN ra_customer_trx.attribute13%type,
6198: p_attribute14 IN ra_customer_trx.attribute14%type,
6199: p_attribute15 IN ra_customer_trx.attribute15%type,
6200: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,
6201: p_payment_trxn_extension_id IN ra_customer_trx.payment_trxn_extension_id%type,
6202: p_billing_date IN ra_customer_trx.billing_date%type,
6203: p_lock_trx_flag IN BOOLEAN DEFAULT TRUE)
6204:
6205:

Line 6202: p_billing_date IN ra_customer_trx.billing_date%type,

6198: p_attribute14 IN ra_customer_trx.attribute14%type,
6199: p_attribute15 IN ra_customer_trx.attribute15%type,
6200: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,
6201: p_payment_trxn_extension_id IN ra_customer_trx.payment_trxn_extension_id%type,
6202: p_billing_date IN ra_customer_trx.billing_date%type,
6203: p_lock_trx_flag IN BOOLEAN DEFAULT TRUE)
6204:
6205:
6206: IS

Line 6208: l_trx_rec ra_customer_trx%rowtype;

6204:
6205:
6206: IS
6207:
6208: l_trx_rec ra_customer_trx%rowtype;
6209:
6210: BEGIN
6211: arp_util.debug('arp_ct_pkg.lock_compare_cover()+');
6212:

Line 6738: | This procedure updates the ra_customer_trx row identified by the |

6734: | PROCEDURE |
6735: | update_tax |
6736: | |
6737: | DESCRIPTION |
6738: | This procedure updates the ra_customer_trx row identified by the |
6739: | p_customer_trx_id parameter. |
6740: | |
6741: | SCOPE - PUBLIC |
6742: | |

Line 6773: PROCEDURE update_tax( p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,

6769: | and warehouse_id
6770: +===========================================================================*/
6771:
6772:
6773: PROCEDURE update_tax( p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
6774: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
6775: p_trx_date IN ra_customer_trx.trx_date%type,
6776: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
6777: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

Line 6774: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,

6770: +===========================================================================*/
6771:
6772:
6773: PROCEDURE update_tax( p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
6774: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
6775: p_trx_date IN ra_customer_trx.trx_date%type,
6776: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
6777: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
6778: P_TAX_AFFECT_FLAG in varchar2,

Line 6775: p_trx_date IN ra_customer_trx.trx_date%type,

6771:
6772:
6773: PROCEDURE update_tax( p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
6774: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
6775: p_trx_date IN ra_customer_trx.trx_date%type,
6776: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
6777: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
6778: P_TAX_AFFECT_FLAG in varchar2,
6779: p_enforce_nat_acc_flag IN BOOLEAN) IS

Line 6776: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,

6772:
6773: PROCEDURE update_tax( p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
6774: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
6775: p_trx_date IN ra_customer_trx.trx_date%type,
6776: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
6777: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
6778: P_TAX_AFFECT_FLAG in varchar2,
6779: p_enforce_nat_acc_flag IN BOOLEAN) IS
6780:

Line 6777: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

6773: PROCEDURE update_tax( p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
6774: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
6775: p_trx_date IN ra_customer_trx.trx_date%type,
6776: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
6777: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
6778: P_TAX_AFFECT_FLAG in varchar2,
6779: p_enforce_nat_acc_flag IN BOOLEAN) IS
6780:
6781: CURSOR update_header_lines IS

Line 6786: FROM ra_customer_trx_lines

6782: SELECT customer_trx_line_id,
6783: inventory_item_id,
6784: memo_line_id,
6785: warehouse_id
6786: FROM ra_customer_trx_lines
6787: WHERE customer_trx_id = p_customer_trx_id
6788: AND line_type = 'LINE';--3872371
6789:
6790: l_tax_code VARCHAR2(50);

Line 6795: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;

6791: l_vat_tax_id NUMBER ;
6792: l_organization_id NUMBER ;
6793: l_warehouse_id NUMBER;
6794: l_sob_id NUMBER;
6795: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
6796: l_inventory_item_id ra_customer_trx_lines.inventory_item_id%type;
6797: l_autotax ra_customer_trx_lines.autotax%type;
6798: l_amt_incl_tax_flag ar_vat_tax.amount_includes_tax_flag%type;
6799: l_amt_incl_tax_override ar_vat_tax.amount_includes_tax_override%type;

Line 6796: l_inventory_item_id ra_customer_trx_lines.inventory_item_id%type;

6792: l_organization_id NUMBER ;
6793: l_warehouse_id NUMBER;
6794: l_sob_id NUMBER;
6795: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
6796: l_inventory_item_id ra_customer_trx_lines.inventory_item_id%type;
6797: l_autotax ra_customer_trx_lines.autotax%type;
6798: l_amt_incl_tax_flag ar_vat_tax.amount_includes_tax_flag%type;
6799: l_amt_incl_tax_override ar_vat_tax.amount_includes_tax_override%type;
6800: /* bug fix : 1070949 */

Line 6797: l_autotax ra_customer_trx_lines.autotax%type;

6793: l_warehouse_id NUMBER;
6794: l_sob_id NUMBER;
6795: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
6796: l_inventory_item_id ra_customer_trx_lines.inventory_item_id%type;
6797: l_autotax ra_customer_trx_lines.autotax%type;
6798: l_amt_incl_tax_flag ar_vat_tax.amount_includes_tax_flag%type;
6799: l_amt_incl_tax_override ar_vat_tax.amount_includes_tax_override%type;
6800: /* bug fix : 1070949 */
6801: l_tax_calculation_flag varchar2(1);

Line 6879: p_entity_code => 'RA_CUSTOMER_TRX',

6875: p_cust_trx_id => p_customer_trx_id,
6876: p_cust_trx_line_id => line.customer_trx_line_id,
6877: p_customer_id => NULL,
6878: p_memo_line_id => line.memo_line_id,
6879: p_entity_code => 'RA_CUSTOMER_TRX',
6880: p_event_class_code => l_event_class_code,
6881: p_function_short_name => 'GL_ACCT_FIXUP',
6882: p_tax_classification_code => l_tax_code );
6883:

Line 6898: --- UPDATE RA_CUSTOMER_TRX_LINES with new

6894: END;
6895:
6896: IF l_tax_code IS NOT NULL
6897: THEN
6898: --- UPDATE RA_CUSTOMER_TRX_LINES with new
6899: --- tax_code and autotax='Y'
6900: update ra_customer_trx_lines
6901: set tax_classification_code = l_tax_code,
6902: autotax = l_autotax

Line 6900: update ra_customer_trx_lines

6896: IF l_tax_code IS NOT NULL
6897: THEN
6898: --- UPDATE RA_CUSTOMER_TRX_LINES with new
6899: --- tax_code and autotax='Y'
6900: update ra_customer_trx_lines
6901: set tax_classification_code = l_tax_code,
6902: autotax = l_autotax
6903: where customer_trx_line_id = line.customer_trx_line_id;
6904: END IF;

Line 6930: p_entity_code => 'RA_CUSTOMER_TRX',

6926: p_cust_trx_id => p_customer_trx_id,
6927: p_cust_trx_line_id => line.customer_trx_line_id,
6928: p_customer_id => NULL,
6929: p_memo_line_id => line.memo_line_id,
6930: p_entity_code => 'RA_CUSTOMER_TRX',
6931: p_event_class_code => l_event_class_code,
6932: p_function_short_name => 'ACCT_DIST',
6933: p_tax_classification_code => l_tax_code );
6934: ELSE

Line 6951: update ra_customer_trx_lines

6947: l_tax_code := NULL;
6948: l_autotax := 'Y';
6949: END;
6950:
6951: update ra_customer_trx_lines
6952: set tax_classification_code = l_tax_code,
6953: autotax = l_autotax
6954: where customer_trx_line_id = line.customer_trx_line_id;
6955:

Line 7132: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

7128: | Global parameters are also passed. |
7129: +===========================================================================*/
7130:
7131: PROCEDURE lock_compare_cover(
7132: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
7133: p_trx_number IN ra_customer_trx.trx_number%type,
7134: p_posting_control_id IN ra_customer_trx.posting_control_id%type,
7135: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
7136: p_complete_flag IN ra_customer_trx.complete_flag%type,

Line 7133: p_trx_number IN ra_customer_trx.trx_number%type,

7129: +===========================================================================*/
7130:
7131: PROCEDURE lock_compare_cover(
7132: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
7133: p_trx_number IN ra_customer_trx.trx_number%type,
7134: p_posting_control_id IN ra_customer_trx.posting_control_id%type,
7135: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
7136: p_complete_flag IN ra_customer_trx.complete_flag%type,
7137: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,

Line 7134: p_posting_control_id IN ra_customer_trx.posting_control_id%type,

7130:
7131: PROCEDURE lock_compare_cover(
7132: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
7133: p_trx_number IN ra_customer_trx.trx_number%type,
7134: p_posting_control_id IN ra_customer_trx.posting_control_id%type,
7135: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
7136: p_complete_flag IN ra_customer_trx.complete_flag%type,
7137: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
7138: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,

Line 7135: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,

7131: PROCEDURE lock_compare_cover(
7132: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
7133: p_trx_number IN ra_customer_trx.trx_number%type,
7134: p_posting_control_id IN ra_customer_trx.posting_control_id%type,
7135: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
7136: p_complete_flag IN ra_customer_trx.complete_flag%type,
7137: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
7138: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
7139: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,

Line 7136: p_complete_flag IN ra_customer_trx.complete_flag%type,

7132: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
7133: p_trx_number IN ra_customer_trx.trx_number%type,
7134: p_posting_control_id IN ra_customer_trx.posting_control_id%type,
7135: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
7136: p_complete_flag IN ra_customer_trx.complete_flag%type,
7137: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
7138: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
7139: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
7140: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,

Line 7137: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,

7133: p_trx_number IN ra_customer_trx.trx_number%type,
7134: p_posting_control_id IN ra_customer_trx.posting_control_id%type,
7135: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
7136: p_complete_flag IN ra_customer_trx.complete_flag%type,
7137: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
7138: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
7139: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
7140: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
7141: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,

Line 7138: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,

7134: p_posting_control_id IN ra_customer_trx.posting_control_id%type,
7135: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
7136: p_complete_flag IN ra_customer_trx.complete_flag%type,
7137: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
7138: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
7139: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
7140: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
7141: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
7142: p_batch_id IN ra_customer_trx.batch_id%type,

Line 7139: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,

7135: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
7136: p_complete_flag IN ra_customer_trx.complete_flag%type,
7137: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
7138: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
7139: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
7140: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
7141: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
7142: p_batch_id IN ra_customer_trx.batch_id%type,
7143: p_batch_source_id IN ra_customer_trx.batch_source_id%type,

Line 7140: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,

7136: p_complete_flag IN ra_customer_trx.complete_flag%type,
7137: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
7138: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
7139: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
7140: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
7141: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
7142: p_batch_id IN ra_customer_trx.batch_id%type,
7143: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
7144: p_agreement_id IN ra_customer_trx.agreement_id%type,

Line 7141: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,

7137: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
7138: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
7139: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
7140: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
7141: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
7142: p_batch_id IN ra_customer_trx.batch_id%type,
7143: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
7144: p_agreement_id IN ra_customer_trx.agreement_id%type,
7145: p_trx_date IN ra_customer_trx.trx_date%type,

Line 7142: p_batch_id IN ra_customer_trx.batch_id%type,

7138: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
7139: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
7140: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
7141: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
7142: p_batch_id IN ra_customer_trx.batch_id%type,
7143: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
7144: p_agreement_id IN ra_customer_trx.agreement_id%type,
7145: p_trx_date IN ra_customer_trx.trx_date%type,
7146: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,

Line 7143: p_batch_source_id IN ra_customer_trx.batch_source_id%type,

7139: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
7140: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
7141: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
7142: p_batch_id IN ra_customer_trx.batch_id%type,
7143: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
7144: p_agreement_id IN ra_customer_trx.agreement_id%type,
7145: p_trx_date IN ra_customer_trx.trx_date%type,
7146: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
7147: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,

Line 7144: p_agreement_id IN ra_customer_trx.agreement_id%type,

7140: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
7141: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
7142: p_batch_id IN ra_customer_trx.batch_id%type,
7143: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
7144: p_agreement_id IN ra_customer_trx.agreement_id%type,
7145: p_trx_date IN ra_customer_trx.trx_date%type,
7146: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
7147: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
7148: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,

Line 7145: p_trx_date IN ra_customer_trx.trx_date%type,

7141: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
7142: p_batch_id IN ra_customer_trx.batch_id%type,
7143: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
7144: p_agreement_id IN ra_customer_trx.agreement_id%type,
7145: p_trx_date IN ra_customer_trx.trx_date%type,
7146: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
7147: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
7148: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
7149: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,

Line 7146: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,

7142: p_batch_id IN ra_customer_trx.batch_id%type,
7143: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
7144: p_agreement_id IN ra_customer_trx.agreement_id%type,
7145: p_trx_date IN ra_customer_trx.trx_date%type,
7146: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
7147: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
7148: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
7149: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
7150: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,

Line 7147: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,

7143: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
7144: p_agreement_id IN ra_customer_trx.agreement_id%type,
7145: p_trx_date IN ra_customer_trx.trx_date%type,
7146: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
7147: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
7148: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
7149: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
7150: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
7151: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,

Line 7148: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,

7144: p_agreement_id IN ra_customer_trx.agreement_id%type,
7145: p_trx_date IN ra_customer_trx.trx_date%type,
7146: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
7147: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
7148: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
7149: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
7150: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
7151: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
7152: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,

Line 7149: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,

7145: p_trx_date IN ra_customer_trx.trx_date%type,
7146: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
7147: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
7148: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
7149: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
7150: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
7151: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
7152: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
7153: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,

Line 7150: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,

7146: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
7147: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
7148: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
7149: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
7150: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
7151: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
7152: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
7153: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
7154: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,

Line 7151: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,

7147: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
7148: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
7149: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
7150: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
7151: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
7152: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
7153: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
7154: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
7155: p_customer_reference IN ra_customer_trx.customer_reference%type,

Line 7152: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,

7148: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
7149: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
7150: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
7151: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
7152: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
7153: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
7154: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
7155: p_customer_reference IN ra_customer_trx.customer_reference%type,
7156: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,

Line 7153: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,

7149: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
7150: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
7151: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
7152: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
7153: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
7154: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
7155: p_customer_reference IN ra_customer_trx.customer_reference%type,
7156: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
7157: p_cr_method_for_installments IN

Line 7154: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,

7150: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
7151: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
7152: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
7153: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
7154: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
7155: p_customer_reference IN ra_customer_trx.customer_reference%type,
7156: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
7157: p_cr_method_for_installments IN
7158: ra_customer_trx.credit_method_for_installments%type,

Line 7155: p_customer_reference IN ra_customer_trx.customer_reference%type,

7151: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
7152: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
7153: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
7154: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
7155: p_customer_reference IN ra_customer_trx.customer_reference%type,
7156: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
7157: p_cr_method_for_installments IN
7158: ra_customer_trx.credit_method_for_installments%type,
7159: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,

Line 7156: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,

7152: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
7153: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
7154: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
7155: p_customer_reference IN ra_customer_trx.customer_reference%type,
7156: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
7157: p_cr_method_for_installments IN
7158: ra_customer_trx.credit_method_for_installments%type,
7159: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
7160: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,

Line 7158: ra_customer_trx.credit_method_for_installments%type,

7154: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
7155: p_customer_reference IN ra_customer_trx.customer_reference%type,
7156: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
7157: p_cr_method_for_installments IN
7158: ra_customer_trx.credit_method_for_installments%type,
7159: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
7160: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
7161: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
7162: p_exchange_date IN ra_customer_trx.exchange_date%type,

Line 7159: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,

7155: p_customer_reference IN ra_customer_trx.customer_reference%type,
7156: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
7157: p_cr_method_for_installments IN
7158: ra_customer_trx.credit_method_for_installments%type,
7159: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
7160: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
7161: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
7162: p_exchange_date IN ra_customer_trx.exchange_date%type,
7163: p_exchange_rate IN ra_customer_trx.exchange_rate%type,

Line 7160: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,

7156: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
7157: p_cr_method_for_installments IN
7158: ra_customer_trx.credit_method_for_installments%type,
7159: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
7160: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
7161: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
7162: p_exchange_date IN ra_customer_trx.exchange_date%type,
7163: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
7164: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,

Line 7161: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,

7157: p_cr_method_for_installments IN
7158: ra_customer_trx.credit_method_for_installments%type,
7159: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
7160: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
7161: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
7162: p_exchange_date IN ra_customer_trx.exchange_date%type,
7163: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
7164: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
7165: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,

Line 7162: p_exchange_date IN ra_customer_trx.exchange_date%type,

7158: ra_customer_trx.credit_method_for_installments%type,
7159: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
7160: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
7161: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
7162: p_exchange_date IN ra_customer_trx.exchange_date%type,
7163: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
7164: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
7165: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
7166: p_finance_charges IN ra_customer_trx.finance_charges%type,

Line 7163: p_exchange_rate IN ra_customer_trx.exchange_rate%type,

7159: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
7160: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
7161: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
7162: p_exchange_date IN ra_customer_trx.exchange_date%type,
7163: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
7164: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
7165: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
7166: p_finance_charges IN ra_customer_trx.finance_charges%type,
7167: p_fob_point IN ra_customer_trx.fob_point%type,

Line 7164: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,

7160: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
7161: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
7162: p_exchange_date IN ra_customer_trx.exchange_date%type,
7163: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
7164: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
7165: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
7166: p_finance_charges IN ra_customer_trx.finance_charges%type,
7167: p_fob_point IN ra_customer_trx.fob_point%type,
7168: p_comments IN ra_customer_trx.comments%type,

Line 7165: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,

7161: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
7162: p_exchange_date IN ra_customer_trx.exchange_date%type,
7163: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
7164: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
7165: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
7166: p_finance_charges IN ra_customer_trx.finance_charges%type,
7167: p_fob_point IN ra_customer_trx.fob_point%type,
7168: p_comments IN ra_customer_trx.comments%type,
7169: p_internal_notes IN ra_customer_trx.internal_notes%type,

Line 7166: p_finance_charges IN ra_customer_trx.finance_charges%type,

7162: p_exchange_date IN ra_customer_trx.exchange_date%type,
7163: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
7164: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
7165: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
7166: p_finance_charges IN ra_customer_trx.finance_charges%type,
7167: p_fob_point IN ra_customer_trx.fob_point%type,
7168: p_comments IN ra_customer_trx.comments%type,
7169: p_internal_notes IN ra_customer_trx.internal_notes%type,
7170: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,

Line 7167: p_fob_point IN ra_customer_trx.fob_point%type,

7163: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
7164: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
7165: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
7166: p_finance_charges IN ra_customer_trx.finance_charges%type,
7167: p_fob_point IN ra_customer_trx.fob_point%type,
7168: p_comments IN ra_customer_trx.comments%type,
7169: p_internal_notes IN ra_customer_trx.internal_notes%type,
7170: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
7171: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,

Line 7168: p_comments IN ra_customer_trx.comments%type,

7164: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
7165: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
7166: p_finance_charges IN ra_customer_trx.finance_charges%type,
7167: p_fob_point IN ra_customer_trx.fob_point%type,
7168: p_comments IN ra_customer_trx.comments%type,
7169: p_internal_notes IN ra_customer_trx.internal_notes%type,
7170: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
7171: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
7172: p_last_printed_sequence_num IN

Line 7169: p_internal_notes IN ra_customer_trx.internal_notes%type,

7165: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
7166: p_finance_charges IN ra_customer_trx.finance_charges%type,
7167: p_fob_point IN ra_customer_trx.fob_point%type,
7168: p_comments IN ra_customer_trx.comments%type,
7169: p_internal_notes IN ra_customer_trx.internal_notes%type,
7170: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
7171: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
7172: p_last_printed_sequence_num IN
7173: ra_customer_trx.last_printed_sequence_num%type,

Line 7170: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,

7166: p_finance_charges IN ra_customer_trx.finance_charges%type,
7167: p_fob_point IN ra_customer_trx.fob_point%type,
7168: p_comments IN ra_customer_trx.comments%type,
7169: p_internal_notes IN ra_customer_trx.internal_notes%type,
7170: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
7171: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
7172: p_last_printed_sequence_num IN
7173: ra_customer_trx.last_printed_sequence_num%type,
7174: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,

Line 7171: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,

7167: p_fob_point IN ra_customer_trx.fob_point%type,
7168: p_comments IN ra_customer_trx.comments%type,
7169: p_internal_notes IN ra_customer_trx.internal_notes%type,
7170: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
7171: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
7172: p_last_printed_sequence_num IN
7173: ra_customer_trx.last_printed_sequence_num%type,
7174: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
7175: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,

Line 7173: ra_customer_trx.last_printed_sequence_num%type,

7169: p_internal_notes IN ra_customer_trx.internal_notes%type,
7170: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
7171: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
7172: p_last_printed_sequence_num IN
7173: ra_customer_trx.last_printed_sequence_num%type,
7174: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
7175: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
7176: p_printing_count IN ra_customer_trx.printing_count%type,
7177: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,

Line 7174: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,

7170: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
7171: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
7172: p_last_printed_sequence_num IN
7173: ra_customer_trx.last_printed_sequence_num%type,
7174: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
7175: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
7176: p_printing_count IN ra_customer_trx.printing_count%type,
7177: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
7178: p_printing_option IN ra_customer_trx.printing_option%type,

Line 7175: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,

7171: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
7172: p_last_printed_sequence_num IN
7173: ra_customer_trx.last_printed_sequence_num%type,
7174: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
7175: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
7176: p_printing_count IN ra_customer_trx.printing_count%type,
7177: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
7178: p_printing_option IN ra_customer_trx.printing_option%type,
7179: p_printing_original_date IN ra_customer_trx.printing_original_date%type,

Line 7176: p_printing_count IN ra_customer_trx.printing_count%type,

7172: p_last_printed_sequence_num IN
7173: ra_customer_trx.last_printed_sequence_num%type,
7174: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
7175: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
7176: p_printing_count IN ra_customer_trx.printing_count%type,
7177: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
7178: p_printing_option IN ra_customer_trx.printing_option%type,
7179: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
7180: p_printing_pending IN ra_customer_trx.printing_pending%type,

Line 7177: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,

7173: ra_customer_trx.last_printed_sequence_num%type,
7174: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
7175: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
7176: p_printing_count IN ra_customer_trx.printing_count%type,
7177: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
7178: p_printing_option IN ra_customer_trx.printing_option%type,
7179: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
7180: p_printing_pending IN ra_customer_trx.printing_pending%type,
7181: p_purchase_order IN ra_customer_trx.purchase_order%type,

Line 7178: p_printing_option IN ra_customer_trx.printing_option%type,

7174: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
7175: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
7176: p_printing_count IN ra_customer_trx.printing_count%type,
7177: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
7178: p_printing_option IN ra_customer_trx.printing_option%type,
7179: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
7180: p_printing_pending IN ra_customer_trx.printing_pending%type,
7181: p_purchase_order IN ra_customer_trx.purchase_order%type,
7182: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,

Line 7179: p_printing_original_date IN ra_customer_trx.printing_original_date%type,

7175: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
7176: p_printing_count IN ra_customer_trx.printing_count%type,
7177: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
7178: p_printing_option IN ra_customer_trx.printing_option%type,
7179: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
7180: p_printing_pending IN ra_customer_trx.printing_pending%type,
7181: p_purchase_order IN ra_customer_trx.purchase_order%type,
7182: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
7183: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,

Line 7180: p_printing_pending IN ra_customer_trx.printing_pending%type,

7176: p_printing_count IN ra_customer_trx.printing_count%type,
7177: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
7178: p_printing_option IN ra_customer_trx.printing_option%type,
7179: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
7180: p_printing_pending IN ra_customer_trx.printing_pending%type,
7181: p_purchase_order IN ra_customer_trx.purchase_order%type,
7182: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
7183: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
7184: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,

Line 7181: p_purchase_order IN ra_customer_trx.purchase_order%type,

7177: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
7178: p_printing_option IN ra_customer_trx.printing_option%type,
7179: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
7180: p_printing_pending IN ra_customer_trx.printing_pending%type,
7181: p_purchase_order IN ra_customer_trx.purchase_order%type,
7182: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
7183: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
7184: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
7185: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,

Line 7182: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,

7178: p_printing_option IN ra_customer_trx.printing_option%type,
7179: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
7180: p_printing_pending IN ra_customer_trx.printing_pending%type,
7181: p_purchase_order IN ra_customer_trx.purchase_order%type,
7182: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
7183: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
7184: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
7185: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
7186: p_shipment_id IN ra_customer_trx.shipment_id%type,

Line 7183: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,

7179: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
7180: p_printing_pending IN ra_customer_trx.printing_pending%type,
7181: p_purchase_order IN ra_customer_trx.purchase_order%type,
7182: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
7183: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
7184: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
7185: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
7186: p_shipment_id IN ra_customer_trx.shipment_id%type,
7187: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,

Line 7184: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,

7180: p_printing_pending IN ra_customer_trx.printing_pending%type,
7181: p_purchase_order IN ra_customer_trx.purchase_order%type,
7182: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
7183: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
7184: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
7185: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
7186: p_shipment_id IN ra_customer_trx.shipment_id%type,
7187: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
7188: p_ship_via IN ra_customer_trx.ship_via%type,

Line 7185: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,

7181: p_purchase_order IN ra_customer_trx.purchase_order%type,
7182: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
7183: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
7184: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
7185: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
7186: p_shipment_id IN ra_customer_trx.shipment_id%type,
7187: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
7188: p_ship_via IN ra_customer_trx.ship_via%type,
7189: p_term_due_date IN ra_customer_trx.term_due_date%type,

Line 7186: p_shipment_id IN ra_customer_trx.shipment_id%type,

7182: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
7183: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
7184: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
7185: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
7186: p_shipment_id IN ra_customer_trx.shipment_id%type,
7187: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
7188: p_ship_via IN ra_customer_trx.ship_via%type,
7189: p_term_due_date IN ra_customer_trx.term_due_date%type,
7190: p_term_id IN ra_customer_trx.term_id%type,

Line 7187: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,

7183: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
7184: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
7185: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
7186: p_shipment_id IN ra_customer_trx.shipment_id%type,
7187: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
7188: p_ship_via IN ra_customer_trx.ship_via%type,
7189: p_term_due_date IN ra_customer_trx.term_due_date%type,
7190: p_term_id IN ra_customer_trx.term_id%type,
7191: p_territory_id IN ra_customer_trx.territory_id%type,

Line 7188: p_ship_via IN ra_customer_trx.ship_via%type,

7184: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
7185: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
7186: p_shipment_id IN ra_customer_trx.shipment_id%type,
7187: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
7188: p_ship_via IN ra_customer_trx.ship_via%type,
7189: p_term_due_date IN ra_customer_trx.term_due_date%type,
7190: p_term_id IN ra_customer_trx.term_id%type,
7191: p_territory_id IN ra_customer_trx.territory_id%type,
7192: p_waybill_number IN ra_customer_trx.waybill_number%type,

Line 7189: p_term_due_date IN ra_customer_trx.term_due_date%type,

7185: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
7186: p_shipment_id IN ra_customer_trx.shipment_id%type,
7187: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
7188: p_ship_via IN ra_customer_trx.ship_via%type,
7189: p_term_due_date IN ra_customer_trx.term_due_date%type,
7190: p_term_id IN ra_customer_trx.term_id%type,
7191: p_territory_id IN ra_customer_trx.territory_id%type,
7192: p_waybill_number IN ra_customer_trx.waybill_number%type,
7193: p_status_trx IN ra_customer_trx.status_trx%type,

Line 7190: p_term_id IN ra_customer_trx.term_id%type,

7186: p_shipment_id IN ra_customer_trx.shipment_id%type,
7187: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
7188: p_ship_via IN ra_customer_trx.ship_via%type,
7189: p_term_due_date IN ra_customer_trx.term_due_date%type,
7190: p_term_id IN ra_customer_trx.term_id%type,
7191: p_territory_id IN ra_customer_trx.territory_id%type,
7192: p_waybill_number IN ra_customer_trx.waybill_number%type,
7193: p_status_trx IN ra_customer_trx.status_trx%type,
7194: p_reason_code IN ra_customer_trx.reason_code%type,

Line 7191: p_territory_id IN ra_customer_trx.territory_id%type,

7187: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
7188: p_ship_via IN ra_customer_trx.ship_via%type,
7189: p_term_due_date IN ra_customer_trx.term_due_date%type,
7190: p_term_id IN ra_customer_trx.term_id%type,
7191: p_territory_id IN ra_customer_trx.territory_id%type,
7192: p_waybill_number IN ra_customer_trx.waybill_number%type,
7193: p_status_trx IN ra_customer_trx.status_trx%type,
7194: p_reason_code IN ra_customer_trx.reason_code%type,
7195: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,

Line 7192: p_waybill_number IN ra_customer_trx.waybill_number%type,

7188: p_ship_via IN ra_customer_trx.ship_via%type,
7189: p_term_due_date IN ra_customer_trx.term_due_date%type,
7190: p_term_id IN ra_customer_trx.term_id%type,
7191: p_territory_id IN ra_customer_trx.territory_id%type,
7192: p_waybill_number IN ra_customer_trx.waybill_number%type,
7193: p_status_trx IN ra_customer_trx.status_trx%type,
7194: p_reason_code IN ra_customer_trx.reason_code%type,
7195: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
7196: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,

Line 7193: p_status_trx IN ra_customer_trx.status_trx%type,

7189: p_term_due_date IN ra_customer_trx.term_due_date%type,
7190: p_term_id IN ra_customer_trx.term_id%type,
7191: p_territory_id IN ra_customer_trx.territory_id%type,
7192: p_waybill_number IN ra_customer_trx.waybill_number%type,
7193: p_status_trx IN ra_customer_trx.status_trx%type,
7194: p_reason_code IN ra_customer_trx.reason_code%type,
7195: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
7196: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
7197: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,

Line 7194: p_reason_code IN ra_customer_trx.reason_code%type,

7190: p_term_id IN ra_customer_trx.term_id%type,
7191: p_territory_id IN ra_customer_trx.territory_id%type,
7192: p_waybill_number IN ra_customer_trx.waybill_number%type,
7193: p_status_trx IN ra_customer_trx.status_trx%type,
7194: p_reason_code IN ra_customer_trx.reason_code%type,
7195: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
7196: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
7197: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
7198: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,

Line 7195: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,

7191: p_territory_id IN ra_customer_trx.territory_id%type,
7192: p_waybill_number IN ra_customer_trx.waybill_number%type,
7193: p_status_trx IN ra_customer_trx.status_trx%type,
7194: p_reason_code IN ra_customer_trx.reason_code%type,
7195: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
7196: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
7197: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
7198: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
7199: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,

Line 7196: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,

7192: p_waybill_number IN ra_customer_trx.waybill_number%type,
7193: p_status_trx IN ra_customer_trx.status_trx%type,
7194: p_reason_code IN ra_customer_trx.reason_code%type,
7195: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
7196: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
7197: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
7198: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
7199: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
7200: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,

Line 7197: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,

7193: p_status_trx IN ra_customer_trx.status_trx%type,
7194: p_reason_code IN ra_customer_trx.reason_code%type,
7195: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
7196: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
7197: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
7198: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
7199: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
7200: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,
7201: p_created_from IN ra_customer_trx.created_from%type,

Line 7198: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,

7194: p_reason_code IN ra_customer_trx.reason_code%type,
7195: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
7196: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
7197: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
7198: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
7199: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
7200: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,
7201: p_created_from IN ra_customer_trx.created_from%type,
7202: p_deflt_ussgl_trx_code_context IN

Line 7199: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,

7195: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
7196: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
7197: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
7198: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
7199: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
7200: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,
7201: p_created_from IN ra_customer_trx.created_from%type,
7202: p_deflt_ussgl_trx_code_context IN
7203: ra_customer_trx.default_ussgl_trx_code_context%type,

Line 7200: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,

7196: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
7197: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
7198: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
7199: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
7200: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,
7201: p_created_from IN ra_customer_trx.created_from%type,
7202: p_deflt_ussgl_trx_code_context IN
7203: ra_customer_trx.default_ussgl_trx_code_context%type,
7204: p_deflt_ussgl_transaction_code IN

Line 7201: p_created_from IN ra_customer_trx.created_from%type,

7197: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
7198: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
7199: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
7200: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,
7201: p_created_from IN ra_customer_trx.created_from%type,
7202: p_deflt_ussgl_trx_code_context IN
7203: ra_customer_trx.default_ussgl_trx_code_context%type,
7204: p_deflt_ussgl_transaction_code IN
7205: ra_customer_trx.default_ussgl_transaction_code%type,

Line 7203: ra_customer_trx.default_ussgl_trx_code_context%type,

7199: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
7200: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,
7201: p_created_from IN ra_customer_trx.created_from%type,
7202: p_deflt_ussgl_trx_code_context IN
7203: ra_customer_trx.default_ussgl_trx_code_context%type,
7204: p_deflt_ussgl_transaction_code IN
7205: ra_customer_trx.default_ussgl_transaction_code%type,
7206: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
7207: p_interface_header_context IN

Line 7205: ra_customer_trx.default_ussgl_transaction_code%type,

7201: p_created_from IN ra_customer_trx.created_from%type,
7202: p_deflt_ussgl_trx_code_context IN
7203: ra_customer_trx.default_ussgl_trx_code_context%type,
7204: p_deflt_ussgl_transaction_code IN
7205: ra_customer_trx.default_ussgl_transaction_code%type,
7206: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
7207: p_interface_header_context IN
7208: ra_customer_trx.interface_header_context%type,
7209: p_interface_header_attribute1 IN

Line 7206: p_old_trx_number IN ra_customer_trx.old_trx_number%type,

7202: p_deflt_ussgl_trx_code_context IN
7203: ra_customer_trx.default_ussgl_trx_code_context%type,
7204: p_deflt_ussgl_transaction_code IN
7205: ra_customer_trx.default_ussgl_transaction_code%type,
7206: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
7207: p_interface_header_context IN
7208: ra_customer_trx.interface_header_context%type,
7209: p_interface_header_attribute1 IN
7210: ra_customer_trx.interface_header_attribute1%type,

Line 7208: ra_customer_trx.interface_header_context%type,

7204: p_deflt_ussgl_transaction_code IN
7205: ra_customer_trx.default_ussgl_transaction_code%type,
7206: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
7207: p_interface_header_context IN
7208: ra_customer_trx.interface_header_context%type,
7209: p_interface_header_attribute1 IN
7210: ra_customer_trx.interface_header_attribute1%type,
7211: p_interface_header_attribute2 IN
7212: ra_customer_trx.interface_header_attribute2%type,

Line 7210: ra_customer_trx.interface_header_attribute1%type,

7206: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
7207: p_interface_header_context IN
7208: ra_customer_trx.interface_header_context%type,
7209: p_interface_header_attribute1 IN
7210: ra_customer_trx.interface_header_attribute1%type,
7211: p_interface_header_attribute2 IN
7212: ra_customer_trx.interface_header_attribute2%type,
7213: p_interface_header_attribute3 IN
7214: ra_customer_trx.interface_header_attribute3%type,

Line 7212: ra_customer_trx.interface_header_attribute2%type,

7208: ra_customer_trx.interface_header_context%type,
7209: p_interface_header_attribute1 IN
7210: ra_customer_trx.interface_header_attribute1%type,
7211: p_interface_header_attribute2 IN
7212: ra_customer_trx.interface_header_attribute2%type,
7213: p_interface_header_attribute3 IN
7214: ra_customer_trx.interface_header_attribute3%type,
7215: p_interface_header_attribute4 IN
7216: ra_customer_trx.interface_header_attribute4%type,

Line 7214: ra_customer_trx.interface_header_attribute3%type,

7210: ra_customer_trx.interface_header_attribute1%type,
7211: p_interface_header_attribute2 IN
7212: ra_customer_trx.interface_header_attribute2%type,
7213: p_interface_header_attribute3 IN
7214: ra_customer_trx.interface_header_attribute3%type,
7215: p_interface_header_attribute4 IN
7216: ra_customer_trx.interface_header_attribute4%type,
7217: p_interface_header_attribute5 IN
7218: ra_customer_trx.interface_header_attribute5%type,

Line 7216: ra_customer_trx.interface_header_attribute4%type,

7212: ra_customer_trx.interface_header_attribute2%type,
7213: p_interface_header_attribute3 IN
7214: ra_customer_trx.interface_header_attribute3%type,
7215: p_interface_header_attribute4 IN
7216: ra_customer_trx.interface_header_attribute4%type,
7217: p_interface_header_attribute5 IN
7218: ra_customer_trx.interface_header_attribute5%type,
7219: p_interface_header_attribute6 IN
7220: ra_customer_trx.interface_header_attribute6%type,

Line 7218: ra_customer_trx.interface_header_attribute5%type,

7214: ra_customer_trx.interface_header_attribute3%type,
7215: p_interface_header_attribute4 IN
7216: ra_customer_trx.interface_header_attribute4%type,
7217: p_interface_header_attribute5 IN
7218: ra_customer_trx.interface_header_attribute5%type,
7219: p_interface_header_attribute6 IN
7220: ra_customer_trx.interface_header_attribute6%type,
7221: p_interface_header_attribute7 IN
7222: ra_customer_trx.interface_header_attribute7%type,

Line 7220: ra_customer_trx.interface_header_attribute6%type,

7216: ra_customer_trx.interface_header_attribute4%type,
7217: p_interface_header_attribute5 IN
7218: ra_customer_trx.interface_header_attribute5%type,
7219: p_interface_header_attribute6 IN
7220: ra_customer_trx.interface_header_attribute6%type,
7221: p_interface_header_attribute7 IN
7222: ra_customer_trx.interface_header_attribute7%type,
7223: p_interface_header_attribute8 IN
7224: ra_customer_trx.interface_header_attribute8%type,

Line 7222: ra_customer_trx.interface_header_attribute7%type,

7218: ra_customer_trx.interface_header_attribute5%type,
7219: p_interface_header_attribute6 IN
7220: ra_customer_trx.interface_header_attribute6%type,
7221: p_interface_header_attribute7 IN
7222: ra_customer_trx.interface_header_attribute7%type,
7223: p_interface_header_attribute8 IN
7224: ra_customer_trx.interface_header_attribute8%type,
7225: p_interface_header_attribute9 IN
7226: ra_customer_trx.interface_header_attribute9%type,

Line 7224: ra_customer_trx.interface_header_attribute8%type,

7220: ra_customer_trx.interface_header_attribute6%type,
7221: p_interface_header_attribute7 IN
7222: ra_customer_trx.interface_header_attribute7%type,
7223: p_interface_header_attribute8 IN
7224: ra_customer_trx.interface_header_attribute8%type,
7225: p_interface_header_attribute9 IN
7226: ra_customer_trx.interface_header_attribute9%type,
7227: p_interface_header_attribute10 IN
7228: ra_customer_trx.interface_header_attribute10%type,

Line 7226: ra_customer_trx.interface_header_attribute9%type,

7222: ra_customer_trx.interface_header_attribute7%type,
7223: p_interface_header_attribute8 IN
7224: ra_customer_trx.interface_header_attribute8%type,
7225: p_interface_header_attribute9 IN
7226: ra_customer_trx.interface_header_attribute9%type,
7227: p_interface_header_attribute10 IN
7228: ra_customer_trx.interface_header_attribute10%type,
7229: p_interface_header_attribute11 IN
7230: ra_customer_trx.interface_header_attribute11%type,

Line 7228: ra_customer_trx.interface_header_attribute10%type,

7224: ra_customer_trx.interface_header_attribute8%type,
7225: p_interface_header_attribute9 IN
7226: ra_customer_trx.interface_header_attribute9%type,
7227: p_interface_header_attribute10 IN
7228: ra_customer_trx.interface_header_attribute10%type,
7229: p_interface_header_attribute11 IN
7230: ra_customer_trx.interface_header_attribute11%type,
7231: p_interface_header_attribute12 IN
7232: ra_customer_trx.interface_header_attribute12%type,

Line 7230: ra_customer_trx.interface_header_attribute11%type,

7226: ra_customer_trx.interface_header_attribute9%type,
7227: p_interface_header_attribute10 IN
7228: ra_customer_trx.interface_header_attribute10%type,
7229: p_interface_header_attribute11 IN
7230: ra_customer_trx.interface_header_attribute11%type,
7231: p_interface_header_attribute12 IN
7232: ra_customer_trx.interface_header_attribute12%type,
7233: p_interface_header_attribute13 IN
7234: ra_customer_trx.interface_header_attribute13%type,

Line 7232: ra_customer_trx.interface_header_attribute12%type,

7228: ra_customer_trx.interface_header_attribute10%type,
7229: p_interface_header_attribute11 IN
7230: ra_customer_trx.interface_header_attribute11%type,
7231: p_interface_header_attribute12 IN
7232: ra_customer_trx.interface_header_attribute12%type,
7233: p_interface_header_attribute13 IN
7234: ra_customer_trx.interface_header_attribute13%type,
7235: p_interface_header_attribute14 IN
7236: ra_customer_trx.interface_header_attribute14%type,

Line 7234: ra_customer_trx.interface_header_attribute13%type,

7230: ra_customer_trx.interface_header_attribute11%type,
7231: p_interface_header_attribute12 IN
7232: ra_customer_trx.interface_header_attribute12%type,
7233: p_interface_header_attribute13 IN
7234: ra_customer_trx.interface_header_attribute13%type,
7235: p_interface_header_attribute14 IN
7236: ra_customer_trx.interface_header_attribute14%type,
7237: p_interface_header_attribute15 IN
7238: ra_customer_trx.interface_header_attribute15%type,

Line 7236: ra_customer_trx.interface_header_attribute14%type,

7232: ra_customer_trx.interface_header_attribute12%type,
7233: p_interface_header_attribute13 IN
7234: ra_customer_trx.interface_header_attribute13%type,
7235: p_interface_header_attribute14 IN
7236: ra_customer_trx.interface_header_attribute14%type,
7237: p_interface_header_attribute15 IN
7238: ra_customer_trx.interface_header_attribute15%type,
7239: p_attribute_category IN ra_customer_trx.attribute_category%type,
7240: p_attribute1 IN ra_customer_trx.attribute1%type,

Line 7238: ra_customer_trx.interface_header_attribute15%type,

7234: ra_customer_trx.interface_header_attribute13%type,
7235: p_interface_header_attribute14 IN
7236: ra_customer_trx.interface_header_attribute14%type,
7237: p_interface_header_attribute15 IN
7238: ra_customer_trx.interface_header_attribute15%type,
7239: p_attribute_category IN ra_customer_trx.attribute_category%type,
7240: p_attribute1 IN ra_customer_trx.attribute1%type,
7241: p_attribute2 IN ra_customer_trx.attribute2%type,
7242: p_attribute3 IN ra_customer_trx.attribute3%type,

Line 7239: p_attribute_category IN ra_customer_trx.attribute_category%type,

7235: p_interface_header_attribute14 IN
7236: ra_customer_trx.interface_header_attribute14%type,
7237: p_interface_header_attribute15 IN
7238: ra_customer_trx.interface_header_attribute15%type,
7239: p_attribute_category IN ra_customer_trx.attribute_category%type,
7240: p_attribute1 IN ra_customer_trx.attribute1%type,
7241: p_attribute2 IN ra_customer_trx.attribute2%type,
7242: p_attribute3 IN ra_customer_trx.attribute3%type,
7243: p_attribute4 IN ra_customer_trx.attribute4%type,

Line 7240: p_attribute1 IN ra_customer_trx.attribute1%type,

7236: ra_customer_trx.interface_header_attribute14%type,
7237: p_interface_header_attribute15 IN
7238: ra_customer_trx.interface_header_attribute15%type,
7239: p_attribute_category IN ra_customer_trx.attribute_category%type,
7240: p_attribute1 IN ra_customer_trx.attribute1%type,
7241: p_attribute2 IN ra_customer_trx.attribute2%type,
7242: p_attribute3 IN ra_customer_trx.attribute3%type,
7243: p_attribute4 IN ra_customer_trx.attribute4%type,
7244: p_attribute5 IN ra_customer_trx.attribute5%type,

Line 7241: p_attribute2 IN ra_customer_trx.attribute2%type,

7237: p_interface_header_attribute15 IN
7238: ra_customer_trx.interface_header_attribute15%type,
7239: p_attribute_category IN ra_customer_trx.attribute_category%type,
7240: p_attribute1 IN ra_customer_trx.attribute1%type,
7241: p_attribute2 IN ra_customer_trx.attribute2%type,
7242: p_attribute3 IN ra_customer_trx.attribute3%type,
7243: p_attribute4 IN ra_customer_trx.attribute4%type,
7244: p_attribute5 IN ra_customer_trx.attribute5%type,
7245: p_attribute6 IN ra_customer_trx.attribute6%type,

Line 7242: p_attribute3 IN ra_customer_trx.attribute3%type,

7238: ra_customer_trx.interface_header_attribute15%type,
7239: p_attribute_category IN ra_customer_trx.attribute_category%type,
7240: p_attribute1 IN ra_customer_trx.attribute1%type,
7241: p_attribute2 IN ra_customer_trx.attribute2%type,
7242: p_attribute3 IN ra_customer_trx.attribute3%type,
7243: p_attribute4 IN ra_customer_trx.attribute4%type,
7244: p_attribute5 IN ra_customer_trx.attribute5%type,
7245: p_attribute6 IN ra_customer_trx.attribute6%type,
7246: p_attribute7 IN ra_customer_trx.attribute7%type,

Line 7243: p_attribute4 IN ra_customer_trx.attribute4%type,

7239: p_attribute_category IN ra_customer_trx.attribute_category%type,
7240: p_attribute1 IN ra_customer_trx.attribute1%type,
7241: p_attribute2 IN ra_customer_trx.attribute2%type,
7242: p_attribute3 IN ra_customer_trx.attribute3%type,
7243: p_attribute4 IN ra_customer_trx.attribute4%type,
7244: p_attribute5 IN ra_customer_trx.attribute5%type,
7245: p_attribute6 IN ra_customer_trx.attribute6%type,
7246: p_attribute7 IN ra_customer_trx.attribute7%type,
7247: p_attribute8 IN ra_customer_trx.attribute8%type,

Line 7244: p_attribute5 IN ra_customer_trx.attribute5%type,

7240: p_attribute1 IN ra_customer_trx.attribute1%type,
7241: p_attribute2 IN ra_customer_trx.attribute2%type,
7242: p_attribute3 IN ra_customer_trx.attribute3%type,
7243: p_attribute4 IN ra_customer_trx.attribute4%type,
7244: p_attribute5 IN ra_customer_trx.attribute5%type,
7245: p_attribute6 IN ra_customer_trx.attribute6%type,
7246: p_attribute7 IN ra_customer_trx.attribute7%type,
7247: p_attribute8 IN ra_customer_trx.attribute8%type,
7248: p_attribute9 IN ra_customer_trx.attribute9%type,

Line 7245: p_attribute6 IN ra_customer_trx.attribute6%type,

7241: p_attribute2 IN ra_customer_trx.attribute2%type,
7242: p_attribute3 IN ra_customer_trx.attribute3%type,
7243: p_attribute4 IN ra_customer_trx.attribute4%type,
7244: p_attribute5 IN ra_customer_trx.attribute5%type,
7245: p_attribute6 IN ra_customer_trx.attribute6%type,
7246: p_attribute7 IN ra_customer_trx.attribute7%type,
7247: p_attribute8 IN ra_customer_trx.attribute8%type,
7248: p_attribute9 IN ra_customer_trx.attribute9%type,
7249: p_attribute10 IN ra_customer_trx.attribute10%type,

Line 7246: p_attribute7 IN ra_customer_trx.attribute7%type,

7242: p_attribute3 IN ra_customer_trx.attribute3%type,
7243: p_attribute4 IN ra_customer_trx.attribute4%type,
7244: p_attribute5 IN ra_customer_trx.attribute5%type,
7245: p_attribute6 IN ra_customer_trx.attribute6%type,
7246: p_attribute7 IN ra_customer_trx.attribute7%type,
7247: p_attribute8 IN ra_customer_trx.attribute8%type,
7248: p_attribute9 IN ra_customer_trx.attribute9%type,
7249: p_attribute10 IN ra_customer_trx.attribute10%type,
7250: p_attribute11 IN ra_customer_trx.attribute11%type,

Line 7247: p_attribute8 IN ra_customer_trx.attribute8%type,

7243: p_attribute4 IN ra_customer_trx.attribute4%type,
7244: p_attribute5 IN ra_customer_trx.attribute5%type,
7245: p_attribute6 IN ra_customer_trx.attribute6%type,
7246: p_attribute7 IN ra_customer_trx.attribute7%type,
7247: p_attribute8 IN ra_customer_trx.attribute8%type,
7248: p_attribute9 IN ra_customer_trx.attribute9%type,
7249: p_attribute10 IN ra_customer_trx.attribute10%type,
7250: p_attribute11 IN ra_customer_trx.attribute11%type,
7251: p_attribute12 IN ra_customer_trx.attribute12%type,

Line 7248: p_attribute9 IN ra_customer_trx.attribute9%type,

7244: p_attribute5 IN ra_customer_trx.attribute5%type,
7245: p_attribute6 IN ra_customer_trx.attribute6%type,
7246: p_attribute7 IN ra_customer_trx.attribute7%type,
7247: p_attribute8 IN ra_customer_trx.attribute8%type,
7248: p_attribute9 IN ra_customer_trx.attribute9%type,
7249: p_attribute10 IN ra_customer_trx.attribute10%type,
7250: p_attribute11 IN ra_customer_trx.attribute11%type,
7251: p_attribute12 IN ra_customer_trx.attribute12%type,
7252: p_attribute13 IN ra_customer_trx.attribute13%type,

Line 7249: p_attribute10 IN ra_customer_trx.attribute10%type,

7245: p_attribute6 IN ra_customer_trx.attribute6%type,
7246: p_attribute7 IN ra_customer_trx.attribute7%type,
7247: p_attribute8 IN ra_customer_trx.attribute8%type,
7248: p_attribute9 IN ra_customer_trx.attribute9%type,
7249: p_attribute10 IN ra_customer_trx.attribute10%type,
7250: p_attribute11 IN ra_customer_trx.attribute11%type,
7251: p_attribute12 IN ra_customer_trx.attribute12%type,
7252: p_attribute13 IN ra_customer_trx.attribute13%type,
7253: p_attribute14 IN ra_customer_trx.attribute14%type,

Line 7250: p_attribute11 IN ra_customer_trx.attribute11%type,

7246: p_attribute7 IN ra_customer_trx.attribute7%type,
7247: p_attribute8 IN ra_customer_trx.attribute8%type,
7248: p_attribute9 IN ra_customer_trx.attribute9%type,
7249: p_attribute10 IN ra_customer_trx.attribute10%type,
7250: p_attribute11 IN ra_customer_trx.attribute11%type,
7251: p_attribute12 IN ra_customer_trx.attribute12%type,
7252: p_attribute13 IN ra_customer_trx.attribute13%type,
7253: p_attribute14 IN ra_customer_trx.attribute14%type,
7254: p_attribute15 IN ra_customer_trx.attribute15%type,

Line 7251: p_attribute12 IN ra_customer_trx.attribute12%type,

7247: p_attribute8 IN ra_customer_trx.attribute8%type,
7248: p_attribute9 IN ra_customer_trx.attribute9%type,
7249: p_attribute10 IN ra_customer_trx.attribute10%type,
7250: p_attribute11 IN ra_customer_trx.attribute11%type,
7251: p_attribute12 IN ra_customer_trx.attribute12%type,
7252: p_attribute13 IN ra_customer_trx.attribute13%type,
7253: p_attribute14 IN ra_customer_trx.attribute14%type,
7254: p_attribute15 IN ra_customer_trx.attribute15%type,
7255: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type,

Line 7252: p_attribute13 IN ra_customer_trx.attribute13%type,

7248: p_attribute9 IN ra_customer_trx.attribute9%type,
7249: p_attribute10 IN ra_customer_trx.attribute10%type,
7250: p_attribute11 IN ra_customer_trx.attribute11%type,
7251: p_attribute12 IN ra_customer_trx.attribute12%type,
7252: p_attribute13 IN ra_customer_trx.attribute13%type,
7253: p_attribute14 IN ra_customer_trx.attribute14%type,
7254: p_attribute15 IN ra_customer_trx.attribute15%type,
7255: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type,
7256: p_global_attribute1 IN ra_customer_trx.global_attribute1%type,

Line 7253: p_attribute14 IN ra_customer_trx.attribute14%type,

7249: p_attribute10 IN ra_customer_trx.attribute10%type,
7250: p_attribute11 IN ra_customer_trx.attribute11%type,
7251: p_attribute12 IN ra_customer_trx.attribute12%type,
7252: p_attribute13 IN ra_customer_trx.attribute13%type,
7253: p_attribute14 IN ra_customer_trx.attribute14%type,
7254: p_attribute15 IN ra_customer_trx.attribute15%type,
7255: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type,
7256: p_global_attribute1 IN ra_customer_trx.global_attribute1%type,
7257: p_global_attribute2 IN ra_customer_trx.global_attribute2%type,

Line 7254: p_attribute15 IN ra_customer_trx.attribute15%type,

7250: p_attribute11 IN ra_customer_trx.attribute11%type,
7251: p_attribute12 IN ra_customer_trx.attribute12%type,
7252: p_attribute13 IN ra_customer_trx.attribute13%type,
7253: p_attribute14 IN ra_customer_trx.attribute14%type,
7254: p_attribute15 IN ra_customer_trx.attribute15%type,
7255: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type,
7256: p_global_attribute1 IN ra_customer_trx.global_attribute1%type,
7257: p_global_attribute2 IN ra_customer_trx.global_attribute2%type,
7258: p_global_attribute3 IN ra_customer_trx.global_attribute3%type,

Line 7255: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type,

7251: p_attribute12 IN ra_customer_trx.attribute12%type,
7252: p_attribute13 IN ra_customer_trx.attribute13%type,
7253: p_attribute14 IN ra_customer_trx.attribute14%type,
7254: p_attribute15 IN ra_customer_trx.attribute15%type,
7255: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type,
7256: p_global_attribute1 IN ra_customer_trx.global_attribute1%type,
7257: p_global_attribute2 IN ra_customer_trx.global_attribute2%type,
7258: p_global_attribute3 IN ra_customer_trx.global_attribute3%type,
7259: p_global_attribute4 IN ra_customer_trx.global_attribute4%type,

Line 7256: p_global_attribute1 IN ra_customer_trx.global_attribute1%type,

7252: p_attribute13 IN ra_customer_trx.attribute13%type,
7253: p_attribute14 IN ra_customer_trx.attribute14%type,
7254: p_attribute15 IN ra_customer_trx.attribute15%type,
7255: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type,
7256: p_global_attribute1 IN ra_customer_trx.global_attribute1%type,
7257: p_global_attribute2 IN ra_customer_trx.global_attribute2%type,
7258: p_global_attribute3 IN ra_customer_trx.global_attribute3%type,
7259: p_global_attribute4 IN ra_customer_trx.global_attribute4%type,
7260: p_global_attribute5 IN ra_customer_trx.global_attribute5%type,

Line 7257: p_global_attribute2 IN ra_customer_trx.global_attribute2%type,

7253: p_attribute14 IN ra_customer_trx.attribute14%type,
7254: p_attribute15 IN ra_customer_trx.attribute15%type,
7255: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type,
7256: p_global_attribute1 IN ra_customer_trx.global_attribute1%type,
7257: p_global_attribute2 IN ra_customer_trx.global_attribute2%type,
7258: p_global_attribute3 IN ra_customer_trx.global_attribute3%type,
7259: p_global_attribute4 IN ra_customer_trx.global_attribute4%type,
7260: p_global_attribute5 IN ra_customer_trx.global_attribute5%type,
7261: p_global_attribute6 IN ra_customer_trx.global_attribute6%type,

Line 7258: p_global_attribute3 IN ra_customer_trx.global_attribute3%type,

7254: p_attribute15 IN ra_customer_trx.attribute15%type,
7255: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type,
7256: p_global_attribute1 IN ra_customer_trx.global_attribute1%type,
7257: p_global_attribute2 IN ra_customer_trx.global_attribute2%type,
7258: p_global_attribute3 IN ra_customer_trx.global_attribute3%type,
7259: p_global_attribute4 IN ra_customer_trx.global_attribute4%type,
7260: p_global_attribute5 IN ra_customer_trx.global_attribute5%type,
7261: p_global_attribute6 IN ra_customer_trx.global_attribute6%type,
7262: p_global_attribute7 IN ra_customer_trx.global_attribute7%type,

Line 7259: p_global_attribute4 IN ra_customer_trx.global_attribute4%type,

7255: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type,
7256: p_global_attribute1 IN ra_customer_trx.global_attribute1%type,
7257: p_global_attribute2 IN ra_customer_trx.global_attribute2%type,
7258: p_global_attribute3 IN ra_customer_trx.global_attribute3%type,
7259: p_global_attribute4 IN ra_customer_trx.global_attribute4%type,
7260: p_global_attribute5 IN ra_customer_trx.global_attribute5%type,
7261: p_global_attribute6 IN ra_customer_trx.global_attribute6%type,
7262: p_global_attribute7 IN ra_customer_trx.global_attribute7%type,
7263: p_global_attribute8 IN ra_customer_trx.global_attribute8%type,

Line 7260: p_global_attribute5 IN ra_customer_trx.global_attribute5%type,

7256: p_global_attribute1 IN ra_customer_trx.global_attribute1%type,
7257: p_global_attribute2 IN ra_customer_trx.global_attribute2%type,
7258: p_global_attribute3 IN ra_customer_trx.global_attribute3%type,
7259: p_global_attribute4 IN ra_customer_trx.global_attribute4%type,
7260: p_global_attribute5 IN ra_customer_trx.global_attribute5%type,
7261: p_global_attribute6 IN ra_customer_trx.global_attribute6%type,
7262: p_global_attribute7 IN ra_customer_trx.global_attribute7%type,
7263: p_global_attribute8 IN ra_customer_trx.global_attribute8%type,
7264: p_global_attribute9 IN ra_customer_trx.global_attribute9%type,

Line 7261: p_global_attribute6 IN ra_customer_trx.global_attribute6%type,

7257: p_global_attribute2 IN ra_customer_trx.global_attribute2%type,
7258: p_global_attribute3 IN ra_customer_trx.global_attribute3%type,
7259: p_global_attribute4 IN ra_customer_trx.global_attribute4%type,
7260: p_global_attribute5 IN ra_customer_trx.global_attribute5%type,
7261: p_global_attribute6 IN ra_customer_trx.global_attribute6%type,
7262: p_global_attribute7 IN ra_customer_trx.global_attribute7%type,
7263: p_global_attribute8 IN ra_customer_trx.global_attribute8%type,
7264: p_global_attribute9 IN ra_customer_trx.global_attribute9%type,
7265: p_global_attribute10 IN ra_customer_trx.global_attribute10%type,

Line 7262: p_global_attribute7 IN ra_customer_trx.global_attribute7%type,

7258: p_global_attribute3 IN ra_customer_trx.global_attribute3%type,
7259: p_global_attribute4 IN ra_customer_trx.global_attribute4%type,
7260: p_global_attribute5 IN ra_customer_trx.global_attribute5%type,
7261: p_global_attribute6 IN ra_customer_trx.global_attribute6%type,
7262: p_global_attribute7 IN ra_customer_trx.global_attribute7%type,
7263: p_global_attribute8 IN ra_customer_trx.global_attribute8%type,
7264: p_global_attribute9 IN ra_customer_trx.global_attribute9%type,
7265: p_global_attribute10 IN ra_customer_trx.global_attribute10%type,
7266: p_global_attribute11 IN ra_customer_trx.global_attribute11%type,

Line 7263: p_global_attribute8 IN ra_customer_trx.global_attribute8%type,

7259: p_global_attribute4 IN ra_customer_trx.global_attribute4%type,
7260: p_global_attribute5 IN ra_customer_trx.global_attribute5%type,
7261: p_global_attribute6 IN ra_customer_trx.global_attribute6%type,
7262: p_global_attribute7 IN ra_customer_trx.global_attribute7%type,
7263: p_global_attribute8 IN ra_customer_trx.global_attribute8%type,
7264: p_global_attribute9 IN ra_customer_trx.global_attribute9%type,
7265: p_global_attribute10 IN ra_customer_trx.global_attribute10%type,
7266: p_global_attribute11 IN ra_customer_trx.global_attribute11%type,
7267: p_global_attribute12 IN ra_customer_trx.global_attribute12%type,

Line 7264: p_global_attribute9 IN ra_customer_trx.global_attribute9%type,

7260: p_global_attribute5 IN ra_customer_trx.global_attribute5%type,
7261: p_global_attribute6 IN ra_customer_trx.global_attribute6%type,
7262: p_global_attribute7 IN ra_customer_trx.global_attribute7%type,
7263: p_global_attribute8 IN ra_customer_trx.global_attribute8%type,
7264: p_global_attribute9 IN ra_customer_trx.global_attribute9%type,
7265: p_global_attribute10 IN ra_customer_trx.global_attribute10%type,
7266: p_global_attribute11 IN ra_customer_trx.global_attribute11%type,
7267: p_global_attribute12 IN ra_customer_trx.global_attribute12%type,
7268: p_global_attribute13 IN ra_customer_trx.global_attribute13%type,

Line 7265: p_global_attribute10 IN ra_customer_trx.global_attribute10%type,

7261: p_global_attribute6 IN ra_customer_trx.global_attribute6%type,
7262: p_global_attribute7 IN ra_customer_trx.global_attribute7%type,
7263: p_global_attribute8 IN ra_customer_trx.global_attribute8%type,
7264: p_global_attribute9 IN ra_customer_trx.global_attribute9%type,
7265: p_global_attribute10 IN ra_customer_trx.global_attribute10%type,
7266: p_global_attribute11 IN ra_customer_trx.global_attribute11%type,
7267: p_global_attribute12 IN ra_customer_trx.global_attribute12%type,
7268: p_global_attribute13 IN ra_customer_trx.global_attribute13%type,
7269: p_global_attribute14 IN ra_customer_trx.global_attribute14%type,

Line 7266: p_global_attribute11 IN ra_customer_trx.global_attribute11%type,

7262: p_global_attribute7 IN ra_customer_trx.global_attribute7%type,
7263: p_global_attribute8 IN ra_customer_trx.global_attribute8%type,
7264: p_global_attribute9 IN ra_customer_trx.global_attribute9%type,
7265: p_global_attribute10 IN ra_customer_trx.global_attribute10%type,
7266: p_global_attribute11 IN ra_customer_trx.global_attribute11%type,
7267: p_global_attribute12 IN ra_customer_trx.global_attribute12%type,
7268: p_global_attribute13 IN ra_customer_trx.global_attribute13%type,
7269: p_global_attribute14 IN ra_customer_trx.global_attribute14%type,
7270: p_global_attribute15 IN ra_customer_trx.global_attribute15%type,

Line 7267: p_global_attribute12 IN ra_customer_trx.global_attribute12%type,

7263: p_global_attribute8 IN ra_customer_trx.global_attribute8%type,
7264: p_global_attribute9 IN ra_customer_trx.global_attribute9%type,
7265: p_global_attribute10 IN ra_customer_trx.global_attribute10%type,
7266: p_global_attribute11 IN ra_customer_trx.global_attribute11%type,
7267: p_global_attribute12 IN ra_customer_trx.global_attribute12%type,
7268: p_global_attribute13 IN ra_customer_trx.global_attribute13%type,
7269: p_global_attribute14 IN ra_customer_trx.global_attribute14%type,
7270: p_global_attribute15 IN ra_customer_trx.global_attribute15%type,
7271: p_global_attribute16 IN ra_customer_trx.global_attribute16%type,

Line 7268: p_global_attribute13 IN ra_customer_trx.global_attribute13%type,

7264: p_global_attribute9 IN ra_customer_trx.global_attribute9%type,
7265: p_global_attribute10 IN ra_customer_trx.global_attribute10%type,
7266: p_global_attribute11 IN ra_customer_trx.global_attribute11%type,
7267: p_global_attribute12 IN ra_customer_trx.global_attribute12%type,
7268: p_global_attribute13 IN ra_customer_trx.global_attribute13%type,
7269: p_global_attribute14 IN ra_customer_trx.global_attribute14%type,
7270: p_global_attribute15 IN ra_customer_trx.global_attribute15%type,
7271: p_global_attribute16 IN ra_customer_trx.global_attribute16%type,
7272: p_global_attribute17 IN ra_customer_trx.global_attribute17%type,

Line 7269: p_global_attribute14 IN ra_customer_trx.global_attribute14%type,

7265: p_global_attribute10 IN ra_customer_trx.global_attribute10%type,
7266: p_global_attribute11 IN ra_customer_trx.global_attribute11%type,
7267: p_global_attribute12 IN ra_customer_trx.global_attribute12%type,
7268: p_global_attribute13 IN ra_customer_trx.global_attribute13%type,
7269: p_global_attribute14 IN ra_customer_trx.global_attribute14%type,
7270: p_global_attribute15 IN ra_customer_trx.global_attribute15%type,
7271: p_global_attribute16 IN ra_customer_trx.global_attribute16%type,
7272: p_global_attribute17 IN ra_customer_trx.global_attribute17%type,
7273: p_global_attribute18 IN ra_customer_trx.global_attribute18%type,

Line 7270: p_global_attribute15 IN ra_customer_trx.global_attribute15%type,

7266: p_global_attribute11 IN ra_customer_trx.global_attribute11%type,
7267: p_global_attribute12 IN ra_customer_trx.global_attribute12%type,
7268: p_global_attribute13 IN ra_customer_trx.global_attribute13%type,
7269: p_global_attribute14 IN ra_customer_trx.global_attribute14%type,
7270: p_global_attribute15 IN ra_customer_trx.global_attribute15%type,
7271: p_global_attribute16 IN ra_customer_trx.global_attribute16%type,
7272: p_global_attribute17 IN ra_customer_trx.global_attribute17%type,
7273: p_global_attribute18 IN ra_customer_trx.global_attribute18%type,
7274: p_global_attribute19 IN ra_customer_trx.global_attribute19%type,

Line 7271: p_global_attribute16 IN ra_customer_trx.global_attribute16%type,

7267: p_global_attribute12 IN ra_customer_trx.global_attribute12%type,
7268: p_global_attribute13 IN ra_customer_trx.global_attribute13%type,
7269: p_global_attribute14 IN ra_customer_trx.global_attribute14%type,
7270: p_global_attribute15 IN ra_customer_trx.global_attribute15%type,
7271: p_global_attribute16 IN ra_customer_trx.global_attribute16%type,
7272: p_global_attribute17 IN ra_customer_trx.global_attribute17%type,
7273: p_global_attribute18 IN ra_customer_trx.global_attribute18%type,
7274: p_global_attribute19 IN ra_customer_trx.global_attribute19%type,
7275: p_global_attribute20 IN ra_customer_trx.global_attribute20%type,

Line 7272: p_global_attribute17 IN ra_customer_trx.global_attribute17%type,

7268: p_global_attribute13 IN ra_customer_trx.global_attribute13%type,
7269: p_global_attribute14 IN ra_customer_trx.global_attribute14%type,
7270: p_global_attribute15 IN ra_customer_trx.global_attribute15%type,
7271: p_global_attribute16 IN ra_customer_trx.global_attribute16%type,
7272: p_global_attribute17 IN ra_customer_trx.global_attribute17%type,
7273: p_global_attribute18 IN ra_customer_trx.global_attribute18%type,
7274: p_global_attribute19 IN ra_customer_trx.global_attribute19%type,
7275: p_global_attribute20 IN ra_customer_trx.global_attribute20%type,
7276: p_global_attribute21 IN ra_customer_trx.global_attribute21%type,

Line 7273: p_global_attribute18 IN ra_customer_trx.global_attribute18%type,

7269: p_global_attribute14 IN ra_customer_trx.global_attribute14%type,
7270: p_global_attribute15 IN ra_customer_trx.global_attribute15%type,
7271: p_global_attribute16 IN ra_customer_trx.global_attribute16%type,
7272: p_global_attribute17 IN ra_customer_trx.global_attribute17%type,
7273: p_global_attribute18 IN ra_customer_trx.global_attribute18%type,
7274: p_global_attribute19 IN ra_customer_trx.global_attribute19%type,
7275: p_global_attribute20 IN ra_customer_trx.global_attribute20%type,
7276: p_global_attribute21 IN ra_customer_trx.global_attribute21%type,
7277: p_global_attribute22 IN ra_customer_trx.global_attribute22%type,

Line 7274: p_global_attribute19 IN ra_customer_trx.global_attribute19%type,

7270: p_global_attribute15 IN ra_customer_trx.global_attribute15%type,
7271: p_global_attribute16 IN ra_customer_trx.global_attribute16%type,
7272: p_global_attribute17 IN ra_customer_trx.global_attribute17%type,
7273: p_global_attribute18 IN ra_customer_trx.global_attribute18%type,
7274: p_global_attribute19 IN ra_customer_trx.global_attribute19%type,
7275: p_global_attribute20 IN ra_customer_trx.global_attribute20%type,
7276: p_global_attribute21 IN ra_customer_trx.global_attribute21%type,
7277: p_global_attribute22 IN ra_customer_trx.global_attribute22%type,
7278: p_global_attribute23 IN ra_customer_trx.global_attribute23%type,

Line 7275: p_global_attribute20 IN ra_customer_trx.global_attribute20%type,

7271: p_global_attribute16 IN ra_customer_trx.global_attribute16%type,
7272: p_global_attribute17 IN ra_customer_trx.global_attribute17%type,
7273: p_global_attribute18 IN ra_customer_trx.global_attribute18%type,
7274: p_global_attribute19 IN ra_customer_trx.global_attribute19%type,
7275: p_global_attribute20 IN ra_customer_trx.global_attribute20%type,
7276: p_global_attribute21 IN ra_customer_trx.global_attribute21%type,
7277: p_global_attribute22 IN ra_customer_trx.global_attribute22%type,
7278: p_global_attribute23 IN ra_customer_trx.global_attribute23%type,
7279: p_global_attribute24 IN ra_customer_trx.global_attribute24%type,

Line 7276: p_global_attribute21 IN ra_customer_trx.global_attribute21%type,

7272: p_global_attribute17 IN ra_customer_trx.global_attribute17%type,
7273: p_global_attribute18 IN ra_customer_trx.global_attribute18%type,
7274: p_global_attribute19 IN ra_customer_trx.global_attribute19%type,
7275: p_global_attribute20 IN ra_customer_trx.global_attribute20%type,
7276: p_global_attribute21 IN ra_customer_trx.global_attribute21%type,
7277: p_global_attribute22 IN ra_customer_trx.global_attribute22%type,
7278: p_global_attribute23 IN ra_customer_trx.global_attribute23%type,
7279: p_global_attribute24 IN ra_customer_trx.global_attribute24%type,
7280: p_global_attribute25 IN ra_customer_trx.global_attribute25%type,

Line 7277: p_global_attribute22 IN ra_customer_trx.global_attribute22%type,

7273: p_global_attribute18 IN ra_customer_trx.global_attribute18%type,
7274: p_global_attribute19 IN ra_customer_trx.global_attribute19%type,
7275: p_global_attribute20 IN ra_customer_trx.global_attribute20%type,
7276: p_global_attribute21 IN ra_customer_trx.global_attribute21%type,
7277: p_global_attribute22 IN ra_customer_trx.global_attribute22%type,
7278: p_global_attribute23 IN ra_customer_trx.global_attribute23%type,
7279: p_global_attribute24 IN ra_customer_trx.global_attribute24%type,
7280: p_global_attribute25 IN ra_customer_trx.global_attribute25%type,
7281: p_global_attribute26 IN ra_customer_trx.global_attribute26%type,

Line 7278: p_global_attribute23 IN ra_customer_trx.global_attribute23%type,

7274: p_global_attribute19 IN ra_customer_trx.global_attribute19%type,
7275: p_global_attribute20 IN ra_customer_trx.global_attribute20%type,
7276: p_global_attribute21 IN ra_customer_trx.global_attribute21%type,
7277: p_global_attribute22 IN ra_customer_trx.global_attribute22%type,
7278: p_global_attribute23 IN ra_customer_trx.global_attribute23%type,
7279: p_global_attribute24 IN ra_customer_trx.global_attribute24%type,
7280: p_global_attribute25 IN ra_customer_trx.global_attribute25%type,
7281: p_global_attribute26 IN ra_customer_trx.global_attribute26%type,
7282: p_global_attribute27 IN ra_customer_trx.global_attribute27%type,

Line 7279: p_global_attribute24 IN ra_customer_trx.global_attribute24%type,

7275: p_global_attribute20 IN ra_customer_trx.global_attribute20%type,
7276: p_global_attribute21 IN ra_customer_trx.global_attribute21%type,
7277: p_global_attribute22 IN ra_customer_trx.global_attribute22%type,
7278: p_global_attribute23 IN ra_customer_trx.global_attribute23%type,
7279: p_global_attribute24 IN ra_customer_trx.global_attribute24%type,
7280: p_global_attribute25 IN ra_customer_trx.global_attribute25%type,
7281: p_global_attribute26 IN ra_customer_trx.global_attribute26%type,
7282: p_global_attribute27 IN ra_customer_trx.global_attribute27%type,
7283: p_global_attribute28 IN ra_customer_trx.global_attribute28%type,

Line 7280: p_global_attribute25 IN ra_customer_trx.global_attribute25%type,

7276: p_global_attribute21 IN ra_customer_trx.global_attribute21%type,
7277: p_global_attribute22 IN ra_customer_trx.global_attribute22%type,
7278: p_global_attribute23 IN ra_customer_trx.global_attribute23%type,
7279: p_global_attribute24 IN ra_customer_trx.global_attribute24%type,
7280: p_global_attribute25 IN ra_customer_trx.global_attribute25%type,
7281: p_global_attribute26 IN ra_customer_trx.global_attribute26%type,
7282: p_global_attribute27 IN ra_customer_trx.global_attribute27%type,
7283: p_global_attribute28 IN ra_customer_trx.global_attribute28%type,
7284: p_global_attribute29 IN ra_customer_trx.global_attribute29%type,

Line 7281: p_global_attribute26 IN ra_customer_trx.global_attribute26%type,

7277: p_global_attribute22 IN ra_customer_trx.global_attribute22%type,
7278: p_global_attribute23 IN ra_customer_trx.global_attribute23%type,
7279: p_global_attribute24 IN ra_customer_trx.global_attribute24%type,
7280: p_global_attribute25 IN ra_customer_trx.global_attribute25%type,
7281: p_global_attribute26 IN ra_customer_trx.global_attribute26%type,
7282: p_global_attribute27 IN ra_customer_trx.global_attribute27%type,
7283: p_global_attribute28 IN ra_customer_trx.global_attribute28%type,
7284: p_global_attribute29 IN ra_customer_trx.global_attribute29%type,
7285: p_global_attribute30 IN ra_customer_trx.global_attribute30%type,

Line 7282: p_global_attribute27 IN ra_customer_trx.global_attribute27%type,

7278: p_global_attribute23 IN ra_customer_trx.global_attribute23%type,
7279: p_global_attribute24 IN ra_customer_trx.global_attribute24%type,
7280: p_global_attribute25 IN ra_customer_trx.global_attribute25%type,
7281: p_global_attribute26 IN ra_customer_trx.global_attribute26%type,
7282: p_global_attribute27 IN ra_customer_trx.global_attribute27%type,
7283: p_global_attribute28 IN ra_customer_trx.global_attribute28%type,
7284: p_global_attribute29 IN ra_customer_trx.global_attribute29%type,
7285: p_global_attribute30 IN ra_customer_trx.global_attribute30%type,
7286: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,

Line 7283: p_global_attribute28 IN ra_customer_trx.global_attribute28%type,

7279: p_global_attribute24 IN ra_customer_trx.global_attribute24%type,
7280: p_global_attribute25 IN ra_customer_trx.global_attribute25%type,
7281: p_global_attribute26 IN ra_customer_trx.global_attribute26%type,
7282: p_global_attribute27 IN ra_customer_trx.global_attribute27%type,
7283: p_global_attribute28 IN ra_customer_trx.global_attribute28%type,
7284: p_global_attribute29 IN ra_customer_trx.global_attribute29%type,
7285: p_global_attribute30 IN ra_customer_trx.global_attribute30%type,
7286: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,
7287: p_payment_trxn_extension_id IN ra_customer_trx.payment_trxn_extension_id%type,

Line 7284: p_global_attribute29 IN ra_customer_trx.global_attribute29%type,

7280: p_global_attribute25 IN ra_customer_trx.global_attribute25%type,
7281: p_global_attribute26 IN ra_customer_trx.global_attribute26%type,
7282: p_global_attribute27 IN ra_customer_trx.global_attribute27%type,
7283: p_global_attribute28 IN ra_customer_trx.global_attribute28%type,
7284: p_global_attribute29 IN ra_customer_trx.global_attribute29%type,
7285: p_global_attribute30 IN ra_customer_trx.global_attribute30%type,
7286: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,
7287: p_payment_trxn_extension_id IN ra_customer_trx.payment_trxn_extension_id%type,
7288: p_billing_date IN ra_customer_trx.billing_date%type)

Line 7285: p_global_attribute30 IN ra_customer_trx.global_attribute30%type,

7281: p_global_attribute26 IN ra_customer_trx.global_attribute26%type,
7282: p_global_attribute27 IN ra_customer_trx.global_attribute27%type,
7283: p_global_attribute28 IN ra_customer_trx.global_attribute28%type,
7284: p_global_attribute29 IN ra_customer_trx.global_attribute29%type,
7285: p_global_attribute30 IN ra_customer_trx.global_attribute30%type,
7286: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,
7287: p_payment_trxn_extension_id IN ra_customer_trx.payment_trxn_extension_id%type,
7288: p_billing_date IN ra_customer_trx.billing_date%type)
7289:

Line 7286: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,

7282: p_global_attribute27 IN ra_customer_trx.global_attribute27%type,
7283: p_global_attribute28 IN ra_customer_trx.global_attribute28%type,
7284: p_global_attribute29 IN ra_customer_trx.global_attribute29%type,
7285: p_global_attribute30 IN ra_customer_trx.global_attribute30%type,
7286: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,
7287: p_payment_trxn_extension_id IN ra_customer_trx.payment_trxn_extension_id%type,
7288: p_billing_date IN ra_customer_trx.billing_date%type)
7289:
7290:

Line 7287: p_payment_trxn_extension_id IN ra_customer_trx.payment_trxn_extension_id%type,

7283: p_global_attribute28 IN ra_customer_trx.global_attribute28%type,
7284: p_global_attribute29 IN ra_customer_trx.global_attribute29%type,
7285: p_global_attribute30 IN ra_customer_trx.global_attribute30%type,
7286: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,
7287: p_payment_trxn_extension_id IN ra_customer_trx.payment_trxn_extension_id%type,
7288: p_billing_date IN ra_customer_trx.billing_date%type)
7289:
7290:
7291: IS

Line 7288: p_billing_date IN ra_customer_trx.billing_date%type)

7284: p_global_attribute29 IN ra_customer_trx.global_attribute29%type,
7285: p_global_attribute30 IN ra_customer_trx.global_attribute30%type,
7286: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,
7287: p_payment_trxn_extension_id IN ra_customer_trx.payment_trxn_extension_id%type,
7288: p_billing_date IN ra_customer_trx.billing_date%type)
7289:
7290:
7291: IS
7292:

Line 7293: l_trx_rec ra_customer_trx%rowtype;

7289:
7290:
7291: IS
7292:
7293: l_trx_rec ra_customer_trx%rowtype;
7294:
7295: BEGIN
7296: arp_util.debug('arp_ct_pkg.lock_compare_cover()+');
7297: