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_CR_ICR_PKG dependencies on AR_INTERIM_CASH_RECEIPTS

Line 42: | This function inserts a row into AR_INTERIM_CASH_RECEIPTS |

38: | PROCEDURE |
39: | insert_p |
40: | |
41: | DESCRIPTION |
42: | This function inserts a row into AR_INTERIM_CASH_RECEIPTS |
43: | |
44: | SCOPE - PUBLIC |
45: | |
46: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

Line 62: p_cr_id OUT NOCOPY ar_interim_cash_receipts.cash_receipt_id%TYPE,

58: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
59: | |
60: +===========================================================================*/
61: PROCEDURE insert_p( p_row_id OUT NOCOPY VARCHAR2,
62: p_cr_id OUT NOCOPY ar_interim_cash_receipts.cash_receipt_id%TYPE,
63: p_icr_rec IN ar_interim_cash_receipts%ROWTYPE ) IS
64: l_cr_id ar_interim_cash_receipts.cash_receipt_id%TYPE;
65: l_row_id VARCHAR2( 20 );
66: BEGIN

Line 63: p_icr_rec IN ar_interim_cash_receipts%ROWTYPE ) IS

59: | |
60: +===========================================================================*/
61: PROCEDURE insert_p( p_row_id OUT NOCOPY VARCHAR2,
62: p_cr_id OUT NOCOPY ar_interim_cash_receipts.cash_receipt_id%TYPE,
63: p_icr_rec IN ar_interim_cash_receipts%ROWTYPE ) IS
64: l_cr_id ar_interim_cash_receipts.cash_receipt_id%TYPE;
65: l_row_id VARCHAR2( 20 );
66: BEGIN
67: arp_standard.debug( 'arp_cr_icr_pkg.insert_p()+' );

Line 64: l_cr_id ar_interim_cash_receipts.cash_receipt_id%TYPE;

60: +===========================================================================*/
61: PROCEDURE insert_p( p_row_id OUT NOCOPY VARCHAR2,
62: p_cr_id OUT NOCOPY ar_interim_cash_receipts.cash_receipt_id%TYPE,
63: p_icr_rec IN ar_interim_cash_receipts%ROWTYPE ) IS
64: l_cr_id ar_interim_cash_receipts.cash_receipt_id%TYPE;
65: l_row_id VARCHAR2( 20 );
66: BEGIN
67: arp_standard.debug( 'arp_cr_icr_pkg.insert_p()+' );
68: --

Line 73: FROM ar_interim_cash_receipts

69: arp_cr_icr_pkg.insert_p( p_icr_rec, l_cr_id );
70: --
71: SELECT ROWID
72: INTO l_row_id
73: FROM ar_interim_cash_receipts
74: WHERE cash_receipt_id = l_cr_id;
75: --
76: p_cr_id := l_cr_id;
77: p_row_id := l_row_id;

Line 92: | This function inserts a row into AR_INTERIM_CASH_RECEIPTS |

88: | PROCEDURE |
89: | insert_p |
90: | |
91: | DESCRIPTION |
92: | This function inserts a row into AR_INTERIM_CASH_RECEIPTS |
93: | |
94: | SCOPE - PUBLIC |
95: | |
96: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

Line 117: PROCEDURE insert_p( p_icr_rec IN ar_interim_cash_receipts%ROWTYPE,

113: | 12-24-02 K.Dhaliwal Bug 2707190 Added |
114: | application_ref_type,customer_reference and|
115: | customer_reason. |
116: +===========================================================================*/
117: PROCEDURE insert_p( p_icr_rec IN ar_interim_cash_receipts%ROWTYPE,
118: p_icr_id OUT NOCOPY ar_interim_cash_receipts.cash_receipt_id%TYPE ) IS
119: l_icr_id ar_interim_cash_receipts.cash_receipt_id%TYPE;
120: BEGIN
121: arp_standard.debug( '>>>>>>>> arp_cr_icr_pkg.insert_p' );

Line 118: p_icr_id OUT NOCOPY ar_interim_cash_receipts.cash_receipt_id%TYPE ) IS

114: | application_ref_type,customer_reference and|
115: | customer_reason. |
116: +===========================================================================*/
117: PROCEDURE insert_p( p_icr_rec IN ar_interim_cash_receipts%ROWTYPE,
118: p_icr_id OUT NOCOPY ar_interim_cash_receipts.cash_receipt_id%TYPE ) IS
119: l_icr_id ar_interim_cash_receipts.cash_receipt_id%TYPE;
120: BEGIN
121: arp_standard.debug( '>>>>>>>> arp_cr_icr_pkg.insert_p' );
122: --

Line 119: l_icr_id ar_interim_cash_receipts.cash_receipt_id%TYPE;

115: | customer_reason. |
116: +===========================================================================*/
117: PROCEDURE insert_p( p_icr_rec IN ar_interim_cash_receipts%ROWTYPE,
118: p_icr_id OUT NOCOPY ar_interim_cash_receipts.cash_receipt_id%TYPE ) IS
119: l_icr_id ar_interim_cash_receipts.cash_receipt_id%TYPE;
120: BEGIN
121: arp_standard.debug( '>>>>>>>> arp_cr_icr_pkg.insert_p' );
122: --
123: SELECT ar_cash_receipts_s.nextval

Line 127: INSERT INTO ar_interim_cash_receipts (

123: SELECT ar_cash_receipts_s.nextval
124: INTO l_icr_id
125: FROM dual;
126: --
127: INSERT INTO ar_interim_cash_receipts (
128: cash_receipt_id,
129: amount,
130: amount_applied,
131: trans_to_receipt_rate,

Line 295: 'update ar_interim_cash_receipts

291: BEGIN
292: arp_standard.debug('arp_cr_icr_pkg.construct_icr_update_stmt()+');
293: --
294: update_text :=
295: 'update ar_interim_cash_receipts
296: SET amount =
297: decode(:amount,
298: :ar_number_dummy, amount,
299: :amount),

Line 554: p_icr_rec IN ar_interim_cash_receipts%rowtype)

550: | customer_reason. |
551: +===========================================================================*/
552: --
553: PROCEDURE bind_icr_variables(p_update_cursor IN integer,
554: p_icr_rec IN ar_interim_cash_receipts%rowtype)
555: IS
556: --
557: BEGIN
558: --

Line 779: p_icr_rec IN ar_interim_cash_receipts%ROWTYPE)

775: --
776: PROCEDURE generic_update(p_update_cursor IN OUT NOCOPY integer,
777: p_where_clause IN varchar2,
778: p_where1 IN number,
779: p_icr_rec IN ar_interim_cash_receipts%ROWTYPE)
780: IS
781: --
782: l_count number;
783: l_update_statement varchar2(20000);

Line 867: PROCEDURE set_to_dummy( p_icr_rec OUT NOCOPY ar_interim_cash_receipts%rowtype)

863: END;
864: --
865: --
866: --
867: PROCEDURE set_to_dummy( p_icr_rec OUT NOCOPY ar_interim_cash_receipts%rowtype)
868: IS
869: --
870: BEGIN
871: --

Line 937: PROCEDURE update_p( p_icr_rec IN ar_interim_cash_receipts%ROWTYPE,

933: --
934: --
935: --
936: --
937: PROCEDURE update_p( p_icr_rec IN ar_interim_cash_receipts%ROWTYPE,
938: p_cash_receipt_id IN
939: ar_interim_cash_receipts.cash_receipt_id%TYPE) IS
940: --
941: BEGIN

Line 939: ar_interim_cash_receipts.cash_receipt_id%TYPE) IS

935: --
936: --
937: PROCEDURE update_p( p_icr_rec IN ar_interim_cash_receipts%ROWTYPE,
938: p_cash_receipt_id IN
939: ar_interim_cash_receipts.cash_receipt_id%TYPE) IS
940: --
941: BEGIN
942: --
943: arp_standard.debug('arp_cr_icr_pkg.update_p()+ ');

Line 966: | This function deletes a row into AR_INTERIM_CASH_RECEIPTS |

962: | PROCEDURE |
963: | delete_p |
964: | |
965: | DESCRIPTION |
966: | This function deletes a row into AR_INTERIM_CASH_RECEIPTS |
967: | |
968: | SCOPE - PUBLIC |
969: | |
970: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

