DBA Data[Home] [Help]

APPS.WSH_SHIPPING_PARAMS_PVT dependencies on FND_NUMBER

Line 893: l_param_value_info.param_value_num(i) := fnd_number.canonical_to_number(l_param_value(i));

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;
896: End If;
897: End Loop;

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

1222: Else
1223: l_ship_par_val_rec.param_value_chr(l_param_count) := p_ship_par_val_rec.param_value_chr(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:

Line 1556: FND_NUMBER.NUMBER_TO_CANONICAL(p_ship_par_val_rec.param_value_num(i));

1552: If p_ship_par_val_rec.param_data_type(i) = 'VARCHAR2' then
1553: l_ins_ship_par_val_rec.param_value_chr(ins_count) := p_ship_par_val_rec.param_value_chr(i);
1554: Elsif p_ship_par_val_rec.param_data_type(i) = 'NUMBER' then
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;

Line 1581: FND_NUMBER.NUMBER_TO_CANONICAL(p_ship_par_val_rec.param_value_num(i));

1577: If p_ship_par_val_rec.param_data_type(i) = 'VARCHAR2' then
1578: l_upd_ship_par_val_rec.param_value_chr(upd_count) := p_ship_par_val_rec.param_value_chr(i);
1579: Elsif p_ship_par_val_rec.param_data_type(i) = 'NUMBER' then
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;

Line 1597: FND_NUMBER.NUMBER_TO_CANONICAL(p_ship_par_val_rec.param_value_num(i));

1593: If p_ship_par_val_rec.param_data_type(i) = 'VARCHAR2' then
1594: l_ins_ship_par_val_rec.param_value_chr(ins_count) := p_ship_par_val_rec.param_value_chr(i);
1595: Elsif p_ship_par_val_rec.param_data_type(i) = 'NUMBER' then
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;

Line 1990: x_param_value_info.param_value_num(i) := fnd_number.canonical_to_number(l_param_value(i));

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;
1993: End If;
1994: End Loop;