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 299: 'update ar_interim_cash_receipts

295: BEGIN
296: arp_standard.debug('arp_cr_icr_pkg.construct_icr_update_stmt()+');
297: --
298: update_text :=
299: 'update ar_interim_cash_receipts
300: SET amount =
301: decode(:amount,
302: :ar_number_dummy, amount,
303: :amount),

Line 564: p_icr_rec IN ar_interim_cash_receipts%rowtype)

560: | customer_reason. |
561: +===========================================================================*/
562: --
563: PROCEDURE bind_icr_variables(p_update_cursor IN integer,
564: p_icr_rec IN ar_interim_cash_receipts%rowtype)
565: IS
566: --
567: BEGIN
568: --

Line 799: p_icr_rec IN ar_interim_cash_receipts%ROWTYPE)

795: --
796: PROCEDURE generic_update(p_update_cursor IN OUT NOCOPY integer,
797: p_where_clause IN varchar2,
798: p_where1 IN number,
799: p_icr_rec IN ar_interim_cash_receipts%ROWTYPE)
800: IS
801: --
802: l_count number;
803: l_update_statement varchar2(20000);

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

883: END;
884: --
885: --
886: --
887: PROCEDURE set_to_dummy( p_icr_rec OUT NOCOPY ar_interim_cash_receipts%rowtype)
888: IS
889: --
890: BEGIN
891: --

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

955: --
956: --
957: --
958: --
959: PROCEDURE update_p( p_icr_rec IN ar_interim_cash_receipts%ROWTYPE,
960: p_cash_receipt_id IN
961: ar_interim_cash_receipts.cash_receipt_id%TYPE) IS
962: --
963: BEGIN

Line 961: ar_interim_cash_receipts.cash_receipt_id%TYPE) IS

957: --
958: --
959: PROCEDURE update_p( p_icr_rec IN ar_interim_cash_receipts%ROWTYPE,
960: p_cash_receipt_id IN
961: ar_interim_cash_receipts.cash_receipt_id%TYPE) IS
962: --
963: BEGIN
964: --
965: arp_standard.debug('arp_cr_icr_pkg.update_p()+ ');

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

984: | PROCEDURE |
985: | delete_p |
986: | |
987: | DESCRIPTION |
988: | This function deletes a row into AR_INTERIM_CASH_RECEIPTS |
989: | |
990: | SCOPE - PUBLIC |
991: | |
992: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

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

1001: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
1002: | |
1003: +===========================================================================*/
1004: PROCEDURE delete_p(
1005: p_icr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE ) IS
1006: BEGIN
1007: arp_standard.debug( '>>>>>>>> arp_cr_icr_pkg.delete_p' );
1008: --
1009: DELETE FROM ar_interim_cash_receipts

Line 1009: DELETE FROM ar_interim_cash_receipts

1005: p_icr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE ) IS
1006: BEGIN
1007: arp_standard.debug( '>>>>>>>> arp_cr_icr_pkg.delete_p' );
1008: --
1009: DELETE FROM ar_interim_cash_receipts
1010: WHERE cash_receipt_id = p_icr_id;
1011: --
1012: arp_standard.debug( '<<<<<<<< arp_cr_icr_pkg.delete_p' );
1013: EXCEPTION

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

1020: | PROCEDURE |
1021: | lock_p |
1022: | |
1023: | DESCRIPTION |
1024: | This function locks a row in AR_INTERIM_CASH_RECEIPTS |
1025: | |
1026: | SCOPE - PUBLIC |
1027: | |
1028: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

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

1036: | |
1037: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
1038: | |
1039: +===========================================================================*/
1040: PROCEDURE lock_p( p_icr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE ) IS
1041: l_icr_id ar_interim_cash_receipts.cash_receipt_id%TYPE;
1042: BEGIN
1043: arp_standard.debug( '>>>>>>>> arp_cr_icr_pkg.lock_p' );
1044: --

Line 1041: l_icr_id ar_interim_cash_receipts.cash_receipt_id%TYPE;

1037: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
1038: | |
1039: +===========================================================================*/
1040: PROCEDURE lock_p( p_icr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE ) IS
1041: l_icr_id ar_interim_cash_receipts.cash_receipt_id%TYPE;
1042: BEGIN
1043: arp_standard.debug( '>>>>>>>> arp_cr_icr_pkg.lock_p' );
1044: --
1045: SELECT cash_receipt_id

Line 1047: FROM ar_interim_cash_receipts