Line 983: p_icr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE ) IS

979: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
980: | |
981: +===========================================================================*/
982: PROCEDURE delete_p(
983: p_icr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE ) IS
984: BEGIN
985: arp_standard.debug( '>>>>>>>> arp_cr_icr_pkg.delete_p' );
986: --
987: DELETE FROM ar_interim_cash_receipts

Line 987: DELETE FROM ar_interim_cash_receipts

983: p_icr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE ) IS
984: BEGIN
985: arp_standard.debug( '>>>>>>>> arp_cr_icr_pkg.delete_p' );
986: --
987: DELETE FROM ar_interim_cash_receipts
988: WHERE cash_receipt_id = p_icr_id;
989: --
990: arp_standard.debug( '<<<<<<<< arp_cr_icr_pkg.delete_p' );
991: EXCEPTION

Line 1002: | This function locks a row in AR_INTERIM_CASH_RECEIPTS |

998: | PROCEDURE |
999: | lock_p |
1000: | |
1001: | DESCRIPTION |
1002: | This function locks a row in AR_INTERIM_CASH_RECEIPTS |
1003: | |
1004: | SCOPE - PUBLIC |
1005: | |
1006: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

Line 1018: PROCEDURE lock_p( p_icr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE ) IS

1014: | |
1015: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
1016: | |
1017: +===========================================================================*/
1018: PROCEDURE lock_p( p_icr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE ) IS
1019: l_icr_id ar_interim_cash_receipts.cash_receipt_id%TYPE;
1020: BEGIN
1021: arp_standard.debug( '>>>>>>>> arp_cr_icr_pkg.lock_p' );
1022: --

Line 1019: l_icr_id ar_interim_cash_receipts.cash_receipt_id%TYPE;

1015: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
1016: | |
1017: +===========================================================================*/
1018: PROCEDURE lock_p( p_icr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE ) IS
1019: l_icr_id ar_interim_cash_receipts.cash_receipt_id%TYPE;
1020: BEGIN
1021: arp_standard.debug( '>>>>>>>> arp_cr_icr_pkg.lock_p' );
1022: --
1023: SELECT cash_receipt_id

Line 1025: FROM ar_interim_cash_receipts

1021: arp_standard.debug( '>>>>>>>> arp_cr_icr_pkg.lock_p' );
1022: --
1023: SELECT cash_receipt_id
1024: INTO l_icr_id
1025: FROM ar_interim_cash_receipts
1026: WHERE cash_receipt_id = p_icr_id
1027: FOR UPDATE OF STATUS;
1028: --
1029: arp_standard.debug( '<<<<<<<< arp_cr_icr_pkg.lock_p' );

Line 1036: PROCEDURE nowaitlock_p( p_icr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE ) IS

1032: arp_standard.debug( 'EXCEPTION: arp_cr_icr_pkg.lock_p' );
1033: RAISE;
1034: END;
1035: --
1036: PROCEDURE nowaitlock_p( p_icr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE ) IS
1037: l_icr_id ar_interim_cash_receipts.cash_receipt_id%TYPE;
1038: BEGIN
1039: arp_standard.debug( '>>>>>>>> arp_cr_icr_pkg.nowaitlock_p' );
1040: --

Line 1037: l_icr_id ar_interim_cash_receipts.cash_receipt_id%TYPE;

1033: RAISE;
1034: END;
1035: --
1036: PROCEDURE nowaitlock_p( p_icr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE ) IS
1037: l_icr_id ar_interim_cash_receipts.cash_receipt_id%TYPE;
1038: BEGIN
1039: arp_standard.debug( '>>>>>>>> arp_cr_icr_pkg.nowaitlock_p' );
1040: --
1041: SELECT cash_receipt_id

Line 1043: FROM ar_interim_cash_receipts

