APPS.HR_BIS_ALERTS dependencies on PER_BUSINESS_GROUPS

Line 820: l_security_group_id per_business_groups.security_group_id%TYPE; --Varchar2

816: (p_organization_id IN NUMBER)
817: RETURN NUMBER
818: IS
819:
820: l_security_group_id per_business_groups.security_group_id%TYPE; --Varchar2
821: --
822: -- get the security group id
823: --
824: CURSOR sg_cur(p_organization_id IN VARCHAR2) IS

Line 826: FROM per_business_groups b

822: -- get the security group id
823: --
824: CURSOR sg_cur(p_organization_id IN VARCHAR2) IS
825: SELECT b.security_group_id
826: FROM per_business_groups b
827: , hr_all_organization_units o
828: where o.business_group_id = b.business_group_id
829: AND o.organization_id = p_organization_id;
830:

Line 869: l_business_group_id per_business_groups.business_group_id%TYPE;

865:
866: l_dummy NUMBER;
867: l_status boolean;
868:
869: l_business_group_id per_business_groups.business_group_id%TYPE;
870: l_security_group_id NUMBER; -- Not per_business_groups.security_group_id%TYPE this is varchar2
871: l_org_structure_version_id per_org_structure_versions.org_structure_version_id%TYPE;
872:
873: -- Holds the session at the start of the function

Line 870: l_security_group_id NUMBER; -- Not per_business_groups.security_group_id%TYPE this is varchar2

866: l_dummy NUMBER;
867: l_status boolean;
868:
869: l_business_group_id per_business_groups.business_group_id%TYPE;
870: l_security_group_id NUMBER; -- Not per_business_groups.security_group_id%TYPE this is varchar2
871: l_org_structure_version_id per_org_structure_versions.org_structure_version_id%TYPE;
872:
873: -- Holds the session at the start of the function
874: -- used to return the session back to original

Line 1307: l_security_group_id per_business_groups.security_group_id%TYPE;

1303:
1304: l_error VARCHAR2(2000);
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;

Line 1758: l_security_group_id per_business_groups.security_group_id%TYPE;

1754:
1755: l_period_name VARCHAR2(50);
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;

Line 2403: l_security_group_id per_business_groups.security_group_id%TYPE;

2399:
2400: l_period_name VARCHAR2(50);
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;

Line 2908: l_security_group_id per_business_groups.security_group_id%TYPE;

2904: l_target VARCHAR2(80); -- Target value (e.g. 75%)
2905: l_period_name VARCHAR2(50);
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;

Line 3411: l_security_group_id per_business_groups.security_group_id%TYPE;

3407: l_error_tbl bis_UTILITIES_PUB.Error_Tbl_Type;
3408: i NUMBER := 0;
3409: l_actual NUMBER(38,2);
3410:
3411: l_security_group_id per_business_groups.security_group_id%TYPE;
3412:
3413: BEGIN
3414: pl('--------------------');
3415: pl('*POST TARGET LEVEL ACTUALS','Start');