[Home] [Help]
1: PACKAGE BODY MST_WB_UTIL AS
2: /* $Header: MSTWUTLB.pls 120.1 2005/05/27 05:21:30 appldev $ */
3: --TYPE NUM_LIST IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
4:
5: G_Time_delim CONSTANT VARCHAR2(1) := ':';
27: l_Len NUMBER;
28: l_Pos NUMBER;
29: l_Delimiter VARCHAR2 ( 1 ) := ',';
30: BEGIN
31: l_Partner_Info := MST_WB_UTIL.Get_Facility_Owner ( p_Facility_Id, l_Delimiter );
32: l_Len := LENGTH ( l_Partner_Info );
33:
34: IF l_Len > 3
35: THEN
1469: , fnd_date.DATE_TO_CHARDATE(date2)
1470: , decode ( fsrr.attribute_name
1471: , 'SPEND'
1472: , to_char ( ( med.number3 - med.number2 ) , fnd_currency.get_format_mask ( fsl.uom_code, 67 ) )
1473: , to_char( round ( med.number3 ) - round ( med.number2 ), mst_wb_util.get_format_string ( 'NUMBER' ) ) )
1474: into l_id2,l_temp1,l_temp2,l_temp3
1475: from mst_exception_details med
1476: , fte_sel_rule_restrictions fsrr
1477: , fte_sel_rules fsl
4081: l_ret_val VARCHAR2(20) := NULL;
4082:
4083: BEGIN
4084: SELECT substr(wl.location_code,1,5)
4085: , substr(mst_wb_util.get_name(loc_id),1,10)
4086: , substr(wl.address1,1,20)
4087: , substr(wl.city,1,10)
4088: , substr(wl.state,1,10)
4089: , substr(wl.postal_code,1,5)
4119:
4120: function r_dep_frm_dest(p_plan_id in number, p_trip_id in number, p_stop_location_id in number)
4121: return varchar2 is latest_depart_date_frm_dest varchar2(20) := null;
4122: begin
4123: select substr(mst_wb_util.get_local_chardt(p_stop_location_id, min(mts.planned_departure_date)),1,20)
4124: into latest_depart_date_frm_dest
4125: from mst_delivery_legs mdl
4126: , mst_trip_stops mts
4127: where mdl.plan_id = p_plan_id
6247: RETURN 0;
6248: END get_row_count;
6249:
6250:
6251: END MST_WB_UTIL;