1 PACKAGE Pji_Cm_Util AS
2 /* $Header: PJIRX17S.pls 120.2 2007/10/24 04:07:50 paljain ship $ */
3
4 PROCEDURE Generate_CM_Procedure(
5 x_return_status IN OUT NOCOPY VARCHAR2
6 , x_msg_count IN OUT NOCOPY NUMBER
7 , x_msg_data IN OUT NOCOPY VARCHAR2
8 );
9
10 FUNCTION Generate_Procedure_String(
11 p_measure_source IN VARCHAR2)
12 RETURN VARCHAR2;
13 PROCEDURE Apply_Measure(p_itd_measure_id IN pji_mt_measures_b.measure_id%type
14 ,p_ptd_measure_id IN pji_mt_measures_b.measure_id%type
15 ,p_itd_name IN pji_mt_measures_tl.name%type
16 ,p_ptd_name IN pji_mt_measures_tl.name%type
17 ,p_qtd_measure_id IN pji_mt_measures_b.measure_id%TYPE
18 ,p_ytd_measure_id IN pji_mt_measures_b.measure_id%TYPE
19 ,p_qtd_name IN pji_mt_measures_tl.name%TYPE
20 ,p_ytd_name IN pji_mt_measures_tl.name%TYPE
21 ,p_measure_set_code IN pji_mt_measures_b.measure_set_code%type
22 ,p_last_update_date IN pji_mt_measures_b.last_update_date%Type
23 ,p_last_updated_by IN pji_mt_measures_b.last_updated_by%Type
24 ,p_creation_date IN pji_mt_measures_b.creation_date%Type
25 ,p_created_by IN pji_mt_measures_b.created_by%Type
26 ,p_last_update_Login IN pji_mt_measures_b.last_update_Login%Type
27 ,X_return_status OUT NOCOPY VARCHAR2
28 ,X_msg_data OUT NOCOPY VARCHAR2
29 ,X_msg_count OUT NOCOPY NUMBER
30 );
31 END Pji_Cm_Util;