DBA Data[Home] [Help]

APPS.WSH_SHIPPING_PARAMS_PVT dependencies on FND_DATE

Line 836: l_param_value_info.param_value_date(i):= fnd_date.canonical_to_date(l_param_value(i));

832: l_param_value_info.param_value_date(i):= NULL;
833: Elsif l_param_value_info.param_data_type(i) = 'DATE' then
834: l_param_value_info.param_value_num(i) := NULL;
835: l_param_value_info.param_value_chr(i) := NULL;
836: l_param_value_info.param_value_date(i):= fnd_date.canonical_to_date(l_param_value(i));
837: Elsif l_param_value_info.param_data_type(i) = 'NUMBER' then
838: l_param_value_info.param_value_num(i) := fnd_number.canonical_to_number(l_param_value(i));
839: l_param_value_info.param_value_chr(i) := NULL;
840: l_param_value_info.param_value_date(i):= NULL;

Line 1182: l_ship_par_val_rec.param_value_chr(l_param_count) := fnd_date.date_to_canonical(p_ship_par_val_rec.param_value_date(i)) ;

1178: End If;
1179: Elsif p_ship_par_val_rec.param_data_type(i) = 'NUMBER' then
1180: l_ship_par_val_rec.param_value_chr(l_param_count) := FND_NUMBER.NUMBER_TO_CANONICAL(p_ship_par_val_rec.param_value_num(i));
1181: Elsif p_ship_par_val_rec.param_data_type(i) = 'DATE' then
1182: l_ship_par_val_rec.param_value_chr(l_param_count) := fnd_date.date_to_canonical(p_ship_par_val_rec.param_value_date(i)) ;
1183: End If;
1184:
1185: End If;
1186: End Loop;

Line 1517: fnd_date.date_to_canonical(p_ship_par_val_rec.param_value_date(i)) ;

1513: l_ins_ship_par_val_rec.param_value_chr(ins_count) :=
1514: FND_NUMBER.NUMBER_TO_CANONICAL(p_ship_par_val_rec.param_value_num(i));
1515: Elsif p_ship_par_val_rec.param_data_type(i) = 'DATE' then
1516: l_upd_ship_par_val_rec.param_value_chr(ins_count) :=
1517: fnd_date.date_to_canonical(p_ship_par_val_rec.param_value_date(i)) ;
1518: End If;
1519: Else
1520: <>
1521: For j in l_param_name_tbl.FIRST..l_param_name_tbl.LAST

Line 1542: fnd_date.date_to_canonical(p_ship_par_val_rec.param_value_date(i)) ;

1538: l_upd_ship_par_val_rec.param_value_chr(upd_count) :=
1539: FND_NUMBER.NUMBER_TO_CANONICAL(p_ship_par_val_rec.param_value_num(i));
1540: Elsif p_ship_par_val_rec.param_data_type(i) = 'DATE' then
1541: l_upd_ship_par_val_rec.param_value_chr(upd_count) :=
1542: fnd_date.date_to_canonical(p_ship_par_val_rec.param_value_date(i)) ;
1543: End If;
1544: l_record_exists := FALSE;
1545: Else
1546: ins_count := nvl(l_ins_ship_par_val_rec.class_code.count,0) + 1;

Line 1558: fnd_date.date_to_canonical(p_ship_par_val_rec.param_value_date(i)) ;

1554: l_ins_ship_par_val_rec.param_value_chr(ins_count) :=
1555: FND_NUMBER.NUMBER_TO_CANONICAL(p_ship_par_val_rec.param_value_num(i));
1556: Elsif p_ship_par_val_rec.param_data_type(i) = 'DATE' then
1557: l_upd_ship_par_val_rec.param_value_chr(ins_count) :=
1558: fnd_date.date_to_canonical(p_ship_par_val_rec.param_value_date(i)) ;
1559: End If;
1560: End If;
1561: End If;
1562: End If;

Line 1946: x_param_value_info.param_value_date(i):= fnd_date.canonical_to_date(l_param_value(i));

1942: x_param_value_info.param_value_date(i):= NULL;
1943: Elsif x_param_value_info.param_data_type(i) = 'DATE' then
1944: x_param_value_info.param_value_num(i) := NULL;
1945: x_param_value_info.param_value_chr(i) := NULL;
1946: x_param_value_info.param_value_date(i):= fnd_date.canonical_to_date(l_param_value(i));
1947: Elsif x_param_value_info.param_data_type(i) = 'NUMBER' then
1948: x_param_value_info.param_value_num(i) := fnd_number.canonical_to_number(l_param_value(i));
1949: x_param_value_info.param_value_chr(i) := NULL;
1950: x_param_value_info.param_value_date(i):= NULL;