DBA Data[Home] [Help]

APPS.WSH_SHIPPING_PARAMS_PVT dependencies on FND_NUMBER

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

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;
841: End If;
842: End Loop;

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

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

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

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

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

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

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

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

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

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;
1951: End If;
1952: End Loop;