APPS.POA_BIS_ALERTS dependencies on BIS_TARGET_PUB

Line 10: p_target_value OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type) IS

6: p_plan_short_name IN VARCHAR2,
7: p_time_period IN VARCHAR2,
8: p_org_id IN NUMBER,
9: p_found OUT NOCOPY BOOLEAN,
10: p_target_value OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type) IS
11: l_index NUMBER := 0;
12: CURSOR cr_target IS
13: SELECT tv.target_level_short_name
14: , tv.target_level_name

Line 74: p_target_orgs OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_Type) IS

70:
71: PROCEDURE get_target_orgs(
72: p_target_level_short_name IN VARCHAR2,
73: p_plan_short_name IN VARCHAR2,
74: p_target_orgs OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_Type) IS
75: l_index NUMBER := 0;
76: CURSOR cr_target_org IS
77: SELECT distinct(org_level_value_id) org_id
78: FROM BISFV_TARGETS tv

Line 779: l_target_orgs BIS_TARGET_PUB.Target_Tbl_Type;

775: l_target_level_short_name VARCHAR2(30);
776: l_measure_short_name VARCHAR2(30);
777: l_target_level_name VARCHAR2(80);
778: l_param VARCHAR2(1000);
779: l_target_orgs BIS_TARGET_PUB.Target_Tbl_Type;
780: l_target_rec BIS_TARGET_PUB.Target_Rec_Type;
781: l_actual NUMBER;
782: l_index NUMBER;
783: l_start_date DATE;

Line 780: l_target_rec BIS_TARGET_PUB.Target_Rec_Type;

776: l_measure_short_name VARCHAR2(30);
777: l_target_level_name VARCHAR2(80);
778: l_param VARCHAR2(1000);
779: l_target_orgs BIS_TARGET_PUB.Target_Tbl_Type;
780: l_target_rec BIS_TARGET_PUB.Target_Rec_Type;
781: l_actual NUMBER;
782: l_index NUMBER;
783: l_start_date DATE;
784: l_end_date DATE;