APPS.PER_CAGR_API_PARAMETERS_PKG dependencies on PER_CAGR_API_PARAMETERS_TL

Line 133: p_entity_name => 'PER_CAGR_API_PARAMETERS_TL',

129: --
130:
131: BEGIN
132: PER_RIC_PKG.chk_integrity (
133: p_entity_name => 'PER_CAGR_API_PARAMETERS_TL',
134: p_ref_entity => 'PER_CAGR_API_PARAMETERS',
135: p_ref_column_name => 'CAGR_API_PARAM_ID',
136: p_ref_col_value_number => X_CAGR_API_PARAM_ID,
137: p_ref_col_value_varchar => NULL,

Line 146: insert into PER_CAGR_API_PARAMETERS_TL (

142: --
143: -- Code Ends Here.
144: --
145:
146: insert into PER_CAGR_API_PARAMETERS_TL (
147: LAST_UPDATE_LOGIN,
148: CREATED_BY,
149: CREATION_DATE,
150: LAST_UPDATE_DATE,

Line 170: from PER_CAGR_API_PARAMETERS_TL T

166: from FND_LANGUAGES L
167: where L.INSTALLED_FLAG in ('I', 'B')
168: and not exists
169: (select NULL
170: from PER_CAGR_API_PARAMETERS_TL T
171: where T.CAGR_API_PARAM_ID = X_CAGR_API_PARAM_ID
172: and T.LANGUAGE = L.LANGUAGE_CODE);
173:
174: open c;

Line 204: update per_cagr_api_parameters_tl set

200: X_CAGR_API_ID
201: );
202:
203:
204: update per_cagr_api_parameters_tl set
205: display_name = X_display_NAME,
206: last_update_date = sysdate,
207: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),
208: last_update_login = 0,

Line 322: from PER_CAGR_API_PARAMETERS_TL

318:
319: cursor c1 is select
320: DISPLAY_NAME,
321: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
322: from PER_CAGR_API_PARAMETERS_TL
323: where CAGR_API_PARAM_ID = X_CAGR_API_PARAM_ID
324: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
325: for update of CAGR_API_PARAM_ID nowait;
326: begin

Line 409: update PER_CAGR_API_PARAMETERS_TL set

405: if (sql%notfound) then
406: raise no_data_found;
407: end if;
408:
409: update PER_CAGR_API_PARAMETERS_TL set
410: DISPLAY_NAME = X_DISPLAY_NAME,
411: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
412: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
413: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 427: delete from PER_CAGR_API_PARAMETERS_TL

423: procedure DELETE_ROW (
424: X_CAGR_API_PARAM_ID in NUMBER
425: ) is
426: begin
427: delete from PER_CAGR_API_PARAMETERS_TL
428: where CAGR_API_PARAM_ID = X_CAGR_API_PARAM_ID;
429:
430: if (sql%notfound) then
431: raise no_data_found;

Line 441: p_ref_entity => 'PER_CAGR_API_PARAMETERS_TL',

437:
438: BEGIN
439: PER_RIC_PKG.chk_integrity (
440: p_entity_name => 'PER_CAGR_API_PARAMETERS',
441: p_ref_entity => 'PER_CAGR_API_PARAMETERS_TL',
442: p_ref_column_name => 'CAGR_API_PARAM_ID',
443: p_ref_col_value_number => X_CAGR_API_PARAM_ID,
444: p_ref_col_value_varchar => NULL,
445: p_ref_col_value_date => NULL,

Line 463: delete from PER_CAGR_API_PARAMETERS_TL T

459:
460: procedure ADD_LANGUAGE
461: is
462: begin
463: delete from PER_CAGR_API_PARAMETERS_TL T
464: where not exists
465: (select NULL
466: from PER_CAGR_API_PARAMETERS B
467: where B.CAGR_API_PARAM_ID = T.CAGR_API_PARAM_ID

Line 470: update PER_CAGR_API_PARAMETERS_TL T set (

466: from PER_CAGR_API_PARAMETERS B
467: where B.CAGR_API_PARAM_ID = T.CAGR_API_PARAM_ID
468: );
469:
470: update PER_CAGR_API_PARAMETERS_TL T set (
471: DISPLAY_NAME
472: ) = (select
473: B.DISPLAY_NAME
474: from PER_CAGR_API_PARAMETERS_TL B

Line 474: from PER_CAGR_API_PARAMETERS_TL B

470: update PER_CAGR_API_PARAMETERS_TL T set (
471: DISPLAY_NAME
472: ) = (select
473: B.DISPLAY_NAME
474: from PER_CAGR_API_PARAMETERS_TL B
475: where B.CAGR_API_PARAM_ID = T.CAGR_API_PARAM_ID
476: and B.LANGUAGE = T.SOURCE_LANG)
477: where (
478: T.CAGR_API_PARAM_ID,

Line 483: from PER_CAGR_API_PARAMETERS_TL SUBB, PER_CAGR_API_PARAMETERS_TL SUBT

479: T.LANGUAGE
480: ) in (select
481: SUBT.CAGR_API_PARAM_ID,
482: SUBT.LANGUAGE
483: from PER_CAGR_API_PARAMETERS_TL SUBB, PER_CAGR_API_PARAMETERS_TL SUBT
484: where SUBB.CAGR_API_PARAM_ID = SUBT.CAGR_API_PARAM_ID
485: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
486: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
487: ));

Line 489: insert into PER_CAGR_API_PARAMETERS_TL (

485: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
486: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
487: ));
488:
489: insert into PER_CAGR_API_PARAMETERS_TL (
490: LAST_UPDATE_LOGIN,
491: CREATED_BY,
492: CREATION_DATE,
493: LAST_UPDATE_DATE,

Line 509: from PER_CAGR_API_PARAMETERS_TL B, FND_LANGUAGES L

505: B.CAGR_API_PARAM_ID,
506: B.DISPLAY_NAME,
507: L.LANGUAGE_CODE,
508: B.SOURCE_LANG
509: from PER_CAGR_API_PARAMETERS_TL B, FND_LANGUAGES L
510: where L.INSTALLED_FLAG in ('I', 'B')
511: and B.LANGUAGE = userenv('LANG')
512: and not exists
513: (select NULL

Line 514: from PER_CAGR_API_PARAMETERS_TL T

510: where L.INSTALLED_FLAG in ('I', 'B')
511: and B.LANGUAGE = userenv('LANG')
512: and not exists
513: (select NULL
514: from PER_CAGR_API_PARAMETERS_TL T
515: where T.CAGR_API_PARAM_ID = B.CAGR_API_PARAM_ID
516: and T.LANGUAGE = L.LANGUAGE_CODE);
517: end ADD_LANGUAGE;
518: