DBA Data[Home] [Help]

PACKAGE: APPS.MSC_EXCHANGE_BUCKETING

Source


1 PACKAGE MSC_EXCHANGE_BUCKETING AUTHID CURRENT_USER AS
2 /* $Header: MSCXBKS.pls 115.6 2004/04/03 01:58:04 pshah ship $ */
3 
4   G_MSC_CP_DEBUG VARCHAR2(10) := NVL(FND_PROFILE.VALUE('MSC_CP_DEBUG'), '0');
5 
6   /* Order types */
7   G_SALES_FORECAST       CONSTANT NUMBER       := 1;
8   G_ORDER_FORECAST       CONSTANT NUMBER       := 2;
9   G_SUPPLY_COMMIT        CONSTANT NUMBER       := 3;
10   G_PURCHASE_ORDER       CONSTANT NUMBER       := 13;
11   G_SALES_ORDER          CONSTANT NUMBER       := 14;
12 
13 PROCEDURE calculate_plan_buckets(
14              p_plan_id                IN    NUMBER,
15              p_org_id               IN NUMBER,
16              p_sr_instance_id          IN NUMBER,
17              p_daily_cutoff_bucket    IN   number,
18              p_weekly_cutoff_bucket   IN    number,
19              p_mthly_cutoff_bucket   IN    number
20             );
21 
22 
23 PROCEDURE calculate_netting_bucket(
24             p_sr_instance_id IN NUMBER,
25               p_customer_id IN NUMBER,
26             p_customer_site_id IN NUMBER,
27             p_supplier_id IN NUMBER,
28             p_supplier_site_id IN NUMBER,
29             p_item_id IN NUMBER,
30             p_plan_type IN NUMBER,
31             p_cutoff_ref_num IN OUT NOCOPY NUMBER);
32 
33 PROCEDURE start_bucketing( p_refresh_number IN OUT NOCOPY NUMBER);
34 
35 END MSC_EXCHANGE_BUCKETING;