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_FORMULAS_F_PKG dependencies on FF_FORMULAS_F

Line 1: PACKAGE BODY FF_FORMULAS_F_PKG as

1: PACKAGE BODY FF_FORMULAS_F_PKG as
2: /* $Header: fffra01t.pkb 120.1 2005/07/29 04:55:46 shisriva noship $ */
3: --
4: g_dummy number(1); -- Dummy for cursor returns which are not needed
5: --

Line 444: from ff_formulas_f ff

440: ,p_legislation_code varchar2
441: ,p_val_start_date date
442: ,p_startup_mode varchar2) is
443: select 'X'
444: from ff_formulas_f ff
445: where ff.formula_name = p_formula_name
446: and ff.formula_type_id = p_formula_type_id
447: and ff.effective_start_date > p_val_start_date
448: and ((p_startup_mode = 'MASTER')

Line 514: CURSOR C IS SELECT rowid row_id, last_update_date FROM ff_formulas_f

510: X_Formula_Text VARCHAR2,
511: X_Sticky_Flag VARCHAR2,
512: X_Last_Update_Date IN OUT NOCOPY DATE) IS
513: --
514: CURSOR C IS SELECT rowid row_id, last_update_date FROM ff_formulas_f
515: WHERE formula_id = X_Formula_Id;
516: --
517: CURSOR C2 IS SELECT ff_formulas_s.nextval FROM sys.dual;
518: --

Line 540: INSERT INTO ff_formulas_f

536: FETCH C2 INTO X_Formula_Id;
537: CLOSE C2;
538: end if;
539: --
540: INSERT INTO ff_formulas_f
541: (formula_id,
542: effective_start_date,
543: effective_end_date,
544: business_group_id,

Line 579: 'ff_formulas_f_pkg.insert_row');

575: if (C%NOTFOUND) then
576: CLOSE C;
577: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
578: hr_utility.set_message_token('PROCEDURE',
579: 'ff_formulas_f_pkg.insert_row');
580: hr_utility.set_message_token('STEP','1');
581: hr_utility.raise_error;
582: end if;
583: CLOSE C;

Line 621: CURSOR C IS SELECT * FROM ff_formulas_f

617: X_Sticky_Flag VARCHAR2,
618: X_Base_Formula_Name VARCHAR2 default NULL,
619: X_Base_Description VARCHAR2 default NULL) IS
620: --
621: CURSOR C IS SELECT * FROM ff_formulas_f
622: WHERE rowid = X_Rowid FOR UPDATE NOWAIT;
623: --
624: Recinfo C%ROWTYPE;
625: --

Line 634: 'ff_formulas_f_pkg.lock_row');

630: if (C%NOTFOUND) then
631: CLOSE C;
632: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
633: hr_utility.set_message_token('PROCEDURE',
634: 'ff_formulas_f_pkg.lock_row');
635: hr_utility.set_message_token('STEP','1');
636: hr_utility.raise_error;
637: end if;
638: CLOSE C;

Line 703: CURSOR C IS SELECT last_update_date FROM ff_formulas_f

699: --
700: PROCEDURE Lock_Row(x_rowid VARCHAR2,
701: x_last_update_date DATE) IS
702: --
703: CURSOR C IS SELECT last_update_date FROM ff_formulas_f
704: WHERE rowid = x_rowid FOR UPDATE NOWAIT;
705: --
706: v_current_update_date date;
707: --

Line 716: 'ff_formulas_f_pkg.lock_row');

712: if (C%NOTFOUND) then
713: CLOSE C;
714: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
715: hr_utility.set_message_token('PROCEDURE',
716: 'ff_formulas_f_pkg.lock_row');
717: hr_utility.set_message_token('STEP','1');
718: hr_utility.raise_error;
719: end if;
720: CLOSE C;

Line 761: CURSOR C IS SELECT last_update_date FROM ff_formulas_f

757: X_Last_Update_Date IN OUT NOCOPY DATE,
758: X_Base_Formula_Name VARCHAR2 default hr_api.g_varchar2,
759: X_Base_Description VARCHAR2 default hr_api.g_varchar2) IS
760: --
761: CURSOR C IS SELECT last_update_date FROM ff_formulas_f
762: WHERE rowid = x_rowid;
763: --
764: v_current_update_date date;
765: --

