PACKAGE: APPS.FTE_FPA_UTIL

Source

1 PACKAGE FTE_FPA_UTIL AUTHID CURRENT_USER AS
2 /* $Header: FTEFPUTS.pls 120.2 2011/03/23 11:14:47 suppal ship $ */
3 
4 PROCEDURE GET_PAYMENT_METHOD(
5 			     p_init_msg_list IN  VARCHAR2 default FND_API.G_FALSE,
6 			     p_invoice_header_id  in NUMBER,
7                              x_msg_data  OUT NOCOPY VARCHAR2,
8                              x_msg_count OUT NOCOPY NUMBER,
9 			     x_return_status OUT NOCOPY VARCHAR2,
10 		 	     x_payment_method OUT NOCOPY VARCHAR2);
11 
12 
13 PROCEDURE CALCULATE_PO_FREIGHT(p_bol_no IN VARCHAR2,
14                                 p_inv_header_id IN NUMBER,
15 				p_mode_of_transport IN VARCHAR2);
16 
17 --Commenting  the code for Obsoletion of DBI APIs in 12.2
18 /*PROCEDURE callDBI
19 (p_invoice_header_id  IN    NUMBER,
20  p_dml_type           IN    VARCHAR2,
21  p_return_status      OUT NOCOPY   VARCHAR2);*/
22 
23   PROCEDURE Get_Legal_Entity(p_org_id IN NUMBER,
24                              x_legal_entity_id OUT NOCOPY NUMBER,
25 			     x_return_status   OUT NOCOPY VARCHAR2,
26 			     x_msg_data  OUT NOCOPY  VARCHAR2,
27 			     x_msg_count  OUT NOCOPY NUMBER);
28 
29 
30 
31 PROCEDURE Update_Status(itemtype  IN  		VARCHAR2,
32                         itemkey   IN  		VARCHAR2,
33                         actid     IN  		NUMBER,
34                         funcmode  IN  		VARCHAR2,
35                         resultout OUT NOCOPY 	VARCHAR2);
36 
37 
38 
39 PROCEDURE GET_FRACCT_CCID
40 (
41         itemtype        IN VARCHAR2,
42         itemkey     IN VARCHAR2,
43         actid       IN NUMBER,
44         funcmode    IN VARCHAR2,
45         result      OUT NOCOPY VARCHAR2);
46 
47 PROCEDURE LOG_FAILURE_REASON(
48 			p_init_msg_list           IN     VARCHAR2 DEFAULT FND_API.G_FALSE,
49 			p_parent_name		  IN	 VARCHAR2,
50 			p_parent_id		  IN	 NUMBER,
51 			p_failure_type		  IN	 VARCHAR2,
52 			p_failure_reason	  IN	 VARCHAR2,
53 	        	x_return_status           OUT   NOCOPY VARCHAR2,
54 	        	x_msg_count               OUT   NOCOPY NUMBER,
55 	        	x_msg_data                OUT   NOCOPY VARCHAR2);
56 
57 
58 FUNCTION START_FRACCT_WF_PROCESS
59 (
60     p_carrier_id        IN              NUMBER,
61     p_ship_from_org_id  IN              NUMBER,
62     p_ship_to_org_id    IN              NUMBER,
63     p_supplier_id       IN              NUMBER,
64     p_supplier_site_id  IN              NUMBER,
65     p_trip_id           IN              NUMBER,
66     p_delivery_id       IN              NUMBER,
67     x_return_ccid       OUT     NOCOPY  NUMBER,
68     x_concat_segs       OUT     NOCOPY  VARCHAR2,
69     x_concat_ids        OUT     NOCOPY  VARCHAR2,
70     x_concat_descrs     OUT     NOCOPY  VARCHAR2,
71     x_msg_count         OUT     NOCOPY  NUMBER,
72     x_msg_data          OUT     NOCOPY  VARCHAR2)
73 RETURN VARCHAR2;
74 
75 END FTE_FPA_UTIL;