PACKAGE: APPS.GMP_LEAD_TIME_CALCULATOR_PKG

Source

1 PACKAGE gmp_lead_time_calculator_pkg AS
2 /* $Header: GMPLTCPS.pls 120.1.12010000.1 2008/07/30 06:15:43 appldev ship $ */
3 
4 PROCEDURE calculate_lead_times(
5         errbuf		OUT  NOCOPY VARCHAR2,
6         retcode         OUT  NOCOPY VARCHAR2,
7         /*Sowmya - Inventory convergence - begin*/
8         /*
9         p_from_orgn_code VARCHAR2 ,
10         p_to_orgn_code    VARCHAR2,
11         p_from_item_no  VARCHAR2,
12         p_to_item_no    VARCHAR2) ;
13         */
14         /*Sowmya - Inventory convergence - End*/
15         p_from_orgn             NUMBER,
16 	p_to_orgn               NUMBER,
17         p_from_item_id          NUMBER,
18         p_to_item_id            NUMBER) ;
19 
20 PROCEDURE calc_lead_time(p_routing_id  NUMBER);
21 
22 PROCEDURE log_message( pbuff  IN VARCHAR2);
23 
24 PROCEDURE time_stamp ;
25 
26 /*Sowmya - Included a new function to get the average work hours*/
27 FUNCTION get_avg_working_hours (p_calendar_code IN VARCHAR2) RETURN NUMBER;
28 
29 END gmp_lead_time_calculator_pkg ;