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.

[Home] [Help]

APPS.ZPB_SOLVE dependencies on FND_GLOBAL

Line 69: fnd_global.USER_ID,

65: HIERARCHY,
66: SELECTION_NAME,
67: SELECTION_PATH,
68: 'Y',
69: fnd_global.USER_ID,
70: SYSDATE,
71: fnd_global.USER_ID,
72: SYSDATE,
73: fnd_global.LOGIN_ID

Line 71: fnd_global.USER_ID,

67: SELECTION_PATH,
68: 'Y',
69: fnd_global.USER_ID,
70: SYSDATE,
71: fnd_global.USER_ID,
72: SYSDATE,
73: fnd_global.LOGIN_ID
74: FROM ZPB_SOLVE_INPUT_SELECTIONS
75: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;

Line 73: fnd_global.LOGIN_ID

69: fnd_global.USER_ID,
70: SYSDATE,
71: fnd_global.USER_ID,
72: SYSDATE,
73: fnd_global.LOGIN_ID
74: FROM ZPB_SOLVE_INPUT_SELECTIONS
75: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
76:
77: END LOOP;

Line 158: fnd_global.USER_ID,

154: FORCE_INPUT_FLAG,
155: SUM_SELECTION_NAME,
156: SUM_SELECTION_PATH,
157: 'Y',
158: fnd_global.USER_ID,
159: SYSDATE,
160: fnd_global.USER_ID,
161: SYSDATE,
162: fnd_global.LOGIN_ID

Line 160: fnd_global.USER_ID,

156: SUM_SELECTION_PATH,
157: 'Y',
158: fnd_global.USER_ID,
159: SYSDATE,
160: fnd_global.USER_ID,
161: SYSDATE,
162: fnd_global.LOGIN_ID
163: FROM ZPB_LINE_DIMENSIONALITY
164: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;

Line 162: fnd_global.LOGIN_ID

158: fnd_global.USER_ID,
159: SYSDATE,
160: fnd_global.USER_ID,
161: SYSDATE,
162: fnd_global.LOGIN_ID
163: FROM ZPB_LINE_DIMENSIONALITY
164: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
165:
166: ELSE

Line 175: LAST_UPDATED_BY = fnd_global.USER_ID,

171: FORCE_INPUT_FLAG = dimRec.FORCE_INPUT_FLAG,
172: SUM_SELECTION_NAME = dimRec.SUM_SELECTION_NAME,
173: SUM_SELECTION_PATH = dimRec.SUM_SELECTION_PATH,
174: PROPAGATED_FLAG = 'Y',
175: LAST_UPDATED_BY = fnd_global.USER_ID,
176: LAST_UPDATE_DATE = SYSDATE,
177: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
178: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = propagateList(p_to_index) AND
179: DIMENSION =dimRec.DIMENSION;

Line 177: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

173: SUM_SELECTION_PATH = dimRec.SUM_SELECTION_PATH,
174: PROPAGATED_FLAG = 'Y',
175: LAST_UPDATED_BY = fnd_global.USER_ID,
176: LAST_UPDATE_DATE = SYSDATE,
177: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
178: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = propagateList(p_to_index) AND
179: DIMENSION =dimRec.DIMENSION;
180: END IF;
181: END LOOP;

Line 245: fnd_global.USER_ID,

241: HIERARCHY,
242: SELECTION_NAME,
243: SELECTION_PATH,
244: 'Y',
245: fnd_global.USER_ID,
246: SYSDATE,
247: fnd_global.USER_ID,
248: SYSDATE,
249: fnd_global.LOGIN_ID

Line 247: fnd_global.USER_ID,

243: SELECTION_PATH,
244: 'Y',
245: fnd_global.USER_ID,
246: SYSDATE,
247: fnd_global.USER_ID,
248: SYSDATE,
249: fnd_global.LOGIN_ID
250: FROM ZPB_SOLVE_INPUT_SELECTIONS
251: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;

Line 249: fnd_global.LOGIN_ID

