PACKAGE: APPS.GMP_CALENDAR_PKG

Source

1 PACKAGE GMP_CALENDAR_PKG AUTHID CURRENT_USER as
2 /* $Header: GMPDCALS.pls 120.4.12020000.1 2012/06/27 15:06:28 appldev ship $ */
3 
4 g_in_str_org       VARCHAR2(32767) := NULL;
5 G_ALL_ORG          CONSTANT VARCHAR2(1024) := '-999' ;
6 
7 PROCEDURE rsrc_extract(p_instance_id IN PLS_INTEGER,
8                        p_db_link IN VARCHAR2,
9                        return_status OUT NOCOPY BOOLEAN);
10 
11 /* Bug# 1494939 - Initial changes for Resource Calendar */
12 PROCEDURE update_trading_partners(p_org_id IN PLS_INTEGER,
13                                   p_cal_code IN varchar2,
14                                   return_status OUT NOCOPY BOOLEAN);
15 
16 PROCEDURE retrieve_calendar_detail( p_calendar_code IN VARCHAR2,
17                                     p_cal_desc in varchar2,
18                                     p_run_date IN date,
19                                     p_db_link IN varchar2,
20                                     p_instance_id IN PLS_INTEGER,
21                                     p_usage IN varchar2,
22                                     return_status OUT NOCOPY BOOLEAN);
23 
24 PROCEDURE net_rsrc_insert(p_org_id IN PLS_INTEGER,
25                           p_orgn_code IN varchar2,
26                           p_simulation_set IN varchar2,
27                           p_db_link  IN varchar2,
28                           p_instance_id IN PLS_INTEGER,
29                           p_run_date IN DATE ,
30                           p_calendar_code IN varchar2,
31                           p_usage IN varchar2,
32                           return_status OUT NOCOPY BOOLEAN);
33 
34 PROCEDURE populate_rsrc_cal(p_run_date IN date,
35                             p_instance_id IN PLS_INTEGER,
36                             p_delimiter IN varchar2,
37                             p_db_link IN varchar2,
38                             p_nra_enabled IN NUMBER,
39                             return_status OUT NOCOPY BOOLEAN);
40 PROCEDURE time_stamp ;
41 
42 PROCEDURE log_message( pbuff  IN  VARCHAR2) ;
43 
44 PROCEDURE insert_gmp_resource_avail( errbuf        OUT NOCOPY varchar2,
45                                      retcode       OUT NOCOPY number  ,
46                                      p_org_id      IN PLS_INTEGER ,
47                                      p_from_rsrc   IN varchar2 ,
48                                      p_to_rsrc     IN varchar2 ,
49                                      p_calendar_code IN VARCHAR2  ) ;
50 
51 PROCEDURE net_rsrc_avail_calculate(p_instance_id IN PLS_INTEGER,
52                           p_org_id      IN PLS_INTEGER ,
53                           p_calendar_code IN VARCHAR2,
54                           p_db_link   IN varchar2,
55                           return_status OUT NOCOPY BOOLEAN) ;
56 
57 PROCEDURE net_rsrc_avail_insert(p_instance_id IN PLS_INTEGER,
58                    p_org_id IN PLS_INTEGER,
59                    p_resource_instance_id IN PLS_INTEGER,
60                    p_calendar_code IN VARCHAR2,
61                    p_resource_id IN PLS_INTEGER,
62                    p_assigned_qty IN number,
63                    p_shift_num IN PLS_INTEGER,
64                    p_calendar_date IN DATE,
65                    p_from_time IN NUMBER,
66                    p_to_time IN NUMBER )  ;
67 
68 FUNCTION ORG_STRING(instance_id IN PLS_INTEGER) return BOOLEAN ;
69 
70 END gmp_calendar_pkg;