[Home] [Help]
PACKAGE: APPS.MST_SNAPSHOT_TASK_UTIL
Source
1 PACKAGE MST_SNAPSHOT_TASK_UTIL AUTHID CURRENT_USER AS
2 /* $Header: MSTSNTUS.pls 115.5 2004/06/25 17:23:40 qlu noship $ */
3
4
5
6 V_DEBUG BOOLEAN;
7 NULL_VALUE NUMBER := -23453;
8 NULL_CHAR_VALUE VARCHAR2(10) := '-23453';
9
10 Procedure LOG_MESSAGE( pBUFF IN VARCHAR2);
11
12 Procedure Get_Phase_Status_Code(p_rqst_id IN NUMBER, p_phase_code OUT NOCOPY VARCHAR2,
13 p_status_code OUT NOCOPY VARCHAR2);
14
15
16 Function getCalendar(lLocationId in number,lCalendarType in VARCHAR2 )
17 return Varchar2;
18
19 Function getDeliveryId (ldeliveryId in number,
20 lNullNumber in number) return number;
21 Function getCMVehicleType (lMoveId in number) return NUMBER;
22
23 Function GET_DEL_OSP_FLAG(ldelivery_id in NUMBER) return varchar2;
24
25 END MST_SNAPSHOT_TASK_UTIL;