DBA Data[Home] [Help]

PACKAGE: APPS.OE_ORDER_UPGRADE_UTIL

Source


1 PACKAGE OE_ORDER_UPGRADE_UTIL AUTHID CURRENT_USER as
2 /* $Header: OEXUUPGS.pls 120.0 2005/06/01 00:02:59 appldev noship $ */
3 
4 G_PKG_NAME       CONSTANT VARCHAR2(30) := 'OE_ORDER_UPGRADE_UTIL';
5 
6 FUNCTION Get_entity_Scolumn_value (
7 	  p_entity_type IN VARCHAR2,
8 	  p_entity_key IN NUMBER,
9 	  p_SColumn_name IN VARCHAR2)
10 RETURN NUMBER;
11 
12 
13 PROCEDURE Get_Invoice_Status_Code(
14 	p_line_id  IN NUMBER,
15 x_invoice_status_code OUT NOCOPY VARCHAR2);
16 
17 
18 PROCEDURE Get_Demand_Interface_Status(
19 p_line_id	IN  NUMBER,
20 x_result OUT NOCOPY NUMBER);
21 
22 
23 PROCEDURE Get_Mfg_Release_Status(
24 p_line_id	IN  NUMBER,
25 x_result OUT NOCOPY NUMBER);
26 
27 
28 PROCEDURE Get_Pur_Rel_Status(
29 p_line_id	IN  NUMBER,
30 x_result OUT NOCOPY NUMBER);
31 
32 
33 PROCEDURE Get_responsibility_application(
34 	p_user_id             IN  NUMBER,
35 	p_org_id              IN  NUMBER,
36 x_return_status OUT NOCOPY VARCHAR2,
37 
38 x_error_message OUT NOCOPY VARCHAR2,
39 
40 x_responsibility_id OUT NOCOPY NUMBER,
41 
42 x_application_id OUT NOCOPY NUMBER);
43 
44 
45 END OE_ORDER_UPGRADE_UTIL;