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.GMD_EBI_RECIPE_PUB dependencies on FND_GLOBAL

Line 326: l_routings_insert.CREATED_BY := Nvl(p_routing_obj.CREATED_BY,FND_GLOBAL.USER_ID);

322: l_routings_insert.TEXT_CODE := p_routing_obj.TEXT_CODE;
323: l_routings_insert.INACTIVE_IND := p_routing_obj.INACTIVE_IND ;
324: l_routings_insert.IN_USE := p_routing_obj.IN_USE;
325: l_routings_insert.CREATION_DATE := Nvl(p_routing_obj.CREATION_DATE,SYSDATE);
326: l_routings_insert.CREATED_BY := Nvl(p_routing_obj.CREATED_BY,FND_GLOBAL.USER_ID);
327: l_routings_insert.LAST_UPDATE_LOGIN := Nvl(p_routing_obj.LAST_UPDATE_LOGIN ,FND_GLOBAL.USER_ID);
328: l_routings_insert.LAST_UPDATE_DATE := Nvl(p_routing_obj.LAST_UPDATE_DATE,SYSDATE);
329: l_routings_insert.LAST_UPDATED_BY := Nvl(p_routing_obj.LAST_UPDATED_BY,FND_GLOBAL.USER_ID);
330: l_routings_insert.ATTRIBUTE_CATEGORY :=p_routing_obj.flex_obj.ATTRIBUTE_CATEGORY;

Line 327: l_routings_insert.LAST_UPDATE_LOGIN := Nvl(p_routing_obj.LAST_UPDATE_LOGIN ,FND_GLOBAL.USER_ID);

323: l_routings_insert.INACTIVE_IND := p_routing_obj.INACTIVE_IND ;
324: l_routings_insert.IN_USE := p_routing_obj.IN_USE;
325: l_routings_insert.CREATION_DATE := Nvl(p_routing_obj.CREATION_DATE,SYSDATE);
326: l_routings_insert.CREATED_BY := Nvl(p_routing_obj.CREATED_BY,FND_GLOBAL.USER_ID);
327: l_routings_insert.LAST_UPDATE_LOGIN := Nvl(p_routing_obj.LAST_UPDATE_LOGIN ,FND_GLOBAL.USER_ID);
328: l_routings_insert.LAST_UPDATE_DATE := Nvl(p_routing_obj.LAST_UPDATE_DATE,SYSDATE);
329: l_routings_insert.LAST_UPDATED_BY := Nvl(p_routing_obj.LAST_UPDATED_BY,FND_GLOBAL.USER_ID);
330: l_routings_insert.ATTRIBUTE_CATEGORY :=p_routing_obj.flex_obj.ATTRIBUTE_CATEGORY;
331: l_routings_insert.ATTRIBUTE_CATEGORY:=p_routing_obj.flex_obj.ATTRIBUTE_CATEGORY;

Line 329: l_routings_insert.LAST_UPDATED_BY := Nvl(p_routing_obj.LAST_UPDATED_BY,FND_GLOBAL.USER_ID);

325: l_routings_insert.CREATION_DATE := Nvl(p_routing_obj.CREATION_DATE,SYSDATE);
326: l_routings_insert.CREATED_BY := Nvl(p_routing_obj.CREATED_BY,FND_GLOBAL.USER_ID);
327: l_routings_insert.LAST_UPDATE_LOGIN := Nvl(p_routing_obj.LAST_UPDATE_LOGIN ,FND_GLOBAL.USER_ID);
328: l_routings_insert.LAST_UPDATE_DATE := Nvl(p_routing_obj.LAST_UPDATE_DATE,SYSDATE);
329: l_routings_insert.LAST_UPDATED_BY := Nvl(p_routing_obj.LAST_UPDATED_BY,FND_GLOBAL.USER_ID);
330: l_routings_insert.ATTRIBUTE_CATEGORY :=p_routing_obj.flex_obj.ATTRIBUTE_CATEGORY;
331: l_routings_insert.ATTRIBUTE_CATEGORY:=p_routing_obj.flex_obj.ATTRIBUTE_CATEGORY;
332: l_routings_insert.ATTRIBUTE1:=p_routing_obj.flex_obj.ATTRIBUTE1;
333: l_routings_insert.ATTRIBUTE2:=p_routing_obj.flex_obj.ATTRIBUTE2;

Line 364: l_routings_insert.OWNER_ID := Nvl(p_routing_obj.OWNER_ID,FND_GLOBAL.USER_ID);

360: l_routings_insert.ATTRIBUTE29:=p_routing_obj.flex_obj.ATTRIBUTE29;
361: l_routings_insert.ATTRIBUTE30:=p_routing_obj.flex_obj.ATTRIBUTE30;
362: l_routings_insert.EFFECTIVE_START_DATE := p_routing_obj.EFFECTIVE_START_DATE;
363: l_routings_insert.EFFECTIVE_END_DATE := p_routing_obj.EFFECTIVE_END_DATE;
364: l_routings_insert.OWNER_ID := Nvl(p_routing_obj.OWNER_ID,FND_GLOBAL.USER_ID);
365: l_routings_insert.PROJECT_ID := p_routing_obj.PROJECT_ID ;
366: l_routings_insert.PROCESS_LOSS := p_routing_obj.PROCESS_LOSS ;
367: FOR j IN 1..p_routing_obj.gmd_ebi_routing_steps.Count LOOP
368: l_routings_step_rec.X_COORDINATE:=p_routing_obj.gmd_ebi_routing_steps(j).X_COORDINATE;

