DBA Data[Home] [Help]

APPS.BIS_PORTLET_PMREGION dependencies on BIS_TARGET_PUB

Line 120: p_target_rec IN BIS_TARGET_PUB.Target_Rec_Type

116:
117:
118: --===========================================================
119: PROCEDURE get_actual(
120: p_target_rec IN BIS_TARGET_PUB.Target_Rec_Type
121: ,x_actual_url OUT NOCOPY VARCHAR2
122: ,x_actual_value OUT NOCOPY NUMBER
123: ,x_comparison_actual_value OUT NOCOPY NUMBER
124: ,x_err OUT NOCOPY VARCHAR2

Line 130: p_target_in IN BIS_TARGET_PUB.Target_Rec_Type

126:
127:
128: --============================================================
129: PROCEDURE get_target(
130: p_target_in IN BIS_TARGET_PUB.Target_Rec_Type
131: ,x_target OUT NOCOPY NUMBER
132: ,x_range1_low OUT NOCOPY NUMBER
133: ,x_range1_high OUT NOCOPY NUMBER
134: ,x_range2_low OUT NOCOPY NUMBER

Line 146: ,x_target_rec IN OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type

142:
143: --===========================================================
144: PROCEDURE get_time_dim_index(
145: p_ind_selection_id IN NUMBER
146: ,x_target_rec IN OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type
147: ,x_err OUT NOCOPY VARCHAR2
148: ) ;
149:
150: --=============================================================

Line 155: p_target_rec IN OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type

151: PROCEDURE assign_time_level_value_id(
152: p_is_rolling_level IN NUMBER,
153: p_current_period_id IN VARCHAR,
154: p_time_dim_idx IN NUMBER,
155: p_target_rec IN OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type
156: ) ;
157:
158:
159: --===========================================================

Line 980: l_target_rec BIS_TARGET_PUB.Target_Rec_Type;

976: e_notimevalue EXCEPTION;
977:
978: l_user_id PLS_INTEGER;
979: x_owner_user_id PLS_INTEGER;
980: l_target_rec BIS_TARGET_PUB.Target_Rec_Type;
981:
982:
983: l_row_style VARCHAR2(100);
984:

Line 6277: p_target_rec IN BIS_TARGET_PUB.Target_Rec_Type

6273: -- HISTORY
6274: -- 08JAN-2002 juwang Created for bug#2173745
6275: --=============================================================
6276: FUNCTION use_current_period(
6277: p_target_rec IN BIS_TARGET_PUB.Target_Rec_Type
6278: ,p_time_dimension_index IN NUMBER
6279: ,p_current_period_id IN VARCHAR2
6280: ,x_last_period_id OUT NOCOPY VARCHAR2
6281: ) RETURN BOOLEAN IS

Line 7094: p_target_rec IN BIS_TARGET_PUB.Target_Rec_Type

7090: --===========================================================
7091: -- retriving actual and report url
7092: --===========================================================
7093: PROCEDURE get_actual(
7094: p_target_rec IN BIS_TARGET_PUB.Target_Rec_Type
7095: ,x_actual_url OUT NOCOPY VARCHAR2
7096: ,x_actual_value OUT NOCOPY NUMBER
7097: ,x_comparison_actual_value OUT NOCOPY NUMBER
7098: ,x_err OUT NOCOPY VARCHAR2

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

7146:
7147:
7148:
7149: --===========================================================
7150: -- retriving taget, Note: do not use BIS_TARGET_PUB.Rrieve_Target
7151: -- Procedure. Bug exists.
7152: --===========================================================
7153: PROCEDURE get_target(
7154: p_target_in IN BIS_TARGET_PUB.Target_Rec_Type

Line 7154: p_target_in IN BIS_TARGET_PUB.Target_Rec_Type

7150: -- retriving taget, Note: do not use BIS_TARGET_PUB.Rrieve_Target
7151: -- Procedure. Bug exists.
7152: --===========================================================
7153: PROCEDURE get_target(
7154: p_target_in IN BIS_TARGET_PUB.Target_Rec_Type
7155: ,x_target OUT NOCOPY NUMBER
7156: ,x_range1_low OUT NOCOPY NUMBER
7157: ,x_range1_high OUT NOCOPY NUMBER
7158: ,x_range2_low OUT NOCOPY NUMBER

Line 7267: ,x_target_rec IN OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type

7263: -- 4. If the above does not exist, return immediately
7264: --===========================================================
7265: PROCEDURE get_time_dim_index(
7266: p_ind_selection_id IN NUMBER
7267: ,x_target_rec IN OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type
7268: ,x_err OUT NOCOPY VARCHAR2
7269: )
7270: IS
7271: e_notimevalue EXCEPTION;

Line 7400: p_target_rec IN OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type

7396: PROCEDURE assign_time_level_value_id(
7397: p_is_rolling_level IN NUMBER,
7398: p_current_period_id IN VARCHAR,
7399: p_time_dim_idx IN NUMBER,
7400: p_target_rec IN OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type
7401: )
7402: IS
7403: BEGIN
7404: