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.PN_EXP_TO_AR dependencies on RA_INTERFACE_LINES

Line 532: -- characters before inserting into ra_interface_lines,

528: before inserting into interface_line_attribute2
529: -- 22-NOV-04 kkhegde o Bug 3751438 - fixed the validation for distributions
530: -- 22-DEC-04 Kiran o Fix for 3751438 - corrected it for bug # 4083036
531: -- 10-MAR-05 piagrawa o Bug #4231051 - Truncated the attribute values to 30
532: -- characters before inserting into ra_interface_lines,
533: -- ra_interface_salescredits and
534: -- ra_interface_distributions tables
535: -- 15-JUL-05 hareesha o Bug 4284035 - Replaced RA_INTERFACE_DISTRIBUTIONS_ALL
536: -- with _ALL table.

Line 543: -- into ra_interface_lines_all instead of rule_gl_date.

539: -- 28-OCT-05 sdmahesh o ATG mandated changes for SQL literals
540: -- 24-MAR-06 Hareesha o Bug 5116270 Modified get_salesrep_number to pass
541: -- org_id as parameter.
542: -- 07-AUG-06 Hareesha o Bug #5405883 Inserted schedule_date as rule_start_date
543: -- into ra_interface_lines_all instead of rule_gl_date.
544: -----------------------------------------------------------------------------*/
545: Procedure EXP_TO_AR_GRP (
546: errbuf IN OUT NOCOPY VARCHAR2
547: ,retcode IN OUT NOCOPY VARCHAR2

Line 573: l_desc RA_INTERFACE_LINES.description%TYPE;

569: l_inv_rule_freq RA_RULES.FREQUENCY%TYPE;
570: l_acc_rule_name RA_RULES.NAME%TYPE;
571: l_acc_rule_type RA_RULES.TYPE%TYPE;
572: l_acc_rule_freq RA_RULES.FREQUENCY%TYPE;
573: l_desc RA_INTERFACE_LINES.description%TYPE;
574: l_salesrep_number RA_SALESREPS.SALESREP_NUMBER%TYPE;
575: l_sales_credit_id RA_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE;
576: l_cust_trx_name RA_CUST_TRX_TYPES.NAME%TYPE;
577: l_term_name RA_TERMS.NAME%TYPE;

Line 625: l_rule_start_date RA_INTERFACE_LINES.RULE_START_DATE%TYPE := NULL;

621: l_valid_rec_accs BOOLEAN := TRUE;
622: l_grp NUMBER;
623: l_post_to_gl RA_CUST_TRX_TYPES_ALL.POST_TO_GL%TYPE;
624: l_derive_date_flag RA_BATCH_SOURCES.derive_date_flag%TYPE;
625: l_rule_start_date RA_INTERFACE_LINES.RULE_START_DATE%TYPE := NULL;
626: l_count_grp INTEGER;
627: l_rows_grp INTEGER;
628: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;
629: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;

Line 1111: o one record per item in group into ra_interface_lines

1107: l_last_update_date := sysdate;
1108:
1109: /* if we reached here, we have a group worth inserting
1110: loop through the PL/SQL table and insert
1111: o one record per item in group into ra_interface_lines
1112: o distributions into ra_interface_distributions for REV
1113: and UNEARN based on pn_distributions for each line
1114: o ONLY one record in ra_interface_distributions for REC
1115: for ALL items

Line 1308: INSERT INTO ra_interface_lines_all

1304:
1305:
1306: l_context := 'Inserting into interface lines';
1307:
1308: INSERT INTO ra_interface_lines_all
1309:
1310: (amount_includes_tax_flag -- tax inclusive flag
1311: ,tax_code -- tax code
1312: ,legal_entity_id -- legal entity

Line 1793: -- characters before inserting into ra_interface_lines,

1789: before inserting into interface_line_attribute2
1790: -- 22-NOV-04 kkhegde o Bug 3751438 - fixed the validation for distributions
1791: -- 22-DEC-04 Kiran o Fix for 3751438 - corrected it for bug # 4083036
1792: -- 10-MAR-05 piagrawa o Bug #4231051 - Truncated the attribute values to 30
1793: -- characters before inserting into ra_interface_lines,
1794: -- ra_interface_salescredits and
1795: -- ra_interface_distributions tables
1796: -- 12-SEP-05 Parag o Bug #4284035 Modified insert statement to include org_id
1797: -- 11-OCT-05 pikhar o Bug 4652946 - Added trunc to pi.accounted_date in

Line 1804: -- into ra_interface_lines_all instead of rule_gl_date.

1800: -- 28-NOV-05 sdmahesh o Passed org_id to GET_START_DATE,check_conversion_type
1801: -- 24-MAR-06 Hareesha o Bug 5116270 Modified get_salesrep_number to pass
1802: -- org_id as parameter.
1803: -- 07-AUG-06 Hareesha o Bug #5405883 Inserted schedule_date as rule_start_date
1804: -- into ra_interface_lines_all instead of rule_gl_date.
1805: -----------------------------------------------------------------------------*/
1806:
1807: Procedure EXP_TO_AR_NO_GRP (
1808: errbuf IN OUT NOCOPY VARCHAR2

Line 1871: l_desc RA_INTERFACE_LINES.description%TYPE;

1867: l_inv_rule_freq RA_RULES.frequency%TYPE;
1868: l_acc_rule_name RA_RULES.name%TYPE;
1869: l_acc_rule_type RA_RULES.type%TYPE;
1870: l_acc_rule_freq RA_RULES.frequency%TYPE;
1871: l_desc RA_INTERFACE_LINES.description%TYPE;
1872: l_salesrep_number RA_SALESREPS.salesrep_number%TYPE;
1873: l_sales_credit_id RA_SALESREPS.sales_credit_type_id%TYPE;
1874: l_cust_trx_name RA_CUST_TRX_TYPES.name%TYPE;
1875: l_term_name RA_TERMS.name%TYPE;

Line 1920: l_rule_start_date RA_INTERFACE_LINES.rule_start_date%TYPE := NULL;

1916: v_pur_code PN_PAYMENT_TERMS.payment_purpose_code%TYPE;
1917: v_pur_type_code PN_PAYMENT_TERMS.payment_term_type_code%TYPE;
1918: l_post_to_gl RA_CUST_TRX_TYPES_ALL.post_to_gl%TYPE;
1919: l_derive_date_flag RA_BATCH_SOURCES.derive_date_flag%TYPE;
1920: l_rule_start_date RA_INTERFACE_LINES.rule_start_date%TYPE := NULL;
1921: l_rows_nogrp INTEGER;
1922: l_count_nogrp INTEGER;
1923: v_pn_payment_term_id1 PN_PAYMENT_ITEMS_ALL.payment_term_id%TYPE;
1924: v_pn_le_id1 PN_PAYMENT_TERMS_ALL.legal_entity_id%TYPE;

Line 2418: INSERT INTO ra_interface_lines_all

2414: pnp_debug_pkg.put_log_msg(fnd_message.get);
2415:
2416: l_context := 'Inserting into interface lines';
2417:
2418: INSERT INTO ra_interface_lines_all
2419: ( amount_includes_tax_flag -- tax inclusive flag
2420: ,tax_code -- tax code
2421: ,legal_entity_id -- legal entity id
2422: ,org_id -- org id