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_TBAT_PKG dependencies on RA_BATCHES

Line 70: PROCEDURE display_batch_rec( p_batch_rec ra_batches%rowtype )

66: | into the table handlers. |
67: | |
68: +===========================================================================*/
69:
70: PROCEDURE display_batch_rec( p_batch_rec ra_batches%rowtype )
71: IS
72:
73:
74: BEGIN

Line 79: arp_util.debug(' Dump of ra_batches record ');

75:
76: arp_util.debug('arp_tbat_pgk.display_batch_rec()+');
77:
78:
79: arp_util.debug('************** Dump of ra_batches record **************');
80: arp_util.debug('batch_id: ' || p_batch_rec.batch_id);
81: arp_util.debug('last_updated_by: ' || p_batch_rec.last_updated_by);
82: arp_util.debug('created_by: ' || p_batch_rec.created_by);
83: arp_util.debug('last_update_login: ' || p_batch_rec.last_update_login);

Line 123: arp_util.debug(' End ra_batches record ');

119: arp_util.debug('special_instructions: ' || p_batch_rec.special_instructions);
120: arp_util.debug('batch_process_status: ' || p_batch_rec.batch_process_status);
121: arp_util.debug('selection_criteria_id: ' || p_batch_rec.selection_criteria_id);
122: arp_util.debug('request_id: ' || p_batch_rec.request_id);
123: arp_util.debug('************** End ra_batches record **************');
124:
125: arp_util.debug('arp_tbat_pgk.display_batch_rec()-');
126:
127: EXCEPTION

Line 164: PROCEDURE display_batch( p_batch_id IN ra_batches.batch_id%type)

160: | 13-JUL-95 Charlie Tomberg Created |
161: | |
162: +===========================================================================*/
163:
164: PROCEDURE display_batch( p_batch_id IN ra_batches.batch_id%type)
165: IS
166:
167: l_batch_rec ra_batches%rowtype;
168:

Line 167: l_batch_rec ra_batches%rowtype;

163:
164: PROCEDURE display_batch( p_batch_id IN ra_batches.batch_id%type)
165: IS
166:
167: l_batch_rec ra_batches%rowtype;
168:
169: BEGIN
170:
171: arp_util.debug('arp_tbat_pgk.display_batch()+');

Line 203: | p_batch_rec - ra_batches record |

199: | arp_util.debug |
200: | |
201: | ARGUMENTS : IN: |
202: | p_update_cursor - ID of the update cursor |
203: | p_batch_rec - ra_batches record |
204: | OUT: |
205: | None |
206: | |
207: | RETURNS : NONE |

Line 228: p_batch_rec IN ra_batches%rowtype) IS

224: +===========================================================================*/
225:
226:
227: PROCEDURE bind_batch_variables(p_update_cursor IN integer,
228: p_batch_rec IN ra_batches%rowtype) IS
229:
230: BEGIN
231:
232: arp_util.debug('arp_tbat_pkg.bind_batch_variables()+');

Line 415: 'update ra_batches

411: BEGIN
412: arp_util.debug('arp_tbat_pkg.construct_batch_update_stmt()+');
413:
414: update_text :=
415: 'update ra_batches
416: SET batch_id =
417: DECODE(:batch_id,
418: :ar_number_dummy, batch_id,
419: :batch_id),

Line 616: | This procedure Updates records in ra_batches identified by the where |

612: | PROCEDURE |
613: | generic_update |
614: | |
615: | DESCRIPTION |
616: | This procedure Updates records in ra_batches identified by the where |
617: | clause that is passed in as a parameter. Only those columns in |
618: | the batch record parameter that do not contain the special dummy values|
619: | are updated. |
620: | |

Line 650: p_batch_rec IN ra_batches%rowtype) IS

646:
647: PROCEDURE generic_update(p_update_cursor IN OUT NOCOPY integer,
648: p_where_clause IN varchar2,
649: p_where1 IN number,
650: p_batch_rec IN ra_batches%rowtype) IS
651:
652: l_count number;
653: l_update_statement varchar2(10000);
654: l_ra_batch_key_value_list gl_ca_utility_pkg.r_key_value_arr;

Line 738: -- p_table_name => 'RA_BATCHES',

734: | call mrc engine to update RA_MC_BATCHES |
735: +---------------------------------------------*/
736: -- ar_mrc_engine.maintain_mrc_data(
737: -- p_event_mode => 'UPDATE',
738: -- p_table_name => 'RA_BATCHES',
739: -- p_mode => 'SINGLE',
740: -- p_key_value => ra_batch_array(I));
741: -- END LOOP;
742: --}

Line 798: PROCEDURE set_to_dummy( p_batch_rec OUT NOCOPY ra_batches%rowtype) IS

794: | into the table handlers. |
795: | |
796: +===========================================================================*/
797:
798: PROCEDURE set_to_dummy( p_batch_rec OUT NOCOPY ra_batches%rowtype) IS
799:
800: BEGIN
801:
802: arp_util.debug('arp_tbat_pkg.set_to_dummy()+');

Line 865: | This procedure fetches a single row from ra_batches into a variable |

861: | PROCEDURE |
862: | fetch_p |
863: | |
864: | DESCRIPTION |
865: | This procedure fetches a single row from ra_batches into a variable |
866: | specified as a parameter based on the table's primary key, batch_id. |
867: | |
868: | SCOPE - PUBLIC |
869: | |

Line 887: PROCEDURE fetch_p( p_batch_rec OUT NOCOPY ra_batches%rowtype,

883: | 06-JUN-95 Charlie Tomberg Created |
884: | |
885: +===========================================================================*/
886:
887: PROCEDURE fetch_p( p_batch_rec OUT NOCOPY ra_batches%rowtype,
888: p_batch_id IN ra_batches.batch_id%type ) IS
889:
890: BEGIN
891: arp_util.debug('arp_tbat_pkg.fetch_p()+');

Line 888: p_batch_id IN ra_batches.batch_id%type ) IS

884: | |
885: +===========================================================================*/
886:
887: PROCEDURE fetch_p( p_batch_rec OUT NOCOPY ra_batches%rowtype,
888: p_batch_id IN ra_batches.batch_id%type ) IS
889:
890: BEGIN
891: arp_util.debug('arp_tbat_pkg.fetch_p()+');
892:

Line 895: FROM ra_batches

891: arp_util.debug('arp_tbat_pkg.fetch_p()+');
892:
893: SELECT *
894: INTO p_batch_rec
895: FROM ra_batches
896: WHERE batch_id = p_batch_id;
897:
898: arp_util.debug('arp_tbat_pkg.fetch_p()-');
899:

Line 911: | This procedure locks the ra_batches row identified by the p_batch_id |

907: | PROCEDURE |
908: | lock_p |
909: | |
910: | DESCRIPTION |
911: | This procedure locks the ra_batches row identified by the p_batch_id |
912: | parameter. |
913: | |
914: | SCOPE - PUBLIC |
915: | |

Line 933: PROCEDURE lock_p( p_batch_id IN ra_batches.batch_id%type ) IS

929: | 06-JUN-95 Charlie Tomberg Created |
930: | |
931: +===========================================================================*/
932:
933: PROCEDURE lock_p( p_batch_id IN ra_batches.batch_id%type ) IS
934:
935: l_batch_id ra_batches.batch_id%type;
936:
937: BEGIN

Line 935: l_batch_id ra_batches.batch_id%type;

931: +===========================================================================*/
932:
933: PROCEDURE lock_p( p_batch_id IN ra_batches.batch_id%type ) IS
934:
935: l_batch_id ra_batches.batch_id%type;
936:
937: BEGIN
938: arp_util.debug('arp_tbat_pkg.lock_p()+');
939:

Line 942: FROM ra_batches

938: arp_util.debug('arp_tbat_pkg.lock_p()+');
939:
940: SELECT batch_id
941: INTO l_batch_id
942: FROM ra_batches
943: WHERE batch_id = p_batch_id
944: FOR UPDATE OF batch_id NOWAIT;
945:
946: arp_util.debug('arp_tbat_pkg.lock_p()-');

Line 959: | This procedure locks the ra_batches row identified by the p_batch_id |

955: | PROCEDURE |
956: | lock_fetch_p |
957: | |
958: | DESCRIPTION |
959: | This procedure locks the ra_batches row identified by the p_batch_id |
960: | parameter and populates the p_batch_rec parameter with the row that |
961: | was locked. |
962: | |
963: | SCOPE - PUBLIC |

Line 982: PROCEDURE lock_fetch_p( p_batch_rec IN OUT NOCOPY ra_batches%rowtype,

978: | 06-JUN-95 Charlie Tomberg Created |
979: | |
980: +===========================================================================*/
981:
982: PROCEDURE lock_fetch_p( p_batch_rec IN OUT NOCOPY ra_batches%rowtype,
983: p_batch_id IN ra_batches.batch_id%type ) IS
984:
985: BEGIN
986: arp_util.debug('arp_tbat_pkg.lock_fetch_p()+');

Line 983: p_batch_id IN ra_batches.batch_id%type ) IS

979: | |
980: +===========================================================================*/
981:
982: PROCEDURE lock_fetch_p( p_batch_rec IN OUT NOCOPY ra_batches%rowtype,
983: p_batch_id IN ra_batches.batch_id%type ) IS
984:
985: BEGIN
986: arp_util.debug('arp_tbat_pkg.lock_fetch_p()+');
987:

Line 990: FROM ra_batches

986: arp_util.debug('arp_tbat_pkg.lock_fetch_p()+');
987:
988: SELECT *
989: INTO p_batch_rec
990: FROM ra_batches
991: WHERE batch_id = p_batch_id
992: FOR UPDATE OF batch_id NOWAIT;
993:
994: arp_util.debug('arp_tbat_pkg.lock_fetch_p()-');

Line 1007: | This procedure locks the ra_batches row identified by the p_batch_id |

1003: | PROCEDURE |
1004: | lock_compare_p |
1005: | |
1006: | DESCRIPTION |
1007: | This procedure locks the ra_batches row identified by the p_batch_id |
1008: | parameter only if no columns in that row have changed from when they |
1009: | were first selected in the form. |
1010: | |
1011: | SCOPE - PUBLIC |

Line 1042: PROCEDURE lock_compare_p( p_batch_rec IN ra_batches%rowtype,

1038: | |
1039: | |
1040: +===========================================================================*/
1041:
1042: PROCEDURE lock_compare_p( p_batch_rec IN ra_batches%rowtype,
1043: p_batch_id IN ra_batches.batch_id%type ) IS
1044:
1045: l_new_batch_rec ra_batches%rowtype;
1046:

Line 1043: p_batch_id IN ra_batches.batch_id%type ) IS

1039: | |
1040: +===========================================================================*/
1041:
1042: PROCEDURE lock_compare_p( p_batch_rec IN ra_batches%rowtype,
1043: p_batch_id IN ra_batches.batch_id%type ) IS
1044:
1045: l_new_batch_rec ra_batches%rowtype;
1046:
1047: BEGIN

Line 1045: l_new_batch_rec ra_batches%rowtype;

1041:
1042: PROCEDURE lock_compare_p( p_batch_rec IN ra_batches%rowtype,
1043: p_batch_id IN ra_batches.batch_id%type ) IS
1044:
1045: l_new_batch_rec ra_batches%rowtype;
1046:
1047: BEGIN
1048: arp_util.debug('arp_tbat_pkg.lock_compare_p()+');
1049:

Line 1052: FROM ra_batches tbat

1048: arp_util.debug('arp_tbat_pkg.lock_compare_p()+');
1049:
1050: SELECT *
1051: INTO l_new_batch_rec
1052: FROM ra_batches tbat
1053: WHERE tbat.batch_id = p_batch_id
1054: AND NOT
1055: (
1056: NVL(tbat.name, AR_TEXT_DUMMY) <>

Line 1484: p_batch_id IN ra_batches.batch_id%type,

1480:
1481: PROCEDURE lock_compare_cover(
1482: p_form_name IN varchar2,
1483: p_form_version IN number,
1484: p_batch_id IN ra_batches.batch_id%type,
1485: p_name IN ra_batches.name%type,
1486: p_batch_source_id IN ra_batches.batch_source_id%type,
1487: p_batch_date IN ra_batches.batch_date%type,
1488: p_gl_date IN ra_batches.gl_date%type,

Line 1485: p_name IN ra_batches.name%type,

1481: PROCEDURE lock_compare_cover(
1482: p_form_name IN varchar2,
1483: p_form_version IN number,
1484: p_batch_id IN ra_batches.batch_id%type,
1485: p_name IN ra_batches.name%type,
1486: p_batch_source_id IN ra_batches.batch_source_id%type,
1487: p_batch_date IN ra_batches.batch_date%type,
1488: p_gl_date IN ra_batches.gl_date%type,
1489: p_status IN ra_batches.status%type,

Line 1486: p_batch_source_id IN ra_batches.batch_source_id%type,

1482: p_form_name IN varchar2,
1483: p_form_version IN number,
1484: p_batch_id IN ra_batches.batch_id%type,
1485: p_name IN ra_batches.name%type,
1486: p_batch_source_id IN ra_batches.batch_source_id%type,
1487: p_batch_date IN ra_batches.batch_date%type,
1488: p_gl_date IN ra_batches.gl_date%type,
1489: p_status IN ra_batches.status%type,
1490: p_type IN ra_batches.type%type,

Line 1487: p_batch_date IN ra_batches.batch_date%type,

1483: p_form_version IN number,
1484: p_batch_id IN ra_batches.batch_id%type,
1485: p_name IN ra_batches.name%type,
1486: p_batch_source_id IN ra_batches.batch_source_id%type,
1487: p_batch_date IN ra_batches.batch_date%type,
1488: p_gl_date IN ra_batches.gl_date%type,
1489: p_status IN ra_batches.status%type,
1490: p_type IN ra_batches.type%type,
1491: p_currency_code IN ra_batches.currency_code%type,

Line 1488: p_gl_date IN ra_batches.gl_date%type,

1484: p_batch_id IN ra_batches.batch_id%type,
1485: p_name IN ra_batches.name%type,
1486: p_batch_source_id IN ra_batches.batch_source_id%type,
1487: p_batch_date IN ra_batches.batch_date%type,
1488: p_gl_date IN ra_batches.gl_date%type,
1489: p_status IN ra_batches.status%type,
1490: p_type IN ra_batches.type%type,
1491: p_currency_code IN ra_batches.currency_code%type,
1492: p_exchange_rate_type IN ra_batches.exchange_rate_type%type,

Line 1489: p_status IN ra_batches.status%type,

1485: p_name IN ra_batches.name%type,
1486: p_batch_source_id IN ra_batches.batch_source_id%type,
1487: p_batch_date IN ra_batches.batch_date%type,
1488: p_gl_date IN ra_batches.gl_date%type,
1489: p_status IN ra_batches.status%type,
1490: p_type IN ra_batches.type%type,
1491: p_currency_code IN ra_batches.currency_code%type,
1492: p_exchange_rate_type IN ra_batches.exchange_rate_type%type,
1493: p_exchange_date IN ra_batches.exchange_date%type,

Line 1490: p_type IN ra_batches.type%type,

1486: p_batch_source_id IN ra_batches.batch_source_id%type,
1487: p_batch_date IN ra_batches.batch_date%type,
1488: p_gl_date IN ra_batches.gl_date%type,
1489: p_status IN ra_batches.status%type,
1490: p_type IN ra_batches.type%type,
1491: p_currency_code IN ra_batches.currency_code%type,
1492: p_exchange_rate_type IN ra_batches.exchange_rate_type%type,
1493: p_exchange_date IN ra_batches.exchange_date%type,
1494: p_exchange_rate IN ra_batches.exchange_rate%type,

Line 1491: p_currency_code IN ra_batches.currency_code%type,

1487: p_batch_date IN ra_batches.batch_date%type,
1488: p_gl_date IN ra_batches.gl_date%type,
1489: p_status IN ra_batches.status%type,
1490: p_type IN ra_batches.type%type,
1491: p_currency_code IN ra_batches.currency_code%type,
1492: p_exchange_rate_type IN ra_batches.exchange_rate_type%type,
1493: p_exchange_date IN ra_batches.exchange_date%type,
1494: p_exchange_rate IN ra_batches.exchange_rate%type,
1495: p_control_count IN ra_batches.control_count%type,

Line 1492: p_exchange_rate_type IN ra_batches.exchange_rate_type%type,

1488: p_gl_date IN ra_batches.gl_date%type,
1489: p_status IN ra_batches.status%type,
1490: p_type IN ra_batches.type%type,
1491: p_currency_code IN ra_batches.currency_code%type,
1492: p_exchange_rate_type IN ra_batches.exchange_rate_type%type,
1493: p_exchange_date IN ra_batches.exchange_date%type,
1494: p_exchange_rate IN ra_batches.exchange_rate%type,
1495: p_control_count IN ra_batches.control_count%type,
1496: p_control_amount IN ra_batches.control_amount%type,

Line 1493: p_exchange_date IN ra_batches.exchange_date%type,

1489: p_status IN ra_batches.status%type,
1490: p_type IN ra_batches.type%type,
1491: p_currency_code IN ra_batches.currency_code%type,
1492: p_exchange_rate_type IN ra_batches.exchange_rate_type%type,
1493: p_exchange_date IN ra_batches.exchange_date%type,
1494: p_exchange_rate IN ra_batches.exchange_rate%type,
1495: p_control_count IN ra_batches.control_count%type,
1496: p_control_amount IN ra_batches.control_amount%type,
1497: p_comments IN ra_batches.comments%type,

Line 1494: p_exchange_rate IN ra_batches.exchange_rate%type,

1490: p_type IN ra_batches.type%type,
1491: p_currency_code IN ra_batches.currency_code%type,
1492: p_exchange_rate_type IN ra_batches.exchange_rate_type%type,
1493: p_exchange_date IN ra_batches.exchange_date%type,
1494: p_exchange_rate IN ra_batches.exchange_rate%type,
1495: p_control_count IN ra_batches.control_count%type,
1496: p_control_amount IN ra_batches.control_amount%type,
1497: p_comments IN ra_batches.comments%type,
1498: p_set_of_books_id IN ra_batches.set_of_books_id%type,

Line 1495: p_control_count IN ra_batches.control_count%type,

1491: p_currency_code IN ra_batches.currency_code%type,
1492: p_exchange_rate_type IN ra_batches.exchange_rate_type%type,
1493: p_exchange_date IN ra_batches.exchange_date%type,
1494: p_exchange_rate IN ra_batches.exchange_rate%type,
1495: p_control_count IN ra_batches.control_count%type,
1496: p_control_amount IN ra_batches.control_amount%type,
1497: p_comments IN ra_batches.comments%type,
1498: p_set_of_books_id IN ra_batches.set_of_books_id%type,
1499: p_purged_children_flag IN ra_batches.purged_children_flag%type,

Line 1496: p_control_amount IN ra_batches.control_amount%type,

1492: p_exchange_rate_type IN ra_batches.exchange_rate_type%type,
1493: p_exchange_date IN ra_batches.exchange_date%type,
1494: p_exchange_rate IN ra_batches.exchange_rate%type,
1495: p_control_count IN ra_batches.control_count%type,
1496: p_control_amount IN ra_batches.control_amount%type,
1497: p_comments IN ra_batches.comments%type,
1498: p_set_of_books_id IN ra_batches.set_of_books_id%type,
1499: p_purged_children_flag IN ra_batches.purged_children_flag%type,
1500: p_attribute_category IN ra_batches.attribute_category%type,

Line 1497: p_comments IN ra_batches.comments%type,

1493: p_exchange_date IN ra_batches.exchange_date%type,
1494: p_exchange_rate IN ra_batches.exchange_rate%type,
1495: p_control_count IN ra_batches.control_count%type,
1496: p_control_amount IN ra_batches.control_amount%type,
1497: p_comments IN ra_batches.comments%type,
1498: p_set_of_books_id IN ra_batches.set_of_books_id%type,
1499: p_purged_children_flag IN ra_batches.purged_children_flag%type,
1500: p_attribute_category IN ra_batches.attribute_category%type,
1501: p_attribute1 IN ra_batches.attribute1%type,

Line 1498: p_set_of_books_id IN ra_batches.set_of_books_id%type,

1494: p_exchange_rate IN ra_batches.exchange_rate%type,
1495: p_control_count IN ra_batches.control_count%type,
1496: p_control_amount IN ra_batches.control_amount%type,
1497: p_comments IN ra_batches.comments%type,
1498: p_set_of_books_id IN ra_batches.set_of_books_id%type,
1499: p_purged_children_flag IN ra_batches.purged_children_flag%type,
1500: p_attribute_category IN ra_batches.attribute_category%type,
1501: p_attribute1 IN ra_batches.attribute1%type,
1502: p_attribute2 IN ra_batches.attribute2%type,

Line 1499: p_purged_children_flag IN ra_batches.purged_children_flag%type,

1495: p_control_count IN ra_batches.control_count%type,
1496: p_control_amount IN ra_batches.control_amount%type,
1497: p_comments IN ra_batches.comments%type,
1498: p_set_of_books_id IN ra_batches.set_of_books_id%type,
1499: p_purged_children_flag IN ra_batches.purged_children_flag%type,
1500: p_attribute_category IN ra_batches.attribute_category%type,
1501: p_attribute1 IN ra_batches.attribute1%type,
1502: p_attribute2 IN ra_batches.attribute2%type,
1503: p_attribute3 IN ra_batches.attribute3%type,

Line 1500: p_attribute_category IN ra_batches.attribute_category%type,

1496: p_control_amount IN ra_batches.control_amount%type,
1497: p_comments IN ra_batches.comments%type,
1498: p_set_of_books_id IN ra_batches.set_of_books_id%type,
1499: p_purged_children_flag IN ra_batches.purged_children_flag%type,
1500: p_attribute_category IN ra_batches.attribute_category%type,
1501: p_attribute1 IN ra_batches.attribute1%type,
1502: p_attribute2 IN ra_batches.attribute2%type,
1503: p_attribute3 IN ra_batches.attribute3%type,
1504: p_attribute4 IN ra_batches.attribute4%type,

Line 1501: p_attribute1 IN ra_batches.attribute1%type,

1497: p_comments IN ra_batches.comments%type,
1498: p_set_of_books_id IN ra_batches.set_of_books_id%type,
1499: p_purged_children_flag IN ra_batches.purged_children_flag%type,
1500: p_attribute_category IN ra_batches.attribute_category%type,
1501: p_attribute1 IN ra_batches.attribute1%type,
1502: p_attribute2 IN ra_batches.attribute2%type,
1503: p_attribute3 IN ra_batches.attribute3%type,
1504: p_attribute4 IN ra_batches.attribute4%type,
1505: p_attribute5 IN ra_batches.attribute5%type,

Line 1502: p_attribute2 IN ra_batches.attribute2%type,

1498: p_set_of_books_id IN ra_batches.set_of_books_id%type,
1499: p_purged_children_flag IN ra_batches.purged_children_flag%type,
1500: p_attribute_category IN ra_batches.attribute_category%type,
1501: p_attribute1 IN ra_batches.attribute1%type,
1502: p_attribute2 IN ra_batches.attribute2%type,
1503: p_attribute3 IN ra_batches.attribute3%type,
1504: p_attribute4 IN ra_batches.attribute4%type,
1505: p_attribute5 IN ra_batches.attribute5%type,
1506: p_attribute6 IN ra_batches.attribute6%type,

Line 1503: p_attribute3 IN ra_batches.attribute3%type,

1499: p_purged_children_flag IN ra_batches.purged_children_flag%type,
1500: p_attribute_category IN ra_batches.attribute_category%type,
1501: p_attribute1 IN ra_batches.attribute1%type,
1502: p_attribute2 IN ra_batches.attribute2%type,
1503: p_attribute3 IN ra_batches.attribute3%type,
1504: p_attribute4 IN ra_batches.attribute4%type,
1505: p_attribute5 IN ra_batches.attribute5%type,
1506: p_attribute6 IN ra_batches.attribute6%type,
1507: p_attribute7 IN ra_batches.attribute7%type,

Line 1504: p_attribute4 IN ra_batches.attribute4%type,

1500: p_attribute_category IN ra_batches.attribute_category%type,
1501: p_attribute1 IN ra_batches.attribute1%type,
1502: p_attribute2 IN ra_batches.attribute2%type,
1503: p_attribute3 IN ra_batches.attribute3%type,
1504: p_attribute4 IN ra_batches.attribute4%type,
1505: p_attribute5 IN ra_batches.attribute5%type,
1506: p_attribute6 IN ra_batches.attribute6%type,
1507: p_attribute7 IN ra_batches.attribute7%type,
1508: p_attribute8 IN ra_batches.attribute8%type,

Line 1505: p_attribute5 IN ra_batches.attribute5%type,

1501: p_attribute1 IN ra_batches.attribute1%type,
1502: p_attribute2 IN ra_batches.attribute2%type,
1503: p_attribute3 IN ra_batches.attribute3%type,
1504: p_attribute4 IN ra_batches.attribute4%type,
1505: p_attribute5 IN ra_batches.attribute5%type,
1506: p_attribute6 IN ra_batches.attribute6%type,
1507: p_attribute7 IN ra_batches.attribute7%type,
1508: p_attribute8 IN ra_batches.attribute8%type,
1509: p_attribute9 IN ra_batches.attribute9%type,

Line 1506: p_attribute6 IN ra_batches.attribute6%type,

1502: p_attribute2 IN ra_batches.attribute2%type,
1503: p_attribute3 IN ra_batches.attribute3%type,
1504: p_attribute4 IN ra_batches.attribute4%type,
1505: p_attribute5 IN ra_batches.attribute5%type,
1506: p_attribute6 IN ra_batches.attribute6%type,
1507: p_attribute7 IN ra_batches.attribute7%type,
1508: p_attribute8 IN ra_batches.attribute8%type,
1509: p_attribute9 IN ra_batches.attribute9%type,
1510: p_attribute10 IN ra_batches.attribute10%type,

Line 1507: p_attribute7 IN ra_batches.attribute7%type,

1503: p_attribute3 IN ra_batches.attribute3%type,
1504: p_attribute4 IN ra_batches.attribute4%type,
1505: p_attribute5 IN ra_batches.attribute5%type,
1506: p_attribute6 IN ra_batches.attribute6%type,
1507: p_attribute7 IN ra_batches.attribute7%type,
1508: p_attribute8 IN ra_batches.attribute8%type,
1509: p_attribute9 IN ra_batches.attribute9%type,
1510: p_attribute10 IN ra_batches.attribute10%type,
1511: p_attribute11 IN ra_batches.attribute11%type,

Line 1508: p_attribute8 IN ra_batches.attribute8%type,

1504: p_attribute4 IN ra_batches.attribute4%type,
1505: p_attribute5 IN ra_batches.attribute5%type,
1506: p_attribute6 IN ra_batches.attribute6%type,
1507: p_attribute7 IN ra_batches.attribute7%type,
1508: p_attribute8 IN ra_batches.attribute8%type,
1509: p_attribute9 IN ra_batches.attribute9%type,
1510: p_attribute10 IN ra_batches.attribute10%type,
1511: p_attribute11 IN ra_batches.attribute11%type,
1512: p_attribute12 IN ra_batches.attribute12%type,

Line 1509: p_attribute9 IN ra_batches.attribute9%type,

1505: p_attribute5 IN ra_batches.attribute5%type,
1506: p_attribute6 IN ra_batches.attribute6%type,
1507: p_attribute7 IN ra_batches.attribute7%type,
1508: p_attribute8 IN ra_batches.attribute8%type,
1509: p_attribute9 IN ra_batches.attribute9%type,
1510: p_attribute10 IN ra_batches.attribute10%type,
1511: p_attribute11 IN ra_batches.attribute11%type,
1512: p_attribute12 IN ra_batches.attribute12%type,
1513: p_attribute13 IN ra_batches.attribute13%type,

Line 1510: p_attribute10 IN ra_batches.attribute10%type,

1506: p_attribute6 IN ra_batches.attribute6%type,
1507: p_attribute7 IN ra_batches.attribute7%type,
1508: p_attribute8 IN ra_batches.attribute8%type,
1509: p_attribute9 IN ra_batches.attribute9%type,
1510: p_attribute10 IN ra_batches.attribute10%type,
1511: p_attribute11 IN ra_batches.attribute11%type,
1512: p_attribute12 IN ra_batches.attribute12%type,
1513: p_attribute13 IN ra_batches.attribute13%type,
1514: p_attribute14 IN ra_batches.attribute14%type,

Line 1511: p_attribute11 IN ra_batches.attribute11%type,

1507: p_attribute7 IN ra_batches.attribute7%type,
1508: p_attribute8 IN ra_batches.attribute8%type,
1509: p_attribute9 IN ra_batches.attribute9%type,
1510: p_attribute10 IN ra_batches.attribute10%type,
1511: p_attribute11 IN ra_batches.attribute11%type,
1512: p_attribute12 IN ra_batches.attribute12%type,
1513: p_attribute13 IN ra_batches.attribute13%type,
1514: p_attribute14 IN ra_batches.attribute14%type,
1515: p_attribute15 IN ra_batches.attribute15%type)

Line 1512: p_attribute12 IN ra_batches.attribute12%type,

1508: p_attribute8 IN ra_batches.attribute8%type,
1509: p_attribute9 IN ra_batches.attribute9%type,
1510: p_attribute10 IN ra_batches.attribute10%type,
1511: p_attribute11 IN ra_batches.attribute11%type,
1512: p_attribute12 IN ra_batches.attribute12%type,
1513: p_attribute13 IN ra_batches.attribute13%type,
1514: p_attribute14 IN ra_batches.attribute14%type,
1515: p_attribute15 IN ra_batches.attribute15%type)
1516: IS

Line 1513: p_attribute13 IN ra_batches.attribute13%type,

1509: p_attribute9 IN ra_batches.attribute9%type,
1510: p_attribute10 IN ra_batches.attribute10%type,
1511: p_attribute11 IN ra_batches.attribute11%type,
1512: p_attribute12 IN ra_batches.attribute12%type,
1513: p_attribute13 IN ra_batches.attribute13%type,
1514: p_attribute14 IN ra_batches.attribute14%type,
1515: p_attribute15 IN ra_batches.attribute15%type)
1516: IS
1517: l_batch_rec ra_batches%rowtype;

