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.FND_CONCURRENT_PROGRAMS_PKG dependencies on FND_CONCURRENT_PROGRAMS

Line 1: package body FND_CONCURRENT_PROGRAMS_PKG as

1: package body FND_CONCURRENT_PROGRAMS_PKG as
2: /* $Header: AFCPMCPB.pls 120.2.12000000.2 2007/09/07 07:06:22 ggupta ship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out nocopy VARCHAR2,

Line 60: cursor C is select ROWID from FND_CONCURRENT_PROGRAMS

56: X_TEMPLATE_APPL_SHORT_NAME in VARCHAR2,
57: X_TEMPLATE_CODE in VARCHAR2,
58: X_MULTI_ORG_CATEGORY in VARCHAR2
59: ) is
60: cursor C is select ROWID from FND_CONCURRENT_PROGRAMS
61: where APPLICATION_ID = X_APPLICATION_ID
62: and CONCURRENT_PROGRAM_ID = X_CONCURRENT_PROGRAM_ID;
63: begin
64: insert into FND_CONCURRENT_PROGRAMS (

Line 64: insert into FND_CONCURRENT_PROGRAMS (

60: cursor C is select ROWID from FND_CONCURRENT_PROGRAMS
61: where APPLICATION_ID = X_APPLICATION_ID
62: and CONCURRENT_PROGRAM_ID = X_CONCURRENT_PROGRAM_ID;
63: begin
64: insert into FND_CONCURRENT_PROGRAMS (
65: APPLICATION_ID,
66: CONCURRENT_PROGRAM_ID,
67: CONCURRENT_PROGRAM_NAME,
68: EXECUTABLE_APPLICATION_ID,

Line 171: insert into FND_CONCURRENT_PROGRAMS_TL (

167: X_MULTI_ORG_CATEGORY
168: );
169:
170:
171: insert into FND_CONCURRENT_PROGRAMS_TL (
172: APPLICATION_ID,
173: CONCURRENT_PROGRAM_ID,
174: USER_CONCURRENT_PROGRAM_NAME,
175: CREATION_DATE,

Line 199: from FND_CONCURRENT_PROGRAMS_TL T

195: from FND_LANGUAGES L
196: where L.INSTALLED_FLAG in ('I', 'B')
197: and not exists
198: (select NULL
199: from FND_CONCURRENT_PROGRAMS_TL T
200: where T.APPLICATION_ID = X_APPLICATION_ID
201: and T.CONCURRENT_PROGRAM_ID = X_CONCURRENT_PROGRAM_ID
202: and T.LANGUAGE = L.LANGUAGE_CODE);
203:

Line 310: from FND_CONCURRENT_PROGRAMS

306: TEMPLATE_CODE,
307: TEMPLATE_APPL_SHORT_NAME,
308: MULTI_ORG_CATEGORY
309:
310: from FND_CONCURRENT_PROGRAMS
311: where APPLICATION_ID = X_APPLICATION_ID
312: and CONCURRENT_PROGRAM_ID = X_CONCURRENT_PROGRAM_ID
313: for update of APPLICATION_ID nowait;
314: recinfo c%rowtype;

Line 320: from FND_CONCURRENT_PROGRAMS_TL

316: cursor c1 is select
317: USER_CONCURRENT_PROGRAM_NAME,
318: DESCRIPTION,
319: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
320: from FND_CONCURRENT_PROGRAMS_TL
321: where APPLICATION_ID = X_APPLICATION_ID
322: and CONCURRENT_PROGRAM_ID = X_CONCURRENT_PROGRAM_ID
323: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
324: for update of APPLICATION_ID nowait;

Line 484: update FND_CONCURRENT_PROGRAMS set

480: X_TEMPLATE_CODE VARCHAR2,
481: X_MULTI_ORG_CATEGORY VARCHAR2
482: ) is
483: begin
484: update FND_CONCURRENT_PROGRAMS set
485: CONCURRENT_PROGRAM_NAME =
486: nvl(X_CONCURRENT_PROGRAM_NAME, CONCURRENT_PROGRAM_NAME),
487: EXECUTABLE_APPLICATION_ID = X_EXECUTABLE_APPLICATION_ID,
488: EXECUTABLE_ID = X_EXECUTABLE_ID,

Line 540: update FND_CONCURRENT_PROGRAMS_TL set

536: if (sql%notfound) then
537: raise no_data_found;
538: end if;
539:
540: update FND_CONCURRENT_PROGRAMS_TL set
541: USER_CONCURRENT_PROGRAM_NAME = X_USER_CONCURRENT_PROGRAM_NAME,
542: DESCRIPTION = X_DESCRIPTION,
543: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
544: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 565: fnd_concurrent_programs_pkg.translate_row (

561: x_user_concurrent_program_name in varchar2,
562: x_description in varchar2)
563: is
564: begin
565: fnd_concurrent_programs_pkg.translate_row (
566: x_concurrent_program_name => x_concurrent_program_name,
567: x_application_short_name => x_application_short_name,
568: x_owner => x_owner,
569: x_user_concurrent_program_name => x_user_concurrent_program_name,

Line 598: from fnd_concurrent_programs

594: where application_short_name = x_application_short_name;
595:
596: begin
597: select CONCURRENT_PROGRAM_ID into key_id
598: from fnd_concurrent_programs
599: where APPLICATION_ID = app_id
600: and CONCURRENT_PROGRAM_NAME = x_concurrent_program_name;
601: exception when others then key_id :=null;
602: end;

Line 613: from FND_CONCURRENT_PROGRAMS_TL

609:
610: begin
611: select LAST_UPDATED_BY, LAST_UPDATE_DATE
612: into db_luby, db_ludate
613: from FND_CONCURRENT_PROGRAMS_TL
614: where APPLICATION_ID = app_id
615: and CONCURRENT_PROGRAM_ID = key_id
616: and LANGUAGE = userenv('LANG');
617:

Line 630: update FND_CONCURRENT_PROGRAMS_TL set

626: p_db_id => db_luby,
627: p_db_lud => db_ludate,
628: p_custom_mode => x_custom_mode))
629: then
630: update FND_CONCURRENT_PROGRAMS_TL set
631: USER_CONCURRENT_PROGRAM_NAME =
632: nvl(x_user_concurrent_program_name, USER_CONCURRENT_PROGRAM_NAME),
633: DESCRIPTION = nvl(x_description, DESCRIPTION),
634: SOURCE_LANG = userenv('LANG'),

Line 704: fnd_concurrent_programs_pkg.LOAD_ROW (

700: x_optimizer_mode in varchar2,
701: x_srs_flex in varchar2)
702: is
703: begin
704: fnd_concurrent_programs_pkg.LOAD_ROW (
705: x_concurrent_program_name => x_concurrent_program_name,
706: x_application_short_name => x_application_short_name,
707: x_owner => x_owner,
708: x_user_concurrent_program_name => x_user_concurrent_program_name,

Line 904: from FND_CONCURRENT_PROGRAMS

900:
901: begin
902: select CONCURRENT_PROGRAM_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE
903: into key_id, db_luby, db_ludate
904: from FND_CONCURRENT_PROGRAMS
905: where APPLICATION_ID = app_id
906: and CONCURRENT_PROGRAM_NAME = x_concurrent_program_name;
907:
908: -- Update record, honoring customization mode.

Line 930: update FND_CONCURRENT_PROGRAMS set

926: delete from fnd_concurrent_program_serial
927: WHERE to_run_concurrent_program_id = key_id
928: AND to_run_application_id = app_id; */
929:
930: update FND_CONCURRENT_PROGRAMS set
931: LAST_UPDATE_DATE = f_ludate,
932: LAST_UPDATED_BY = f_luby,
933: LAST_UPDATE_LOGIN = 0,
934: EXECUTABLE_ID = ex_id,

Line 994: update fnd_concurrent_programs_tl set

990:
991: where APPLICATION_ID = app_id
992: and CONCURRENT_PROGRAM_ID = key_id;
993:
994: update fnd_concurrent_programs_tl set
995: source_lang=userenv('LANG'),
996: USER_CONCURRENT_PROGRAM_NAME =
997: nvl(x_user_concurrent_program_name, USER_CONCURRENT_PROGRAM_NAME),
998: DESCRIPTION = nvl(x_description, DESCRIPTION),

Line 1016: update FND_CONCURRENT_PROGRAMS

1012: -- CD_PARAMETER is one of these, see bug 2737442
1013: -- Update it quietly, without setting last_update_date or last_updated_by
1014: -- 03/27/03 - not checking last_update anymore, this column is ALWAYS updated.
1015: begin
1016: update FND_CONCURRENT_PROGRAMS
1017: set CD_PARAMETER = x_cd_parameter
1018: where APPLICATION_ID = app_id
1019: and CONCURRENT_PROGRAM_ID = key_id;
1020: exception

Line 1031: select FND_CONCURRENT_PROGRAMS_S.nextval into key_id from dual;

1027:
1028: exception
1029: when no_data_found then
1030:
1031: select FND_CONCURRENT_PROGRAMS_S.nextval into key_id from dual;
1032:
1033: insert into FND_CONCURRENT_PROGRAMS
1034: (CONCURRENT_PROGRAM_NAME, CONCURRENT_PROGRAM_ID,
1035: APPLICATION_ID, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE,

Line 1033: insert into FND_CONCURRENT_PROGRAMS

1029: when no_data_found then
1030:
1031: select FND_CONCURRENT_PROGRAMS_S.nextval into key_id from dual;
1032:
1033: insert into FND_CONCURRENT_PROGRAMS
1034: (CONCURRENT_PROGRAM_NAME, CONCURRENT_PROGRAM_ID,
1035: APPLICATION_ID, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE,
1036: LAST_UPDATED_BY, LAST_UPDATE_LOGIN, EXECUTABLE_ID,
1037: EXECUTABLE_APPLICATION_ID, EXECUTION_METHOD_CODE,

Line 1078: insert into FND_CONCURRENT_PROGRAMS_TL

1074: x_template_appl_short_name, x_template_code,
1075: x_multi_org_category
1076: from DUAL;
1077:
1078: insert into FND_CONCURRENT_PROGRAMS_TL
1079: (CONCURRENT_PROGRAM_ID, APPLICATION_ID, CREATION_DATE,
1080: CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY,
1081: LAST_UPDATE_LOGIN, DESCRIPTION,USER_CONCURRENT_PROGRAM_NAME,
1082: LANGUAGE, SOURCE_LANG)

Line 1091: from FND_CONCURRENT_PROGRAMS_TL T

1087: from FND_LANGUAGES L
1088: where L.INSTALLED_FLAG in ('I', 'B')
1089: and not exists
1090: (select NULL
1091: from FND_CONCURRENT_PROGRAMS_TL T
1092: where T.APPLICATION_ID = app_id
1093: and T.CONCURRENT_PROGRAM_ID =key_id
1094: and T.LANGUAGE = L.LANGUAGE_CODE);
1095:

Line 1108: delete from FND_CONCURRENT_PROGRAMS_TL T

1104: /* The following delete and update statements are commented out */
1105: /* as a quick workaround to fix the time-consuming table handler issue */
1106: /* Eventually we'll need to turn them into a separate fix_language procedure */
1107: /*
1108: delete from FND_CONCURRENT_PROGRAMS_TL T
1109: where not exists
1110: (select NULL
1111: from FND_CONCURRENT_PROGRAMS B
1112: where B.APPLICATION_ID = T.APPLICATION_ID

Line 1111: from FND_CONCURRENT_PROGRAMS B

1107: /*
1108: delete from FND_CONCURRENT_PROGRAMS_TL T
1109: where not exists
1110: (select NULL
1111: from FND_CONCURRENT_PROGRAMS B
1112: where B.APPLICATION_ID = T.APPLICATION_ID
1113: and B.CONCURRENT_PROGRAM_ID = T.CONCURRENT_PROGRAM_ID
1114: );
1115:

Line 1116: update FND_CONCURRENT_PROGRAMS_TL T set (

1112: where B.APPLICATION_ID = T.APPLICATION_ID
1113: and B.CONCURRENT_PROGRAM_ID = T.CONCURRENT_PROGRAM_ID
1114: );
1115:
1116: update FND_CONCURRENT_PROGRAMS_TL T set (
1117: USER_CONCURRENT_PROGRAM_NAME,
1118: DESCRIPTION
1119: ) = (select
1120: B.USER_CONCURRENT_PROGRAM_NAME,

Line 1122: from FND_CONCURRENT_PROGRAMS_TL B

1118: DESCRIPTION
1119: ) = (select
1120: B.USER_CONCURRENT_PROGRAM_NAME,
1121: B.DESCRIPTION
1122: from FND_CONCURRENT_PROGRAMS_TL B
1123: where B.APPLICATION_ID = T.APPLICATION_ID
1124: and B.CONCURRENT_PROGRAM_ID = T.CONCURRENT_PROGRAM_ID
1125: and B.LANGUAGE = T.SOURCE_LANG)
1126: where (

Line 1134: from FND_CONCURRENT_PROGRAMS_TL SUBB, FND_CONCURRENT_PROGRAMS_TL SUBT

1130: ) in (select
1131: SUBT.APPLICATION_ID,
1132: SUBT.CONCURRENT_PROGRAM_ID,
1133: SUBT.LANGUAGE
1134: from FND_CONCURRENT_PROGRAMS_TL SUBB, FND_CONCURRENT_PROGRAMS_TL SUBT
1135: where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
1136: and SUBB.CONCURRENT_PROGRAM_ID = SUBT.CONCURRENT_PROGRAM_ID
1137: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1138: and (SUBB.USER_CONCURRENT_PROGRAM_NAME <> SUBT.USER_CONCURRENT_PROGRAM_NAME

Line 1145: insert into FND_CONCURRENT_PROGRAMS_TL (

1141: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
1142: ));
1143: */
1144:
1145: insert into FND_CONCURRENT_PROGRAMS_TL (
1146: APPLICATION_ID,
1147: CONCURRENT_PROGRAM_ID,
1148: USER_CONCURRENT_PROGRAM_NAME,
1149: CREATION_DATE,

Line 1169: from FND_CONCURRENT_PROGRAMS_TL B, FND_LANGUAGES L

1165: B.LAST_UPDATE_LOGIN,
1166: B.DESCRIPTION,
1167: L.LANGUAGE_CODE,
1168: B.SOURCE_LANG
1169: from FND_CONCURRENT_PROGRAMS_TL B, FND_LANGUAGES L
1170: where L.INSTALLED_FLAG in ('I', 'B')
1171: and B.LANGUAGE = userenv('LANG')
1172: and not exists
1173: (select NULL

Line 1174: from FND_CONCURRENT_PROGRAMS_TL T

1170: where L.INSTALLED_FLAG in ('I', 'B')
1171: and B.LANGUAGE = userenv('LANG')
1172: and not exists
1173: (select NULL
1174: from FND_CONCURRENT_PROGRAMS_TL T
1175: where T.APPLICATION_ID = B.APPLICATION_ID
1176: and T.CONCURRENT_PROGRAM_ID = B.CONCURRENT_PROGRAM_ID
1177: and T.LANGUAGE = L.LANGUAGE_CODE);
1178: end ADD_LANGUAGE;

Line 1182: end FND_CONCURRENT_PROGRAMS_PKG;

1178: end ADD_LANGUAGE;
1179:
1180:
1181:
1182: end FND_CONCURRENT_PROGRAMS_PKG;