PACKAGE: APPS.MSD_ROLL_DEMAND_PLAN

Source

1 PACKAGE msd_roll_demand_plan AUTHID CURRENT_USER AS
2 /* $Header: msddprls.pls 120.1.12010000.1 2009/04/30 06:43:27 vrepaka ship $ */
3 
4 
5   SYS_YES                         CONSTANT NUMBER := 1;
6   SYS_NO                          CONSTANT NUMBER := 2;
7 
8  -- ================== Period Types ========================================
9   G_VALID_PLAN                    CONSTANT NUMBER := 0;
10   G_INVALID_PLAN                  CONSTANT NUMBER := 1;
11 
12   -- ================== Period Types ========================================
13   G_DAY                           CONSTANT NUMBER := 9;
14   G_WEEK                          CONSTANT NUMBER := 10;
15   G_GREGORIAN_MONTH               CONSTANT NUMBER := 6;
16 
17 
18   -- ================== Parameter Types =====================================
19   G_TYPE_INPUT_SCENARIO           CONSTANT VARCHAR2(100) :='MSD_INPUT_SCENARIO';
20 
21 
22   -- ============ NULL VALUE USED IN THE WHERE CLAUSE========================
23   NULL_CHAR                       CONSTANT VARCHAR2(6) := '-23453';
24 
25 
26 PROCEDURE launching_roll (    ERRBUF   OUT NOCOPY VARCHAR2,
27                               RETCODE  OUT NOCOPY NUMBER,
28                               p_demand_plan_id IN NUMBER,
29                               p_period_type IN NUMBER,
30                               p_number_of_periods IN NUMBER );
31 
32 END msd_roll_demand_plan;