[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;