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_CTL_PKG dependencies on RA_CUSTOMER_TRX_LINES

Line 122: p_tax_amount IN ra_customer_trx_lines.extended_amount%type,

118: | |
119: +===========================================================================*/
120:
121: FUNCTION calculate_prorated_tax_amount (p_mode IN varchar2,
122: p_tax_amount IN ra_customer_trx_lines.extended_amount%type,
123: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
124: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type)
125: RETURN NUMBER
126: IS

Line 124: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type)

120:
121: FUNCTION calculate_prorated_tax_amount (p_mode IN varchar2,
122: p_tax_amount IN ra_customer_trx_lines.extended_amount%type,
123: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
124: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type)
125: RETURN NUMBER
126: IS
127: l_tax_recoverable ra_customer_trx_lines.tax_recoverable%type;
128: l_total_tax_recoverable ra_customer_trx_lines.tax_recoverable%type;

Line 127: l_tax_recoverable ra_customer_trx_lines.tax_recoverable%type;

123: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
124: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type)
125: RETURN NUMBER
126: IS
127: l_tax_recoverable ra_customer_trx_lines.tax_recoverable%type;
128: l_total_tax_recoverable ra_customer_trx_lines.tax_recoverable%type;
129: l_precision FND_CURRENCIES.precision%type;
130: l_mau FND_CURRENCIES.minimum_accountable_unit%type;
131: l_tax_amount ra_customer_trx_lines.extended_amount%type;

Line 128: l_total_tax_recoverable ra_customer_trx_lines.tax_recoverable%type;

124: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type)
125: RETURN NUMBER
126: IS
127: l_tax_recoverable ra_customer_trx_lines.tax_recoverable%type;
128: l_total_tax_recoverable ra_customer_trx_lines.tax_recoverable%type;
129: l_precision FND_CURRENCIES.precision%type;
130: l_mau FND_CURRENCIES.minimum_accountable_unit%type;
131: l_tax_amount ra_customer_trx_lines.extended_amount%type;
132:

Line 131: l_tax_amount ra_customer_trx_lines.extended_amount%type;

127: l_tax_recoverable ra_customer_trx_lines.tax_recoverable%type;
128: l_total_tax_recoverable ra_customer_trx_lines.tax_recoverable%type;
129: l_precision FND_CURRENCIES.precision%type;
130: l_mau FND_CURRENCIES.minimum_accountable_unit%type;
131: l_tax_amount ra_customer_trx_lines.extended_amount%type;
132:
133: BEGIN
134: IF PG_DEBUG in ('Y', 'C') THEN
135: arp_util.debug( 'arp_ctl_pkg.calculate_prorated_tax_amount()+');

Line 142: (select sum(ctl_tax.extended_amount) from ra_customer_trx_lines_all ctl_tax

138: IF p_mode = 'INSERT_NO_LINE' then
139:
140: select sum(decode(ct.complete_flag , 'N', 0,
141: nvl(ctl.tax_recoverable,
142: (select sum(ctl_tax.extended_amount) from ra_customer_trx_lines_all ctl_tax
143: where ctl_tax.customer_trx_id = ctl.customer_trx_id
144: and ctl_tax.link_to_cust_trx_line_id = ctl.customer_trx_line_id
145: and ctl_tax.line_type = 'TAX')))) tax_recoverable
146: INTO l_tax_recoverable

Line 147: from ra_customer_trx_lines_all orig_ctl,

143: where ctl_tax.customer_trx_id = ctl.customer_trx_id
144: and ctl_tax.link_to_cust_trx_line_id = ctl.customer_trx_line_id
145: and ctl_tax.line_type = 'TAX')))) tax_recoverable
146: INTO l_tax_recoverable
147: from ra_customer_trx_lines_all orig_ctl,
148: ra_customer_trx_lines_all ctl,
149: ra_customer_trx_lines_all cm_ctl,
150: ra_customer_trx_all ct
151: where (ctl.customer_trx_line_id = orig_ctl.customer_trx_line_id

Line 148: ra_customer_trx_lines_all ctl,

144: and ctl_tax.link_to_cust_trx_line_id = ctl.customer_trx_line_id
145: and ctl_tax.line_type = 'TAX')))) tax_recoverable
146: INTO l_tax_recoverable
147: from ra_customer_trx_lines_all orig_ctl,
148: ra_customer_trx_lines_all ctl,
149: ra_customer_trx_lines_all cm_ctl,
150: ra_customer_trx_all ct
151: where (ctl.customer_trx_line_id = orig_ctl.customer_trx_line_id
152: OR ( ctl.previous_customer_trx_line_id IS NOT NULL

Line 149: ra_customer_trx_lines_all cm_ctl,

145: and ctl_tax.line_type = 'TAX')))) tax_recoverable
146: INTO l_tax_recoverable
147: from ra_customer_trx_lines_all orig_ctl,
148: ra_customer_trx_lines_all ctl,
149: ra_customer_trx_lines_all cm_ctl,
150: ra_customer_trx_all ct
151: where (ctl.customer_trx_line_id = orig_ctl.customer_trx_line_id
152: OR ( ctl.previous_customer_trx_line_id IS NOT NULL
153: AND ctl.previous_customer_trx_line_id = orig_ctl.customer_trx_line_id)

Line 164: nvl(ctl.tax_recoverable, (select sum(ctl_tax.extended_amount) from ra_customer_trx_lines_all ctl_tax

160: and ct.customer_trx_id = ctl.customer_trx_id
161: group by orig_ctl.customer_trx_line_id, ctl.line_type;
162:
163: select sum(decode(ct.complete_flag , 'N', 0,
164: nvl(ctl.tax_recoverable, (select sum(ctl_tax.extended_amount) from ra_customer_trx_lines_all ctl_tax
165: where ctl_tax.customer_trx_id = ctl.customer_trx_id
166: and ctl_tax.link_to_cust_trx_line_id = ctl.customer_trx_line_id
167: and ctl_tax.line_type = 'TAX')))) total_tax_recoverable
168: INTO l_total_tax_recoverable

Line 169: from ra_customer_trx_lines_all orig_ctl,

165: where ctl_tax.customer_trx_id = ctl.customer_trx_id
166: and ctl_tax.link_to_cust_trx_line_id = ctl.customer_trx_line_id
167: and ctl_tax.line_type = 'TAX')))) total_tax_recoverable
168: INTO l_total_tax_recoverable
169: from ra_customer_trx_lines_all orig_ctl,
170: ra_customer_trx_lines_all ctl,
171: ra_customer_trx_lines_all cm_ctl,
172: ra_customer_trx_all ct
173: where (ctl.customer_trx_line_id = orig_ctl.customer_trx_line_id

Line 170: ra_customer_trx_lines_all ctl,

166: and ctl_tax.link_to_cust_trx_line_id = ctl.customer_trx_line_id
167: and ctl_tax.line_type = 'TAX')))) total_tax_recoverable
168: INTO l_total_tax_recoverable
169: from ra_customer_trx_lines_all orig_ctl,
170: ra_customer_trx_lines_all ctl,
171: ra_customer_trx_lines_all cm_ctl,
172: ra_customer_trx_all ct
173: where (ctl.customer_trx_line_id = orig_ctl.customer_trx_line_id
174: OR ( ctl.previous_customer_trx_line_id IS NOT NULL

Line 171: ra_customer_trx_lines_all cm_ctl,

167: and ctl_tax.line_type = 'TAX')))) total_tax_recoverable
168: INTO l_total_tax_recoverable
169: from ra_customer_trx_lines_all orig_ctl,
170: ra_customer_trx_lines_all ctl,
171: ra_customer_trx_lines_all cm_ctl,
172: ra_customer_trx_all ct
173: where (ctl.customer_trx_line_id = orig_ctl.customer_trx_line_id
174: OR ( ctl.previous_customer_trx_line_id IS NOT NULL
175: AND ctl.previous_customer_trx_line_id = orig_ctl.customer_trx_line_id)

Line 253: | p_line_rec - ra_customer_trx_lines record |

249: | arp_util.debug |
250: | |
251: | ARGUMENTS : IN: |
252: | p_update_cursor - ID of the update cursor |
253: | p_line_rec - ra_customer_trx_lines record |
254: | OUT: |
255: | None |
256: | |
257: | RETURNS : NONE |

Line 294: p_line_rec IN ra_customer_trx_lines%rowtype) IS

290: +===========================================================================*/
291:
292:
293: PROCEDURE bind_line_variables(p_update_cursor IN integer,
294: p_line_rec IN ra_customer_trx_lines%rowtype) IS
295:
296: BEGIN
297:
298: arp_util.debug('arp_ctl_pkg.bind_line_variables()+');

Line 803: 'UPDATE ra_customer_trx_lines

799: BEGIN
800: arp_util.debug('arp_ctl_pkg.construct_line_update_stmt()+');
801:
802: update_text :=
803: 'UPDATE ra_customer_trx_lines
804: SET customer_trx_line_id =
805: DECODE(:customer_trx_line_id,
806: :ar_number_dummy, customer_trx_line_id,
807: :customer_trx_line_id),

Line 1366: | This procedure Updates records in ra_customer_trx_lines identified by |

1362: | PROCEDURE |
1363: | generic_update |
1364: | |
1365: | DESCRIPTION |
1366: | This procedure Updates records in ra_customer_trx_lines identified by |
1367: | the where clause that is passed in as a parameter. Only those columns |
1368: | in the line record parameter that do not contain the special dummy |
1369: | values are updated. |
1370: | |

Line 1403: ra_customer_trx_lines.line_type%type,

1399: PROCEDURE generic_update(p_update_cursor IN OUT NOCOPY integer,
1400: p_where_clause IN varchar2,
1401: p_where1 IN number,
1402: p_line_type IN
1403: ra_customer_trx_lines.line_type%type,
1404: p_currency_code IN
1405: fnd_currencies.currency_code%type,
1406: p_line_rec IN ra_customer_trx_lines%rowtype)
1407: IS

Line 1406: p_line_rec IN ra_customer_trx_lines%rowtype)

1402: p_line_type IN
1403: ra_customer_trx_lines.line_type%type,
1404: p_currency_code IN
1405: fnd_currencies.currency_code%type,
1406: p_line_rec IN ra_customer_trx_lines%rowtype)
1407: IS
1408:
1409: l_count number;
1410: l_update_statement varchar2(32767);

Line 1573: PROCEDURE set_to_dummy( p_line_rec OUT NOCOPY ra_customer_trx_lines%rowtype) IS

1569: | into the table handlers. |
1570: +===========================================================================*/
1571:
1572:
1573: PROCEDURE set_to_dummy( p_line_rec OUT NOCOPY ra_customer_trx_lines%rowtype) IS
1574:
1575: BEGIN
1576:
1577: IF PG_DEBUG in ('Y', 'C') THEN

Line 1737: | This procedure fetches a single row from ra_customer_trx_lines into a |

1733: | PROCEDURE |
1734: | fetch_p |
1735: | |
1736: | DESCRIPTION |
1737: | This procedure fetches a single row from ra_customer_trx_lines into a |
1738: | variable specified as a parameter based on the table's primary key, |
1739: | customer_trx__line_id. |
1740: | |
1741: | SCOPE - PUBLIC |

Line 1760: PROCEDURE fetch_p( p_line_rec OUT NOCOPY ra_customer_trx_lines%rowtype,

1756: | 07-JUN-95 Charlie Tomberg Created |
1757: | |
1758: +===========================================================================*/
1759:
1760: PROCEDURE fetch_p( p_line_rec OUT NOCOPY ra_customer_trx_lines%rowtype,
1761: p_customer_trx_line_id IN
1762: ra_customer_trx_lines.customer_trx_line_id%type )
1763: IS
1764:

Line 1762: ra_customer_trx_lines.customer_trx_line_id%type )

1758: +===========================================================================*/
1759:
1760: PROCEDURE fetch_p( p_line_rec OUT NOCOPY ra_customer_trx_lines%rowtype,
1761: p_customer_trx_line_id IN
1762: ra_customer_trx_lines.customer_trx_line_id%type )
1763: IS
1764:
1765: BEGIN
1766: IF PG_DEBUG in ('Y', 'C') THEN

Line 1772: FROM ra_customer_trx_lines

1768: END IF;
1769:
1770: SELECT *
1771: INTO p_line_rec
1772: FROM ra_customer_trx_lines
1773: WHERE customer_trx_line_id = p_customer_trx_line_id;
1774:
1775: IF PG_DEBUG in ('Y', 'C') THEN
1776: arp_util.debug( 'arp_ctl_pkg.fetch_p()-');

Line 1796: | This procedure locks the ra_customer_trx_lines row identified by the |

1792: | PROCEDURE |
1793: | lock_p |
1794: | |
1795: | DESCRIPTION |
1796: | This procedure locks the ra_customer_trx_lines row identified by the |
1797: | p_customer_trx_line_id parameter. |
1798: | |
1799: | SCOPE - PUBLIC |
1800: | |

Line 1819: ra_customer_trx_lines.customer_trx_line_id%type )

1815: | |
1816: +===========================================================================*/
1817:
1818: PROCEDURE lock_p( p_customer_trx_line_id IN
1819: ra_customer_trx_lines.customer_trx_line_id%type )
1820: IS
1821:
1822: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
1823:

Line 1822: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;

1818: PROCEDURE lock_p( p_customer_trx_line_id IN
1819: ra_customer_trx_lines.customer_trx_line_id%type )
1820: IS
1821:
1822: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
1823:
1824: BEGIN
1825: IF PG_DEBUG in ('Y', 'C') THEN
1826: arp_util.debug( 'arp_ctl_pkg.lock_p()+');

Line 1832: FROM ra_customer_trx_lines

1828:
1829:
1830: SELECT customer_trx_line_id
1831: INTO l_customer_trx_line_id
1832: FROM ra_customer_trx_lines
1833: WHERE customer_trx_line_id = p_customer_trx_line_id
1834: FOR UPDATE OF customer_trx_line_id NOWAIT;
1835:
1836: IF PG_DEBUG in ('Y', 'C') THEN

Line 1858: | This procedure locks the ra_customer_trx_lines rows identified by the |

1854: | PROCEDURE |
1855: | lock_f_ct_id |
1856: | |
1857: | DESCRIPTION |
1858: | This procedure locks the ra_customer_trx_lines rows identified by the |
1859: | p_customer_trx_id parameter. |
1860: | |
1861: | SCOPE - PUBLIC |
1862: | |

Line 1886: FROM ra_customer_trx_lines

1882: IS
1883:
1884: CURSOR LOCK_C IS
1885: SELECT 'lock'
1886: FROM ra_customer_trx_lines
1887: WHERE customer_trx_id = p_customer_trx_id
1888: FOR UPDATE OF customer_trx_line_id NOWAIT;
1889:
1890: BEGIN

Line 1921: | This procedure locks the ra_customer_trx_lines row identified by the |

1917: | PROCEDURE |
1918: | lock_fetch_p |
1919: | |
1920: | DESCRIPTION |
1921: | This procedure locks the ra_customer_trx_lines row identified by the |
1922: | p_ra_customer_trx_line_id parameter and populates the |
1923: | p_line_rec parameter with the row that was locked |
1924: | |
1925: | SCOPE - PUBLIC |

Line 1944: PROCEDURE lock_fetch_p( p_line_rec IN OUT NOCOPY ra_customer_trx_lines%rowtype,

1940: | 07-JUN-95 Charlie Tomberg Created |
1941: | |
1942: +===========================================================================*/
1943:
1944: PROCEDURE lock_fetch_p( p_line_rec IN OUT NOCOPY ra_customer_trx_lines%rowtype,
1945: p_customer_trx_line_id IN
1946: ra_customer_trx_lines.customer_trx_line_id%type ) IS
1947:
1948: BEGIN

Line 1946: ra_customer_trx_lines.customer_trx_line_id%type ) IS

1942: +===========================================================================*/
1943:
1944: PROCEDURE lock_fetch_p( p_line_rec IN OUT NOCOPY ra_customer_trx_lines%rowtype,
1945: p_customer_trx_line_id IN
1946: ra_customer_trx_lines.customer_trx_line_id%type ) IS
1947:
1948: BEGIN
1949: IF PG_DEBUG in ('Y', 'C') THEN
1950: arp_util.debug( 'arp_ctl_pkg.lock_fetch_p()+');

Line 1955: FROM ra_customer_trx_lines

1951: END IF;
1952:
1953: SELECT *
1954: INTO p_line_rec
1955: FROM ra_customer_trx_lines
1956: WHERE customer_trx_line_id = p_customer_trx_line_id
1957: FOR UPDATE OF customer_trx_line_id NOWAIT;
1958:
1959: IF PG_DEBUG in ('Y', 'C') THEN

Line 1982: | This procedure locks the ra_customer_trx_lines row identified by the |

1978: | PROCEDURE |
1979: | lock_compare_p |
1980: | |
1981: | DESCRIPTION |
1982: | This procedure locks the ra_customer_trx_lines row identified by the |
1983: | p_customer_trx_line_id parameter only if no columns in that row have |
1984: | changed from when they were first selected in the form. |
1985: | |
1986: | SCOPE - PUBLIC |

Line 2032: PROCEDURE lock_compare_p( p_line_rec IN ra_customer_trx_lines%rowtype,

2028: | 31-OCT-2000 Y Rakotonirainy Bug 1243304 : Added column wh_update_date |
2029: | into the table handlers. |
2030: +===========================================================================*/
2031:
2032: PROCEDURE lock_compare_p( p_line_rec IN ra_customer_trx_lines%rowtype,
2033: p_customer_trx_line_id IN
2034: ra_customer_trx_lines.customer_trx_line_id%type,
2035: p_ignore_who_flag BOOLEAN DEFAULT FALSE ) IS
2036:

Line 2034: ra_customer_trx_lines.customer_trx_line_id%type,

2030: +===========================================================================*/
2031:
2032: PROCEDURE lock_compare_p( p_line_rec IN ra_customer_trx_lines%rowtype,
2033: p_customer_trx_line_id IN
2034: ra_customer_trx_lines.customer_trx_line_id%type,
2035: p_ignore_who_flag BOOLEAN DEFAULT FALSE ) IS
2036:
2037: l_new_line_rec ra_customer_trx_lines%rowtype;
2038: l_temp_line_rec ra_customer_trx_lines%rowtype;

Line 2037: l_new_line_rec ra_customer_trx_lines%rowtype;

2033: p_customer_trx_line_id IN
2034: ra_customer_trx_lines.customer_trx_line_id%type,
2035: p_ignore_who_flag BOOLEAN DEFAULT FALSE ) IS
2036:
2037: l_new_line_rec ra_customer_trx_lines%rowtype;
2038: l_temp_line_rec ra_customer_trx_lines%rowtype;
2039: l_ignore_who_flag varchar2(2);
2040:
2041: BEGIN

Line 2038: l_temp_line_rec ra_customer_trx_lines%rowtype;

2034: ra_customer_trx_lines.customer_trx_line_id%type,
2035: p_ignore_who_flag BOOLEAN DEFAULT FALSE ) IS
2036:
2037: l_new_line_rec ra_customer_trx_lines%rowtype;
2038: l_temp_line_rec ra_customer_trx_lines%rowtype;
2039: l_ignore_who_flag varchar2(2);
2040:
2041: BEGIN
2042: IF PG_DEBUG in ('Y', 'C') THEN

Line 2053: FROM ra_customer_trx_lines ctl

2049: END IF;
2050:
2051: SELECT *
2052: INTO l_new_line_rec
2053: FROM ra_customer_trx_lines ctl
2054: WHERE ctl.customer_trx_line_id = p_customer_trx_line_id
2055: AND
2056: (
2057: NVL(ctl.customer_trx_line_id, AR_NUMBER_DUMMY) =

Line 3167: | This procedure deletes the ra_customer_trx_lines row identified by the |

3163: | PROCEDURE |
3164: | delete_p |
3165: | |
3166: | DESCRIPTION |
3167: | This procedure deletes the ra_customer_trx_lines row identified by the |
3168: | p_customer_trx_line_id parameter. |
3169: | |
3170: | SCOPE - PUBLIC |
3171: | |

Line 3190: ra_customer_trx_lines.customer_trx_line_id%type)

3186: | |
3187: +===========================================================================*/
3188:
3189: procedure delete_p( p_customer_trx_line_id IN
3190: ra_customer_trx_lines.customer_trx_line_id%type)
3191: IS
3192:
3193:
3194: BEGIN

Line 3201: DELETE FROM ra_customer_trx_lines

3197: arp_util.debug( 'arp_ctl_pkg.delete_p()+');
3198: arp_util.debug( 'deleting ctlid: ' || p_customer_trx_line_id);
3199: END IF;
3200:
3201: DELETE FROM ra_customer_trx_lines
3202: WHERE customer_trx_line_id = p_customer_trx_line_id;
3203:
3204: IF ( SQL%ROWCOUNT = 0 )
3205: THEN arp_util.debug('EXCEPTION: arp_ctl_pkg.delete_p()');

Line 3232: | This procedure deletes the ra_customer_trx_lines rows identified by |

3228: | PROCEDURE |
3229: | delete_f_ct_id |
3230: | |
3231: | DESCRIPTION |
3232: | This procedure deletes the ra_customer_trx_lines rows identified by |
3233: | the p_customer_trx_id parameter. |
3234: | |
3235: | SCOPE - PUBLIC |
3236: | |

Line 3265: DELETE FROM ra_customer_trx_lines