Line 1514: p_attribute14 IN ra_batches.attribute14%type,

1510: p_attribute10 IN ra_batches.attribute10%type,
1511: p_attribute11 IN ra_batches.attribute11%type,
1512: p_attribute12 IN ra_batches.attribute12%type,
1513: p_attribute13 IN ra_batches.attribute13%type,
1514: p_attribute14 IN ra_batches.attribute14%type,
1515: p_attribute15 IN ra_batches.attribute15%type)
1516: IS
1517: l_batch_rec ra_batches%rowtype;
1518: BEGIN

Line 1515: p_attribute15 IN ra_batches.attribute15%type)

1511: p_attribute11 IN ra_batches.attribute11%type,
1512: p_attribute12 IN ra_batches.attribute12%type,
1513: p_attribute13 IN ra_batches.attribute13%type,
1514: p_attribute14 IN ra_batches.attribute14%type,
1515: p_attribute15 IN ra_batches.attribute15%type)
1516: IS
1517: l_batch_rec ra_batches%rowtype;
1518: BEGIN
1519: arp_util.debug('arp_tbat_pkg.lock_compare_cover()+');

Line 1517: l_batch_rec ra_batches%rowtype;

1513: p_attribute13 IN ra_batches.attribute13%type,
1514: p_attribute14 IN ra_batches.attribute14%type,
1515: p_attribute15 IN ra_batches.attribute15%type)
1516: IS
1517: l_batch_rec ra_batches%rowtype;
1518: BEGIN
1519: arp_util.debug('arp_tbat_pkg.lock_compare_cover()+');
1520:
1521: arp_tbat_pkg.set_to_dummy(l_batch_rec);

Line 1606: | This procedure deletes the ra_batches row identified by the p_batch_id |

1602: | PROCEDURE |
1603: | delete_p |
1604: | |
1605: | DESCRIPTION |
1606: | This procedure deletes the ra_batches row identified by the p_batch_id |
1607: | parameter. |
1608: | |
1609: | SCOPE - PUBLIC |
1610: | |

Line 1628: procedure delete_p( p_batch_id IN ra_batches.batch_id%type) IS

1624: | 06-JUN-95 Charlie Tomberg Created |
1625: | |
1626: +===========================================================================*/
1627:
1628: procedure delete_p( p_batch_id IN ra_batches.batch_id%type) IS
1629:
1630: l_count number;
1631:
1632: BEGIN

Line 1649: delete FROM ra_batches

1645: WHERE batch_id = p_batch_id;
1646:
1647: IF (l_count = 0)
1648: THEN
1649: delete FROM ra_batches
1650: where batch_id = p_batch_id;
1651: /*---------------------------------+
1652: | Calling central MRC library |
1653: | for MRC integration |

Line 1658: -- p_table_name => 'RA_BATCHES',

1654: +----------------------------------*/
1655: --{BUG#4301323
1656: -- ar_mrc_engine.maintain_mrc_data(
1657: -- p_event_mode => 'DELETE',
1658: -- p_table_name => 'RA_BATCHES',
1659: -- p_mode => 'SINGLE',
1660: -- p_key_value => p_batch_id );
1661: --}
1662: ELSE

