DBA Data[Home] [Help]

APPS.BIS_INDICATOR_REGION_UI_PVT dependencies on BIS_TARGET_PUB

Line 188: p_target_rec IN BIS_TARGET_PUB.Target_Rec_Type

184:
185:
186: --===========================================================
187: PROCEDURE get_actual(
188: p_target_rec IN BIS_TARGET_PUB.Target_Rec_Type
189: ,x_actual_url OUT NOCOPY VARCHAR2
190: ,x_actual_value OUT NOCOPY NUMBER
191: ,x_comparison_actual_value OUT NOCOPY NUMBER
192: ,x_err OUT NOCOPY VARCHAR2

Line 199: p_target_in IN BIS_TARGET_PUB.Target_Rec_Type

195:
196:
197: --============================================================
198: PROCEDURE get_target(
199: p_target_in IN BIS_TARGET_PUB.Target_Rec_Type
200: ,x_target OUT NOCOPY NUMBER
201: ,x_range1_low OUT NOCOPY NUMBER
202: ,x_range1_high OUT NOCOPY NUMBER
203: ,x_range2_low OUT NOCOPY NUMBER

Line 214: ,x_target_rec IN OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type

210:
211: --===========================================================
212: PROCEDURE get_time_dim_index(
213: p_ind_selection_id IN NUMBER
214: ,x_target_rec IN OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type
215: ,x_err OUT NOCOPY VARCHAR2
216: ) ;
217:
218: --=============================================================

Line 224: p_target_rec IN OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type

220: (
221: p_is_rolling_level IN NUMBER,
222: p_current_period_id IN VARCHAR,
223: p_time_dim_idx IN NUMBER,
224: p_target_rec IN OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type
225: ) ;
226:
227:
228: --===========================================================

Line 802: l_target_rec BIS_TARGET_PUB.Target_Rec_Type;

798: , p_display_name varchar2 default NULL
799: , p_delete in varchar2 default 'N')
800: is
801:
802: l_target_rec BIS_TARGET_PUB.Target_Rec_Type;
803: l_row_style VARCHAR2(100);
804:
805: -- data variables
806: l_actual_value NUMBER;

Line 5388: rec_bis_target bis_target_pub.target_rec_type;

5384: IS
5385: dummy PLS_INTEGER;
5386: return_status VARCHAR2(255);
5387: token VARCHAR2(1) := '';
5388: rec_bis_target bis_target_pub.target_rec_type;
5389:
5390: CURSOR cur_notimelvl (p_tarid IN PLS_INTEGER)
5391: IS
5392: SELECT tlv.target_level_id

Line 6352: p_target_rec IN BIS_TARGET_PUB.Target_Rec_Type

6348: -- HISTORY
6349: -- 08JAN-2002 juwang Created for bug#2173745
6350: --=============================================================
6351: FUNCTION use_current_period(
6352: p_target_rec IN BIS_TARGET_PUB.Target_Rec_Type
6353: ,p_time_dimension_index IN NUMBER
6354: ,p_current_period_id IN VARCHAR2
6355: ,x_last_period_id OUT NOCOPY VARCHAR2
6356: ) RETURN BOOLEAN IS

Line 7222: p_target_rec IN BIS_TARGET_PUB.Target_Rec_Type

7218: --===========================================================
7219: -- retriving actual and report url
7220: --===========================================================
7221: PROCEDURE get_actual(
7222: p_target_rec IN BIS_TARGET_PUB.Target_Rec_Type
7223: ,x_actual_url OUT NOCOPY VARCHAR2
7224: ,x_actual_value OUT NOCOPY NUMBER
7225: ,x_comparison_actual_value OUT NOCOPY NUMBER
7226: ,x_err OUT NOCOPY VARCHAR2

Line 7278: -- retriving taget, Note: do not use BIS_TARGET_PUB.Rrieve_Target

7274:
7275:
7276:
7277: --===========================================================
7278: -- retriving taget, Note: do not use BIS_TARGET_PUB.Rrieve_Target
7279: -- Procedure. Bug exists.
7280: --===========================================================
7281: PROCEDURE get_target(
7282: p_target_in IN BIS_TARGET_PUB.Target_Rec_Type

Line 7282: p_target_in IN BIS_TARGET_PUB.Target_Rec_Type

7278: -- retriving taget, Note: do not use BIS_TARGET_PUB.Rrieve_Target
7279: -- Procedure. Bug exists.
7280: --===========================================================
7281: PROCEDURE get_target(
7282: p_target_in IN BIS_TARGET_PUB.Target_Rec_Type
7283: ,x_target OUT NOCOPY NUMBER
7284: ,x_range1_low OUT NOCOPY NUMBER
7285: ,x_range1_high OUT NOCOPY NUMBER
7286: ,x_range2_low OUT NOCOPY NUMBER

Line 7395: ,x_target_rec IN OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type

7391: -- 4. If the above does not exist, return immediately
7392: --===========================================================
7393: PROCEDURE get_time_dim_index(
7394: p_ind_selection_id IN NUMBER
7395: ,x_target_rec IN OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type
7396: ,x_err OUT NOCOPY VARCHAR2
7397: )
7398: IS
7399: e_notimevalue EXCEPTION;

Line 7530: p_target_rec IN OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type

7526: (
7527: p_is_rolling_level IN NUMBER,
7528: p_current_period_id IN VARCHAR,
7529: p_time_dim_idx IN NUMBER,
7530: p_target_rec IN OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type
7531: )
7532: IS
7533: BEGIN
7534: