[Home] [Help]
PACKAGE: APPS.AHL_STATUS_ORDER_RULES_PVT
Source
1 PACKAGE AHL_STATUS_ORDER_RULES_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVSORS.pls 115.0 2003/07/07 19:06:09 sdevaki noship $ */
3
4 -----------------------------------------------------------
5 -- PACKAGE
6 -- AHL_STATUS_ORDER_RULES_PVT
7 --
8 -- PURPOSE
9 -- This package is a Private API for retrieving the valid
10 -- statuses for the current status
11 --
12 -- Advanced Services Online. It contains specification for pl/sql records and tables
13 --
14 -- AHL_STATUS_ORDER_RULES
15 -- Get_Valid_Status_Order_Values (see below for specification)
16 --
17 -- NOTES
18 --
19 --
20 -- HISTORY
21 -- 09-May-2003 sdevaki Created.
22 -----------------------------------------------------------
23
24 -------------------------------------
25 ----- AHL_STATUS_ORDER_RULES -----
26 -------------------------------------
27 -- Record for AHL_STATUS_ORDER_RULES
28
29 TYPE Status_Order_Rules_Rec IS RECORD (
30 status_order_rule_id NUMBER,
31 object_version_number NUMBER,
32 last_update_date DATE,
33 last_updated_by NUMBER(15),
34 creation_date DATE,
35 created_by NUMBER(15),
36 last_update_login NUMBER(15),
37 system_status_type VARCHAR2(30),
38 current_status_code VARCHAR2(30),
39 next_status_code VARCHAR2(30),
40 next_status_meaning VARCHAR2(80),
41 security_groupd_id NUMBER
42 );
43
44
45 --Declare StatusOrderRules table type
46 TYPE Status_Order_Rules_Tbl IS TABLE OF Status_Order_Rules_Rec
47 INDEX BY BINARY_INTEGER;
48
49 --------------------------------------------------------------------
50 -- PROCEDURE
51 -- Get_Status_Order_Rules
52 --
53 -- PURPOSE
54 -- To Retrieve the valid Status Order Rules for the current Status
55 -- Order Rule
56 --
57 -- PARAMETERS
58 -- p_current_status_code : current status code
59 -- p_system_status_type : current status type
60 -- x_status_order_rules_tbl: the table of records representing
61 -- AHL_STATUS_ORDER_RULES table.
62 --
63 -- NOTES
64 --------------------------------------------------------------------
65 PROCEDURE Get_Status_Order_Rules (
66 p_api_version IN NUMBER,
67 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
68 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
69 p_module_type IN VARCHAR2 := 'JSP',
70 p_current_status_code IN VARCHAR2,
71 p_system_status_type IN VARCHAR2,
72 x_status_order_rules_tbl OUT NOCOPY Status_Order_Rules_Tbl,
73 x_return_status OUT NOCOPY VARCHAR2,
74 x_msg_count OUT NOCOPY NUMBER,
75 x_msg_data OUT NOCOPY VARCHAR2
76 );
77
78
79 END AHL_STATUS_ORDER_RULES_PVT;