245: fnd_global.USER_ID,
246: SYSDATE,
247: fnd_global.USER_ID,
248: SYSDATE,
249: fnd_global.LOGIN_ID
250: FROM ZPB_SOLVE_INPUT_SELECTIONS
251: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
252: ELSE
253: FOR ipRec IN c1 LOOP

Line 259: LAST_UPDATED_BY = fnd_global.USER_ID,

255: SET
256: SELECTION_NAME = ipRec.SELECTION_NAME,
257: SELECTION_PATH = ipRec.SELECTION_PATH,
258: PROPAGATED_FLAG = 'Y',
259: LAST_UPDATED_BY = fnd_global.USER_ID,
260: LAST_UPDATE_DATE = SYSDATE,
261: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
262: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = propagateList(p_to_index) AND
263: DIMENSION =ipRec.DIMENSION AND HIERARCHY = ipRec.HIERARCHY;

Line 261: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

257: SELECTION_PATH = ipRec.SELECTION_PATH,
258: PROPAGATED_FLAG = 'Y',
259: LAST_UPDATED_BY = fnd_global.USER_ID,
260: LAST_UPDATE_DATE = SYSDATE,
261: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
262: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = propagateList(p_to_index) AND
263: DIMENSION =ipRec.DIMENSION AND HIERARCHY = ipRec.HIERARCHY;
264: END LOOP;
265: END IF;

Line 325: fnd_global.USER_ID,

321: SELECTION_NAME,
322: SELECTION_PATH,
323: 'Y',
324: MATCH_INPUT_FLAG,
325: fnd_global.USER_ID,
326: SYSDATE,
327: fnd_global.USER_ID,
328: SYSDATE,
329: fnd_global.LOGIN_ID

Line 327: fnd_global.USER_ID,

323: 'Y',
324: MATCH_INPUT_FLAG,
325: fnd_global.USER_ID,
326: SYSDATE,
327: fnd_global.USER_ID,
328: SYSDATE,
329: fnd_global.LOGIN_ID
330: FROM ZPB_SOLVE_OUTPUT_SELECTIONS
331: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;

Line 329: fnd_global.LOGIN_ID

325: fnd_global.USER_ID,
326: SYSDATE,
327: fnd_global.USER_ID,
328: SYSDATE,
329: fnd_global.LOGIN_ID
330: FROM ZPB_SOLVE_OUTPUT_SELECTIONS
331: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
332: ELSIF p_dimensionality_flag = 'COPY' THEN
333: FOR opRec IN c1 LOOP

Line 339: LAST_UPDATED_BY = fnd_global.USER_ID,

335: SET
336: SELECTION_NAME = opRec.SELECTION_NAME,
337: SELECTION_PATH = opRec.SELECTION_PATH,
338: PROPAGATED_FLAG = 'Y',
339: LAST_UPDATED_BY = fnd_global.USER_ID,
340: LAST_UPDATE_DATE = SYSDATE,
341: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
342: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = propagateList(p_to_index) AND
343: DIMENSION =opRec.DIMENSION AND HIERARCHY = opRec.HIERARCHY;

Line 341: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

337: SELECTION_PATH = opRec.SELECTION_PATH,
338: PROPAGATED_FLAG = 'Y',
339: LAST_UPDATED_BY = fnd_global.USER_ID,
340: LAST_UPDATE_DATE = SYSDATE,
341: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
342: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = propagateList(p_to_index) AND
343: DIMENSION =opRec.DIMENSION AND HIERARCHY = opRec.HIERARCHY;
344: END LOOP;
345: END IF;

Line 368: LAST_UPDATED_BY = fnd_global.USER_ID,

364: CALC_TYPE = NULL,
365: CALC_DESCRIPTION = NULL,
366: CALC_PARAMETERS = NULL,
367: MODEL_EQUATION = NULL,
368: LAST_UPDATED_BY = fnd_global.USER_ID,
369: LAST_UPDATE_DATE = SYSDATE,
370: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
371: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_to_member;
372: END removeCalcObjectInfo;

Line 370: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

