APPS.ARP_PROGRAM_GENERATE_BR dependencies on AR_SELECTION_CRITERIA

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

754:
755: -- Temporary table Creation
756: ARP_PROGRAM_GENERATE_BR.arbr_cr_tmp_table;
757:
758: -- Insert the batch header in RA_BATCHES and the criteria in AR_SELECTION_CRITERIA
759: ARP_PROGRAM_GENERATE_BR.create_batch_header(
760: p_batch_source_id,
761: p_batch_date,
762: p_gl_date,

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

953: FND_MESSAGE.set_token('GENERIC_TEXT',l_error_message);
954: APP_EXCEPTION.raise_exception;
955: END IF;
956:
957: -- Insert the batch header in RA_BATCHES and the criteria in AR_SELECTION_CRITERIA
958: arp_process_br_batches.insert_batch('FNDRSRUN', -- p_form_name
959: NULL, -- p_form_version
960: p_batch_source_id, -- p_batch_source_id
961: p_batch_date, -- p_batch_date

Line 1046: l_criteria_rec AR_SELECTION_CRITERIA%ROWTYPE;

1042: p_draft_mode IN VARCHAR2,
1043: p_batch_id IN RA_BATCHES.batch_id%TYPE) IS
1044:
1045: l_batch_rec RA_BATCHES%ROWTYPE;
1046: l_criteria_rec AR_SELECTION_CRITERIA%ROWTYPE;
1047:
1048: l_selection_criteria_id RA_BATCHES.selection_criteria_id%TYPE;
1049: l_status RA_BATCHES.batch_process_status%TYPE;
1050:

Line 1063: from ar_selection_criteria

1059: -- fetch the criteria
1060: IF (l_batch_rec.selection_criteria_id IS NOT NULL) THEN
1061: Select *
1062: into l_criteria_rec
1063: from ar_selection_criteria
1064: where selection_criteria_id = l_batch_rec.selection_criteria_id;
1065: END IF;
1066:
1067: -- Update the batch status to 'CREATION_COMPLETED' if the batch run in Create mode.