3261: IF PG_DEBUG in ('Y', 'C') THEN
3262: arp_util.debug( 'arp_ctl_pkg.delete_f_ct_id()+');
3263: END IF;
3264:
3265: DELETE FROM ra_customer_trx_lines
3266: WHERE customer_trx_id = p_customer_trx_id;
3267:
3268: IF PG_DEBUG in ('Y', 'C') THEN
3269: arp_util.debug( 'arp_ctl_pkg.delete_f_ct_id()-');

Line 3292: | This procedure deletes the child ra_customer_trx_lines rows identified |

3288: | PROCEDURE |
3289: | delete_f_ltctl_id |
3290: | |
3291: | DESCRIPTION |
3292: | This procedure deletes the child ra_customer_trx_lines rows identified |
3293: | by the p_link_to_cust_trx_line_id parameter. |
3294: | |
3295: | SCOPE - PUBLIC |
3296: | |

Line 3315: ra_customer_trx_lines.link_to_cust_trx_line_id%type)

3311: | |
3312: +===========================================================================*/
3313:
3314: procedure delete_f_ltctl_id( p_link_to_cust_trx_line_id IN
3315: ra_customer_trx_lines.link_to_cust_trx_line_id%type)
3316: IS
3317:
3318: BEGIN
3319:

Line 3325: DELETE FROM ra_customer_trx_lines

3321: IF PG_DEBUG in ('Y', 'C') THEN
3322: arp_util.debug( 'arp_ctl_pkg.delete_f_ltctl_id()+');
3323: END IF;
3324:
3325: DELETE FROM ra_customer_trx_lines
3326: WHERE link_to_cust_trx_line_id = p_link_to_cust_trx_line_id;
3327:
3328: IF PG_DEBUG in ('Y', 'C') THEN
3329: arp_util.debug( 'arp_ctl_pkg.delete_f_ltctl_id()-');

Line 3351: | This procedure deletes the child ra_customer_trx_lines rows identified |

3347: | PROCEDURE |
3348: | delete_f_ct_ltctl_id_type |
3349: | |
3350: | DESCRIPTION |
3351: | This procedure deletes the child ra_customer_trx_lines rows identified |
3352: | by the p_customer_trx_id, p_link_to_cust_trx_line_id and p_line_type |
3353: | |
3354: | SCOPE - PUBLIC |
3355: | |

Line 3381: ra_customer_trx_lines.link_to_cust_trx_line_id%type,

3377: procedure delete_f_ct_ltctl_id_type(
3378: p_customer_trx_id IN
3379: ra_customer_trx.customer_trx_id%type,
3380: p_link_to_cust_trx_line_id IN
3381: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
3382: p_line_type IN
3383: ra_customer_trx_lines.line_type%type DEFAULT NULL)
3384: IS
3385:

Line 3383: ra_customer_trx_lines.line_type%type DEFAULT NULL)

3379: ra_customer_trx.customer_trx_id%type,
3380: p_link_to_cust_trx_line_id IN
3381: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
3382: p_line_type IN
3383: ra_customer_trx_lines.line_type%type DEFAULT NULL)
3384: IS
3385:
3386: BEGIN
3387:

Line 3392: DELETE FROM ra_customer_trx_lines

3388: IF PG_DEBUG in ('Y', 'C') THEN
3389: arp_util.debug( 'arp_ctl_pkg.delete_f_ct_ltctl_id_type()+');
3390: END IF;
3391:
3392: DELETE FROM ra_customer_trx_lines
3393: WHERE customer_trx_id = p_customer_trx_id
3394: AND decode(p_link_to_cust_trx_line_id,
3395: null, -99,
3396: customer_trx_line_id) = nvl(p_link_to_cust_trx_line_id, -99)

Line 3424: | This procedure updates the ra_customer_trx_lines row identified by the |

3420: | PROCEDURE |
3421: | update_p |
3422: | |
3423: | DESCRIPTION |
3424: | This procedure updates the ra_customer_trx_lines row identified by the |
3425: | p_customer_trx_line_id parameter. |
3426: | |
3427: | SCOPE - PUBLIC |
3428: | |