Line 378: l_routings_step_rec.LAST_UPDATED_BY:=Nvl(p_routing_obj.gmd_ebi_routing_steps(j).LAST_UPDATED_BY,FND_GLOBAL.USER_ID);

374: l_routings_step_rec.OPRN_ID:=p_routing_obj.gmd_ebi_routing_steps(j).OPRN_ID;
375: l_routings_step_rec.STEP_QTY:=p_routing_obj.gmd_ebi_routing_steps(j).STEP_QTY;
376: l_routings_step_rec.STEPRELEASE_TYPE:=p_routing_obj.gmd_ebi_routing_steps(j).STEPRELEASE_TYPE;
377: l_routings_step_rec.TEXT_CODE:=p_routing_obj.gmd_ebi_routing_steps(j).TEXT_CODE;
378: l_routings_step_rec.LAST_UPDATED_BY:=Nvl(p_routing_obj.gmd_ebi_routing_steps(j).LAST_UPDATED_BY,FND_GLOBAL.USER_ID);
379: l_routings_step_rec.CREATED_BY:=Nvl(p_routing_obj.gmd_ebi_routing_steps(j).CREATED_BY,FND_GLOBAL.USER_ID);
380: l_routings_step_rec.LAST_UPDATE_DATE:=Nvl(p_routing_obj.gmd_ebi_routing_steps(j).LAST_UPDATE_DATE,SYSDATE);
381: l_routings_step_rec.CREATION_DATE:=Nvl(p_routing_obj.gmd_ebi_routing_steps(j).CREATION_DATE,SYSDATE);
382: l_routings_step_rec.LAST_UPDATE_LOGIN:=Nvl(p_routing_obj.gmd_ebi_routing_steps(j).LAST_UPDATE_LOGIN,FND_GLOBAL.USER_ID);

Line 379: l_routings_step_rec.CREATED_BY:=Nvl(p_routing_obj.gmd_ebi_routing_steps(j).CREATED_BY,FND_GLOBAL.USER_ID);

375: l_routings_step_rec.STEP_QTY:=p_routing_obj.gmd_ebi_routing_steps(j).STEP_QTY;
376: l_routings_step_rec.STEPRELEASE_TYPE:=p_routing_obj.gmd_ebi_routing_steps(j).STEPRELEASE_TYPE;
377: l_routings_step_rec.TEXT_CODE:=p_routing_obj.gmd_ebi_routing_steps(j).TEXT_CODE;
378: l_routings_step_rec.LAST_UPDATED_BY:=Nvl(p_routing_obj.gmd_ebi_routing_steps(j).LAST_UPDATED_BY,FND_GLOBAL.USER_ID);
379: l_routings_step_rec.CREATED_BY:=Nvl(p_routing_obj.gmd_ebi_routing_steps(j).CREATED_BY,FND_GLOBAL.USER_ID);
380: l_routings_step_rec.LAST_UPDATE_DATE:=Nvl(p_routing_obj.gmd_ebi_routing_steps(j).LAST_UPDATE_DATE,SYSDATE);
381: l_routings_step_rec.CREATION_DATE:=Nvl(p_routing_obj.gmd_ebi_routing_steps(j).CREATION_DATE,SYSDATE);
382: l_routings_step_rec.LAST_UPDATE_LOGIN:=Nvl(p_routing_obj.gmd_ebi_routing_steps(j).LAST_UPDATE_LOGIN,FND_GLOBAL.USER_ID);
383: l_routings_step_rec.ATTRIBUTE1:=p_routing_obj.gmd_ebi_routing_steps(j).flex_obj.ATTRIBUTE1;

Line 382: l_routings_step_rec.LAST_UPDATE_LOGIN:=Nvl(p_routing_obj.gmd_ebi_routing_steps(j).LAST_UPDATE_LOGIN,FND_GLOBAL.USER_ID);

378: l_routings_step_rec.LAST_UPDATED_BY:=Nvl(p_routing_obj.gmd_ebi_routing_steps(j).LAST_UPDATED_BY,FND_GLOBAL.USER_ID);
379: l_routings_step_rec.CREATED_BY:=Nvl(p_routing_obj.gmd_ebi_routing_steps(j).CREATED_BY,FND_GLOBAL.USER_ID);
380: l_routings_step_rec.LAST_UPDATE_DATE:=Nvl(p_routing_obj.gmd_ebi_routing_steps(j).LAST_UPDATE_DATE,SYSDATE);
381: l_routings_step_rec.CREATION_DATE:=Nvl(p_routing_obj.gmd_ebi_routing_steps(j).CREATION_DATE,SYSDATE);
382: l_routings_step_rec.LAST_UPDATE_LOGIN:=Nvl(p_routing_obj.gmd_ebi_routing_steps(j).LAST_UPDATE_LOGIN,FND_GLOBAL.USER_ID);
383: l_routings_step_rec.ATTRIBUTE1:=p_routing_obj.gmd_ebi_routing_steps(j).flex_obj.ATTRIBUTE1;
384: l_routings_step_rec.ATTRIBUTE2:=p_routing_obj.gmd_ebi_routing_steps(j).flex_obj.ATTRIBUTE2;
385: l_routings_step_rec.ATTRIBUTE3:=p_routing_obj.gmd_ebi_routing_steps(j).flex_obj.ATTRIBUTE3;
386: l_routings_step_rec.ATTRIBUTE4:=p_routing_obj.gmd_ebi_routing_steps(j).flex_obj.ATTRIBUTE4;

Line 430: l_routings_step_dep_rec.LAST_UPDATED_BY := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATED_BY,FND_GLOBAL.USER_ID);

426: l_routings_step_dep_rec.MAX_DELAY := p_routing_obj.gmd_ebi_rtg_step_dependency(i).MAX_DELAY;
427: l_routings_step_dep_rec.TRANSFER_QTY := p_routing_obj.gmd_ebi_rtg_step_dependency(i).TRANSFER_QTY;
428: l_routings_step_dep_rec.ITEM_UM := p_routing_obj.gmd_ebi_rtg_step_dependency(i).ITEM_UM;
429: l_routings_step_dep_rec.TEXT_CODE := p_routing_obj.gmd_ebi_rtg_step_dependency(i).TEXT_CODE;
430: l_routings_step_dep_rec.LAST_UPDATED_BY := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATED_BY,FND_GLOBAL.USER_ID);
431: l_routings_step_dep_rec.CREATED_BY := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).CREATED_BY,FND_GLOBAL.USER_ID);
432: l_routings_step_dep_rec.LAST_UPDATE_DATE := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATE_DATE,SYSDATE);
433: l_routings_step_dep_rec.CREATION_DATE := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).CREATION_DATE,SYSDATE);
434: l_routings_step_dep_rec.LAST_UPDATE_LOGIN := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATE_LOGIN,FND_GLOBAL.USER_ID);

Line 431: l_routings_step_dep_rec.CREATED_BY := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).CREATED_BY,FND_GLOBAL.USER_ID);

427: l_routings_step_dep_rec.TRANSFER_QTY := p_routing_obj.gmd_ebi_rtg_step_dependency(i).TRANSFER_QTY;
428: l_routings_step_dep_rec.ITEM_UM := p_routing_obj.gmd_ebi_rtg_step_dependency(i).ITEM_UM;
429: l_routings_step_dep_rec.TEXT_CODE := p_routing_obj.gmd_ebi_rtg_step_dependency(i).TEXT_CODE;
430: l_routings_step_dep_rec.LAST_UPDATED_BY := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATED_BY,FND_GLOBAL.USER_ID);
431: l_routings_step_dep_rec.CREATED_BY := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).CREATED_BY,FND_GLOBAL.USER_ID);
432: l_routings_step_dep_rec.LAST_UPDATE_DATE := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATE_DATE,SYSDATE);
433: l_routings_step_dep_rec.CREATION_DATE := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).CREATION_DATE,SYSDATE);
434: l_routings_step_dep_rec.LAST_UPDATE_LOGIN := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATE_LOGIN,FND_GLOBAL.USER_ID);
435: l_routings_step_dep_rec.TRANSFER_PCT := p_routing_obj.gmd_ebi_rtg_step_dependency(i).TRANSFER_PCT;

Line 434: l_routings_step_dep_rec.LAST_UPDATE_LOGIN := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATE_LOGIN,FND_GLOBAL.USER_ID);

430: l_routings_step_dep_rec.LAST_UPDATED_BY := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATED_BY,FND_GLOBAL.USER_ID);
431: l_routings_step_dep_rec.CREATED_BY := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).CREATED_BY,FND_GLOBAL.USER_ID);
432: l_routings_step_dep_rec.LAST_UPDATE_DATE := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATE_DATE,SYSDATE);
433: l_routings_step_dep_rec.CREATION_DATE := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).CREATION_DATE,SYSDATE);
434: l_routings_step_dep_rec.LAST_UPDATE_LOGIN := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATE_LOGIN,FND_GLOBAL.USER_ID);
435: l_routings_step_dep_rec.TRANSFER_PCT := p_routing_obj.gmd_ebi_rtg_step_dependency(i).TRANSFER_PCT;
436: l_routings_step_dep_tbl_insert(l_routings_step_dep_insert_ctr) := l_routings_step_dep_rec;
437: l_routings_step_dep_insert_ctr := l_routings_step_dep_insert_ctr + 1;
438: END LOOP;

Line 532: l_rout_rec.p_value := Nvl(p_routing_obj.owner_id,FND_GLOBAL.USER_ID);

528: l_rout_rec.p_col_to_update := 'effective_end_date';
529: l_rout_rec.p_value := p_routing_obj.effective_end_date;
530: l_rout_tbl(25) := l_rout_rec;
531: l_rout_rec.p_col_to_update := 'owner_id';
532: l_rout_rec.p_value := Nvl(p_routing_obj.owner_id,FND_GLOBAL.USER_ID);
533: l_rout_tbl(26) := l_rout_rec;
534: l_rout_rec.p_col_to_update := 'project_id';
535: l_rout_rec.p_value := p_routing_obj.project_id;
536: l_rout_tbl(27) := l_rout_rec;

Line 663: l_routings_step_rec.LAST_UPDATED_BY:=Nvl(p_routing_obj.gmd_ebi_routing_steps(j).LAST_UPDATED_BY,FND_GLOBAL.USER_ID);

659: l_routings_step_rec.OPRN_ID:=p_routing_obj.gmd_ebi_routing_steps(j).OPRN_ID;
660: l_routings_step_rec.STEP_QTY:=p_routing_obj.gmd_ebi_routing_steps(j).STEP_QTY;
661: l_routings_step_rec.STEPRELEASE_TYPE:=p_routing_obj.gmd_ebi_routing_steps(j).STEPRELEASE_TYPE;
662: l_routings_step_rec.TEXT_CODE:=p_routing_obj.gmd_ebi_routing_steps(j).TEXT_CODE;
663: l_routings_step_rec.LAST_UPDATED_BY:=Nvl(p_routing_obj.gmd_ebi_routing_steps(j).LAST_UPDATED_BY,FND_GLOBAL.USER_ID);
664: l_routings_step_rec.CREATED_BY:=Nvl(p_routing_obj.gmd_ebi_routing_steps(j).CREATED_BY,FND_GLOBAL.USER_ID);
665: l_routings_step_rec.LAST_UPDATE_DATE:=NVL(p_routing_obj.gmd_ebi_routing_steps(j).LAST_UPDATE_DATE,SYSDATE);
666: l_routings_step_rec.CREATION_DATE:=Nvl(p_routing_obj.gmd_ebi_routing_steps(j).CREATION_DATE,SYSDATE);
667: l_routings_step_rec.LAST_UPDATE_LOGIN:=Nvl(p_routing_obj.gmd_ebi_routing_steps(j).LAST_UPDATE_LOGIN,FND_GLOBAL.USER_ID);

Line 664: l_routings_step_rec.CREATED_BY:=Nvl(p_routing_obj.gmd_ebi_routing_steps(j).CREATED_BY,FND_GLOBAL.USER_ID);

660: l_routings_step_rec.STEP_QTY:=p_routing_obj.gmd_ebi_routing_steps(j).STEP_QTY;
661: l_routings_step_rec.STEPRELEASE_TYPE:=p_routing_obj.gmd_ebi_routing_steps(j).STEPRELEASE_TYPE;
662: l_routings_step_rec.TEXT_CODE:=p_routing_obj.gmd_ebi_routing_steps(j).TEXT_CODE;
663: l_routings_step_rec.LAST_UPDATED_BY:=Nvl(p_routing_obj.gmd_ebi_routing_steps(j).LAST_UPDATED_BY,FND_GLOBAL.USER_ID);
664: l_routings_step_rec.CREATED_BY:=Nvl(p_routing_obj.gmd_ebi_routing_steps(j).CREATED_BY,FND_GLOBAL.USER_ID);
665: l_routings_step_rec.LAST_UPDATE_DATE:=NVL(p_routing_obj.gmd_ebi_routing_steps(j).LAST_UPDATE_DATE,SYSDATE);
666: l_routings_step_rec.CREATION_DATE:=Nvl(p_routing_obj.gmd_ebi_routing_steps(j).CREATION_DATE,SYSDATE);
667: l_routings_step_rec.LAST_UPDATE_LOGIN:=Nvl(p_routing_obj.gmd_ebi_routing_steps(j).LAST_UPDATE_LOGIN,FND_GLOBAL.USER_ID);
668: l_routings_step_rec.ATTRIBUTE1:=p_routing_obj.gmd_ebi_routing_steps(j).flex_obj.ATTRIBUTE1;

Line 667: l_routings_step_rec.LAST_UPDATE_LOGIN:=Nvl(p_routing_obj.gmd_ebi_routing_steps(j).LAST_UPDATE_LOGIN,FND_GLOBAL.USER_ID);

663: l_routings_step_rec.LAST_UPDATED_BY:=Nvl(p_routing_obj.gmd_ebi_routing_steps(j).LAST_UPDATED_BY,FND_GLOBAL.USER_ID);
664: l_routings_step_rec.CREATED_BY:=Nvl(p_routing_obj.gmd_ebi_routing_steps(j).CREATED_BY,FND_GLOBAL.USER_ID);
665: l_routings_step_rec.LAST_UPDATE_DATE:=NVL(p_routing_obj.gmd_ebi_routing_steps(j).LAST_UPDATE_DATE,SYSDATE);
666: l_routings_step_rec.CREATION_DATE:=Nvl(p_routing_obj.gmd_ebi_routing_steps(j).CREATION_DATE,SYSDATE);
667: l_routings_step_rec.LAST_UPDATE_LOGIN:=Nvl(p_routing_obj.gmd_ebi_routing_steps(j).LAST_UPDATE_LOGIN,FND_GLOBAL.USER_ID);
668: l_routings_step_rec.ATTRIBUTE1:=p_routing_obj.gmd_ebi_routing_steps(j).flex_obj.ATTRIBUTE1;
669: l_routings_step_rec.ATTRIBUTE2:=p_routing_obj.gmd_ebi_routing_steps(j).flex_obj.ATTRIBUTE2;
670: l_routings_step_rec.ATTRIBUTE3:=p_routing_obj.gmd_ebi_routing_steps(j).flex_obj.ATTRIBUTE3;
671: l_routings_step_rec.ATTRIBUTE4:=p_routing_obj.gmd_ebi_routing_steps(j).flex_obj.ATTRIBUTE4;

Line 719: l_routings_step_dep_rec.LAST_UPDATED_BY := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATED_BY,FND_GLOBAL.USER_ID);

