[Home] [Help]
PACKAGE: APPS.IEX_STATUS_RULE_PVT
Source
1 PACKAGE IEX_STATUS_RULE_PVT AUTHID CURRENT_USER AS
2 /* $Header: iexvcsts.pls 120.0 2004/01/24 03:25:18 appldev noship $ */
3
4 G_MIN_STATUS_RULE CONSTANT NUMBER := 10;
5 G_MAX_STATUS_RULE CONSTANT NUMBER := 100;
6
7 IEX_DUPLICATE_NAME constant varchar2(1) := 'D';
8
9 Procedure Validate_Status_Rule(P_Init_Msg_List IN VARCHAR2 := 'F',
10 P_Status_Rule_rec IN IEX_STATUS_RULE_PUB.STATUS_RULE_REC_TYPE,
11 X_Dup_Status OUT NOCOPY VARCHAR2,
12 X_Return_Status OUT NOCOPY VARCHAR2,
13 X_Msg_Count OUT NOCOPY NUMBER,
14 X_Msg_Data OUT NOCOPY VARCHAR2);
15
16 Procedure Validate_STATUS_RULE_Name(P_Init_Msg_List IN VARCHAR2 := 'F',
17 P_Status_Rule_Name IN VARCHAR2 := 'F',
18 X_Dup_Status OUT NOCOPY VARCHAR2,
19 X_Return_Status OUT NOCOPY VARCHAR2,
20 X_Msg_Count OUT NOCOPY NUMBER,
21 X_Msg_Data OUT NOCOPY VARCHAR2);
22
23 Procedure Validate_STATUS_RULE_ID_Name(P_Init_Msg_List IN VARCHAR2 := 'F',
24 P_Status_Rule_ID IN NUMBER,
25 P_Status_Rule_Name IN VARCHAR2 := 'F',
26 X_Dup_Status OUT NOCOPY VARCHAR2,
27 X_Return_Status OUT NOCOPY VARCHAR2,
28 X_Msg_Count OUT NOCOPY NUMBER,
29 X_Msg_Data OUT NOCOPY VARCHAR2);
30
31 Procedure Create_Status_Rule (p_api_version IN NUMBER := 1.0,
32 p_init_msg_list IN VARCHAR2 := 'F',
33 p_commit IN VARCHAR2 := 'F',
34 P_STATUS_RULE_REC IN IEX_STATUS_RULE_PUB.STATUS_RULE_REC_TYPE ,
35 X_Dup_Status OUT NOCOPY VARCHAR2,
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_msg_count OUT NOCOPY NUMBER,
38 x_msg_data OUT NOCOPY VARCHAR2,
39 X_STATUS_RULE_ID OUT NOCOPY NUMBER);
40
41
42 Procedure Update_Status_Rule (p_api_version IN NUMBER := 1.0,
43 p_init_msg_list IN VARCHAR2 := 'F',
44 p_commit IN VARCHAR2 := 'F',
45 P_STATUS_RULE_REC IN IEX_STATUS_RULE_PUB.STATUS_RULE_REC_TYPE,
46 X_Dup_Status OUT NOCOPY VARCHAR2,
47 x_return_status OUT NOCOPY VARCHAR2,
48 x_msg_count OUT NOCOPY NUMBER,
49 x_msg_data OUT NOCOPY VARCHAR2);
50
51
52 Procedure Delete_Status_Rule (p_api_version IN NUMBER := 1.0,
53 p_init_msg_list IN VARCHAR2 := 'F',
54 p_commit IN VARCHAR2 := 'F',
55 p_status_rule_id IN NUMBER,
56 x_return_status OUT NOCOPY VARCHAR2,
57 x_msg_count OUT NOCOPY NUMBER,
58 x_msg_data OUT NOCOPY VARCHAR2);
59
60
61 Procedure Create_Status_Rule_Line(p_api_version IN NUMBER := 1.0,
62 p_init_msg_list IN VARCHAR2 := 'F',
63 p_commit IN VARCHAR2 := 'F',
64 p_Status_Rule_Line_REC IN IEX_STATUS_RULE_PUB.Status_Rule_Line_REC_Type,
65 x_return_status OUT NOCOPY VARCHAR2,
66 x_msg_count OUT NOCOPY NUMBER,
67 x_msg_data OUT NOCOPY VARCHAR2,
68 x_status_rule_line_id OUT NOCOPY NUMBER);
69
70
71 Procedure Update_Status_Rule_Line(p_api_version IN NUMBER := 1.0,
72 p_init_msg_list IN VARCHAR2 := 'F',
73 p_commit IN VARCHAR2 := 'F',
74 p_Status_Rule_Line_Rec IN IEX_STATUS_RULE_PUB.Status_Rule_Line_REC_Type,
75 x_return_status OUT NOCOPY VARCHAR2,
76 x_msg_count OUT NOCOPY NUMBER,
77 x_msg_data OUT NOCOPY VARCHAR2);
78
79
80
81 Procedure Delete_Status_Rule_Line(p_api_version IN NUMBER := 1.0,
82 p_init_msg_list IN VARCHAR2 := 'F',
83 p_commit IN VARCHAR2 := 'F',
84 p_status_rule_id IN NUMBER,
85 p_status_rule_line_id IN NUMBER,
86 x_return_status OUT NOCOPY VARCHAR2,
87 x_msg_count OUT NOCOPY NUMBER,
88 x_msg_data OUT NOCOPY VARCHAR2);
89
90 END IEX_STATUS_RULE_PVT;