Line 787: UPDATE ff_formulas_f

783: if( l_description = hr_api.g_varchar2 ) then
784: l_description := X_Description;
785: end if;
786: ----
787: UPDATE ff_formulas_f
788: SET formula_id = X_Formula_Id,
789: effective_start_date = X_Effective_Start_Date,
790: effective_end_date = X_Effective_End_Date,
791: business_group_id = X_Business_Group_Id,

Line 811: 'ff_formulas_f_pkg.update_row');

807: ---
808: if (SQL%NOTFOUND) then
809: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
810: hr_utility.set_message_token('PROCEDURE',
811: 'ff_formulas_f_pkg.update_row');
812: hr_utility.set_message_token('STEP','1');
813: hr_utility.raise_error;
814: end if;
815: --

Line 822: 'ff_formulas_f_pkg.update_row');

818: if (C%NOTFOUND) then
819: CLOSE C;
820: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
821: hr_utility.set_message_token('PROCEDURE',
822: 'ff_formulas_f_pkg.update_row');
823: hr_utility.set_message_token('STEP','2');
824: hr_utility.raise_error;
825: end if;
826: CLOSE C;

Line 883: from ff_formulas_f ff

879: , ff.business_group_id
880: , nvl(bg.legislation_code,ff.legislation_code)
881: , ff.effective_start_date
882: , ff.effective_end_date
883: from ff_formulas_f ff
884: , per_business_groups bg
885: where ff.formula_id = X_formula_id
886: and ff.business_group_id = bg.business_group_id (+)
887: and (

Line 989: DELETE FROM ff_formulas_f

985: end;
986: end if;
987: --------------------------------------------------------------------------------
988:
989: DELETE FROM ff_formulas_f
990: WHERE rowid = X_Rowid;
991: --
992: if (SQL%NOTFOUND) then
993: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 995: 'ff_formulas_f_pkg.delete_row');

991: --
992: if (SQL%NOTFOUND) then
993: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
994: hr_utility.set_message_token('PROCEDURE',
995: 'ff_formulas_f_pkg.delete_row');
996: hr_utility.set_message_token('STEP','1');
997: hr_utility.raise_error;
998: end if;
999: --

Line 1006: delete from FF_FORMULAS_F_TL T

