554: arp_util.debug('EXCEPTION: arp_process_batch.validate_selection()');
555: arp_util.debug('validate_selection: ' || '');
556: arp_util.debug('------ parameters for validate_selection() -------');
557: END IF;
558: arp_selection_criteria_pkg.display_selection_rec(p_sel_rec);
559: RAISE;
560:
561: END validate_selection;
562:
603: arp_util.debug('EXCEPTION: arp_process_batches.Is_Selection_Entered ()');
604: arp_util.debug('Is_Selection_Entered: ' || '');
605: arp_util.debug('Is_Selection_Entered: ' || '------ parameters for validate_selection() -------');
606: END IF;
607: arp_selection_criteria_pkg.display_selection_rec(p_sel_rec);
608: RAISE;
609:
610: END Is_Selection_Entered;
611:
815: /*-------------------------------------------------------------+
816: | Call Table Handler to insert the selection |
817: +-------------------------------------------------------------*/
818:
819: arp_selection_criteria_pkg.insert_p (l_sel_rec, p_selection_criteria_id);
820:
821:
822: /*-------------------------------------------------------------+
823: | Update the Batch information with the Selection Criteria ID |
1068: +---------------------------------------------------------------*/
1069:
1070: IF (p_selection_criteria_id IS NOT NULL)
1071: THEN
1072: arp_selection_criteria_pkg.set_to_dummy(l_sel_rec);
1073: END IF;
1074:
1075: l_sel_rec.due_date_low := p_due_date_low ;
1076: l_sel_rec.due_date_high := p_due_date_high ;
1103: /*-------------------------------------------------------------+
1104: | Call Table Handler to insert the selection |
1105: +-------------------------------------------------------------*/
1106:
1107: arp_selection_criteria_pkg.insert_p ( l_sel_rec, p_selection_criteria_id);
1108:
1109: /*-------------------------------------------------------------+
1110: | Update the Batch information with the Selection Criteria ID |
1111: +-------------------------------------------------------------*/
1119: /*-------------------------------------------------------------+
1120: | Call Table Handler to update the selection |
1121: +-------------------------------------------------------------*/
1122:
1123: arp_selection_criteria_pkg.update_p (l_sel_rec, p_selection_criteria_id);
1124:
1125: END IF;
1126:
1127: END IF;
1243: +---------------------------------------------------------------*/
1244:
1245: IF (p_selection_criteria_id IS NOT NULL)
1246: THEN
1247: arp_selection_criteria_pkg.delete_p (p_selection_criteria_id);
1248: END IF;
1249:
1250:
1251: /*---------------------------------------------------------------+
1400: +---------------------------------------------------------------*/
1401:
1402: IF (p_selection_criteria_id IS NOT NULL)
1403: THEN
1404: ARP_SELECTION_CRITERIA_PKG.set_to_dummy(l_sel_rec);
1405:
1406: l_sel_rec.selection_criteria_id := p_selection_criteria_id;
1407: l_sel_rec.due_date_low := p_due_date_low;
1408: l_sel_rec.due_date_high := p_due_date_high;
1417: l_sel_rec.customer_category_code:= p_customer_category_code;
1418: l_sel_rec.customer_id := p_customer_id;
1419: l_sel_rec.site_use_id := p_site_use_id;
1420:
1421: arp_selection_criteria_pkg.display_selection_rec (l_sel_rec);
1422:
1423: ARP_SELECTION_CRITERIA_PKG.lock_compare_p(l_sel_rec,p_selection_criteria_id);
1424:
1425: END IF;
1419: l_sel_rec.site_use_id := p_site_use_id;
1420:
1421: arp_selection_criteria_pkg.display_selection_rec (l_sel_rec);
1422:
1423: ARP_SELECTION_CRITERIA_PKG.lock_compare_p(l_sel_rec,p_selection_criteria_id);
1424:
1425: END IF;
1426:
1427: