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.PA_FP_SPREAD_CURVES_PKG dependencies on PA_SPREAD_CURVES_TL

Line 49: delete from PA_SPREAD_CURVES_TL

45: procedure DELETE_ROW (
46: p_spread_curve_id in Pa_spread_curves_b.spread_curve_id%TYPE
47: ) is
48: begin
49: delete from PA_SPREAD_CURVES_TL
50: where spread_curve_id = p_spread_curve_id;
51:
52: if (sql%notfound) then
53: raise no_data_found;

Line 70: X_Name IN Pa_Spread_Curves_Tl.Name%Type,

66: X_Rowid IN OUT NOCOPY Rowid, --File.Sql.39 bug 4440895
67: X_Spread_Curve_Id IN Pa_Spread_Curves_B.Spread_Curve_Id%Type,
68: X_Spread_Curve_Code IN Pa_Spread_Curves_B.Spread_Curve_Code%Type,
69: X_Record_Version_Number IN Pa_Spread_Curves_B.Record_Version_Number%Type,
70: X_Name IN Pa_Spread_Curves_Tl.Name%Type,
71: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
72: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
73: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
74: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,

Line 71: X_Description IN Pa_Spread_Curves_Tl.Description%Type,

67: X_Spread_Curve_Id IN Pa_Spread_Curves_B.Spread_Curve_Id%Type,
68: X_Spread_Curve_Code IN Pa_Spread_Curves_B.Spread_Curve_Code%Type,
69: X_Record_Version_Number IN Pa_Spread_Curves_B.Record_Version_Number%Type,
70: X_Name IN Pa_Spread_Curves_Tl.Name%Type,
71: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
72: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
73: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
74: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
75: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,

Line 178: pa_debug.g_err_stage:= 'Inserting record in Pa_Spread_Curves_TL'||to_char(l_spread_Curve_id);

174: X_Last_Update_Login
175: );
176:
177: IF l_debug_mode = 'Y' THEN
178: pa_debug.g_err_stage:= 'Inserting record in Pa_Spread_Curves_TL'||to_char(l_spread_Curve_id);
179: pa_debug.write(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level3);
180: END IF;
181:
182: INSERT INTO Pa_Spread_Curves_TL

Line 182: INSERT INTO Pa_Spread_Curves_TL