Line 1681: | This procedure deletes the ra_batches rows identified by the |

1677: | PROCEDURE |
1678: | delete_f_bs_id |
1679: | |
1680: | DESCRIPTION |
1681: | This procedure deletes the ra_batches rows identified by the |
1682: | p_batch_source_id parameter. |
1683: | |
1684: | SCOPE - PUBLIC |
1685: | |

Line 1704: ra_batches.batch_source_id%type) IS

1700: | |
1701: +===========================================================================*/
1702:
1703: procedure delete_f_bs_id( p_batch_source_id IN
1704: ra_batches.batch_source_id%type) IS
1705:
1706: l_count number;
1707:
1708: BEGIN

Line 1725: DELETE FROM ra_batches

1721: WHERE batch_source_id = p_batch_source_id;
1722:
1723: IF (l_count = 0)
1724: THEN
1725: DELETE FROM ra_batches
1726: WHERE batch_id = p_batch_source_id;
1727: /*---------------------------------+
1728: | Calling central MRC library |
1729: | for MRC integration |

Line 1734: -- p_table_name => 'RA_BATCHES',

1730: +----------------------------------*/
1731: --{BUG4301323
1732: -- ar_mrc_engine.maintain_mrc_data(
1733: -- p_event_mode => 'DELETE',
1734: -- p_table_name => 'RA_BATCHES',
1735: -- p_mode => 'SINGLE',
1736: -- p_key_value => p_batch_source_id );
1737: --}
1738: ELSE

Line 1758: | This procedure updates the ra_batches row identified by the p_batch_id |

1754: | PROCEDURE |
1755: | update_p |
1756: | |
1757: | DESCRIPTION |
1758: | This procedure updates the ra_batches row identified by the p_batch_id |
1759: | parameter. |
1760: | |
1761: | SCOPE - PUBLIC |
1762: | |

Line 1783: PROCEDURE update_p( p_batch_rec IN ra_batches%rowtype,

1779: | 06-JUN-95 Charlie Tomberg Created |
1780: | |
1781: +===========================================================================*/
1782:
1783: PROCEDURE update_p( p_batch_rec IN ra_batches%rowtype,
1784: p_batch_id IN ra_batches.batch_id%type) IS
1785:
1786:
1787: BEGIN

Line 1784: p_batch_id IN ra_batches.batch_id%type) IS

1780: | |
1781: +===========================================================================*/
1782:
1783: PROCEDURE update_p( p_batch_rec IN ra_batches%rowtype,
1784: p_batch_id IN ra_batches.batch_id%type) IS
1785:
1786:
1787: BEGIN
1788:

Line 1810: | This procedure updates the ra_batches rows that are contained in a |

1806: | PROCEDURE |
1807: | update_f_bs_id |
1808: | |
1809: | DESCRIPTION |
1810: | This procedure updates the ra_batches rows that are contained in a |
1811: | particular batch source. |
1812: | |
1813: | SCOPE - PUBLIC |
1814: | |

Line 1835: PROCEDURE update_f_bs_id( p_batch_rec IN ra_batches%rowtype,

1831: | 06-JUN-95 Charlie Tomberg Created |
1832: | |
1833: +===========================================================================*/
1834:
1835: PROCEDURE update_f_bs_id( p_batch_rec IN ra_batches%rowtype,
1836: p_batch_source_id
1837: IN ra_batch_sources.batch_source_id%type) IS
1838:
1839:

Line 1863: | This procedure inserts a row into ra_batches that contains the column |

1859: | PROCEDURE |
1860: | insert_p |
1861: | |
1862: | DESCRIPTION |
1863: | This procedure inserts a row into ra_batches that contains the column |
1864: | values specified in the p_batch_rec parameter. |
1865: | |
1866: | SCOPE - PUBLIC |
1867: | |

Line 1897: p_batch_rec IN ra_batches%rowtype,

1893: | |
1894: +===========================================================================*/
1895:
1896: PROCEDURE insert_p(
1897: p_batch_rec IN ra_batches%rowtype,
1898: p_batch_id OUT NOCOPY ra_batches.batch_id%type,
1899: p_name OUT NOCOPY ra_batches.name%type
1900: ) IS
1901:

Line 1898: p_batch_id OUT NOCOPY ra_batches.batch_id%type,

1894: +===========================================================================*/
1895:
1896: PROCEDURE insert_p(
1897: p_batch_rec IN ra_batches%rowtype,
1898: p_batch_id OUT NOCOPY ra_batches.batch_id%type,
1899: p_name OUT NOCOPY ra_batches.name%type
1900: ) IS
1901:
1902:

Line 1899: p_name OUT NOCOPY ra_batches.name%type

1895:
1896: PROCEDURE insert_p(
1897: p_batch_rec IN ra_batches%rowtype,
1898: p_batch_id OUT NOCOPY ra_batches.batch_id%type,
1899: p_name OUT NOCOPY ra_batches.name%type
1900: ) IS
1901:
1902:
1903: l_batch_id ra_batches.batch_id%type;

Line 1903: l_batch_id ra_batches.batch_id%type;

1899: p_name OUT NOCOPY ra_batches.name%type
1900: ) IS
1901:
1902:
1903: l_batch_id ra_batches.batch_id%type;
1904: l_batch_name ra_batches.name%type;
1905: l_ra_batches_value_list gl_ca_utility_pkg.r_key_value_arr; /* MRC */
1906:
1907: BEGIN

Line 1904: l_batch_name ra_batches.name%type;

1900: ) IS
1901:
1902:
1903: l_batch_id ra_batches.batch_id%type;
1904: l_batch_name ra_batches.name%type;
1905: l_ra_batches_value_list gl_ca_utility_pkg.r_key_value_arr; /* MRC */
1906:
1907: BEGIN
1908:

Line 1905: l_ra_batches_value_list gl_ca_utility_pkg.r_key_value_arr; /* MRC */

1901:
1902:
1903: l_batch_id ra_batches.batch_id%type;
1904: l_batch_name ra_batches.name%type;
1905: l_ra_batches_value_list gl_ca_utility_pkg.r_key_value_arr; /* MRC */
1906:
1907: BEGIN
1908:
1909: arp_util.debug('arp_tbat_pkg.insert_p()+');

Line 1917: SELECT RA_BATCHES_S.NEXTVAL

1913: /*---------------------------*
1914: | Get the unique identifier |
1915: *---------------------------*/
1916:
1917: SELECT RA_BATCHES_S.NEXTVAL
1918: INTO l_batch_id
1919: FROM DUAL;
1920:
1921: /*-----------------------------------------------------------------*

Line 1947: INSERT INTO ra_batches

1943: /*-------------------*
1944: | Insert the record |
1945: *-------------------*/
1946:
1947: INSERT INTO ra_batches
1948: (
1949: batch_id,
1950: last_update_date,
1951: last_updated_by,

Line 2058: -- p_table_name => 'RA_BATCHES',

2054: +----------------------------------*/
2055: --{BUG4301323
2056: -- ar_mrc_engine.maintain_mrc_data(
2057: -- p_event_mode => 'INSERT',
2058: -- p_table_name => 'RA_BATCHES',
2059: -- p_mode => 'SINGLE',
2060: -- p_key_value => l_batch_id);
2061: --}
2062: arp_util.debug('arp_tbat_pkg.insert_p()-');