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_APPLICATION dependencies on ARP_APP_PKG

Line 161: | arp_app_pkg.fetch_p - Fetch a record from |

157: | |
158: | SCOPE - PUBLIC |
159: | |
160: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
161: | arp_app_pkg.fetch_p - Fetch a record from |
162: | AR_RECEIVABLE_APPLICATIONS table |
163: | arp_app_pkg.lock_p - lock a record in |
164: | AR_RECEIVABLE_APPLICATIONS table |
165: | |

Line 163: | arp_app_pkg.lock_p - lock a record in |

159: | |
160: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
161: | arp_app_pkg.fetch_p - Fetch a record from |
162: | AR_RECEIVABLE_APPLICATIONS table |
163: | arp_app_pkg.lock_p - lock a record in |
164: | AR_RECEIVABLE_APPLICATIONS table |
165: | |
166: | ARGUMENTS : IN: |
167: | p_ra_id - Id of application to be reversed |

Line 231: arp_app_pkg.lock_p( p_ra_id );

227: -- ar_receivable_applications table.
228:
229: --Bug:4068781
230: BEGIN
231: arp_app_pkg.lock_p( p_ra_id );
232: EXCEPTION
233: WHEN OTHERS
234: THEN
235: FND_MESSAGE.SET_NAME( 'FND', 'FND_LOCK_RECORD_ERROR');

Line 240: arp_app_pkg.fetch_p( p_ra_id, l_ra_rec );

236: FND_MSG_PUB.Add;
237: APP_EXCEPTION.raise_exception;
238: END;
239:
240: arp_app_pkg.fetch_p( p_ra_id, l_ra_rec );
241: --apandit Bug : 2641517
242: l_status := l_ra_rec.status;
243:
244: -- get the payment schedule id of the trx that receipt was

Line 555: | arp_app_pkg.fetch_p - Fetch a record from

551: | |
552: | SCOPE - PUBLIC |
553: | |
554: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
555: | arp_app_pkg.fetch_p - Fetch a record from
556: | AR_RECEIVABLE_APPLICATIONS table
557: | |
558: | ARGUMENTS : IN: |
559: | pn_ra_id Id of application to be reversed

Line 610: arp_app_pkg.lock_p( pn_ra_id );

606: -- for selection.
607:
608: --Bug:4068781
609: BEGIN
610: arp_app_pkg.lock_p( pn_ra_id );
611: EXCEPTION
612: WHEN OTHERS
613: THEN
614: FND_MESSAGE.SET_NAME( 'FND', 'FND_LOCK_RECORD_ERROR');

Line 619: arp_app_pkg.fetch_p( pn_ra_id, lr_ra_rec );

615: FND_MSG_PUB.Add;
616: APP_EXCEPTION.raise_exception;
617: END;
618:
619: arp_app_pkg.fetch_p( pn_ra_id, lr_ra_rec );
620:
621: -- need some information to check if we have a regular cm or
622: -- on acct credit memo also if we have invoice with rules.
623: -- to do some processing before the application is reversed.

Line 939: arp_app_pkg.lock_p( pn_ra_id );

935: -- for selection.
936:
937: --Bug:4068781
938: BEGIN
939: arp_app_pkg.lock_p( pn_ra_id );
940: EXCEPTION
941: WHEN OTHERS
942: THEN
943: FND_MESSAGE.SET_NAME( 'FND', 'FND_LOCK_RECORD_ERROR');

Line 947: arp_app_pkg.fetch_p( pn_ra_id, lr_ra_rec );

943: FND_MESSAGE.SET_NAME( 'FND', 'FND_LOCK_RECORD_ERROR');
944: FND_MSG_PUB.Add;
945: APP_EXCEPTION.raise_exception;
946: END;
947: arp_app_pkg.fetch_p( pn_ra_id, lr_ra_rec );
948:
949: -- Before we update the APP row, we need to calculate the change in amount
950: -- so we can update the UNAPP row for the cash receipt.
951: IF lr_ra_rec.amount_applied <> pn_amount_applied THEN

Line 1025: arp_app_pkg.update_p(lr_ra_rec);

1021: lr_ra_rec.global_attribute18 := p_global_attribute18;
1022: lr_ra_rec.global_attribute19 := p_global_attribute19;
1023: lr_ra_rec.global_attribute20 := p_global_attribute20;
1024:
1025: arp_app_pkg.update_p(lr_ra_rec);
1026:
1027: l_app_ra_rec := lr_ra_rec;
1028: --------------------------------------------------------------------
1029: -- Now that we have updated the APP row we need to update the UNAPP

Line 1043: arp_app_pkg.lock_p( ln_unapp_ra_id );

1039: and ra.status = 'UNAPP';
1040:
1041: --Bug:4068781
1042: BEGIN
1043: arp_app_pkg.lock_p( ln_unapp_ra_id );
1044: EXCEPTION
1045: WHEN OTHERS
1046: THEN
1047: FND_MESSAGE.SET_NAME( 'FND', 'FND_LOCK_RECORD_ERROR');

Line 1053: arp_app_pkg.fetch_p( ln_unapp_ra_id, lr_ra_rec );

1049: APP_EXCEPTION.raise_exception;
1050: END;
1051:
1052: -- Fetch the UNAPP row.
1053: arp_app_pkg.fetch_p( ln_unapp_ra_id, lr_ra_rec );
1054:
1055: -- Set the amount with the new value.
1056: lr_ra_rec.amount_applied := lr_ra_rec.amount_applied - ln_amount_change;
1057:

Line 1068: arp_app_pkg.update_p(lr_ra_rec);

1064: , precision => NULL
1065: , min_acc_unit => NULL );
1066:
1067: -- Update the UNAPP row.
1068: arp_app_pkg.update_p(lr_ra_rec);
1069:
1070: -- Call MRC to replace receivable apps rows
1071: -- ar_mrc_engine3.update_selected_transaction(
1072: -- pn_amount_applied,

Line 1382: | arp_app_pkg.insert_p Table handler to insert into |

1378: | SCOPE - PRIVATE |
1379: | |
1380: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1381: | ARCIAPPS.pls |
1382: | arp_app_pkg.insert_p Table handler to insert into |
1383: | ar_receivable_applications table. |
1384: | |
1385: | ARGUMENTS : IN: |
1386: | p_ra_rec Receivables application record |

Line 1563: arp_app_pkg.insert_p( p_ra_rec, l_ra_id );

1559: ---------------------------------------------------
1560: -- Create the opposing receivable application row.
1561: --
1562: ---------------------------------------------------
1563: arp_app_pkg.insert_p( p_ra_rec, l_ra_id );
1564:
1565: -- Bug 7241111 Updating the ar_activity_details reversal record with RA IDs
1566:
1567: IF p_ra_rec.status = 'APP' or p_ra_rec.application_type = 'CASH' THEN

Line 1788: arp_app_pkg.insert_p(

1784: p_ra_rec.posting_control_id := -3;
1785: p_ra_rec.gl_posted_date := NULL;
1786:
1787: -- Call the table handler to insert the APP or ACC row.
1788: arp_app_pkg.insert_p(
1789: p_ra_rec -- IN
1790: , l_ra_id -- OUT NOCOPY
1791: );
1792:

Line 2096: arp_app_pkg.insert_p(

2092: arp_debug.debug(' l_ra_id = ' || l_ra_id);
2093: l_ra_id := NULL;
2094:
2095: -- Call the table handler to insert the UNAPP row.
2096: arp_app_pkg.insert_p(
2097: p_ra_rec -- IN
2098: , l_ra_id -- OUT NOCOPY
2099: );
2100:

Line 2203: | arp_app_pkg.update_p - table handler to update |

2199: | |
2200: | SCOPE - PUBLIC |
2201: | |
2202: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2203: | arp_app_pkg.update_p - table handler to update |
2204: | ar_receivable_applications table |
2205: | |
2206: | ARGUMENTS : IN: |
2207: | p_ra_rec - Receivables application record |

Line 2234: arp_app_pkg.update_p( p_ra_rec );

2230: ELSE
2231: p_ra_rec.reversal_gl_date := p_ra_rec.gl_date;
2232: END IF;
2233: --
2234: arp_app_pkg.update_p( p_ra_rec );
2235: --
2236: IF PG_DEBUG in ('Y', 'C') THEN
2237: arp_standard.debug('validate_args: ' || 'arp_process_application.reversal_update_old_ra_rec()-' );
2238: END IF;

Line 2320: arp_app_pkg.fetch_p(p_ra_id, l_ra_rec );

2316: IF PG_DEBUG in ('Y', 'C') THEN
2317: arp_standard.debug('validate_args: ' || 'arp_process_application.check_reversable()+' );
2318: END IF;
2319: --
2320: arp_app_pkg.fetch_p(p_ra_id, l_ra_rec );
2321:
2322: IF (SIGN(l_ra_rec.applied_payment_schedule_id) <> -1) THEN
2323:
2324: BEGIN

Line 3620: arp_app_pkg.insert_p( l_rec_ra_rec,

3616: --
3617: --
3618: IF nvl(p_called_from,'NONE') <> 'AUTORECAPI' THEN -- autorecapi bichatte project
3619:
3620: arp_app_pkg.insert_p( l_rec_ra_rec,
3621: l_rec_ra_rec.receivable_application_id );
3622:
3623: END IF;
3624:

Line 3930: arp_app_pkg.insert_p( l_inv_ra_rec,

3926: x_application_ref_num := l_inv_ra_rec.application_ref_num;
3927:
3928: -- Call the applications table handler to create the APP row.
3929: --
3930: arp_app_pkg.insert_p( l_inv_ra_rec,
3931: l_ra_app_id );
3932:
3933: /* 5677984 - copy l_ra_app_id into l_inv_ra_rec to preserve it for
3934: later processing */

Line 3937: arp_standard.debug('Calling arp_app_pkg.insert_p and created l_inv_ra_rec.receivable_application_id :'||

3933: /* 5677984 - copy l_ra_app_id into l_inv_ra_rec to preserve it for
3934: later processing */
3935: l_inv_ra_rec.receivable_application_id := l_ra_app_id;
3936:
3937: arp_standard.debug('Calling arp_app_pkg.insert_p and created l_inv_ra_rec.receivable_application_id :'||
3938: l_inv_ra_rec.receivable_application_id);
3939:
3940: --apandit
3941: --Bug : 2641517 raise Apply business event.

Line 4658: arp_app_pkg.insert_p( l_inv_ra_rec,

4654: --------------------------------------------------------------------------
4655: -- Create the APP row in receivable applications.
4656: --
4657: --------------------------------------------------------------------------
4658: arp_app_pkg.insert_p( l_inv_ra_rec,
4659: l_inv_ra_rec.receivable_application_id );
4660:
4661: IF l_inv_ra_rec.receivable_application_id IS NOT NULL THEN
4662: l_xla_ev_rec.xla_from_doc_id := l_inv_ra_rec.receivable_application_id;

Line 4794: | arp_app_pkg.insert_p - Insert a row into RA table |

4790: | |
4791: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - |
4792: | ARPCURR.functional_amount - Get the acctd amount of amount applied|
4793: | arp_ps_pkg.fetch_p - Fetch a PS row |
4794: | arp_app_pkg.insert_p - Insert a row into RA table |
4795: | |
4796: | ARGUMENTS : IN: |
4797: | p_ps_id - PS id of the receipt |
4798: | p_amount_applied - Input amount applied |

Line 5056: arp_app_pkg.insert_p( l_ra_rec, l_ra_rec.receivable_application_id );

5052:
5053: --
5054: -- Insert UNAPP record
5055: --
5056: arp_app_pkg.insert_p( l_ra_rec, l_ra_rec.receivable_application_id );
5057:
5058: IF l_ra_rec.receivable_application_id IS NOT NULL THEN
5059: l_xla_ev_rec.xla_from_doc_id := l_ra_rec.receivable_application_id;
5060: l_xla_ev_rec.xla_to_doc_id := l_ra_rec.receivable_application_id;

Line 5104: arp_app_pkg.insert_p( l_ra_rec, l_ra_rec.receivable_application_id );

5100: l_ra_rec.customer_reason := p_customer_reason; -- 4145224
5101:
5102: -- Insert ACC record
5103:
5104: arp_app_pkg.insert_p( l_ra_rec, l_ra_rec.receivable_application_id );
5105:
5106: IF l_ra_rec.receivable_application_id IS NOT NULL THEN
5107: l_xla_ev_rec.xla_from_doc_id := l_ra_rec.receivable_application_id;
5108: l_xla_ev_rec.xla_to_doc_id := l_ra_rec.receivable_application_id;

Line 5954: arp_app_pkg.insert_p( l_ra_rec, l_ra_rec.receivable_application_id );

5950: l_ra_rec.comments := p_comments;
5951:
5952:
5953: /* Insert UNAPP record */
5954: arp_app_pkg.insert_p( l_ra_rec, l_ra_rec.receivable_application_id );
5955:
5956: IF l_ra_rec.receivable_application_id IS NOT NULL THEN
5957: l_xla_ev_rec.xla_from_doc_id := l_ra_rec.receivable_application_id;
5958: l_xla_ev_rec.xla_to_doc_id := l_ra_rec.receivable_application_id;

Line 6030: arp_app_pkg.insert_p( l_ra_rec, l_ra_rec.receivable_application_id );

6026: l_ra_rec.amount_applied_from := p_amount_applied;
6027:
6028:
6029: /* Insert ACTIVITY record */
6030: arp_app_pkg.insert_p( l_ra_rec, l_ra_rec.receivable_application_id );
6031:
6032: IF l_ra_rec.receivable_application_id IS NOT NULL THEN
6033: l_xla_ev_rec.xla_from_doc_id := l_ra_rec.receivable_application_id;
6034: l_xla_ev_rec.xla_to_doc_id := l_ra_rec.receivable_application_id;

Line 6606: | arp_app_pkg.insert_p - Insert a row into RA table |

6602: | |
6603: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - |
6604: | ARPCURR.functional_amount - Get the acctd amount of amount applied|
6605: | arp_ps_pkg.fetch_p - Fetch a PS row |
6606: | arp_app_pkg.insert_p - Insert a row into RA table |
6607: | |
6608: | ARGUMENTS : IN: |
6609: | p_ps_id - PS id of the receipt |
6610: | p_amount_applied - Input amount applied |

Line 6951: arp_app_pkg.insert_p( l_ra_rec, l_ra_rec.receivable_application_id );

6947: l_ra_rec.comments := p_comments;
6948: --
6949: -- Insert UNAPP record
6950: --
6951: arp_app_pkg.insert_p( l_ra_rec, l_ra_rec.receivable_application_id );
6952:
6953: IF l_ra_rec.receivable_application_id IS NOT NULL THEN
6954: l_xla_ev_rec.xla_from_doc_id := l_ra_rec.receivable_application_id;
6955: l_xla_ev_rec.xla_to_doc_id := l_ra_rec.receivable_application_id;

Line 7094: arp_app_pkg.insert_p( l_ra_rec, l_ra_rec.receivable_application_id );

7090: x_application_ref_num := l_ra_rec.application_ref_num;
7091:
7092: -- Insert OTHER ACC record
7093:
7094: arp_app_pkg.insert_p( l_ra_rec, l_ra_rec.receivable_application_id );
7095:
7096: IF l_ra_rec.receivable_application_id IS NOT NULL THEN
7097: l_xla_ev_rec.xla_from_doc_id := l_ra_rec.receivable_application_id;
7098: l_xla_ev_rec.xla_to_doc_id := l_ra_rec.receivable_application_id;

Line 8164: | arp_app_pkg.insert_p - Insert a row into RA table |

8160: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - |
8161: | |
8162: | ARPCURR.functional_amount - Get the acctd amount of amount applied|
8163: | arp_ps_pkg.fetch_p - Fetch a PS row |
8164: | arp_app_pkg.insert_p - Insert a row into RA table |
8165: | |
8166: | ARGUMENTS : IN: |
8167: | p_cm_ps_id - PS id of the receipt |
8168: | p_application_ps_id - PS id of the special application |

Line 8439: arp_app_pkg.insert_p( l_inv_ra_rec,

8435: --------------------------------------------------------------------------
8436: -- Create the APP row in receivable applications.
8437: --
8438: --------------------------------------------------------------------------
8439: arp_app_pkg.insert_p( l_inv_ra_rec,
8440: l_receivable_application_id );
8441:
8442: l_inv_ra_rec.receivable_application_id := l_receivable_application_id;
8443: