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_APP_PKG dependencies on AR_RECEIVABLE_APPLICATIONS

Line 30: | This function inserts a row into AR_RECEIVABLE_APPLICATIONS table |

26: | PROCEDURE |
27: | insert_p |
28: | |
29: | DESCRIPTION |
30: | This function inserts a row into AR_RECEIVABLE_APPLICATIONS table |
31: | |
32: | SCOPE - PUBLIC |
33: | |
34: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

Line 77: p_ra_rec IN ar_receivable_applications%ROWTYPE

73: | applied_rec_app_id |
74: | 07-DEC-2006 MRAYMOND 5677984 - changed p_ra_id from IN to IN/OUT
75: +===========================================================================*/
76: PROCEDURE insert_p(
77: p_ra_rec IN ar_receivable_applications%ROWTYPE
78: , p_ra_id IN OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE ) IS
79: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;
80: BEGIN
81: arp_standard.debug( 'arp_app_pkg.insert_p()+' );

Line 78: , p_ra_id IN OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE ) IS

74: | 07-DEC-2006 MRAYMOND 5677984 - changed p_ra_id from IN to IN/OUT
75: +===========================================================================*/
76: PROCEDURE insert_p(
77: p_ra_rec IN ar_receivable_applications%ROWTYPE
78: , p_ra_id IN OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE ) IS
79: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;
80: BEGIN
81: arp_standard.debug( 'arp_app_pkg.insert_p()+' );
82: arp_standard.debug(' p_ra_id = ' || p_ra_id);

Line 79: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;

75: +===========================================================================*/
76: PROCEDURE insert_p(
77: p_ra_rec IN ar_receivable_applications%ROWTYPE
78: , p_ra_id IN OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE ) IS
79: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;
80: BEGIN
81: arp_standard.debug( 'arp_app_pkg.insert_p()+' );
82: arp_standard.debug(' p_ra_id = ' || p_ra_id);
83: IF p_ra_id IS NULL

Line 85: SELECT ar_receivable_applications_s.nextval

81: arp_standard.debug( 'arp_app_pkg.insert_p()+' );
82: arp_standard.debug(' p_ra_id = ' || p_ra_id);
83: IF p_ra_id IS NULL
84: THEN
85: SELECT ar_receivable_applications_s.nextval
86: INTO l_ra_id
87: FROM dual;
88: arp_standard.debug(' assigned l_ra_id = ' || l_ra_id);
89: ELSE

Line 93: INSERT INTO ar_receivable_applications (

89: ELSE
90: l_ra_id := p_ra_id;
91: END IF;
92:
93: INSERT INTO ar_receivable_applications (
94: receivable_application_id,
95: acctd_amount_applied_from,
96: amount_applied,
97: amount_applied_from,

Line 393: | This function updates a row into AR_RECEIVABLE_APPLICATIONS table |

389: | PROCEDURE |
390: | update_p |
391: | |
392: | DESCRIPTION |
393: | This function updates a row into AR_RECEIVABLE_APPLICATIONS table |
394: | |
395: | SCOPE - PUBLIC |
396: | |
397: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

Line 441: PROCEDURE update_p( p_ra_rec IN ar_receivable_applications%ROWTYPE ) IS

437: | customer_reference (bug 2254777) |
438: | 06-FEB-2003 J.Beckett Bug 2751910 - Added customer_reason and |
439: | applied_rec_app_id |
440: +===========================================================================*/
441: PROCEDURE update_p( p_ra_rec IN ar_receivable_applications%ROWTYPE ) IS
442: lc_dump VARCHAR2(30000);
443:
444: BEGIN
445: arp_standard.debug( 'arp_app_pkg.update_p()+' );

Line 447: UPDATE ar_receivable_applications ra SET

443:
444: BEGIN
445: arp_standard.debug( 'arp_app_pkg.update_p()+' );
446:
447: UPDATE ar_receivable_applications ra SET
448: acctd_amount_applied_from =
449: p_ra_rec.acctd_amount_applied_from,
450: amount_applied = p_ra_rec.amount_applied,
451: amount_applied_from = p_ra_rec.amount_applied_from,

Line 700: | This function deletes a row from AR_RECEIVABLE_APPLICATIONS table |

696: | PROCEDURE |
697: | delete_p |
698: | |
699: | DESCRIPTION |
700: | This function deletes a row from AR_RECEIVABLE_APPLICATIONS table |
701: | |
702: | SCOPE - PUBLIC |
703: | |
704: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

Line 717: | delete from ar_receivable_applications |

713: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
714: | |
715: | 09/09/02 M Ryzhikova Modified for MRC trigger elimination proj |
716: | added call to ar_mrc_engine for processing |
717: | delete from ar_receivable_applications |
718: | |
719: +===========================================================================*/
720: PROCEDURE delete_p(
721: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE ) IS

Line 721: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE ) IS

717: | delete from ar_receivable_applications |
718: | |
719: +===========================================================================*/
720: PROCEDURE delete_p(
721: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE ) IS
722: BEGIN
723: arp_standard.debug( 'arp_app_pkg.delete_p()+' );
724:
725: DELETE FROM ar_receivable_applications ra

Line 725: DELETE FROM ar_receivable_applications ra

721: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE ) IS
722: BEGIN
723: arp_standard.debug( 'arp_app_pkg.delete_p()+' );
724:
725: DELETE FROM ar_receivable_applications ra
726: WHERE ra.receivable_application_id = p_ra_id;
727:
728: /*----------------------------------------------------+
729: | Calling central MRC library for MRC Integration. |

Line 735: -- p_table_name => 'AR_RECEIVABLE_APPLICATIONS',

731: +-----------------------------------------------------*/
732: --{BUG4301323
733: -- ar_mrc_engine.maintain_mrc_data(
734: -- p_event_mode => 'DELETE',
735: -- p_table_name => 'AR_RECEIVABLE_APPLICATIONS',
736: -- p_mode => 'SINGLE',
737: -- p_key_value => p_ra_id);
738: --}
739:

Line 752: | This function deletes a row from AR_RECEIVABLE_APPLICATIONS table |

748: /*===========================================================================+
749: | PROCEDURE |
750: | delete_f_ct_id |
751: | DESCRIPTION |
752: | This function deletes a row from AR_RECEIVABLE_APPLICATIONS table |
753: | for a Credit Memo taking custoemr_trx_id as parameter |
754: | SCOPE - PUBLIC |
755: | |
756: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

Line 774: p_customer_trx_id IN ar_receivable_applications.customer_trx_id%TYPE ) IS

770: | processing deletes from ar rec apps |
771: +===========================================================================*/
772: -- bugfix 2217253
773: PROCEDURE delete_f_ct_id(
774: p_customer_trx_id IN ar_receivable_applications.customer_trx_id%TYPE ) IS
775: CURSOR c_ra_rec IS select receivable_application_id
776: from ar_receivable_applications
777: where customer_trx_id = p_customer_trx_id;
778:

Line 776: from ar_receivable_applications

772: -- bugfix 2217253
773: PROCEDURE delete_f_ct_id(
774: p_customer_trx_id IN ar_receivable_applications.customer_trx_id%TYPE ) IS
775: CURSOR c_ra_rec IS select receivable_application_id
776: from ar_receivable_applications
777: where customer_trx_id = p_customer_trx_id;
778:
779: l_ar_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
780:

Line 785: DELETE FROM ar_receivable_applications ra

781: BEGIN
782: arp_standard.debug( 'arp_app_pkg.delete_f_ct_id()+' );
783: FOR i IN c_ra_rec LOOP
784:
785: DELETE FROM ar_receivable_applications ra
786: WHERE ra.receivable_application_id = i.receivable_application_id;
787:
788: /*---------------------------------+
789: | Calling central MRC library |

Line 795: -- p_table_name => 'AR_RECEIVABLE_APPLICATIONS',

791: +---------------------------------*/
792: --{BUG#4301323
793: -- ar_mrc_engine.maintain_mrc_data(
794: -- p_event_mode => 'DELETE',
795: -- p_table_name => 'AR_RECEIVABLE_APPLICATIONS',
796: -- p_mode => 'SINGLE',
797: -- p_key_value => i.receivable_application_id);
798: --}
799: DELETE FROM ar_distributions

Line 829: | This function locks a row in AR_RECEIVABLE_APPLICATIONS table |

825: | PROCEDURE |
826: | lock_p |
827: | |
828: | DESCRIPTION |
829: | This function locks a row in AR_RECEIVABLE_APPLICATIONS table |
830: | |
831: | SCOPE - PUBLIC |
832: | |
833: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

