DBA Data[Home] [Help]

APPS.HR_API dependencies on PER_BUSINESS_GROUPS

Line 40: g_leg_code PER_BUSINESS_GROUPS_PERF.LEGISLATION_CODE%TYPE default null;

36: g_session_context number default 0;
37: --
38: -- 120.2 (END)
39: --
40: g_leg_code PER_BUSINESS_GROUPS_PERF.LEGISLATION_CODE%TYPE default null;
41:
42: -- ------------------------ mandatory_arg_error ------------------------------
43: --
44: -- Description: This procedure is called by business processes which have

Line 176: from per_business_groups_perf

172: --
173: Cursor Sel_Id Is
174: select distinct
175: business_group_id
176: from per_business_groups_perf
177: where name = p_name;
178: --
179: Begin
180: --

Line 274: (p_business_group_id in per_business_groups.business_group_id%TYPE

270: --
271: -- ------------------------ validate_bus_grp_id ------------------------------
272: --
273: procedure validate_bus_grp_id
274: (p_business_group_id in per_business_groups.business_group_id%TYPE
275: ,p_associated_column1 in varchar2 default null) is
276: --
277: l_column varchar2(70);
278: l_org_id number;

Line 1375: from per_business_groups_perf

1371: -- Cursor to find the legislation_code
1372: --
1373: cursor csr_leg_code is
1374: select legislation_code
1375: from per_business_groups_perf
1376: where business_group_id = p_business_group_id;
1377: --
1378: l_legislation_code varchar2(30);
1379: begin

Line 1509: l_leg_code PER_BUSINESS_GROUPS_PERF.LEGISLATION_CODE%TYPE;

1505: -- ----------------------------------------------------------------------------
1506: --
1507: function get_legislation_context return varchar2 is
1508: --
1509: l_leg_code PER_BUSINESS_GROUPS_PERF.LEGISLATION_CODE%TYPE;
1510: begin
1511: -- Check for session context change and initialize legislation code accordingly
1512: IF NOT (FND_GLOBAL.COMPARE_SESSION_CONTEXT(g_session_context))
1513: THEN