DBA Data[Home] [Help]

APPS.ARW_CM_COVER dependencies on RA_CUSTOMER_TRX_LINES

Line 329: p_line_amount IN ra_customer_trx_lines.extended_amount%type,

325: p_interface_header_attribute15 IN ra_customer_trx.interface_header_attribute15%type,
326: p_default_ussgl_trx_code IN ra_customer_trx.default_ussgl_transaction_code%type,
327: p_line_percent IN number,
328: p_freight_percent IN number,
329: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
330: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
331: p_compute_tax IN varchar2,
332: p_comments IN ra_customer_trx.comments%type,
333: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,

Line 330: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,

326: p_default_ussgl_trx_code IN ra_customer_trx.default_ussgl_transaction_code%type,
327: p_line_percent IN number,
328: p_freight_percent IN number,
329: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
330: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
331: p_compute_tax IN varchar2,
332: p_comments IN ra_customer_trx.comments%type,
333: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
334: p_trx_number IN OUT NOCOPY ra_customer_trx.trx_number%type,

Line 336: p_computed_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

332: p_comments IN ra_customer_trx.comments%type,
333: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
334: p_trx_number IN OUT NOCOPY ra_customer_trx.trx_number%type,
335: p_computed_tax_percent IN OUT NOCOPY number,
336: p_computed_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
337: p_errors OUT NOCOPY arp_trx_validate.Message_Tbl_Type,
338: p_status OUT NOCOPY varchar2,
339: p_purchase_order IN ra_customer_trx.purchase_order%type,
340: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,

Line 395: l_line_amount ra_customer_trx_lines.extended_amount%type ;

391: l_num_frt_lines number;
392: l_num_installments number;
393: l_pmt_exist_flag varchar2(1);
394: --
395: l_line_amount ra_customer_trx_lines.extended_amount%type ;
396: l_line_percent number ;
397: l_freight_amount ra_customer_trx_lines.extended_amount%type ;
398: l_freight_percent number ;
399: l_computed_tax_percent number;

Line 397: l_freight_amount ra_customer_trx_lines.extended_amount%type ;

393: l_pmt_exist_flag varchar2(1);
394: --
395: l_line_amount ra_customer_trx_lines.extended_amount%type ;
396: l_line_percent number ;
397: l_freight_amount ra_customer_trx_lines.extended_amount%type ;
398: l_freight_percent number ;
399: l_computed_tax_percent number;
400: l_computed_tax_amount ra_customer_trx_lines.extended_amount%type;
401: l_credited_trx_rec ra_customer_trx_cr_trx_v%rowtype ;

Line 400: l_computed_tax_amount ra_customer_trx_lines.extended_amount%type;

396: l_line_percent number ;
397: l_freight_amount ra_customer_trx_lines.extended_amount%type ;
398: l_freight_percent number ;
399: l_computed_tax_percent number;
400: l_computed_tax_amount ra_customer_trx_lines.extended_amount%type;
401: l_credited_trx_rec ra_customer_trx_cr_trx_v%rowtype ;
402: l_credited_trx_cm_type_id ra_cust_trx_types.credit_memo_type_id%TYPE ;
403: l_credited_trx_open_rec_flag ra_cust_trx_types.accounting_affect_flag%TYPE ;
404: --

Line 1544: p_line_amount IN ra_customer_trx_lines.extended_amount%type,

1540: p_interface_header_attribute15 IN ra_customer_trx.interface_header_attribute15%type,
1541: p_default_ussgl_trx_code IN ra_customer_trx.default_ussgl_transaction_code%type,
1542: p_line_percent IN number,
1543: p_freight_percent IN number,
1544: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
1545: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
1546: p_compute_tax IN varchar2,
1547: p_comments IN ra_customer_trx.comments%type,
1548: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,

Line 1545: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,

1541: p_default_ussgl_trx_code IN ra_customer_trx.default_ussgl_transaction_code%type,
1542: p_line_percent IN number,
1543: p_freight_percent IN number,
1544: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
1545: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
1546: p_compute_tax IN varchar2,
1547: p_comments IN ra_customer_trx.comments%type,
1548: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
1549: p_trx_number IN OUT NOCOPY ra_customer_trx.trx_number%type,

Line 1551: p_computed_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

1547: p_comments IN ra_customer_trx.comments%type,
1548: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
1549: p_trx_number IN OUT NOCOPY ra_customer_trx.trx_number%type,
1550: p_computed_tax_percent IN OUT NOCOPY number,
1551: p_computed_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1552: p_errors OUT NOCOPY arp_trx_validate.Message_Tbl_Type,
1553: p_status OUT NOCOPY varchar2,
1554: p_credit_line_table IN arw_cm_cover.credit_lines_table_type,
1555: p_purchase_order IN ra_customer_trx.purchase_order%type,

Line 1638: ct_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE;

1634: l_cr CONSTANT char(1) := '
1635: ';
1636: j number;
1637:
1638: ct_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE;
1639: ct_quantity_invoiced ra_customer_trx_lines.quantity_invoiced%TYPE;
1640: ct_extended_amount ra_customer_trx_lines.extended_amount%TYPE;
1641: ----
1642: l_dist_index NUMBER ;

Line 1639: ct_quantity_invoiced ra_customer_trx_lines.quantity_invoiced%TYPE;

1635: ';
1636: j number;
1637:
1638: ct_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE;
1639: ct_quantity_invoiced ra_customer_trx_lines.quantity_invoiced%TYPE;
1640: ct_extended_amount ra_customer_trx_lines.extended_amount%TYPE;
1641: ----
1642: l_dist_index NUMBER ;
1643: l_lines_index NUMBER ;

Line 1640: ct_extended_amount ra_customer_trx_lines.extended_amount%TYPE;

1636: j number;
1637:
1638: ct_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE;
1639: ct_quantity_invoiced ra_customer_trx_lines.quantity_invoiced%TYPE;
1640: ct_extended_amount ra_customer_trx_lines.extended_amount%TYPE;
1641: ----
1642: l_dist_index NUMBER ;
1643: l_lines_index NUMBER ;
1644: l_credit_memo_type_id ra_cust_trx_types.credit_memo_type_id%type;

Line 1649: line_type ra_customer_trx_lines.Line_type%type

1645: l_line_matched NUMBER := 0;
1646: l_lines_to_delete_index NUMBER := 1;
1647: TYPE lines_to_delete_rec IS RECORD
1648: (line_index BINARY_INTEGER,
1649: line_type ra_customer_trx_lines.Line_type%type
1650: );
1651: TYPE lines_to_delete_tbl_type IS TABLE OF lines_to_delete_rec INDEX BY BINARY_INTEGER;
1652: l_lines_to_delete_tbl lines_to_delete_tbl_type;
1653:

Line 1665: l_line_amount ra_customer_trx_lines.extended_amount%type ;

1661: l_debug_point NUMBER;
1662:
1663: l_cm_header ra_customer_trx%rowtype;
1664:
1665: l_line_amount ra_customer_trx_lines.extended_amount%type ;
1666: l_line_percent number ;
1667: l_freight_amount ra_customer_trx_lines.extended_amount%type ;
1668: l_freight_percent number ;
1669: l_computed_tax_percent number;

Line 1667: l_freight_amount ra_customer_trx_lines.extended_amount%type ;

1663: l_cm_header ra_customer_trx%rowtype;
1664:
1665: l_line_amount ra_customer_trx_lines.extended_amount%type ;
1666: l_line_percent number ;
1667: l_freight_amount ra_customer_trx_lines.extended_amount%type ;
1668: l_freight_percent number ;
1669: l_computed_tax_percent number;
1670: l_computed_tax_amount ra_customer_trx_lines.extended_amount%type;
1671:

Line 1670: l_computed_tax_amount ra_customer_trx_lines.extended_amount%type;

1666: l_line_percent number ;
1667: l_freight_amount ra_customer_trx_lines.extended_amount%type ;
1668: l_freight_percent number ;
1669: l_computed_tax_percent number;
1670: l_computed_tax_amount ra_customer_trx_lines.extended_amount%type;
1671:
1672: l_default_bs_name varchar2(50);
1673: l_bs_type varchar2(10);
1674: l_copy_doc_number_flag varchar2(1);

Line 1716: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE;

1712: l_pmt_exist_flag varchar2(1);
1713: --
1714: l_credited_trx_line_tbl arw_cm_cover.credit_lines_table_type;
1715:
1716: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE;
1717:
1718: l_err_mesg VARCHAR2(2000);
1719: l_ue_message VARCHAR2(2000);
1720: