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 AR_SELECTION_CRITERIA_S

Line 126: PROCEDURE display_selection ( p_sel_id IN ar_selection_criteria.selection_criteria_id%TYPE)

122: | 17-APR-2000 Tien Tran Created |
123: | |
124: +===========================================================================*/
125:
126: PROCEDURE display_selection ( p_sel_id IN ar_selection_criteria.selection_criteria_id%TYPE)
127:
128: IS
129:
130: l_sel_rec ar_selection_criteria%rowtype;

Line 248: p_sel_id IN ar_selection_criteria.selection_criteria_id%TYPE ) IS

244: | |
245: +===========================================================================*/
246:
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:

Line 295: PROCEDURE lock_p( p_sel_id IN ar_selection_criteria.selection_criteria_id%TYPE )

291: | 17-APR-2000 Tien Tran Created |
292: | |
293: +===========================================================================*/
294:
295: PROCEDURE lock_p( p_sel_id IN ar_selection_criteria.selection_criteria_id%TYPE )
296:
297: IS
298:
299: l_sel_id ar_selection_criteria.selection_criteria_id%TYPE;

Line 299: l_sel_id ar_selection_criteria.selection_criteria_id%TYPE;

295: PROCEDURE lock_p( p_sel_id IN ar_selection_criteria.selection_criteria_id%TYPE )
296:
297: IS
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:

Line 348: p_sel_id IN ar_selection_criteria.selection_criteria_id%TYPE )

344: | |
345: +===========================================================================*/
346:
347: PROCEDURE lock_fetch_p( p_sel_rec IN OUT NOCOPY ar_selection_criteria%rowtype ,
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()+');

Line 400: p_sel_id IN ar_selection_criteria.selection_criteria_id%TYPE )

396: | |
397: +===========================================================================*/
398:
399: PROCEDURE lock_compare_p( p_sel_rec IN ar_selection_criteria%rowtype ,
400: p_sel_id IN ar_selection_criteria.selection_criteria_id%TYPE )
401: IS
402:
403: l_new_sel_rec ar_selection_criteria%rowtype;
404:

Line 629: p_selection_criteria_id IN ar_selection_criteria.selection_criteria_id%TYPE ,

625:
626: PROCEDURE lock_compare_cover(
627: p_form_name IN varchar2 ,
628: p_form_version IN number ,
629: p_selection_criteria_id IN ar_selection_criteria.selection_criteria_id%TYPE ,
630: p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,
631: p_due_date_high IN ar_selection_criteria.due_date_high%TYPE ,
632: p_trx_date_low IN ar_selection_criteria.trx_date_low%TYPE ,
633: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE ,

Line 642: p_site_use_id IN ar_selection_criteria.site_use_id%TYPE )

638: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
639: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,
640: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE ,
641: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,
642: p_site_use_id IN ar_selection_criteria.site_use_id%TYPE )
643:
644: IS
645:
646: l_sel_rec ar_selection_criteria%rowtype;

Line 725: procedure delete_p( p_sel_id IN ar_selection_criteria.selection_criteria_id%TYPE) IS

721: | 17-APR-2000 Tien Tran Created |
722: | |
723: +===========================================================================*/
724:
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()+');

Line 775: p_sel_id IN ar_selection_criteria.selection_criteria_id%TYPE) IS

771: | |
772: +===========================================================================*/
773:
774: PROCEDURE update_p( p_sel_rec IN ar_selection_criteria%rowtype,
775: p_sel_id IN ar_selection_criteria.selection_criteria_id%TYPE) IS
776:
777:
778: BEGIN
779:

Line 782: UPDATE AR_SELECTION_CRITERIA SET

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 =
785: DECODE( p_sel_rec.due_date_low,
786: AR_DATE_DUMMY, due_date_low,

Line 896: p_sel_id OUT NOCOPY ar_selection_criteria.selection_criteria_id%TYPE )

892: | |
893: +===========================================================================*/
894:
895: PROCEDURE insert_p( p_sel_rec IN ar_selection_criteria%rowtype ,
896: p_sel_id OUT NOCOPY ar_selection_criteria.selection_criteria_id%TYPE )
897:
898: IS
899: l_sel_id ar_selection_criteria.selection_criteria_id%TYPE;
900:

Line 899: l_sel_id ar_selection_criteria.selection_criteria_id%TYPE;

895: PROCEDURE insert_p( p_sel_rec IN ar_selection_criteria%rowtype ,
896: p_sel_id OUT NOCOPY ar_selection_criteria.selection_criteria_id%TYPE )
897:
898: IS
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()+');

Line 911: SELECT AR_SELECTION_CRITERIA_S.NEXTVAL

907: /*---------------------------*
908: | Get the unique identifier |
909: *---------------------------*/
910:
911: SELECT AR_SELECTION_CRITERIA_S.NEXTVAL
912: INTO l_sel_id
913: FROM DUAL;
914:
915: /*-------------------*