1043: arp_standard.debug( '>>>>>>>> arp_cr_icr_pkg.lock_p' );
1044: --
1045: SELECT cash_receipt_id
1046: INTO l_icr_id
1047: FROM ar_interim_cash_receipts
1048: WHERE cash_receipt_id = p_icr_id
1049: FOR UPDATE OF STATUS;
1050: --
1051: arp_standard.debug( '<<<<<<<< arp_cr_icr_pkg.lock_p' );

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

1054: arp_standard.debug( 'EXCEPTION: arp_cr_icr_pkg.lock_p' );
1055: RAISE;
1056: END;
1057: --
1058: PROCEDURE nowaitlock_p( p_icr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE ) IS
1059: l_icr_id ar_interim_cash_receipts.cash_receipt_id%TYPE;
1060: BEGIN
1061: arp_standard.debug( '>>>>>>>> arp_cr_icr_pkg.nowaitlock_p' );
1062: --

Line 1059: l_icr_id ar_interim_cash_receipts.cash_receipt_id%TYPE;

1055: RAISE;
1056: END;
1057: --
1058: PROCEDURE nowaitlock_p( p_icr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE ) IS
1059: l_icr_id ar_interim_cash_receipts.cash_receipt_id%TYPE;
1060: BEGIN
1061: arp_standard.debug( '>>>>>>>> arp_cr_icr_pkg.nowaitlock_p' );
1062: --
1063: SELECT cash_receipt_id

Line 1065: FROM ar_interim_cash_receipts

1061: arp_standard.debug( '>>>>>>>> arp_cr_icr_pkg.nowaitlock_p' );
1062: --
1063: SELECT cash_receipt_id
1064: INTO l_icr_id
1065: FROM ar_interim_cash_receipts
1066: WHERE cash_receipt_id = p_icr_id
1067: FOR UPDATE OF STATUS NOWAIT;
1068: --
1069: arp_standard.debug( '<<<<<<<< arp_cr_icr_pkg.nowaitlock_p' );

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

1077: | PROCEDURE |
1078: | fetch_p |
1079: | |
1080: | DESCRIPTION |
1081: | This function fetches a row from AR_INTERIM_CASH_RECEIPTS |
1082: | |
1083: | SCOPE - PUBLIC |
1084: | |
1085: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

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

1095: | |
1096: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
1097: | |
1098: +===========================================================================*/
1099: PROCEDURE fetch_p( p_icr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
1100: p_icr_rec OUT NOCOPY ar_interim_cash_receipts%ROWTYPE ) IS
1101: BEGIN
1102: arp_standard.debug( '>>>>>>>> arp_cr_icr_pkg.fetch_p' );
1103: --

Line 1100: p_icr_rec OUT NOCOPY ar_interim_cash_receipts%ROWTYPE ) IS

1096: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
1097: | |
1098: +===========================================================================*/
1099: PROCEDURE fetch_p( p_icr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
1100: p_icr_rec OUT NOCOPY ar_interim_cash_receipts%ROWTYPE ) IS
1101: BEGIN
1102: arp_standard.debug( '>>>>>>>> arp_cr_icr_pkg.fetch_p' );
1103: --
1104: SELECT *

Line 1106: FROM ar_interim_cash_receipts

1102: arp_standard.debug( '>>>>>>>> arp_cr_icr_pkg.fetch_p' );
1103: --
1104: SELECT *
1105: INTO p_icr_rec
1106: FROM ar_interim_cash_receipts
1107: WHERE cash_receipt_id = p_icr_id;
1108: --
1109: arp_standard.debug( '<<<<<<<<< arp_cr_icr_pkg.fetch_p' );
1110: EXCEPTION

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

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

Line 1126: FROM ar_interim_cash_receipts

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

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

1138: RAISE;
1139: END lock_fetch_p;
1140: --
1141: --
1142: PROCEDURE nowaitlock_fetch_p( p_icr_rec IN OUT NOCOPY ar_interim_cash_receipts%ROWTYPE ) IS
1143: BEGIN
1144: IF PG_DEBUG in ('Y', 'C') THEN
1145: arp_standard.debug( 'arp_cr_icr_pkg.nowaitlock_fetch_p()+' );
1146: END IF;

Line 1150: FROM ar_interim_cash_receipts

1146: END IF;
1147: --
1148: SELECT *
1149: INTO p_icr_rec
1150: FROM ar_interim_cash_receipts
1151: WHERE cash_receipt_id = p_icr_rec.cash_receipt_id
1152: FOR UPDATE OF STATUS NOWAIT;
1153: --
1154: IF PG_DEBUG in ('Y', 'C') THEN