APPS.RG_REPORT_STANDARD_AXES_PKG dependencies on RG_REPORT_STANDARD_AXES_TL

Line 21: PROCEDURE select_row(recinfo IN OUT NOCOPY rg_report_standard_axes_tl%ROWTYPE) IS

17: -- None.
18: --
19: -- PUBLIC FUNCTIONS
20: --
21: PROCEDURE select_row(recinfo IN OUT NOCOPY rg_report_standard_axes_tl%ROWTYPE) IS
22: BEGIN
23: select * INTO recinfo
24: from rg_report_standard_axes_tl
25: where standard_axis_id = recinfo.standard_axis_id;

Line 24: from rg_report_standard_axes_tl

20: --
21: PROCEDURE select_row(recinfo IN OUT NOCOPY rg_report_standard_axes_tl%ROWTYPE) IS
22: BEGIN
23: select * INTO recinfo
24: from rg_report_standard_axes_tl
25: where standard_axis_id = recinfo.standard_axis_id;
26: END select_row;
27:
28: PROCEDURE select_columns(X_standard_axis_id NUMBER,

Line 30: recinfo rg_report_standard_axes_tl%ROWTYPE;

26: END select_row;
27:
28: PROCEDURE select_columns(X_standard_axis_id NUMBER,
29: X_name IN OUT NOCOPY VARCHAR2) IS
30: recinfo rg_report_standard_axes_tl%ROWTYPE;
31: BEGIN
32: recinfo.standard_axis_id := X_standard_axis_id;
33: select_row(recinfo);
34: X_name := recinfo.standard_axis_name;

Line 114: INSERT INTO RG_REPORT_STANDARD_AXES_TL

110: X_sign_flag
111: );
112:
113:
114: INSERT INTO RG_REPORT_STANDARD_AXES_TL
115: (
116: STANDARD_AXIS_ID,
117: LANGUAGE,
118: SOURCE_LANG,

Line 142: FROM RG_REPORT_STANDARD_AXES_TL R

138: FROM FND_LANGUAGES L
139: WHERE L.installed_flag IN ('I', 'B')
140: AND NOT EXISTS
141: ( SELECT NULL
142: FROM RG_REPORT_STANDARD_AXES_TL R
143: WHERE R.standard_axis_id = X_standard_axis_id
144: AND R.language = L.language_code );
145:
146:

Line 207: UPDATE RG_REPORT_STANDARD_AXES_TL

203: END IF;
204:
205: -- update non-translatable columns
206:
207: UPDATE RG_REPORT_STANDARD_AXES_TL
208: SET
209: STANDARD_AXIS_ID = X_standard_axis_id,
210: LAST_UPDATE_DATE = X_last_update_date,
211: LAST_UPDATED_BY = X_last_updated_by,

Line 221: UPDATE RG_REPORT_STANDARD_AXES_TL

217: END IF;
218:
219: -- update translatable columns
220:
221: UPDATE RG_REPORT_STANDARD_AXES_TL
222: SET DESCRIPTION = X_description,
223: STANDARD_AXIS_NAME = X_standard_axis_name,
224: SOURCE_LANG = userenv('LANG')
225: WHERE standard_axis_id = X_standard_axis_id

Line 373: UPDATE RG_REPORT_STANDARD_AXES_TL

369: /*
370: * Update only if force_edits is 'Y' OR user_id is 'SEED'.
371: */
372: IF ( user_id = 1 or X_Force_Edits = 'Y' ) THEN
373: UPDATE RG_REPORT_STANDARD_AXES_TL
374: SET
375: standard_axis_name = X_Standard_Axis_Name,
376: description = X_Description,
377: source_lang = userenv('LANG'),

Line 396: UPDATE RG_REPORT_STANDARD_AXES_TL T

392: PROCEDURE ADD_LANGUAGE
393: is
394: begin
395:
396: UPDATE RG_REPORT_STANDARD_AXES_TL T
397: set ( standard_axis_name,
398: description)
399: = ( select
400: B.standard_axis_name,

Line 402: from rg_report_standard_axes_tl B

398: description)
399: = ( select
400: B.standard_axis_name,
401: B.description
402: from rg_report_standard_axes_tl B
403: where B.standard_axis_id = T.standard_axis_id
404: and B.language = T.source_lang)
405: where ( T.standard_axis_id,
406: T.language ) in

Line 410: from rg_report_standard_axes_tl SUBB,

406: T.language ) in
407: ( select
408: SUBT.standard_axis_id ,
409: SUBT.language
410: from rg_report_standard_axes_tl SUBB,
411: rg_report_standard_axes_tl SUBT
412: where SUBB.standard_axis_id = SUBT.standard_axis_id
413: and SUBB.language = SUBT.source_lang
414: and ( SUBB.standard_axis_name <> SUBT.standard_axis_name

Line 411: rg_report_standard_axes_tl SUBT

407: ( select
408: SUBT.standard_axis_id ,
409: SUBT.language
410: from rg_report_standard_axes_tl SUBB,
411: rg_report_standard_axes_tl SUBT
412: where SUBB.standard_axis_id = SUBT.standard_axis_id
413: and SUBB.language = SUBT.source_lang
414: and ( SUBB.standard_axis_name <> SUBT.standard_axis_name
415: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 421: INSERT INTO RG_REPORT_STANDARD_AXES_TL

417: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null))
418: );
419:
420:
421: INSERT INTO RG_REPORT_STANDARD_AXES_TL
422: (
423: STANDARD_AXIS_ID,
424: LANGUAGE,
425: SOURCE_LANG,

Line 445: FROM rg_report_standard_axes_tl B, FND_LANGUAGES L

441: B.last_update_login,
442: B.creation_date,
443: B.created_by,
444: B.description
445: FROM rg_report_standard_axes_tl B, FND_LANGUAGES L
446: WHERE L.installed_flag IN ('I', 'B')
447: AND B.language = USERENV('LANG')
448: AND NOT EXISTS
449: ( SELECT NULL

Line 450: FROM RG_REPORT_STANDARD_AXES_TL R

446: WHERE L.installed_flag IN ('I', 'B')
447: AND B.language = USERENV('LANG')
448: AND NOT EXISTS
449: ( SELECT NULL
450: FROM RG_REPORT_STANDARD_AXES_TL R
451: WHERE R.standard_axis_id = B.standard_axis_id
452: AND R.language = L.language_code );
453:
454: end ADD_LANGUAGE;