Line 846: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE ) IS

842: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
843: | |
844: +===========================================================================*/
845: PROCEDURE lock_p(
846: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE ) IS
847: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;
848: BEGIN
849: IF PG_DEBUG in ('Y', 'C') THEN
850: arp_standard.debug( 'arp_app_pkg.lock_p()+');

Line 847: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;

843: | |
844: +===========================================================================*/
845: PROCEDURE lock_p(
846: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE ) IS
847: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;
848: BEGIN
849: IF PG_DEBUG in ('Y', 'C') THEN
850: arp_standard.debug( 'arp_app_pkg.lock_p()+');
851: END IF;

Line 855: FROM ar_receivable_applications ra

851: END IF;
852:
853: SELECT ra.receivable_application_id
854: INTO l_ra_id
855: FROM ar_receivable_applications ra
856: WHERE ra.receivable_application_id = p_ra_id
857: FOR UPDATE OF STATUS NOWAIT;
858:
859: IF PG_DEBUG in ('Y', 'C') THEN

Line 875: | This function locks a row in AR_RECEIVABLE_APPLICATIONS table. |

871: | PROCEDURE |
872: | NOWAITLOCK_P |
873: | |
874: | DESCRIPTION |
875: | This function locks a row in AR_RECEIVABLE_APPLICATIONS table. |
876: | If row is already locked procedure will return error code ORA-0054 |
877: | (normal NOWAIT error code if already locked). |
878: | |
879: | SCOPE - PUBLIC |

Line 894: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE ) IS

890: | MODIFICATION HISTORY |
891: | 1/26/1996 Harri Kaukovuo Created |
892: +===========================================================================*/
893: PROCEDURE nowaitlock_p(
894: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE ) IS
895: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;
896: BEGIN
897: IF PG_DEBUG in ('Y', 'C') THEN
898: arp_standard.debug( 'arp_app_pkg.nowaitlock_p()+');

Line 895: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;

891: | 1/26/1996 Harri Kaukovuo Created |
892: +===========================================================================*/
893: PROCEDURE nowaitlock_p(
894: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE ) IS
895: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;
896: BEGIN
897: IF PG_DEBUG in ('Y', 'C') THEN
898: arp_standard.debug( 'arp_app_pkg.nowaitlock_p()+');
899: END IF;

Line 903: FROM ar_receivable_applications ra

899: END IF;
900:
901: SELECT ra.receivable_application_id
902: INTO l_ra_id
903: FROM ar_receivable_applications ra
904: WHERE ra.receivable_application_id = p_ra_id
905: FOR UPDATE OF STATUS NOWAIT;
906:
907: IF PG_DEBUG in ('Y', 'C') THEN

Line 923: | This function fetches a row from AR_RECEIVABLE_APPLICATIONS table |

919: | PROCEDURE |
920: | fetch_p |
921: | |
922: | DESCRIPTION |
923: | This function fetches a row from AR_RECEIVABLE_APPLICATIONS table |
924: | |
925: | SCOPE - PUBLIC |
926: | |
927: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

Line 942: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,

938: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
939: | |
940: +===========================================================================*/
941: PROCEDURE fetch_p(
942: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,
943: p_ra_rec OUT NOCOPY ar_receivable_applications%ROWTYPE ) IS
944: BEGIN
945: IF PG_DEBUG in ('Y', 'C') THEN
946: arp_standard.debug( 'arp_app_pkg.fetch_p()+' );

Line 943: p_ra_rec OUT NOCOPY ar_receivable_applications%ROWTYPE ) IS

939: | |
940: +===========================================================================*/
941: PROCEDURE fetch_p(
942: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,
943: p_ra_rec OUT NOCOPY ar_receivable_applications%ROWTYPE ) IS
944: BEGIN
945: IF PG_DEBUG in ('Y', 'C') THEN
946: arp_standard.debug( 'arp_app_pkg.fetch_p()+' );
947: END IF;

Line 951: FROM ar_receivable_applications

947: END IF;
948:
949: SELECT *
950: INTO p_ra_rec
951: FROM ar_receivable_applications
952: WHERE receivable_application_id = p_ra_id;
953:
954: IF PG_DEBUG in ('Y', 'C') THEN
955: arp_standard.debug( 'arp_app_pkg.fetch_p()-' );