715: l_routings_step_dep_rec.MAX_DELAY := p_routing_obj.gmd_ebi_rtg_step_dependency(i).MAX_DELAY;
716: l_routings_step_dep_rec.TRANSFER_QTY := p_routing_obj.gmd_ebi_rtg_step_dependency(i).TRANSFER_QTY;
717: l_routings_step_dep_rec.ITEM_UM := p_routing_obj.gmd_ebi_rtg_step_dependency(i).ITEM_UM;
718: l_routings_step_dep_rec.TEXT_CODE := p_routing_obj.gmd_ebi_rtg_step_dependency(i).TEXT_CODE;
719: l_routings_step_dep_rec.LAST_UPDATED_BY := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATED_BY,FND_GLOBAL.USER_ID);
720: l_routings_step_dep_rec.CREATED_BY := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).CREATED_BY,FND_GLOBAL.USER_ID);
721: l_routings_step_dep_rec.LAST_UPDATE_DATE := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATE_DATE,SYSDATE);
722: l_routings_step_dep_rec.CREATION_DATE := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).CREATION_DATE,SYSDATE);
723: l_routings_step_dep_rec.LAST_UPDATE_LOGIN := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATE_LOGIN,FND_GLOBAL.USER_ID);

Line 720: l_routings_step_dep_rec.CREATED_BY := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).CREATED_BY,FND_GLOBAL.USER_ID);

716: l_routings_step_dep_rec.TRANSFER_QTY := p_routing_obj.gmd_ebi_rtg_step_dependency(i).TRANSFER_QTY;
717: l_routings_step_dep_rec.ITEM_UM := p_routing_obj.gmd_ebi_rtg_step_dependency(i).ITEM_UM;
718: l_routings_step_dep_rec.TEXT_CODE := p_routing_obj.gmd_ebi_rtg_step_dependency(i).TEXT_CODE;
719: l_routings_step_dep_rec.LAST_UPDATED_BY := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATED_BY,FND_GLOBAL.USER_ID);
720: l_routings_step_dep_rec.CREATED_BY := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).CREATED_BY,FND_GLOBAL.USER_ID);
721: l_routings_step_dep_rec.LAST_UPDATE_DATE := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATE_DATE,SYSDATE);
722: l_routings_step_dep_rec.CREATION_DATE := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).CREATION_DATE,SYSDATE);
723: l_routings_step_dep_rec.LAST_UPDATE_LOGIN := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATE_LOGIN,FND_GLOBAL.USER_ID);
724: l_routings_step_dep_rec.TRANSFER_PCT := p_routing_obj.gmd_ebi_rtg_step_dependency(i).TRANSFER_PCT;

Line 723: l_routings_step_dep_rec.LAST_UPDATE_LOGIN := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATE_LOGIN,FND_GLOBAL.USER_ID);

719: l_routings_step_dep_rec.LAST_UPDATED_BY := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATED_BY,FND_GLOBAL.USER_ID);
720: l_routings_step_dep_rec.CREATED_BY := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).CREATED_BY,FND_GLOBAL.USER_ID);
721: l_routings_step_dep_rec.LAST_UPDATE_DATE := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATE_DATE,SYSDATE);
722: l_routings_step_dep_rec.CREATION_DATE := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).CREATION_DATE,SYSDATE);
723: l_routings_step_dep_rec.LAST_UPDATE_LOGIN := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATE_LOGIN,FND_GLOBAL.USER_ID);
724: l_routings_step_dep_rec.TRANSFER_PCT := p_routing_obj.gmd_ebi_rtg_step_dependency(i).TRANSFER_PCT;
725: l_routings_step_dep_tbl_insert(l_routings_step_dep_insert_ctr) := l_routings_step_dep_rec;
726: l_routings_step_dep_insert_ctr := l_routings_step_dep_insert_ctr + 1;
727: END IF;

Line 931: l_routings_step_dep_rec.LAST_UPDATED_BY :=Nvl( p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATED_BY,FND_GLOBAL.USER_ID);

927: l_routings_step_dep_rec.MAX_DELAY := p_routing_obj.gmd_ebi_rtg_step_dependency(i).MAX_DELAY;
928: l_routings_step_dep_rec.TRANSFER_QTY := p_routing_obj.gmd_ebi_rtg_step_dependency(i).TRANSFER_QTY;
929: l_routings_step_dep_rec.ITEM_UM := p_routing_obj.gmd_ebi_rtg_step_dependency(i).ITEM_UM;
930: l_routings_step_dep_rec.TEXT_CODE := p_routing_obj.gmd_ebi_rtg_step_dependency(i).TEXT_CODE;
931: l_routings_step_dep_rec.LAST_UPDATED_BY :=Nvl( p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATED_BY,FND_GLOBAL.USER_ID);
932: l_routings_step_dep_rec.CREATED_BY := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).CREATED_BY,FND_GLOBAL.USER_ID);
933: l_routings_step_dep_rec.LAST_UPDATE_DATE := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATE_DATE,SYSDATE);
934: l_routings_step_dep_rec.CREATION_DATE := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).CREATION_DATE,SYSDATE);
935: l_routings_step_dep_rec.LAST_UPDATE_LOGIN := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATE_LOGIN,FND_GLOBAL.USER_ID);

Line 932: l_routings_step_dep_rec.CREATED_BY := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).CREATED_BY,FND_GLOBAL.USER_ID);

928: l_routings_step_dep_rec.TRANSFER_QTY := p_routing_obj.gmd_ebi_rtg_step_dependency(i).TRANSFER_QTY;
929: l_routings_step_dep_rec.ITEM_UM := p_routing_obj.gmd_ebi_rtg_step_dependency(i).ITEM_UM;
930: l_routings_step_dep_rec.TEXT_CODE := p_routing_obj.gmd_ebi_rtg_step_dependency(i).TEXT_CODE;
931: l_routings_step_dep_rec.LAST_UPDATED_BY :=Nvl( p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATED_BY,FND_GLOBAL.USER_ID);
932: l_routings_step_dep_rec.CREATED_BY := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).CREATED_BY,FND_GLOBAL.USER_ID);
933: l_routings_step_dep_rec.LAST_UPDATE_DATE := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATE_DATE,SYSDATE);
934: l_routings_step_dep_rec.CREATION_DATE := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).CREATION_DATE,SYSDATE);
935: l_routings_step_dep_rec.LAST_UPDATE_LOGIN := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATE_LOGIN,FND_GLOBAL.USER_ID);
936: l_routings_step_dep_rec.TRANSFER_PCT := p_routing_obj.gmd_ebi_rtg_step_dependency(i).TRANSFER_PCT;

Line 935: l_routings_step_dep_rec.LAST_UPDATE_LOGIN := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATE_LOGIN,FND_GLOBAL.USER_ID);

931: l_routings_step_dep_rec.LAST_UPDATED_BY :=Nvl( p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATED_BY,FND_GLOBAL.USER_ID);
932: l_routings_step_dep_rec.CREATED_BY := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).CREATED_BY,FND_GLOBAL.USER_ID);
933: l_routings_step_dep_rec.LAST_UPDATE_DATE := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATE_DATE,SYSDATE);
934: l_routings_step_dep_rec.CREATION_DATE := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).CREATION_DATE,SYSDATE);
935: l_routings_step_dep_rec.LAST_UPDATE_LOGIN := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATE_LOGIN,FND_GLOBAL.USER_ID);
936: l_routings_step_dep_rec.TRANSFER_PCT := p_routing_obj.gmd_ebi_rtg_step_dependency(i).TRANSFER_PCT;
937: l_routings_step_dep_tbl_insert(l_routings_step_dep_insert_ctr) := l_routings_step_dep_rec;
938: l_routings_step_dep_insert_ctr := l_routings_step_dep_insert_ctr + 1;
939: ELSE

Line 1082: l_new_line varchar2(10) := fnd_global.newline;

1078: l_text LONG;
1079: l_text_ing LONG;
1080: l_text_products LONG;
1081: l_text_by_products LONG;
1082: l_new_line varchar2(10) := fnd_global.newline;
1083: l_space varchar2(10) := fnd_const.local_chr(32);
1084: l_bus_comp_id VARCHAR2(100);
1085: l_line_id NUMBER;
1086: l_attchmt_exits VARCHAR2(1);

Line 1197: X_created_by => FND_GLOBAL.USER_ID,

1193: IF(l_attchmt_exits <> 'Y') THEN
1194: FND_Documents_PKG.Insert_Row(X_Rowid => l_row_id1,
1195: X_document_id => l_document_id,
1196: X_creation_date => sysdate,
1197: X_created_by => FND_GLOBAL.USER_ID,
1198: X_last_update_date => sysdate,
1199: X_last_updated_by => FND_GLOBAL.USER_ID,
1200: X_datatype_id => l_datatype_id,
1201: X_category_id => l_category_id,

Line 1199: X_last_updated_by => FND_GLOBAL.USER_ID,

1195: X_document_id => l_document_id,
1196: X_creation_date => sysdate,
1197: X_created_by => FND_GLOBAL.USER_ID,
1198: X_last_update_date => sysdate,
1199: X_last_updated_by => FND_GLOBAL.USER_ID,
1200: X_datatype_id => l_datatype_id,
1201: X_category_id => l_category_id,
1202: X_security_type => l_security_tp,
1203: X_publish_flag => l_publish_flag,

Line 1217: X_created_by => FND_GLOBAL.USER_ID,

1213: FND_Attached_Documents_PKG.Insert_Row(X_Rowid => l_row_id2,
1214: X_attached_document_id => l_att_doc_id,
1215: X_document_id => l_document_id,
1216: X_creation_date => sysdate,
1217: X_created_by => FND_GLOBAL.USER_ID,
1218: X_last_update_date => sysdate,
1219: X_last_updated_by => FND_GLOBAL.USER_ID,
1220: X_seq_num => '10',
1221: X_entity_name => l_entity_name,

Line 1219: X_last_updated_by => FND_GLOBAL.USER_ID,

1215: X_document_id => l_document_id,
1216: X_creation_date => sysdate,
1217: X_created_by => FND_GLOBAL.USER_ID,
1218: X_last_update_date => sysdate,
1219: X_last_updated_by => FND_GLOBAL.USER_ID,
1220: X_seq_num => '10',
1221: X_entity_name => l_entity_name,
1222: X_column1 => NULL,
1223: X_pk1_value => l_formula_id,

Line 1272: ,X_last_updated_by => FND_GLOBAL.USER_ID

1268: FND_Attached_Documents_PKG.Update_Row(X_Rowid => l_row_id1
1269: ,X_attached_document_id => l_attached_doc.attached_document_id
1270: ,X_document_id =>l_attached_doc.document_id
1271: ,X_last_update_date => sysdate
1272: ,X_last_updated_by => FND_GLOBAL.USER_ID
1273: ,X_last_update_login => FND_GLOBAL.USER_ID
1274: ,X_seq_num => l_attached_doc.seq_num
1275: ,X_entity_name => l_attached_doc.entity_name
1276: ,X_column1 => l_attached_doc.column1

Line 1273: ,X_last_update_login => FND_GLOBAL.USER_ID

1269: ,X_attached_document_id => l_attached_doc.attached_document_id
1270: ,X_document_id =>l_attached_doc.document_id
1271: ,X_last_update_date => sysdate
1272: ,X_last_updated_by => FND_GLOBAL.USER_ID
1273: ,X_last_update_login => FND_GLOBAL.USER_ID
1274: ,X_seq_num => l_attached_doc.seq_num
1275: ,X_entity_name => l_attached_doc.entity_name
1276: ,X_column1 => l_attached_doc.column1
1277: ,X_pk1_value => l_attached_doc.pk1_value

Line 1591: l_formula_insert_header_rec.created_by := FND_GLOBAL.USER_ID;

1587: l_formula_insert_header_rec.attribute30 := p_formula_obj.formula_header.attribute30;
1588: l_formula_insert_header_rec.attribute_category := p_formula_obj.formula_header.attribute_category;
1589: l_formula_insert_header_rec.text_code_hdr := p_formula_obj.formula_header.text_code_hdr;
1590: l_formula_insert_header_rec.delete_mark := NVL(p_formula_obj.formula_header.delete_mark,0);
1591: l_formula_insert_header_rec.created_by := FND_GLOBAL.USER_ID;
1592: l_formula_insert_header_rec.creation_date := NVL(p_formula_obj.formula_header.creation_date, SYSDATE);
1593: l_formula_insert_header_rec.last_update_date := NVL(p_formula_obj.formula_header.last_update_date, SYSDATE);
1594: l_formula_insert_header_rec.last_update_login := NVL(p_formula_obj.formula_header.last_update_login, FND_GLOBAL.USER_ID);
1595: l_formula_insert_header_rec.last_updated_by := FND_GLOBAL.USER_ID;

Line 1594: l_formula_insert_header_rec.last_update_login := NVL(p_formula_obj.formula_header.last_update_login, FND_GLOBAL.USER_ID);

1590: l_formula_insert_header_rec.delete_mark := NVL(p_formula_obj.formula_header.delete_mark,0);
1591: l_formula_insert_header_rec.created_by := FND_GLOBAL.USER_ID;
1592: l_formula_insert_header_rec.creation_date := NVL(p_formula_obj.formula_header.creation_date, SYSDATE);
1593: l_formula_insert_header_rec.last_update_date := NVL(p_formula_obj.formula_header.last_update_date, SYSDATE);
1594: l_formula_insert_header_rec.last_update_login := NVL(p_formula_obj.formula_header.last_update_login, FND_GLOBAL.USER_ID);
1595: l_formula_insert_header_rec.last_updated_by := FND_GLOBAL.USER_ID;
1596: l_formula_insert_header_rec.formulaline_id := p_formula_obj.formula_details(j).formulaline_id;
1597: l_formula_insert_header_rec.line_type := p_formula_obj.formula_details(j).line_type;
1598: l_formula_insert_header_rec.line_no := p_formula_obj.formula_details(j).line_no;

Line 1595: l_formula_insert_header_rec.last_updated_by := FND_GLOBAL.USER_ID;

1591: l_formula_insert_header_rec.created_by := FND_GLOBAL.USER_ID;
1592: l_formula_insert_header_rec.creation_date := NVL(p_formula_obj.formula_header.creation_date, SYSDATE);
1593: l_formula_insert_header_rec.last_update_date := NVL(p_formula_obj.formula_header.last_update_date, SYSDATE);
1594: l_formula_insert_header_rec.last_update_login := NVL(p_formula_obj.formula_header.last_update_login, FND_GLOBAL.USER_ID);
1595: l_formula_insert_header_rec.last_updated_by := FND_GLOBAL.USER_ID;
1596: l_formula_insert_header_rec.formulaline_id := p_formula_obj.formula_details(j).formulaline_id;
1597: l_formula_insert_header_rec.line_type := p_formula_obj.formula_details(j).line_type;
1598: l_formula_insert_header_rec.line_no := p_formula_obj.formula_details(j).line_no;
1599: l_formula_insert_header_rec.inventory_item_id := p_formula_obj.formula_details(j).inventory_item_id;

Line 1713: l_formula_update_header_rec.created_by := FND_GLOBAL.USER_ID;

1709: l_formula_update_header_rec.attribute30 := p_formula_obj.formula_header.attribute30;
1710: l_formula_update_header_rec.attribute_category:= p_formula_obj.formula_header.attribute_category;
1711: l_formula_update_header_rec.text_code_hdr := p_formula_obj.formula_header.text_code_hdr;
1712: l_formula_update_header_rec.delete_mark := NVL(p_formula_obj.formula_header.delete_mark,0);
1713: l_formula_update_header_rec.created_by := FND_GLOBAL.USER_ID;
1714: l_formula_update_header_rec.creation_date := NVL(p_formula_obj.formula_header.creation_date, SYSDATE);
1715: l_formula_update_header_rec.last_update_date := NVL(p_formula_obj.formula_header.last_update_date, SYSDATE);
1716: l_formula_update_header_rec.last_update_login := NVL(p_formula_obj.formula_header.last_update_login, FND_GLOBAL.USER_ID);
1717: l_formula_update_header_rec.last_updated_by := FND_GLOBAL.USER_ID;

Line 1716: l_formula_update_header_rec.last_update_login := NVL(p_formula_obj.formula_header.last_update_login, FND_GLOBAL.USER_ID);

1712: l_formula_update_header_rec.delete_mark := NVL(p_formula_obj.formula_header.delete_mark,0);
1713: l_formula_update_header_rec.created_by := FND_GLOBAL.USER_ID;
1714: l_formula_update_header_rec.creation_date := NVL(p_formula_obj.formula_header.creation_date, SYSDATE);
1715: l_formula_update_header_rec.last_update_date := NVL(p_formula_obj.formula_header.last_update_date, SYSDATE);
1716: l_formula_update_header_rec.last_update_login := NVL(p_formula_obj.formula_header.last_update_login, FND_GLOBAL.USER_ID);
1717: l_formula_update_header_rec.last_updated_by := FND_GLOBAL.USER_ID;
1718: l_formula_update_header_tbl(1) := l_formula_update_header_rec;
1719: END IF;
1720: IF (p_formula_obj.formula_details(j).formulaline_id IS NULL) THEN

Line 1717: l_formula_update_header_rec.last_updated_by := FND_GLOBAL.USER_ID;

1713: l_formula_update_header_rec.created_by := FND_GLOBAL.USER_ID;
1714: l_formula_update_header_rec.creation_date := NVL(p_formula_obj.formula_header.creation_date, SYSDATE);
1715: l_formula_update_header_rec.last_update_date := NVL(p_formula_obj.formula_header.last_update_date, SYSDATE);
1716: l_formula_update_header_rec.last_update_login := NVL(p_formula_obj.formula_header.last_update_login, FND_GLOBAL.USER_ID);
1717: l_formula_update_header_rec.last_updated_by := FND_GLOBAL.USER_ID;
1718: l_formula_update_header_tbl(1) := l_formula_update_header_rec;
1719: END IF;
1720: IF (p_formula_obj.formula_details(j).formulaline_id IS NULL) THEN
1721: l_formula_insert_detail_rec.formula_id := p_formula_obj.formula_details(j).formula_id;

Line 1838: l_formula_update_detail_rec.created_by := FND_GLOBAL.USER_ID;

1834: l_formula_update_detail_rec.attribute27 := p_formula_obj.formula_details(j).dtl_attribute27;
1835: l_formula_update_detail_rec.attribute28 := p_formula_obj.formula_details(j).dtl_attribute28;
1836: l_formula_update_detail_rec.attribute29 := p_formula_obj.formula_details(j).dtl_attribute29;
1837: l_formula_update_detail_rec.attribute30 := p_formula_obj.formula_details(j).dtl_attribute30;
1838: l_formula_update_detail_rec.created_by := FND_GLOBAL.USER_ID;
1839: l_formula_update_detail_rec.creation_date := NVL(p_formula_obj.formula_details(j).creation_date, SYSDATE);
1840: l_formula_update_detail_rec.last_update_date := NVL(p_formula_obj.formula_details(j).last_update_date, SYSDATE);
1841: l_formula_update_detail_rec.last_update_login := NVL(p_formula_obj.formula_details(j).last_update_login, FND_GLOBAL.USER_ID);
1842: l_formula_update_detail_rec.last_updated_by := FND_GLOBAL.USER_ID;

Line 1841: l_formula_update_detail_rec.last_update_login := NVL(p_formula_obj.formula_details(j).last_update_login, FND_GLOBAL.USER_ID);

1837: l_formula_update_detail_rec.attribute30 := p_formula_obj.formula_details(j).dtl_attribute30;
1838: l_formula_update_detail_rec.created_by := FND_GLOBAL.USER_ID;
1839: l_formula_update_detail_rec.creation_date := NVL(p_formula_obj.formula_details(j).creation_date, SYSDATE);
1840: l_formula_update_detail_rec.last_update_date := NVL(p_formula_obj.formula_details(j).last_update_date, SYSDATE);
1841: l_formula_update_detail_rec.last_update_login := NVL(p_formula_obj.formula_details(j).last_update_login, FND_GLOBAL.USER_ID);
1842: l_formula_update_detail_rec.last_updated_by := FND_GLOBAL.USER_ID;
1843: l_formula_update_detail_tbl(l_update_detailctr) := l_formula_update_detail_rec;
1844: l_update_detailctr := l_update_detailctr + 1;
1845: END IF;

Line 1842: l_formula_update_detail_rec.last_updated_by := FND_GLOBAL.USER_ID;

1838: l_formula_update_detail_rec.created_by := FND_GLOBAL.USER_ID;
1839: l_formula_update_detail_rec.creation_date := NVL(p_formula_obj.formula_details(j).creation_date, SYSDATE);
1840: l_formula_update_detail_rec.last_update_date := NVL(p_formula_obj.formula_details(j).last_update_date, SYSDATE);
1841: l_formula_update_detail_rec.last_update_login := NVL(p_formula_obj.formula_details(j).last_update_login, FND_GLOBAL.USER_ID);
1842: l_formula_update_detail_rec.last_updated_by := FND_GLOBAL.USER_ID;
1843: l_formula_update_detail_tbl(l_update_detailctr) := l_formula_update_detail_rec;
1844: l_update_detailctr := l_update_detailctr + 1;
1845: END IF;
1846: END IF;

Line 2092: x_msg_data := x_msg_data || l_recipe_out_obj.error_msg || fnd_global.newline;

2088: l_recipe_out_Ctr := l_recipe_out_Ctr + 1;
2089: END IF;
2090: IF l_status NOT IN (FND_API.G_RET_STS_SUCCESS,'Q') THEN
2091: x_return_status := FND_API.G_RET_STS_ERROR;
2092: x_msg_data := x_msg_data || l_recipe_out_obj.error_msg || fnd_global.newline;
2093: END IF;
2094: IF p_commit = FND_API.G_TRUE THEN
2095: COMMIT;
2096: END IF;