DBA Data[Home] [Help]

APPS.WSH_SHIPPING_PARAMS_PVT dependencies on FND_DATE

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

887: l_param_value_info.param_value_date(i):= NULL;
888: Elsif l_param_value_info.param_data_type(i) = 'DATE' then
889: l_param_value_info.param_value_num(i) := NULL;
890: l_param_value_info.param_value_chr(i) := NULL;
891: l_param_value_info.param_value_date(i):= fnd_date.canonical_to_date(l_param_value(i));
892: Elsif l_param_value_info.param_data_type(i) = 'NUMBER' then
893: l_param_value_info.param_value_num(i) := fnd_number.canonical_to_number(l_param_value(i));
894: l_param_value_info.param_value_chr(i) := NULL;
895: l_param_value_info.param_value_date(i):= NULL;

Line 1228: 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)) ;

1224: End If;
1225: Elsif p_ship_par_val_rec.param_data_type(i) = 'NUMBER' then
1226: 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));
1227: Elsif p_ship_par_val_rec.param_data_type(i) = 'DATE' then
1228: 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)) ;
1229: End If;
1230:
1231: End If;
1232: End Loop;

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

1555: l_ins_ship_par_val_rec.param_value_chr(ins_count) :=
1556: FND_NUMBER.NUMBER_TO_CANONICAL(p_ship_par_val_rec.param_value_num(i));
1557: Elsif p_ship_par_val_rec.param_data_type(i) = 'DATE' then
1558: l_upd_ship_par_val_rec.param_value_chr(ins_count) :=
1559: fnd_date.date_to_canonical(p_ship_par_val_rec.param_value_date(i)) ;
1560: End If;
1561: Else
1562: <>
1563: For j in l_param_name_tbl.FIRST..l_param_name_tbl.LAST

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

1580: l_upd_ship_par_val_rec.param_value_chr(upd_count) :=
1581: FND_NUMBER.NUMBER_TO_CANONICAL(p_ship_par_val_rec.param_value_num(i));
1582: Elsif p_ship_par_val_rec.param_data_type(i) = 'DATE' then
1583: l_upd_ship_par_val_rec.param_value_chr(upd_count) :=
1584: fnd_date.date_to_canonical(p_ship_par_val_rec.param_value_date(i)) ;
1585: End If;
1586: l_record_exists := FALSE;
1587: Else
1588: ins_count := nvl(l_ins_ship_par_val_rec.class_code.count,0) + 1;

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

1596: l_ins_ship_par_val_rec.param_value_chr(ins_count) :=
1597: FND_NUMBER.NUMBER_TO_CANONICAL(p_ship_par_val_rec.param_value_num(i));
1598: Elsif p_ship_par_val_rec.param_data_type(i) = 'DATE' then
1599: l_upd_ship_par_val_rec.param_value_chr(ins_count) :=
1600: fnd_date.date_to_canonical(p_ship_par_val_rec.param_value_date(i)) ;
1601: End If;
1602: End If;
1603: End If;
1604: End If;

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

1984: x_param_value_info.param_value_date(i):= NULL;
1985: Elsif x_param_value_info.param_data_type(i) = 'DATE' then
1986: x_param_value_info.param_value_num(i) := NULL;
1987: x_param_value_info.param_value_chr(i) := NULL;
1988: x_param_value_info.param_value_date(i):= fnd_date.canonical_to_date(l_param_value(i));
1989: Elsif x_param_value_info.param_data_type(i) = 'NUMBER' then
1990: x_param_value_info.param_value_num(i) := fnd_number.canonical_to_number(l_param_value(i));
1991: x_param_value_info.param_value_chr(i) := NULL;
1992: x_param_value_info.param_value_date(i):= NULL;