Line 3450: PROCEDURE update_p( p_line_rec IN ra_customer_trx_lines%rowtype,

3446: | 06-JUN-95 Charlie Tomberg Created |
3447: | |
3448: +===========================================================================*/
3449:
3450: PROCEDURE update_p( p_line_rec IN ra_customer_trx_lines%rowtype,
3451: p_customer_trx_line_id IN
3452: ra_customer_trx_lines.customer_trx_line_id%type,
3453: p_currency_code IN fnd_currencies.currency_code%type
3454: DEFAULT NULL ) IS

Line 3452: ra_customer_trx_lines.customer_trx_line_id%type,

3448: +===========================================================================*/
3449:
3450: PROCEDURE update_p( p_line_rec IN ra_customer_trx_lines%rowtype,
3451: p_customer_trx_line_id IN
3452: ra_customer_trx_lines.customer_trx_line_id%type,
3453: p_currency_code IN fnd_currencies.currency_code%type
3454: DEFAULT NULL ) IS
3455:
3456: l_currency_code fnd_currencies.currency_code%type;

Line 3474: ra_customer_trx_lines ctl

3470: THEN
3471: SELECT ct.invoice_currency_code
3472: INTO l_currency_code
3473: FROM ra_customer_trx ct,
3474: ra_customer_trx_lines ctl
3475: WHERE ct.customer_trx_id = ctl.customer_trx_id
3476: AND ctl.customer_trx_line_id = p_customer_trx_line_id;
3477: ELSE l_currency_code := p_currency_code;
3478: END IF;

Line 3518: | This procedure updates the ra_customer_trx_lines rows identified by the|

3514: | PROCEDURE |
3515: | update_f_ct_id |
3516: | |
3517: | DESCRIPTION |
3518: | This procedure updates the ra_customer_trx_lines rows identified by the|
3519: | p_customer_trx_id parameter. |
3520: | |
3521: | SCOPE - PUBLIC |
3522: | |

Line 3545: PROCEDURE update_f_ct_id( p_line_rec IN ra_customer_trx_lines%rowtype,

3541: | 06-JUN-95 Charlie Tomberg Created |
3542: | |
3543: +===========================================================================*/
3544:
3545: PROCEDURE update_f_ct_id( p_line_rec IN ra_customer_trx_lines%rowtype,
3546: p_customer_trx_id IN
3547: ra_customer_trx_lines.customer_trx_id%type,
3548: p_line_type IN
3549: ra_customer_trx_lines.line_type%type default null,

Line 3547: ra_customer_trx_lines.customer_trx_id%type,

3543: +===========================================================================*/
3544:
3545: PROCEDURE update_f_ct_id( p_line_rec IN ra_customer_trx_lines%rowtype,
3546: p_customer_trx_id IN
3547: ra_customer_trx_lines.customer_trx_id%type,
3548: p_line_type IN
3549: ra_customer_trx_lines.line_type%type default null,
3550: p_currency_code IN fnd_currencies.currency_code%type
3551: DEFAULT NULL) IS

Line 3549: ra_customer_trx_lines.line_type%type default null,

3545: PROCEDURE update_f_ct_id( p_line_rec IN ra_customer_trx_lines%rowtype,
3546: p_customer_trx_id IN
3547: ra_customer_trx_lines.customer_trx_id%type,
3548: p_line_type IN
3549: ra_customer_trx_lines.line_type%type default null,
3550: p_currency_code IN fnd_currencies.currency_code%type
3551: DEFAULT NULL) IS
3552:
3553: l_where varchar2(500);

Line 3621: | This procedure updates the amounts in a record in ra_customer_trx_lines|

3617: | PROCEDURE |
3618: | update_amount_f_ctl_id |
3619: | |
3620: | DESCRIPTION |
3621: | This procedure updates the amounts in a record in ra_customer_trx_lines|
3622: | The columns affected are: extended_amount, unit_selling_price, |
3623: | gross_extended_amount, and gross_unit_selling_price. |
3624: | These are adjustments made for inclusive tax amounts. |
3625: | This function is used when the amounts are gross of inclusive tax. |

Line 3664: ra_customer_trx_lines

3660: gross_extended_amount,
3661: gross_unit_selling_price,
3662: revenue_amount
3663: from
3664: ra_customer_trx_lines
3665: where
3666: customer_trx_line_id = p_customer_trx_line_id for update;
3667: crow c%rowtype;
3668: l_extended_amount ra_customer_trx_lines.extended_amount%type;

Line 3668: l_extended_amount ra_customer_trx_lines.extended_amount%type;

3664: ra_customer_trx_lines
3665: where
3666: customer_trx_line_id = p_customer_trx_line_id for update;
3667: crow c%rowtype;
3668: l_extended_amount ra_customer_trx_lines.extended_amount%type;
3669: l_unit_selling_price ra_customer_trx_lines.unit_selling_price%type;
3670: l_gross_extended_amount ra_customer_trx_lines.gross_extended_amount%type;
3671: l_gross_unit_selling_price ra_customer_trx_lines.gross_unit_selling_price%type;
3672: l_revenue_amount ra_customer_trx_lines.revenue_amount%type;

Line 3669: l_unit_selling_price ra_customer_trx_lines.unit_selling_price%type;

3665: where
3666: customer_trx_line_id = p_customer_trx_line_id for update;
3667: crow c%rowtype;
3668: l_extended_amount ra_customer_trx_lines.extended_amount%type;
3669: l_unit_selling_price ra_customer_trx_lines.unit_selling_price%type;
3670: l_gross_extended_amount ra_customer_trx_lines.gross_extended_amount%type;
3671: l_gross_unit_selling_price ra_customer_trx_lines.gross_unit_selling_price%type;
3672: l_revenue_amount ra_customer_trx_lines.revenue_amount%type;
3673: l_old_inclusive_amt ra_customer_trx_lines.extended_amount%type;

Line 3670: l_gross_extended_amount ra_customer_trx_lines.gross_extended_amount%type;

3666: customer_trx_line_id = p_customer_trx_line_id for update;
3667: crow c%rowtype;
3668: l_extended_amount ra_customer_trx_lines.extended_amount%type;
3669: l_unit_selling_price ra_customer_trx_lines.unit_selling_price%type;
3670: l_gross_extended_amount ra_customer_trx_lines.gross_extended_amount%type;
3671: l_gross_unit_selling_price ra_customer_trx_lines.gross_unit_selling_price%type;
3672: l_revenue_amount ra_customer_trx_lines.revenue_amount%type;
3673: l_old_inclusive_amt ra_customer_trx_lines.extended_amount%type;
3674: l_qty ra_customer_trx_lines.quantity_invoiced%type;

Line 3671: l_gross_unit_selling_price ra_customer_trx_lines.gross_unit_selling_price%type;

3667: crow c%rowtype;
3668: l_extended_amount ra_customer_trx_lines.extended_amount%type;
3669: l_unit_selling_price ra_customer_trx_lines.unit_selling_price%type;
3670: l_gross_extended_amount ra_customer_trx_lines.gross_extended_amount%type;
3671: l_gross_unit_selling_price ra_customer_trx_lines.gross_unit_selling_price%type;
3672: l_revenue_amount ra_customer_trx_lines.revenue_amount%type;
3673: l_old_inclusive_amt ra_customer_trx_lines.extended_amount%type;
3674: l_qty ra_customer_trx_lines.quantity_invoiced%type;
3675: begin

Line 3672: l_revenue_amount ra_customer_trx_lines.revenue_amount%type;

3668: l_extended_amount ra_customer_trx_lines.extended_amount%type;
3669: l_unit_selling_price ra_customer_trx_lines.unit_selling_price%type;
3670: l_gross_extended_amount ra_customer_trx_lines.gross_extended_amount%type;
3671: l_gross_unit_selling_price ra_customer_trx_lines.gross_unit_selling_price%type;
3672: l_revenue_amount ra_customer_trx_lines.revenue_amount%type;
3673: l_old_inclusive_amt ra_customer_trx_lines.extended_amount%type;
3674: l_qty ra_customer_trx_lines.quantity_invoiced%type;
3675: begin
3676: IF PG_DEBUG in ('Y', 'C') THEN

Line 3673: l_old_inclusive_amt ra_customer_trx_lines.extended_amount%type;

3669: l_unit_selling_price ra_customer_trx_lines.unit_selling_price%type;
3670: l_gross_extended_amount ra_customer_trx_lines.gross_extended_amount%type;
3671: l_gross_unit_selling_price ra_customer_trx_lines.gross_unit_selling_price%type;
3672: l_revenue_amount ra_customer_trx_lines.revenue_amount%type;
3673: l_old_inclusive_amt ra_customer_trx_lines.extended_amount%type;
3674: l_qty ra_customer_trx_lines.quantity_invoiced%type;
3675: begin
3676: IF PG_DEBUG in ('Y', 'C') THEN
3677: arp_util.debug( 'arp_ctl_pkg.update_amount_f_ctl_id('

Line 3674: l_qty ra_customer_trx_lines.quantity_invoiced%type;

3670: l_gross_extended_amount ra_customer_trx_lines.gross_extended_amount%type;
3671: l_gross_unit_selling_price ra_customer_trx_lines.gross_unit_selling_price%type;
3672: l_revenue_amount ra_customer_trx_lines.revenue_amount%type;
3673: l_old_inclusive_amt ra_customer_trx_lines.extended_amount%type;
3674: l_qty ra_customer_trx_lines.quantity_invoiced%type;
3675: begin
3676: IF PG_DEBUG in ('Y', 'C') THEN
3677: arp_util.debug( 'arp_ctl_pkg.update_amount_f_ctl_id('
3678: || to_char(p_customer_trx_line_id) || ','

Line 3728: update ra_customer_trx_lines

3724: l_gross_extended_amount := NULL;
3725: l_gross_unit_selling_price := NULL;
3726: END IF;
3727:
3728: update ra_customer_trx_lines
3729: set
3730: extended_amount = l_extended_amount,
3731: unit_selling_price = l_unit_selling_price,
3732: gross_extended_amount = l_gross_extended_amount,

Line 3767: | This procedure updates the amounts in a record in ra_customer_trx_lines|

3763: | PROCEDURE |
3764: | update_cm_amount_f_ctl_id |
3765: | |
3766: | DESCRIPTION |
3767: | This procedure updates the amounts in a record in ra_customer_trx_lines|
3768: | The columns affected are: extended_amount, unit_selling_price, |
3769: | gross_extended_amount, and gross_unit_selling_price. |
3770: | These are adjustments made for inclusive tax amounts. |
3771: | This function is used when the amounts are net of inclusive tax. |

Line 3804: ra_customer_trx_lines cm

3800: cm.gross_extended_amount gross_extended_amount,
3801: cm.gross_unit_selling_price gross_unit_selling_price,
3802: cm.previous_customer_trx_line_id previous_customer_trx_line_id
3803: from
3804: ra_customer_trx_lines cm
3805: where
3806: customer_trx_line_id = p_customer_trx_line_id for update;
3807: cursor cinv(p_line_id IN number) is select
3808: inv.gross_unit_selling_price gross_unit_selling_price

Line 3810: ra_customer_trx_lines inv

3806: customer_trx_line_id = p_customer_trx_line_id for update;
3807: cursor cinv(p_line_id IN number) is select
3808: inv.gross_unit_selling_price gross_unit_selling_price
3809: from
3810: ra_customer_trx_lines inv
3811: where
3812: customer_trx_line_id = p_line_id;
3813:
3814: crow c%rowtype;

Line 3815: l_extended_amount ra_customer_trx_lines.extended_amount%type;

3811: where
3812: customer_trx_line_id = p_line_id;
3813:
3814: crow c%rowtype;
3815: l_extended_amount ra_customer_trx_lines.extended_amount%type;
3816: l_unit_selling_price ra_customer_trx_lines.unit_selling_price%type;
3817: l_gross_extended_amount ra_customer_trx_lines.gross_extended_amount%type;
3818: l_gross_unit_selling_price ra_customer_trx_lines.gross_unit_selling_price%type;
3819: l_revenue_amount ra_customer_trx_lines.revenue_amount%type;

Line 3816: l_unit_selling_price ra_customer_trx_lines.unit_selling_price%type;

3812: customer_trx_line_id = p_line_id;
3813:
3814: crow c%rowtype;
3815: l_extended_amount ra_customer_trx_lines.extended_amount%type;
3816: l_unit_selling_price ra_customer_trx_lines.unit_selling_price%type;
3817: l_gross_extended_amount ra_customer_trx_lines.gross_extended_amount%type;
3818: l_gross_unit_selling_price ra_customer_trx_lines.gross_unit_selling_price%type;
3819: l_revenue_amount ra_customer_trx_lines.revenue_amount%type;
3820: l_old_inclusive_amt ra_customer_trx_lines.extended_amount%type;

Line 3817: l_gross_extended_amount ra_customer_trx_lines.gross_extended_amount%type;

3813:
3814: crow c%rowtype;
3815: l_extended_amount ra_customer_trx_lines.extended_amount%type;
3816: l_unit_selling_price ra_customer_trx_lines.unit_selling_price%type;
3817: l_gross_extended_amount ra_customer_trx_lines.gross_extended_amount%type;
3818: l_gross_unit_selling_price ra_customer_trx_lines.gross_unit_selling_price%type;
3819: l_revenue_amount ra_customer_trx_lines.revenue_amount%type;
3820: l_old_inclusive_amt ra_customer_trx_lines.extended_amount%type;
3821: begin

Line 3818: l_gross_unit_selling_price ra_customer_trx_lines.gross_unit_selling_price%type;

3814: crow c%rowtype;
3815: l_extended_amount ra_customer_trx_lines.extended_amount%type;
3816: l_unit_selling_price ra_customer_trx_lines.unit_selling_price%type;
3817: l_gross_extended_amount ra_customer_trx_lines.gross_extended_amount%type;
3818: l_gross_unit_selling_price ra_customer_trx_lines.gross_unit_selling_price%type;
3819: l_revenue_amount ra_customer_trx_lines.revenue_amount%type;
3820: l_old_inclusive_amt ra_customer_trx_lines.extended_amount%type;
3821: begin
3822: IF PG_DEBUG in ('Y', 'C') THEN

Line 3819: l_revenue_amount ra_customer_trx_lines.revenue_amount%type;

3815: l_extended_amount ra_customer_trx_lines.extended_amount%type;
3816: l_unit_selling_price ra_customer_trx_lines.unit_selling_price%type;
3817: l_gross_extended_amount ra_customer_trx_lines.gross_extended_amount%type;
3818: l_gross_unit_selling_price ra_customer_trx_lines.gross_unit_selling_price%type;
3819: l_revenue_amount ra_customer_trx_lines.revenue_amount%type;
3820: l_old_inclusive_amt ra_customer_trx_lines.extended_amount%type;
3821: begin
3822: IF PG_DEBUG in ('Y', 'C') THEN
3823: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id('

Line 3820: l_old_inclusive_amt ra_customer_trx_lines.extended_amount%type;

3816: l_unit_selling_price ra_customer_trx_lines.unit_selling_price%type;
3817: l_gross_extended_amount ra_customer_trx_lines.gross_extended_amount%type;
3818: l_gross_unit_selling_price ra_customer_trx_lines.gross_unit_selling_price%type;
3819: l_revenue_amount ra_customer_trx_lines.revenue_amount%type;
3820: l_old_inclusive_amt ra_customer_trx_lines.extended_amount%type;
3821: begin
3822: IF PG_DEBUG in ('Y', 'C') THEN
3823: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id('
3824: || to_char(p_customer_trx_line_id) || ','

Line 3890: update ra_customer_trx_lines

3886: * 100 * p_min_acct_unit;
3887: end if;
3888: end if;
3889:
3890: update ra_customer_trx_lines
3891: set
3892: gross_extended_amount = l_gross_extended_amount,
3893: gross_unit_selling_price = l_gross_unit_selling_price
3894: where current of c;

Line 3928: | This procedure inserts a row into ra_customer_trx_lines that contains |

3924: | PROCEDURE |
3925: | insert_p |
3926: | |
3927: | DESCRIPTION |
3928: | This procedure inserts a row into ra_customer_trx_lines that contains |
3929: | the column values specified in the p_trx_rec parameter. |
3930: | |
3931: | SCOPE - PUBLIC |
3932: | |

Line 3982: p_line_rec IN ra_customer_trx_lines%rowtype,

3978: | commented the changes for Bug 4410461
3979: +===========================================================================*/
3980:
3981: PROCEDURE insert_p(
3982: p_line_rec IN ra_customer_trx_lines%rowtype,
3983: p_customer_trx_line_id OUT NOCOPY
3984: ra_customer_trx_lines.customer_trx_line_id%type
3985: ) IS
3986:

Line 3984: ra_customer_trx_lines.customer_trx_line_id%type

3980:
3981: PROCEDURE insert_p(
3982: p_line_rec IN ra_customer_trx_lines%rowtype,
3983: p_customer_trx_line_id OUT NOCOPY
3984: ra_customer_trx_lines.customer_trx_line_id%type
3985: ) IS
3986:
3987:
3988: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;

Line 3988: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;

3984: ra_customer_trx_lines.customer_trx_line_id%type
3985: ) IS
3986:
3987:
3988: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
3989: l_revenue_amount ra_customer_trx_lines.revenue_amount%TYPE;
3990:
3991: BEGIN
3992:

Line 3989: l_revenue_amount ra_customer_trx_lines.revenue_amount%TYPE;

3985: ) IS
3986:
3987:
3988: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
3989: l_revenue_amount ra_customer_trx_lines.revenue_amount%TYPE;
3990:
3991: BEGIN
3992:
3993: IF PG_DEBUG in ('Y', 'C') THEN

Line 4004: SELECT RA_CUSTOMER_TRX_LINES_S.NEXTVAL

4000: | Get the unique identifier |
4001: *---------------------------*/
4002: /* Bug 4410461 FP for 4340099: Added the If Condition below */
4003: IF p_line_rec.customer_trx_line_id is null THEN
4004: SELECT RA_CUSTOMER_TRX_LINES_S.NEXTVAL
4005: INTO l_customer_trx_line_id
4006: FROM DUAL;
4007: ELSE l_customer_trx_line_id := p_line_rec.customer_trx_line_id ;
4008: END IF ;

Line 4026: INSERT INTO ra_customer_trx_lines

4022: END IF;
4023: END IF;
4024:
4025:
4026: INSERT INTO ra_customer_trx_lines
4027: (
4028: customer_trx_line_id,
4029: customer_trx_id,
4030: line_number,

Line 4345: p_line_rec IN ra_customer_trx_lines%rowtype) IS

4341: | 19-JUL-95 Subash C Created |
4342: | |
4343: +===========================================================================*/
4344: PROCEDURE display_line_rec(
4345: p_line_rec IN ra_customer_trx_lines%rowtype) IS
4346: BEGIN
4347: IF PG_DEBUG in ('Y', 'C') THEN
4348: arp_util.debug( 'arp_ctl_pkg.display_line_rec()+');
4349: END IF;

Line 4387: ra_customer_trx_lines.customer_trx_line_id%type) IS

4383: | |
4384: +===========================================================================*/
4385: PROCEDURE display_line_p(
4386: p_customer_trx_line_id IN
4387: ra_customer_trx_lines.customer_trx_line_id%type) IS
4388: BEGIN
4389: IF PG_DEBUG in ('Y', 'C') THEN
4390: arp_util.debug( 'arp_ctl_pkg.display_line_p()+');
4391: END IF;

Line 4432: ra_customer_trx_lines.link_to_cust_trx_line_id%type)

4428: +===========================================================================*/
4429:
4430:
4431: PROCEDURE display_line_f_lctl_id( p_link_to_cust_trx_line_id IN
4432: ra_customer_trx_lines.link_to_cust_trx_line_id%type)
4433: IS
4434: BEGIN
4435:
4436: IF PG_DEBUG in ('Y', 'C') THEN

Line 4557: p_old_line_rec IN ra_customer_trx_lines%rowtype,

4553: | support ship to at the line level |
4554: +===========================================================================*/
4555:
4556: PROCEDURE merge_line_recs(
4557: p_old_line_rec IN ra_customer_trx_lines%rowtype,
4558: p_new_line_rec IN
4559: ra_customer_trx_lines%rowtype,
4560: p_out_line_rec IN OUT NOCOPY
4561: ra_customer_trx_lines%rowtype)

Line 4559: ra_customer_trx_lines%rowtype,

4555:
4556: PROCEDURE merge_line_recs(
4557: p_old_line_rec IN ra_customer_trx_lines%rowtype,
4558: p_new_line_rec IN
4559: ra_customer_trx_lines%rowtype,
4560: p_out_line_rec IN OUT NOCOPY
4561: ra_customer_trx_lines%rowtype)
4562: IS
4563:

Line 4561: ra_customer_trx_lines%rowtype)

4557: p_old_line_rec IN ra_customer_trx_lines%rowtype,
4558: p_new_line_rec IN
4559: ra_customer_trx_lines%rowtype,
4560: p_out_line_rec IN OUT NOCOPY
4561: ra_customer_trx_lines%rowtype)
4562: IS
4563:
4564: BEGIN
4565:

Line 5412: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,

5408: | -ement the line level rounding logic.|
5409: +===========================================================================*/
5410: PROCEDURE insert_line_f_cm_ct_ctl_id(
5411: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
5412: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
5413: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
5414: p_line_type IN ra_customer_trx_lines.line_type%type,
5415: p_line_percent IN number,
5416: p_uncredited_amount IN ra_customer_trx_lines.extended_amount%type,

Line 5414: p_line_type IN ra_customer_trx_lines.line_type%type,

5410: PROCEDURE insert_line_f_cm_ct_ctl_id(
5411: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
5412: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
5413: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
5414: p_line_type IN ra_customer_trx_lines.line_type%type,
5415: p_line_percent IN number,
5416: p_uncredited_amount IN ra_customer_trx_lines.extended_amount%type,
5417: p_credit_amount IN ra_customer_trx_lines.extended_amount%type,
5418: p_currency_code IN fnd_currencies.currency_code%type,

Line 5416: p_uncredited_amount IN ra_customer_trx_lines.extended_amount%type,

5412: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
5413: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
5414: p_line_type IN ra_customer_trx_lines.line_type%type,
5415: p_line_percent IN number,
5416: p_uncredited_amount IN ra_customer_trx_lines.extended_amount%type,
5417: p_credit_amount IN ra_customer_trx_lines.extended_amount%type,
5418: p_currency_code IN fnd_currencies.currency_code%type,
5419: p_tax_amount IN ra_customer_trx_lines.extended_amount%type)
5420: IS

Line 5417: p_credit_amount IN ra_customer_trx_lines.extended_amount%type,

5413: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
5414: p_line_type IN ra_customer_trx_lines.line_type%type,
5415: p_line_percent IN number,
5416: p_uncredited_amount IN ra_customer_trx_lines.extended_amount%type,
5417: p_credit_amount IN ra_customer_trx_lines.extended_amount%type,
5418: p_currency_code IN fnd_currencies.currency_code%type,
5419: p_tax_amount IN ra_customer_trx_lines.extended_amount%type)
5420: IS
5421: l_rows_inserted number;

Line 5419: p_tax_amount IN ra_customer_trx_lines.extended_amount%type)

