[Home] [Help]
PACKAGE: APPS.PJI_MT_MEASURE_SETS_PKG
Source
1 PACKAGE Pji_Mt_Measure_Sets_Pkg AS
2 /* $Header: PJIMTMSS.pls 120.1 2005/05/31 08:01:30 appldev $ */
3
4 G_RET_STS_ERROR VARCHAR2(1):='E';
5
6 PROCEDURE LOCK_ROW (
7 p_measure_set_code IN pji_mt_measure_sets_b.measure_set_code%TYPE,
8 p_object_version_number IN pji_mt_measure_sets_b.object_version_number%TYPE
9 );
10
11 PROCEDURE DELETE_ROW (
12 p_measure_set_code IN pji_mt_measure_sets_b.measure_set_code%TYPE
13 );
14
15 PROCEDURE Insert_Row (
16 X_Rowid IN OUT NOCOPY ROWID,
17 X_Measure_Set_Code IN pji_mt_measure_sets_b.Measure_Set_Code%TYPE,
18 X_Measure_Set_Type IN pji_mt_measure_sets_b.Measure_Set_Type%TYPE,
19 X_Measure_Format IN pji_mt_measure_sets_b.Measure_Format%TYPE,
20 X_DB_Column_Name IN pji_mt_measure_sets_b.DB_Column_Name%TYPE,
21 X_Object_Version_Number IN pji_mt_measure_sets_b.Object_Version_Number%TYPE,
22 X_Name IN pji_mt_measure_sets_Tl.Name%TYPE,
23 X_Description IN pji_mt_measure_sets_Tl.Description%TYPE,
24 X_Last_Update_Date IN pji_mt_measure_sets_b.Last_Update_Date%TYPE,
25 X_Last_Updated_by IN pji_mt_measure_sets_b.Last_Updated_by%TYPE,
26 X_Creation_Date IN pji_mt_measure_sets_b.Creation_Date%TYPE,
27 X_Created_By IN pji_mt_measure_sets_b.Created_By%TYPE,
28 X_Last_Update_Login IN pji_mt_measure_sets_b.Last_Update_Login%TYPE,
29 X_Measure_Formula IN pji_mt_measure_sets_b.Measure_Formula%TYPE,
30 X_Measure_Source IN pji_mt_measure_sets_b.Measure_Source%TYPE,
31 X_Return_Status OUT NOCOPY VARCHAR2,
32 X_Msg_Data OUT NOCOPY VARCHAR2,
33 X_Msg_Count OUT NOCOPY NUMBER
34 );
35
36 PROCEDURE Update_Row (
37 X_Measure_Set_Code IN pji_mt_measure_sets_b.Measure_Set_Code%TYPE,
38 X_Measure_Set_Type IN pji_mt_measure_sets_b.Measure_Set_Type%TYPE,
39 X_Measure_Format IN pji_mt_measure_sets_b.Measure_Format%TYPE,
40 X_DB_Column_Name IN pji_mt_measure_sets_b.DB_Column_Name%TYPE,
41 X_Object_Version_Number IN pji_mt_measure_sets_b.Object_Version_Number%TYPE,
42 X_Name IN pji_mt_measure_sets_Tl.Name%TYPE,
43 X_Description IN pji_mt_measure_sets_Tl.Description%TYPE,
44 X_Last_Update_Date IN pji_mt_measure_sets_b.Last_Update_Date%TYPE,
45 X_Last_Updated_by IN pji_mt_measure_sets_b.Last_Updated_by%TYPE,
46 X_Last_Update_Login IN pji_mt_measure_sets_b.Last_Update_Login%TYPE,
47 X_Measure_Formula IN pji_mt_measure_sets_b.Measure_Formula%TYPE,
48 X_Measure_Source IN pji_mt_measure_sets_b.Measure_Source%TYPE,
49 X_Return_Status OUT NOCOPY VARCHAR2,
50 X_Msg_Data OUT NOCOPY VARCHAR2,
51 X_Msg_Count OUT NOCOPY NUMBER
52 );
53
54 PROCEDURE Load_Row (
55 X_Measure_Set_Code IN pji_mt_measure_sets_b.Measure_Set_Code%TYPE,
56 X_Measure_Set_Type IN pji_mt_measure_sets_b.Measure_Set_Type%TYPE,
57 X_Measure_Format IN pji_mt_measure_sets_b.Measure_Format%TYPE,
58 X_DB_Column_Name IN pji_mt_measure_sets_b.DB_Column_Name%TYPE,
59 X_Object_Version_Number IN pji_mt_measure_sets_b.Object_Version_Number%TYPE,
60 X_Name IN pji_mt_measure_sets_Tl.Name%TYPE,
61 X_Description IN pji_mt_measure_sets_Tl.Description%TYPE,
62 X_Owner IN VARCHAR2,
63 X_Measure_Formula IN pji_mt_measure_sets_b.Measure_Formula%TYPE,
64 X_Measure_Source IN pji_mt_measure_sets_b.Measure_Source%TYPE
65 );
66
67 PROCEDURE Add_Language;
68
69 PROCEDURE TRANSLATE_ROW (
70 X_measure_set_code IN pji_mt_measure_sets_b.measure_set_code%TYPE,
71 X_owner IN VARCHAR2 ,
72 X_name IN pji_mt_measure_sets_TL.NAME%TYPE,
73 X_description IN pji_mt_measure_sets_TL.DESCRIPTION%TYPE
74 );
75
76 END Pji_Mt_Measure_Sets_Pkg;