366: CALC_PARAMETERS = NULL,
367: MODEL_EQUATION = NULL,
368: LAST_UPDATED_BY = fnd_global.USER_ID,
369: LAST_UPDATE_DATE = SYSDATE,
370: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
371: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_to_member;
372: END removeCalcObjectInfo;
373:
374: PROCEDURE deleteInializedInputSettings(p_ac_id IN ZPB_DATA_INITIALIZATION_DEFS.ANALYSIS_CYCLE_ID%TYPE,

Line 445: fnd_global.USER_ID,

441: PERCENTAGE_FLAG,
442: QUERY_PATH,
443: source_query_name,
444: target_query_name,
445: fnd_global.USER_ID,
446: SYSDATE,
447: fnd_global.USER_ID,
448: SYSDATE,
449: fnd_global.LOGIN_ID,

Line 447: fnd_global.USER_ID,

443: source_query_name,
444: target_query_name,
445: fnd_global.USER_ID,
446: SYSDATE,
447: fnd_global.USER_ID,
448: SYSDATE,
449: fnd_global.LOGIN_ID,
450: PROPAGATED_FLAG
451: FROM ZPB_DATA_INITIALIZATION_DEFS

Line 449: fnd_global.LOGIN_ID,

445: fnd_global.USER_ID,
446: SYSDATE,
447: fnd_global.USER_ID,
448: SYSDATE,
449: fnd_global.LOGIN_ID,
450: PROPAGATED_FLAG
451: FROM ZPB_DATA_INITIALIZATION_DEFS
452: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
453:

Line 470: fnd_global.USER_ID,

466: SELECT DIM,
467: ANALYSIS_CYCLE_ID,
468: SOURCE_NUM_MEMBERS,
469: TARGET_NUM_MEMBERS,
470: fnd_global.USER_ID,
471: SYSDATE,
472: fnd_global.USER_ID,
473: SYSDATE,
474: fnd_global.LOGIN_ID,

Line 472: fnd_global.USER_ID,

468: SOURCE_NUM_MEMBERS,
469: TARGET_NUM_MEMBERS,
470: fnd_global.USER_ID,
471: SYSDATE,
472: fnd_global.USER_ID,
473: SYSDATE,
474: fnd_global.LOGIN_ID,
475: SAME_SELECTION,
476: p_to_member

Line 474: fnd_global.LOGIN_ID,

470: fnd_global.USER_ID,
471: SYSDATE,
472: fnd_global.USER_ID,
473: SYSDATE,
474: fnd_global.LOGIN_ID,
475: SAME_SELECTION,
476: p_to_member
477: FROM zpb_copy_dim_members
478: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND LINE_MEMBER_ID = p_from_member;

Line 576: LAST_UPDATED_BY = fnd_global.USER_ID,

572: --Bug#5092815, changed into bulk operation
573: FORALL i IN propagateList.FIRST..propagateList.LAST
574: UPDATE ZPB_SOLVE_MEMBER_DEFS
575: SET SOURCE_TYPE = fromSource,
576: LAST_UPDATED_BY = fnd_global.USER_ID,
577: LAST_UPDATE_DATE = SYSDATE,
578: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
579: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = propagateList(i);
580:

Line 578: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

574: UPDATE ZPB_SOLVE_MEMBER_DEFS
575: SET SOURCE_TYPE = fromSource,
576: LAST_UPDATED_BY = fnd_global.USER_ID,
577: LAST_UPDATE_DATE = SYSDATE,
578: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
579: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = propagateList(i);
580:
581: --Bug#5092815, mark the source line as propagated, so that
582: --the same settings can be copied to target line

Line 597: LAST_UPDATED_BY = fnd_global.USER_ID,

593: LOOP
594: UPDATE ZPB_SOLVE_MEMBER_DEFS
595: SET
596: SOURCE_TYPE = fromSource,
597: LAST_UPDATED_BY = fnd_global.USER_ID,
598: LAST_UPDATE_DATE = SYSDATE,
599: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
600: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = propagateList(i);
601: END LOOP;

Line 599: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

595: SET
596: SOURCE_TYPE = fromSource,
597: LAST_UPDATED_BY = fnd_global.USER_ID,
598: LAST_UPDATE_DATE = SYSDATE,
599: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
600: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = propagateList(i);
601: END LOOP;
602:
603: FOR i IN propagateList.FIRST..propagateList.LAST

Line 748: LAST_UPDATED_BY = fnd_global.USER_ID,

744: CALC_TYPE = l_calcType,
745: CALC_DESCRIPTION = l_calcDesc,
746: CALC_PARAMETERS = l_calcParams,
747: MODEL_EQUATION = l_modelEquation,
748: LAST_UPDATED_BY = fnd_global.USER_ID,
749: LAST_UPDATE_DATE = SYSDATE,
750: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
751: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = propagateList(i);
752:

Line 750: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

746: CALC_PARAMETERS = l_calcParams,
747: MODEL_EQUATION = l_modelEquation,
748: LAST_UPDATED_BY = fnd_global.USER_ID,
749: LAST_UPDATE_DATE = SYSDATE,
750: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
751: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = propagateList(i);
752:
753: END IF;
754:

Line 795: BASIS, QUALIFIER, fnd_global.USER_ID, SYSDATE,

791: LAST_UPDATE_DATE,
792: LAST_UPDATE_LOGIN)
793: SELECT ANALYSIS_CYCLE_ID, propagateList(i), propagateOrder(i), RULE_NAME,
794: METHOD, EVALUATION_OPTION, ROUND_DECIMALS, ROUND_ENABLED,
795: BASIS, QUALIFIER, fnd_global.USER_ID, SYSDATE,
796:
797: fnd_global.USER_ID, SYSDATE, fnd_global.LOGIN_ID
798: FROM ZPB_SOLVE_ALLOCATION_DEFS
799: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;

Line 797: fnd_global.USER_ID, SYSDATE, fnd_global.LOGIN_ID

793: SELECT ANALYSIS_CYCLE_ID, propagateList(i), propagateOrder(i), RULE_NAME,
794: METHOD, EVALUATION_OPTION, ROUND_DECIMALS, ROUND_ENABLED,
795: BASIS, QUALIFIER, fnd_global.USER_ID, SYSDATE,
796:
797: fnd_global.USER_ID, SYSDATE, fnd_global.LOGIN_ID
798: FROM ZPB_SOLVE_ALLOCATION_DEFS
799: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
800: END propagateAlloc;
801:

Line 867: fnd_global.USER_ID,

863: opRec.SELECTION_NAME,
864: opRec.SELECTION_PATH,
865: 'Y',
866: opRec.MATCH_INPUT_FLAG,
867: fnd_global.USER_ID,
868: SYSDATE,
869: fnd_global.USER_ID,
870: SYSDATE,
871: fnd_global.LOGIN_ID);

Line 869: fnd_global.USER_ID,

865: 'Y',
866: opRec.MATCH_INPUT_FLAG,
867: fnd_global.USER_ID,
868: SYSDATE,
869: fnd_global.USER_ID,
870: SYSDATE,
871: fnd_global.LOGIN_ID);
872: END LOOP;
873:

Line 871: fnd_global.LOGIN_ID);

867: fnd_global.USER_ID,
868: SYSDATE,
869: fnd_global.USER_ID,
870: SYSDATE,
871: fnd_global.LOGIN_ID);
872: END LOOP;
873:
874:
875:

Line 915: fnd_global.USER_ID,

911: opRec.SELECTION_NAME,
912: opRec.SELECTION_PATH,
913: 'Y',
914: opRec.MATCH_INPUT_FLAG,
915: fnd_global.USER_ID,
916: SYSDATE,
917: fnd_global.USER_ID,
918: SYSDATE,
919: fnd_global.LOGIN_ID);

Line 917: fnd_global.USER_ID,

913: 'Y',
914: opRec.MATCH_INPUT_FLAG,
915: fnd_global.USER_ID,
916: SYSDATE,
917: fnd_global.USER_ID,
918: SYSDATE,
919: fnd_global.LOGIN_ID);
920: end if;
921: END LOOP;

Line 919: fnd_global.LOGIN_ID);

915: fnd_global.USER_ID,
916: SYSDATE,
917: fnd_global.USER_ID,
918: SYSDATE,
919: fnd_global.LOGIN_ID);
920: end if;
921: END LOOP;
922:
923:

Line 955: fnd_global.USER_ID,

951: opRec.SELECTION_NAME,
952: opRec.SELECTION_PATH,
953: 'Y',
954: opRec.MATCH_INPUT_FLAG,
955: fnd_global.USER_ID,
956: SYSDATE,
957: fnd_global.USER_ID,
958: SYSDATE,
959: fnd_global.LOGIN_ID);

Line 957: fnd_global.USER_ID,

953: 'Y',
954: opRec.MATCH_INPUT_FLAG,
955: fnd_global.USER_ID,
956: SYSDATE,
957: fnd_global.USER_ID,
958: SYSDATE,
959: fnd_global.LOGIN_ID);
960: END LOOP;
961:

Line 959: fnd_global.LOGIN_ID);

955: fnd_global.USER_ID,
956: SYSDATE,
957: fnd_global.USER_ID,
958: SYSDATE,
959: fnd_global.LOGIN_ID);
960: END LOOP;
961:
962: End if;
963:

Line 1037: fnd_global.USER_ID,

1033: dimRec.FORCE_INPUT_FLAG,
1034: dimRec.SUM_SELECTION_NAME,
1035: dimRec.SUM_SELECTION_PATH,
1036: 'Y',
1037: fnd_global.USER_ID,
1038: SYSDATE,
1039: fnd_global.USER_ID,
1040: SYSDATE,
1041: fnd_global.LOGIN_ID);

Line 1039: fnd_global.USER_ID,

1035: dimRec.SUM_SELECTION_PATH,
1036: 'Y',
1037: fnd_global.USER_ID,
1038: SYSDATE,
1039: fnd_global.USER_ID,
1040: SYSDATE,
1041: fnd_global.LOGIN_ID);
1042: END LOOP;
1043: END IF;

Line 1041: fnd_global.LOGIN_ID);

1037: fnd_global.USER_ID,
1038: SYSDATE,
1039: fnd_global.USER_ID,
1040: SYSDATE,
1041: fnd_global.LOGIN_ID);
1042: END LOOP;
1043: END IF;
1044: END LOOP;
1045: END IF;

Line 1125: LAST_UPDATED_BY = fnd_global.USER_ID,

1121: END IF;
1122: --reset propagate flag
1123: UPDATE ZPB_SOLVE_MEMBER_DEFS
1124: SET PROPAGATE_TARGET = iFalseValue,
1125: LAST_UPDATED_BY = fnd_global.USER_ID,
1126: LAST_UPDATE_DATE = SYSDATE,
1127: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1128: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND PROPAGATE_TARGET = iTrueValue;
1129: END propagateSolve;

Line 1127: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

1123: UPDATE ZPB_SOLVE_MEMBER_DEFS
1124: SET PROPAGATE_TARGET = iFalseValue,
1125: LAST_UPDATED_BY = fnd_global.USER_ID,
1126: LAST_UPDATE_DATE = SYSDATE,
1127: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1128: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND PROPAGATE_TARGET = iTrueValue;
1129: END propagateSolve;
1130:
1131:

Line 1223: fnd_global.USER_ID,

1219: 'NONE',
1220: 'DEFAULT',
1221: 'N',
1222: 'N',
1223: fnd_global.USER_ID,
1224: SYSDATE,
1225: fnd_global.USER_ID,
1226: SYSDATE,
1227: fnd_global.LOGIN_ID);

Line 1225: fnd_global.USER_ID,

1221: 'N',
1222: 'N',
1223: fnd_global.USER_ID,
1224: SYSDATE,
1225: fnd_global.USER_ID,
1226: SYSDATE,
1227: fnd_global.LOGIN_ID);
1228:
1229:

Line 1227: fnd_global.LOGIN_ID);

1223: fnd_global.USER_ID,
1224: SYSDATE,
1225: fnd_global.USER_ID,
1226: SYSDATE,
1227: fnd_global.LOGIN_ID);
1228:
1229:
1230: END insertDefaultOutput;
1231:

Line 1348: last_updated_by = FND_GLOBAL.USER_ID,

1344: set selection_name = 'DEFAULT',
1345: selection_path = null,
1346: hierarchy = l_new_hier,
1347: last_update_date = sysdate,
1348: last_updated_by = FND_GLOBAL.USER_ID,
1349: last_update_login = FND_GLOBAL.LOGIN_ID
1350: where analysis_cycle_id = p_ac_id
1351: and dimension = each.dimension
1352: and hierarchy = each.hierarchy;

Line 1349: last_update_login = FND_GLOBAL.LOGIN_ID

1345: selection_path = null,
1346: hierarchy = l_new_hier,
1347: last_update_date = sysdate,
1348: last_updated_by = FND_GLOBAL.USER_ID,
1349: last_update_login = FND_GLOBAL.LOGIN_ID
1350: where analysis_cycle_id = p_ac_id
1351: and dimension = each.dimension
1352: and hierarchy = each.hierarchy;
1353: else

Line 1378: last_updated_by = FND_GLOBAL.USER_ID,

1374: set hierarchy = 'NONE',
1375: selection_path = null,
1376: selection_name = 'DEFAULT',
1377: last_update_date = sysdate,
1378: last_updated_by = FND_GLOBAL.USER_ID,
1379: last_update_login = FND_GLOBAL.LOGIN_ID
1380: where analysis_cycle_id = p_ac_id
1381: and dimension = each.dimension
1382: and hierarchy = each.hierarchy;

Line 1379: last_update_login = FND_GLOBAL.LOGIN_ID

1375: selection_path = null,
1376: selection_name = 'DEFAULT',
1377: last_update_date = sysdate,
1378: last_updated_by = FND_GLOBAL.USER_ID,
1379: last_update_login = FND_GLOBAL.LOGIN_ID
1380: where analysis_cycle_id = p_ac_id
1381: and dimension = each.dimension
1382: and hierarchy = each.hierarchy;
1383: end if;

Line 1456: last_updated_by = FND_GLOBAL.USER_ID,

1452: set selection_name = 'DEFAULT',
1453: selection_path = null,
1454: hierarchy = l_new_hier,
1455: last_update_date = sysdate,
1456: last_updated_by = FND_GLOBAL.USER_ID,
1457: last_update_login = FND_GLOBAL.LOGIN_ID
1458: where analysis_cycle_id = p_ac_id
1459: and dimension = each.dimension
1460: and hierarchy = each.hierarchy;

Line 1457: last_update_login = FND_GLOBAL.LOGIN_ID

1453: selection_path = null,
1454: hierarchy = l_new_hier,
1455: last_update_date = sysdate,
1456: last_updated_by = FND_GLOBAL.USER_ID,
1457: last_update_login = FND_GLOBAL.LOGIN_ID
1458: where analysis_cycle_id = p_ac_id
1459: and dimension = each.dimension
1460: and hierarchy = each.hierarchy;
1461: else

Line 1486: last_updated_by = FND_GLOBAL.USER_ID,

1482: set hierarchy = 'NONE',
1483: selection_path = null,
1484: selection_name = 'DEFAULT',
1485: last_update_date = sysdate,
1486: last_updated_by = FND_GLOBAL.USER_ID,
1487: last_update_login = FND_GLOBAL.LOGIN_ID
1488: where analysis_cycle_id = p_ac_id
1489: and dimension = each.dimension
1490: and hierarchy = each.hierarchy;

Line 1487: last_update_login = FND_GLOBAL.LOGIN_ID

1483: selection_path = null,
1484: selection_name = 'DEFAULT',
1485: last_update_date = sysdate,
1486: last_updated_by = FND_GLOBAL.USER_ID,
1487: last_update_login = FND_GLOBAL.LOGIN_ID
1488: where analysis_cycle_id = p_ac_id
1489: and dimension = each.dimension
1490: and hierarchy = each.hierarchy;
1491: end if;

Line 1514: l_userid number := fnd_global.USER_ID;

1510:
1511: attached varchar2(1) := 'N';
1512: l_dbname varchar2(150);
1513: l_count number;
1514: l_userid number := fnd_global.USER_ID;
1515: l_taskid number;
1516:
1517:
1518: BEGIN