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_BATCHES_PKG dependencies on ARP_CR_BATCHES_PKG

Line 1: PACKAGE BODY ARP_CR_BATCHES_PKG AS

1: PACKAGE BODY ARP_CR_BATCHES_PKG AS
2: /* $Header: ARRIBATB.pls 120.10 2008/03/18 09:12:01 spdixit ship $*/
3:
4: --
5: --

Line 70: arp_standard.debug( 'arp_cr_batches_pkg.insert_p()+' );

66: l_bat_id ar_batches.batch_id%TYPE;
67: l_row_id VARCHAR2( 20 );
68: BEGIN
69: IF PG_DEBUG in ('Y', 'C') THEN
70: arp_standard.debug( 'arp_cr_batches_pkg.insert_p()+' );
71: END IF;
72: --
73: ARP_CR_BATCHES_PKG.insert_p( p_bat_rec, l_bat_id );
74: --

Line 73: ARP_CR_BATCHES_PKG.insert_p( p_bat_rec, l_bat_id );

69: IF PG_DEBUG in ('Y', 'C') THEN
70: arp_standard.debug( 'arp_cr_batches_pkg.insert_p()+' );
71: END IF;
72: --
73: ARP_CR_BATCHES_PKG.insert_p( p_bat_rec, l_bat_id );
74: --
75: SELECT rowid
76: INTO l_row_id
77: FROM ar_batches

Line 84: arp_standard.debug( 'arp_cr_batches_pkg.insert_p()-' );

80: p_bat_id := l_bat_id;
81: p_row_id := l_row_id;
82: --
83: IF PG_DEBUG in ('Y', 'C') THEN
84: arp_standard.debug( 'arp_cr_batches_pkg.insert_p()-' );
85: END IF;
86: EXCEPTION
87: WHEN OTHERS THEN
88: IF PG_DEBUG in ('Y', 'C') THEN

Line 89: arp_standard.debug( 'EXCEPTION: arp_cr_batches_pkg.insert_p' );

85: END IF;
86: EXCEPTION
87: WHEN OTHERS THEN
88: IF PG_DEBUG in ('Y', 'C') THEN
89: arp_standard.debug( 'EXCEPTION: arp_cr_batches_pkg.insert_p' );
90: END IF;
91: RAISE;
92: END insert_p;
93: --

Line 130: arp_standard.debug( '>>>>>>>> arp_cr_batches_pkg.insert_p' );

126: p_bat_id OUT NOCOPY ar_batches.batch_id%TYPE ) IS
127: l_bat_id ar_batches.batch_id%TYPE;
128:
129: BEGIN
130: arp_standard.debug( '>>>>>>>> arp_cr_batches_pkg.insert_p' );
131: --
132: SELECT ar_batches_s.nextval
133: INTO l_bat_id
134: FROM dual;

Line 273: arp_standard.debug( '<<<<<<<< arp_cr_batches_pkg.insert_p' );

269: -- p_mode => 'SINGLE',
270: -- p_key_value => l_bat_id);
271: --}
272: --
273: arp_standard.debug( '<<<<<<<< arp_cr_batches_pkg.insert_p' );
274: EXCEPTION
275: WHEN OTHERS THEN
276: arp_standard.debug( 'EXCEPTION: arp_cr_batches_pkg.insert_p' );
277: RAISE;

Line 276: arp_standard.debug( 'EXCEPTION: arp_cr_batches_pkg.insert_p' );

272: --
273: arp_standard.debug( '<<<<<<<< arp_cr_batches_pkg.insert_p' );
274: EXCEPTION
275: WHEN OTHERS THEN
276: arp_standard.debug( 'EXCEPTION: arp_cr_batches_pkg.insert_p' );
277: RAISE;
278: END;
279: --
280: --

Line 284: arp_standard.debug('arp_cr_batches_pkg.construct_bat_update_stmt()+');

280: --
281: PROCEDURE construct_bat_update_stmt( update_text OUT NOCOPY varchar2) IS
282: --
283: BEGIN
284: arp_standard.debug('arp_cr_batches_pkg.construct_bat_update_stmt()+');
285: --
286: update_text :=
287: 'update ar_batches
288: SET batch_applied_status =

Line 499: arp_standard.debug('arp_cr_batches_pkg.construct_bat_update_stmt()-');

495: :ar_flag_dummy, purged_children_flag,
496: :purged_children_flag) ';
497:
498:
499: arp_standard.debug('arp_cr_batches_pkg.construct_bat_update_stmt()-');
500: --
501: EXCEPTION
502: WHEN OTHERS THEN
503: arp_standard.debug('EXCEPTION: arp_cr_batches_pkg .construct_bat_update_stmt()');

Line 503: arp_standard.debug('EXCEPTION: arp_cr_batches_pkg .construct_bat_update_stmt()');

499: arp_standard.debug('arp_cr_batches_pkg.construct_bat_update_stmt()-');
500: --
501: EXCEPTION
502: WHEN OTHERS THEN
503: arp_standard.debug('EXCEPTION: arp_cr_batches_pkg .construct_bat_update_stmt()');
504: RAISE;
505: --
506: END;
507: --

Line 516: arp_standard.debug('arp_cr_batches_pkg.bind_bat_variables()+');

512: IS
513: --
514: BEGIN
515: --
516: arp_standard.debug('arp_cr_batches_pkg.bind_bat_variables()+');
517: --
518: --
519: /*------------------+
520: | Dummy constants |

Line 715: arp_standard.debug('arp_cr_batches_pkg.bind_bat_variables()-');

711: --
712: dbms_sql.bind_variable(p_update_cursor, ':purged_children_flag',
713: p_bat_rec.purged_children_flag);
714: --
715: arp_standard.debug('arp_cr_batches_pkg.bind_bat_variables()-');
716: --
717: EXCEPTION
718: WHEN OTHERS THEN
719: arp_standard.debug('EXCEPTION: arp_cr_batches_pkg.bind_bat_variables()');

Line 719: arp_standard.debug('EXCEPTION: arp_cr_batches_pkg.bind_bat_variables()');

715: arp_standard.debug('arp_cr_batches_pkg.bind_bat_variables()-');
716: --
717: EXCEPTION
718: WHEN OTHERS THEN
719: arp_standard.debug('EXCEPTION: arp_cr_batches_pkg.bind_bat_variables()');
720: arp_standard.debug('Error at character: ' ||
721: to_char(dbms_sql.last_error_position));
722:
723: RAISE;

Line 741: arp_standard.debug('arp_cr_batches_pkg.generic_update()+');

737: ar_batch_array dbms_sql.number_table;
738:
739: --
740: BEGIN
741: arp_standard.debug('arp_cr_batches_pkg.generic_update()+');
742: --
743: /*--------------------------------------------------------------+
744: | If this update statement has not already been parsed, |
745: | construct the statement and parse it. |

Line 759: arp_cr_batches_pkg.construct_bat_update_stmt(l_update_statement);

755: /*---------------------------------+
756: | Construct the update statement |
757: +---------------------------------*/
758: --
759: arp_cr_batches_pkg.construct_bat_update_stmt(l_update_statement);
760: --
761: l_update_statement := l_update_statement || p_where_clause;
762:
763: /* add on mrc variables for bulk collect */

Line 782: arp_cr_batches_pkg.bind_bat_variables(p_update_cursor, p_bat_rec);

