[Home] [Help]
PACKAGE: APPS.PJI_MT_ROWSET_DET_PKG
Source
1 PACKAGE PJI_MT_ROWSET_DET_PKG AS
2 /* $Header: PJIMTRDS.pls 120.1 2005/05/31 08:01:40 appldev $ */
3
4 PROCEDURE LOCK_ROW (
5 p_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,
6 p_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,
7 p_object_version_number IN pji_mt_rowset_det.object_version_number%TYPE
8 );
9
10
11 PROCEDURE DELETE_ROW (
12 p_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,
13 p_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE
14 );
15
16
17 PROCEDURE Insert_Row (
18 X_Rowid IN OUT NOCOPY ROWID,
19 X_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,
20 X_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,
21 X_Object_Version_Number IN pji_mt_rowset_det.Object_Version_Number%TYPE,
22 X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976
23 X_Last_Update_Date IN pji_mt_rowset_det.Last_Update_Date%TYPE,
24 X_Last_Updated_by IN pji_mt_rowset_det.Last_Updated_by%TYPE,
25 X_Creation_Date IN pji_mt_rowset_det.Creation_Date%TYPE,
26 X_Created_By IN pji_mt_rowset_det.Created_By%TYPE,
27 X_Last_Update_Login IN pji_mt_rowset_det.Last_Update_Login%TYPE,
28 X_Return_Status OUT NOCOPY VARCHAR2,
29 X_Msg_Data OUT NOCOPY VARCHAR2,
30 X_Msg_Count OUT NOCOPY NUMBER
31 );
32
33
34 PROCEDURE Update_Row (
35 X_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,
36 X_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,
37 X_Object_Version_Number IN pji_mt_rowset_det.Object_Version_Number%TYPE,
38 X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976
39 X_Last_Update_Date IN pji_mt_rowset_det.Last_Update_Date%TYPE,
40 X_Last_Updated_by IN pji_mt_rowset_det.Last_Updated_by%TYPE,
41 X_Last_Update_Login IN pji_mt_rowset_det.Last_Update_Login%TYPE,
42 X_Return_Status OUT NOCOPY VARCHAR2,
43 X_Msg_Data OUT NOCOPY VARCHAR2,
44 X_Msg_Count OUT NOCOPY NUMBER
45 );
46
47
48 PROCEDURE Load_Row (
49 X_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,
50 X_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,
51 X_Object_Version_Number IN pji_mt_rowset_det.Object_Version_Number%TYPE,
52 X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976
53 X_Owner IN VARCHAR2
54 );
55
56
57 END PJI_MT_ROWSET_DET_PKG;