[Home] [Help]
PACKAGE: APPS.GMPMPACT
Source
1 PACKAGE GMPMPACT AUTHID CURRENT_USER AS
2 /* $Header: GMPMPACS.pls 120.2.12020000.1 2012/06/27 15:07:24 appldev ship $ */
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 VARCHAR2,
23 V_ttrans_date IN VARCHAR2,
24 /*V_ftrans_date IN DATE,
25 V_ttrans_date IN DATE, */
26 V_critical_indicator IN NUMBER,
27 V_template IN VARCHAR2,
28 V_template_locale IN VARCHAR2
29 );
30
31 PROCEDURE ps_generate_xml ;
32
33 FUNCTION schedule (p_schedule_id NUMBER) RETURN VARCHAR2;
34
35 FUNCTION category_set (p_category_set_id NUMBER) RETURN VARCHAR2;
36
37 FUNCTION item_name (p_inventory_item_id NUMBER, p_organization_id NUMBER) RETURN VARCHAR2;
38
39 FUNCTION organization_code (p_organization_id NUMBER) RETURN VARCHAR2;
40
41 FUNCTION planner_code (p_inventory_item_id NUMBER, p_organization_id NUMBER) RETURN VARCHAR2;
42
43 FUNCTION buyer_name (p_inventory_item_id NUMBER, p_organization_id NUMBER) RETURN VARCHAR2;
44
45 FUNCTION onhand_qty (p_inventory_item_id NUMBER, p_organization_id NUMBER) RETURN NUMBER;
46
47 FUNCTION unit_of_measure (p_inventory_item_id NUMBER, p_organization_id NUMBER) RETURN VARCHAR2;
48
49 FUNCTION category (p_category_id NUMBER) RETURN VARCHAR2;
50
51 PROCEDURE ps_generate_output(p_sequence_num IN NUMBER);
52
53 PROCEDURE xml_transfer (errbuf OUT NOCOPY VARCHAR2, retcode OUT NOCOPY VARCHAR2, p_sequence_num IN NUMBER) ;
54
55 END GMPMPACT;