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

Line 406: fnd_global.user_id,

402: Subinventory_name,
403: 0,
404: Source_type,
405: sysdate,
406: fnd_global.user_id,
407: sysdate,
408: fnd_global.user_id,
409: fnd_global.login_id,
410: Locator_id,

Line 408: fnd_global.user_id,

404: Source_type,
405: sysdate,
406: fnd_global.user_id,
407: sysdate,
408: fnd_global.user_id,
409: fnd_global.login_id,
410: Locator_id,
411: Calculate_Kanban_flag,
412: Kanban_size,

Line 409: fnd_global.login_id,

405: sysdate,
406: fnd_global.user_id,
407: sysdate,
408: fnd_global.user_id,
409: fnd_global.login_id,
410: Locator_id,
411: Calculate_Kanban_flag,
412: Kanban_size,
413: Number_of_cards,

Line 817: g_user_id := fnd_global.user_id;

813: into l_org_code
814: from mtl_parameters
815: where organization_id = p_organization_id;
816:
817: g_user_id := fnd_global.user_id;
818: g_user_login_id := fnd_global.login_id;
819: g_program_appl_id := fnd_global.prog_appl_id;
820: g_request_id := fnd_global.conc_request_id;
821: g_program_id := fnd_global.conc_program_id;

Line 818: g_user_login_id := fnd_global.login_id;

814: from mtl_parameters
815: where organization_id = p_organization_id;
816:
817: g_user_id := fnd_global.user_id;
818: g_user_login_id := fnd_global.login_id;
819: g_program_appl_id := fnd_global.prog_appl_id;
820: g_request_id := fnd_global.conc_request_id;
821: g_program_id := fnd_global.conc_program_id;
822: g_logLevel := FND_LOG.g_current_runtime_level;

Line 819: g_program_appl_id := fnd_global.prog_appl_id;

815: where organization_id = p_organization_id;
816:
817: g_user_id := fnd_global.user_id;
818: g_user_login_id := fnd_global.login_id;
819: g_program_appl_id := fnd_global.prog_appl_id;
820: g_request_id := fnd_global.conc_request_id;
821: g_program_id := fnd_global.conc_program_id;
822: g_logLevel := FND_LOG.g_current_runtime_level;
823:

Line 820: g_request_id := fnd_global.conc_request_id;

816:
817: g_user_id := fnd_global.user_id;
818: g_user_login_id := fnd_global.login_id;
819: g_program_appl_id := fnd_global.prog_appl_id;
820: g_request_id := fnd_global.conc_request_id;
821: g_program_id := fnd_global.conc_program_id;
822: g_logLevel := FND_LOG.g_current_runtime_level;
823:
824: l_stmt_num := 20;

Line 821: g_program_id := fnd_global.conc_program_id;

817: g_user_id := fnd_global.user_id;
818: g_user_login_id := fnd_global.login_id;
819: g_program_appl_id := fnd_global.prog_appl_id;
820: g_request_id := fnd_global.conc_request_id;
821: g_program_id := fnd_global.conc_program_id;
822: g_logLevel := FND_LOG.g_current_runtime_level;
823:
824: l_stmt_num := 20;
825:

Line 829: request_id = fnd_global.conc_request_id,

825:
826: update FLM_EKB_DEMAND_INTERFACE FEDI
827: set process_status = running,
828: organization_id = nvl(organization_id,p_organization_id),
829: request_id = fnd_global.conc_request_id,
830: program_id = fnd_global.conc_program_id,
831: program_application_id = fnd_global.prog_appl_id,
832: program_update_date = sysdate,
833: last_updated_by = fnd_global.user_id,

Line 830: program_id = fnd_global.conc_program_id,

826: update FLM_EKB_DEMAND_INTERFACE FEDI
827: set process_status = running,
828: organization_id = nvl(organization_id,p_organization_id),
829: request_id = fnd_global.conc_request_id,
830: program_id = fnd_global.conc_program_id,
831: program_application_id = fnd_global.prog_appl_id,
832: program_update_date = sysdate,
833: last_updated_by = fnd_global.user_id,
834: last_update_date = sysdate,

Line 831: program_application_id = fnd_global.prog_appl_id,

827: set process_status = running,
828: organization_id = nvl(organization_id,p_organization_id),
829: request_id = fnd_global.conc_request_id,
830: program_id = fnd_global.conc_program_id,
831: program_application_id = fnd_global.prog_appl_id,
832: program_update_date = sysdate,
833: last_updated_by = fnd_global.user_id,
834: last_update_date = sysdate,
835: LAST_UPDATED_LOGIN = fnd_global.login_id

Line 833: last_updated_by = fnd_global.user_id,

829: request_id = fnd_global.conc_request_id,
830: program_id = fnd_global.conc_program_id,
831: program_application_id = fnd_global.prog_appl_id,
832: program_update_date = sysdate,
833: last_updated_by = fnd_global.user_id,
834: last_update_date = sysdate,
835: LAST_UPDATED_LOGIN = fnd_global.login_id
836: where
837: process_status = pending

Line 835: LAST_UPDATED_LOGIN = fnd_global.login_id

831: program_application_id = fnd_global.prog_appl_id,
832: program_update_date = sysdate,
833: last_updated_by = fnd_global.user_id,
834: last_update_date = sysdate,
835: LAST_UPDATED_LOGIN = fnd_global.login_id
836: where
837: process_status = pending
838: and (organization_id = p_organization_id or
839: organization_code = (select mp.organization_code

Line 1139: v_flm_kanban_demand(ins_counter).created_by := fnd_global.user_id;

1135: v_flm_kanban_demand(ins_counter).demand_date := l_flm_kanban_demand_intf(l_counter).DEMAND_START_DATE;
1136: v_flm_kanban_demand(ins_counter).demand_quantity := l_flm_kanban_demand_intf(l_counter).AVERAGE_DEMAND;
1137: v_flm_kanban_demand(ins_counter).order_type := -1;
1138: v_flm_kanban_demand(ins_counter).kanban_item_flag := 'Y';
1139: v_flm_kanban_demand(ins_counter).created_by := fnd_global.user_id;
1140: v_flm_kanban_demand(ins_counter).creation_date := sysdate;
1141: v_flm_kanban_demand(ins_counter).last_updated_by := fnd_global.user_id;
1142: v_flm_kanban_demand(ins_counter).last_update_date := sysdate;
1143: v_flm_kanban_demand(ins_counter).last_updated_login := fnd_global.login_id;

Line 1141: v_flm_kanban_demand(ins_counter).last_updated_by := fnd_global.user_id;

1137: v_flm_kanban_demand(ins_counter).order_type := -1;
1138: v_flm_kanban_demand(ins_counter).kanban_item_flag := 'Y';
1139: v_flm_kanban_demand(ins_counter).created_by := fnd_global.user_id;
1140: v_flm_kanban_demand(ins_counter).creation_date := sysdate;
1141: v_flm_kanban_demand(ins_counter).last_updated_by := fnd_global.user_id;
1142: v_flm_kanban_demand(ins_counter).last_update_date := sysdate;
1143: v_flm_kanban_demand(ins_counter).last_updated_login := fnd_global.login_id;
1144: v_flm_kanban_demand(ins_counter).request_id := fnd_global.conc_request_id;
1145: v_flm_kanban_demand(ins_counter).program_id := fnd_global.conc_program_id;

Line 1143: v_flm_kanban_demand(ins_counter).last_updated_login := fnd_global.login_id;

1139: v_flm_kanban_demand(ins_counter).created_by := fnd_global.user_id;
1140: v_flm_kanban_demand(ins_counter).creation_date := sysdate;
1141: v_flm_kanban_demand(ins_counter).last_updated_by := fnd_global.user_id;
1142: v_flm_kanban_demand(ins_counter).last_update_date := sysdate;
1143: v_flm_kanban_demand(ins_counter).last_updated_login := fnd_global.login_id;
1144: v_flm_kanban_demand(ins_counter).request_id := fnd_global.conc_request_id;
1145: v_flm_kanban_demand(ins_counter).program_id := fnd_global.conc_program_id;
1146: v_flm_kanban_demand(ins_counter).program_application_id := fnd_global.prog_appl_id;
1147: v_flm_kanban_demand(ins_counter).program_update_date := sysdate;

Line 1144: v_flm_kanban_demand(ins_counter).request_id := fnd_global.conc_request_id;

1140: v_flm_kanban_demand(ins_counter).creation_date := sysdate;
1141: v_flm_kanban_demand(ins_counter).last_updated_by := fnd_global.user_id;
1142: v_flm_kanban_demand(ins_counter).last_update_date := sysdate;
1143: v_flm_kanban_demand(ins_counter).last_updated_login := fnd_global.login_id;
1144: v_flm_kanban_demand(ins_counter).request_id := fnd_global.conc_request_id;
1145: v_flm_kanban_demand(ins_counter).program_id := fnd_global.conc_program_id;
1146: v_flm_kanban_demand(ins_counter).program_application_id := fnd_global.prog_appl_id;
1147: v_flm_kanban_demand(ins_counter).program_update_date := sysdate;
1148:

Line 1145: v_flm_kanban_demand(ins_counter).program_id := fnd_global.conc_program_id;

1141: v_flm_kanban_demand(ins_counter).last_updated_by := fnd_global.user_id;
1142: v_flm_kanban_demand(ins_counter).last_update_date := sysdate;
1143: v_flm_kanban_demand(ins_counter).last_updated_login := fnd_global.login_id;
1144: v_flm_kanban_demand(ins_counter).request_id := fnd_global.conc_request_id;
1145: v_flm_kanban_demand(ins_counter).program_id := fnd_global.conc_program_id;
1146: v_flm_kanban_demand(ins_counter).program_application_id := fnd_global.prog_appl_id;
1147: v_flm_kanban_demand(ins_counter).program_update_date := sysdate;
1148:
1149: ins_counter := ins_counter+1;

Line 1146: v_flm_kanban_demand(ins_counter).program_application_id := fnd_global.prog_appl_id;

1142: v_flm_kanban_demand(ins_counter).last_update_date := sysdate;
1143: v_flm_kanban_demand(ins_counter).last_updated_login := fnd_global.login_id;
1144: v_flm_kanban_demand(ins_counter).request_id := fnd_global.conc_request_id;
1145: v_flm_kanban_demand(ins_counter).program_id := fnd_global.conc_program_id;
1146: v_flm_kanban_demand(ins_counter).program_application_id := fnd_global.prog_appl_id;
1147: v_flm_kanban_demand(ins_counter).program_update_date := sysdate;
1148:
1149: ins_counter := ins_counter+1;
1150: l_flm_kanban_demand_intf(l_counter).DEMAND_START_DATE := l_flm_kanban_demand_intf(l_counter).DEMAND_START_DATE +1;

Line 1341: 'Source_type,sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,fnd_global.login_id,Locator_id,Calculate_Kanban_flag,'||

1337: 'Safety_Stock_Days,Attribute_Category,Attribute1,Attribute2,Attribute3,Attribute4,Attribute5,Attribute6,Attribute7,Attribute8,'||
1338: 'Attribute9,Attribute10,Attribute11,Attribute12,Attribute13,Attribute14,Attribute15,'||
1339: 'PLANNING_EFFECTIVITY,UPDATED_FLAG, RELEASE_KANBAN_FLAG,AVG_DEPENDENT_DEMAND,FUTURE_CARD_SIZE,FUTURE_NO_OF_CARDS)'||
1340: 'select MTL_KANBAN_PULL_SEQUENCES_S.NEXTVAL,Inventory_item_id,Organization_id,Subinventory_name,0,'||
1341: 'Source_type,sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,fnd_global.login_id,Locator_id,Calculate_Kanban_flag,'||
1342: 'decode(Calculate_Kanban_flag,1,FLM_KANBAN_PLANNING_UTIL.GET_CALCULATED_SIZE(PULL_SEQUENCE_ID,CALCULATE_KANBAN_FLAG,NUMBER_OF_CARDS,'||
1343: 'nvl(FLM_KANBAN_PLANNING_UTIL.get_average_demand(Organization_id,0,Inventory_item_id,Subinventory_name,Locator_id),nvl(AVG_DEPENDENT_DEMAND,0)),ALLOCATION_PERCENT,'||
1344: 'REPLENISHMENT_LEAD_TIME,SAFETY_STOCK_DAYS,MINIMUM_ORDER_QUANTITY,FIXED_LOT_MULTIPLIER),Kanban_size),'||
1345: 'decode(Calculate_Kanban_flag,2,FLM_KANBAN_PLANNING_UTIL.GET_CALCULATED_CARDS(PULL_SEQUENCE_ID,CALCULATE_KANBAN_FLAG,KANBAN_SIZE,'||

Line 1482: g_user_id := fnd_global.user_id;

1478: v_demand_quantity(to_char(v_dem_pull_seq_id(l_temp)||'-:-'||v_demand_date(l_temp))) := v_demand_qty(l_temp);
1479: l_temp := v_dem_pull_seq_id.next(l_temp);
1480: end loop;
1481: end if;
1482: g_user_id := fnd_global.user_id;
1483: g_user_login_id := fnd_global.login_id;
1484: l_counter := 0;
1485: l_temp_start_date := l_start_date;
1486: v_flm_kanban_planning_temp.delete;

Line 1483: g_user_login_id := fnd_global.login_id;

1479: l_temp := v_dem_pull_seq_id.next(l_temp);
1480: end loop;
1481: end if;
1482: g_user_id := fnd_global.user_id;
1483: g_user_login_id := fnd_global.login_id;
1484: l_counter := 0;
1485: l_temp_start_date := l_start_date;
1486: v_flm_kanban_planning_temp.delete;
1487: l_plan_pull_seq := v_plan_pull_seq_tbl.first;

Line 1834: last_updated_by = fnd_global.user_id,

1830: replenishment_lead_time = l_lead_time,
1831: fixed_lot_multiplier = l_lot_multiplier,
1832: safety_stock_days = l_safety_stock,
1833: last_update_date = sysdate,
1834: last_updated_by = fnd_global.user_id,
1835: last_update_login = fnd_global.login_id,
1836: attribute1 =l_attr_1,
1837: attribute2 =l_attr_2,
1838: attribute3 =l_attr_3,

Line 1835: last_update_login = fnd_global.login_id,

1831: fixed_lot_multiplier = l_lot_multiplier,
1832: safety_stock_days = l_safety_stock,
1833: last_update_date = sysdate,
1834: last_updated_by = fnd_global.user_id,
1835: last_update_login = fnd_global.login_id,
1836: attribute1 =l_attr_1,
1837: attribute2 =l_attr_2,
1838: attribute3 =l_attr_3,
1839: attribute4 =l_attr_4,

Line 1931: r_kanban_card_rec.last_update_by := fnd_global.user_id;

1927: r_kanban_card_rec.attribute14 := null;
1928: r_kanban_card_rec.attribute15 := null;
1929: r_kanban_card_rec.last_print_date := null;
1930: r_kanban_card_rec.last_update_date := sysdate;
1931: r_kanban_card_rec.last_update_by := fnd_global.user_id;
1932: r_kanban_card_rec.creation_date := sysdate;
1933: r_kanban_card_rec.created_by := fnd_global.user_id;
1934: r_kanban_card_rec.last_update_login := fnd_global.login_id;
1935: r_kanban_card_rec.request_id := null;

Line 1933: r_kanban_card_rec.created_by := fnd_global.user_id;

1929: r_kanban_card_rec.last_print_date := null;
1930: r_kanban_card_rec.last_update_date := sysdate;
1931: r_kanban_card_rec.last_update_by := fnd_global.user_id;
1932: r_kanban_card_rec.creation_date := sysdate;
1933: r_kanban_card_rec.created_by := fnd_global.user_id;
1934: r_kanban_card_rec.last_update_login := fnd_global.login_id;
1935: r_kanban_card_rec.request_id := null;
1936: r_kanban_card_rec.program_application_id := null;
1937: r_kanban_card_rec.program_id := null;

Line 1934: r_kanban_card_rec.last_update_login := fnd_global.login_id;

1930: r_kanban_card_rec.last_update_date := sysdate;
1931: r_kanban_card_rec.last_update_by := fnd_global.user_id;
1932: r_kanban_card_rec.creation_date := sysdate;
1933: r_kanban_card_rec.created_by := fnd_global.user_id;
1934: r_kanban_card_rec.last_update_login := fnd_global.login_id;
1935: r_kanban_card_rec.request_id := null;
1936: r_kanban_card_rec.program_application_id := null;
1937: r_kanban_card_rec.program_id := null;
1938: r_kanban_card_rec.program_update_date := null;

Line 2106: , p_last_updated_by => fnd_global.user_id

2102: , p_kanban_card_type => l_kanban_card_rec.kanban_card_type
2103: , p_source_type => l_kanban_card_rec.source_type
2104: , p_kanban_size => l_kanban_card_rec.kanban_size
2105: , p_last_update_date => sysdate
2106: , p_last_updated_by => fnd_global.user_id
2107: , p_creation_date => l_kanban_card_rec.creation_date
2108: , p_created_by => l_kanban_card_rec.created_by
2109: , p_last_update_login => fnd_global.login_id
2110: , p_last_print_date => l_kanban_card_rec.last_print_date

Line 2109: , p_last_update_login => fnd_global.login_id

2105: , p_last_update_date => sysdate
2106: , p_last_updated_by => fnd_global.user_id
2107: , p_creation_date => l_kanban_card_rec.creation_date
2108: , p_created_by => l_kanban_card_rec.created_by
2109: , p_last_update_login => fnd_global.login_id
2110: , p_last_print_date => l_kanban_card_rec.last_print_date
2111: , p_locator_id => l_kanban_card_rec.locator_id
2112: , p_supplier_id => l_kanban_card_rec.supplier_id
2113: , p_supplier_site_id => l_kanban_card_rec.supplier_site_id

Line 2296: last_updated_by = fnd_global.user_id,

2292: replenishment_lead_time = l_lead_time,
2293: fixed_lot_multiplier = l_lot_multiplier,
2294: safety_stock_days = l_safety_stock,
2295: last_update_date = sysdate,
2296: last_updated_by = fnd_global.user_id,
2297: last_update_login = fnd_global.login_id,
2298: attribute1 =l_attr_1,
2299: attribute2 =l_attr_2,
2300: attribute3 =l_attr_3,

Line 2297: last_update_login = fnd_global.login_id,

2293: fixed_lot_multiplier = l_lot_multiplier,
2294: safety_stock_days = l_safety_stock,
2295: last_update_date = sysdate,
2296: last_updated_by = fnd_global.user_id,
2297: last_update_login = fnd_global.login_id,
2298: attribute1 =l_attr_1,
2299: attribute2 =l_attr_2,
2300: attribute3 =l_attr_3,
2301: attribute4 =l_attr_4,

Line 2393: r_kanban_card_rec.last_update_by := fnd_global.user_id;

2389: r_kanban_card_rec.attribute14 := null;
2390: r_kanban_card_rec.attribute15 := null;
2391: r_kanban_card_rec.last_print_date := null;
2392: r_kanban_card_rec.last_update_date := sysdate;
2393: r_kanban_card_rec.last_update_by := fnd_global.user_id;
2394: r_kanban_card_rec.creation_date := sysdate;
2395: r_kanban_card_rec.created_by := fnd_global.user_id;
2396: r_kanban_card_rec.last_update_login := fnd_global.login_id;
2397: r_kanban_card_rec.request_id := null;

Line 2395: r_kanban_card_rec.created_by := fnd_global.user_id;

2391: r_kanban_card_rec.last_print_date := null;
2392: r_kanban_card_rec.last_update_date := sysdate;
2393: r_kanban_card_rec.last_update_by := fnd_global.user_id;
2394: r_kanban_card_rec.creation_date := sysdate;
2395: r_kanban_card_rec.created_by := fnd_global.user_id;
2396: r_kanban_card_rec.last_update_login := fnd_global.login_id;
2397: r_kanban_card_rec.request_id := null;
2398: r_kanban_card_rec.program_application_id := null;
2399: r_kanban_card_rec.program_id := null;

Line 2396: r_kanban_card_rec.last_update_login := fnd_global.login_id;

2392: r_kanban_card_rec.last_update_date := sysdate;
2393: r_kanban_card_rec.last_update_by := fnd_global.user_id;
2394: r_kanban_card_rec.creation_date := sysdate;
2395: r_kanban_card_rec.created_by := fnd_global.user_id;
2396: r_kanban_card_rec.last_update_login := fnd_global.login_id;
2397: r_kanban_card_rec.request_id := null;
2398: r_kanban_card_rec.program_application_id := null;
2399: r_kanban_card_rec.program_id := null;
2400: r_kanban_card_rec.program_update_date := null;

Line 2564: , p_last_updated_by => fnd_global.user_id

2560: , p_kanban_card_type => l_kanban_card_rec.kanban_card_type
2561: , p_source_type => l_kanban_card_rec.source_type
2562: , p_kanban_size => l_kanban_card_rec.kanban_size
2563: , p_last_update_date => sysdate
2564: , p_last_updated_by => fnd_global.user_id
2565: , p_creation_date => l_kanban_card_rec.creation_date
2566: , p_created_by => l_kanban_card_rec.created_by
2567: , p_last_update_login => fnd_global.login_id
2568: , p_last_print_date => l_kanban_card_rec.last_print_date

Line 2567: , p_last_update_login => fnd_global.login_id

2563: , p_last_update_date => sysdate
2564: , p_last_updated_by => fnd_global.user_id
2565: , p_creation_date => l_kanban_card_rec.creation_date
2566: , p_created_by => l_kanban_card_rec.created_by
2567: , p_last_update_login => fnd_global.login_id
2568: , p_last_print_date => l_kanban_card_rec.last_print_date
2569: , p_locator_id => l_kanban_card_rec.locator_id
2570: , p_supplier_id => l_kanban_card_rec.supplier_id
2571: , p_supplier_site_id => l_kanban_card_rec.supplier_site_id

Line 2644: FND_GLOBAL.apps_initialize (p_user_id,p_responsibility_id,p_resp_appl_id);

2640: FROM mtl_default_sets_view
2641: WHERE functional_area_id=3
2642: AND category_set_name = Nvl(p_category_set, category_set_name);
2643:
2644: FND_GLOBAL.apps_initialize (p_user_id,p_responsibility_id,p_resp_appl_id);
2645:
2646: l_request_id := FND_REQUEST.submit_request( 'MRP',
2647: 'MRPKQCAL',
2648: NULL,