DBA Data[Home] [Help]

PACKAGE: APPS.MSD_ROLL_DEMAND_PLAN

Source


1 PACKAGE msd_roll_demand_plan AS
2 /* $Header: msddprls.pls 120.0 2005/05/25 17:51:37 appldev noship $ */
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_GREGORIAN_MONTH               CONSTANT NUMBER := 6;
15 
16 
17   -- ================== Parameter Types =====================================
18   G_TYPE_INPUT_SCENARIO           CONSTANT VARCHAR2(100) :='MSD_INPUT_SCENARIO';
19 
20 
21   -- ============ NULL VALUE USED IN THE WHERE CLAUSE========================
22   NULL_CHAR                       CONSTANT VARCHAR2(6) := '-23453';
23 
24 
25 PROCEDURE launching_roll (    ERRBUF   OUT NOCOPY VARCHAR2,
26                               RETCODE  OUT NOCOPY NUMBER,
27                               p_demand_plan_id IN NUMBER,
28                               p_period_type IN NUMBER,
29                               p_number_of_periods IN NUMBER );
30 
31 END msd_roll_demand_plan;