1 PACKAGE CSM_ACC_PKG
2 /* $Header: csmeaccs.pls 120.1 2005/07/22 08:29:20 trajasek noship $*/
3 AS
4 --
5 -- To modify this template, edit file PKGSPEC.TXT in TEMPLATE
6 -- directory of SQL Navigator
7 --
8 -- Purpose: Provides generic procedures to manipulate ACC tables, and
9 -- mark dirty records for users, in process
10 --
11 -- MODIFICATION HISTORY
12 -- Person Date Comments
13 -- Anurag 09/16/02 Created
14 -- --------- ------ ------------------------------------------
15 -- Enter package declarations as shown below
16
17 /*** type containing list of publication items that use an ACC table ***/
18 TYPE t_publication_item_list IS TABLE OF VARCHAR2(30);
19
20 PROCEDURE INSERT_ACC
21 ( p_publication_item_names in t_publication_item_list
22 , p_acc_table_name in VARCHAR2
23 , p_seq_name in VARCHAR2
24 , p_user_id in NUMBER
25 , p_pk1_name in VARCHAR2
26 , p_pk1_num_value in NUMBER DEFAULT NULL
27 , p_pk1_char_value in VARCHAR2 DEFAULT NULL
28 , p_pk1_date_value in DATE DEFAULT NULL
29 , p_pk2_name in VARCHAR2 DEFAULT NULL
30 , p_pk2_num_value in NUMBER DEFAULT NULL
31 , p_pk2_char_value in VARCHAR2 DEFAULT NULL
32 , p_pk2_date_value in DATE DEFAULT NULL
33 , p_pk3_name in VARCHAR2 DEFAULT NULL
34 , p_pk3_num_value in NUMBER DEFAULT NULL
35 , p_pk3_char_value in VARCHAR2 DEFAULT NULL
36 , p_pk3_date_value in DATE DEFAULT NULL
37 );
38 PROCEDURE Delete_Acc
39 ( p_publication_item_names in t_publication_item_list
40 ,p_acc_table_name in VARCHAR2
41 ,p_pk1_name in VARCHAR2
42 ,p_pk1_num_value in NUMBER DEFAULT NULL
43 ,p_pk1_char_value in VARCHAR2 DEFAULT NULL
44 , p_pk1_date_value in DATE DEFAULT NULL
45 , p_pk2_name in VARCHAR2 DEFAULT NULL
46 , p_pk2_num_value in NUMBER DEFAULT NULL
47 , p_pk2_char_value in VARCHAR2 DEFAULT NULL
48 , p_pk2_date_value in DATE DEFAULT NULL
49 , p_pk3_name in VARCHAR2 DEFAULT NULL
50 , p_pk3_num_value in NUMBER DEFAULT NULL
51 , p_pk3_char_value in VARCHAR2 DEFAULT NULL
52 , p_pk3_date_value in DATE DEFAULT NULL
53 ,p_user_id in NUMBER DEFAULT NULL
54 ,p_operator in VARCHAR2 DEFAULT '='
55 );
56
57 PROCEDURE Update_Acc
58 ( p_publication_item_names in t_publication_item_list
59 ,p_acc_table_name in VARCHAR2
60 ,p_user_id in NUMBER
61 ,p_access_id in NUMBER
62 );
63
64 FUNCTION Get_Acc_Id
65 ( p_acc_table_name in VARCHAR2
66 , p_user_id in NUMBER
67 , p_pk1_name in VARCHAR2
68 , p_pk1_num_value in NUMBER DEFAULT NULL
69 , p_pk1_char_value in VARCHAR2 DEFAULT NULL
70 , p_pk1_date_value in DATE DEFAULT NULL
71 , p_pk2_name in VARCHAR2 DEFAULT NULL
72 , p_pk2_num_value in NUMBER DEFAULT NULL
73 , p_pk2_char_value in VARCHAR2 DEFAULT NULL
74 , p_pk2_date_value in DATE DEFAULT NULL
75 , p_pk3_name in VARCHAR2 DEFAULT NULL
76 , p_pk3_num_value in NUMBER DEFAULT NULL
77 , p_pk3_char_value in VARCHAR2 DEFAULT NULL
78 , p_pk3_date_value in DATE DEFAULT NULL
79 )
80 RETURN NUMBER;
81
82 END; -- Package spec