1039: arp_standard.debug( '>>>>>>>> arp_cr_icr_pkg.nowaitlock_p' );
1040: --
1041: SELECT cash_receipt_id
1042: INTO l_icr_id
1043: FROM ar_interim_cash_receipts
1044: WHERE cash_receipt_id = p_icr_id
1045: FOR UPDATE OF STATUS NOWAIT;
1046: --
1047: arp_standard.debug( '<<<<<<<< arp_cr_icr_pkg.nowaitlock_p' );

Line 1059: | This function fetches a row from AR_INTERIM_CASH_RECEIPTS |

1055: | PROCEDURE |
1056: | fetch_p |
1057: | |
1058: | DESCRIPTION |
1059: | This function fetches a row from AR_INTERIM_CASH_RECEIPTS |
1060: | |
1061: | SCOPE - PUBLIC |
1062: | |
1063: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

Line 1077: PROCEDURE fetch_p( p_icr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,

1073: | |
1074: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
1075: | |
1076: +===========================================================================*/
1077: PROCEDURE fetch_p( p_icr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
1078: p_icr_rec OUT NOCOPY ar_interim_cash_receipts%ROWTYPE ) IS
1079: BEGIN
1080: arp_standard.debug( '>>>>>>>> arp_cr_icr_pkg.fetch_p' );
1081: --

Line 1078: p_icr_rec OUT NOCOPY ar_interim_cash_receipts%ROWTYPE ) IS

1074: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
1075: | |
1076: +===========================================================================*/
1077: PROCEDURE fetch_p( p_icr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
1078: p_icr_rec OUT NOCOPY ar_interim_cash_receipts%ROWTYPE ) IS
1079: BEGIN
1080: arp_standard.debug( '>>>>>>>> arp_cr_icr_pkg.fetch_p' );
1081: --
1082: SELECT *

Line 1084: FROM ar_interim_cash_receipts

1080: arp_standard.debug( '>>>>>>>> arp_cr_icr_pkg.fetch_p' );
1081: --
1082: SELECT *
1083: INTO p_icr_rec
1084: FROM ar_interim_cash_receipts
1085: WHERE cash_receipt_id = p_icr_id;
1086: --
1087: arp_standard.debug( '<<<<<<<<< arp_cr_icr_pkg.fetch_p' );
1088: EXCEPTION

Line 1096: PROCEDURE lock_fetch_p( p_icr_rec IN OUT NOCOPY ar_interim_cash_receipts%ROWTYPE ) IS

1092: RAISE;
1093: END;
1094: --
1095:
1096: PROCEDURE lock_fetch_p( p_icr_rec IN OUT NOCOPY ar_interim_cash_receipts%ROWTYPE ) IS
1097: BEGIN
1098: IF PG_DEBUG in ('Y', 'C') THEN
1099: arp_standard.debug( 'arp_cr_icr_pkg.lock_fetch_p()+' );
1100: END IF;

Line 1104: FROM ar_interim_cash_receipts

1100: END IF;
1101: --
1102: SELECT *
1103: INTO p_icr_rec
1104: FROM ar_interim_cash_receipts
1105: WHERE cash_receipt_id = p_icr_rec.cash_receipt_id
1106: FOR UPDATE OF STATUS;
1107: --
1108: IF PG_DEBUG in ('Y', 'C') THEN

Line 1120: PROCEDURE nowaitlock_fetch_p( p_icr_rec IN OUT NOCOPY ar_interim_cash_receipts%ROWTYPE ) IS

1116: RAISE;
1117: END lock_fetch_p;
1118: --
1119: --
1120: PROCEDURE nowaitlock_fetch_p( p_icr_rec IN OUT NOCOPY ar_interim_cash_receipts%ROWTYPE ) IS
1121: BEGIN
1122: IF PG_DEBUG in ('Y', 'C') THEN
1123: arp_standard.debug( 'arp_cr_icr_pkg.nowaitlock_fetch_p()+' );
1124: END IF;

Line 1128: FROM ar_interim_cash_receipts

1124: END IF;
1125: --
1126: SELECT *
1127: INTO p_icr_rec
1128: FROM ar_interim_cash_receipts
1129: WHERE cash_receipt_id = p_icr_rec.cash_receipt_id
1130: FOR UPDATE OF STATUS NOWAIT;
1131: --
1132: IF PG_DEBUG in ('Y', 'C') THEN