8: g_module_name VARCHAR2(100) := 'pa.plsql.pji_mt_measures_pkg';
9: g_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
10:
11: -- -----------------------------------------------------------------------
12: -- This api locks the row in Pji_Mt_Measures_B before updating
13: -- -----------------------------------------------------------------------
14:
15: procedure LOCK_ROW (
16: p_measure_id IN pji_mt_measures_b.measure_id%TYPE,
12: -- This api locks the row in Pji_Mt_Measures_B before updating
13: -- -----------------------------------------------------------------------
14:
15: procedure LOCK_ROW (
16: p_measure_id IN pji_mt_measures_b.measure_id%TYPE,
17: p_OBJECT_VERSION_NUMBER IN pji_mt_measures_b.OBJECT_VERSION_NUMBER%TYPE
18: ) is
19:
20: cursor c is
13: -- -----------------------------------------------------------------------
14:
15: procedure LOCK_ROW (
16: p_measure_id IN pji_mt_measures_b.measure_id%TYPE,
17: p_OBJECT_VERSION_NUMBER IN pji_mt_measures_b.OBJECT_VERSION_NUMBER%TYPE
18: ) is
19:
20: cursor c is
21: select OBJECT_VERSION_NUMBER
18: ) is
19:
20: cursor c is
21: select OBJECT_VERSION_NUMBER
22: from PJI_MT_MEASURES_B
23: where MEASURE_ID = p_measure_id
24: for update of measure_id nowait;
25:
26: recinfo c%rowtype;
50:
51: -- -----------------------------------------------------------------------
52:
53: procedure DELETE_ROW (
54: p_measure_id IN pji_mt_measures_b.measure_id%TYPE
55: ) is
56:
57:
58: begin
62: if (sql%notfound) then
63: raise no_data_found;
64: end if;
65:
66: delete from PJI_MT_MEASURES_B
67: where measure_id = p_measure_id;
68:
69: if (sql%notfound) then
70: raise no_data_found;
78: procedure INSERT_ROW(
79:
80: X_rowid IN OUT NOCOPY rowid,
81:
82: X_measure_id IN pji_mt_measures_b.measure_id%type,
83:
84: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
85: X_measure_code IN pji_mt_measures_b.measure_code%type,
86: X_xtd_type IN pji_mt_measures_b.xtd_type%type,
80: X_rowid IN OUT NOCOPY rowid,
81:
82: X_measure_id IN pji_mt_measures_b.measure_id%type,
83:
84: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
85: X_measure_code IN pji_mt_measures_b.measure_code%type,
86: X_xtd_type IN pji_mt_measures_b.xtd_type%type,
87: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%type,
88: X_object_version_number IN pji_mt_measures_b.object_version_number%type,
81:
82: X_measure_id IN pji_mt_measures_b.measure_id%type,
83:
84: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
85: X_measure_code IN pji_mt_measures_b.measure_code%type,
86: X_xtd_type IN pji_mt_measures_b.xtd_type%type,
87: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%type,
88: X_object_version_number IN pji_mt_measures_b.object_version_number%type,
89:
82: X_measure_id IN pji_mt_measures_b.measure_id%type,
83:
84: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
85: X_measure_code IN pji_mt_measures_b.measure_code%type,
86: X_xtd_type IN pji_mt_measures_b.xtd_type%type,
87: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%type,
88: X_object_version_number IN pji_mt_measures_b.object_version_number%type,
89:
90: X_name IN pji_mt_measures_tl.name%type,
83:
84: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
85: X_measure_code IN pji_mt_measures_b.measure_code%type,
86: X_xtd_type IN pji_mt_measures_b.xtd_type%type,
87: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%type,
88: X_object_version_number IN pji_mt_measures_b.object_version_number%type,
89:
90: X_name IN pji_mt_measures_tl.name%type,
91: X_description IN pji_mt_measures_tl.description%type,
84: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
85: X_measure_code IN pji_mt_measures_b.measure_code%type,
86: X_xtd_type IN pji_mt_measures_b.xtd_type%type,
87: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%type,
88: X_object_version_number IN pji_mt_measures_b.object_version_number%type,
89:
90: X_name IN pji_mt_measures_tl.name%type,
91: X_description IN pji_mt_measures_tl.description%type,
92:
89:
90: X_name IN pji_mt_measures_tl.name%type,
91: X_description IN pji_mt_measures_tl.description%type,
92:
93: X_last_update_date IN pji_mt_measures_b.last_update_date%Type,
94: X_last_updated_by IN pji_mt_measures_b.last_updated_by%Type,
95: X_creation_date IN pji_mt_measures_b.creation_date%Type,
96: X_created_by IN pji_mt_measures_b.created_by%Type,
97: X_last_update_Login IN pji_mt_measures_b.last_update_Login%Type,
90: X_name IN pji_mt_measures_tl.name%type,
91: X_description IN pji_mt_measures_tl.description%type,
92:
93: X_last_update_date IN pji_mt_measures_b.last_update_date%Type,
94: X_last_updated_by IN pji_mt_measures_b.last_updated_by%Type,
95: X_creation_date IN pji_mt_measures_b.creation_date%Type,
96: X_created_by IN pji_mt_measures_b.created_by%Type,
97: X_last_update_Login IN pji_mt_measures_b.last_update_Login%Type,
98:
91: X_description IN pji_mt_measures_tl.description%type,
92:
93: X_last_update_date IN pji_mt_measures_b.last_update_date%Type,
94: X_last_updated_by IN pji_mt_measures_b.last_updated_by%Type,
95: X_creation_date IN pji_mt_measures_b.creation_date%Type,
96: X_created_by IN pji_mt_measures_b.created_by%Type,
97: X_last_update_Login IN pji_mt_measures_b.last_update_Login%Type,
98:
99: X_return_status OUT NOCOPY VARCHAR2,
92:
93: X_last_update_date IN pji_mt_measures_b.last_update_date%Type,
94: X_last_updated_by IN pji_mt_measures_b.last_updated_by%Type,
95: X_creation_date IN pji_mt_measures_b.creation_date%Type,
96: X_created_by IN pji_mt_measures_b.created_by%Type,
97: X_last_update_Login IN pji_mt_measures_b.last_update_Login%Type,
98:
99: X_return_status OUT NOCOPY VARCHAR2,
100: X_msg_data OUT NOCOPY VARCHAR2,
93: X_last_update_date IN pji_mt_measures_b.last_update_date%Type,
94: X_last_updated_by IN pji_mt_measures_b.last_updated_by%Type,
95: X_creation_date IN pji_mt_measures_b.creation_date%Type,
96: X_created_by IN pji_mt_measures_b.created_by%Type,
97: X_last_update_Login IN pji_mt_measures_b.last_update_Login%Type,
98:
99: X_return_status OUT NOCOPY VARCHAR2,
100: X_msg_data OUT NOCOPY VARCHAR2,
101: X_msg_count OUT NOCOPY NUMBER
101: X_msg_count OUT NOCOPY NUMBER
102:
103: ) is
104:
105: l_measure_id pji_mt_measures_b.MEASURE_ID%type;
106:
107: cursor C is select ROWID from pji_mt_measures_b
108: where MEASURE_ID = l_measure_id;
109:
103: ) is
104:
105: l_measure_id pji_mt_measures_b.MEASURE_ID%type;
106:
107: cursor C is select ROWID from pji_mt_measures_b
108: where MEASURE_ID = l_measure_id;
109:
110: l_return_status VARCHAR2(1) := NULL;
111: l_msg_count NUMBER := 0;
128: into l_measure_id
129: from dual;
130:
131: IF g_debug_mode = 'Y' THEN
132: pa_debug.g_err_stage:= 'Inserting record in pji_mt_measures_b'||to_char(l_measure_id);
133: pa_debug.write(g_module_name,pa_debug.g_err_stage,
134: pa_fp_constants_pkg.g_debug_level3);
135: END IF;
136:
133: pa_debug.write(g_module_name,pa_debug.g_err_stage,
134: pa_fp_constants_pkg.g_debug_level3);
135: END IF;
136:
137: INSERT INTO Pji_Mt_Measures_B
138: (
139: measure_id,
140: measure_set_code,
141: measure_code,
276: -- -----------------------------------------------------------------------
277:
278: procedure UPDATE_ROW (
279:
280: X_measure_id IN pji_mt_measures_b.measure_id%type,
281: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
282: X_measure_code IN pji_mt_measures_b.measure_code%type,
283: X_xtd_type IN pji_mt_measures_b.xtd_type%type,
284: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%type,
277:
278: procedure UPDATE_ROW (
279:
280: X_measure_id IN pji_mt_measures_b.measure_id%type,
281: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
282: X_measure_code IN pji_mt_measures_b.measure_code%type,
283: X_xtd_type IN pji_mt_measures_b.xtd_type%type,
284: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%type,
285: X_object_version_number IN pji_mt_measures_b.object_version_number%type,
278: procedure UPDATE_ROW (
279:
280: X_measure_id IN pji_mt_measures_b.measure_id%type,
281: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
282: X_measure_code IN pji_mt_measures_b.measure_code%type,
283: X_xtd_type IN pji_mt_measures_b.xtd_type%type,
284: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%type,
285: X_object_version_number IN pji_mt_measures_b.object_version_number%type,
286:
279:
280: X_measure_id IN pji_mt_measures_b.measure_id%type,
281: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
282: X_measure_code IN pji_mt_measures_b.measure_code%type,
283: X_xtd_type IN pji_mt_measures_b.xtd_type%type,
284: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%type,
285: X_object_version_number IN pji_mt_measures_b.object_version_number%type,
286:
287: X_name IN pji_mt_measures_tl.name%type,
280: X_measure_id IN pji_mt_measures_b.measure_id%type,
281: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
282: X_measure_code IN pji_mt_measures_b.measure_code%type,
283: X_xtd_type IN pji_mt_measures_b.xtd_type%type,
284: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%type,
285: X_object_version_number IN pji_mt_measures_b.object_version_number%type,
286:
287: X_name IN pji_mt_measures_tl.name%type,
288: X_description IN pji_mt_measures_tl.description%type,
281: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
282: X_measure_code IN pji_mt_measures_b.measure_code%type,
283: X_xtd_type IN pji_mt_measures_b.xtd_type%type,
284: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%type,
285: X_object_version_number IN pji_mt_measures_b.object_version_number%type,
286:
287: X_name IN pji_mt_measures_tl.name%type,
288: X_description IN pji_mt_measures_tl.description%type,
289:
286:
287: X_name IN pji_mt_measures_tl.name%type,
288: X_description IN pji_mt_measures_tl.description%type,
289:
290: X_last_update_date IN pji_mt_measures_b.last_update_date%Type,
291: X_last_updated_by IN pji_mt_measures_b.last_updated_by%Type,
292: X_last_update_login IN pji_mt_measures_b.last_update_login%Type,
293:
294: X_return_status OUT NOCOPY VARCHAR2,
287: X_name IN pji_mt_measures_tl.name%type,
288: X_description IN pji_mt_measures_tl.description%type,
289:
290: X_last_update_date IN pji_mt_measures_b.last_update_date%Type,
291: X_last_updated_by IN pji_mt_measures_b.last_updated_by%Type,
292: X_last_update_login IN pji_mt_measures_b.last_update_login%Type,
293:
294: X_return_status OUT NOCOPY VARCHAR2,
295: X_msg_data OUT NOCOPY VARCHAR2,
288: X_description IN pji_mt_measures_tl.description%type,
289:
290: X_last_update_date IN pji_mt_measures_b.last_update_date%Type,
291: X_last_updated_by IN pji_mt_measures_b.last_updated_by%Type,
292: X_last_update_login IN pji_mt_measures_b.last_update_login%Type,
293:
294: X_return_status OUT NOCOPY VARCHAR2,
295: X_msg_data OUT NOCOPY VARCHAR2,
296: X_msg_count OUT NOCOPY NUMBER
315: p_debug_mode => g_debug_mode );
316: END IF;
317:
318: IF g_debug_mode = 'Y' THEN
319: pa_debug.g_err_stage:= 'Updating Pji_Mt_Measures_B for'||to_char(X_measure_id);
320: pa_debug.write(g_module_name,pa_debug.g_err_stage,pa_fp_constants_pkg.g_debug_level3);
321: END IF;
322:
323: UPDATE Pji_Mt_Measures_B
319: pa_debug.g_err_stage:= 'Updating Pji_Mt_Measures_B for'||to_char(X_measure_id);
320: pa_debug.write(g_module_name,pa_debug.g_err_stage,pa_fp_constants_pkg.g_debug_level3);
321: END IF;
322:
323: UPDATE Pji_Mt_Measures_B
324: SET
325:
326: measure_set_code = X_measure_set_code,
327: measure_code = X_measure_code,
332: where Measure_Id = X_Measure_Id;
333:
334: IF (SQL%NOTFOUND) THEN
335: IF g_debug_mode = 'Y' THEN
336: pa_debug.g_err_stage:= 'NDF while updating Pji_Mt_Measures_B'||to_char(X_measure_id);
337: pa_debug.write(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level5);
338: END IF;
339: RAISE NO_DATA_FOUND;
340: END IF;
414: -- -----------------------------------------------------------------------
415:
416: procedure LOAD_ROW (
417:
418: X_measure_id IN pji_mt_measures_b.measure_id%type,
419:
420: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
421: X_measure_code IN pji_mt_measures_b.measure_code%type,
422: X_xtd_type IN pji_mt_measures_b.xtd_type%type,
416: procedure LOAD_ROW (
417:
418: X_measure_id IN pji_mt_measures_b.measure_id%type,
419:
420: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
421: X_measure_code IN pji_mt_measures_b.measure_code%type,
422: X_xtd_type IN pji_mt_measures_b.xtd_type%type,
423: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%type,
424: X_object_version_number IN pji_mt_measures_b.object_version_number%type,
417:
418: X_measure_id IN pji_mt_measures_b.measure_id%type,
419:
420: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
421: X_measure_code IN pji_mt_measures_b.measure_code%type,
422: X_xtd_type IN pji_mt_measures_b.xtd_type%type,
423: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%type,
424: X_object_version_number IN pji_mt_measures_b.object_version_number%type,
425:
418: X_measure_id IN pji_mt_measures_b.measure_id%type,
419:
420: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
421: X_measure_code IN pji_mt_measures_b.measure_code%type,
422: X_xtd_type IN pji_mt_measures_b.xtd_type%type,
423: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%type,
424: X_object_version_number IN pji_mt_measures_b.object_version_number%type,
425:
426: X_name IN pji_mt_measures_tl.name%type,
419:
420: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
421: X_measure_code IN pji_mt_measures_b.measure_code%type,
422: X_xtd_type IN pji_mt_measures_b.xtd_type%type,
423: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%type,
424: X_object_version_number IN pji_mt_measures_b.object_version_number%type,
425:
426: X_name IN pji_mt_measures_tl.name%type,
427: X_description IN pji_mt_measures_tl.description%type,
420: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
421: X_measure_code IN pji_mt_measures_b.measure_code%type,
422: X_xtd_type IN pji_mt_measures_b.xtd_type%type,
423: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%type,
424: X_object_version_number IN pji_mt_measures_b.object_version_number%type,
425:
426: X_name IN pji_mt_measures_tl.name%type,
427: X_description IN pji_mt_measures_tl.description%type,
428:
536:
537: delete from PJI_MT_MEASURES_TL T
538: where not exists
539: (select NULL
540: from PJI_MT_MEASURES_B B
541: where B.MEASURE_ID = T.MEASURE_ID
542: );
543:
544: update PJI_MT_MEASURES_TL T set (
611: -- -----------------------------------------------------------------------
612:
613: procedure TRANSLATE_ROW (
614:
615: X_MEASURE_ID in PJI_MT_MEASURES_B.MEASURE_ID%TYPE,
616:
617: X_NAME in PJI_MT_MEASURES_TL.NAME%TYPE,
618: X_DESCRIPTION in PJI_MT_MEASURES_TL.DESCRIPTION%TYPE,
619: