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_PROCESS_BR_HEADER dependencies on RA_CUSTOMER_TRX

Line 8: PROCEDURE delete_transaction(p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE);

4: SUBTYPE ae_doc_rec_type IS arp_acct_main.ae_doc_rec_type;
5:
6: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
7:
8: PROCEDURE delete_transaction(p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE);
9: PROCEDURE delete_transaction_dist(p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE);
10:
11: /*===========================================================================+
12: | PROCEDURE |

Line 9: PROCEDURE delete_transaction_dist(p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE);

5:
6: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
7:
8: PROCEDURE delete_transaction(p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE);
9: PROCEDURE delete_transaction_dist(p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE);
10:
11: /*===========================================================================+
12: | PROCEDURE |
13: | |

Line 16: | Inserts a record into ra_customer_trx for bills receivable transaction |

12: | PROCEDURE |
13: | |
14: | |
15: | DESCRIPTION |
16: | Inserts a record into ra_customer_trx for bills receivable transaction |
17: | |
18: | SCOPE - PUBLIC |
19: | |
20: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 35: PROCEDURE insert_header(p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,

31: | 28-MAR-2000 Jani Rautiainen Created |
32: | |
33: +===========================================================================*/
34:
35: PROCEDURE insert_header(p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,
36: p_gl_date IN DATE,
37: p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,
38: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type) IS
39:

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

33: +===========================================================================*/
34:
35: PROCEDURE insert_header(p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,
36: p_gl_date IN DATE,
37: p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,
38: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type) IS
39:
40: l_trh_rec ar_transaction_history%ROWTYPE;
41: l_transaction_history_id ar_transaction_history.transaction_history_id%TYPE;

Line 38: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type) IS

34:
35: PROCEDURE insert_header(p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,
36: p_gl_date IN DATE,
37: p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,
38: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type) IS
39:
40: l_trh_rec ar_transaction_history%ROWTYPE;
41: l_transaction_history_id ar_transaction_history.transaction_history_id%TYPE;
42: BEGIN

Line 117: | Updates a record into ra_customer_trx for bills receivable transaction.|

113: | PROCEDURE |
114: | update_header |
115: | |
116: | DESCRIPTION |
117: | Updates a record into ra_customer_trx for bills receivable transaction.|
118: | |
119: | SCOPE - PUBLIC |
120: | |
121: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 135: PROCEDURE update_header(p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,

131: | 28-MAR-2000 Jani Rautiainen Created |
132: | |
133: +===========================================================================*/
134:
135: PROCEDURE update_header(p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,
136: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE) IS
137: BEGIN
138:
139: IF PG_DEBUG in ('Y', 'C') THEN

Line 136: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE) IS

132: | |
133: +===========================================================================*/
134:
135: PROCEDURE update_header(p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,
136: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE) IS
137: BEGIN
138:
139: IF PG_DEBUG in ('Y', 'C') THEN
140: arp_util.debug('delete_transaction: ' || 'arp_process_br_header.update_header()+');

Line 187: | Deletes row from ra_customer_trx for Bills Receivable Transaction. |

183: | PROCEDURE |
184: | delete_header |
185: | |
186: | DESCRIPTION |
187: | Deletes row from ra_customer_trx for Bills Receivable Transaction. |
188: | Also deletes all child rows. |
189: | |
190: | SCOPE - PUBLIC |
191: | |

Line 205: PROCEDURE delete_header(p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE) IS

201: | MODIFICATION HISTORY |
202: | 28-MAR-2000 Jani Rautiainen Created |
203: | |
204: +===========================================================================*/
205: PROCEDURE delete_header(p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE) IS
206: l_transaction_history_id NUMBER;
207: BEGIN
208:
209: IF PG_DEBUG in ('Y', 'C') THEN

Line 277: PROCEDURE delete_transaction(p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE) IS

273: | MODIFICATION HISTORY |
274: | 28-MAR-2000 Jani Rautiainen Created
275: | |
276: +===========================================================================*/
277: PROCEDURE delete_transaction(p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE) IS
278:
279: BEGIN
280:
281: IF PG_DEBUG in ('Y', 'C') THEN

Line 333: PROCEDURE lock_transaction(p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE) IS

329: | MODIFICATION HISTORY |
330: | 28-MAR-2000 Jani Rautiainen Created
331: | |
332: +===========================================================================*/
333: PROCEDURE lock_transaction(p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE) IS
334: BEGIN
335: IF PG_DEBUG in ('Y', 'C') THEN
336: arp_util.debug('delete_transaction: ' || 'arp_process_br_header.lock_transaction()+');
337: END IF;

Line 388: PROCEDURE delete_transaction_dist(p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE) IS

384: | MODIFICATION HISTORY |
385: | 28-MAR-2000 Jani Rautiainen Created |
386: | |
387: +===========================================================================*/
388: PROCEDURE delete_transaction_dist(p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE) IS
389:
390: /*----------------------------------------------------------------+
391: | Cursor for all transaction history rows that have accounting |
392: +----------------------------------------------------------------*/

Line 458: PROCEDURE move_deferred_tax(p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,

454: | MODIFICATION HISTORY |
455: | 31-AUG-2000 Jani Rautiainen Created |
456: | |
457: +===========================================================================*/
458: PROCEDURE move_deferred_tax(p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
459: p_required OUT NOCOPY BOOLEAN) IS
460:
461: CURSOR move_deferred_tax_cur IS
462: select 'Y' deferred_tax_moved

Line 465: from ra_customer_trx ct

461: CURSOR move_deferred_tax_cur IS
462: select 'Y' deferred_tax_moved
463: from dual
464: where exists (select 'x'
465: from ra_customer_trx ct
466: where ct.customer_trx_id IN (select distinct ctl.br_ref_customer_trx_id
467: from ra_customer_trx_lines ctl
468: start with ctl.customer_trx_id = p_customer_trx_id
469: connect by prior ctl.br_ref_customer_trx_id = ctl.customer_trx_id

Line 467: from ra_customer_trx_lines ctl

463: from dual
464: where exists (select 'x'
465: from ra_customer_trx ct
466: where ct.customer_trx_id IN (select distinct ctl.br_ref_customer_trx_id
467: from ra_customer_trx_lines ctl
468: start with ctl.customer_trx_id = p_customer_trx_id
469: connect by prior ctl.br_ref_customer_trx_id = ctl.customer_trx_id
470: )
471: and ct.drawee_site_use_id IS NULL