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;