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.FF_GLOBALS_F_PKG dependencies on FF_GLOBALS_F

Line 1: PACKAGE BODY FF_GLOBALS_F_PKG as

1: PACKAGE BODY FF_GLOBALS_F_PKG as
2: /* $Header: ffglb01t.pkb 120.1.12000000.3 2007/03/08 14:48:22 ajeyam noship $ */
3: --
4: /*===========================================================================+
5: | Copyright (c) 1993 Oracle Corporation |

Line 10: ff_globals_f_pkg

6: | Redwood Shores, California, USA |
7: | All rights reserved. |
8: +============================================================================+
9: Name
10: ff_globals_f_pkg
11: Purpose
12: Supports the GLB block in the form FFWSDGLB (Define Globals).
13: Notes
14:

Line 21: 12-Apr-05 Shisriva -- Version 115.1,115.2 for MLS of FF_GLOBALS_F.

17: 19-Apr-94 J.S.Hobbs 40.1 Added rtrim to Lock_Row.
18: 31-Jan-95 J.S.Hobbs 40.3 Removed aol WHO columns.
19: 06-Mar-97 J.Alloun 40.5 Changed all occurances of system.dual
20: to sys.dual for next release requirements.
21: 12-Apr-05 Shisriva -- Version 115.1,115.2 for MLS of FF_GLOBALS_F.
22: 05-May-05 Shisriva 115.3 Fixes for bug 4350976. Removed the Base
23: Parameters from insert_row procedure.
24: 05-May-05 Shisriva 115.4 Fixes for bug 4350976. Changed defualting
25: of parameters in update_row and lock_row.

Line 62: CURSOR C IS SELECT rowid FROM ff_globals_f

58: X_Global_Name IN OUT NOCOPY VARCHAR2,
59: X_Global_Description VARCHAR2,
60: X_Global_Value VARCHAR2) IS
61: --
62: CURSOR C IS SELECT rowid FROM ff_globals_f
63: WHERE global_id = X_Global_Id;
64: --
65: CURSOR C2 IS SELECT ff_globals_s.nextval FROM sys.dual;
66: --

Line 82: INSERT INTO ff_globals_f

78: end if;
79: --
80: g_dml_status := TRUE;
81: --
82: INSERT INTO ff_globals_f
83: (global_id,
84: effective_start_date,
85: effective_end_date,
86: business_group_id,

Line 117: 'ff_globals_f_pkg.insert_row');

113: if (C%NOTFOUND) then
114: CLOSE C;
115: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
116: hr_utility.set_message_token('PROCEDURE',
117: 'ff_globals_f_pkg.insert_row');
118: hr_utility.set_message_token('STEP','1');
119: hr_utility.raise_error;
120: end if;
121: CLOSE C;

Line 155: CURSOR C IS SELECT * FROM ff_globals_f

151: X_Global_Value VARCHAR2,
152: X_Base_Global_Name VARCHAR2 default NULL,
153: X_Base_Global_Description VARCHAR2 default NULL) IS
154: --
155: CURSOR C IS SELECT * FROM ff_globals_f
156: WHERE rowid = X_Rowid FOR UPDATE of Global_Id NOWAIT;
157: --
158: Recinfo C%ROWTYPE;
159: --

Line 168: 'ff_globals_f_pkg.lock_row');

164: if (C%NOTFOUND) then
165: CLOSE C;
166: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
167: hr_utility.set_message_token('PROCEDURE',
168: 'ff_globals_f_pkg.lock_row');
169: hr_utility.set_message_token('STEP','1');
170: hr_utility.raise_error;
171: end if;
172: CLOSE C;

Line 263: UPDATE ff_globals_f

259: end if;
260: ----
261: g_dml_status := TRUE;
262: ----
263: UPDATE ff_globals_f
264: SET global_id = X_Global_Id,
265: effective_start_date = X_Effective_Start_Date,
266: effective_end_date = X_Effective_End_Date,
267: business_group_id = X_Business_Group_Id,

Line 284: 'ff_globals_f_pkg.update_row');

280: ---
281: if (SQL%NOTFOUND) then
282: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
283: hr_utility.set_message_token('PROCEDURE',
284: 'ff_globals_f_pkg.update_row');
285: hr_utility.set_message_token('STEP','1');
286: hr_utility.raise_error;
287: end if;
288: --

Line 324: select Global_Id into x_global_id from ff_globals_f

320: X_Business_Group_Id,
321: X_Legislation_Code);
322:
323: --For MLS-----------------------------------------------------------------------
324: select Global_Id into x_global_id from ff_globals_f
325: where rowid = X_Rowid;
326: g_dml_status := TRUE;
327: ff_fgt_del.del_tl(x_global_id);
328: --------------------------------------------------------------------------------

Line 331: DELETE FROM ff_globals_f

327: ff_fgt_del.del_tl(x_global_id);
328: --------------------------------------------------------------------------------
329:
330: --
331: DELETE FROM ff_globals_f
332: WHERE rowid = X_Rowid;
333: --
334: g_dml_status := FALSE;
335: --

Line 339: 'ff_globals_f_pkg.delete_row');

335: --
336: if (SQL%NOTFOUND) then
337: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
338: hr_utility.set_message_token('PROCEDURE',
339: 'ff_globals_f_pkg.delete_row');
340: hr_utility.set_message_token('STEP','1');
341: hr_utility.raise_error;
342: end if;
343: --

Line 354: delete from FF_GLOBALS_F_TL T

350: ---For MLS----------------------------------------------------------------------
351: procedure ADD_LANGUAGE
352: is
353: begin
354: delete from FF_GLOBALS_F_TL T
355: where not exists
356: (select NULL
357: from FF_GLOBALS_F B
358: where B.GLOBAL_ID = T.GLOBAL_ID

Line 357: from FF_GLOBALS_F B

353: begin
354: delete from FF_GLOBALS_F_TL T
355: where not exists
356: (select NULL
357: from FF_GLOBALS_F B
358: where B.GLOBAL_ID = T.GLOBAL_ID
359: );
360: update FF_GLOBALS_F_TL T set (
361: GLOBAL_NAME,

Line 360: update FF_GLOBALS_F_TL T set (

356: (select NULL
357: from FF_GLOBALS_F B
358: where B.GLOBAL_ID = T.GLOBAL_ID
359: );
360: update FF_GLOBALS_F_TL T set (
361: GLOBAL_NAME,
362: GLOBAL_DESCRIPTION
363: ) = (select
364: B.GLOBAL_NAME,

Line 366: from FF_GLOBALS_F_TL B

362: GLOBAL_DESCRIPTION
363: ) = (select
364: B.GLOBAL_NAME,
365: B.GLOBAL_DESCRIPTION
366: from FF_GLOBALS_F_TL B
367: where B.GLOBAL_ID = T.GLOBAL_ID
368: and B.LANGUAGE = T.SOURCE_LANG)
369: where (
370: T.GLOBAL_ID,

Line 375: from FF_GLOBALS_F_TL SUBB, FF_GLOBALS_F_TL SUBT

371: T.LANGUAGE
372: ) in (select
373: SUBT.GLOBAL_ID,
374: SUBT.LANGUAGE
375: from FF_GLOBALS_F_TL SUBB, FF_GLOBALS_F_TL SUBT
376: where SUBB.GLOBAL_ID = SUBT.GLOBAL_ID
377: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
378: and (SUBB.GLOBAL_NAME <> SUBT.GLOBAL_NAME
379: or SUBB.GLOBAL_DESCRIPTION <> SUBT.GLOBAL_DESCRIPTION

Line 386: insert into FF_GLOBALS_F_TL (

382: or (SUBB.GLOBAL_DESCRIPTION is not null
383: and SUBT.GLOBAL_DESCRIPTION is null)
384: ));
385:
386: insert into FF_GLOBALS_F_TL (
387: GLOBAL_ID,
388: GLOBAL_NAME,
389: GLOBAL_DESCRIPTION,
390: LAST_UPDATE_DATE,

Line 408: from FF_GLOBALS_F_TL B, FND_LANGUAGES L

404: B.CREATED_BY,
405: B.CREATION_DATE,
406: L.LANGUAGE_CODE,
407: B.SOURCE_LANG
408: from FF_GLOBALS_F_TL B, FND_LANGUAGES L
409: where L.INSTALLED_FLAG in ('I', 'B')
410: and B.LANGUAGE = userenv('LANG')
411: and not exists
412: (select NULL

Line 413: from FF_GLOBALS_F_TL T

409: where L.INSTALLED_FLAG in ('I', 'B')
410: and B.LANGUAGE = userenv('LANG')
411: and not exists
412: (select NULL
413: from FF_GLOBALS_F_TL T
414: where T.GLOBAL_ID = B.GLOBAL_ID
415: and T.LANGUAGE = L.LANGUAGE_CODE);
416: end ADD_LANGUAGE;
417: ---

Line 434: from ff_globals_f glb

430: (p_b_global_name in varchar2
431: ,p_legislation_code in varchar2
432: ) is
433: select glb.global_id
434: from ff_globals_f glb
435: where glb.global_name = p_b_global_name
436: and glb.business_group_id is null
437: and (glb.legislation_code = p_legislation_code or
438: p_legislation_code is null and glb.legislation_code is null)

Line 469: UPDATE ff_globals_f_tl

465:
466: --
467: -- Update the global value.
468: --
469: UPDATE ff_globals_f_tl
470: SET GLOBAL_NAME = nvl(X_GLOBAL_NAME,GLOBAL_NAME),
471: GLOBAL_DESCRIPTION = nvl(X_GLOBAL_DESCRIPTION,GLOBAL_DESCRIPTION),
472: last_update_date = SYSDATE,
473: last_updated_by = decode(x_owner,'SEED',1,0),

Line 559: from ff_globals_f ffg

555: ,P_MAX_UPDATE_DATE DATE)is
556:
557: cursor csr_glb_exists_for_bg(r_global_name varchar2,r_legislation_code varchar2) is
558: select null
559: from ff_globals_f ffg
560: where ffg.global_name = r_global_name
561: and ffg.business_group_id is not null
562: and exists (select null
563: from per_business_groups pbg

Line 573: from ff_globals_f ffg

569: --opened and used once,distinct not required.
570: --creation_date may vary in seconds
571: Select data_type,global_id,creation_date,created_by,
572: max(trunc(last_update_date)) over(order by last_update_date) lud
573: from ff_globals_f ffg
574: where ffg.global_name=r_global_name
575: and ffg.legislation_code=r_legislation_code;
576:
577: l_glb_exists_for_current_leg csr_glb_exists_for_current_leg%rowtype;

Line 603: Insert into FF_GLOBALS_F

599: Begin
600: --Assumption Global has been validated
601: --Idea is to enter a global row alonwith the WHO columns
602: hr_utility.trace('Inserting global '||P_BASE_GLOBAL_NAME||'Date '||P_EFFECTIVE_START_DATE);
603: Insert into FF_GLOBALS_F
604: (GLOBAL_ID
605: ,EFFECTIVE_START_DATE
606: ,EFFECTIVE_END_DATE
607: ,BUSINESS_GROUP_ID

Line 698: delete ff_globals_f_tl

694: where user_entity_id=i.user_entity_id;
695:
696: end loop;
697:
698: delete ff_globals_f_tl
699: where global_id=p_global_id;
700:
701: delete ff_globals_f
702: where global_id=p_global_id;

Line 701: delete ff_globals_f

697:
698: delete ff_globals_f_tl
699: where global_id=p_global_id;
700:
701: delete ff_globals_f
702: where global_id=p_global_id;
703: End Delete_glb_and_child_entities;
704:
705: BEGIN

Line 706: hr_utility.set_location('Entering:'||'FF_GLOBALS_F_PKG.Load_row',10);

702: where global_id=p_global_id;
703: End Delete_glb_and_child_entities;
704:
705: BEGIN
706: hr_utility.set_location('Entering:'||'FF_GLOBALS_F_PKG.Load_row',10);
707:
708: if not ( (nvl(g_glb_record.global_name,'~nvl~') = P_BASE_GLOBAL_NAME)
709: and (nvl(g_glb_record.legislation_code,'~nvl~')=P_LEGISLATION_CODE)
710: )then

Line 714: --check if it exists for this legislation in ff_globals_f

710: )then
711:
712: g_glb_record:=null;
713: --Global from ldt encountered first time
714: --check if it exists for this legislation in ff_globals_f
715:
716:
717: hr_utility.trace(P_BASE_GLOBAL_NAME||'*20');
718:

Line 823: --global not found in ff_globals_f for current legislation.

819:
820:
821: else --l_glb_exists_for_current_leg.data_type is null here
822:
823: --global not found in ff_globals_f for current legislation.
824: --Global needs to be created with last_update_date=P_MAX_UPDATE_DATE
825: --Ensure that there isnt a global with
826: --similar name for a BG that belongs to this leg
827: --ffdict doesnt perform this check

Line 929: hr_utility.set_location('Leaving:'||'FF_GLOBALS_F_PKG.Load_row',100);

925: hr_general.g_data_migrator_mode:='N';
926: end if;
927: end if;
928:
929: hr_utility.set_location('Leaving:'||'FF_GLOBALS_F_PKG.Load_row',100);
930: End Load_row;
931:
932:
933:

Line 936: END FF_GLOBALS_F_PKG;

932:
933:
934:
935:
936: END FF_GLOBALS_F_PKG;