1 PACKAGE AHL_ENIGMA_UTIL_PKG AS
2 /* $Header: AHLUENGS.pls 120.0.12010000.1 2008/11/05 14:13:54 sathapli noship $ */
3
4 ---------------------------------------------------------------------------------------------------------
5 -- Declare Procedures --
6 ---------------------------------------------------------------------------------------------------------
7 -- Start of Comments --
8 -- Procedure name : get_enigma_url_params
9 -- Function : Returns the Model of MC header, ATA Code of the position and Tail Number of the unit
10 -- get_enigma_url_params Parameters:
11 -- p_object_type : Indicates whether the call is from MC or UC context
12 -- p_primary_object_id : Incase of MC this will be the Relationship Id, For UC this will be the instance Id
13 -- p_secondary_object_id : Incase of MC this will be null, incase of UC if p_primary_object_id if is null this will be
14 -- uc header id
15 -- x_model : The model of the corresponding MC
16 -- x_ata_code : The ATA Code of the corresponding position
17 -- x_tail_number : The tail number of the corresponding UC
18 -- End of Comments.
19 ---------------------------------------------------------------------------------------------------------
20 PROCEDURE get_enigma_url_params(
21 p_object_type IN VARCHAR2,
22 p_primary_object_id IN NUMBER ,
23 p_secondary_object_id IN NUMBER ,
24 x_model OUT NOCOPY VARCHAR2,
25 x_ata_code OUT NOCOPY VARCHAR2,
26 x_tail_number OUT NOCOPY VARCHAR2,
27 x_user_name OUT NOCOPY VARCHAR2,
28 x_user_lang OUT NOCOPY VARCHAR2,
29 x_doc_ID OUT NOCOPY VARCHAR2
30 );
31
32 FUNCTION IS_TASK_CARD_ENABLED (
33 p_workorder_id IN NUMBER)
34 RETURN VARCHAR2 ;
35
36
37
38 END AHL_ENIGMA_UTIL_PKG;