PACKAGE: APPS.PJI_MT_MEASURES_PKG

Source

1 package PJI_MT_MEASURES_PKG as
2 /* $Header: PJIMTMDS.pls 120.1 2005/05/31 08:01:18 appldev  $ */
3 
4 
5 -- -----------------------------------------------------------------------
6 -- -----------------------------------------------------------------------
7 
8 procedure LOCK_ROW (
9 	p_measure_id		IN	pji_mt_measures_b.measure_id%TYPE,
10 	p_OBJECT_VERSION_NUMBER IN	pji_mt_measures_b.OBJECT_VERSION_NUMBER%TYPE
11  );
12 
13 
14 -- -----------------------------------------------------------------------
15 
16 procedure DELETE_ROW (
17 	p_measure_id		IN	pji_mt_measures_b.measure_id%TYPE
18 );
19 
20 
21 -- -----------------------------------------------------------------------
22 
23 procedure INSERT_ROW (
24 
25 	X_rowid		 IN OUT NOCOPY  rowid,
26 
27 	X_measure_id		IN	pji_mt_measures_b.measure_id%type,
28 
29 	X_measure_set_code	IN	pji_mt_measures_b.measure_set_code%type,
30 	X_measure_code		IN	pji_mt_measures_b.measure_code%type,
31 	X_xtd_type		IN	pji_mt_measures_b.xtd_type%type,
32 	X_pl_sql_api		IN	pji_mt_measures_b.pl_sql_api%type,
33 	X_object_version_number	IN	pji_mt_measures_b.object_version_number%type,
34 
35 	X_name			IN	pji_mt_measures_tl.name%type,
36 	X_description		IN	pji_mt_measures_tl.description%type,
37 
38 	X_last_update_date	IN      pji_mt_measures_b.last_update_date%Type,
39 	X_last_updated_by	IN	pji_mt_measures_b.last_updated_by%Type,
40 	X_creation_date		IN 	pji_mt_measures_b.creation_date%Type,
41 	X_created_by		IN	pji_mt_measures_b.created_by%Type,
42 	X_last_update_login	IN	pji_mt_measures_b.last_update_login%Type,
43 
44 	X_return_status	 OUT NOCOPY  VARCHAR2,
45 	X_msg_data	 OUT NOCOPY  VARCHAR2,
46 	X_msg_count	 OUT NOCOPY  NUMBER
47 );
48 
49 
50 -- -----------------------------------------------------------------------
51 
52 procedure UPDATE_ROW (
53 
54 	X_measure_id		IN	pji_mt_measures_b.measure_id%type,
55 
56 	X_measure_set_code	IN	pji_mt_measures_b.measure_set_code%type,
57 	X_measure_code		IN	pji_mt_measures_b.measure_code%type,
58 	X_xtd_type		IN	pji_mt_measures_b.xtd_type%type,
59 	X_pl_sql_api		IN	pji_mt_measures_b.pl_sql_api%type,
60 	X_object_version_number	IN	pji_mt_measures_b.object_version_number%type,
61 
62 	X_name			IN	pji_mt_measures_tl.name%type,
63 	X_description		IN	pji_mt_measures_tl.description%type,
64 
65 	X_last_update_date	IN      pji_mt_measures_b.last_update_date%Type,
66 	X_last_updated_by	IN	pji_mt_measures_b.last_updated_by%Type,
67 	X_last_update_login	IN	pji_mt_measures_b.last_update_login%Type,
68 	X_return_status	 OUT NOCOPY  VARCHAR2,
69 	X_msg_data	 OUT NOCOPY  VARCHAR2,
70 	X_msg_count	 OUT NOCOPY  NUMBER
71 );
72 
73 
74 -- -----------------------------------------------------------------------
75 
76 procedure LOAD_ROW (
77 
78 	X_measure_id		IN	pji_mt_measures_b.measure_id%type,
79 	X_measure_set_code	IN	pji_mt_measures_b.measure_set_code%type,
80 	X_measure_code		IN	pji_mt_measures_b.measure_code%type,
81 	X_xtd_type		IN	pji_mt_measures_b.xtd_type%type,
82 	X_pl_sql_api		IN	pji_mt_measures_b.pl_sql_api%type,
83 	X_object_version_number	IN	pji_mt_measures_b.object_version_number%type,
84 
85 	X_name			IN	pji_mt_measures_tl.name%type,
86 	X_description		IN	pji_mt_measures_tl.description%type,
87 
88 	X_owner			IN	VARCHAR2
89 );
90 
91 
92 -- -----------------------------------------------------------------------
93 
94 procedure ADD_LANGUAGE;
95 
96 
97 -- -----------------------------------------------------------------------
98 
99 procedure TRANSLATE_ROW (
100 
101 	X_measure_id		IN	pji_mt_measures_b.measure_id%type,
102 
103 	X_name			IN	pji_mt_measures_tl.name%type,
104 	X_description		IN	pji_mt_measures_tl.description%type,
105 
106 	X_owner			IN	VARCHAR2
107  );
108 
109 -- -----------------------------------------------------------------------
110 
111 end PJI_MT_MEASURES_PKG;