5415: p_line_percent IN number,
5416: p_uncredited_amount IN ra_customer_trx_lines.extended_amount%type,
5417: p_credit_amount IN ra_customer_trx_lines.extended_amount%type,
5418: p_currency_code IN fnd_currencies.currency_code%type,
5419: p_tax_amount IN ra_customer_trx_lines.extended_amount%type)
5420: IS
5421: l_rows_inserted number;
5422: --{BUG#3339072
5423: l_trx_line_array ctlrec;

Line 5433: l_total_tax_prorate ra_customer_trx_lines.extended_amount%type := 0;

5429: l_amt_prev_run_total Number ;
5430: l_rev_run_total Number ;
5431: l_rev_prev_run_total Number ;
5432: /* Bug Number 6790882 */
5433: l_total_tax_prorate ra_customer_trx_lines.extended_amount%type := 0;
5434: l_tax_amount ra_customer_trx_lines.extended_amount%type;
5435: l_quantity_invoiced Number ;
5436: l_round Number ;
5437: l_qnt_temp Number;

Line 5434: l_tax_amount ra_customer_trx_lines.extended_amount%type;

5430: l_rev_run_total Number ;
5431: l_rev_prev_run_total Number ;
5432: /* Bug Number 6790882 */
5433: l_total_tax_prorate ra_customer_trx_lines.extended_amount%type := 0;
5434: l_tax_amount ra_customer_trx_lines.extended_amount%type;
5435: l_quantity_invoiced Number ;
5436: l_round Number ;
5437: l_qnt_temp Number;
5438:

Line 5442: FROM ra_customer_trx_lines

5438:
5439: --bug 9125212
5440: cursor c1(c_prev_customer_trx_line_id number) is
5441: select quantity_invoiced
5442: FROM ra_customer_trx_lines
5443: WHERE customer_trx_line_id=c_prev_customer_trx_line_id;
5444: BEGIN
5445:
5446: IF PG_DEBUG in ('Y', 'C') THEN

Line 5463: SELECT ra_customer_trx_lines_s.nextval,

5459: END IF;
5460:
5461: --{BUG#3339072
5462: -- Bug 10169170, Modified the following query to add an Order By clause.
5463: SELECT ra_customer_trx_lines_s.nextval,
5464: p_customer_trx_id,
5465: pg_user_id, /* created_by */
5466: sysdate, /* creation_date */
5467: pg_user_id, /* last_updated_by */

Line 5719: FROM ra_customer_trx_lines inv_ctl,

5715: /* NULL=Y N=not historical, calc tax */
5716: /* N - New CM line is created */
5717: ,NVL(inv_ctl.historical_flag,'N') historical_flag
5718: ,inv_ctl_memo.line_type memo_line_type
5719: FROM ra_customer_trx_lines inv_ctl,
5720: ra_customer_trx_lines cm_ctl,
5721: ra_customer_trx cm_ct,
5722: ar_net_revenue_amount nra,
5723: ar_memo_lines_b inv_ctl_memo

Line 5720: ra_customer_trx_lines cm_ctl,

5716: /* N - New CM line is created */
5717: ,NVL(inv_ctl.historical_flag,'N') historical_flag
5718: ,inv_ctl_memo.line_type memo_line_type
5719: FROM ra_customer_trx_lines inv_ctl,
5720: ra_customer_trx_lines cm_ctl,
5721: ra_customer_trx cm_ct,
5722: ar_net_revenue_amount nra,
5723: ar_memo_lines_b inv_ctl_memo
5724: WHERE cm_ct.customer_trx_id = p_customer_trx_id

Line 5917: INSERT INTO ra_customer_trx_lines

5913: --{BUG#3339072
5914: IF l_rows_inserted <> 0 THEN
5915: FORALL indx IN l_trx_line_array.customer_trx_line_id.FIRST ..
5916: l_trx_line_array.customer_trx_line_id.LAST
5917: INSERT INTO ra_customer_trx_lines
5918: ( customer_trx_line_id,
5919: customer_trx_id,
5920: created_by,
5921: creation_date,

Line 6155: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,

6151: | |
6152: +===========================================================================*/
6153: PROCEDURE update_line_f_cm_ctl_id(
6154: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
6155: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
6156: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
6157: p_line_type IN ra_customer_trx_lines.line_type%type,
6158: p_uncredited_amount IN ra_customer_trx_lines.extended_amount%type,
6159: p_credit_amount IN ra_customer_trx_lines.extended_amount%type,

Line 6157: p_line_type IN ra_customer_trx_lines.line_type%type,

6153: PROCEDURE update_line_f_cm_ctl_id(
6154: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
6155: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
6156: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
6157: p_line_type IN ra_customer_trx_lines.line_type%type,
6158: p_uncredited_amount IN ra_customer_trx_lines.extended_amount%type,
6159: p_credit_amount IN ra_customer_trx_lines.extended_amount%type,
6160: p_currency_code IN fnd_currencies.currency_code%type)
6161: IS

Line 6158: p_uncredited_amount IN ra_customer_trx_lines.extended_amount%type,

6154: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
6155: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
6156: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
6157: p_line_type IN ra_customer_trx_lines.line_type%type,
6158: p_uncredited_amount IN ra_customer_trx_lines.extended_amount%type,
6159: p_credit_amount IN ra_customer_trx_lines.extended_amount%type,
6160: p_currency_code IN fnd_currencies.currency_code%type)
6161: IS
6162: l_rows_updated number;

Line 6159: p_credit_amount IN ra_customer_trx_lines.extended_amount%type,

6155: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
6156: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
6157: p_line_type IN ra_customer_trx_lines.line_type%type,
6158: p_uncredited_amount IN ra_customer_trx_lines.extended_amount%type,
6159: p_credit_amount IN ra_customer_trx_lines.extended_amount%type,
6160: p_currency_code IN fnd_currencies.currency_code%type)
6161: IS
6162: l_rows_updated number;
6163: BEGIN

Line 6169: UPDATE ra_customer_trx_lines ctl

6165: IF PG_DEBUG in ('Y', 'C') THEN
6166: arp_util.debug( 'arp_ctl_pkg.update_line_f_cm_ctl_id()+');
6167: END IF;
6168:
6169: UPDATE ra_customer_trx_lines ctl
6170: SET extended_amount =
6171: (SELECT ( (nra.net_amount -
6172: decode(cm_ct.complete_flag,
6173: 'Y', nvl(ctl.extended_amount, 0),

Line 6195: UPDATE ra_customer_trx_lines ctl

6191: arp_util.debug( 'arp_ctl_pkg.update_line_f_cm_ctl_id : '||
6192: 'Extended Amount :'|| SQL%ROWCOUNT||' rows updated');
6193: END IF;
6194:
6195: UPDATE ra_customer_trx_lines ctl
6196: SET extended_amount = arpcurr.CurrRound (extended_amount,
6197: p_currency_code)
6198: WHERE ctl.customer_trx_id = p_customer_trx_id
6199: AND ctl.link_to_cust_trx_line_id = p_customer_trx_line_id

Line 6213: UPDATE ra_customer_trx_lines l

6209: +----------------------------*/
6210:
6211: IF (SQL%ROWCOUNT > 0)
6212: THEN
6213: UPDATE ra_customer_trx_lines l
6214: SET extended_amount =
6215: (SELECT l.extended_amount +
6216: (p_credit_amount - sum(l2.extended_amount))
6217: FROM ra_customer_trx_lines l2

Line 6217: FROM ra_customer_trx_lines l2

6213: UPDATE ra_customer_trx_lines l
6214: SET extended_amount =
6215: (SELECT l.extended_amount +
6216: (p_credit_amount - sum(l2.extended_amount))
6217: FROM ra_customer_trx_lines l2
6218: WHERE l2.customer_trx_id = l.customer_trx_id
6219: AND l2.link_to_cust_trx_line_id = p_customer_trx_line_id
6220: AND l2.line_type = p_line_type)
6221: WHERE l.customer_trx_id = p_customer_trx_id

Line 6225: FROM ra_customer_trx_lines l3

6221: WHERE l.customer_trx_id = p_customer_trx_id
6222: AND l.line_type = p_line_type
6223: AND l.customer_trx_line_id =
6224: (SELECT min(customer_trx_line_id)
6225: FROM ra_customer_trx_lines l3
6226: WHERE l3.customer_trx_id = p_customer_trx_id
6227: AND l3.link_to_cust_trx_line_id = p_customer_trx_line_id
6228: AND l3.line_type = p_line_type
6229: AND l3.extended_amount <> 0