778: arp_standard.debug('after dbms_sql');
779:
780: end if;
781: --
782: arp_cr_batches_pkg.bind_bat_variables(p_update_cursor, p_bat_rec);
783: --
784: --
785: arp_standard.debug('after .bind_app');
786: /*-----------------------------------------+

Line 841: arp_standard.debug('arp_cr_batches_pkg.generic_update()-');

837: -- p_key_value => ar_batch_array(I));
838: -- END LOOP;
839: --}
840: --
841: arp_standard.debug('arp_cr_batches_pkg.generic_update()-');
842: --
843: EXCEPTION
844: WHEN OTHERS THEN
845: arp_standard.debug('EXCEPTION: arp_cr_batches_pkg.generic_update()

Line 845: arp_standard.debug('EXCEPTION: arp_cr_batches_pkg.generic_update()

841: arp_standard.debug('arp_cr_batches_pkg.generic_update()-');
842: --
843: EXCEPTION
844: WHEN OTHERS THEN
845: arp_standard.debug('EXCEPTION: arp_cr_batches_pkg.generic_update()
846: ');
847: arp_standard.debug(l_update_statement);
848: arp_standard.debug('Error at character: ' ||
849: to_char(dbms_sql.last_error_position));

Line 862: arp_standard.debug('arp_cr_batches_pkg.set_to_dummy()+');

858: IS
859: --
860: BEGIN
861: --
862: arp_standard.debug('arp_cr_batches_pkg.set_to_dummy()+');
863: --
864: p_bat_rec.batch_applied_status := AR_TEXT_DUMMY;
865: p_bat_rec.batch_date := AR_DATE_DUMMY;
866: p_bat_rec.batch_source_id := AR_NUMBER_DUMMY;

Line 914: arp_standard.debug('arp_cr_batches_pkg.set_to_dummy()-');

910: p_bat_rec.auto_trans_program_id := AR_NUMBER_DUMMY;
911: p_bat_rec.purged_children_flag := AR_FLAG_DUMMY;
912: --
913:
914: arp_standard.debug('arp_cr_batches_pkg.set_to_dummy()-');
915: --
916: EXCEPTION
917: WHEN OTHERS THEN
918: arp_standard.debug('EXCEPTION: arp_cr_batches_pkg.set_to_dummy()');

Line 918: arp_standard.debug('EXCEPTION: arp_cr_batches_pkg.set_to_dummy()');

914: arp_standard.debug('arp_cr_batches_pkg.set_to_dummy()-');
915: --
916: EXCEPTION
917: WHEN OTHERS THEN
918: arp_standard.debug('EXCEPTION: arp_cr_batches_pkg.set_to_dummy()');
919: RAISE;
920: --
921: END;
922: --

Line 933: arp_standard.debug('arp_cr_batches_pkg.update_p()+ ');

929: ar_batches.batch_id%TYPE) IS
930: --
931: BEGIN
932: --
933: arp_standard.debug('arp_cr_batches_pkg.update_p()+ ');
934: --
935: --
936: arp_cr_batches_pkg.generic_update( pg_cursor1,
937: ' WHERE batch_id = :where_1',

Line 936: arp_cr_batches_pkg.generic_update( pg_cursor1,

932: --
933: arp_standard.debug('arp_cr_batches_pkg.update_p()+ ');
934: --
935: --
936: arp_cr_batches_pkg.generic_update( pg_cursor1,
937: ' WHERE batch_id = :where_1',
938: p_batch_id,
939: p_bat_rec);
940: --

Line 941: arp_standard.debug('arp_cr_batches_pkg.update_p()- ' ||

937: ' WHERE batch_id = :where_1',
938: p_batch_id,
939: p_bat_rec);
940: --
941: arp_standard.debug('arp_cr_batches_pkg.update_p()- ' ||
942: to_char(sysdate, 'HH:MI:SS'));
943: --
944: --
945: EXCEPTION

Line 947: arp_standard.debug('EXCEPTION: arp_cr_batches_pkg.update_p()');

943: --
944: --
945: EXCEPTION
946: WHEN OTHERS THEN
947: arp_standard.debug('EXCEPTION: arp_cr_batches_pkg.update_p()');
948: RAISE;
949: END;
950: --
951: /*===========================================================================+

Line 974: arp_standard.debug( ' arp_cr_batches_pkg.update_p()+ ' );

970: | |
971: +===========================================================================*/
972: PROCEDURE update_p( p_bat_rec IN ar_batches%ROWTYPE ) IS
973: BEGIN
974: arp_standard.debug( ' arp_cr_batches_pkg.update_p()+ ' );
975: --
976: update_p( p_bat_rec, p_bat_rec.batch_id );
977: --
978: arp_standard.debug( 'arp_cr_batches_pkg.update_p()- ' );

Line 978: arp_standard.debug( 'arp_cr_batches_pkg.update_p()- ' );

974: arp_standard.debug( ' arp_cr_batches_pkg.update_p()+ ' );
975: --
976: update_p( p_bat_rec, p_bat_rec.batch_id );
977: --
978: arp_standard.debug( 'arp_cr_batches_pkg.update_p()- ' );
979: EXCEPTION
980: WHEN OTHERS THEN
981: arp_standard.debug( 'EXCEPTION: arp_cr_batches_pkg.update_p' );
982: RAISE;

Line 981: arp_standard.debug( 'EXCEPTION: arp_cr_batches_pkg.update_p' );

977: --
978: arp_standard.debug( 'arp_cr_batches_pkg.update_p()- ' );
979: EXCEPTION
980: WHEN OTHERS THEN
981: arp_standard.debug( 'EXCEPTION: arp_cr_batches_pkg.update_p' );
982: RAISE;
983: END;
984: --
985: /*===========================================================================+

Line 1009: arp_standard.debug( '>>>>>>>> arp_cr_batches_pkg.delete_p' );

1005: +===========================================================================*/
1006: PROCEDURE delete_p(
1007: p_bat_id IN ar_batches.batch_id%TYPE ) IS
1008: BEGIN
1009: arp_standard.debug( '>>>>>>>> arp_cr_batches_pkg.delete_p' );
1010: --
1011: DELETE FROM ar_batches
1012: WHERE batch_id = p_bat_id;
1013:

Line 1026: arp_standard.debug( '<<<<<<<< arp_cr_batches_pkg.delete_p' );

1022: -- p_mode => 'SINGLE',
1023: -- p_key_value => p_bat_id);
1024: --}
1025: --
1026: arp_standard.debug( '<<<<<<<< arp_cr_batches_pkg.delete_p' );
1027: EXCEPTION
1028: WHEN OTHERS THEN
1029: arp_standard.debug( 'EXCEPTION: arp_cr_batches_pkg.delete_p' );
1030: RAISE;

Line 1029: arp_standard.debug( 'EXCEPTION: arp_cr_batches_pkg.delete_p' );

1025: --
1026: arp_standard.debug( '<<<<<<<< arp_cr_batches_pkg.delete_p' );
1027: EXCEPTION
1028: WHEN OTHERS THEN
1029: arp_standard.debug( 'EXCEPTION: arp_cr_batches_pkg.delete_p' );
1030: RAISE;
1031: END;
1032: --
1033: /*===========================================================================+

Line 1268: arp_standard.debug( '>>>>>>>> arp_cr_batches_pkg.nowaitlock_p' );

1264: --
1265: PROCEDURE nowaitlock_p( p_bat_id IN ar_batches.batch_id%TYPE ) IS
1266: l_bat_id ar_batches.batch_id%TYPE;
1267: BEGIN
1268: arp_standard.debug( '>>>>>>>> arp_cr_batches_pkg.nowaitlock_p' );
1269: --
1270: SELECT batch_id
1271: INTO l_bat_id
1272: FROM ar_batches

Line 1276: arp_standard.debug( '<<<<<<<< arp_cr_batches_pkg.nowaitlock_p' );

1272: FROM ar_batches
1273: WHERE batch_id = p_bat_id
1274: FOR UPDATE OF STATUS NOWAIT;
1275: --
1276: arp_standard.debug( '<<<<<<<< arp_cr_batches_pkg.nowaitlock_p' );
1277: EXCEPTION
1278: WHEN OTHERS THEN
1279: arp_standard.debug( 'EXCEPTION: arp_cr_batches_pkg.nowaitlock_p' );
1280: RAISE;

Line 1279: arp_standard.debug( 'EXCEPTION: arp_cr_batches_pkg.nowaitlock_p' );

1275: --
1276: arp_standard.debug( '<<<<<<<< arp_cr_batches_pkg.nowaitlock_p' );
1277: EXCEPTION
1278: WHEN OTHERS THEN
1279: arp_standard.debug( 'EXCEPTION: arp_cr_batches_pkg.nowaitlock_p' );
1280: RAISE;
1281: END;
1282: --
1283: /*===========================================================================+

Line 1309: arp_standard.debug( '>>>>>>>> arp_cr_batches_pkg.fetch_p' );

1305: +===========================================================================*/
1306: PROCEDURE fetch_p( p_batch_id IN ar_batches.batch_id%TYPE,
1307: p_batch_rec OUT NOCOPY ar_batches%ROWTYPE ) IS
1308: BEGIN
1309: arp_standard.debug( '>>>>>>>> arp_cr_batches_pkg.fetch_p' );
1310: --
1311: SELECT *
1312: INTO p_batch_rec
1313: FROM ar_batches

Line 1316: arp_standard.debug( '<<<<<<<<< arp_cr_batches_pkg.fetch_p' );

1312: INTO p_batch_rec
1313: FROM ar_batches
1314: WHERE batch_id = p_batch_id;
1315: --
1316: arp_standard.debug( '<<<<<<<<< arp_cr_batches_pkg.fetch_p' );
1317: EXCEPTION
1318: --
1319: WHEN OTHERS THEN
1320: arp_standard.debug( 'EXCEPTION: arp_cr_batches_pkg.fetch_p' );

