[Home] [Help]
PACKAGE: APPS.IEX_STATUS_RULE_PUB
Source
1 PACKAGE IEX_STATUS_RULE_PUB AUTHID CURRENT_USER AS
2 /* $Header: iexpcsts.pls 120.0 2004/01/24 03:19:17 appldev noship $ */
3
4 TYPE STATUS_RULE_REC_TYPE IS RECORD(
5 STATUS_RULE_ID NUMBER,
6 STATUS_RULE_NAME VARCHAR2(50),
7 STATUS_RULE_DESCRIPTION VARCHAR2(150),
8 START_DATE DATE,
9 END_DATE DATE,
10 -- JTF_OBJECT_CODE VARCHAR2(25),
11 LAST_UPDATE_DATE DATE,
12 LAST_UPDATED_BY NUMBER,
13 CREATION_DATE DATE,
14 CREATED_BY NUMBER,
15 LAST_UPDATE_LOGIN NUMBER,
16 PROGRAM_ID NUMBER(15),
17 SECURITY_GROUP_ID NUMBER,
18 OBJECT_VERSION_NUMBER NUMBER);
19
20
21
22 TYPE STATUS_RULE_TBL_TYPE IS TABLE OF STATUS_RULE_REC_TYPE INDEX BY binary_integer;
23
24 TYPE STATUS_rule_line_REC_TYPE IS RECORD (
25 STATUS_RULE_LINE_ID NUMBER,
26 DELINQUENCY_STATUS VARCHAR2(30),
27 PRIORITY NUMBER,
28 ENABLED_FLAG VARCHAR2(1),
29 STATUS_RULE_ID NUMBER,
30 LAST_UPDATE_DATE DATE,
31 LAST_UPDATED_BY NUMBER,
32 CREATION_DATE DATE,
33 CREATED_BY NUMBER,
34 LAST_UPDATE_LOGIN NUMBER,
35 PROGRAM_ID NUMBER(15),
36 SECURITY_GROUP_ID NUMBER,
37 OBJECT_VERSION_NUMBER NUMBER);
38
39 TYPE STATUS_rule_line_TBL_TYPE IS TABLE OF STATUS_rule_line_REC_TYPE INDEX BY binary_integer;
40
41 TYPE STATUS_RULE_ID_TBL_TYPE IS TABLE OF NUMBER INDEX BY binary_integer;
42
43 TYPE STATUS_rule_line_ID_TBL_TYPE IS TABLE OF NUMBER INDEX BY binary_integer;
44
45
46 Procedure Create_Status_Rule
47 (p_api_version IN NUMBER := 1.0,
48 p_init_msg_list IN VARCHAR2 := 'F',
49 p_commit IN VARCHAR2 := 'F',
50 P_STATUS_RULE_REC IN IEX_STATUS_RULE_PUB.STATUS_RULE_REC_TYPE,
51 x_dup_status OUT NOCOPY VARCHAR2,
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_msg_count OUT NOCOPY NUMBER,
54 x_msg_data OUT NOCOPY VARCHAR2,
55 X_STATUS_RULE_ID OUT NOCOPY NUMBER);
56
57
58 Procedure Update_Status_Rule
59 (p_api_version IN NUMBER := 1.0,
60 p_init_msg_list IN VARCHAR2 := 'F',
61 p_commit IN VARCHAR2 := 'F',
62 p_status_rule_tbl IN IEX_STATUS_RULE_PUB.STATUS_RULE_TBL_TYPE,
63 x_dup_status OUT NOCOPY VARCHAR2,
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_msg_count OUT NOCOPY NUMBER,
66 x_msg_data OUT NOCOPY VARCHAR2);
67
68
69
70 Procedure Delete_Status_Rule
71 (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_ID_TBL IN IEX_STATUS_RULE_PUB.STATUS_RULE_ID_TBL_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 Procedure Create_Status_rule_line
81 ( 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_line_rec IN iex_status_rule_pub.status_rule_line_rec_type,
85 x_return_status OUT NOCOPY VARCHAR2,
86 x_msg_count OUT NOCOPY NUMBER,
87 x_msg_data OUT NOCOPY VARCHAR2);
88
89
90 Procedure Update_Status_rule_line
91 ( p_api_version IN NUMBER := 1.0,
92 p_init_msg_list IN VARCHAR2 := 'F',
93 p_commit IN VARCHAR2 := 'F',
94 p_Status_rule_line_Tbl IN iex_status_rule_pub.status_rule_line_tbl_type,
95 x_dup_status OUT NOCOPY VARCHAR2,
96 x_return_status OUT NOCOPY VARCHAR2,
97 x_msg_count OUT NOCOPY NUMBER,
98 x_msg_data OUT NOCOPY VARCHAR2);
99
100 Procedure Delete_Status_rule_line
101 ( p_api_version IN NUMBER := 1.0,
102 p_init_msg_list IN VARCHAR2 := 'F',
103 p_commit IN VARCHAR2 := 'F',
104 p_status_rule_id IN NUMBER,
105 p_status_rule_line_id_tbl IN iex_status_rule_pub.status_rule_line_id_tbl_type,
106 x_return_status OUT NOCOPY VARCHAR2,
107 x_msg_count OUT NOCOPY NUMBER,
108 x_msg_data OUT NOCOPY VARCHAR2);
109
110
111
112 END IEX_STATUS_RULE_PUB;