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

Line 58: PROCEDURE display_selection_rec( p_sel_rec IN ar_selection_criteria%rowtype )

54: | |
55: | |
56: +===========================================================================*/
57:
58: PROCEDURE display_selection_rec( p_sel_rec IN ar_selection_criteria%rowtype )
59:
60: IS
61:
62: BEGIN

Line 66: arp_util.debug(' Dump of ar_selection_criteria record ');

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);
69: arp_util.debug('created_by: ' || p_sel_rec.created_by);
70: arp_util.debug('last_update_login: ' || p_sel_rec.last_update_login);

Line 85: arp_util.debug(' End ar_selection_criteria record ');

81: arp_util.debug('customer_category_code: ' || p_sel_rec.customer_category_code);
82: arp_util.debug('customer_id : ' || p_sel_rec.customer_id);
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

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 130: l_sel_rec ar_selection_criteria%rowtype;

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;
131:
132: BEGIN
133:
134: arp_util.debug('arp_selection_criteria_pkg.display_selection()+');

Line 183: PROCEDURE set_to_dummy( p_sel_rec OUT NOCOPY ar_selection_criteria%rowtype) IS

179: | |
180: | |
181: +===========================================================================*/
182:
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()+');

Line 224: | This procedure fetches a single row from ar_selection_criteria into a |

220: | PROCEDURE |
221: | fetch_p |
222: | |
223: | DESCRIPTION |
224: | This procedure fetches a single row from ar_selection_criteria into a |
225: | variable specified as a parameter based on the table's primary key, |
226: | selection_criteria_id. |
227: | |
228: | SCOPE - PUBLIC |

Line 247: PROCEDURE fetch_p( p_sel_rec OUT NOCOPY ar_selection_criteria%rowtype ,

243: | 17-APR-2000 Tien Tran Created |
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()+');

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 255: FROM ar_selection_criteria

251: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.fetch_p()+');
252:
253: SELECT *
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:

Line 273: | This procedure locks the ar_selection_criteria row identified by the |

269: | PROCEDURE |
270: | lock_p |
271: | |
272: | DESCRIPTION |
273: | This procedure locks the ar_selection_criteria row identified by the |
274: | p_selection_criteria_id parameter. |
275: | |
276: | SCOPE - PUBLIC |
277: | |

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 306: FROM ar_selection_criteria

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
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()-');

Line 324: | This procedure locks the ar_selection_criteria row identified by the |

320: | PROCEDURE |
321: | lock_fetch_p |
322: | |
323: | DESCRIPTION |
324: | This procedure locks the ar_selection_criteria row identified by the |
325: | p_sel_id parameter and populates the p_sel_rec parameter |
326: | with the row that was locked. |
327: | |
328: | SCOPE - PUBLIC |

Line 347: PROCEDURE lock_fetch_p( p_sel_rec IN OUT NOCOPY ar_selection_criteria%rowtype ,

343: | 17-APR-2000 Tien Tran Created |
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

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 356: FROM ar_selection_criteria

352: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_fetch_p()+');
353:
354: SELECT *
355: INTO p_sel_rec
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()-');

Line 374: | This procedure locks the ar_selection_criteria row identified by the |

370: | PROCEDURE |
371: | lock_compare_p |
372: | |
373: | DESCRIPTION |
374: | This procedure locks the ar_selection_criteria row identified by the |
375: | p_sel_id parameter only if no columns in that row have |
376: | changed from when they were first selected in the form |
377: | |
378: | SCOPE - PUBLIC |

Line 399: PROCEDURE lock_compare_p( p_sel_rec IN ar_selection_criteria%rowtype ,

395: | |
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;

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 403: l_new_sel_rec ar_selection_criteria%rowtype;

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:
405: BEGIN
406: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_compare_p()+');
407:

Line 410: FROM ar_selection_criteria tsel

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
411: WHERE tsel.selection_criteria_id = p_sel_id
412: AND NOT
413:
414: (

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 630: p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,

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 ,
634: p_cust_trx_type_id IN ar_selection_criteria.cust_trx_type_id%TYPE ,

Line 631: p_due_date_high IN ar_selection_criteria.due_date_high%TYPE ,

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 ,
634: p_cust_trx_type_id IN ar_selection_criteria.cust_trx_type_id%TYPE ,
635: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,

Line 632: p_trx_date_low IN ar_selection_criteria.trx_date_low%TYPE ,

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 ,
634: p_cust_trx_type_id IN ar_selection_criteria.cust_trx_type_id%TYPE ,
635: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
636: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,

Line 633: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE ,

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 ,
634: p_cust_trx_type_id IN ar_selection_criteria.cust_trx_type_id%TYPE ,
635: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
636: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
637: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,

Line 634: p_cust_trx_type_id IN ar_selection_criteria.cust_trx_type_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 ,
634: p_cust_trx_type_id IN ar_selection_criteria.cust_trx_type_id%TYPE ,
635: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
636: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
637: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
638: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,

Line 635: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%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 ,
634: p_cust_trx_type_id IN ar_selection_criteria.cust_trx_type_id%TYPE ,
635: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
636: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
637: p_trx_number_low IN ar_selection_criteria.trx_number_low%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 ,

Line 636: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%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 ,
634: p_cust_trx_type_id IN ar_selection_criteria.cust_trx_type_id%TYPE ,
635: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
636: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
637: p_trx_number_low IN ar_selection_criteria.trx_number_low%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 ,

Line 637: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,

633: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE ,
634: p_cust_trx_type_id IN ar_selection_criteria.cust_trx_type_id%TYPE ,
635: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
636: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
637: p_trx_number_low IN ar_selection_criteria.trx_number_low%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 ,

Line 638: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,

634: p_cust_trx_type_id IN ar_selection_criteria.cust_trx_type_id%TYPE ,
635: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
636: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
637: p_trx_number_low IN ar_selection_criteria.trx_number_low%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 )

Line 639: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,

635: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
636: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
637: p_trx_number_low IN ar_selection_criteria.trx_number_low%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:

Line 640: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE ,

636: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
637: p_trx_number_low IN ar_selection_criteria.trx_number_low%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

Line 641: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,

637: p_trx_number_low IN ar_selection_criteria.trx_number_low%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:

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 646: l_sel_rec ar_selection_criteria%rowtype;

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;
647:
648: BEGIN
649: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_compare_cover()+');
650:

Line 676: arp_util.debug(' Dump of ar_selection_criteria record ');

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);
679: arp_util.debug('p_due_date_high: ' || p_due_date_high);
680: arp_util.debug('p_trx_date_low: ' || p_trx_date_low);

Line 692: arp_util.debug(' End ar_selection_criteria record ');

688: arp_util.debug('p_customer_category_code: ' || p_customer_category_code);
689: arp_util.debug('p_customer_id : ' || p_customer_id);
690: arp_util.debug('p_site_use_id: ' || p_site_use_id);
691:
692: arp_util.debug('************** End ar_selection_criteria record **************');
693:
694:
695: RAISE;
696: END;

Line 703: | This procedure deletes the ar_selection_criteria row identified by the |

699: | PROCEDURE |
700: | delete_p |
701: | |
702: | DESCRIPTION |
703: | This procedure deletes the ar_selection_criteria row identified by the |
704: | p_sel_id parameter. |
705: | |
706: | SCOPE - PUBLIC |
707: | |

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 731: DELETE FROM ar_selection_criteria

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:
734: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.delete_p()-');
735:

Line 749: | This procedure updates the ar_selection_criteria row identified by the |

745: | PROCEDURE |
746: | update_p |
747: | |
748: | DESCRIPTION |
749: | This procedure updates the ar_selection_criteria row identified by the |
750: | p_sel_id parameter. |
751: | |
752: | SCOPE - PUBLIC |
753: | |

Line 774: PROCEDURE update_p( p_sel_rec IN ar_selection_criteria%rowtype,

770: | 17-APR-2000 Tien Tran Created |
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

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 871: | This procedure inserts a row into ar_selection_criteria that contains |

867: | PROCEDURE |
868: | insert_p |
869: | |
870: | DESCRIPTION |
871: | This procedure inserts a row into ar_selection_criteria that contains |
872: | the column values specified in the p_sel_rec parameter. |
873: | |
874: | SCOPE - PUBLIC |
875: | |

Line 895: PROCEDURE insert_p( p_sel_rec IN ar_selection_criteria%rowtype ,

891: | |
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;

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: /*-------------------*

Line 919: INSERT INTO ar_selection_criteria

915: /*-------------------*
916: | Insert the record |
917: *-------------------*/
918:
919: INSERT INTO ar_selection_criteria
920: (
921: selection_criteria_id,
922: last_update_date,
923: last_updated_by,