Line 1320: arp_standard.debug( 'EXCEPTION: arp_cr_batches_pkg.fetch_p' );

1316: arp_standard.debug( '<<<<<<<<< arp_cr_batches_pkg.fetch_p' );
1317: EXCEPTION
1318: --
1319: WHEN OTHERS THEN
1320: arp_standard.debug( 'EXCEPTION: arp_cr_batches_pkg.fetch_p' );
1321: RAISE;
1322: END;
1323: --
1324: PROCEDURE lock_fetch_p( p_batch_rec IN OUT NOCOPY ar_batches%ROWTYPE ) IS

Line 1327: arp_standard.debug( 'arp_cr_batches_pkg.lock_fetch_p()+' );

1323: --
1324: PROCEDURE lock_fetch_p( p_batch_rec IN OUT NOCOPY ar_batches%ROWTYPE ) IS
1325: BEGIN
1326: IF PG_DEBUG in ('Y', 'C') THEN
1327: arp_standard.debug( 'arp_cr_batches_pkg.lock_fetch_p()+' );
1328: END IF;
1329: --
1330: SELECT *
1331: INTO p_batch_rec

Line 1337: arp_standard.debug( 'arp_cr_batches_pkg.lock_fetch_p()-' );

1333: WHERE batch_id = p_batch_rec.batch_id
1334: FOR UPDATE OF STATUS;
1335: --
1336: IF PG_DEBUG in ('Y', 'C') THEN
1337: arp_standard.debug( 'arp_cr_batches_pkg.lock_fetch_p()-' );
1338: END IF;
1339: EXCEPTION
1340: WHEN OTHERS THEN
1341: IF PG_DEBUG in ('Y', 'C') THEN

Line 1342: arp_standard.debug( 'EXCEPTION: arp_cr_batches_pkg.lock_fetch_p' );

1338: END IF;
1339: EXCEPTION
1340: WHEN OTHERS THEN
1341: IF PG_DEBUG in ('Y', 'C') THEN
1342: arp_standard.debug( 'EXCEPTION: arp_cr_batches_pkg.lock_fetch_p' );
1343: END IF;
1344: RAISE;
1345: END lock_fetch_p;
1346: --

Line 1351: arp_standard.debug( 'arp_cr_batches_pkg.nowaitlock_fetch_p()+' );

1347: --
1348: PROCEDURE nowaitlock_fetch_p( p_batch_rec IN OUT NOCOPY ar_batches%ROWTYPE ) IS
1349: BEGIN
1350: IF PG_DEBUG in ('Y', 'C') THEN
1351: arp_standard.debug( 'arp_cr_batches_pkg.nowaitlock_fetch_p()+' );
1352: END IF;
1353: --
1354: SELECT *
1355: INTO p_batch_rec

Line 1361: arp_standard.debug( 'arp_cr_batches_pkg.nowaitlock_fetch_p()-' );

1357: WHERE batch_id = p_batch_rec.batch_id
1358: FOR UPDATE OF STATUS NOWAIT;
1359: --
1360: IF PG_DEBUG in ('Y', 'C') THEN
1361: arp_standard.debug( 'arp_cr_batches_pkg.nowaitlock_fetch_p()-' );
1362: END IF;
1363: EXCEPTION
1364: WHEN OTHERS THEN
1365: IF PG_DEBUG in ('Y', 'C') THEN

Line 1366: arp_standard.debug( 'EXCEPTION: arp_cr_batches_pkg.nowaitlock_fetch_p' );

1362: END IF;
1363: EXCEPTION
1364: WHEN OTHERS THEN
1365: IF PG_DEBUG in ('Y', 'C') THEN
1366: arp_standard.debug( 'EXCEPTION: arp_cr_batches_pkg.nowaitlock_fetch_p' );
1367: END IF;
1368: RAISE;
1369: END nowaitlock_fetch_p;
1370: --

Line 1394: END ARP_CR_BATCHES_PKG;

1390: pg_last_update_login := arp_global.last_update_login;
1391: pg_set_of_books_id := arp_global.set_of_books_id;
1392: --
1393: --
1394: END ARP_CR_BATCHES_PKG;
1395: --