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_SELECTION_CRITERIA_PKG dependencies on ARP_SELECTION_CRITERIA_PKG

Line 1: PACKAGE BODY ARP_SELECTION_CRITERIA_PKG AS

1: PACKAGE BODY ARP_SELECTION_CRITERIA_PKG AS
2: /* $Header: ARBRSELB.pls 120.5 2005/10/30 03:49:01 appldev ship $ */
3:
4: /*--------------------------------------------------------+
5: | Dummy constants for use in update and lock operations |

Line 64: arp_util.debug('arp_selection_criteria_pkg.display_selection_rec()+');

60: IS
61:
62: BEGIN
63:
64: arp_util.debug('arp_selection_criteria_pkg.display_selection_rec()+');
65:
66: arp_util.debug('************** Dump of ar_selection_criteria record **************');
67: arp_util.debug('selection_criteria_id: ' || p_sel_rec.selection_criteria_id);
68: arp_util.debug('last_updated_by: ' || p_sel_rec.last_updated_by);

Line 87: arp_util.debug('arp_selection_criteria_pkg.display_selection_rec()-');

83: arp_util.debug('site_use_id: ' || p_sel_rec.site_use_id);
84:
85: arp_util.debug('************** End ar_selection_criteria record **************');
86:
87: arp_util.debug('arp_selection_criteria_pkg.display_selection_rec()-');
88:
89: EXCEPTION
90: WHEN OTHERS THEN
91: arp_util.debug('EXCEPTION: arp_selection_criteria_pkg.display_selection_rec()');

Line 91: arp_util.debug('EXCEPTION: arp_selection_criteria_pkg.display_selection_rec()');

87: arp_util.debug('arp_selection_criteria_pkg.display_selection_rec()-');
88:
89: EXCEPTION
90: WHEN OTHERS THEN
91: arp_util.debug('EXCEPTION: arp_selection_criteria_pkg.display_selection_rec()');
92: RAISE;
93:
94: END;
95:

Line 134: arp_util.debug('arp_selection_criteria_pkg.display_selection()+');

130: l_sel_rec ar_selection_criteria%rowtype;
131:
132: BEGIN
133:
134: arp_util.debug('arp_selection_criteria_pkg.display_selection()+');
135:
136: ARP_SELECTION_CRITERIA_PKG.fetch_p(l_sel_rec, p_sel_id);
137:
138: ARP_SELECTION_CRITERIA_PKG.display_selection_rec (l_sel_rec);

Line 136: ARP_SELECTION_CRITERIA_PKG.fetch_p(l_sel_rec, p_sel_id);

132: BEGIN
133:
134: arp_util.debug('arp_selection_criteria_pkg.display_selection()+');
135:
136: ARP_SELECTION_CRITERIA_PKG.fetch_p(l_sel_rec, p_sel_id);
137:
138: ARP_SELECTION_CRITERIA_PKG.display_selection_rec (l_sel_rec);
139:
140: arp_util.debug('arp_selection_criteria_pkg.display_selection()-');

Line 138: ARP_SELECTION_CRITERIA_PKG.display_selection_rec (l_sel_rec);

134: arp_util.debug('arp_selection_criteria_pkg.display_selection()+');
135:
136: ARP_SELECTION_CRITERIA_PKG.fetch_p(l_sel_rec, p_sel_id);
137:
138: ARP_SELECTION_CRITERIA_PKG.display_selection_rec (l_sel_rec);
139:
140: arp_util.debug('arp_selection_criteria_pkg.display_selection()-');
141:
142: EXCEPTION

Line 140: arp_util.debug('arp_selection_criteria_pkg.display_selection()-');

136: ARP_SELECTION_CRITERIA_PKG.fetch_p(l_sel_rec, p_sel_id);
137:
138: ARP_SELECTION_CRITERIA_PKG.display_selection_rec (l_sel_rec);
139:
140: arp_util.debug('arp_selection_criteria_pkg.display_selection()-');
141:
142: EXCEPTION
143: WHEN OTHERS THEN
144: arp_util.debug('EXCEPTION: arp_selection_criteria_pkg.display_selection()');

Line 144: arp_util.debug('EXCEPTION: arp_selection_criteria_pkg.display_selection()');

140: arp_util.debug('arp_selection_criteria_pkg.display_selection()-');
141:
142: EXCEPTION
143: WHEN OTHERS THEN
144: arp_util.debug('EXCEPTION: arp_selection_criteria_pkg.display_selection()');
145: RAISE;
146:
147: END;
148:

Line 187: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.set_to_dummy()+');

183: PROCEDURE set_to_dummy( p_sel_rec OUT NOCOPY ar_selection_criteria%rowtype) IS
184:
185: BEGIN
186:
187: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.set_to_dummy()+');
188:
189: p_sel_rec.selection_criteria_id := AR_NUMBER_DUMMY;
190: p_sel_rec.last_update_date := AR_DATE_DUMMY;
191: p_sel_rec.last_updated_by := AR_NUMBER_DUMMY;

Line 209: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.set_to_dummy()-');

205: p_sel_rec.customer_category_code := AR_TEXT_DUMMY;
206: p_sel_rec.customer_id := AR_NUMBER_DUMMY;
207: p_sel_rec.site_use_id := AR_NUMBER_DUMMY;
208:
209: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.set_to_dummy()-');
210:
211: EXCEPTION
212: WHEN OTHERS THEN
213: arp_util.debug('EXCEPTION: ARP_SELECTION_CRITERIA_PKG.set_to_dummy()');

Line 213: arp_util.debug('EXCEPTION: ARP_SELECTION_CRITERIA_PKG.set_to_dummy()');

209: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.set_to_dummy()-');
210:
211: EXCEPTION
212: WHEN OTHERS THEN
213: arp_util.debug('EXCEPTION: ARP_SELECTION_CRITERIA_PKG.set_to_dummy()');
214: RAISE;
215:
216: END;
217:

Line 251: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.fetch_p()+');

247: PROCEDURE fetch_p( p_sel_rec OUT NOCOPY ar_selection_criteria%rowtype ,
248: p_sel_id IN ar_selection_criteria.selection_criteria_id%TYPE ) IS
249:
250: BEGIN
251: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.fetch_p()+');
252:
253: SELECT *
254: INTO p_sel_rec
255: FROM ar_selection_criteria

Line 258: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.fetch_p()-');

254: INTO p_sel_rec
255: FROM ar_selection_criteria
256: WHERE selection_criteria_id = p_sel_id;
257:
258: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.fetch_p()-');
259:
260: EXCEPTION
261: WHEN OTHERS THEN
262: arp_util.debug('EXCEPTION: ARP_SELECTION_CRITERIA_PKG.fetch_p' );

Line 262: arp_util.debug('EXCEPTION: ARP_SELECTION_CRITERIA_PKG.fetch_p' );

258: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.fetch_p()-');
259:
260: EXCEPTION
261: WHEN OTHERS THEN
262: arp_util.debug('EXCEPTION: ARP_SELECTION_CRITERIA_PKG.fetch_p' );
263: RAISE;
264: END;
265:
266:

Line 302: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_p()+');

298:
299: l_sel_id ar_selection_criteria.selection_criteria_id%TYPE;
300:
301: BEGIN
302: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_p()+');
303:
304: SELECT selection_criteria_id
305: INTO l_sel_id
306: FROM ar_selection_criteria

Line 310: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_p()-');

306: FROM ar_selection_criteria
307: WHERE selection_criteria_id = p_sel_id
308: FOR UPDATE OF selection_criteria_id NOWAIT;
309:
310: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_p()-');
311:
312: EXCEPTION
313: WHEN OTHERS THEN
314: arp_util.debug( 'EXCEPTION: ARP_SELECTION_CRITERIA_PKG.lock_p' );

Line 314: arp_util.debug( 'EXCEPTION: ARP_SELECTION_CRITERIA_PKG.lock_p' );

310: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_p()-');
311:
312: EXCEPTION
313: WHEN OTHERS THEN
314: arp_util.debug( 'EXCEPTION: ARP_SELECTION_CRITERIA_PKG.lock_p' );
315: RAISE;
316: END;
317:
318:

Line 352: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_fetch_p()+');

348: p_sel_id IN ar_selection_criteria.selection_criteria_id%TYPE )
349: IS
350:
351: BEGIN
352: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_fetch_p()+');
353:
354: SELECT *
355: INTO p_sel_rec
356: FROM ar_selection_criteria

Line 360: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_fetch_p()-');

356: FROM ar_selection_criteria
357: WHERE selection_criteria_id = p_sel_id
358: FOR UPDATE OF selection_criteria_id NOWAIT;
359:
360: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_fetch_p()-');
361:
362: EXCEPTION
363: WHEN OTHERS THEN
364: arp_util.debug( 'EXCEPTION: ARP_SELECTION_CRITERIA_PKG.lock_fetch_p' );

Line 364: arp_util.debug( 'EXCEPTION: ARP_SELECTION_CRITERIA_PKG.lock_fetch_p' );

360: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_fetch_p()-');
361:
362: EXCEPTION
363: WHEN OTHERS THEN
364: arp_util.debug( 'EXCEPTION: ARP_SELECTION_CRITERIA_PKG.lock_fetch_p' );
365: RAISE;
366: END;
367:
368:

Line 406: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_compare_p()+');

402:
403: l_new_sel_rec ar_selection_criteria%rowtype;
404:
405: BEGIN
406: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_compare_p()+');
407:
408: SELECT *
409: INTO l_new_sel_rec
410: FROM ar_selection_criteria tsel

Line 572: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_compare_p()-');

568:
569: )
570: FOR UPDATE OF selection_criteria_id NOWAIT;
571:
572: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_compare_p()-');
573:
574: EXCEPTION
575: WHEN OTHERS THEN
576: arp_util.debug( 'EXCEPTION: ARP_SELECTION_CRITERIA_PKG.lock_compare_p' );

Line 576: arp_util.debug( 'EXCEPTION: ARP_SELECTION_CRITERIA_PKG.lock_compare_p' );

572: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_compare_p()-');
573:
574: EXCEPTION
575: WHEN OTHERS THEN
576: arp_util.debug( 'EXCEPTION: ARP_SELECTION_CRITERIA_PKG.lock_compare_p' );
577: RAISE;
578: END;
579:
580:

Line 649: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_compare_cover()+');

645:
646: l_sel_rec ar_selection_criteria%rowtype;
647:
648: BEGIN
649: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_compare_cover()+');
650:
651: ARP_SELECTION_CRITERIA_PKG.set_to_dummy(l_sel_rec);
652:
653: l_sel_rec.selection_criteria_id := p_selection_criteria_id ;

Line 651: ARP_SELECTION_CRITERIA_PKG.set_to_dummy(l_sel_rec);

647:
648: BEGIN
649: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_compare_cover()+');
650:
651: ARP_SELECTION_CRITERIA_PKG.set_to_dummy(l_sel_rec);
652:
653: l_sel_rec.selection_criteria_id := p_selection_criteria_id ;
654: l_sel_rec.due_date_low := p_due_date_low ;
655: l_sel_rec.due_date_high := p_due_date_high ;

Line 668: ARP_SELECTION_CRITERIA_PKG.lock_compare_p(l_sel_rec, p_selection_criteria_id);

664: l_sel_rec.customer_category_code := p_customer_category_code ;
665: l_sel_rec.customer_id := p_customer_id ;
666: l_sel_rec.site_use_id := p_site_use_id ;
667:
668: ARP_SELECTION_CRITERIA_PKG.lock_compare_p(l_sel_rec, p_selection_criteria_id);
669:
670: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_compare_cover()-');
671:
672: EXCEPTION

Line 670: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_compare_cover()-');

666: l_sel_rec.site_use_id := p_site_use_id ;
667:
668: ARP_SELECTION_CRITERIA_PKG.lock_compare_p(l_sel_rec, p_selection_criteria_id);
669:
670: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_compare_cover()-');
671:
672: EXCEPTION
673: WHEN OTHERS THEN
674: arp_util.debug('EXCEPTION : ARP_SELECTION_CRITERIA_PKG.lock_compare_cover');

Line 674: arp_util.debug('EXCEPTION : ARP_SELECTION_CRITERIA_PKG.lock_compare_cover');

670: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_compare_cover()-');
671:
672: EXCEPTION
673: WHEN OTHERS THEN
674: arp_util.debug('EXCEPTION : ARP_SELECTION_CRITERIA_PKG.lock_compare_cover');
675:
676: arp_util.debug('************** Dump of ar_selection_criteria record **************');
677: arp_util.debug('p_selection_criteria_id: ' || p_selection_criteria_id);
678: arp_util.debug('p_due_date_low: ' || p_due_date_low);

Line 729: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.delete_p()+');

725: procedure delete_p( p_sel_id IN ar_selection_criteria.selection_criteria_id%TYPE) IS
726:
727: BEGIN
728:
729: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.delete_p()+');
730:
731: DELETE FROM ar_selection_criteria
732: WHERE selection_criteria_id = p_sel_id;
733:

Line 734: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.delete_p()-');

730:
731: DELETE FROM ar_selection_criteria
732: WHERE selection_criteria_id = p_sel_id;
733:
734: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.delete_p()-');
735:
736: EXCEPTION
737: WHEN OTHERS THEN
738: arp_util.debug('EXCEPTION: ARP_SELECTION_CRITERIA_PKG.delete_p()');

Line 738: arp_util.debug('EXCEPTION: ARP_SELECTION_CRITERIA_PKG.delete_p()');

734: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.delete_p()-');
735:
736: EXCEPTION
737: WHEN OTHERS THEN
738: arp_util.debug('EXCEPTION: ARP_SELECTION_CRITERIA_PKG.delete_p()');
739: RAISE;
740:
741: END;
742:

Line 780: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.update_p()+');

776:
777:
778: BEGIN
779:
780: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.update_p()+');
781:
782: UPDATE AR_SELECTION_CRITERIA SET
783:
784: due_date_low =

Line 856: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.update_p()-');

852:
853: WHERE selection_criteria_id = p_sel_id;
854:
855:
856: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.update_p()-');
857:
858:
859: EXCEPTION
860: WHEN OTHERS THEN

Line 861: arp_util.debug('EXCEPTION: ARP_SELECTION_CRITERIA_PKG.update_p()');

857:
858:
859: EXCEPTION
860: WHEN OTHERS THEN
861: arp_util.debug('EXCEPTION: ARP_SELECTION_CRITERIA_PKG.update_p()');
862: RAISE;
863: END;
864:
865:

Line 903: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.insert_p()+');

899: l_sel_id ar_selection_criteria.selection_criteria_id%TYPE;
900:
901: BEGIN
902:
903: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.insert_p()+');
904:
905: p_sel_id := '';
906:
907: /*---------------------------*

Line 967: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.insert_p()-');

963: );
964:
965: p_sel_id := l_sel_id;
966:
967: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.insert_p()-');
968:
969: EXCEPTION
970: WHEN OTHERS THEN
971: arp_util.debug('EXCEPTION: ARP_SELECTION_CRITERIA_PKG.insert_p()');

Line 971: arp_util.debug('EXCEPTION: ARP_SELECTION_CRITERIA_PKG.insert_p()');

967: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.insert_p()-');
968:
969: EXCEPTION
970: WHEN OTHERS THEN
971: arp_util.debug('EXCEPTION: ARP_SELECTION_CRITERIA_PKG.insert_p()');
972: RAISE;
973: END;
974:
975:

Line 994: END ARP_SELECTION_CRITERIA_PKG;

990: pg_set_of_books_id := arp_global.set_of_books_id;
991:
992:
993:
994: END ARP_SELECTION_CRITERIA_PKG;