PACKAGE: APPS.GMPPSRP

Source

1 PACKAGE GMPPSRP AUTHID CURRENT_USER as
2 /* $Header: GMPPSRPS.pls 120.1 2005/07/19 10:44:53 nsinghi noship $ */
3 
4 /*
5 PROCEDURE gmp_print_mps
6 			 (	errbuf              OUT NOCOPY VARCHAR2,
7  				retcode             OUT NOCOPY VARCHAR2,
8  				V_schedule_id  	  IN NUMBER,
9  				V_fplanning_class   IN VARCHAR2,
10  				V_tplanning_class   IN VARCHAR2,
11  				V_fwhse_code        IN VARCHAR2,
12  				V_twhse_code        IN VARCHAR2,
13   				V_fitem_no          IN VARCHAR2,
14  				V_titem_no          IN VARCHAR2,
15  				V_fBuyer_Plnr       IN VARCHAR2,
16  				V_tBuyer_Plnr       IN VARCHAR2,
17  				V_whse_security     IN VARCHAR2,
18  				V_printer           IN VARCHAR2,
19  				V_number_of_copies  IN NUMBER,
20  				V_user_print_style  IN VARCHAR2,
21 				V_run_date          IN DATE,
22 				V_schedule          IN VARCHAR2  );
23 */
24 PROCEDURE gmp_print_mps
25 			 (	errbuf              OUT NOCOPY VARCHAR2,
26  				retcode             OUT NOCOPY VARCHAR2,
27                                 V_organization_id   IN NUMBER,
28                                 V_schedule          IN NUMBER,
29 -- 				V_schedule_id  	    IN NUMBER,
30                                 V_Category_Set      IN NUMBER,
31                                 V_Structure_Id      IN NUMBER,
32 --                                V_Category_set_id   IN NUMBER,
33                                 V_fcategory         IN VARCHAR2,
34                                 V_tcategory         IN VARCHAR2,
35                                 V_fbuyer            IN VARCHAR2,
36                                 V_tbuyer            IN VARCHAR2,
37                                 V_fplanner          IN VARCHAR2,
38                                 V_tplanner          IN VARCHAR2,
39                                 V_forg              IN VARCHAR2,
40                                 V_torg              IN VARCHAR2,
41                                 V_fitem             IN VARCHAR2,
42                                 V_titem             IN VARCHAR2,
43                                 V_template          IN VARCHAR2,
44                                 V_template_locale   IN VARCHAR2
45                                 );
46 
47         PROCEDURE ps_generate_xml ;
48 
49         FUNCTION schedule (p_schedule_id NUMBER) RETURN VARCHAR2;
50 
51         FUNCTION category_set (p_category_set_id NUMBER) RETURN VARCHAR2;
52 
53         FUNCTION item_name (p_inventory_item_id NUMBER, p_organization_id NUMBER) RETURN VARCHAR2;
54 
55         FUNCTION organization_code (p_organization_id NUMBER) RETURN VARCHAR2;
56 
57         FUNCTION planner_code (p_inventory_item_id NUMBER, p_organization_id NUMBER) RETURN VARCHAR2;
58 
59         FUNCTION buyer_name (p_inventory_item_id NUMBER, p_organization_id NUMBER) RETURN VARCHAR2;
60 
61         FUNCTION onhand_qty (p_inventory_item_id NUMBER, p_organization_id NUMBER) RETURN NUMBER;
62 
63         FUNCTION unit_of_measure (p_inventory_item_id NUMBER, p_organization_id NUMBER) RETURN VARCHAR2;
64 
65         FUNCTION category (p_category_id NUMBER) RETURN VARCHAR2;
66 
67         PROCEDURE ps_generate_output(p_sequence_num IN NUMBER) ;
68 
69         PROCEDURE xml_transfer (errbuf OUT NOCOPY VARCHAR2, retcode OUT NOCOPY VARCHAR2, p_sequence_num IN NUMBER) ;
70 
71 END GMPPSRP;