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 36: | This function inserts a row into AR_RECEIVABLE_APPLICATIONS table |

32: | PROCEDURE |
33: | insert_p |
34: | |
35: | DESCRIPTION |
36: | This function inserts a row into AR_RECEIVABLE_APPLICATIONS table |
37: | |
38: | SCOPE - PUBLIC |
39: | |
40: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

Line 83: p_ra_rec IN ar_receivable_applications%ROWTYPE

79: | applied_rec_app_id |
80: | 07-DEC-2006 MRAYMOND 5677984 - changed p_ra_id from IN to IN/OUT
81: +===========================================================================*/
82: PROCEDURE insert_p(
83: p_ra_rec IN ar_receivable_applications%ROWTYPE
84: , p_ra_id IN OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE ) IS
85: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;
86: BEGIN
87: arp_standard.debug( 'arp_app_pkg.insert_p()+' );

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

80: | 07-DEC-2006 MRAYMOND 5677984 - changed p_ra_id from IN to IN/OUT
81: +===========================================================================*/
82: PROCEDURE insert_p(
83: p_ra_rec IN ar_receivable_applications%ROWTYPE
84: , p_ra_id IN OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE ) IS
85: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;
86: BEGIN
87: arp_standard.debug( 'arp_app_pkg.insert_p()+' );
88: arp_standard.debug(' p_ra_id = ' || p_ra_id);

Line 85: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;

81: +===========================================================================*/
82: PROCEDURE insert_p(
83: p_ra_rec IN ar_receivable_applications%ROWTYPE
84: , p_ra_id IN OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE ) IS
85: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;
86: BEGIN
87: arp_standard.debug( 'arp_app_pkg.insert_p()+' );
88: arp_standard.debug(' p_ra_id = ' || p_ra_id);
89: IF p_ra_id IS NULL

Line 91: SELECT ar_receivable_applications_s.nextval

87: arp_standard.debug( 'arp_app_pkg.insert_p()+' );
88: arp_standard.debug(' p_ra_id = ' || p_ra_id);
89: IF p_ra_id IS NULL
90: THEN
91: SELECT ar_receivable_applications_s.nextval
92: INTO l_ra_id
93: FROM dual;
94: arp_standard.debug(' assigned l_ra_id = ' || l_ra_id);
95: ELSE

Line 99: INSERT INTO ar_receivable_applications (

95: ELSE
96: l_ra_id := p_ra_id;
97: END IF;
98:
99: INSERT INTO ar_receivable_applications (
100: receivable_application_id,
101: acctd_amount_applied_from,
102: amount_applied,
103: amount_applied_from,

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

407: | PROCEDURE |
408: | update_p |
409: | |
410: | DESCRIPTION |
411: | This function updates a row into AR_RECEIVABLE_APPLICATIONS table |
412: | |
413: | SCOPE - PUBLIC |
414: | |
415: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

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

455: | customer_reference (bug 2254777) |
456: | 06-FEB-2003 J.Beckett Bug 2751910 - Added customer_reason and |
457: | applied_rec_app_id |
458: +===========================================================================*/
459: PROCEDURE update_p( p_ra_rec IN ar_receivable_applications%ROWTYPE ) IS
460: lc_dump VARCHAR2(30000);
461:
462: BEGIN
463: arp_standard.debug( 'arp_app_pkg.update_p()+' );

Line 465: UPDATE ar_receivable_applications ra SET

461:
462: BEGIN
463: arp_standard.debug( 'arp_app_pkg.update_p()+' );
464:
465: UPDATE ar_receivable_applications ra SET
466: acctd_amount_applied_from =
467: p_ra_rec.acctd_amount_applied_from,
468: amount_applied = p_ra_rec.amount_applied,
469: amount_applied_from = p_ra_rec.amount_applied_from,

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

721: | PROCEDURE |
722: | delete_p |
723: | |
724: | DESCRIPTION |
725: | This function deletes a row from AR_RECEIVABLE_APPLICATIONS table |
726: | |
727: | SCOPE - PUBLIC |
728: | |
729: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

Line 742: | delete from ar_receivable_applications |

738: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
739: | |
740: | 09/09/02 M Ryzhikova Modified for MRC trigger elimination proj |
741: | added call to ar_mrc_engine for processing |
742: | delete from ar_receivable_applications |
743: | |
744: +===========================================================================*/
745: PROCEDURE delete_p(
746: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE ) IS

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

742: | delete from ar_receivable_applications |
743: | |
744: +===========================================================================*/
745: PROCEDURE delete_p(
746: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE ) IS
747: BEGIN
748: arp_standard.debug( 'arp_app_pkg.delete_p()+' );
749:
750: DELETE FROM ar_receivable_applications ra

Line 750: DELETE FROM ar_receivable_applications ra

746: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE ) IS
747: BEGIN
748: arp_standard.debug( 'arp_app_pkg.delete_p()+' );
749:
750: DELETE FROM ar_receivable_applications ra
751: WHERE ra.receivable_application_id = p_ra_id;
752:
753: /*----------------------------------------------------+
754: | Calling central MRC library for MRC Integration. |

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

756: +-----------------------------------------------------*/
757: --{BUG4301323
758: -- ar_mrc_engine.maintain_mrc_data(
759: -- p_event_mode => 'DELETE',
760: -- p_table_name => 'AR_RECEIVABLE_APPLICATIONS',
761: -- p_mode => 'SINGLE',
762: -- p_key_value => p_ra_id);
763: --}
764:

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

773: /*===========================================================================+
774: | PROCEDURE |
775: | delete_f_ct_id |
776: | DESCRIPTION |
777: | This function deletes a row from AR_RECEIVABLE_APPLICATIONS table |
778: | for a Credit Memo taking custoemr_trx_id as parameter |
779: | SCOPE - PUBLIC |
780: | |
781: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

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

795: | processing deletes from ar rec apps |
796: +===========================================================================*/
797: -- bugfix 2217253
798: PROCEDURE delete_f_ct_id(
799: p_customer_trx_id IN ar_receivable_applications.customer_trx_id%TYPE ) IS
800: CURSOR c_ra_rec IS select receivable_application_id
801: from ar_receivable_applications
802: where customer_trx_id = p_customer_trx_id;
803:

Line 801: from ar_receivable_applications

797: -- bugfix 2217253
798: PROCEDURE delete_f_ct_id(
799: p_customer_trx_id IN ar_receivable_applications.customer_trx_id%TYPE ) IS
800: CURSOR c_ra_rec IS select receivable_application_id
801: from ar_receivable_applications
802: where customer_trx_id = p_customer_trx_id;
803:
804: l_ar_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
805:

Line 810: DELETE FROM ar_receivable_applications ra

806: BEGIN
807: arp_standard.debug( 'arp_app_pkg.delete_f_ct_id()+' );
808: FOR i IN c_ra_rec LOOP
809:
810: DELETE FROM ar_receivable_applications ra
811: WHERE ra.receivable_application_id = i.receivable_application_id;
812:
813: /*---------------------------------+
814: | Calling central MRC library |

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

816: +---------------------------------*/
817: --{BUG#4301323
818: -- ar_mrc_engine.maintain_mrc_data(
819: -- p_event_mode => 'DELETE',
820: -- p_table_name => 'AR_RECEIVABLE_APPLICATIONS',
821: -- p_mode => 'SINGLE',
822: -- p_key_value => i.receivable_application_id);
823: --}
824: DELETE FROM ar_distributions

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

850: | PROCEDURE |
851: | lock_p |
852: | |
853: | DESCRIPTION |
854: | This function locks a row in AR_RECEIVABLE_APPLICATIONS table |
855: | |
856: | SCOPE - PUBLIC |
857: | |
858: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

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

867: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
868: | |
869: +===========================================================================*/
870: PROCEDURE lock_p(
871: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE ) IS
872: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;
873: l_event_id xla_events.event_id%TYPE;
874: BEGIN
875: IF PG_DEBUG in ('Y', 'C') THEN

Line 872: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;

868: | |
869: +===========================================================================*/
870: PROCEDURE lock_p(
871: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE ) IS
872: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;
873: l_event_id xla_events.event_id%TYPE;
874: BEGIN
875: IF PG_DEBUG in ('Y', 'C') THEN
876: arp_standard.debug( 'arp_app_pkg.lock_p()+');

Line 886: SELECT ra.event_id FROM ar_receivable_applications ra

882:
883: SELECT ev.event_id INTO l_event_id
884: FROM xla_events ev
885: WHERE ev.event_id IN (
886: SELECT ra.event_id FROM ar_receivable_applications ra
887: WHERE ra.receivable_application_id = p_ra_id)
888: FOR UPDATE OF ev.event_id NOWAIT;
889:
890: EXCEPTION

Line 898: FROM ar_receivable_applications ra

894: END;
895:
896: SELECT ra.receivable_application_id
897: INTO l_ra_id
898: FROM ar_receivable_applications ra
899: WHERE ra.receivable_application_id = p_ra_id
900: FOR UPDATE OF STATUS NOWAIT;
901:
902: IF PG_DEBUG in ('Y', 'C') THEN

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

915: | PROCEDURE |
916: | NOWAITLOCK_P |
917: | |
918: | DESCRIPTION |
919: | This function locks a row in AR_RECEIVABLE_APPLICATIONS table. |
920: | If row is already locked procedure will return error code ORA-0054 |
921: | (normal NOWAIT error code if already locked). |
922: | |
923: | SCOPE - PUBLIC |

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

934: | MODIFICATION HISTORY |
935: | 1/26/1996 Harri Kaukovuo Created |
936: +===========================================================================*/
937: PROCEDURE nowaitlock_p(
938: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE ) IS
939: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;
940: l_event_id xla_events.event_id%TYPE;
941: BEGIN
942: IF PG_DEBUG in ('Y', 'C') THEN

Line 939: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;

935: | 1/26/1996 Harri Kaukovuo Created |
936: +===========================================================================*/
937: PROCEDURE nowaitlock_p(
938: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE ) IS
939: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;
940: l_event_id xla_events.event_id%TYPE;
941: BEGIN
942: IF PG_DEBUG in ('Y', 'C') THEN
943: arp_standard.debug( 'arp_app_pkg.nowaitlock_p()+');

Line 953: SELECT ra.event_id FROM ar_receivable_applications ra

949:
950: SELECT ev.event_id INTO l_event_id
951: FROM xla_events ev
952: WHERE ev.event_id IN (
953: SELECT ra.event_id FROM ar_receivable_applications ra
954: WHERE ra.receivable_application_id = p_ra_id)
955: FOR UPDATE OF ev.event_id NOWAIT;
956:
957: EXCEPTION

Line 965: FROM ar_receivable_applications ra

961: END;
962:
963: SELECT ra.receivable_application_id
964: INTO l_ra_id
965: FROM ar_receivable_applications ra
966: WHERE ra.receivable_application_id = p_ra_id
967: FOR UPDATE OF STATUS NOWAIT;
968:
969: IF PG_DEBUG in ('Y', 'C') THEN

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

982: | PROCEDURE |
983: | fetch_p |
984: | |
985: | DESCRIPTION |
986: | This function fetches a row from AR_RECEIVABLE_APPLICATIONS table |
987: | |
988: | SCOPE - PUBLIC |
989: | |
990: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

Line 1005: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,

1001: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
1002: | |
1003: +===========================================================================*/
1004: PROCEDURE fetch_p(
1005: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,
1006: p_ra_rec OUT NOCOPY ar_receivable_applications%ROWTYPE ) IS
1007: BEGIN
1008: IF PG_DEBUG in ('Y', 'C') THEN
1009: arp_standard.debug( 'arp_app_pkg.fetch_p()+' );

Line 1006: p_ra_rec OUT NOCOPY ar_receivable_applications%ROWTYPE ) IS

1002: | |
1003: +===========================================================================*/
1004: PROCEDURE fetch_p(
1005: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,
1006: p_ra_rec OUT NOCOPY ar_receivable_applications%ROWTYPE ) IS
1007: BEGIN
1008: IF PG_DEBUG in ('Y', 'C') THEN
1009: arp_standard.debug( 'arp_app_pkg.fetch_p()+' );
1010: END IF;

Line 1014: FROM ar_receivable_applications

1010: END IF;
1011:
1012: SELECT *
1013: INTO p_ra_rec
1014: FROM ar_receivable_applications
1015: WHERE receivable_application_id = p_ra_id;
1016:
1017: IF PG_DEBUG in ('Y', 'C') THEN
1018: arp_standard.debug( 'arp_app_pkg.fetch_p()-' );

Line 1030: p_ra_rec_ui IN ar_receivable_applications%ROWTYPE ) return boolean IS

1026:
1027: END fetch_p;
1028:
1029: FUNCTION compare_for_llca(
1030: p_ra_rec_ui IN ar_receivable_applications%ROWTYPE ) return boolean IS
1031:
1032: llca_flow boolean;
1033: l_ra_id number;
1034: l_ra_rec_db ar_receivable_applications%ROWTYPE;

Line 1034: l_ra_rec_db ar_receivable_applications%ROWTYPE;

1030: p_ra_rec_ui IN ar_receivable_applications%ROWTYPE ) return boolean IS
1031:
1032: llca_flow boolean;
1033: l_ra_id number;
1034: l_ra_rec_db ar_receivable_applications%ROWTYPE;
1035: BEGIN
1036: l_ra_id := p_ra_rec_ui.receivable_application_id;
1037: fetch_p(l_ra_id,l_ra_rec_db);
1038: llca_flow := false;