178: pa_debug.g_err_stage:= 'Inserting record in Pa_Spread_Curves_TL'||to_char(l_spread_Curve_id);
179: pa_debug.write(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level3);
180: END IF;
181:
182: INSERT INTO Pa_Spread_Curves_TL
183: (
184: Spread_Curve_Id,
185: Name,
186: Description,

Line 209: (SELECT NULL FROM Pa_Spread_Curves_Tl T

205: Userenv('Lang')
206: FROM Fnd_Languages L
207: WHERE L.Installed_Flag In ('I', 'B')
208: AND NOT EXISTS
209: (SELECT NULL FROM Pa_Spread_Curves_Tl T
210: WHERE T.Spread_Curve_Id = L_Spread_Curve_Id
211: AND T.Language = L.Language_Code);
212:
213: OPEN C;

Line 280: X_Name IN Pa_Spread_Curves_Tl.Name%Type,

276: Procedure Update_Row (
277: X_Spread_Curve_Id IN Pa_Spread_Curves_B.Spread_Curve_Id%Type,
278: X_Spread_Curve_Code IN Pa_Spread_Curves_B.Spread_Curve_Code%Type,
279: X_Record_Version_Number IN Pa_Spread_Curves_B.Record_Version_Number%Type,
280: X_Name IN Pa_Spread_Curves_Tl.Name%Type,
281: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
282: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
283: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
284: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,

Line 281: X_Description IN Pa_Spread_Curves_Tl.Description%Type,

277: X_Spread_Curve_Id IN Pa_Spread_Curves_B.Spread_Curve_Id%Type,
278: X_Spread_Curve_Code IN Pa_Spread_Curves_B.Spread_Curve_Code%Type,
279: X_Record_Version_Number IN Pa_Spread_Curves_B.Record_Version_Number%Type,
280: X_Name IN Pa_Spread_Curves_Tl.Name%Type,
281: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
282: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
283: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
284: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
285: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,

Line 356: pa_debug.g_err_stage:= 'Updating Pa_Spread_Curves_TL for'||to_char(X_spread_Curve_id);

352: RAISE NO_DATA_FOUND;
353: END IF;
354:
355: IF l_debug_mode = 'Y' THEN
356: pa_debug.g_err_stage:= 'Updating Pa_Spread_Curves_TL for'||to_char(X_spread_Curve_id);
357: pa_debug.write(g_module_name,pa_debug.g_err_stage,pa_fp_constants_pkg.g_debug_level3);
358: END IF;
359:
360: UPDATE Pa_Spread_Curves_TL

Line 360: UPDATE Pa_Spread_Curves_TL

356: pa_debug.g_err_stage:= 'Updating Pa_Spread_Curves_TL for'||to_char(X_spread_Curve_id);
357: pa_debug.write(g_module_name,pa_debug.g_err_stage,pa_fp_constants_pkg.g_debug_level3);
358: END IF;
359:
360: UPDATE Pa_Spread_Curves_TL
361: SET Name = X_Name,
362: Description = X_Description,
363: Last_Update_Date = X_Last_Update_Date,
364: Last_Updated_By = X_Last_Updated_By,

Line 429: X_Name IN Pa_Spread_Curves_Tl.Name%Type,

425: Procedure Load_Row (
426: X_Spread_Curve_Id IN Pa_Spread_Curves_B.Spread_Curve_Id%Type,
427: X_Spread_Curve_Code IN Pa_Spread_Curves_B.Spread_Curve_Code%Type,
428: X_Record_Version_Number IN Pa_Spread_Curves_B.Record_Version_Number%Type,
429: X_Name IN Pa_Spread_Curves_Tl.Name%Type,
430: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
431: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
432: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
433: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,

Line 430: X_Description IN Pa_Spread_Curves_Tl.Description%Type,

426: X_Spread_Curve_Id IN Pa_Spread_Curves_B.Spread_Curve_Id%Type,
427: X_Spread_Curve_Code IN Pa_Spread_Curves_B.Spread_Curve_Code%Type,
428: X_Record_Version_Number IN Pa_Spread_Curves_B.Record_Version_Number%Type,
429: X_Name IN Pa_Spread_Curves_Tl.Name%Type,
430: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
431: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
432: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
433: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
434: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,

Line 549: delete from PA_SPREAD_CURVES_TL T

545: PROCEDURE Add_Language
546: IS
547: BEGIN
548:
549: delete from PA_SPREAD_CURVES_TL T
550: where not exists
551: (select NULL
552: from PA_SPREAD_CURVES_B B
553: where B.SPREAD_CURVE_ID = T.SPREAD_CURVE_ID

Line 556: update PA_SPREAD_CURVES_TL T set (

552: from PA_SPREAD_CURVES_B B
553: where B.SPREAD_CURVE_ID = T.SPREAD_CURVE_ID
554: );
555:
556: update PA_SPREAD_CURVES_TL T set (
557: NAME,
558: DESCRIPTION
559: ) = (select
560: B.NAME,

Line 562: from PA_SPREAD_CURVES_TL B

558: DESCRIPTION
559: ) = (select
560: B.NAME,
561: B.DESCRIPTION
562: from PA_SPREAD_CURVES_TL B
563: where B.SPREAD_CURVE_ID = T.SPREAD_CURVE_ID
564: and B.LANGUAGE = T.SOURCE_LANG)
565: where (
566: T.SPREAD_CURVE_ID,

Line 571: from PA_SPREAD_CURVES_TL SUBB, PA_SPREAD_CURVES_TL SUBT

567: T.LANGUAGE
568: ) in (select
569: SUBT.SPREAD_CURVE_ID,
570: SUBT.LANGUAGE
571: from PA_SPREAD_CURVES_TL SUBB, PA_SPREAD_CURVES_TL SUBT
572: where SUBB.SPREAD_CURVE_ID = SUBT.SPREAD_CURVE_ID
573: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
574: and (SUBB.NAME <> SUBT.NAME
575: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 580: insert into PA_SPREAD_CURVES_TL (

576: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
577: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
578: ));
579:
580: insert into PA_SPREAD_CURVES_TL (
581: LAST_UPDATE_LOGIN,
582: CREATION_DATE,
583: CREATED_BY,
584: LAST_UPDATE_DATE,

Line 602: from PA_SPREAD_CURVES_TL B, FND_LANGUAGES L

598: B.NAME,
599: B.DESCRIPTION,
600: L.LANGUAGE_CODE,
601: B.SOURCE_LANG
602: from PA_SPREAD_CURVES_TL B, FND_LANGUAGES L
603: where L.INSTALLED_FLAG in ('I', 'B')
604: and B.LANGUAGE = userenv('LANG')
605: and not exists
606: (select NULL

Line 607: from PA_SPREAD_CURVES_TL T

603: where L.INSTALLED_FLAG in ('I', 'B')
604: and B.LANGUAGE = userenv('LANG')
605: and not exists
606: (select NULL
607: from PA_SPREAD_CURVES_TL T
608: where T.SPREAD_CURVE_ID = B.SPREAD_CURVE_ID
609: and T.LANGUAGE = L.LANGUAGE_CODE);
610: end ADD_LANGUAGE;
611:

Line 616: X_NAME in PA_SPREAD_CURVES_TL.NAME%TYPE,

612:
613: procedure TRANSLATE_ROW (
614: X_SPREAD_CURVE_ID in PA_SPREAD_CURVES_B.SPREAD_CURVE_ID%TYPE,
615: X_OWNER in VARCHAR2 ,
616: X_NAME in PA_SPREAD_CURVES_TL.NAME%TYPE,
617: X_DESCRIPTION in PA_SPREAD_CURVES_TL.DESCRIPTION%TYPE
618: )is
619: begin
620:

Line 617: X_DESCRIPTION in PA_SPREAD_CURVES_TL.DESCRIPTION%TYPE

613: procedure TRANSLATE_ROW (
614: X_SPREAD_CURVE_ID in PA_SPREAD_CURVES_B.SPREAD_CURVE_ID%TYPE,
615: X_OWNER in VARCHAR2 ,
616: X_NAME in PA_SPREAD_CURVES_TL.NAME%TYPE,
617: X_DESCRIPTION in PA_SPREAD_CURVES_TL.DESCRIPTION%TYPE
618: )is
619: begin
620:
621: update PA_SPREAD_CURVES_TL set

Line 621: update PA_SPREAD_CURVES_TL set

617: X_DESCRIPTION in PA_SPREAD_CURVES_TL.DESCRIPTION%TYPE
618: )is
619: begin
620:
621: update PA_SPREAD_CURVES_TL set
622: NAME = X_NAME,
623: DESCRIPTION = X_DESCRIPTION,
624: LAST_UPDATE_DATE = sysdate,
625: LAST_UPDATED_BY = decode(X_OWNER, 'SEED', 1, 0),