[Home] [Help]
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.
537: -- 11-OCT-05 pikhar o Bug 4652946 - Added trunc to pi.accounted_date in
538: -- Q_Billitem, l_ord_clause
539: -- 28-OCT-05 sdmahesh o ATG mandated changes for SQL literals
1476:
1477: l_context := 'Inserting into Distributions for REC acount for this group';
1478: pnp_debug_pkg.log(l_context ||' : '|| exp_ar_tbl(l_grp).rec_account);
1479:
1480: INSERT INTO ra_interface_distributions_all
1481: (account_class
1482: ,percent
1483: ,amount
1484: ,code_combination_id
1619:
1620: pnp_debug_pkg.log('Inserting into distributions for account types of REV and UNEARN');
1621: l_context := 'Inserting into Distributions for account types of REV and UNEARN';
1622:
1623: INSERT INTO ra_interface_distributions_all
1624: (account_class
1625: ,percent
1626: ,amount
1627: ,code_combination_id
2685: (NVL(V_NORMALIZE,'N') <> 'Y' OR
2686: (NVL(V_NORMALIZE,'N') = 'Y' AND NVL(l_send_flag,'Y') = 'N'))) THEN
2687:
2688:
2689: INSERT INTO ra_interface_distributions_all
2690: ( account_class
2691: ,percent
2692: ,amount
2693: ,code_combination_id