PACKAGE: APPS.MSC_X_HZ_PLAN

Source

1 PACKAGE MSC_X_HZ_PLAN AS
2 /*  $Header: MSCXHZPS.pls 120.0 2005/05/25 19:49:12 appldev noship $ */
3 
4   Procedure populate_bucketed_quantity(
5                              arg_query_id     OUT NOCOPY NUMBER,
6                              arg_next_link    OUT NOCOPY VARCHAR2,
7                              arg_num_rowset   OUT NOCOPY NUMBER,
8                              arg_err_msg      OUT NOCOPY VARCHAR2,
9                              arg_default_pref OUT NOCOPY NUMBER,
10                              arg_pref_name    IN  VARCHAR2 DEFAULT NULL,
11                              arg_start_row    IN  NUMBER   DEFAULT 1,
12                              arg_end_row      IN  NUMBER   DEFAULT 25,
13                              arg_item_sort    IN  VARCHAR2 DEFAULT 'ASC',
14                              arg_from_date    IN  DATE     DEFAULT sysdate,
15                              arg_where_clause IN  VARCHAR2 DEFAULT NULL,
16                              arg_plan_under   IN  VARCHAR2 DEFAULT 'N',
17                              arg_plan_over    IN  VARCHAR2 DEFAULT 'N',
18                              arg_actual_under IN  VARCHAR2 DEFAULT 'N',
19                              arg_actual_over  IN  VARCHAR2 DEFAULT 'N'
20                              );
21 
22 
23   FUNCTION get_lookup_name(v_lookup_type IN VARCHAR2, v_lookup_code IN NUMBER) RETURN VARCHAR2 ;
24 
25 
26 END MSC_X_HZ_PLAN;