40: AND location_id = p_location_id;
41:
42: BEGIN
43:
44: p_start_date := fnd_date.canonical_to_date(pv_start_date);
45: p_end_date := fnd_date.canonical_to_date(pv_end_date);
46:
47: jai_ar_eer1_pkg.p_action := p_action_flg;
48: openFile(p_file_path,p_filename);
41:
42: BEGIN
43:
44: p_start_date := fnd_date.canonical_to_date(pv_start_date);
45: p_end_date := fnd_date.canonical_to_date(pv_end_date);
46:
47: jai_ar_eer1_pkg.p_action := p_action_flg;
48: openFile(p_file_path,p_filename);
49: