eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_BIS_ALERTS dependencies on BISFV_TARGETS

Line 70: ,target bisfv_targets.target%TYPE

66: ,dim5_level_value_id bisbv_targets.dim5_level_value_id%TYPE
67: ,unit_of_measure bisbv_target_levels.unit_of_measure%TYPE
68: ,workflow_item_type bisfv_target_levels.workflow_item_type%TYPE
69: ,workflow_process_short_name bisfv_target_levels.workflow_process_short_name%TYPE
70: ,target bisfv_targets.target%TYPE
71: ,range1_low bisfv_targets.range1_low%TYPE
72: ,range1_high bisfv_targets.range1_high%TYPE
73: ,range2_low bisfv_targets.range2_low%TYPE
74: ,range2_high bisfv_targets.range2_high%TYPE

Line 71: ,range1_low bisfv_targets.range1_low%TYPE

67: ,unit_of_measure bisbv_target_levels.unit_of_measure%TYPE
68: ,workflow_item_type bisfv_target_levels.workflow_item_type%TYPE
69: ,workflow_process_short_name bisfv_target_levels.workflow_process_short_name%TYPE
70: ,target bisfv_targets.target%TYPE
71: ,range1_low bisfv_targets.range1_low%TYPE
72: ,range1_high bisfv_targets.range1_high%TYPE
73: ,range2_low bisfv_targets.range2_low%TYPE
74: ,range2_high bisfv_targets.range2_high%TYPE
75: ,range3_low bisfv_targets.range3_low%TYPE

Line 72: ,range1_high bisfv_targets.range1_high%TYPE

68: ,workflow_item_type bisfv_target_levels.workflow_item_type%TYPE
69: ,workflow_process_short_name bisfv_target_levels.workflow_process_short_name%TYPE
70: ,target bisfv_targets.target%TYPE
71: ,range1_low bisfv_targets.range1_low%TYPE
72: ,range1_high bisfv_targets.range1_high%TYPE
73: ,range2_low bisfv_targets.range2_low%TYPE
74: ,range2_high bisfv_targets.range2_high%TYPE
75: ,range3_low bisfv_targets.range3_low%TYPE
76: ,range3_high bisfv_targets.range3_high%TYPE

Line 73: ,range2_low bisfv_targets.range2_low%TYPE

69: ,workflow_process_short_name bisfv_target_levels.workflow_process_short_name%TYPE
70: ,target bisfv_targets.target%TYPE
71: ,range1_low bisfv_targets.range1_low%TYPE
72: ,range1_high bisfv_targets.range1_high%TYPE
73: ,range2_low bisfv_targets.range2_low%TYPE
74: ,range2_high bisfv_targets.range2_high%TYPE
75: ,range3_low bisfv_targets.range3_low%TYPE
76: ,range3_high bisfv_targets.range3_high%TYPE
77: ,notify_resp1_id fnd_responsibility.responsibility_id%TYPE

Line 74: ,range2_high bisfv_targets.range2_high%TYPE

70: ,target bisfv_targets.target%TYPE
71: ,range1_low bisfv_targets.range1_low%TYPE
72: ,range1_high bisfv_targets.range1_high%TYPE
73: ,range2_low bisfv_targets.range2_low%TYPE
74: ,range2_high bisfv_targets.range2_high%TYPE
75: ,range3_low bisfv_targets.range3_low%TYPE
76: ,range3_high bisfv_targets.range3_high%TYPE
77: ,notify_resp1_id fnd_responsibility.responsibility_id%TYPE
78: ,notify_resp1_appl_id fnd_responsibility.application_id%TYPE

Line 75: ,range3_low bisfv_targets.range3_low%TYPE

71: ,range1_low bisfv_targets.range1_low%TYPE
72: ,range1_high bisfv_targets.range1_high%TYPE
73: ,range2_low bisfv_targets.range2_low%TYPE
74: ,range2_high bisfv_targets.range2_high%TYPE
75: ,range3_low bisfv_targets.range3_low%TYPE
76: ,range3_high bisfv_targets.range3_high%TYPE
77: ,notify_resp1_id fnd_responsibility.responsibility_id%TYPE
78: ,notify_resp1_appl_id fnd_responsibility.application_id%TYPE
79: ,notify_resp1_short_name bisfv_targets.notify_resp1_short_name%TYPE

Line 76: ,range3_high bisfv_targets.range3_high%TYPE

72: ,range1_high bisfv_targets.range1_high%TYPE
73: ,range2_low bisfv_targets.range2_low%TYPE
74: ,range2_high bisfv_targets.range2_high%TYPE
75: ,range3_low bisfv_targets.range3_low%TYPE
76: ,range3_high bisfv_targets.range3_high%TYPE
77: ,notify_resp1_id fnd_responsibility.responsibility_id%TYPE
78: ,notify_resp1_appl_id fnd_responsibility.application_id%TYPE
79: ,notify_resp1_short_name bisfv_targets.notify_resp1_short_name%TYPE
80: ,notify_resp1_name bisfv_targets.notify_resp1_name%TYPE

Line 79: ,notify_resp1_short_name bisfv_targets.notify_resp1_short_name%TYPE

75: ,range3_low bisfv_targets.range3_low%TYPE
76: ,range3_high bisfv_targets.range3_high%TYPE
77: ,notify_resp1_id fnd_responsibility.responsibility_id%TYPE
78: ,notify_resp1_appl_id fnd_responsibility.application_id%TYPE
79: ,notify_resp1_short_name bisfv_targets.notify_resp1_short_name%TYPE
80: ,notify_resp1_name bisfv_targets.notify_resp1_name%TYPE
81: ,notify_resp2_id fnd_responsibility.responsibility_id%TYPE
82: ,notify_resp2_appl_id fnd_responsibility.application_id%TYPE
83: ,notify_resp2_short_name bisfv_targets.notify_resp2_short_name%TYPE

Line 80: ,notify_resp1_name bisfv_targets.notify_resp1_name%TYPE

76: ,range3_high bisfv_targets.range3_high%TYPE
77: ,notify_resp1_id fnd_responsibility.responsibility_id%TYPE
78: ,notify_resp1_appl_id fnd_responsibility.application_id%TYPE
79: ,notify_resp1_short_name bisfv_targets.notify_resp1_short_name%TYPE
80: ,notify_resp1_name bisfv_targets.notify_resp1_name%TYPE
81: ,notify_resp2_id fnd_responsibility.responsibility_id%TYPE
82: ,notify_resp2_appl_id fnd_responsibility.application_id%TYPE
83: ,notify_resp2_short_name bisfv_targets.notify_resp2_short_name%TYPE
84: ,notify_resp2_name bisfv_targets.notify_resp2_name%TYPE

Line 83: ,notify_resp2_short_name bisfv_targets.notify_resp2_short_name%TYPE

79: ,notify_resp1_short_name bisfv_targets.notify_resp1_short_name%TYPE
80: ,notify_resp1_name bisfv_targets.notify_resp1_name%TYPE
81: ,notify_resp2_id fnd_responsibility.responsibility_id%TYPE
82: ,notify_resp2_appl_id fnd_responsibility.application_id%TYPE
83: ,notify_resp2_short_name bisfv_targets.notify_resp2_short_name%TYPE
84: ,notify_resp2_name bisfv_targets.notify_resp2_name%TYPE
85: ,notify_resp3_id fnd_responsibility.responsibility_id%TYPE
86: ,notify_resp3_appl_id fnd_responsibility.application_id%TYPE
87: ,notify_resp3_short_name bisfv_targets.notify_resp3_short_name%TYPE

Line 84: ,notify_resp2_name bisfv_targets.notify_resp2_name%TYPE

80: ,notify_resp1_name bisfv_targets.notify_resp1_name%TYPE
81: ,notify_resp2_id fnd_responsibility.responsibility_id%TYPE
82: ,notify_resp2_appl_id fnd_responsibility.application_id%TYPE
83: ,notify_resp2_short_name bisfv_targets.notify_resp2_short_name%TYPE
84: ,notify_resp2_name bisfv_targets.notify_resp2_name%TYPE
85: ,notify_resp3_id fnd_responsibility.responsibility_id%TYPE
86: ,notify_resp3_appl_id fnd_responsibility.application_id%TYPE
87: ,notify_resp3_short_name bisfv_targets.notify_resp3_short_name%TYPE
88: ,notify_resp3_name bisfv_targets.notify_resp3_name%TYPE

Line 87: ,notify_resp3_short_name bisfv_targets.notify_resp3_short_name%TYPE

83: ,notify_resp2_short_name bisfv_targets.notify_resp2_short_name%TYPE
84: ,notify_resp2_name bisfv_targets.notify_resp2_name%TYPE
85: ,notify_resp3_id fnd_responsibility.responsibility_id%TYPE
86: ,notify_resp3_appl_id fnd_responsibility.application_id%TYPE
87: ,notify_resp3_short_name bisfv_targets.notify_resp3_short_name%TYPE
88: ,notify_resp3_name bisfv_targets.notify_resp3_name%TYPE
89: -- ,budget_measurement_type hr_lookups.lookup_code%TYPE
90: ,period_start_DATE DATE
91: ,period_end_DATE DATE);

Line 88: ,notify_resp3_name bisfv_targets.notify_resp3_name%TYPE

84: ,notify_resp2_name bisfv_targets.notify_resp2_name%TYPE
85: ,notify_resp3_id fnd_responsibility.responsibility_id%TYPE
86: ,notify_resp3_appl_id fnd_responsibility.application_id%TYPE
87: ,notify_resp3_short_name bisfv_targets.notify_resp3_short_name%TYPE
88: ,notify_resp3_name bisfv_targets.notify_resp3_name%TYPE
89: -- ,budget_measurement_type hr_lookups.lookup_code%TYPE
90: ,period_start_DATE DATE
91: ,period_end_DATE DATE);
92:

Line 310: l_bis_target_rec bisfv_targets%rowtype;

306: IS
307:
308: --records from the cursors to be deleted
309: l_bis_tarlev_rec bisfv_target_levels%rowtype;
310: l_bis_target_rec bisfv_targets%rowtype;
311: l_target_rec hri_target_rec_type;
312:
313: --
314: -- get the performance measure

Line 335: FROM bisfv_targets trg

331: -- get the target value
332: --
333: CURSOR tv_cur (p_target_id IN NUMBER) IS
334: SELECT *
335: FROM bisfv_targets trg
336: WHERE trg.target_id = p_target_id;
337:
338: -- Cursor to verify validity of the budget meaurement type
339: -- at least one row returned if valid

Line 973: ,o_resp_short_name OUT NOCOPY bisfv_targets.notify_resp1_short_name%TYPE

969: (p_resp_no IN NUMBER
970: ,p_target_rec IN hri_target_rec_type
971: ,o_resp_id OUT NOCOPY fnd_responsibility.responsibility_id%TYPE
972: ,o_resp_appl_id OUT NOCOPY fnd_responsibility.application_id%TYPE
973: ,o_resp_short_name OUT NOCOPY bisfv_targets.notify_resp1_short_name%TYPE
974: ,o_resp_name OUT NOCOPY bisfv_targets.notify_resp1_name%TYPE)
975: IS
976: BEGIN
977: IF p_resp_no = 1 THEN

Line 974: ,o_resp_name OUT NOCOPY bisfv_targets.notify_resp1_name%TYPE)

970: ,p_target_rec IN hri_target_rec_type
971: ,o_resp_id OUT NOCOPY fnd_responsibility.responsibility_id%TYPE
972: ,o_resp_appl_id OUT NOCOPY fnd_responsibility.application_id%TYPE
973: ,o_resp_short_name OUT NOCOPY bisfv_targets.notify_resp1_short_name%TYPE
974: ,o_resp_name OUT NOCOPY bisfv_targets.notify_resp1_name%TYPE)
975: IS
976: BEGIN
977: IF p_resp_no = 1 THEN
978: o_resp_id := p_target_rec.notify_resp1_id;

Line 1310: l_resp_short_name bisfv_targets.notify_resp1_short_name%TYPE;

1306: -- Session params
1307: l_security_group_id per_business_groups.security_group_id%TYPE;
1308: l_business_group_id hr_all_organization_units.business_group_id%TYPE;
1309: l_resp_id fnd_responsibility.responsibility_id%TYPE;
1310: l_resp_short_name bisfv_targets.notify_resp1_short_name%TYPE;
1311: l_resp_name bisfv_targets.notify_resp1_name%TYPE;
1312: l_resp_appl_id fnd_responsibility.application_id%TYPE;
1313:
1314: l_formula_id ff_formulas_f.formula_id%TYPE;

Line 1311: l_resp_name bisfv_targets.notify_resp1_name%TYPE;

1307: l_security_group_id per_business_groups.security_group_id%TYPE;
1308: l_business_group_id hr_all_organization_units.business_group_id%TYPE;
1309: l_resp_id fnd_responsibility.responsibility_id%TYPE;
1310: l_resp_short_name bisfv_targets.notify_resp1_short_name%TYPE;
1311: l_resp_name bisfv_targets.notify_resp1_name%TYPE;
1312: l_resp_appl_id fnd_responsibility.application_id%TYPE;
1313:
1314: l_formula_id ff_formulas_f.formula_id%TYPE;
1315:

Line 1612: l_mod_target bisfv_targets.target%TYPE;

1608: (p_target_rec IN hri_target_rec_type)
1609: IS
1610:
1611: l_actual NUMBER(22,2);
1612: l_mod_target bisfv_targets.target%TYPE;
1613:
1614: l_actual_rec bis_actual_pub.actual_rec_type;
1615:
1616: BEGIN

Line 1761: l_resp_short_name bisfv_targets.notify_resp1_short_name%TYPE;

1757: -- Session params
1758: l_security_group_id per_business_groups.security_group_id%TYPE;
1759: l_business_group_id hr_all_organization_units.business_group_id%TYPE;
1760: l_resp_id fnd_responsibility.responsibility_id%TYPE;
1761: l_resp_short_name bisfv_targets.notify_resp1_short_name%TYPE;
1762: l_resp_name bisfv_targets.notify_resp1_name%TYPE;
1763: l_resp_appl_id fnd_responsibility.application_id%TYPE;
1764:
1765: BEGIN

Line 1762: l_resp_name bisfv_targets.notify_resp1_name%TYPE;

1758: l_security_group_id per_business_groups.security_group_id%TYPE;
1759: l_business_group_id hr_all_organization_units.business_group_id%TYPE;
1760: l_resp_id fnd_responsibility.responsibility_id%TYPE;
1761: l_resp_short_name bisfv_targets.notify_resp1_short_name%TYPE;
1762: l_resp_name bisfv_targets.notify_resp1_name%TYPE;
1763: l_resp_appl_id fnd_responsibility.application_id%TYPE;
1764:
1765: BEGIN
1766:

Line 1970: l_mod_target bisfv_targets.target%TYPE;

1966: PROCEDURE hrmvr_compare_values
1967: (p_target_rec IN hri_target_rec_type
1968: ,p_actual IN NUMBER) IS
1969:
1970: l_mod_target bisfv_targets.target%TYPE;
1971:
1972: BEGIN
1973: --
1974: -- process range 1

Line 2406: l_resp_short_name bisfv_targets.notify_resp1_short_name%TYPE;

2402: -- Session params
2403: l_security_group_id per_business_groups.security_group_id%TYPE;
2404: l_business_group_id hr_all_organization_units.business_group_id%TYPE;
2405: l_resp_id fnd_responsibility.responsibility_id%TYPE;
2406: l_resp_short_name bisfv_targets.notify_resp1_short_name%TYPE;
2407: l_resp_name bisfv_targets.notify_resp1_name%TYPE;
2408: l_resp_appl_id fnd_responsibility.application_id%TYPE;
2409:
2410: BEGIN

Line 2407: l_resp_name bisfv_targets.notify_resp1_name%TYPE;

2403: l_security_group_id per_business_groups.security_group_id%TYPE;
2404: l_business_group_id hr_all_organization_units.business_group_id%TYPE;
2405: l_resp_id fnd_responsibility.responsibility_id%TYPE;
2406: l_resp_short_name bisfv_targets.notify_resp1_short_name%TYPE;
2407: l_resp_name bisfv_targets.notify_resp1_name%TYPE;
2408: l_resp_appl_id fnd_responsibility.application_id%TYPE;
2409:
2410: BEGIN
2411:

Line 2780: l_mod_target bisfv_targets.target%TYPE;

2776: (p_target_rec IN hri_target_rec_type)
2777: IS
2778:
2779: l_actual NUMBER;
2780: l_mod_target bisfv_targets.target%TYPE;
2781: l_actual_rec bis_actual_pub.actual_rec_type;
2782:
2783: BEGIN
2784:

Line 2911: l_resp_short_name bisfv_targets.notify_resp1_short_name%TYPE;

2907: -- Session params
2908: l_security_group_id per_business_groups.security_group_id%TYPE;
2909: l_business_group_id hr_all_organization_units.business_group_id%TYPE;
2910: l_resp_id fnd_responsibility.responsibility_id%TYPE;
2911: l_resp_short_name bisfv_targets.notify_resp1_short_name%TYPE;
2912: l_resp_name bisfv_targets.notify_resp1_name%TYPE;
2913: l_resp_appl_id fnd_responsibility.application_id%TYPE;
2914:
2915: BEGIN

Line 2912: l_resp_name bisfv_targets.notify_resp1_name%TYPE;

2908: l_security_group_id per_business_groups.security_group_id%TYPE;
2909: l_business_group_id hr_all_organization_units.business_group_id%TYPE;
2910: l_resp_id fnd_responsibility.responsibility_id%TYPE;
2911: l_resp_short_name bisfv_targets.notify_resp1_short_name%TYPE;
2912: l_resp_name bisfv_targets.notify_resp1_name%TYPE;
2913: l_resp_appl_id fnd_responsibility.application_id%TYPE;
2914:
2915: BEGIN
2916: