APPS.ARP_PROGRAM_GENERATE_BR dependencies on AR_SELECTION_CRITERIA

Line 738: -- Insert the batch header in RA_BATCHES and the criteria in AR_SELECTION_CRITERIA

734:
735: -- Temporary table Creation
736: ARP_PROGRAM_GENERATE_BR.arbr_cr_tmp_table;
737:
738: -- Insert the batch header in RA_BATCHES and the criteria in AR_SELECTION_CRITERIA
739: ARP_PROGRAM_GENERATE_BR.create_batch_header(
740: p_batch_source_id,
741: p_batch_date,
742: p_gl_date,

Line 938: -- Insert the batch header in RA_BATCHES and the criteria in AR_SELECTION_CRITERIA

934: FND_MESSAGE.set_token('GENERIC_TEXT',l_error_message);
935: APP_EXCEPTION.raise_exception;
936: END IF;
937:
938: -- Insert the batch header in RA_BATCHES and the criteria in AR_SELECTION_CRITERIA
939: arp_process_br_batches.insert_batch('FNDRSRUN', -- p_form_name
940: NULL, -- p_form_version
941: p_batch_source_id, -- p_batch_source_id
942: p_batch_date, -- p_batch_date

Line 1027: l_criteria_rec AR_SELECTION_CRITERIA%ROWTYPE;

1023: p_draft_mode IN VARCHAR2,
1024: p_batch_id IN RA_BATCHES.batch_id%TYPE) IS
1025:
1026: l_batch_rec RA_BATCHES%ROWTYPE;
1027: l_criteria_rec AR_SELECTION_CRITERIA%ROWTYPE;
1028:
1029: l_selection_criteria_id RA_BATCHES.selection_criteria_id%TYPE;
1030: l_status RA_BATCHES.batch_process_status%TYPE;
1031:

Line 1044: from ar_selection_criteria

1040: -- fetch the criteria
1041: IF (l_batch_rec.selection_criteria_id IS NOT NULL) THEN
1042: Select *
1043: into l_criteria_rec
1044: from ar_selection_criteria
1045: where selection_criteria_id = l_batch_rec.selection_criteria_id;
1046: END IF;
1047:
1048: -- Update the batch status to 'CREATION_COMPLETED' if the batch run in Create mode.