1002: ---For MLS----------------------------------------------------------------------
1003: procedure ADD_LANGUAGE
1004: is
1005: begin
1006: delete from FF_FORMULAS_F_TL T
1007: where not exists
1008: (select NULL
1009: from FF_FORMULAS_F B
1010: where B.FORMULA_ID = T.FORMULA_ID

Line 1009: from FF_FORMULAS_F B

1005: begin
1006: delete from FF_FORMULAS_F_TL T
1007: where not exists
1008: (select NULL
1009: from FF_FORMULAS_F B
1010: where B.FORMULA_ID = T.FORMULA_ID
1011: );
1012: update FF_FORMULAS_F_TL T set (
1013: FORMULA_NAME,

Line 1012: update FF_FORMULAS_F_TL T set (

1008: (select NULL
1009: from FF_FORMULAS_F B
1010: where B.FORMULA_ID = T.FORMULA_ID
1011: );
1012: update FF_FORMULAS_F_TL T set (
1013: FORMULA_NAME,
1014: DESCRIPTION
1015: ) = (select
1016: B.FORMULA_NAME,

Line 1018: from FF_FORMULAS_F_TL B

1014: DESCRIPTION
1015: ) = (select
1016: B.FORMULA_NAME,
1017: B.DESCRIPTION
1018: from FF_FORMULAS_F_TL B
1019: where B.FORMULA_ID = T.FORMULA_ID
1020: and B.LANGUAGE = T.SOURCE_LANG)
1021: where (
1022: T.FORMULA_ID,

Line 1027: from FF_FORMULAS_F_TL SUBB, FF_FORMULAS_F_TL SUBT

1023: T.LANGUAGE
1024: ) in (select
1025: SUBT.FORMULA_ID,
1026: SUBT.LANGUAGE
1027: from FF_FORMULAS_F_TL SUBB, FF_FORMULAS_F_TL SUBT
1028: where SUBB.FORMULA_ID = SUBT.FORMULA_ID
1029: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1030: and (SUBB.FORMULA_NAME <> SUBT.FORMULA_NAME
1031: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 1036: insert into FF_FORMULAS_F_TL (

1032: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
1033: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
1034: ));
1035:
1036: insert into FF_FORMULAS_F_TL (
1037: FORMULA_ID,
1038: FORMULA_NAME,
1039: DESCRIPTION,
1040: LAST_UPDATE_DATE,

Line 1058: from FF_FORMULAS_F_TL B, FND_LANGUAGES L

1054: B.CREATED_BY,
1055: B.CREATION_DATE,
1056: L.LANGUAGE_CODE,
1057: B.SOURCE_LANG
1058: from FF_FORMULAS_F_TL B, FND_LANGUAGES L
1059: where L.INSTALLED_FLAG in ('I', 'B')
1060: and B.LANGUAGE = userenv('LANG')
1061: and not exists
1062: (select NULL

Line 1063: from FF_FORMULAS_F_TL T

1059: where L.INSTALLED_FLAG in ('I', 'B')
1060: and B.LANGUAGE = userenv('LANG')
1061: and not exists
1062: (select NULL
1063: from FF_FORMULAS_F_TL T
1064: where T.FORMULA_ID = B.FORMULA_ID
1065: and T.LANGUAGE = L.LANGUAGE_CODE);
1066: end ADD_LANGUAGE;
1067: --

Line 1077: UPDATE ff_formulas_f_tl

1073: X_DESCRIPTION in VARCHAR2,
1074: X_OWNER in VARCHAR2
1075: ) is
1076: begin
1077: UPDATE ff_formulas_f_tl
1078: SET FORMULA_NAME = nvl(X_FORMULA_NAME,FORMULA_NAME),
1079: DESCRIPTION = nvl(X_DESCRIPTION,DESCRIPTION),
1080: last_update_date = SYSDATE,
1081: last_updated_by = decode(x_owner,'SEED',1,0),

Line 1087: from FF_FORMULAS_F

1083: source_lang = userenv('LANG')
1084: WHERE userenv('LANG') IN (language,source_lang)
1085: AND FORMULA_ID in
1086: (select FORMULA_ID
1087: from FF_FORMULAS_F
1088: where nvl(FORMULA_NAME,'~null~')=nvl(X_B_FORMULA_NAME,'~null~')
1089: and nvl(LEGISLATION_CODE,'~null~') = nvl(X_B_LEGISLATION_CODE,'~null~')
1090: and BUSINESS_GROUP_ID is NULL);
1091: if (sql%notfound) then

Line 1131: FROM ff_formulas_f_tl fft,

1127: p_formula_id IN NUMBER,
1128: p_bus_grp_id IN NUMBER,
1129: p_leg_code IN varchar2) IS
1130: SELECT 1
1131: FROM ff_formulas_f_tl fft,
1132: ff_formulas_f fff
1133: WHERE upper(fft.formula_name)=upper(p_formula_name)
1134: AND fft.formula_id = fff.formula_id
1135: AND fft.language = p_language

Line 1132: ff_formulas_f fff

1128: p_bus_grp_id IN NUMBER,
1129: p_leg_code IN varchar2) IS
1130: SELECT 1
1131: FROM ff_formulas_f_tl fft,
1132: ff_formulas_f fff
1133: WHERE upper(fft.formula_name)=upper(p_formula_name)
1134: AND fft.formula_id = fff.formula_id
1135: AND fft.language = p_language
1136: AND (fff.formula_id <> p_formula_id OR p_formula_id IS NULL)

Line 1145: l_package_name := 'FF_FORMULAS_F_PKG.VALIDATE_TRANSLATION';

1141: l_business_group_id NUMBER;
1142: l_legislation_code VARCHAR2(150);
1143:
1144: BEGIN
1145: l_package_name := 'FF_FORMULAS_F_PKG.VALIDATE_TRANSLATION';
1146: l_business_group_id := p_business_group_id;
1147: l_legislation_code := p_legislation_code;
1148: hr_utility.set_location (l_package_name,10);
1149: OPEN c_translation(language, formula_name,formula_id,

Line 1173: END FF_FORMULAS_F_PKG;

1169: begin
1170: return g_dml_status;
1171: end return_dml_status;
1172: ---
1173: END FF_FORMULAS_F_PKG;