APPS.MSC_GET_GANTT_DATA dependencies on FND_NUMBER

Line 887: fnd_number.number_to_canonical(v_avail_qty(b))||

883: to_char(v_avail_start(b),format_mask) ||
884: field_seperator ||
885: to_char(new_end,format_mask) ||
886: field_seperator ||
887: fnd_number.number_to_canonical(v_avail_qty(b))||
888: field_seperator ||
889: 0;
890: else
891: oneAvailRecord :=

Line 896: fnd_number.number_to_canonical(v_avail_qty(b))||

892: to_char(v_avail_start(b),format_mask) ||
893: field_seperator ||
894: to_char(new_end,format_mask) ||
895: field_seperator ||
896: fnd_number.number_to_canonical(v_avail_qty(b))||
897: field_seperator ||
898: 0;
899: end if;
900: availCount := availCount+1;

Line 920: fnd_number.number_to_canonical(v_qty)||

916: to_char(v_req_start(b),format_mask) ||
917: field_seperator ||
918: to_char(new_end,format_mask) ||
919: field_seperator ||
920: fnd_number.number_to_canonical(v_qty)||
921: field_seperator ||
922: fnd_number.number_to_canonical(v_over_cap(b));
923: v_max_len := nvl(length(oneAssignRecord(j)),0) +
924: nvl(length(v_one_record),0);

Line 922: fnd_number.number_to_canonical(v_over_cap(b));

918: to_char(new_end,format_mask) ||
919: field_seperator ||
920: fnd_number.number_to_canonical(v_qty)||
921: field_seperator ||
922: fnd_number.number_to_canonical(v_over_cap(b));
923: v_max_len := nvl(length(oneAssignRecord(j)),0) +
924: nvl(length(v_one_record),0);
925: if v_max_len > 30000 then
926: j := j+1;

Line 948: fnd_number.number_to_canonical(v_qty)||

944: to_char(new_start,format_mask) ||
945: field_seperator ||
946: to_char(new_end,format_mask) ||
947: field_seperator ||
948: fnd_number.number_to_canonical(v_qty)||
949: field_seperator ||
950: fnd_number.number_to_canonical(v_qty);
951: v_max_len := nvl(length(oneAssignRecord(j)),0) +
952: nvl(length(v_one_record),0);

Line 950: fnd_number.number_to_canonical(v_qty);

946: to_char(new_end,format_mask) ||
947: field_seperator ||
948: fnd_number.number_to_canonical(v_qty)||
949: field_seperator ||
950: fnd_number.number_to_canonical(v_qty);
951: v_max_len := nvl(length(oneAssignRecord(j)),0) +
952: nvl(length(v_one_record),0);
953: if v_max_len > 30000 then
954: j := j+1;

Line 1001: fnd_number.number_to_canonical(bkt_qty)||

997: oneAvailRecord :=
998: oneAvailRecord || field_seperator ||
999: to_char(v_bkt_start(a),format_mask) || field_seperator ||
1000: to_char(v_bkt_end(a),format_mask) || field_seperator ||
1001: fnd_number.number_to_canonical(bkt_qty)||
1002: field_seperator ||
1003: 0;
1004: else
1005: oneAvailRecord :=

Line 1008: fnd_number.number_to_canonical(bkt_qty)||

1004: else
1005: oneAvailRecord :=
1006: to_char(v_bkt_start(a),format_mask) || field_seperator ||
1007: to_char(v_bkt_end(a),format_mask) || field_seperator ||
1008: fnd_number.number_to_canonical(bkt_qty)||
1009: field_seperator ||
1010: 0;
1011: end if;
1012: availCount := availCount+1;

Line 1053: fnd_number.number_to_canonical(bkt_qty)||

1049: bkt_qty := round(bkt_qty, 6);
1050: v_one_record :=
1051: to_char(v_bkt_start(a),format_mask) || field_seperator ||
1052: to_char(v_bkt_end(a),format_mask) || field_seperator ||
1053: fnd_number.number_to_canonical(bkt_qty)||
1054: field_seperator ||
1055: fnd_number.number_to_canonical(bkt_qty);
1056: v_max_len := nvl(length(oneAssignRecord(j)),0) +
1057: nvl(length(v_one_record),0);

Line 1055: fnd_number.number_to_canonical(bkt_qty);

1051: to_char(v_bkt_start(a),format_mask) || field_seperator ||
1052: to_char(v_bkt_end(a),format_mask) || field_seperator ||
1053: fnd_number.number_to_canonical(bkt_qty)||
1054: field_seperator ||
1055: fnd_number.number_to_canonical(bkt_qty);
1056: v_max_len := nvl(length(oneAssignRecord(j)),0) +
1057: nvl(length(v_one_record),0);
1058: if v_max_len > 30000 then
1059: j := j+1;