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) IS
1983:
1984: l_new_trx_rec ra_customer_trx%rowtype;

Line 1982: ra_customer_trx.customer_trx_id%type) IS

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) IS
1983:
1984: l_new_trx_rec ra_customer_trx%rowtype;
1985:
1986: BEGIN

Line 1984: l_new_trx_rec ra_customer_trx%rowtype;

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) IS
1983:
1984: l_new_trx_rec ra_customer_trx%rowtype;
1985:
1986: BEGIN
1987: arp_util.debug('arp_ct_pkg.lock_compare_p()+');
1988:

Line 1991: FROM ra_customer_trx trx

1987: arp_util.debug('arp_ct_pkg.lock_compare_p()+');
1988:
1989: SELECT *
1990: INTO l_new_trx_rec
1991: FROM ra_customer_trx trx
1992: WHERE trx.customer_trx_id = p_customer_trx_id
1993: AND
1994: (
1995: NVL(trx.trx_number, AR_TEXT_DUMMY) =

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

3355: | PROCEDURE |
3356: | fetch_p |
3357: | |
3358: | DESCRIPTION |
3359: | This procedure fetches a single row from ra_customer_trx into a |
3360: | variable specified as a parameter based on the table's primary key, |
3361: | customer_trx_id. |
3362: | |
3363: | SCOPE - PUBLIC |

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

3378: | 07-JUN-95 Charlie Tomberg Created |
3379: | |
3380: +===========================================================================*/
3381:
3382: PROCEDURE fetch_p( p_trx_rec OUT NOCOPY ra_customer_trx%rowtype,
3383: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type )
3384: IS
3385:
3386: BEGIN

Line 3383: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type )

3379: | |
3380: +===========================================================================*/
3381:
3382: PROCEDURE fetch_p( p_trx_rec OUT NOCOPY ra_customer_trx%rowtype,
3383: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type )
3384: IS
3385:
3386: BEGIN
3387: arp_util.debug('arp_ct_pkg.fetch_p()+');

Line 3391: FROM ra_customer_trx

3387: arp_util.debug('arp_ct_pkg.fetch_p()+');
3388:
3389: SELECT *
3390: INTO p_trx_rec
3391: FROM ra_customer_trx
3392: WHERE customer_trx_id = p_customer_trx_id;
3393:
3394: arp_util.debug('arp_ct_pkg.fetch_p()-');
3395:

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

3403: | PROCEDURE |
3404: | delete_p |
3405: | |
3406: | DESCRIPTION |
3407: | This procedure deletes the ra_customeR_trx row identified by the |
3408: | p_customer_trx_id parameter. |
3409: | |
3410: | SCOPE - PUBLIC |
3411: | |

Line 3427: | RA_CUSTOMER_TRX processing |

3423: | |
3424: | MODIFICATION HISTORY |
3425: | 07-JUN-95 Charlie Tomberg Created |
3426: | 08-NOV-01 Debbie Jancis Added calls to MRC engine for |
3427: | RA_CUSTOMER_TRX processing |
3428: | |
3429: +===========================================================================*/
3430:
3431: procedure delete_p( p_customer_trx_id IN ra_customer_trx.customer_trx_id%type)

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

3427: | RA_CUSTOMER_TRX processing |
3428: | |
3429: +===========================================================================*/
3430:
3431: procedure delete_p( p_customer_trx_id IN ra_customer_trx.customer_trx_id%type)
3432: IS
3433:
3434:
3435: BEGIN

Line 3440: DELETE FROM ra_customer_trx

3436:
3437:
3438: arp_util.debug('arp_ct_pkg.delete_p()+');
3439:
3440: DELETE FROM ra_customer_trx
3441: WHERE customer_trx_id = p_customer_trx_id;
3442:
3443: /*---------------------------------+
3444: | Calling central MRC library |

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

3446: +---------------------------------*/
3447: --{BUG4301323
3448: -- ar_mrc_engine.maintain_mrc_data(
3449: -- p_event_mode => 'DELETE',
3450: -- p_table_name => 'RA_CUSTOMER_TRX',
3451: -- p_mode => 'SINGLE',
3452: -- p_key_value => p_customer_trx_id);
3453: --}
3454: --

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

3466: | PROCEDURE |
3467: | update_p |
3468: | |
3469: | DESCRIPTION |
3470: | This procedure updates the ra_customer_trx row identified by the |
3471: | p_customer_trx_id parameter. |
3472: | |
3473: | SCOPE - PUBLIC |
3474: | |

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

3491: | 06-JUN-95 Charlie Tomberg Created |
3492: | |
3493: +===========================================================================*/
3494:
3495: PROCEDURE update_p( p_trx_rec IN ra_customer_trx%rowtype,
3496: p_customer_trx_id IN
3497: ra_customer_trx.customer_trx_id%type) IS
3498:
3499: --2528261 begin

Line 3497: ra_customer_trx.customer_trx_id%type) IS

3493: +===========================================================================*/
3494:
3495: PROCEDURE update_p( p_trx_rec IN ra_customer_trx%rowtype,
3496: p_customer_trx_id IN
3497: ra_customer_trx.customer_trx_id%type) IS
3498:
3499: --2528261 begin
3500: l_ct_reference varchar2(30);
3501: --2528261 end

Line 3544: update ra_customer_trx

3540: when others then
3541: l_ct_reference:=null;
3542: end;
3543: if l_ct_reference is not null then
3544: update ra_customer_trx
3545: set ct_reference =l_ct_reference
3546: where customer_trx_id = p_trx_rec.customer_trx_id;
3547: end if;
3548:

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

3560: | PROCEDURE |
3561: | update_p_print |
3562: | |
3563: | DESCRIPTION |
3564: | This procedure updates the ra_customer_trx row identified by the |
3565: | p_customer_trx_id parameter. It calls update_p, then
3566: | arp_etax_util.global_document_update. |
3567: | |
3568: | SCOPE - PUBLIC |

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

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

3589: | 24-JAN-06 M Raymond Created |
3590: | |
3591: +===========================================================================*/
3592:
3593: PROCEDURE update_p_print( p_trx_rec IN ra_customer_trx%rowtype,
3594: p_customer_trx_id IN
3595: ra_customer_trx.customer_trx_id%type) IS
3596: BEGIN
3597: /* Call update_p to carry out the actual update */

Line 3595: ra_customer_trx.customer_trx_id%type) IS

3591: +===========================================================================*/
3592:
3593: PROCEDURE update_p_print( p_trx_rec IN ra_customer_trx%rowtype,
3594: p_customer_trx_id IN
3595: ra_customer_trx.customer_trx_id%type) IS
3596: BEGIN
3597: /* Call update_p to carry out the actual update */
3598: update_p(p_trx_rec, p_customer_trx_id);
3599:

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

3613: | PROCEDURE |
3614: | insert_p |
3615: | |
3616: | DESCRIPTION |
3617: | This procedure inserts a row into ra_customer_trx that contains the |
3618: | column values specified in the p_trx_rec parameter. |
3619: | |
3620: | SCOPE - PUBLIC |
3621: | |

Line 3665: | RA_CUSTOMER_TRX processing |

3661: | 6-Jul-2001 yreddy Bug1738914 - Added 'Copy doc num to |
3662: | Trx Number' |
3663: | functionality for chargebacks. |
3664: | 08-NOV-01 Debbie Jancis Added calls to MRC engine for |
3665: | RA_CUSTOMER_TRX processing |
3666: | |
3667: | 20-Jun-02 Sahana Bug2427456: Added global attribute columns |
3668: | 18-May-05 Debbie Jancis Added Legal Entity ID for LE project |
3669: +===========================================================================*/

Line 3672: p_trx_rec IN ra_customer_trx%rowtype,

3668: | 18-May-05 Debbie Jancis Added Legal Entity ID for LE project |
3669: +===========================================================================*/
3670:
3671: PROCEDURE insert_p(
3672: p_trx_rec IN ra_customer_trx%rowtype,
3673: p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,
3674: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type
3675: ) IS
3676:

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

3669: +===========================================================================*/
3670:
3671: PROCEDURE insert_p(
3672: p_trx_rec IN ra_customer_trx%rowtype,
3673: p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,
3674: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type
3675: ) IS
3676:
3677:

Line 3674: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type

3670:
3671: PROCEDURE insert_p(
3672: p_trx_rec IN ra_customer_trx%rowtype,
3673: p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,
3674: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type
3675: ) IS
3676:
3677:
3678: l_customer_trx_id ra_customer_trx.customer_trx_id%type;

Line 3678: l_customer_trx_id ra_customer_trx.customer_trx_id%type;

3674: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type
3675: ) IS
3676:
3677:
3678: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
3679: l_org_id integer;
3680: l_org_str varchar2(30);
3681: l_trx_num_cursor integer;
3682: l_dummy integer;

Line 3683: l_trx_number ra_customer_trx.trx_number%type;

3679: l_org_id integer;
3680: l_org_str varchar2(30);
3681: l_trx_num_cursor integer;
3682: l_dummy integer;
3683: l_trx_number ra_customer_trx.trx_number%type;
3684: l_trx_str VARCHAR2(1000);
3685: l_copy_doc_number_flag varchar2(1):='N'; --Bug1738914
3686: l_old_trx_number ra_customer_trx.old_trx_number%type; --Bug1738914
3687: l_ct_reference varchar2(30);

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

3682: l_dummy integer;
3683: l_trx_number ra_customer_trx.trx_number%type;
3684: l_trx_str VARCHAR2(1000);
3685: l_copy_doc_number_flag varchar2(1):='N'; --Bug1738914
3686: l_old_trx_number ra_customer_trx.old_trx_number%type; --Bug1738914
3687: l_ct_reference varchar2(30);
3688: l_legal_entity_id number;
3689:
3690: BEGIN

Line 3714: SELECT RA_CUSTOMER_TRX_S.NEXTVAL

3710: /*---------------------------*
3711: | Get the unique identifier |
3712: *---------------------------*/
3713:
3714: SELECT RA_CUSTOMER_TRX_S.NEXTVAL
3715: INTO l_customer_trx_id
3716: FROM DUAL;
3717:
3718: /*----------------------------*

Line 3826: INSERT INTO ra_customer_trx

3822: /*-------------------*
3823: | Insert the record |
3824: *-------------------*/
3825:
3826: INSERT INTO ra_customer_trx
3827: (
3828: customer_trx_id,
3829: trx_number,
3830: created_by,

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

4178: +---------------------------------*/
4179: --{BUG4301323
4180: -- ar_mrc_engine.maintain_mrc_data(
4181: -- p_event_mode => 'INSERT',
4182: -- p_table_name => 'RA_CUSTOMER_TRX',
4183: -- p_mode => 'SINGLE',
4184: -- p_key_value => l_customer_trx_id);
4185: --}
4186:

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

4222: | |
4223: +===========================================================================*/
4224:
4225: PROCEDURE display_header_p(
4226: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type) IS
4227:
4228: l_trx_rec ra_customer_trx%rowtype;
4229:
4230: BEGIN

Line 4228: l_trx_rec ra_customer_trx%rowtype;

4224:
4225: PROCEDURE display_header_p(
4226: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type) IS
4227:
4228: l_trx_rec ra_customer_trx%rowtype;
4229:
4230: BEGIN
4231:
4232: arp_util.debug('arp_ct_pkg.display_header_p()+');

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

4290: | wh_update_date |
4291: | into the table handlers. |
4292: +==========================================================================*/
4293:
4294: PROCEDURE display_header_rec ( p_trx_rec IN ra_customer_trx%rowtype ) IS
4295:
4296: BEGIN
4297:
4298: arp_util.debug('arp_ct_pkg.display_header_rec()+');

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

4296: BEGIN
4297:
4298: arp_util.debug('arp_ct_pkg.display_header_rec()+');
4299:
4300: arp_util.debug('************ Dump of ra_customer_trx record ************');
4301: arp_util.debug('customer_trx_id: ' || p_trx_rec.customer_trx_id);
4302: arp_util.debug('trx_number: ' || p_trx_rec.trx_number);
4303: arp_util.debug('created_by: ' || p_trx_rec.created_by);
4304: arp_util.debug('last_updated_by: ' || p_trx_rec.last_updated_by);

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

4503: arp_util.debug('legal_entity_id: ' || to_char(p_trx_rec.legal_entity_id));
4504: arp_util.debug('payment_trxn_extension_id: ' || to_char(p_trx_rec.payment_trxn_extension_id));
4505: arp_util.debug('billing_date: ' || p_trx_rec.billing_date);
4506:
4507: arp_util.debug('************* End ra_customer_trx record *************');
4508:
4509: arp_util.debug('arp_ct_pkg.display_header_rec()-');
4510:
4511: EXCEPTION

Line 4551: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

4547: | 15-OCT-95 Subash Chadalavada Created |
4548: | |
4549: +===========================================================================*/
4550: PROCEDURE lock_compare_frt_cover(
4551: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
4552: p_ship_via IN ra_customer_trx.ship_via%type,
4553: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
4554: p_waybill_number IN ra_customer_trx.waybill_number%type,
4555: p_fob_point IN ra_customer_trx.fob_point%type)

Line 4552: p_ship_via IN ra_customer_trx.ship_via%type,

4548: | |
4549: +===========================================================================*/
4550: PROCEDURE lock_compare_frt_cover(
4551: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
4552: p_ship_via IN ra_customer_trx.ship_via%type,
4553: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
4554: p_waybill_number IN ra_customer_trx.waybill_number%type,
4555: p_fob_point IN ra_customer_trx.fob_point%type)
4556: IS

Line 4553: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,

4549: +===========================================================================*/
4550: PROCEDURE lock_compare_frt_cover(
4551: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
4552: p_ship_via IN ra_customer_trx.ship_via%type,
4553: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
4554: p_waybill_number IN ra_customer_trx.waybill_number%type,
4555: p_fob_point IN ra_customer_trx.fob_point%type)
4556: IS
4557: l_trx_rec ra_customer_trx%rowtype;

Line 4554: p_waybill_number IN ra_customer_trx.waybill_number%type,

4550: PROCEDURE lock_compare_frt_cover(
4551: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
4552: p_ship_via IN ra_customer_trx.ship_via%type,
4553: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
4554: p_waybill_number IN ra_customer_trx.waybill_number%type,
4555: p_fob_point IN ra_customer_trx.fob_point%type)
4556: IS
4557: l_trx_rec ra_customer_trx%rowtype;
4558: BEGIN

Line 4555: p_fob_point IN ra_customer_trx.fob_point%type)

4551: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
4552: p_ship_via IN ra_customer_trx.ship_via%type,
4553: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
4554: p_waybill_number IN ra_customer_trx.waybill_number%type,
4555: p_fob_point IN ra_customer_trx.fob_point%type)
4556: IS
4557: l_trx_rec ra_customer_trx%rowtype;
4558: BEGIN
4559: arp_util.debug('arp_ct_pkg.lock_compare_frt_cover()+');

Line 4557: l_trx_rec ra_customer_trx%rowtype;

4553: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
4554: p_waybill_number IN ra_customer_trx.waybill_number%type,
4555: p_fob_point IN ra_customer_trx.fob_point%type)
4556: IS
4557: l_trx_rec ra_customer_trx%rowtype;
4558: BEGIN
4559: arp_util.debug('arp_ct_pkg.lock_compare_frt_cover()+');
4560:
4561: /*------------------------------------------------+

Line 4732: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

4728: | |
4729: +===========================================================================*/
4730:
4731: PROCEDURE lock_compare_cover(
4732: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
4733: p_trx_number IN ra_customer_trx.trx_number%type,
4734: p_posting_control_id IN ra_customer_trx.posting_control_id%type,
4735: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
4736: p_complete_flag IN ra_customer_trx.complete_flag%type,

Line 4733: p_trx_number IN ra_customer_trx.trx_number%type,

4729: +===========================================================================*/
4730:
4731: PROCEDURE lock_compare_cover(
4732: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
4733: p_trx_number IN ra_customer_trx.trx_number%type,
4734: p_posting_control_id IN ra_customer_trx.posting_control_id%type,
4735: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
4736: p_complete_flag IN ra_customer_trx.complete_flag%type,
4737: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,

Line 4734: p_posting_control_id IN ra_customer_trx.posting_control_id%type,

4730:
4731: PROCEDURE lock_compare_cover(
4732: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
4733: p_trx_number IN ra_customer_trx.trx_number%type,
4734: p_posting_control_id IN ra_customer_trx.posting_control_id%type,
4735: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
4736: p_complete_flag IN ra_customer_trx.complete_flag%type,
4737: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
4738: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,

Line 4735: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,

4731: PROCEDURE lock_compare_cover(
4732: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
4733: p_trx_number IN ra_customer_trx.trx_number%type,
4734: p_posting_control_id IN ra_customer_trx.posting_control_id%type,
4735: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
4736: p_complete_flag IN ra_customer_trx.complete_flag%type,
4737: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
4738: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
4739: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,

Line 4736: p_complete_flag IN ra_customer_trx.complete_flag%type,

4732: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
4733: p_trx_number IN ra_customer_trx.trx_number%type,
4734: p_posting_control_id IN ra_customer_trx.posting_control_id%type,
4735: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
4736: p_complete_flag IN ra_customer_trx.complete_flag%type,
4737: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
4738: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
4739: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
4740: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,

Line 4737: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,

4733: p_trx_number IN ra_customer_trx.trx_number%type,
4734: p_posting_control_id IN ra_customer_trx.posting_control_id%type,
4735: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
4736: p_complete_flag IN ra_customer_trx.complete_flag%type,
4737: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
4738: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
4739: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
4740: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
4741: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,

Line 4738: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,

4734: p_posting_control_id IN ra_customer_trx.posting_control_id%type,
4735: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
4736: p_complete_flag IN ra_customer_trx.complete_flag%type,
4737: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
4738: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
4739: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
4740: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
4741: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
4742: p_batch_id IN ra_customer_trx.batch_id%type,

Line 4739: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,

4735: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
4736: p_complete_flag IN ra_customer_trx.complete_flag%type,
4737: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
4738: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
4739: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
4740: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
4741: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
4742: p_batch_id IN ra_customer_trx.batch_id%type,
4743: p_batch_source_id IN ra_customer_trx.batch_source_id%type,

Line 4740: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,

4736: p_complete_flag IN ra_customer_trx.complete_flag%type,
4737: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
4738: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
4739: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
4740: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
4741: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
4742: p_batch_id IN ra_customer_trx.batch_id%type,
4743: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
4744: p_agreement_id IN ra_customer_trx.agreement_id%type,

Line 4741: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,

4737: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
4738: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
4739: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
4740: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
4741: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
4742: p_batch_id IN ra_customer_trx.batch_id%type,
4743: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
4744: p_agreement_id IN ra_customer_trx.agreement_id%type,
4745: p_trx_date IN ra_customer_trx.trx_date%type,

Line 4742: p_batch_id IN ra_customer_trx.batch_id%type,

4738: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
4739: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
4740: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
4741: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
4742: p_batch_id IN ra_customer_trx.batch_id%type,
4743: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
4744: p_agreement_id IN ra_customer_trx.agreement_id%type,
4745: p_trx_date IN ra_customer_trx.trx_date%type,
4746: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,

Line 4743: p_batch_source_id IN ra_customer_trx.batch_source_id%type,

4739: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
4740: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
4741: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
4742: p_batch_id IN ra_customer_trx.batch_id%type,
4743: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
4744: p_agreement_id IN ra_customer_trx.agreement_id%type,
4745: p_trx_date IN ra_customer_trx.trx_date%type,
4746: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
4747: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,

Line 4744: p_agreement_id IN ra_customer_trx.agreement_id%type,

4740: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
4741: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
4742: p_batch_id IN ra_customer_trx.batch_id%type,
4743: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
4744: p_agreement_id IN ra_customer_trx.agreement_id%type,
4745: p_trx_date IN ra_customer_trx.trx_date%type,
4746: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
4747: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
4748: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,

Line 4745: p_trx_date IN ra_customer_trx.trx_date%type,

4741: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
4742: p_batch_id IN ra_customer_trx.batch_id%type,
4743: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
4744: p_agreement_id IN ra_customer_trx.agreement_id%type,
4745: p_trx_date IN ra_customer_trx.trx_date%type,
4746: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
4747: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
4748: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
4749: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,

Line 4746: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,

4742: p_batch_id IN ra_customer_trx.batch_id%type,
4743: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
4744: p_agreement_id IN ra_customer_trx.agreement_id%type,
4745: p_trx_date IN ra_customer_trx.trx_date%type,
4746: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
4747: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
4748: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
4749: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
4750: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,

Line 4747: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,

4743: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
4744: p_agreement_id IN ra_customer_trx.agreement_id%type,
4745: p_trx_date IN ra_customer_trx.trx_date%type,
4746: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
4747: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
4748: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
4749: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
4750: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
4751: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,

Line 4748: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,

4744: p_agreement_id IN ra_customer_trx.agreement_id%type,
4745: p_trx_date IN ra_customer_trx.trx_date%type,
4746: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
4747: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
4748: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
4749: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
4750: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
4751: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
4752: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,

Line 4749: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,

4745: p_trx_date IN ra_customer_trx.trx_date%type,
4746: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
4747: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
4748: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
4749: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
4750: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
4751: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
4752: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
4753: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,

Line 4750: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,

4746: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
4747: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
4748: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
4749: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
4750: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
4751: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
4752: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
4753: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
4754: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,

Line 4751: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,

4747: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
4748: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
4749: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
4750: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
4751: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
4752: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
4753: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
4754: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
4755: p_customer_reference IN ra_customer_trx.customer_reference%type,

Line 4752: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,

4748: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
4749: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
4750: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
4751: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
4752: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
4753: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
4754: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
4755: p_customer_reference IN ra_customer_trx.customer_reference%type,
4756: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,

Line 4753: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,

4749: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
4750: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
4751: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
4752: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
4753: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
4754: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
4755: p_customer_reference IN ra_customer_trx.customer_reference%type,
4756: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
4757: p_cr_method_for_installments IN

Line 4754: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,

4750: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
4751: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
4752: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
4753: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
4754: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
4755: p_customer_reference IN ra_customer_trx.customer_reference%type,
4756: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
4757: p_cr_method_for_installments IN
4758: ra_customer_trx.credit_method_for_installments%type,

Line 4755: p_customer_reference IN ra_customer_trx.customer_reference%type,

4751: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
4752: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
4753: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
4754: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
4755: p_customer_reference IN ra_customer_trx.customer_reference%type,
4756: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
4757: p_cr_method_for_installments IN
4758: ra_customer_trx.credit_method_for_installments%type,
4759: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,

Line 4756: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,

4752: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
4753: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
4754: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
4755: p_customer_reference IN ra_customer_trx.customer_reference%type,
4756: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
4757: p_cr_method_for_installments IN
4758: ra_customer_trx.credit_method_for_installments%type,
4759: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
4760: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,

Line 4758: ra_customer_trx.credit_method_for_installments%type,

4754: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
4755: p_customer_reference IN ra_customer_trx.customer_reference%type,
4756: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
4757: p_cr_method_for_installments IN
4758: ra_customer_trx.credit_method_for_installments%type,
4759: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
4760: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
4761: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
4762: p_exchange_date IN ra_customer_trx.exchange_date%type,

Line 4759: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,

4755: p_customer_reference IN ra_customer_trx.customer_reference%type,
4756: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
4757: p_cr_method_for_installments IN
4758: ra_customer_trx.credit_method_for_installments%type,
4759: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
4760: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
4761: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
4762: p_exchange_date IN ra_customer_trx.exchange_date%type,
4763: p_exchange_rate IN ra_customer_trx.exchange_rate%type,

Line 4760: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,

4756: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
4757: p_cr_method_for_installments IN
4758: ra_customer_trx.credit_method_for_installments%type,
4759: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
4760: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
4761: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
4762: p_exchange_date IN ra_customer_trx.exchange_date%type,
4763: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
4764: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,

Line 4761: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,

4757: p_cr_method_for_installments IN
4758: ra_customer_trx.credit_method_for_installments%type,
4759: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
4760: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
4761: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
4762: p_exchange_date IN ra_customer_trx.exchange_date%type,
4763: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
4764: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
4765: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,

Line 4762: p_exchange_date IN ra_customer_trx.exchange_date%type,

4758: ra_customer_trx.credit_method_for_installments%type,
4759: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
4760: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
4761: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
4762: p_exchange_date IN ra_customer_trx.exchange_date%type,
4763: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
4764: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
4765: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
4766: p_finance_charges IN ra_customer_trx.finance_charges%type,

Line 4763: p_exchange_rate IN ra_customer_trx.exchange_rate%type,

4759: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
4760: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
4761: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
4762: p_exchange_date IN ra_customer_trx.exchange_date%type,
4763: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
4764: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
4765: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
4766: p_finance_charges IN ra_customer_trx.finance_charges%type,
4767: p_fob_point IN ra_customer_trx.fob_point%type,

Line 4764: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,

4760: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
4761: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
4762: p_exchange_date IN ra_customer_trx.exchange_date%type,
4763: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
4764: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
4765: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
4766: p_finance_charges IN ra_customer_trx.finance_charges%type,
4767: p_fob_point IN ra_customer_trx.fob_point%type,
4768: p_comments IN ra_customer_trx.comments%type,

Line 4765: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,

4761: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
4762: p_exchange_date IN ra_customer_trx.exchange_date%type,
4763: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
4764: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
4765: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
4766: p_finance_charges IN ra_customer_trx.finance_charges%type,
4767: p_fob_point IN ra_customer_trx.fob_point%type,
4768: p_comments IN ra_customer_trx.comments%type,
4769: p_internal_notes IN ra_customer_trx.internal_notes%type,

Line 4766: p_finance_charges IN ra_customer_trx.finance_charges%type,

4762: p_exchange_date IN ra_customer_trx.exchange_date%type,
4763: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
4764: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
4765: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
4766: p_finance_charges IN ra_customer_trx.finance_charges%type,
4767: p_fob_point IN ra_customer_trx.fob_point%type,
4768: p_comments IN ra_customer_trx.comments%type,
4769: p_internal_notes IN ra_customer_trx.internal_notes%type,
4770: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,

Line 4767: p_fob_point IN ra_customer_trx.fob_point%type,

4763: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
4764: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
4765: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
4766: p_finance_charges IN ra_customer_trx.finance_charges%type,
4767: p_fob_point IN ra_customer_trx.fob_point%type,
4768: p_comments IN ra_customer_trx.comments%type,
4769: p_internal_notes IN ra_customer_trx.internal_notes%type,
4770: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
4771: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,

Line 4768: p_comments IN ra_customer_trx.comments%type,

4764: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
4765: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
4766: p_finance_charges IN ra_customer_trx.finance_charges%type,
4767: p_fob_point IN ra_customer_trx.fob_point%type,
4768: p_comments IN ra_customer_trx.comments%type,
4769: p_internal_notes IN ra_customer_trx.internal_notes%type,
4770: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
4771: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
4772: p_last_printed_sequence_num IN

Line 4769: p_internal_notes IN ra_customer_trx.internal_notes%type,

4765: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
4766: p_finance_charges IN ra_customer_trx.finance_charges%type,
4767: p_fob_point IN ra_customer_trx.fob_point%type,
4768: p_comments IN ra_customer_trx.comments%type,
4769: p_internal_notes IN ra_customer_trx.internal_notes%type,
4770: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
4771: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
4772: p_last_printed_sequence_num IN
4773: ra_customer_trx.last_printed_sequence_num%type,

Line 4770: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,

4766: p_finance_charges IN ra_customer_trx.finance_charges%type,
4767: p_fob_point IN ra_customer_trx.fob_point%type,
4768: p_comments IN ra_customer_trx.comments%type,
4769: p_internal_notes IN ra_customer_trx.internal_notes%type,
4770: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
4771: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
4772: p_last_printed_sequence_num IN
4773: ra_customer_trx.last_printed_sequence_num%type,
4774: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,

Line 4771: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,

4767: p_fob_point IN ra_customer_trx.fob_point%type,
4768: p_comments IN ra_customer_trx.comments%type,
4769: p_internal_notes IN ra_customer_trx.internal_notes%type,
4770: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
4771: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
4772: p_last_printed_sequence_num IN
4773: ra_customer_trx.last_printed_sequence_num%type,
4774: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
4775: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,

Line 4773: ra_customer_trx.last_printed_sequence_num%type,

4769: p_internal_notes IN ra_customer_trx.internal_notes%type,
4770: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
4771: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
4772: p_last_printed_sequence_num IN
4773: ra_customer_trx.last_printed_sequence_num%type,
4774: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
4775: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
4776: p_printing_count IN ra_customer_trx.printing_count%type,
4777: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,

Line 4774: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,

4770: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
4771: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
4772: p_last_printed_sequence_num IN
4773: ra_customer_trx.last_printed_sequence_num%type,
4774: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
4775: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
4776: p_printing_count IN ra_customer_trx.printing_count%type,
4777: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
4778: p_printing_option IN ra_customer_trx.printing_option%type,

Line 4775: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,

4771: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
4772: p_last_printed_sequence_num IN
4773: ra_customer_trx.last_printed_sequence_num%type,
4774: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
4775: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
4776: p_printing_count IN ra_customer_trx.printing_count%type,
4777: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
4778: p_printing_option IN ra_customer_trx.printing_option%type,
4779: p_printing_original_date IN ra_customer_trx.printing_original_date%type,

Line 4776: p_printing_count IN ra_customer_trx.printing_count%type,

4772: p_last_printed_sequence_num IN
4773: ra_customer_trx.last_printed_sequence_num%type,
4774: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
4775: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
4776: p_printing_count IN ra_customer_trx.printing_count%type,
4777: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
4778: p_printing_option IN ra_customer_trx.printing_option%type,
4779: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
4780: p_printing_pending IN ra_customer_trx.printing_pending%type,

Line 4777: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,

4773: ra_customer_trx.last_printed_sequence_num%type,
4774: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
4775: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
4776: p_printing_count IN ra_customer_trx.printing_count%type,
4777: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
4778: p_printing_option IN ra_customer_trx.printing_option%type,
4779: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
4780: p_printing_pending IN ra_customer_trx.printing_pending%type,
4781: p_purchase_order IN ra_customer_trx.purchase_order%type,

Line 4778: p_printing_option IN ra_customer_trx.printing_option%type,

4774: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
4775: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
4776: p_printing_count IN ra_customer_trx.printing_count%type,
4777: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
4778: p_printing_option IN ra_customer_trx.printing_option%type,
4779: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
4780: p_printing_pending IN ra_customer_trx.printing_pending%type,
4781: p_purchase_order IN ra_customer_trx.purchase_order%type,
4782: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,

Line 4779: p_printing_original_date IN ra_customer_trx.printing_original_date%type,

4775: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
4776: p_printing_count IN ra_customer_trx.printing_count%type,
4777: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
4778: p_printing_option IN ra_customer_trx.printing_option%type,
4779: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
4780: p_printing_pending IN ra_customer_trx.printing_pending%type,
4781: p_purchase_order IN ra_customer_trx.purchase_order%type,
4782: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
4783: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,

Line 4780: p_printing_pending IN ra_customer_trx.printing_pending%type,

4776: p_printing_count IN ra_customer_trx.printing_count%type,
4777: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
4778: p_printing_option IN ra_customer_trx.printing_option%type,
4779: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
4780: p_printing_pending IN ra_customer_trx.printing_pending%type,
4781: p_purchase_order IN ra_customer_trx.purchase_order%type,
4782: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
4783: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
4784: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,

Line 4781: p_purchase_order IN ra_customer_trx.purchase_order%type,

4777: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
4778: p_printing_option IN ra_customer_trx.printing_option%type,
4779: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
4780: p_printing_pending IN ra_customer_trx.printing_pending%type,
4781: p_purchase_order IN ra_customer_trx.purchase_order%type,
4782: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
4783: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
4784: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
4785: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,

Line 4782: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,

4778: p_printing_option IN ra_customer_trx.printing_option%type,
4779: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
4780: p_printing_pending IN ra_customer_trx.printing_pending%type,
4781: p_purchase_order IN ra_customer_trx.purchase_order%type,
4782: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
4783: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
4784: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
4785: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
4786: p_shipment_id IN ra_customer_trx.shipment_id%type,

Line 4783: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,

4779: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
4780: p_printing_pending IN ra_customer_trx.printing_pending%type,
4781: p_purchase_order IN ra_customer_trx.purchase_order%type,
4782: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
4783: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
4784: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
4785: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
4786: p_shipment_id IN ra_customer_trx.shipment_id%type,
4787: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,

Line 4784: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,

4780: p_printing_pending IN ra_customer_trx.printing_pending%type,
4781: p_purchase_order IN ra_customer_trx.purchase_order%type,
4782: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
4783: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
4784: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
4785: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
4786: p_shipment_id IN ra_customer_trx.shipment_id%type,
4787: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
4788: p_ship_via IN ra_customer_trx.ship_via%type,

Line 4785: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,

4781: p_purchase_order IN ra_customer_trx.purchase_order%type,
4782: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
4783: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
4784: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
4785: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
4786: p_shipment_id IN ra_customer_trx.shipment_id%type,
4787: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
4788: p_ship_via IN ra_customer_trx.ship_via%type,
4789: p_term_due_date IN ra_customer_trx.term_due_date%type,

Line 4786: p_shipment_id IN ra_customer_trx.shipment_id%type,

4782: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
4783: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
4784: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
4785: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
4786: p_shipment_id IN ra_customer_trx.shipment_id%type,
4787: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
4788: p_ship_via IN ra_customer_trx.ship_via%type,
4789: p_term_due_date IN ra_customer_trx.term_due_date%type,
4790: p_term_id IN ra_customer_trx.term_id%type,

Line 4787: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,

4783: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
4784: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
4785: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
4786: p_shipment_id IN ra_customer_trx.shipment_id%type,
4787: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
4788: p_ship_via IN ra_customer_trx.ship_via%type,
4789: p_term_due_date IN ra_customer_trx.term_due_date%type,
4790: p_term_id IN ra_customer_trx.term_id%type,
4791: p_territory_id IN ra_customer_trx.territory_id%type,

Line 4788: p_ship_via IN ra_customer_trx.ship_via%type,

4784: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
4785: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
4786: p_shipment_id IN ra_customer_trx.shipment_id%type,
4787: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
4788: p_ship_via IN ra_customer_trx.ship_via%type,
4789: p_term_due_date IN ra_customer_trx.term_due_date%type,
4790: p_term_id IN ra_customer_trx.term_id%type,
4791: p_territory_id IN ra_customer_trx.territory_id%type,
4792: p_waybill_number IN ra_customer_trx.waybill_number%type,

Line 4789: p_term_due_date IN ra_customer_trx.term_due_date%type,

4785: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
4786: p_shipment_id IN ra_customer_trx.shipment_id%type,
4787: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
4788: p_ship_via IN ra_customer_trx.ship_via%type,
4789: p_term_due_date IN ra_customer_trx.term_due_date%type,
4790: p_term_id IN ra_customer_trx.term_id%type,
4791: p_territory_id IN ra_customer_trx.territory_id%type,
4792: p_waybill_number IN ra_customer_trx.waybill_number%type,
4793: p_status_trx IN ra_customer_trx.status_trx%type,

Line 4790: p_term_id IN ra_customer_trx.term_id%type,

4786: p_shipment_id IN ra_customer_trx.shipment_id%type,
4787: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
4788: p_ship_via IN ra_customer_trx.ship_via%type,
4789: p_term_due_date IN ra_customer_trx.term_due_date%type,
4790: p_term_id IN ra_customer_trx.term_id%type,
4791: p_territory_id IN ra_customer_trx.territory_id%type,
4792: p_waybill_number IN ra_customer_trx.waybill_number%type,
4793: p_status_trx IN ra_customer_trx.status_trx%type,
4794: p_reason_code IN ra_customer_trx.reason_code%type,

Line 4791: p_territory_id IN ra_customer_trx.territory_id%type,

4787: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
4788: p_ship_via IN ra_customer_trx.ship_via%type,
4789: p_term_due_date IN ra_customer_trx.term_due_date%type,
4790: p_term_id IN ra_customer_trx.term_id%type,
4791: p_territory_id IN ra_customer_trx.territory_id%type,
4792: p_waybill_number IN ra_customer_trx.waybill_number%type,
4793: p_status_trx IN ra_customer_trx.status_trx%type,
4794: p_reason_code IN ra_customer_trx.reason_code%type,
4795: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,

Line 4792: p_waybill_number IN ra_customer_trx.waybill_number%type,

4788: p_ship_via IN ra_customer_trx.ship_via%type,
4789: p_term_due_date IN ra_customer_trx.term_due_date%type,
4790: p_term_id IN ra_customer_trx.term_id%type,
4791: p_territory_id IN ra_customer_trx.territory_id%type,
4792: p_waybill_number IN ra_customer_trx.waybill_number%type,
4793: p_status_trx IN ra_customer_trx.status_trx%type,
4794: p_reason_code IN ra_customer_trx.reason_code%type,
4795: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
4796: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,

Line 4793: p_status_trx IN ra_customer_trx.status_trx%type,

4789: p_term_due_date IN ra_customer_trx.term_due_date%type,
4790: p_term_id IN ra_customer_trx.term_id%type,
4791: p_territory_id IN ra_customer_trx.territory_id%type,
4792: p_waybill_number IN ra_customer_trx.waybill_number%type,
4793: p_status_trx IN ra_customer_trx.status_trx%type,
4794: p_reason_code IN ra_customer_trx.reason_code%type,
4795: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
4796: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
4797: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,

Line 4794: p_reason_code IN ra_customer_trx.reason_code%type,

4790: p_term_id IN ra_customer_trx.term_id%type,
4791: p_territory_id IN ra_customer_trx.territory_id%type,
4792: p_waybill_number IN ra_customer_trx.waybill_number%type,
4793: p_status_trx IN ra_customer_trx.status_trx%type,
4794: p_reason_code IN ra_customer_trx.reason_code%type,
4795: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
4796: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
4797: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
4798: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,

Line 4795: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,

4791: p_territory_id IN ra_customer_trx.territory_id%type,
4792: p_waybill_number IN ra_customer_trx.waybill_number%type,
4793: p_status_trx IN ra_customer_trx.status_trx%type,
4794: p_reason_code IN ra_customer_trx.reason_code%type,
4795: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
4796: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
4797: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
4798: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
4799: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,

Line 4796: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,

4792: p_waybill_number IN ra_customer_trx.waybill_number%type,
4793: p_status_trx IN ra_customer_trx.status_trx%type,
4794: p_reason_code IN ra_customer_trx.reason_code%type,
4795: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
4796: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
4797: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
4798: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
4799: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
4800: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,

Line 4797: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,

4793: p_status_trx IN ra_customer_trx.status_trx%type,
4794: p_reason_code IN ra_customer_trx.reason_code%type,
4795: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
4796: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
4797: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
4798: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
4799: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
4800: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,
4801: p_created_from IN ra_customer_trx.created_from%type,

Line 4798: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,

4794: p_reason_code IN ra_customer_trx.reason_code%type,
4795: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
4796: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
4797: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
4798: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
4799: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
4800: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,
4801: p_created_from IN ra_customer_trx.created_from%type,
4802: p_deflt_ussgl_trx_code_context IN

Line 4799: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,

4795: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
4796: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
4797: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
4798: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
4799: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
4800: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,
4801: p_created_from IN ra_customer_trx.created_from%type,
4802: p_deflt_ussgl_trx_code_context IN
4803: ra_customer_trx.default_ussgl_trx_code_context%type,

Line 4800: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,

4796: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
4797: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
4798: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
4799: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
4800: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,
4801: p_created_from IN ra_customer_trx.created_from%type,
4802: p_deflt_ussgl_trx_code_context IN
4803: ra_customer_trx.default_ussgl_trx_code_context%type,
4804: p_deflt_ussgl_transaction_code IN

Line 4801: p_created_from IN ra_customer_trx.created_from%type,

4797: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
4798: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
4799: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
4800: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,
4801: p_created_from IN ra_customer_trx.created_from%type,
4802: p_deflt_ussgl_trx_code_context IN
4803: ra_customer_trx.default_ussgl_trx_code_context%type,
4804: p_deflt_ussgl_transaction_code IN
4805: ra_customer_trx.default_ussgl_transaction_code%type,

Line 4803: ra_customer_trx.default_ussgl_trx_code_context%type,

4799: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
4800: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,
4801: p_created_from IN ra_customer_trx.created_from%type,
4802: p_deflt_ussgl_trx_code_context IN
4803: ra_customer_trx.default_ussgl_trx_code_context%type,
4804: p_deflt_ussgl_transaction_code IN
4805: ra_customer_trx.default_ussgl_transaction_code%type,
4806: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
4807: p_interface_header_context IN

Line 4805: ra_customer_trx.default_ussgl_transaction_code%type,

4801: p_created_from IN ra_customer_trx.created_from%type,
4802: p_deflt_ussgl_trx_code_context IN
4803: ra_customer_trx.default_ussgl_trx_code_context%type,
4804: p_deflt_ussgl_transaction_code IN
4805: ra_customer_trx.default_ussgl_transaction_code%type,
4806: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
4807: p_interface_header_context IN
4808: ra_customer_trx.interface_header_context%type,
4809: p_interface_header_attribute1 IN

Line 4806: p_old_trx_number IN ra_customer_trx.old_trx_number%type,

4802: p_deflt_ussgl_trx_code_context IN
4803: ra_customer_trx.default_ussgl_trx_code_context%type,
4804: p_deflt_ussgl_transaction_code IN
4805: ra_customer_trx.default_ussgl_transaction_code%type,
4806: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
4807: p_interface_header_context IN
4808: ra_customer_trx.interface_header_context%type,
4809: p_interface_header_attribute1 IN
4810: ra_customer_trx.interface_header_attribute1%type,

Line 4808: ra_customer_trx.interface_header_context%type,

4804: p_deflt_ussgl_transaction_code IN
4805: ra_customer_trx.default_ussgl_transaction_code%type,
4806: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
4807: p_interface_header_context IN
4808: ra_customer_trx.interface_header_context%type,
4809: p_interface_header_attribute1 IN
4810: ra_customer_trx.interface_header_attribute1%type,
4811: p_interface_header_attribute2 IN
4812: ra_customer_trx.interface_header_attribute2%type,

Line 4810: ra_customer_trx.interface_header_attribute1%type,

4806: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
4807: p_interface_header_context IN
4808: ra_customer_trx.interface_header_context%type,
4809: p_interface_header_attribute1 IN
4810: ra_customer_trx.interface_header_attribute1%type,
4811: p_interface_header_attribute2 IN
4812: ra_customer_trx.interface_header_attribute2%type,
4813: p_interface_header_attribute3 IN
4814: ra_customer_trx.interface_header_attribute3%type,

Line 4812: ra_customer_trx.interface_header_attribute2%type,

4808: ra_customer_trx.interface_header_context%type,
4809: p_interface_header_attribute1 IN
4810: ra_customer_trx.interface_header_attribute1%type,
4811: p_interface_header_attribute2 IN
4812: ra_customer_trx.interface_header_attribute2%type,
4813: p_interface_header_attribute3 IN
4814: ra_customer_trx.interface_header_attribute3%type,
4815: p_interface_header_attribute4 IN
4816: ra_customer_trx.interface_header_attribute4%type,

Line 4814: ra_customer_trx.interface_header_attribute3%type,

4810: ra_customer_trx.interface_header_attribute1%type,
4811: p_interface_header_attribute2 IN
4812: ra_customer_trx.interface_header_attribute2%type,
4813: p_interface_header_attribute3 IN
4814: ra_customer_trx.interface_header_attribute3%type,
4815: p_interface_header_attribute4 IN
4816: ra_customer_trx.interface_header_attribute4%type,
4817: p_interface_header_attribute5 IN
4818: ra_customer_trx.interface_header_attribute5%type,

Line 4816: ra_customer_trx.interface_header_attribute4%type,

4812: ra_customer_trx.interface_header_attribute2%type,
4813: p_interface_header_attribute3 IN
4814: ra_customer_trx.interface_header_attribute3%type,
4815: p_interface_header_attribute4 IN
4816: ra_customer_trx.interface_header_attribute4%type,
4817: p_interface_header_attribute5 IN
4818: ra_customer_trx.interface_header_attribute5%type,
4819: p_interface_header_attribute6 IN
4820: ra_customer_trx.interface_header_attribute6%type,

Line 4818: ra_customer_trx.interface_header_attribute5%type,

4814: ra_customer_trx.interface_header_attribute3%type,
4815: p_interface_header_attribute4 IN
4816: ra_customer_trx.interface_header_attribute4%type,
4817: p_interface_header_attribute5 IN
4818: ra_customer_trx.interface_header_attribute5%type,
4819: p_interface_header_attribute6 IN
4820: ra_customer_trx.interface_header_attribute6%type,
4821: p_interface_header_attribute7 IN
4822: ra_customer_trx.interface_header_attribute7%type,

Line 4820: ra_customer_trx.interface_header_attribute6%type,

4816: ra_customer_trx.interface_header_attribute4%type,
4817: p_interface_header_attribute5 IN
4818: ra_customer_trx.interface_header_attribute5%type,
4819: p_interface_header_attribute6 IN
4820: ra_customer_trx.interface_header_attribute6%type,
4821: p_interface_header_attribute7 IN
4822: ra_customer_trx.interface_header_attribute7%type,
4823: p_interface_header_attribute8 IN
4824: ra_customer_trx.interface_header_attribute8%type,

Line 4822: ra_customer_trx.interface_header_attribute7%type,

4818: ra_customer_trx.interface_header_attribute5%type,
4819: p_interface_header_attribute6 IN
4820: ra_customer_trx.interface_header_attribute6%type,
4821: p_interface_header_attribute7 IN
4822: ra_customer_trx.interface_header_attribute7%type,
4823: p_interface_header_attribute8 IN
4824: ra_customer_trx.interface_header_attribute8%type,
4825: p_interface_header_attribute9 IN
4826: ra_customer_trx.interface_header_attribute9%type,

Line 4824: ra_customer_trx.interface_header_attribute8%type,

4820: ra_customer_trx.interface_header_attribute6%type,
4821: p_interface_header_attribute7 IN
4822: ra_customer_trx.interface_header_attribute7%type,
4823: p_interface_header_attribute8 IN
4824: ra_customer_trx.interface_header_attribute8%type,
4825: p_interface_header_attribute9 IN
4826: ra_customer_trx.interface_header_attribute9%type,
4827: p_interface_header_attribute10 IN
4828: ra_customer_trx.interface_header_attribute10%type,

Line 4826: ra_customer_trx.interface_header_attribute9%type,

4822: ra_customer_trx.interface_header_attribute7%type,
4823: p_interface_header_attribute8 IN
4824: ra_customer_trx.interface_header_attribute8%type,
4825: p_interface_header_attribute9 IN
4826: ra_customer_trx.interface_header_attribute9%type,
4827: p_interface_header_attribute10 IN
4828: ra_customer_trx.interface_header_attribute10%type,
4829: p_interface_header_attribute11 IN
4830: ra_customer_trx.interface_header_attribute11%type,

Line 4828: ra_customer_trx.interface_header_attribute10%type,

4824: ra_customer_trx.interface_header_attribute8%type,
4825: p_interface_header_attribute9 IN
4826: ra_customer_trx.interface_header_attribute9%type,
4827: p_interface_header_attribute10 IN
4828: ra_customer_trx.interface_header_attribute10%type,
4829: p_interface_header_attribute11 IN
4830: ra_customer_trx.interface_header_attribute11%type,
4831: p_interface_header_attribute12 IN
4832: ra_customer_trx.interface_header_attribute12%type,

Line 4830: ra_customer_trx.interface_header_attribute11%type,

4826: ra_customer_trx.interface_header_attribute9%type,
4827: p_interface_header_attribute10 IN
4828: ra_customer_trx.interface_header_attribute10%type,
4829: p_interface_header_attribute11 IN
4830: ra_customer_trx.interface_header_attribute11%type,
4831: p_interface_header_attribute12 IN
4832: ra_customer_trx.interface_header_attribute12%type,
4833: p_interface_header_attribute13 IN
4834: ra_customer_trx.interface_header_attribute13%type,

Line 4832: ra_customer_trx.interface_header_attribute12%type,

4828: ra_customer_trx.interface_header_attribute10%type,
4829: p_interface_header_attribute11 IN
4830: ra_customer_trx.interface_header_attribute11%type,
4831: p_interface_header_attribute12 IN
4832: ra_customer_trx.interface_header_attribute12%type,
4833: p_interface_header_attribute13 IN
4834: ra_customer_trx.interface_header_attribute13%type,
4835: p_interface_header_attribute14 IN
4836: ra_customer_trx.interface_header_attribute14%type,

Line 4834: ra_customer_trx.interface_header_attribute13%type,

4830: ra_customer_trx.interface_header_attribute11%type,
4831: p_interface_header_attribute12 IN
4832: ra_customer_trx.interface_header_attribute12%type,
4833: p_interface_header_attribute13 IN
4834: ra_customer_trx.interface_header_attribute13%type,
4835: p_interface_header_attribute14 IN
4836: ra_customer_trx.interface_header_attribute14%type,
4837: p_interface_header_attribute15 IN
4838: ra_customer_trx.interface_header_attribute15%type,

Line 4836: ra_customer_trx.interface_header_attribute14%type,

4832: ra_customer_trx.interface_header_attribute12%type,
4833: p_interface_header_attribute13 IN
4834: ra_customer_trx.interface_header_attribute13%type,
4835: p_interface_header_attribute14 IN
4836: ra_customer_trx.interface_header_attribute14%type,
4837: p_interface_header_attribute15 IN
4838: ra_customer_trx.interface_header_attribute15%type,
4839: p_attribute_category IN ra_customer_trx.attribute_category%type,
4840: p_attribute1 IN ra_customer_trx.attribute1%type,

Line 4838: ra_customer_trx.interface_header_attribute15%type,

4834: ra_customer_trx.interface_header_attribute13%type,
4835: p_interface_header_attribute14 IN
4836: ra_customer_trx.interface_header_attribute14%type,
4837: p_interface_header_attribute15 IN
4838: ra_customer_trx.interface_header_attribute15%type,
4839: p_attribute_category IN ra_customer_trx.attribute_category%type,
4840: p_attribute1 IN ra_customer_trx.attribute1%type,
4841: p_attribute2 IN ra_customer_trx.attribute2%type,
4842: p_attribute3 IN ra_customer_trx.attribute3%type,

Line 4839: p_attribute_category IN ra_customer_trx.attribute_category%type,

4835: p_interface_header_attribute14 IN
4836: ra_customer_trx.interface_header_attribute14%type,
4837: p_interface_header_attribute15 IN
4838: ra_customer_trx.interface_header_attribute15%type,
4839: p_attribute_category IN ra_customer_trx.attribute_category%type,
4840: p_attribute1 IN ra_customer_trx.attribute1%type,
4841: p_attribute2 IN ra_customer_trx.attribute2%type,
4842: p_attribute3 IN ra_customer_trx.attribute3%type,
4843: p_attribute4 IN ra_customer_trx.attribute4%type,

Line 4840: p_attribute1 IN ra_customer_trx.attribute1%type,

4836: ra_customer_trx.interface_header_attribute14%type,
4837: p_interface_header_attribute15 IN
4838: ra_customer_trx.interface_header_attribute15%type,
4839: p_attribute_category IN ra_customer_trx.attribute_category%type,
4840: p_attribute1 IN ra_customer_trx.attribute1%type,
4841: p_attribute2 IN ra_customer_trx.attribute2%type,
4842: p_attribute3 IN ra_customer_trx.attribute3%type,
4843: p_attribute4 IN ra_customer_trx.attribute4%type,
4844: p_attribute5 IN ra_customer_trx.attribute5%type,

Line 4841: p_attribute2 IN ra_customer_trx.attribute2%type,

4837: p_interface_header_attribute15 IN
4838: ra_customer_trx.interface_header_attribute15%type,
4839: p_attribute_category IN ra_customer_trx.attribute_category%type,
4840: p_attribute1 IN ra_customer_trx.attribute1%type,
4841: p_attribute2 IN ra_customer_trx.attribute2%type,
4842: p_attribute3 IN ra_customer_trx.attribute3%type,
4843: p_attribute4 IN ra_customer_trx.attribute4%type,
4844: p_attribute5 IN ra_customer_trx.attribute5%type,
4845: p_attribute6 IN ra_customer_trx.attribute6%type,

Line 4842: p_attribute3 IN ra_customer_trx.attribute3%type,

4838: ra_customer_trx.interface_header_attribute15%type,
4839: p_attribute_category IN ra_customer_trx.attribute_category%type,
4840: p_attribute1 IN ra_customer_trx.attribute1%type,
4841: p_attribute2 IN ra_customer_trx.attribute2%type,
4842: p_attribute3 IN ra_customer_trx.attribute3%type,
4843: p_attribute4 IN ra_customer_trx.attribute4%type,
4844: p_attribute5 IN ra_customer_trx.attribute5%type,
4845: p_attribute6 IN ra_customer_trx.attribute6%type,
4846: p_attribute7 IN ra_customer_trx.attribute7%type,

Line 4843: p_attribute4 IN ra_customer_trx.attribute4%type,

4839: p_attribute_category IN ra_customer_trx.attribute_category%type,
4840: p_attribute1 IN ra_customer_trx.attribute1%type,
4841: p_attribute2 IN ra_customer_trx.attribute2%type,
4842: p_attribute3 IN ra_customer_trx.attribute3%type,
4843: p_attribute4 IN ra_customer_trx.attribute4%type,
4844: p_attribute5 IN ra_customer_trx.attribute5%type,
4845: p_attribute6 IN ra_customer_trx.attribute6%type,
4846: p_attribute7 IN ra_customer_trx.attribute7%type,
4847: p_attribute8 IN ra_customer_trx.attribute8%type,

Line 4844: p_attribute5 IN ra_customer_trx.attribute5%type,

4840: p_attribute1 IN ra_customer_trx.attribute1%type,
4841: p_attribute2 IN ra_customer_trx.attribute2%type,
4842: p_attribute3 IN ra_customer_trx.attribute3%type,
4843: p_attribute4 IN ra_customer_trx.attribute4%type,
4844: p_attribute5 IN ra_customer_trx.attribute5%type,
4845: p_attribute6 IN ra_customer_trx.attribute6%type,
4846: p_attribute7 IN ra_customer_trx.attribute7%type,
4847: p_attribute8 IN ra_customer_trx.attribute8%type,
4848: p_attribute9 IN ra_customer_trx.attribute9%type,

Line 4845: p_attribute6 IN ra_customer_trx.attribute6%type,

4841: p_attribute2 IN ra_customer_trx.attribute2%type,
4842: p_attribute3 IN ra_customer_trx.attribute3%type,
4843: p_attribute4 IN ra_customer_trx.attribute4%type,
4844: p_attribute5 IN ra_customer_trx.attribute5%type,
4845: p_attribute6 IN ra_customer_trx.attribute6%type,
4846: p_attribute7 IN ra_customer_trx.attribute7%type,
4847: p_attribute8 IN ra_customer_trx.attribute8%type,
4848: p_attribute9 IN ra_customer_trx.attribute9%type,
4849: p_attribute10 IN ra_customer_trx.attribute10%type,

Line 4846: p_attribute7 IN ra_customer_trx.attribute7%type,

4842: p_attribute3 IN ra_customer_trx.attribute3%type,
4843: p_attribute4 IN ra_customer_trx.attribute4%type,
4844: p_attribute5 IN ra_customer_trx.attribute5%type,
4845: p_attribute6 IN ra_customer_trx.attribute6%type,
4846: p_attribute7 IN ra_customer_trx.attribute7%type,
4847: p_attribute8 IN ra_customer_trx.attribute8%type,
4848: p_attribute9 IN ra_customer_trx.attribute9%type,
4849: p_attribute10 IN ra_customer_trx.attribute10%type,
4850: p_attribute11 IN ra_customer_trx.attribute11%type,

Line 4847: p_attribute8 IN ra_customer_trx.attribute8%type,

4843: p_attribute4 IN ra_customer_trx.attribute4%type,
4844: p_attribute5 IN ra_customer_trx.attribute5%type,
4845: p_attribute6 IN ra_customer_trx.attribute6%type,
4846: p_attribute7 IN ra_customer_trx.attribute7%type,
4847: p_attribute8 IN ra_customer_trx.attribute8%type,
4848: p_attribute9 IN ra_customer_trx.attribute9%type,
4849: p_attribute10 IN ra_customer_trx.attribute10%type,
4850: p_attribute11 IN ra_customer_trx.attribute11%type,
4851: p_attribute12 IN ra_customer_trx.attribute12%type,

Line 4848: p_attribute9 IN ra_customer_trx.attribute9%type,

4844: p_attribute5 IN ra_customer_trx.attribute5%type,
4845: p_attribute6 IN ra_customer_trx.attribute6%type,
4846: p_attribute7 IN ra_customer_trx.attribute7%type,
4847: p_attribute8 IN ra_customer_trx.attribute8%type,
4848: p_attribute9 IN ra_customer_trx.attribute9%type,
4849: p_attribute10 IN ra_customer_trx.attribute10%type,
4850: p_attribute11 IN ra_customer_trx.attribute11%type,
4851: p_attribute12 IN ra_customer_trx.attribute12%type,
4852: p_attribute13 IN ra_customer_trx.attribute13%type,

Line 4849: p_attribute10 IN ra_customer_trx.attribute10%type,

4845: p_attribute6 IN ra_customer_trx.attribute6%type,
4846: p_attribute7 IN ra_customer_trx.attribute7%type,
4847: p_attribute8 IN ra_customer_trx.attribute8%type,
4848: p_attribute9 IN ra_customer_trx.attribute9%type,
4849: p_attribute10 IN ra_customer_trx.attribute10%type,
4850: p_attribute11 IN ra_customer_trx.attribute11%type,
4851: p_attribute12 IN ra_customer_trx.attribute12%type,
4852: p_attribute13 IN ra_customer_trx.attribute13%type,
4853: p_attribute14 IN ra_customer_trx.attribute14%type,

Line 4850: p_attribute11 IN ra_customer_trx.attribute11%type,

4846: p_attribute7 IN ra_customer_trx.attribute7%type,
4847: p_attribute8 IN ra_customer_trx.attribute8%type,
4848: p_attribute9 IN ra_customer_trx.attribute9%type,
4849: p_attribute10 IN ra_customer_trx.attribute10%type,
4850: p_attribute11 IN ra_customer_trx.attribute11%type,
4851: p_attribute12 IN ra_customer_trx.attribute12%type,
4852: p_attribute13 IN ra_customer_trx.attribute13%type,
4853: p_attribute14 IN ra_customer_trx.attribute14%type,
4854: p_attribute15 IN ra_customer_trx.attribute15%type,

Line 4851: p_attribute12 IN ra_customer_trx.attribute12%type,

4847: p_attribute8 IN ra_customer_trx.attribute8%type,
4848: p_attribute9 IN ra_customer_trx.attribute9%type,
4849: p_attribute10 IN ra_customer_trx.attribute10%type,
4850: p_attribute11 IN ra_customer_trx.attribute11%type,
4851: p_attribute12 IN ra_customer_trx.attribute12%type,
4852: p_attribute13 IN ra_customer_trx.attribute13%type,
4853: p_attribute14 IN ra_customer_trx.attribute14%type,
4854: p_attribute15 IN ra_customer_trx.attribute15%type,
4855: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,

Line 4852: p_attribute13 IN ra_customer_trx.attribute13%type,

4848: p_attribute9 IN ra_customer_trx.attribute9%type,
4849: p_attribute10 IN ra_customer_trx.attribute10%type,
4850: p_attribute11 IN ra_customer_trx.attribute11%type,
4851: p_attribute12 IN ra_customer_trx.attribute12%type,
4852: p_attribute13 IN ra_customer_trx.attribute13%type,
4853: p_attribute14 IN ra_customer_trx.attribute14%type,
4854: p_attribute15 IN ra_customer_trx.attribute15%type,
4855: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,
4856: p_payment_trxn_extension_id IN ra_customer_trx.payment_trxn_extension_id%type,

Line 4853: p_attribute14 IN ra_customer_trx.attribute14%type,

4849: p_attribute10 IN ra_customer_trx.attribute10%type,
4850: p_attribute11 IN ra_customer_trx.attribute11%type,
4851: p_attribute12 IN ra_customer_trx.attribute12%type,
4852: p_attribute13 IN ra_customer_trx.attribute13%type,
4853: p_attribute14 IN ra_customer_trx.attribute14%type,
4854: p_attribute15 IN ra_customer_trx.attribute15%type,
4855: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,
4856: p_payment_trxn_extension_id IN ra_customer_trx.payment_trxn_extension_id%type,
4857: p_billing_date IN ra_customer_trx.billing_date%type)

Line 4854: p_attribute15 IN ra_customer_trx.attribute15%type,

4850: p_attribute11 IN ra_customer_trx.attribute11%type,
4851: p_attribute12 IN ra_customer_trx.attribute12%type,
4852: p_attribute13 IN ra_customer_trx.attribute13%type,
4853: p_attribute14 IN ra_customer_trx.attribute14%type,
4854: p_attribute15 IN ra_customer_trx.attribute15%type,
4855: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,
4856: p_payment_trxn_extension_id IN ra_customer_trx.payment_trxn_extension_id%type,
4857: p_billing_date IN ra_customer_trx.billing_date%type)
4858:

Line 4855: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,

4851: p_attribute12 IN ra_customer_trx.attribute12%type,
4852: p_attribute13 IN ra_customer_trx.attribute13%type,
4853: p_attribute14 IN ra_customer_trx.attribute14%type,
4854: p_attribute15 IN ra_customer_trx.attribute15%type,
4855: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,
4856: p_payment_trxn_extension_id IN ra_customer_trx.payment_trxn_extension_id%type,
4857: p_billing_date IN ra_customer_trx.billing_date%type)
4858:
4859:

Line 4856: p_payment_trxn_extension_id IN ra_customer_trx.payment_trxn_extension_id%type,

4852: p_attribute13 IN ra_customer_trx.attribute13%type,
4853: p_attribute14 IN ra_customer_trx.attribute14%type,
4854: p_attribute15 IN ra_customer_trx.attribute15%type,
4855: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,
4856: p_payment_trxn_extension_id IN ra_customer_trx.payment_trxn_extension_id%type,
4857: p_billing_date IN ra_customer_trx.billing_date%type)
4858:
4859:
4860: IS

Line 4857: p_billing_date IN ra_customer_trx.billing_date%type)

4853: p_attribute14 IN ra_customer_trx.attribute14%type,
4854: p_attribute15 IN ra_customer_trx.attribute15%type,
4855: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,
4856: p_payment_trxn_extension_id IN ra_customer_trx.payment_trxn_extension_id%type,
4857: p_billing_date IN ra_customer_trx.billing_date%type)
4858:
4859:
4860: IS
4861:

Line 4862: l_trx_rec ra_customer_trx%rowtype;

4858:
4859:
4860: IS
4861:
4862: l_trx_rec ra_customer_trx%rowtype;
4863:
4864: BEGIN
4865: arp_util.debug('arp_ct_pkg.lock_compare_cover()+');
4866:

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

5388: | PROCEDURE |
5389: | update_tax |
5390: | |
5391: | DESCRIPTION |
5392: | This procedure updates the ra_customer_trx row identified by the |
5393: | p_customer_trx_id parameter. |
5394: | |
5395: | SCOPE - PUBLIC |
5396: | |

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

5423: | and warehouse_id
5424: +===========================================================================*/
5425:
5426:
5427: PROCEDURE update_tax( p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
5428: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
5429: p_trx_date IN ra_customer_trx.trx_date%type,
5430: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
5431: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

Line 5428: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,

5424: +===========================================================================*/
5425:
5426:
5427: PROCEDURE update_tax( p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
5428: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
5429: p_trx_date IN ra_customer_trx.trx_date%type,
5430: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
5431: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
5432: P_TAX_AFFECT_FLAG in varchar2,

Line 5429: p_trx_date IN ra_customer_trx.trx_date%type,

5425:
5426:
5427: PROCEDURE update_tax( p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
5428: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
5429: p_trx_date IN ra_customer_trx.trx_date%type,
5430: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
5431: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
5432: P_TAX_AFFECT_FLAG in varchar2,
5433: p_enforce_nat_acc_flag IN BOOLEAN) IS

Line 5430: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,

5426:
5427: PROCEDURE update_tax( p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
5428: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
5429: p_trx_date IN ra_customer_trx.trx_date%type,
5430: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
5431: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
5432: P_TAX_AFFECT_FLAG in varchar2,
5433: p_enforce_nat_acc_flag IN BOOLEAN) IS
5434:

Line 5431: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

5427: PROCEDURE update_tax( p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
5428: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
5429: p_trx_date IN ra_customer_trx.trx_date%type,
5430: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
5431: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
5432: P_TAX_AFFECT_FLAG in varchar2,
5433: p_enforce_nat_acc_flag IN BOOLEAN) IS
5434:
5435: CURSOR update_header_lines IS

Line 5440: FROM ra_customer_trx_lines

5436: SELECT customer_trx_line_id,
5437: inventory_item_id,
5438: memo_line_id,
5439: warehouse_id
5440: FROM ra_customer_trx_lines
5441: WHERE customer_trx_id = p_customer_trx_id
5442: AND line_type = 'LINE';--3872371
5443:
5444: l_tax_code VARCHAR2(50);

Line 5449: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;

5445: l_vat_tax_id NUMBER ;
5446: l_organization_id NUMBER ;
5447: l_warehouse_id NUMBER;
5448: l_sob_id NUMBER;
5449: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
5450: l_inventory_item_id ra_customer_trx_lines.inventory_item_id%type;
5451: l_autotax ra_customer_trx_lines.autotax%type;
5452: l_amt_incl_tax_flag ar_vat_tax.amount_includes_tax_flag%type;
5453: l_amt_incl_tax_override ar_vat_tax.amount_includes_tax_override%type;

Line 5450: l_inventory_item_id ra_customer_trx_lines.inventory_item_id%type;

5446: l_organization_id NUMBER ;
5447: l_warehouse_id NUMBER;
5448: l_sob_id NUMBER;
5449: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
5450: l_inventory_item_id ra_customer_trx_lines.inventory_item_id%type;
5451: l_autotax ra_customer_trx_lines.autotax%type;
5452: l_amt_incl_tax_flag ar_vat_tax.amount_includes_tax_flag%type;
5453: l_amt_incl_tax_override ar_vat_tax.amount_includes_tax_override%type;
5454: /* bug fix : 1070949 */

Line 5451: l_autotax ra_customer_trx_lines.autotax%type;

5447: l_warehouse_id NUMBER;
5448: l_sob_id NUMBER;
5449: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
5450: l_inventory_item_id ra_customer_trx_lines.inventory_item_id%type;
5451: l_autotax ra_customer_trx_lines.autotax%type;
5452: l_amt_incl_tax_flag ar_vat_tax.amount_includes_tax_flag%type;
5453: l_amt_incl_tax_override ar_vat_tax.amount_includes_tax_override%type;
5454: /* bug fix : 1070949 */
5455: l_tax_calculation_flag varchar2(1);

Line 5533: p_entity_code => 'RA_CUSTOMER_TRX',

5529: p_cust_trx_id => p_customer_trx_id,
5530: p_cust_trx_line_id => line.customer_trx_line_id,
5531: p_customer_id => NULL,
5532: p_memo_line_id => line.memo_line_id,
5533: p_entity_code => 'RA_CUSTOMER_TRX',
5534: p_event_class_code => l_event_class_code,
5535: p_function_short_name => 'GL_ACCT_FIXUP',
5536: p_tax_classification_code => l_tax_code );
5537:

Line 5552: --- UPDATE RA_CUSTOMER_TRX_LINES with new

5548: END;
5549:
5550: IF l_tax_code IS NOT NULL
5551: THEN
5552: --- UPDATE RA_CUSTOMER_TRX_LINES with new
5553: --- tax_code and autotax='Y'
5554: update ra_customer_trx_lines
5555: set tax_classification_code = l_tax_code,
5556: autotax = l_autotax

Line 5554: update ra_customer_trx_lines

5550: IF l_tax_code IS NOT NULL
5551: THEN
5552: --- UPDATE RA_CUSTOMER_TRX_LINES with new
5553: --- tax_code and autotax='Y'
5554: update ra_customer_trx_lines
5555: set tax_classification_code = l_tax_code,
5556: autotax = l_autotax
5557: where customer_trx_line_id = line.customer_trx_line_id;
5558: END IF;

Line 5584: p_entity_code => 'RA_CUSTOMER_TRX',

5580: p_cust_trx_id => p_customer_trx_id,
5581: p_cust_trx_line_id => line.customer_trx_line_id,
5582: p_customer_id => NULL,
5583: p_memo_line_id => line.memo_line_id,
5584: p_entity_code => 'RA_CUSTOMER_TRX',
5585: p_event_class_code => l_event_class_code,
5586: p_function_short_name => 'ACCT_DIST',
5587: p_tax_classification_code => l_tax_code );
5588: ELSE

Line 5605: update ra_customer_trx_lines

5601: l_tax_code := NULL;
5602: l_autotax := 'Y';
5603: END;
5604:
5605: update ra_customer_trx_lines
5606: set tax_classification_code = l_tax_code,
5607: autotax = l_autotax
5608: where customer_trx_line_id = line.customer_trx_line_id;
5609:

Line 5786: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

5782: | Global parameters are also passed. |
5783: +===========================================================================*/
5784:
5785: PROCEDURE lock_compare_cover(
5786: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
5787: p_trx_number IN ra_customer_trx.trx_number%type,
5788: p_posting_control_id IN ra_customer_trx.posting_control_id%type,
5789: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
5790: p_complete_flag IN ra_customer_trx.complete_flag%type,

Line 5787: p_trx_number IN ra_customer_trx.trx_number%type,

5783: +===========================================================================*/
5784:
5785: PROCEDURE lock_compare_cover(
5786: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
5787: p_trx_number IN ra_customer_trx.trx_number%type,
5788: p_posting_control_id IN ra_customer_trx.posting_control_id%type,
5789: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
5790: p_complete_flag IN ra_customer_trx.complete_flag%type,
5791: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,

Line 5788: p_posting_control_id IN ra_customer_trx.posting_control_id%type,

5784:
5785: PROCEDURE lock_compare_cover(
5786: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
5787: p_trx_number IN ra_customer_trx.trx_number%type,
5788: p_posting_control_id IN ra_customer_trx.posting_control_id%type,
5789: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
5790: p_complete_flag IN ra_customer_trx.complete_flag%type,
5791: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
5792: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,

Line 5789: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,

5785: PROCEDURE lock_compare_cover(
5786: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
5787: p_trx_number IN ra_customer_trx.trx_number%type,
5788: p_posting_control_id IN ra_customer_trx.posting_control_id%type,
5789: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
5790: p_complete_flag IN ra_customer_trx.complete_flag%type,
5791: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
5792: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
5793: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,

Line 5790: p_complete_flag IN ra_customer_trx.complete_flag%type,

5786: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
5787: p_trx_number IN ra_customer_trx.trx_number%type,
5788: p_posting_control_id IN ra_customer_trx.posting_control_id%type,
5789: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
5790: p_complete_flag IN ra_customer_trx.complete_flag%type,
5791: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
5792: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
5793: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
5794: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,

Line 5791: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,

5787: p_trx_number IN ra_customer_trx.trx_number%type,
5788: p_posting_control_id IN ra_customer_trx.posting_control_id%type,
5789: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
5790: p_complete_flag IN ra_customer_trx.complete_flag%type,
5791: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
5792: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
5793: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
5794: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
5795: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,

Line 5792: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,

5788: p_posting_control_id IN ra_customer_trx.posting_control_id%type,
5789: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
5790: p_complete_flag IN ra_customer_trx.complete_flag%type,
5791: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
5792: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
5793: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
5794: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
5795: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
5796: p_batch_id IN ra_customer_trx.batch_id%type,

Line 5793: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,

5789: p_ra_post_loop_number IN ra_customer_trx.ra_post_loop_number%type,
5790: p_complete_flag IN ra_customer_trx.complete_flag%type,
5791: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
5792: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
5793: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
5794: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
5795: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
5796: p_batch_id IN ra_customer_trx.batch_id%type,
5797: p_batch_source_id IN ra_customer_trx.batch_source_id%type,

Line 5794: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,

5790: p_complete_flag IN ra_customer_trx.complete_flag%type,
5791: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
5792: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
5793: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
5794: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
5795: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
5796: p_batch_id IN ra_customer_trx.batch_id%type,
5797: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
5798: p_agreement_id IN ra_customer_trx.agreement_id%type,

Line 5795: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,

5791: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
5792: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
5793: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
5794: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
5795: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
5796: p_batch_id IN ra_customer_trx.batch_id%type,
5797: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
5798: p_agreement_id IN ra_customer_trx.agreement_id%type,
5799: p_trx_date IN ra_customer_trx.trx_date%type,

Line 5796: p_batch_id IN ra_customer_trx.batch_id%type,

5792: p_previous_customer_trx_id IN ra_customer_trx.previous_customer_trx_id%type,
5793: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
5794: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
5795: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
5796: p_batch_id IN ra_customer_trx.batch_id%type,
5797: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
5798: p_agreement_id IN ra_customer_trx.agreement_id%type,
5799: p_trx_date IN ra_customer_trx.trx_date%type,
5800: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,

Line 5797: p_batch_source_id IN ra_customer_trx.batch_source_id%type,

5793: p_related_customer_trx_id IN ra_customer_trx.related_customer_trx_id%type,
5794: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
5795: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
5796: p_batch_id IN ra_customer_trx.batch_id%type,
5797: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
5798: p_agreement_id IN ra_customer_trx.agreement_id%type,
5799: p_trx_date IN ra_customer_trx.trx_date%type,
5800: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
5801: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,

Line 5798: p_agreement_id IN ra_customer_trx.agreement_id%type,

5794: p_recurred_from_trx_number IN ra_customer_trx.recurred_from_trx_number%type,
5795: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
5796: p_batch_id IN ra_customer_trx.batch_id%type,
5797: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
5798: p_agreement_id IN ra_customer_trx.agreement_id%type,
5799: p_trx_date IN ra_customer_trx.trx_date%type,
5800: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
5801: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
5802: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,

Line 5799: p_trx_date IN ra_customer_trx.trx_date%type,

5795: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
5796: p_batch_id IN ra_customer_trx.batch_id%type,
5797: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
5798: p_agreement_id IN ra_customer_trx.agreement_id%type,
5799: p_trx_date IN ra_customer_trx.trx_date%type,
5800: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
5801: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
5802: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
5803: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,

Line 5800: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,

5796: p_batch_id IN ra_customer_trx.batch_id%type,
5797: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
5798: p_agreement_id IN ra_customer_trx.agreement_id%type,
5799: p_trx_date IN ra_customer_trx.trx_date%type,
5800: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
5801: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
5802: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
5803: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
5804: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,

Line 5801: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,

5797: p_batch_source_id IN ra_customer_trx.batch_source_id%type,
5798: p_agreement_id IN ra_customer_trx.agreement_id%type,
5799: p_trx_date IN ra_customer_trx.trx_date%type,
5800: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
5801: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
5802: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
5803: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
5804: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
5805: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,

Line 5802: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,

5798: p_agreement_id IN ra_customer_trx.agreement_id%type,
5799: p_trx_date IN ra_customer_trx.trx_date%type,
5800: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
5801: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
5802: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
5803: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
5804: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
5805: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
5806: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,

Line 5803: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,

5799: p_trx_date IN ra_customer_trx.trx_date%type,
5800: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
5801: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
5802: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
5803: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
5804: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
5805: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
5806: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
5807: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,

Line 5804: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,

5800: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
5801: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
5802: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
5803: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
5804: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
5805: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
5806: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
5807: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
5808: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,

Line 5805: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,

5801: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
5802: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
5803: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
5804: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
5805: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
5806: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
5807: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
5808: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
5809: p_customer_reference IN ra_customer_trx.customer_reference%type,

Line 5806: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,

5802: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
5803: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
5804: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
5805: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
5806: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
5807: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
5808: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
5809: p_customer_reference IN ra_customer_trx.customer_reference%type,
5810: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,

Line 5807: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,

5803: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
5804: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
5805: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
5806: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
5807: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
5808: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
5809: p_customer_reference IN ra_customer_trx.customer_reference%type,
5810: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
5811: p_cr_method_for_installments IN

Line 5808: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,

5804: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
5805: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
5806: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
5807: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
5808: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
5809: p_customer_reference IN ra_customer_trx.customer_reference%type,
5810: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
5811: p_cr_method_for_installments IN
5812: ra_customer_trx.credit_method_for_installments%type,

Line 5809: p_customer_reference IN ra_customer_trx.customer_reference%type,

5805: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
5806: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
5807: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
5808: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
5809: p_customer_reference IN ra_customer_trx.customer_reference%type,
5810: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
5811: p_cr_method_for_installments IN
5812: ra_customer_trx.credit_method_for_installments%type,
5813: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,

Line 5810: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,

5806: p_sold_to_customer_id IN ra_customer_trx.sold_to_customer_id%type,
5807: p_sold_to_site_use_id IN ra_customer_trx.sold_to_site_use_id%type,
5808: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
5809: p_customer_reference IN ra_customer_trx.customer_reference%type,
5810: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
5811: p_cr_method_for_installments IN
5812: ra_customer_trx.credit_method_for_installments%type,
5813: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
5814: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,

Line 5812: ra_customer_trx.credit_method_for_installments%type,

5808: p_sold_to_contact_id IN ra_customer_trx.sold_to_contact_id%type,
5809: p_customer_reference IN ra_customer_trx.customer_reference%type,
5810: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
5811: p_cr_method_for_installments IN
5812: ra_customer_trx.credit_method_for_installments%type,
5813: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
5814: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
5815: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
5816: p_exchange_date IN ra_customer_trx.exchange_date%type,

Line 5813: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,

5809: p_customer_reference IN ra_customer_trx.customer_reference%type,
5810: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
5811: p_cr_method_for_installments IN
5812: ra_customer_trx.credit_method_for_installments%type,
5813: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
5814: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
5815: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
5816: p_exchange_date IN ra_customer_trx.exchange_date%type,
5817: p_exchange_rate IN ra_customer_trx.exchange_rate%type,

Line 5814: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,

5810: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
5811: p_cr_method_for_installments IN
5812: ra_customer_trx.credit_method_for_installments%type,
5813: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
5814: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
5815: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
5816: p_exchange_date IN ra_customer_trx.exchange_date%type,
5817: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
5818: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,

Line 5815: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,

5811: p_cr_method_for_installments IN
5812: ra_customer_trx.credit_method_for_installments%type,
5813: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
5814: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
5815: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
5816: p_exchange_date IN ra_customer_trx.exchange_date%type,
5817: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
5818: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
5819: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,

Line 5816: p_exchange_date IN ra_customer_trx.exchange_date%type,

5812: ra_customer_trx.credit_method_for_installments%type,
5813: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
5814: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
5815: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
5816: p_exchange_date IN ra_customer_trx.exchange_date%type,
5817: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
5818: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
5819: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
5820: p_finance_charges IN ra_customer_trx.finance_charges%type,

Line 5817: p_exchange_rate IN ra_customer_trx.exchange_rate%type,

5813: p_credit_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
5814: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
5815: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
5816: p_exchange_date IN ra_customer_trx.exchange_date%type,
5817: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
5818: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
5819: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
5820: p_finance_charges IN ra_customer_trx.finance_charges%type,
5821: p_fob_point IN ra_customer_trx.fob_point%type,

Line 5818: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,

5814: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type,
5815: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
5816: p_exchange_date IN ra_customer_trx.exchange_date%type,
5817: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
5818: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
5819: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
5820: p_finance_charges IN ra_customer_trx.finance_charges%type,
5821: p_fob_point IN ra_customer_trx.fob_point%type,
5822: p_comments IN ra_customer_trx.comments%type,

Line 5819: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,

5815: p_end_date_commitment IN ra_customer_trx.end_date_commitment%type,
5816: p_exchange_date IN ra_customer_trx.exchange_date%type,
5817: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
5818: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
5819: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
5820: p_finance_charges IN ra_customer_trx.finance_charges%type,
5821: p_fob_point IN ra_customer_trx.fob_point%type,
5822: p_comments IN ra_customer_trx.comments%type,
5823: p_internal_notes IN ra_customer_trx.internal_notes%type,

Line 5820: p_finance_charges IN ra_customer_trx.finance_charges%type,

5816: p_exchange_date IN ra_customer_trx.exchange_date%type,
5817: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
5818: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
5819: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
5820: p_finance_charges IN ra_customer_trx.finance_charges%type,
5821: p_fob_point IN ra_customer_trx.fob_point%type,
5822: p_comments IN ra_customer_trx.comments%type,
5823: p_internal_notes IN ra_customer_trx.internal_notes%type,
5824: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,

Line 5821: p_fob_point IN ra_customer_trx.fob_point%type,

5817: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
5818: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
5819: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
5820: p_finance_charges IN ra_customer_trx.finance_charges%type,
5821: p_fob_point IN ra_customer_trx.fob_point%type,
5822: p_comments IN ra_customer_trx.comments%type,
5823: p_internal_notes IN ra_customer_trx.internal_notes%type,
5824: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
5825: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,

Line 5822: p_comments IN ra_customer_trx.comments%type,

5818: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
5819: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
5820: p_finance_charges IN ra_customer_trx.finance_charges%type,
5821: p_fob_point IN ra_customer_trx.fob_point%type,
5822: p_comments IN ra_customer_trx.comments%type,
5823: p_internal_notes IN ra_customer_trx.internal_notes%type,
5824: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
5825: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
5826: p_last_printed_sequence_num IN

Line 5823: p_internal_notes IN ra_customer_trx.internal_notes%type,

5819: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
5820: p_finance_charges IN ra_customer_trx.finance_charges%type,
5821: p_fob_point IN ra_customer_trx.fob_point%type,
5822: p_comments IN ra_customer_trx.comments%type,
5823: p_internal_notes IN ra_customer_trx.internal_notes%type,
5824: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
5825: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
5826: p_last_printed_sequence_num IN
5827: ra_customer_trx.last_printed_sequence_num%type,

Line 5824: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,

5820: p_finance_charges IN ra_customer_trx.finance_charges%type,
5821: p_fob_point IN ra_customer_trx.fob_point%type,
5822: p_comments IN ra_customer_trx.comments%type,
5823: p_internal_notes IN ra_customer_trx.internal_notes%type,
5824: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
5825: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
5826: p_last_printed_sequence_num IN
5827: ra_customer_trx.last_printed_sequence_num%type,
5828: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,

Line 5825: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,

5821: p_fob_point IN ra_customer_trx.fob_point%type,
5822: p_comments IN ra_customer_trx.comments%type,
5823: p_internal_notes IN ra_customer_trx.internal_notes%type,
5824: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
5825: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
5826: p_last_printed_sequence_num IN
5827: ra_customer_trx.last_printed_sequence_num%type,
5828: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
5829: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,

Line 5827: ra_customer_trx.last_printed_sequence_num%type,

5823: p_internal_notes IN ra_customer_trx.internal_notes%type,
5824: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
5825: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
5826: p_last_printed_sequence_num IN
5827: ra_customer_trx.last_printed_sequence_num%type,
5828: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
5829: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
5830: p_printing_count IN ra_customer_trx.printing_count%type,
5831: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,

Line 5828: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,

5824: p_invoice_currency_code IN ra_customer_trx.invoice_currency_code%type,
5825: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
5826: p_last_printed_sequence_num IN
5827: ra_customer_trx.last_printed_sequence_num%type,
5828: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
5829: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
5830: p_printing_count IN ra_customer_trx.printing_count%type,
5831: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
5832: p_printing_option IN ra_customer_trx.printing_option%type,

Line 5829: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,

5825: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
5826: p_last_printed_sequence_num IN
5827: ra_customer_trx.last_printed_sequence_num%type,
5828: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
5829: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
5830: p_printing_count IN ra_customer_trx.printing_count%type,
5831: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
5832: p_printing_option IN ra_customer_trx.printing_option%type,
5833: p_printing_original_date IN ra_customer_trx.printing_original_date%type,

Line 5830: p_printing_count IN ra_customer_trx.printing_count%type,

5826: p_last_printed_sequence_num IN
5827: ra_customer_trx.last_printed_sequence_num%type,
5828: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
5829: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
5830: p_printing_count IN ra_customer_trx.printing_count%type,
5831: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
5832: p_printing_option IN ra_customer_trx.printing_option%type,
5833: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
5834: p_printing_pending IN ra_customer_trx.printing_pending%type,

Line 5831: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,

5827: ra_customer_trx.last_printed_sequence_num%type,
5828: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
5829: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
5830: p_printing_count IN ra_customer_trx.printing_count%type,
5831: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
5832: p_printing_option IN ra_customer_trx.printing_option%type,
5833: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
5834: p_printing_pending IN ra_customer_trx.printing_pending%type,
5835: p_purchase_order IN ra_customer_trx.purchase_order%type,

Line 5832: p_printing_option IN ra_customer_trx.printing_option%type,

5828: p_orig_system_batch_name IN ra_customer_trx.orig_system_batch_name%type,
5829: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
5830: p_printing_count IN ra_customer_trx.printing_count%type,
5831: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
5832: p_printing_option IN ra_customer_trx.printing_option%type,
5833: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
5834: p_printing_pending IN ra_customer_trx.printing_pending%type,
5835: p_purchase_order IN ra_customer_trx.purchase_order%type,
5836: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,

Line 5833: p_printing_original_date IN ra_customer_trx.printing_original_date%type,

5829: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
5830: p_printing_count IN ra_customer_trx.printing_count%type,
5831: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
5832: p_printing_option IN ra_customer_trx.printing_option%type,
5833: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
5834: p_printing_pending IN ra_customer_trx.printing_pending%type,
5835: p_purchase_order IN ra_customer_trx.purchase_order%type,
5836: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
5837: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,

Line 5834: p_printing_pending IN ra_customer_trx.printing_pending%type,

5830: p_printing_count IN ra_customer_trx.printing_count%type,
5831: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
5832: p_printing_option IN ra_customer_trx.printing_option%type,
5833: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
5834: p_printing_pending IN ra_customer_trx.printing_pending%type,
5835: p_purchase_order IN ra_customer_trx.purchase_order%type,
5836: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
5837: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
5838: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,

Line 5835: p_purchase_order IN ra_customer_trx.purchase_order%type,

5831: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
5832: p_printing_option IN ra_customer_trx.printing_option%type,
5833: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
5834: p_printing_pending IN ra_customer_trx.printing_pending%type,
5835: p_purchase_order IN ra_customer_trx.purchase_order%type,
5836: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
5837: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
5838: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
5839: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,

Line 5836: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,

5832: p_printing_option IN ra_customer_trx.printing_option%type,
5833: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
5834: p_printing_pending IN ra_customer_trx.printing_pending%type,
5835: p_purchase_order IN ra_customer_trx.purchase_order%type,
5836: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
5837: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
5838: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
5839: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
5840: p_shipment_id IN ra_customer_trx.shipment_id%type,

Line 5837: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,

5833: p_printing_original_date IN ra_customer_trx.printing_original_date%type,
5834: p_printing_pending IN ra_customer_trx.printing_pending%type,
5835: p_purchase_order IN ra_customer_trx.purchase_order%type,
5836: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
5837: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
5838: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
5839: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
5840: p_shipment_id IN ra_customer_trx.shipment_id%type,
5841: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,

Line 5838: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,

5834: p_printing_pending IN ra_customer_trx.printing_pending%type,
5835: p_purchase_order IN ra_customer_trx.purchase_order%type,
5836: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
5837: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
5838: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
5839: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
5840: p_shipment_id IN ra_customer_trx.shipment_id%type,
5841: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
5842: p_ship_via IN ra_customer_trx.ship_via%type,

Line 5839: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,

5835: p_purchase_order IN ra_customer_trx.purchase_order%type,
5836: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
5837: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
5838: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
5839: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
5840: p_shipment_id IN ra_customer_trx.shipment_id%type,
5841: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
5842: p_ship_via IN ra_customer_trx.ship_via%type,
5843: p_term_due_date IN ra_customer_trx.term_due_date%type,

Line 5840: p_shipment_id IN ra_customer_trx.shipment_id%type,

5836: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
5837: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
5838: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
5839: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
5840: p_shipment_id IN ra_customer_trx.shipment_id%type,
5841: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
5842: p_ship_via IN ra_customer_trx.ship_via%type,
5843: p_term_due_date IN ra_customer_trx.term_due_date%type,
5844: p_term_id IN ra_customer_trx.term_id%type,

Line 5841: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,

5837: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
5838: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
5839: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
5840: p_shipment_id IN ra_customer_trx.shipment_id%type,
5841: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
5842: p_ship_via IN ra_customer_trx.ship_via%type,
5843: p_term_due_date IN ra_customer_trx.term_due_date%type,
5844: p_term_id IN ra_customer_trx.term_id%type,
5845: p_territory_id IN ra_customer_trx.territory_id%type,

Line 5842: p_ship_via IN ra_customer_trx.ship_via%type,

5838: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
5839: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
5840: p_shipment_id IN ra_customer_trx.shipment_id%type,
5841: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
5842: p_ship_via IN ra_customer_trx.ship_via%type,
5843: p_term_due_date IN ra_customer_trx.term_due_date%type,
5844: p_term_id IN ra_customer_trx.term_id%type,
5845: p_territory_id IN ra_customer_trx.territory_id%type,
5846: p_waybill_number IN ra_customer_trx.waybill_number%type,

Line 5843: p_term_due_date IN ra_customer_trx.term_due_date%type,

5839: p_remit_to_address_id IN ra_customer_trx.remit_to_address_id%type,
5840: p_shipment_id IN ra_customer_trx.shipment_id%type,
5841: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
5842: p_ship_via IN ra_customer_trx.ship_via%type,
5843: p_term_due_date IN ra_customer_trx.term_due_date%type,
5844: p_term_id IN ra_customer_trx.term_id%type,
5845: p_territory_id IN ra_customer_trx.territory_id%type,
5846: p_waybill_number IN ra_customer_trx.waybill_number%type,
5847: p_status_trx IN ra_customer_trx.status_trx%type,

Line 5844: p_term_id IN ra_customer_trx.term_id%type,

5840: p_shipment_id IN ra_customer_trx.shipment_id%type,
5841: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
5842: p_ship_via IN ra_customer_trx.ship_via%type,
5843: p_term_due_date IN ra_customer_trx.term_due_date%type,
5844: p_term_id IN ra_customer_trx.term_id%type,
5845: p_territory_id IN ra_customer_trx.territory_id%type,
5846: p_waybill_number IN ra_customer_trx.waybill_number%type,
5847: p_status_trx IN ra_customer_trx.status_trx%type,
5848: p_reason_code IN ra_customer_trx.reason_code%type,

Line 5845: p_territory_id IN ra_customer_trx.territory_id%type,

5841: p_ship_date_actual IN ra_customer_trx.ship_date_actual%type,
5842: p_ship_via IN ra_customer_trx.ship_via%type,
5843: p_term_due_date IN ra_customer_trx.term_due_date%type,
5844: p_term_id IN ra_customer_trx.term_id%type,
5845: p_territory_id IN ra_customer_trx.territory_id%type,
5846: p_waybill_number IN ra_customer_trx.waybill_number%type,
5847: p_status_trx IN ra_customer_trx.status_trx%type,
5848: p_reason_code IN ra_customer_trx.reason_code%type,
5849: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,

Line 5846: p_waybill_number IN ra_customer_trx.waybill_number%type,

5842: p_ship_via IN ra_customer_trx.ship_via%type,
5843: p_term_due_date IN ra_customer_trx.term_due_date%type,
5844: p_term_id IN ra_customer_trx.term_id%type,
5845: p_territory_id IN ra_customer_trx.territory_id%type,
5846: p_waybill_number IN ra_customer_trx.waybill_number%type,
5847: p_status_trx IN ra_customer_trx.status_trx%type,
5848: p_reason_code IN ra_customer_trx.reason_code%type,
5849: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
5850: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,

Line 5847: p_status_trx IN ra_customer_trx.status_trx%type,

5843: p_term_due_date IN ra_customer_trx.term_due_date%type,
5844: p_term_id IN ra_customer_trx.term_id%type,
5845: p_territory_id IN ra_customer_trx.territory_id%type,
5846: p_waybill_number IN ra_customer_trx.waybill_number%type,
5847: p_status_trx IN ra_customer_trx.status_trx%type,
5848: p_reason_code IN ra_customer_trx.reason_code%type,
5849: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
5850: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
5851: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,

Line 5848: p_reason_code IN ra_customer_trx.reason_code%type,

5844: p_term_id IN ra_customer_trx.term_id%type,
5845: p_territory_id IN ra_customer_trx.territory_id%type,
5846: p_waybill_number IN ra_customer_trx.waybill_number%type,
5847: p_status_trx IN ra_customer_trx.status_trx%type,
5848: p_reason_code IN ra_customer_trx.reason_code%type,
5849: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
5850: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
5851: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
5852: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,

Line 5849: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,

5845: p_territory_id IN ra_customer_trx.territory_id%type,
5846: p_waybill_number IN ra_customer_trx.waybill_number%type,
5847: p_status_trx IN ra_customer_trx.status_trx%type,
5848: p_reason_code IN ra_customer_trx.reason_code%type,
5849: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
5850: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
5851: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
5852: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
5853: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,

Line 5850: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,

5846: p_waybill_number IN ra_customer_trx.waybill_number%type,
5847: p_status_trx IN ra_customer_trx.status_trx%type,
5848: p_reason_code IN ra_customer_trx.reason_code%type,
5849: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
5850: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
5851: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
5852: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
5853: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
5854: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,

Line 5851: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,

5847: p_status_trx IN ra_customer_trx.status_trx%type,
5848: p_reason_code IN ra_customer_trx.reason_code%type,
5849: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
5850: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
5851: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
5852: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
5853: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
5854: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,
5855: p_created_from IN ra_customer_trx.created_from%type,

Line 5852: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,

5848: p_reason_code IN ra_customer_trx.reason_code%type,
5849: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
5850: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
5851: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
5852: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
5853: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
5854: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,
5855: p_created_from IN ra_customer_trx.created_from%type,
5856: p_deflt_ussgl_trx_code_context IN

Line 5853: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,

5849: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
5850: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
5851: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
5852: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
5853: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
5854: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,
5855: p_created_from IN ra_customer_trx.created_from%type,
5856: p_deflt_ussgl_trx_code_context IN
5857: ra_customer_trx.default_ussgl_trx_code_context%type,

Line 5854: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,

5850: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
5851: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
5852: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
5853: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
5854: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,
5855: p_created_from IN ra_customer_trx.created_from%type,
5856: p_deflt_ussgl_trx_code_context IN
5857: ra_customer_trx.default_ussgl_trx_code_context%type,
5858: p_deflt_ussgl_transaction_code IN

Line 5855: p_created_from IN ra_customer_trx.created_from%type,

5851: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
5852: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
5853: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
5854: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,
5855: p_created_from IN ra_customer_trx.created_from%type,
5856: p_deflt_ussgl_trx_code_context IN
5857: ra_customer_trx.default_ussgl_trx_code_context%type,
5858: p_deflt_ussgl_transaction_code IN
5859: ra_customer_trx.default_ussgl_transaction_code%type,

Line 5857: ra_customer_trx.default_ussgl_trx_code_context%type,

5853: p_related_batch_source_id IN ra_customer_trx.related_batch_source_id%type,
5854: p_default_tax_exempt_flag IN ra_customer_trx.default_tax_exempt_flag%type,
5855: p_created_from IN ra_customer_trx.created_from%type,
5856: p_deflt_ussgl_trx_code_context IN
5857: ra_customer_trx.default_ussgl_trx_code_context%type,
5858: p_deflt_ussgl_transaction_code IN
5859: ra_customer_trx.default_ussgl_transaction_code%type,
5860: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
5861: p_interface_header_context IN

Line 5859: ra_customer_trx.default_ussgl_transaction_code%type,

5855: p_created_from IN ra_customer_trx.created_from%type,
5856: p_deflt_ussgl_trx_code_context IN
5857: ra_customer_trx.default_ussgl_trx_code_context%type,
5858: p_deflt_ussgl_transaction_code IN
5859: ra_customer_trx.default_ussgl_transaction_code%type,
5860: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
5861: p_interface_header_context IN
5862: ra_customer_trx.interface_header_context%type,
5863: p_interface_header_attribute1 IN

Line 5860: p_old_trx_number IN ra_customer_trx.old_trx_number%type,

5856: p_deflt_ussgl_trx_code_context IN
5857: ra_customer_trx.default_ussgl_trx_code_context%type,
5858: p_deflt_ussgl_transaction_code IN
5859: ra_customer_trx.default_ussgl_transaction_code%type,
5860: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
5861: p_interface_header_context IN
5862: ra_customer_trx.interface_header_context%type,
5863: p_interface_header_attribute1 IN
5864: ra_customer_trx.interface_header_attribute1%type,

Line 5862: ra_customer_trx.interface_header_context%type,

5858: p_deflt_ussgl_transaction_code IN
5859: ra_customer_trx.default_ussgl_transaction_code%type,
5860: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
5861: p_interface_header_context IN
5862: ra_customer_trx.interface_header_context%type,
5863: p_interface_header_attribute1 IN
5864: ra_customer_trx.interface_header_attribute1%type,
5865: p_interface_header_attribute2 IN
5866: ra_customer_trx.interface_header_attribute2%type,

Line 5864: ra_customer_trx.interface_header_attribute1%type,

5860: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
5861: p_interface_header_context IN
5862: ra_customer_trx.interface_header_context%type,
5863: p_interface_header_attribute1 IN
5864: ra_customer_trx.interface_header_attribute1%type,
5865: p_interface_header_attribute2 IN
5866: ra_customer_trx.interface_header_attribute2%type,
5867: p_interface_header_attribute3 IN
5868: ra_customer_trx.interface_header_attribute3%type,

Line 5866: ra_customer_trx.interface_header_attribute2%type,

5862: ra_customer_trx.interface_header_context%type,
5863: p_interface_header_attribute1 IN
5864: ra_customer_trx.interface_header_attribute1%type,
5865: p_interface_header_attribute2 IN
5866: ra_customer_trx.interface_header_attribute2%type,
5867: p_interface_header_attribute3 IN
5868: ra_customer_trx.interface_header_attribute3%type,
5869: p_interface_header_attribute4 IN
5870: ra_customer_trx.interface_header_attribute4%type,

Line 5868: ra_customer_trx.interface_header_attribute3%type,

5864: ra_customer_trx.interface_header_attribute1%type,
5865: p_interface_header_attribute2 IN
5866: ra_customer_trx.interface_header_attribute2%type,
5867: p_interface_header_attribute3 IN
5868: ra_customer_trx.interface_header_attribute3%type,
5869: p_interface_header_attribute4 IN
5870: ra_customer_trx.interface_header_attribute4%type,
5871: p_interface_header_attribute5 IN
5872: ra_customer_trx.interface_header_attribute5%type,

Line 5870: ra_customer_trx.interface_header_attribute4%type,

5866: ra_customer_trx.interface_header_attribute2%type,
5867: p_interface_header_attribute3 IN
5868: ra_customer_trx.interface_header_attribute3%type,
5869: p_interface_header_attribute4 IN
5870: ra_customer_trx.interface_header_attribute4%type,
5871: p_interface_header_attribute5 IN
5872: ra_customer_trx.interface_header_attribute5%type,
5873: p_interface_header_attribute6 IN
5874: ra_customer_trx.interface_header_attribute6%type,

Line 5872: ra_customer_trx.interface_header_attribute5%type,

5868: ra_customer_trx.interface_header_attribute3%type,
5869: p_interface_header_attribute4 IN
5870: ra_customer_trx.interface_header_attribute4%type,
5871: p_interface_header_attribute5 IN
5872: ra_customer_trx.interface_header_attribute5%type,
5873: p_interface_header_attribute6 IN
5874: ra_customer_trx.interface_header_attribute6%type,
5875: p_interface_header_attribute7 IN
5876: ra_customer_trx.interface_header_attribute7%type,

Line 5874: ra_customer_trx.interface_header_attribute6%type,

5870: ra_customer_trx.interface_header_attribute4%type,
5871: p_interface_header_attribute5 IN
5872: ra_customer_trx.interface_header_attribute5%type,
5873: p_interface_header_attribute6 IN
5874: ra_customer_trx.interface_header_attribute6%type,
5875: p_interface_header_attribute7 IN
5876: ra_customer_trx.interface_header_attribute7%type,
5877: p_interface_header_attribute8 IN
5878: ra_customer_trx.interface_header_attribute8%type,

Line 5876: ra_customer_trx.interface_header_attribute7%type,

5872: ra_customer_trx.interface_header_attribute5%type,
5873: p_interface_header_attribute6 IN
5874: ra_customer_trx.interface_header_attribute6%type,
5875: p_interface_header_attribute7 IN
5876: ra_customer_trx.interface_header_attribute7%type,
5877: p_interface_header_attribute8 IN
5878: ra_customer_trx.interface_header_attribute8%type,
5879: p_interface_header_attribute9 IN
5880: ra_customer_trx.interface_header_attribute9%type,

Line 5878: ra_customer_trx.interface_header_attribute8%type,

5874: ra_customer_trx.interface_header_attribute6%type,
5875: p_interface_header_attribute7 IN
5876: ra_customer_trx.interface_header_attribute7%type,
5877: p_interface_header_attribute8 IN
5878: ra_customer_trx.interface_header_attribute8%type,
5879: p_interface_header_attribute9 IN
5880: ra_customer_trx.interface_header_attribute9%type,
5881: p_interface_header_attribute10 IN
5882: ra_customer_trx.interface_header_attribute10%type,

Line 5880: ra_customer_trx.interface_header_attribute9%type,

5876: ra_customer_trx.interface_header_attribute7%type,
5877: p_interface_header_attribute8 IN
5878: ra_customer_trx.interface_header_attribute8%type,
5879: p_interface_header_attribute9 IN
5880: ra_customer_trx.interface_header_attribute9%type,
5881: p_interface_header_attribute10 IN
5882: ra_customer_trx.interface_header_attribute10%type,
5883: p_interface_header_attribute11 IN
5884: ra_customer_trx.interface_header_attribute11%type,

Line 5882: ra_customer_trx.interface_header_attribute10%type,

5878: ra_customer_trx.interface_header_attribute8%type,
5879: p_interface_header_attribute9 IN
5880: ra_customer_trx.interface_header_attribute9%type,
5881: p_interface_header_attribute10 IN
5882: ra_customer_trx.interface_header_attribute10%type,
5883: p_interface_header_attribute11 IN
5884: ra_customer_trx.interface_header_attribute11%type,
5885: p_interface_header_attribute12 IN
5886: ra_customer_trx.interface_header_attribute12%type,

Line 5884: ra_customer_trx.interface_header_attribute11%type,

5880: ra_customer_trx.interface_header_attribute9%type,
5881: p_interface_header_attribute10 IN
5882: ra_customer_trx.interface_header_attribute10%type,
5883: p_interface_header_attribute11 IN
5884: ra_customer_trx.interface_header_attribute11%type,
5885: p_interface_header_attribute12 IN
5886: ra_customer_trx.interface_header_attribute12%type,
5887: p_interface_header_attribute13 IN
5888: ra_customer_trx.interface_header_attribute13%type,

Line 5886: ra_customer_trx.interface_header_attribute12%type,

5882: ra_customer_trx.interface_header_attribute10%type,
5883: p_interface_header_attribute11 IN
5884: ra_customer_trx.interface_header_attribute11%type,
5885: p_interface_header_attribute12 IN
5886: ra_customer_trx.interface_header_attribute12%type,
5887: p_interface_header_attribute13 IN
5888: ra_customer_trx.interface_header_attribute13%type,
5889: p_interface_header_attribute14 IN
5890: ra_customer_trx.interface_header_attribute14%type,

Line 5888: ra_customer_trx.interface_header_attribute13%type,

5884: ra_customer_trx.interface_header_attribute11%type,
5885: p_interface_header_attribute12 IN
5886: ra_customer_trx.interface_header_attribute12%type,
5887: p_interface_header_attribute13 IN
5888: ra_customer_trx.interface_header_attribute13%type,
5889: p_interface_header_attribute14 IN
5890: ra_customer_trx.interface_header_attribute14%type,
5891: p_interface_header_attribute15 IN
5892: ra_customer_trx.interface_header_attribute15%type,

Line 5890: ra_customer_trx.interface_header_attribute14%type,

5886: ra_customer_trx.interface_header_attribute12%type,
5887: p_interface_header_attribute13 IN
5888: ra_customer_trx.interface_header_attribute13%type,
5889: p_interface_header_attribute14 IN
5890: ra_customer_trx.interface_header_attribute14%type,
5891: p_interface_header_attribute15 IN
5892: ra_customer_trx.interface_header_attribute15%type,
5893: p_attribute_category IN ra_customer_trx.attribute_category%type,
5894: p_attribute1 IN ra_customer_trx.attribute1%type,

Line 5892: ra_customer_trx.interface_header_attribute15%type,

5888: ra_customer_trx.interface_header_attribute13%type,
5889: p_interface_header_attribute14 IN
5890: ra_customer_trx.interface_header_attribute14%type,
5891: p_interface_header_attribute15 IN
5892: ra_customer_trx.interface_header_attribute15%type,
5893: p_attribute_category IN ra_customer_trx.attribute_category%type,
5894: p_attribute1 IN ra_customer_trx.attribute1%type,
5895: p_attribute2 IN ra_customer_trx.attribute2%type,
5896: p_attribute3 IN ra_customer_trx.attribute3%type,

Line 5893: p_attribute_category IN ra_customer_trx.attribute_category%type,

5889: p_interface_header_attribute14 IN
5890: ra_customer_trx.interface_header_attribute14%type,
5891: p_interface_header_attribute15 IN
5892: ra_customer_trx.interface_header_attribute15%type,
5893: p_attribute_category IN ra_customer_trx.attribute_category%type,
5894: p_attribute1 IN ra_customer_trx.attribute1%type,
5895: p_attribute2 IN ra_customer_trx.attribute2%type,
5896: p_attribute3 IN ra_customer_trx.attribute3%type,
5897: p_attribute4 IN ra_customer_trx.attribute4%type,

Line 5894: p_attribute1 IN ra_customer_trx.attribute1%type,

5890: ra_customer_trx.interface_header_attribute14%type,
5891: p_interface_header_attribute15 IN
5892: ra_customer_trx.interface_header_attribute15%type,
5893: p_attribute_category IN ra_customer_trx.attribute_category%type,
5894: p_attribute1 IN ra_customer_trx.attribute1%type,
5895: p_attribute2 IN ra_customer_trx.attribute2%type,
5896: p_attribute3 IN ra_customer_trx.attribute3%type,
5897: p_attribute4 IN ra_customer_trx.attribute4%type,
5898: p_attribute5 IN ra_customer_trx.attribute5%type,

Line 5895: p_attribute2 IN ra_customer_trx.attribute2%type,

5891: p_interface_header_attribute15 IN
5892: ra_customer_trx.interface_header_attribute15%type,
5893: p_attribute_category IN ra_customer_trx.attribute_category%type,
5894: p_attribute1 IN ra_customer_trx.attribute1%type,
5895: p_attribute2 IN ra_customer_trx.attribute2%type,
5896: p_attribute3 IN ra_customer_trx.attribute3%type,
5897: p_attribute4 IN ra_customer_trx.attribute4%type,
5898: p_attribute5 IN ra_customer_trx.attribute5%type,
5899: p_attribute6 IN ra_customer_trx.attribute6%type,

Line 5896: p_attribute3 IN ra_customer_trx.attribute3%type,

5892: ra_customer_trx.interface_header_attribute15%type,
5893: p_attribute_category IN ra_customer_trx.attribute_category%type,
5894: p_attribute1 IN ra_customer_trx.attribute1%type,
5895: p_attribute2 IN ra_customer_trx.attribute2%type,
5896: p_attribute3 IN ra_customer_trx.attribute3%type,
5897: p_attribute4 IN ra_customer_trx.attribute4%type,
5898: p_attribute5 IN ra_customer_trx.attribute5%type,
5899: p_attribute6 IN ra_customer_trx.attribute6%type,
5900: p_attribute7 IN ra_customer_trx.attribute7%type,

Line 5897: p_attribute4 IN ra_customer_trx.attribute4%type,

5893: p_attribute_category IN ra_customer_trx.attribute_category%type,
5894: p_attribute1 IN ra_customer_trx.attribute1%type,
5895: p_attribute2 IN ra_customer_trx.attribute2%type,
5896: p_attribute3 IN ra_customer_trx.attribute3%type,
5897: p_attribute4 IN ra_customer_trx.attribute4%type,
5898: p_attribute5 IN ra_customer_trx.attribute5%type,
5899: p_attribute6 IN ra_customer_trx.attribute6%type,
5900: p_attribute7 IN ra_customer_trx.attribute7%type,
5901: p_attribute8 IN ra_customer_trx.attribute8%type,

Line 5898: p_attribute5 IN ra_customer_trx.attribute5%type,

5894: p_attribute1 IN ra_customer_trx.attribute1%type,
5895: p_attribute2 IN ra_customer_trx.attribute2%type,
5896: p_attribute3 IN ra_customer_trx.attribute3%type,
5897: p_attribute4 IN ra_customer_trx.attribute4%type,
5898: p_attribute5 IN ra_customer_trx.attribute5%type,
5899: p_attribute6 IN ra_customer_trx.attribute6%type,
5900: p_attribute7 IN ra_customer_trx.attribute7%type,
5901: p_attribute8 IN ra_customer_trx.attribute8%type,
5902: p_attribute9 IN ra_customer_trx.attribute9%type,

Line 5899: p_attribute6 IN ra_customer_trx.attribute6%type,

5895: p_attribute2 IN ra_customer_trx.attribute2%type,
5896: p_attribute3 IN ra_customer_trx.attribute3%type,
5897: p_attribute4 IN ra_customer_trx.attribute4%type,
5898: p_attribute5 IN ra_customer_trx.attribute5%type,
5899: p_attribute6 IN ra_customer_trx.attribute6%type,
5900: p_attribute7 IN ra_customer_trx.attribute7%type,
5901: p_attribute8 IN ra_customer_trx.attribute8%type,
5902: p_attribute9 IN ra_customer_trx.attribute9%type,
5903: p_attribute10 IN ra_customer_trx.attribute10%type,

Line 5900: p_attribute7 IN ra_customer_trx.attribute7%type,

5896: p_attribute3 IN ra_customer_trx.attribute3%type,
5897: p_attribute4 IN ra_customer_trx.attribute4%type,
5898: p_attribute5 IN ra_customer_trx.attribute5%type,
5899: p_attribute6 IN ra_customer_trx.attribute6%type,
5900: p_attribute7 IN ra_customer_trx.attribute7%type,
5901: p_attribute8 IN ra_customer_trx.attribute8%type,
5902: p_attribute9 IN ra_customer_trx.attribute9%type,
5903: p_attribute10 IN ra_customer_trx.attribute10%type,
5904: p_attribute11 IN ra_customer_trx.attribute11%type,

Line 5901: p_attribute8 IN ra_customer_trx.attribute8%type,

5897: p_attribute4 IN ra_customer_trx.attribute4%type,
5898: p_attribute5 IN ra_customer_trx.attribute5%type,
5899: p_attribute6 IN ra_customer_trx.attribute6%type,
5900: p_attribute7 IN ra_customer_trx.attribute7%type,
5901: p_attribute8 IN ra_customer_trx.attribute8%type,
5902: p_attribute9 IN ra_customer_trx.attribute9%type,
5903: p_attribute10 IN ra_customer_trx.attribute10%type,
5904: p_attribute11 IN ra_customer_trx.attribute11%type,
5905: p_attribute12 IN ra_customer_trx.attribute12%type,

Line 5902: p_attribute9 IN ra_customer_trx.attribute9%type,

5898: p_attribute5 IN ra_customer_trx.attribute5%type,
5899: p_attribute6 IN ra_customer_trx.attribute6%type,
5900: p_attribute7 IN ra_customer_trx.attribute7%type,
5901: p_attribute8 IN ra_customer_trx.attribute8%type,
5902: p_attribute9 IN ra_customer_trx.attribute9%type,
5903: p_attribute10 IN ra_customer_trx.attribute10%type,
5904: p_attribute11 IN ra_customer_trx.attribute11%type,
5905: p_attribute12 IN ra_customer_trx.attribute12%type,
5906: p_attribute13 IN ra_customer_trx.attribute13%type,

Line 5903: p_attribute10 IN ra_customer_trx.attribute10%type,

5899: p_attribute6 IN ra_customer_trx.attribute6%type,
5900: p_attribute7 IN ra_customer_trx.attribute7%type,
5901: p_attribute8 IN ra_customer_trx.attribute8%type,
5902: p_attribute9 IN ra_customer_trx.attribute9%type,
5903: p_attribute10 IN ra_customer_trx.attribute10%type,
5904: p_attribute11 IN ra_customer_trx.attribute11%type,
5905: p_attribute12 IN ra_customer_trx.attribute12%type,
5906: p_attribute13 IN ra_customer_trx.attribute13%type,
5907: p_attribute14 IN ra_customer_trx.attribute14%type,

Line 5904: p_attribute11 IN ra_customer_trx.attribute11%type,

5900: p_attribute7 IN ra_customer_trx.attribute7%type,
5901: p_attribute8 IN ra_customer_trx.attribute8%type,
5902: p_attribute9 IN ra_customer_trx.attribute9%type,
5903: p_attribute10 IN ra_customer_trx.attribute10%type,
5904: p_attribute11 IN ra_customer_trx.attribute11%type,
5905: p_attribute12 IN ra_customer_trx.attribute12%type,
5906: p_attribute13 IN ra_customer_trx.attribute13%type,
5907: p_attribute14 IN ra_customer_trx.attribute14%type,
5908: p_attribute15 IN ra_customer_trx.attribute15%type,

Line 5905: p_attribute12 IN ra_customer_trx.attribute12%type,

5901: p_attribute8 IN ra_customer_trx.attribute8%type,
5902: p_attribute9 IN ra_customer_trx.attribute9%type,
5903: p_attribute10 IN ra_customer_trx.attribute10%type,
5904: p_attribute11 IN ra_customer_trx.attribute11%type,
5905: p_attribute12 IN ra_customer_trx.attribute12%type,
5906: p_attribute13 IN ra_customer_trx.attribute13%type,
5907: p_attribute14 IN ra_customer_trx.attribute14%type,
5908: p_attribute15 IN ra_customer_trx.attribute15%type,
5909: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type,

Line 5906: p_attribute13 IN ra_customer_trx.attribute13%type,

5902: p_attribute9 IN ra_customer_trx.attribute9%type,
5903: p_attribute10 IN ra_customer_trx.attribute10%type,
5904: p_attribute11 IN ra_customer_trx.attribute11%type,
5905: p_attribute12 IN ra_customer_trx.attribute12%type,
5906: p_attribute13 IN ra_customer_trx.attribute13%type,
5907: p_attribute14 IN ra_customer_trx.attribute14%type,
5908: p_attribute15 IN ra_customer_trx.attribute15%type,
5909: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type,
5910: p_global_attribute1 IN ra_customer_trx.global_attribute1%type,

Line 5907: p_attribute14 IN ra_customer_trx.attribute14%type,

5903: p_attribute10 IN ra_customer_trx.attribute10%type,
5904: p_attribute11 IN ra_customer_trx.attribute11%type,
5905: p_attribute12 IN ra_customer_trx.attribute12%type,
5906: p_attribute13 IN ra_customer_trx.attribute13%type,
5907: p_attribute14 IN ra_customer_trx.attribute14%type,
5908: p_attribute15 IN ra_customer_trx.attribute15%type,
5909: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type,
5910: p_global_attribute1 IN ra_customer_trx.global_attribute1%type,
5911: p_global_attribute2 IN ra_customer_trx.global_attribute2%type,

Line 5908: p_attribute15 IN ra_customer_trx.attribute15%type,

5904: p_attribute11 IN ra_customer_trx.attribute11%type,
5905: p_attribute12 IN ra_customer_trx.attribute12%type,
5906: p_attribute13 IN ra_customer_trx.attribute13%type,
5907: p_attribute14 IN ra_customer_trx.attribute14%type,
5908: p_attribute15 IN ra_customer_trx.attribute15%type,
5909: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type,
5910: p_global_attribute1 IN ra_customer_trx.global_attribute1%type,
5911: p_global_attribute2 IN ra_customer_trx.global_attribute2%type,
5912: p_global_attribute3 IN ra_customer_trx.global_attribute3%type,

Line 5909: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type,

5905: p_attribute12 IN ra_customer_trx.attribute12%type,
5906: p_attribute13 IN ra_customer_trx.attribute13%type,
5907: p_attribute14 IN ra_customer_trx.attribute14%type,
5908: p_attribute15 IN ra_customer_trx.attribute15%type,
5909: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type,
5910: p_global_attribute1 IN ra_customer_trx.global_attribute1%type,
5911: p_global_attribute2 IN ra_customer_trx.global_attribute2%type,
5912: p_global_attribute3 IN ra_customer_trx.global_attribute3%type,
5913: p_global_attribute4 IN ra_customer_trx.global_attribute4%type,

Line 5910: p_global_attribute1 IN ra_customer_trx.global_attribute1%type,

5906: p_attribute13 IN ra_customer_trx.attribute13%type,
5907: p_attribute14 IN ra_customer_trx.attribute14%type,
5908: p_attribute15 IN ra_customer_trx.attribute15%type,
5909: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type,
5910: p_global_attribute1 IN ra_customer_trx.global_attribute1%type,
5911: p_global_attribute2 IN ra_customer_trx.global_attribute2%type,
5912: p_global_attribute3 IN ra_customer_trx.global_attribute3%type,
5913: p_global_attribute4 IN ra_customer_trx.global_attribute4%type,
5914: p_global_attribute5 IN ra_customer_trx.global_attribute5%type,

Line 5911: p_global_attribute2 IN ra_customer_trx.global_attribute2%type,

5907: p_attribute14 IN ra_customer_trx.attribute14%type,
5908: p_attribute15 IN ra_customer_trx.attribute15%type,
5909: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type,
5910: p_global_attribute1 IN ra_customer_trx.global_attribute1%type,
5911: p_global_attribute2 IN ra_customer_trx.global_attribute2%type,
5912: p_global_attribute3 IN ra_customer_trx.global_attribute3%type,
5913: p_global_attribute4 IN ra_customer_trx.global_attribute4%type,
5914: p_global_attribute5 IN ra_customer_trx.global_attribute5%type,
5915: p_global_attribute6 IN ra_customer_trx.global_attribute6%type,

Line 5912: p_global_attribute3 IN ra_customer_trx.global_attribute3%type,

5908: p_attribute15 IN ra_customer_trx.attribute15%type,
5909: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type,
5910: p_global_attribute1 IN ra_customer_trx.global_attribute1%type,
5911: p_global_attribute2 IN ra_customer_trx.global_attribute2%type,
5912: p_global_attribute3 IN ra_customer_trx.global_attribute3%type,
5913: p_global_attribute4 IN ra_customer_trx.global_attribute4%type,
5914: p_global_attribute5 IN ra_customer_trx.global_attribute5%type,
5915: p_global_attribute6 IN ra_customer_trx.global_attribute6%type,
5916: p_global_attribute7 IN ra_customer_trx.global_attribute7%type,

Line 5913: p_global_attribute4 IN ra_customer_trx.global_attribute4%type,

5909: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type,
5910: p_global_attribute1 IN ra_customer_trx.global_attribute1%type,
5911: p_global_attribute2 IN ra_customer_trx.global_attribute2%type,
5912: p_global_attribute3 IN ra_customer_trx.global_attribute3%type,
5913: p_global_attribute4 IN ra_customer_trx.global_attribute4%type,
5914: p_global_attribute5 IN ra_customer_trx.global_attribute5%type,
5915: p_global_attribute6 IN ra_customer_trx.global_attribute6%type,
5916: p_global_attribute7 IN ra_customer_trx.global_attribute7%type,
5917: p_global_attribute8 IN ra_customer_trx.global_attribute8%type,

Line 5914: p_global_attribute5 IN ra_customer_trx.global_attribute5%type,

5910: p_global_attribute1 IN ra_customer_trx.global_attribute1%type,
5911: p_global_attribute2 IN ra_customer_trx.global_attribute2%type,
5912: p_global_attribute3 IN ra_customer_trx.global_attribute3%type,
5913: p_global_attribute4 IN ra_customer_trx.global_attribute4%type,
5914: p_global_attribute5 IN ra_customer_trx.global_attribute5%type,
5915: p_global_attribute6 IN ra_customer_trx.global_attribute6%type,
5916: p_global_attribute7 IN ra_customer_trx.global_attribute7%type,
5917: p_global_attribute8 IN ra_customer_trx.global_attribute8%type,
5918: p_global_attribute9 IN ra_customer_trx.global_attribute9%type,

Line 5915: p_global_attribute6 IN ra_customer_trx.global_attribute6%type,

5911: p_global_attribute2 IN ra_customer_trx.global_attribute2%type,
5912: p_global_attribute3 IN ra_customer_trx.global_attribute3%type,
5913: p_global_attribute4 IN ra_customer_trx.global_attribute4%type,
5914: p_global_attribute5 IN ra_customer_trx.global_attribute5%type,
5915: p_global_attribute6 IN ra_customer_trx.global_attribute6%type,
5916: p_global_attribute7 IN ra_customer_trx.global_attribute7%type,
5917: p_global_attribute8 IN ra_customer_trx.global_attribute8%type,
5918: p_global_attribute9 IN ra_customer_trx.global_attribute9%type,
5919: p_global_attribute10 IN ra_customer_trx.global_attribute10%type,

Line 5916: p_global_attribute7 IN ra_customer_trx.global_attribute7%type,

5912: p_global_attribute3 IN ra_customer_trx.global_attribute3%type,
5913: p_global_attribute4 IN ra_customer_trx.global_attribute4%type,
5914: p_global_attribute5 IN ra_customer_trx.global_attribute5%type,
5915: p_global_attribute6 IN ra_customer_trx.global_attribute6%type,
5916: p_global_attribute7 IN ra_customer_trx.global_attribute7%type,
5917: p_global_attribute8 IN ra_customer_trx.global_attribute8%type,
5918: p_global_attribute9 IN ra_customer_trx.global_attribute9%type,
5919: p_global_attribute10 IN ra_customer_trx.global_attribute10%type,
5920: p_global_attribute11 IN ra_customer_trx.global_attribute11%type,

Line 5917: p_global_attribute8 IN ra_customer_trx.global_attribute8%type,

5913: p_global_attribute4 IN ra_customer_trx.global_attribute4%type,
5914: p_global_attribute5 IN ra_customer_trx.global_attribute5%type,
5915: p_global_attribute6 IN ra_customer_trx.global_attribute6%type,
5916: p_global_attribute7 IN ra_customer_trx.global_attribute7%type,
5917: p_global_attribute8 IN ra_customer_trx.global_attribute8%type,
5918: p_global_attribute9 IN ra_customer_trx.global_attribute9%type,
5919: p_global_attribute10 IN ra_customer_trx.global_attribute10%type,
5920: p_global_attribute11 IN ra_customer_trx.global_attribute11%type,
5921: p_global_attribute12 IN ra_customer_trx.global_attribute12%type,

Line 5918: p_global_attribute9 IN ra_customer_trx.global_attribute9%type,

5914: p_global_attribute5 IN ra_customer_trx.global_attribute5%type,
5915: p_global_attribute6 IN ra_customer_trx.global_attribute6%type,
5916: p_global_attribute7 IN ra_customer_trx.global_attribute7%type,
5917: p_global_attribute8 IN ra_customer_trx.global_attribute8%type,
5918: p_global_attribute9 IN ra_customer_trx.global_attribute9%type,
5919: p_global_attribute10 IN ra_customer_trx.global_attribute10%type,
5920: p_global_attribute11 IN ra_customer_trx.global_attribute11%type,
5921: p_global_attribute12 IN ra_customer_trx.global_attribute12%type,
5922: p_global_attribute13 IN ra_customer_trx.global_attribute13%type,

Line 5919: p_global_attribute10 IN ra_customer_trx.global_attribute10%type,

5915: p_global_attribute6 IN ra_customer_trx.global_attribute6%type,
5916: p_global_attribute7 IN ra_customer_trx.global_attribute7%type,
5917: p_global_attribute8 IN ra_customer_trx.global_attribute8%type,
5918: p_global_attribute9 IN ra_customer_trx.global_attribute9%type,
5919: p_global_attribute10 IN ra_customer_trx.global_attribute10%type,
5920: p_global_attribute11 IN ra_customer_trx.global_attribute11%type,
5921: p_global_attribute12 IN ra_customer_trx.global_attribute12%type,
5922: p_global_attribute13 IN ra_customer_trx.global_attribute13%type,
5923: p_global_attribute14 IN ra_customer_trx.global_attribute14%type,

Line 5920: p_global_attribute11 IN ra_customer_trx.global_attribute11%type,

5916: p_global_attribute7 IN ra_customer_trx.global_attribute7%type,
5917: p_global_attribute8 IN ra_customer_trx.global_attribute8%type,
5918: p_global_attribute9 IN ra_customer_trx.global_attribute9%type,
5919: p_global_attribute10 IN ra_customer_trx.global_attribute10%type,
5920: p_global_attribute11 IN ra_customer_trx.global_attribute11%type,
5921: p_global_attribute12 IN ra_customer_trx.global_attribute12%type,
5922: p_global_attribute13 IN ra_customer_trx.global_attribute13%type,
5923: p_global_attribute14 IN ra_customer_trx.global_attribute14%type,
5924: p_global_attribute15 IN ra_customer_trx.global_attribute15%type,

Line 5921: p_global_attribute12 IN ra_customer_trx.global_attribute12%type,

5917: p_global_attribute8 IN ra_customer_trx.global_attribute8%type,
5918: p_global_attribute9 IN ra_customer_trx.global_attribute9%type,
5919: p_global_attribute10 IN ra_customer_trx.global_attribute10%type,
5920: p_global_attribute11 IN ra_customer_trx.global_attribute11%type,
5921: p_global_attribute12 IN ra_customer_trx.global_attribute12%type,
5922: p_global_attribute13 IN ra_customer_trx.global_attribute13%type,
5923: p_global_attribute14 IN ra_customer_trx.global_attribute14%type,
5924: p_global_attribute15 IN ra_customer_trx.global_attribute15%type,
5925: p_global_attribute16 IN ra_customer_trx.global_attribute16%type,

Line 5922: p_global_attribute13 IN ra_customer_trx.global_attribute13%type,

5918: p_global_attribute9 IN ra_customer_trx.global_attribute9%type,
5919: p_global_attribute10 IN ra_customer_trx.global_attribute10%type,
5920: p_global_attribute11 IN ra_customer_trx.global_attribute11%type,
5921: p_global_attribute12 IN ra_customer_trx.global_attribute12%type,
5922: p_global_attribute13 IN ra_customer_trx.global_attribute13%type,
5923: p_global_attribute14 IN ra_customer_trx.global_attribute14%type,
5924: p_global_attribute15 IN ra_customer_trx.global_attribute15%type,
5925: p_global_attribute16 IN ra_customer_trx.global_attribute16%type,
5926: p_global_attribute17 IN ra_customer_trx.global_attribute17%type,

Line 5923: p_global_attribute14 IN ra_customer_trx.global_attribute14%type,

5919: p_global_attribute10 IN ra_customer_trx.global_attribute10%type,
5920: p_global_attribute11 IN ra_customer_trx.global_attribute11%type,
5921: p_global_attribute12 IN ra_customer_trx.global_attribute12%type,
5922: p_global_attribute13 IN ra_customer_trx.global_attribute13%type,
5923: p_global_attribute14 IN ra_customer_trx.global_attribute14%type,
5924: p_global_attribute15 IN ra_customer_trx.global_attribute15%type,
5925: p_global_attribute16 IN ra_customer_trx.global_attribute16%type,
5926: p_global_attribute17 IN ra_customer_trx.global_attribute17%type,
5927: p_global_attribute18 IN ra_customer_trx.global_attribute18%type,

Line 5924: p_global_attribute15 IN ra_customer_trx.global_attribute15%type,

5920: p_global_attribute11 IN ra_customer_trx.global_attribute11%type,
5921: p_global_attribute12 IN ra_customer_trx.global_attribute12%type,
5922: p_global_attribute13 IN ra_customer_trx.global_attribute13%type,
5923: p_global_attribute14 IN ra_customer_trx.global_attribute14%type,
5924: p_global_attribute15 IN ra_customer_trx.global_attribute15%type,
5925: p_global_attribute16 IN ra_customer_trx.global_attribute16%type,
5926: p_global_attribute17 IN ra_customer_trx.global_attribute17%type,
5927: p_global_attribute18 IN ra_customer_trx.global_attribute18%type,
5928: p_global_attribute19 IN ra_customer_trx.global_attribute19%type,

Line 5925: p_global_attribute16 IN ra_customer_trx.global_attribute16%type,

5921: p_global_attribute12 IN ra_customer_trx.global_attribute12%type,
5922: p_global_attribute13 IN ra_customer_trx.global_attribute13%type,
5923: p_global_attribute14 IN ra_customer_trx.global_attribute14%type,
5924: p_global_attribute15 IN ra_customer_trx.global_attribute15%type,
5925: p_global_attribute16 IN ra_customer_trx.global_attribute16%type,
5926: p_global_attribute17 IN ra_customer_trx.global_attribute17%type,
5927: p_global_attribute18 IN ra_customer_trx.global_attribute18%type,
5928: p_global_attribute19 IN ra_customer_trx.global_attribute19%type,
5929: p_global_attribute20 IN ra_customer_trx.global_attribute20%type,

Line 5926: p_global_attribute17 IN ra_customer_trx.global_attribute17%type,

5922: p_global_attribute13 IN ra_customer_trx.global_attribute13%type,
5923: p_global_attribute14 IN ra_customer_trx.global_attribute14%type,
5924: p_global_attribute15 IN ra_customer_trx.global_attribute15%type,
5925: p_global_attribute16 IN ra_customer_trx.global_attribute16%type,
5926: p_global_attribute17 IN ra_customer_trx.global_attribute17%type,
5927: p_global_attribute18 IN ra_customer_trx.global_attribute18%type,
5928: p_global_attribute19 IN ra_customer_trx.global_attribute19%type,
5929: p_global_attribute20 IN ra_customer_trx.global_attribute20%type,
5930: p_global_attribute21 IN ra_customer_trx.global_attribute21%type,

Line 5927: p_global_attribute18 IN ra_customer_trx.global_attribute18%type,

5923: p_global_attribute14 IN ra_customer_trx.global_attribute14%type,
5924: p_global_attribute15 IN ra_customer_trx.global_attribute15%type,
5925: p_global_attribute16 IN ra_customer_trx.global_attribute16%type,
5926: p_global_attribute17 IN ra_customer_trx.global_attribute17%type,
5927: p_global_attribute18 IN ra_customer_trx.global_attribute18%type,
5928: p_global_attribute19 IN ra_customer_trx.global_attribute19%type,
5929: p_global_attribute20 IN ra_customer_trx.global_attribute20%type,
5930: p_global_attribute21 IN ra_customer_trx.global_attribute21%type,
5931: p_global_attribute22 IN ra_customer_trx.global_attribute22%type,

Line 5928: p_global_attribute19 IN ra_customer_trx.global_attribute19%type,

5924: p_global_attribute15 IN ra_customer_trx.global_attribute15%type,
5925: p_global_attribute16 IN ra_customer_trx.global_attribute16%type,
5926: p_global_attribute17 IN ra_customer_trx.global_attribute17%type,
5927: p_global_attribute18 IN ra_customer_trx.global_attribute18%type,
5928: p_global_attribute19 IN ra_customer_trx.global_attribute19%type,
5929: p_global_attribute20 IN ra_customer_trx.global_attribute20%type,
5930: p_global_attribute21 IN ra_customer_trx.global_attribute21%type,
5931: p_global_attribute22 IN ra_customer_trx.global_attribute22%type,
5932: p_global_attribute23 IN ra_customer_trx.global_attribute23%type,

Line 5929: p_global_attribute20 IN ra_customer_trx.global_attribute20%type,

5925: p_global_attribute16 IN ra_customer_trx.global_attribute16%type,
5926: p_global_attribute17 IN ra_customer_trx.global_attribute17%type,
5927: p_global_attribute18 IN ra_customer_trx.global_attribute18%type,
5928: p_global_attribute19 IN ra_customer_trx.global_attribute19%type,
5929: p_global_attribute20 IN ra_customer_trx.global_attribute20%type,
5930: p_global_attribute21 IN ra_customer_trx.global_attribute21%type,
5931: p_global_attribute22 IN ra_customer_trx.global_attribute22%type,
5932: p_global_attribute23 IN ra_customer_trx.global_attribute23%type,
5933: p_global_attribute24 IN ra_customer_trx.global_attribute24%type,

Line 5930: p_global_attribute21 IN ra_customer_trx.global_attribute21%type,

5926: p_global_attribute17 IN ra_customer_trx.global_attribute17%type,
5927: p_global_attribute18 IN ra_customer_trx.global_attribute18%type,
5928: p_global_attribute19 IN ra_customer_trx.global_attribute19%type,
5929: p_global_attribute20 IN ra_customer_trx.global_attribute20%type,
5930: p_global_attribute21 IN ra_customer_trx.global_attribute21%type,
5931: p_global_attribute22 IN ra_customer_trx.global_attribute22%type,
5932: p_global_attribute23 IN ra_customer_trx.global_attribute23%type,
5933: p_global_attribute24 IN ra_customer_trx.global_attribute24%type,
5934: p_global_attribute25 IN ra_customer_trx.global_attribute25%type,

Line 5931: p_global_attribute22 IN ra_customer_trx.global_attribute22%type,

5927: p_global_attribute18 IN ra_customer_trx.global_attribute18%type,
5928: p_global_attribute19 IN ra_customer_trx.global_attribute19%type,
5929: p_global_attribute20 IN ra_customer_trx.global_attribute20%type,
5930: p_global_attribute21 IN ra_customer_trx.global_attribute21%type,
5931: p_global_attribute22 IN ra_customer_trx.global_attribute22%type,
5932: p_global_attribute23 IN ra_customer_trx.global_attribute23%type,
5933: p_global_attribute24 IN ra_customer_trx.global_attribute24%type,
5934: p_global_attribute25 IN ra_customer_trx.global_attribute25%type,
5935: p_global_attribute26 IN ra_customer_trx.global_attribute26%type,

Line 5932: p_global_attribute23 IN ra_customer_trx.global_attribute23%type,

5928: p_global_attribute19 IN ra_customer_trx.global_attribute19%type,
5929: p_global_attribute20 IN ra_customer_trx.global_attribute20%type,
5930: p_global_attribute21 IN ra_customer_trx.global_attribute21%type,
5931: p_global_attribute22 IN ra_customer_trx.global_attribute22%type,
5932: p_global_attribute23 IN ra_customer_trx.global_attribute23%type,
5933: p_global_attribute24 IN ra_customer_trx.global_attribute24%type,
5934: p_global_attribute25 IN ra_customer_trx.global_attribute25%type,
5935: p_global_attribute26 IN ra_customer_trx.global_attribute26%type,
5936: p_global_attribute27 IN ra_customer_trx.global_attribute27%type,

Line 5933: p_global_attribute24 IN ra_customer_trx.global_attribute24%type,

5929: p_global_attribute20 IN ra_customer_trx.global_attribute20%type,
5930: p_global_attribute21 IN ra_customer_trx.global_attribute21%type,
5931: p_global_attribute22 IN ra_customer_trx.global_attribute22%type,
5932: p_global_attribute23 IN ra_customer_trx.global_attribute23%type,
5933: p_global_attribute24 IN ra_customer_trx.global_attribute24%type,
5934: p_global_attribute25 IN ra_customer_trx.global_attribute25%type,
5935: p_global_attribute26 IN ra_customer_trx.global_attribute26%type,
5936: p_global_attribute27 IN ra_customer_trx.global_attribute27%type,
5937: p_global_attribute28 IN ra_customer_trx.global_attribute28%type,

Line 5934: p_global_attribute25 IN ra_customer_trx.global_attribute25%type,

5930: p_global_attribute21 IN ra_customer_trx.global_attribute21%type,
5931: p_global_attribute22 IN ra_customer_trx.global_attribute22%type,
5932: p_global_attribute23 IN ra_customer_trx.global_attribute23%type,
5933: p_global_attribute24 IN ra_customer_trx.global_attribute24%type,
5934: p_global_attribute25 IN ra_customer_trx.global_attribute25%type,
5935: p_global_attribute26 IN ra_customer_trx.global_attribute26%type,
5936: p_global_attribute27 IN ra_customer_trx.global_attribute27%type,
5937: p_global_attribute28 IN ra_customer_trx.global_attribute28%type,
5938: p_global_attribute29 IN ra_customer_trx.global_attribute29%type,

Line 5935: p_global_attribute26 IN ra_customer_trx.global_attribute26%type,

5931: p_global_attribute22 IN ra_customer_trx.global_attribute22%type,
5932: p_global_attribute23 IN ra_customer_trx.global_attribute23%type,
5933: p_global_attribute24 IN ra_customer_trx.global_attribute24%type,
5934: p_global_attribute25 IN ra_customer_trx.global_attribute25%type,
5935: p_global_attribute26 IN ra_customer_trx.global_attribute26%type,
5936: p_global_attribute27 IN ra_customer_trx.global_attribute27%type,
5937: p_global_attribute28 IN ra_customer_trx.global_attribute28%type,
5938: p_global_attribute29 IN ra_customer_trx.global_attribute29%type,
5939: p_global_attribute30 IN ra_customer_trx.global_attribute30%type,

Line 5936: p_global_attribute27 IN ra_customer_trx.global_attribute27%type,

5932: p_global_attribute23 IN ra_customer_trx.global_attribute23%type,
5933: p_global_attribute24 IN ra_customer_trx.global_attribute24%type,
5934: p_global_attribute25 IN ra_customer_trx.global_attribute25%type,
5935: p_global_attribute26 IN ra_customer_trx.global_attribute26%type,
5936: p_global_attribute27 IN ra_customer_trx.global_attribute27%type,
5937: p_global_attribute28 IN ra_customer_trx.global_attribute28%type,
5938: p_global_attribute29 IN ra_customer_trx.global_attribute29%type,
5939: p_global_attribute30 IN ra_customer_trx.global_attribute30%type,
5940: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,

Line 5937: p_global_attribute28 IN ra_customer_trx.global_attribute28%type,

5933: p_global_attribute24 IN ra_customer_trx.global_attribute24%type,
5934: p_global_attribute25 IN ra_customer_trx.global_attribute25%type,
5935: p_global_attribute26 IN ra_customer_trx.global_attribute26%type,
5936: p_global_attribute27 IN ra_customer_trx.global_attribute27%type,
5937: p_global_attribute28 IN ra_customer_trx.global_attribute28%type,
5938: p_global_attribute29 IN ra_customer_trx.global_attribute29%type,
5939: p_global_attribute30 IN ra_customer_trx.global_attribute30%type,
5940: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,
5941: p_payment_trxn_extension_id IN ra_customer_trx.payment_trxn_extension_id%type,

Line 5938: p_global_attribute29 IN ra_customer_trx.global_attribute29%type,

5934: p_global_attribute25 IN ra_customer_trx.global_attribute25%type,
5935: p_global_attribute26 IN ra_customer_trx.global_attribute26%type,
5936: p_global_attribute27 IN ra_customer_trx.global_attribute27%type,
5937: p_global_attribute28 IN ra_customer_trx.global_attribute28%type,
5938: p_global_attribute29 IN ra_customer_trx.global_attribute29%type,
5939: p_global_attribute30 IN ra_customer_trx.global_attribute30%type,
5940: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,
5941: p_payment_trxn_extension_id IN ra_customer_trx.payment_trxn_extension_id%type,
5942: p_billing_date IN ra_customer_trx.billing_date%type)

Line 5939: p_global_attribute30 IN ra_customer_trx.global_attribute30%type,

5935: p_global_attribute26 IN ra_customer_trx.global_attribute26%type,
5936: p_global_attribute27 IN ra_customer_trx.global_attribute27%type,
5937: p_global_attribute28 IN ra_customer_trx.global_attribute28%type,
5938: p_global_attribute29 IN ra_customer_trx.global_attribute29%type,
5939: p_global_attribute30 IN ra_customer_trx.global_attribute30%type,
5940: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,
5941: p_payment_trxn_extension_id IN ra_customer_trx.payment_trxn_extension_id%type,
5942: p_billing_date IN ra_customer_trx.billing_date%type)
5943:

Line 5940: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,

5936: p_global_attribute27 IN ra_customer_trx.global_attribute27%type,
5937: p_global_attribute28 IN ra_customer_trx.global_attribute28%type,
5938: p_global_attribute29 IN ra_customer_trx.global_attribute29%type,
5939: p_global_attribute30 IN ra_customer_trx.global_attribute30%type,
5940: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,
5941: p_payment_trxn_extension_id IN ra_customer_trx.payment_trxn_extension_id%type,
5942: p_billing_date IN ra_customer_trx.billing_date%type)
5943:
5944:

Line 5941: p_payment_trxn_extension_id IN ra_customer_trx.payment_trxn_extension_id%type,

5937: p_global_attribute28 IN ra_customer_trx.global_attribute28%type,
5938: p_global_attribute29 IN ra_customer_trx.global_attribute29%type,
5939: p_global_attribute30 IN ra_customer_trx.global_attribute30%type,
5940: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,
5941: p_payment_trxn_extension_id IN ra_customer_trx.payment_trxn_extension_id%type,
5942: p_billing_date IN ra_customer_trx.billing_date%type)
5943:
5944:
5945: IS

Line 5942: p_billing_date IN ra_customer_trx.billing_date%type)

5938: p_global_attribute29 IN ra_customer_trx.global_attribute29%type,
5939: p_global_attribute30 IN ra_customer_trx.global_attribute30%type,
5940: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type,
5941: p_payment_trxn_extension_id IN ra_customer_trx.payment_trxn_extension_id%type,
5942: p_billing_date IN ra_customer_trx.billing_date%type)
5943:
5944:
5945: IS
5946:

Line 5947: l_trx_rec ra_customer_trx%rowtype;

5943:
5944:
5945: IS
5946:
5947: l_trx_rec ra_customer_trx%rowtype;
5948:
5949: BEGIN
5950: arp_util.debug('arp_ct_pkg.lock_compare_cover()+');
5951: