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 FND_RESPONSIBILITY

Line 77: ,notify_resp1_id fnd_responsibility.responsibility_id%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
81: ,notify_resp2_id fnd_responsibility.responsibility_id%TYPE

Line 78: ,notify_resp1_appl_id fnd_responsibility.application_id%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
81: ,notify_resp2_id fnd_responsibility.responsibility_id%TYPE
82: ,notify_resp2_appl_id fnd_responsibility.application_id%TYPE

Line 81: ,notify_resp2_id fnd_responsibility.responsibility_id%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
85: ,notify_resp3_id fnd_responsibility.responsibility_id%TYPE

Line 82: ,notify_resp2_appl_id fnd_responsibility.application_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
85: ,notify_resp3_id fnd_responsibility.responsibility_id%TYPE
86: ,notify_resp3_appl_id fnd_responsibility.application_id%TYPE

Line 85: ,notify_resp3_id fnd_responsibility.responsibility_id%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
89: -- ,budget_measurement_type hr_lookups.lookup_code%TYPE

Line 86: ,notify_resp3_appl_id fnd_responsibility.application_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
89: -- ,budget_measurement_type hr_lookups.lookup_code%TYPE
90: ,period_start_DATE DATE

Line 348: -- Cursor to obtain fnd_responsibility_id

344: FROM hr_lookups
345: WHERE lookup_type = 'BUDGET_MEASUREMENT_TYPE'
346: AND lookup_code = p_c_bmt;
347:
348: -- Cursor to obtain fnd_responsibility_id
349: -- from role short name and ensure that the
350: -- role currently exists as an FND responsibility
351: CURSOR resp_id_cur
352: (p_c_role_name IN VARCHAR2)

Line 350: -- role currently exists as an FND responsibility

346: AND lookup_code = p_c_bmt;
347:
348: -- Cursor to obtain fnd_responsibility_id
349: -- from role short name and ensure that the
350: -- role currently exists as an FND responsibility
351: CURSOR resp_id_cur
352: (p_c_role_name IN VARCHAR2)
353: IS
354: SELECT wfr.orig_system_id

Line 357: , fnd_responsibility rsp

353: IS
354: SELECT wfr.orig_system_id
355: , rsp.application_id
356: FROM wf_roles wfr
357: , fnd_responsibility rsp
358: WHERE wfr.orig_system_id = rsp.responsibility_id
359: AND wfr.name = p_c_role_name
360: AND wfr.orig_system like 'FND_RESP%';
361:

Line 860: (p_responsibility_id IN fnd_responsibility.responsibility_id%TYPE

856: -- the target organization. If the responsibility does not have access to
857: -- the organization processing will be aborted.
858: -------------------------------------------------------------------------
859: FUNCTION validate_resp_org_security
860: (p_responsibility_id IN fnd_responsibility.responsibility_id%TYPE
861: ,p_application_id IN fnd_responsibility.application_id%TYPE
862: ,p_organization_id IN hr_all_organization_units.organization_id%TYPE)
863: RETURN BOOLEAN
864: IS

Line 861: ,p_application_id IN fnd_responsibility.application_id%TYPE

857: -- the organization processing will be aborted.
858: -------------------------------------------------------------------------
859: FUNCTION validate_resp_org_security
860: (p_responsibility_id IN fnd_responsibility.responsibility_id%TYPE
861: ,p_application_id IN fnd_responsibility.application_id%TYPE
862: ,p_organization_id IN hr_all_organization_units.organization_id%TYPE)
863: RETURN BOOLEAN
864: IS
865:

Line 971: ,o_resp_id OUT NOCOPY fnd_responsibility.responsibility_id%TYPE

967: -------------------------------------------------------------------------
968: PROCEDURE get_resp_details
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

Line 972: ,o_resp_appl_id OUT NOCOPY fnd_responsibility.application_id%TYPE

968: PROCEDURE get_resp_details
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

Line 1309: l_resp_id fnd_responsibility.responsibility_id%TYPE;

1305:
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:

Line 1312: l_resp_appl_id fnd_responsibility.application_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:
1316: BEGIN

Line 1760: l_resp_id fnd_responsibility.responsibility_id%TYPE;

1756:
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:

Line 1763: l_resp_appl_id fnd_responsibility.application_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:
1767: pl('-----------------------------------');

Line 2405: l_resp_id fnd_responsibility.responsibility_id%TYPE;

2401:
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:

Line 2408: l_resp_appl_id fnd_responsibility.application_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:
2412: pl('-------------------------------------');

Line 2910: l_resp_id fnd_responsibility.responsibility_id%TYPE;

2906:
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:

Line 2913: l_resp_appl_id fnd_responsibility.application_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:
2917: pl('----------------------------------');