PACKAGE: APPS.GMPMPACT

Source

1 PACKAGE GMPMPACT AUTHID CURRENT_USER AS
2 /* $Header: GMPMPACS.pls 120.1 2005/07/19 10:43:57 nsinghi noship $ */
3 
4 PROCEDURE print_mps_activity
5 (errbuf             OUT NOCOPY VARCHAR2,
6  retcode            OUT NOCOPY  VARCHAR2,
7  V_organization_id   IN NUMBER,
8  V_schedule          IN NUMBER,
9 -- V_schedule_id       IN NUMBER,
10  V_Category_Set_id   IN NUMBER,
11  V_Structure_Id      IN NUMBER,
12  V_fcategory         IN VARCHAR2,
13  V_tcategory         IN VARCHAR2,
14  V_fbuyer            IN VARCHAR2,
15  V_tbuyer            IN VARCHAR2,
16  V_fplanner          IN VARCHAR2,
17  V_tplanner          IN VARCHAR2,
18  V_forg              IN VARCHAR2,
19  V_torg              IN VARCHAR2,
20  V_fitem             IN VARCHAR2,
21  V_titem             IN VARCHAR2,
22  V_ftrans_date       IN DATE,
23  V_ttrans_date       IN DATE,
24  V_critical_indicator IN  NUMBER,
25   V_template          IN VARCHAR2,
26  V_template_locale   IN VARCHAR2
27 );
28 
29  PROCEDURE ps_generate_xml ;
30 
31  FUNCTION schedule (p_schedule_id NUMBER) RETURN VARCHAR2;
32 
33  FUNCTION category_set (p_category_set_id NUMBER) RETURN VARCHAR2;
34 
35  FUNCTION item_name (p_inventory_item_id NUMBER, p_organization_id NUMBER) RETURN VARCHAR2;
36 
37  FUNCTION organization_code (p_organization_id NUMBER) RETURN VARCHAR2;
38 
39  FUNCTION planner_code (p_inventory_item_id NUMBER, p_organization_id NUMBER) RETURN VARCHAR2;
40 
41  FUNCTION buyer_name (p_inventory_item_id NUMBER, p_organization_id NUMBER) RETURN VARCHAR2;
42 
43  FUNCTION onhand_qty (p_inventory_item_id NUMBER, p_organization_id NUMBER) RETURN NUMBER;
44 
45  FUNCTION unit_of_measure (p_inventory_item_id NUMBER, p_organization_id NUMBER) RETURN VARCHAR2;
46 
47  FUNCTION category (p_category_id NUMBER) RETURN VARCHAR2;
48 
49  PROCEDURE ps_generate_output(p_sequence_num IN NUMBER);
50 
51  PROCEDURE xml_transfer (errbuf OUT NOCOPY VARCHAR2, retcode OUT NOCOPY VARCHAR2, p_sequence_num IN NUMBER) ;
52 
53  END GMPMPACT;