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.WMS_LMS_EXPECTED_RES dependencies on DBMS_SQL

Line 2405: c:= dbms_sql.open_cursor;

2401: IF g_debug=1 THEN
2402: debug('The sql clause finally is '|| l_sql,'MATCH_RATE_EXP_RESOURCE');
2403: END IF;
2404:
2405: c:= dbms_sql.open_cursor;
2406:
2407: IF g_debug=1 THEN
2408: debug('Opened the cursor for Binding ','MATCH_RATE_EXP_RESOURCE');
2409: END IF;

Line 2411: DBMS_SQL.parse(c, l_sql, DBMS_SQL.native);

2407: IF g_debug=1 THEN
2408: debug('Opened the cursor for Binding ','MATCH_RATE_EXP_RESOURCE');
2409: END IF;
2410:
2411: DBMS_SQL.parse(c, l_sql, DBMS_SQL.native);
2412:
2413: IF g_debug=1 THEN
2414: debug('Starting Binding the variables ','MATCH_RATE_EXP_RESOURCE');
2415: END IF;

Line 2417: DBMS_SQL.bind_variable(c, 'els_data_id', l_els_data.els_data_id);

2413: IF g_debug=1 THEN
2414: debug('Starting Binding the variables ','MATCH_RATE_EXP_RESOURCE');
2415: END IF;
2416:
2417: DBMS_SQL.bind_variable(c, 'els_data_id', l_els_data.els_data_id);
2418:
2419: DBMS_SQL.bind_variable(c, 'source_zone', l_els_data.source_zone_id);
2420:
2421: DBMS_SQL.bind_variable(c, 'destination_zone', l_els_data.destination_zone_id);

Line 2419: DBMS_SQL.bind_variable(c, 'source_zone', l_els_data.source_zone_id);

2415: END IF;
2416:
2417: DBMS_SQL.bind_variable(c, 'els_data_id', l_els_data.els_data_id);
2418:
2419: DBMS_SQL.bind_variable(c, 'source_zone', l_els_data.source_zone_id);
2420:
2421: DBMS_SQL.bind_variable(c, 'destination_zone', l_els_data.destination_zone_id);
2422:
2423: DBMS_SQL.bind_variable(c, 'item_category', l_els_data.item_category_id);

Line 2421: DBMS_SQL.bind_variable(c, 'destination_zone', l_els_data.destination_zone_id);

2417: DBMS_SQL.bind_variable(c, 'els_data_id', l_els_data.els_data_id);
2418:
2419: DBMS_SQL.bind_variable(c, 'source_zone', l_els_data.source_zone_id);
2420:
2421: DBMS_SQL.bind_variable(c, 'destination_zone', l_els_data.destination_zone_id);
2422:
2423: DBMS_SQL.bind_variable(c, 'item_category', l_els_data.item_category_id);
2424:
2425: DBMS_SQL.bind_variable(c, 'expected_txn_time', l_els_data.expected_txn_time);

Line 2423: DBMS_SQL.bind_variable(c, 'item_category', l_els_data.item_category_id);

2419: DBMS_SQL.bind_variable(c, 'source_zone', l_els_data.source_zone_id);
2420:
2421: DBMS_SQL.bind_variable(c, 'destination_zone', l_els_data.destination_zone_id);
2422:
2423: DBMS_SQL.bind_variable(c, 'item_category', l_els_data.item_category_id);
2424:
2425: DBMS_SQL.bind_variable(c, 'expected_txn_time', l_els_data.expected_txn_time);
2426:
2427: DBMS_SQL.bind_variable(c, 'expected_travel_time', l_els_data.expected_travel_time);

Line 2425: DBMS_SQL.bind_variable(c, 'expected_txn_time', l_els_data.expected_txn_time);

2421: DBMS_SQL.bind_variable(c, 'destination_zone', l_els_data.destination_zone_id);
2422:
2423: DBMS_SQL.bind_variable(c, 'item_category', l_els_data.item_category_id);
2424:
2425: DBMS_SQL.bind_variable(c, 'expected_txn_time', l_els_data.expected_txn_time);
2426:
2427: DBMS_SQL.bind_variable(c, 'expected_travel_time', l_els_data.expected_travel_time);
2428:
2429: DBMS_SQL.bind_variable(c, 'expected_idle_time', l_els_data.expected_idle_time);

Line 2427: DBMS_SQL.bind_variable(c, 'expected_travel_time', l_els_data.expected_travel_time);

2423: DBMS_SQL.bind_variable(c, 'item_category', l_els_data.item_category_id);
2424:
2425: DBMS_SQL.bind_variable(c, 'expected_txn_time', l_els_data.expected_txn_time);
2426:
2427: DBMS_SQL.bind_variable(c, 'expected_travel_time', l_els_data.expected_travel_time);
2428:
2429: DBMS_SQL.bind_variable(c, 'expected_idle_time', l_els_data.expected_idle_time);
2430:
2431: DBMS_SQL.bind_variable(c, 'time_per_day', p_Num_work_hrs_day);

Line 2429: DBMS_SQL.bind_variable(c, 'expected_idle_time', l_els_data.expected_idle_time);

2425: DBMS_SQL.bind_variable(c, 'expected_txn_time', l_els_data.expected_txn_time);
2426:
2427: DBMS_SQL.bind_variable(c, 'expected_travel_time', l_els_data.expected_travel_time);
2428:
2429: DBMS_SQL.bind_variable(c, 'expected_idle_time', l_els_data.expected_idle_time);
2430:
2431: DBMS_SQL.bind_variable(c, 'time_per_day', p_Num_work_hrs_day);
2432:
2433: DBMS_SQL.bind_variable(c, 'utilization_rate', p_Utilization_rate);

Line 2431: DBMS_SQL.bind_variable(c, 'time_per_day', p_Num_work_hrs_day);

2427: DBMS_SQL.bind_variable(c, 'expected_travel_time', l_els_data.expected_travel_time);
2428:
2429: DBMS_SQL.bind_variable(c, 'expected_idle_time', l_els_data.expected_idle_time);
2430:
2431: DBMS_SQL.bind_variable(c, 'time_per_day', p_Num_work_hrs_day);
2432:
2433: DBMS_SQL.bind_variable(c, 'utilization_rate', p_Utilization_rate);
2434:
2435: DBMS_SQL.bind_variable(c, 'org_id', p_org_id);

Line 2433: DBMS_SQL.bind_variable(c, 'utilization_rate', p_Utilization_rate);

2429: DBMS_SQL.bind_variable(c, 'expected_idle_time', l_els_data.expected_idle_time);
2430:
2431: DBMS_SQL.bind_variable(c, 'time_per_day', p_Num_work_hrs_day);
2432:
2433: DBMS_SQL.bind_variable(c, 'utilization_rate', p_Utilization_rate);
2434:
2435: DBMS_SQL.bind_variable(c, 'org_id', p_org_id);
2436:
2437: IF l_els_data.organization_id IS NOT NULL

Line 2435: DBMS_SQL.bind_variable(c, 'org_id', p_org_id);

2431: DBMS_SQL.bind_variable(c, 'time_per_day', p_Num_work_hrs_day);
2432:
2433: DBMS_SQL.bind_variable(c, 'utilization_rate', p_Utilization_rate);
2434:
2435: DBMS_SQL.bind_variable(c, 'org_id', p_org_id);
2436:
2437: IF l_els_data.organization_id IS NOT NULL
2438: THEN
2439: DBMS_SQL.bind_variable(c, 'organization_id', l_els_data.organization_id);

Line 2439: DBMS_SQL.bind_variable(c, 'organization_id', l_els_data.organization_id);

2435: DBMS_SQL.bind_variable(c, 'org_id', p_org_id);
2436:
2437: IF l_els_data.organization_id IS NOT NULL
2438: THEN
2439: DBMS_SQL.bind_variable(c, 'organization_id', l_els_data.organization_id);
2440: END IF;
2441:
2442: IF l_els_data.activity_id IS NOT NULL
2443: THEN

Line 2444: DBMS_SQL.bind_variable(c, 'activity_id', l_els_data.activity_id);

2440: END IF;
2441:
2442: IF l_els_data.activity_id IS NOT NULL
2443: THEN
2444: DBMS_SQL.bind_variable(c, 'activity_id', l_els_data.activity_id);
2445: END IF;
2446:
2447: IF l_els_data.activity_detail_id IS NOT NULL
2448: THEN

Line 2449: DBMS_SQL.bind_variable(c, 'activity_detail_id', l_els_data.activity_detail_id);

2445: END IF;
2446:
2447: IF l_els_data.activity_detail_id IS NOT NULL
2448: THEN
2449: DBMS_SQL.bind_variable(c, 'activity_detail_id', l_els_data.activity_detail_id);
2450: END IF;
2451:
2452: IF l_els_data.operation_id IS NOT NULL
2453: THEN

Line 2454: DBMS_SQL.bind_variable(c, 'operation_id', l_els_data.operation_id);

2450: END IF;
2451:
2452: IF l_els_data.operation_id IS NOT NULL
2453: THEN
2454: DBMS_SQL.bind_variable(c, 'operation_id', l_els_data.operation_id);
2455: END IF;
2456:
2457: IF l_els_data.source_zone_id IS NOT NULL
2458: THEN

Line 2459: DBMS_SQL.bind_variable(c, 'source_zone_id', l_els_data.source_zone_id);

2455: END IF;
2456:
2457: IF l_els_data.source_zone_id IS NOT NULL
2458: THEN
2459: DBMS_SQL.bind_variable(c, 'source_zone_id', l_els_data.source_zone_id);
2460: END IF;
2461:
2462: IF l_els_data.source_subinventory IS NOT NULL
2463: THEN

Line 2464: DBMS_SQL.bind_variable(c, 'source_subinventory', l_els_data.source_subinventory);

2460: END IF;
2461:
2462: IF l_els_data.source_subinventory IS NOT NULL
2463: THEN
2464: DBMS_SQL.bind_variable(c, 'source_subinventory', l_els_data.source_subinventory);
2465: END IF;
2466:
2467: IF l_els_data.destination_zone_id IS NOT NULL
2468: THEN

Line 2469: DBMS_SQL.bind_variable(c, 'destination_zone_id', l_els_data.destination_zone_id);

2465: END IF;
2466:
2467: IF l_els_data.destination_zone_id IS NOT NULL
2468: THEN
2469: DBMS_SQL.bind_variable(c, 'destination_zone_id', l_els_data.destination_zone_id);
2470: END IF;
2471:
2472: IF l_els_data.destination_subinventory IS NOT NULL
2473: THEN

Line 2474: DBMS_SQL.bind_variable(c, 'destination_subinventory', l_els_data.destination_subinventory);

2470: END IF;
2471:
2472: IF l_els_data.destination_subinventory IS NOT NULL
2473: THEN
2474: DBMS_SQL.bind_variable(c, 'destination_subinventory', l_els_data.destination_subinventory);
2475: END IF;
2476: /*
2477: IF l_els_data.labor_txn_source_id IS NOT NULL
2478: THEN

Line 2479: DBMS_SQL.bind_variable(c, 'labor_txn_source_id', l_els_data.labor_txn_source_id);

2475: END IF;
2476: /*
2477: IF l_els_data.labor_txn_source_id IS NOT NULL
2478: THEN
2479: DBMS_SQL.bind_variable(c, 'labor_txn_source_id', l_els_data.labor_txn_source_id);
2480: END IF;
2481: */
2482:
2483: IF l_els_data.transaction_uom IS NOT NULL

Line 2485: DBMS_SQL.bind_variable(c, 'transaction_uom', l_els_data.transaction_uom);

2481: */
2482:
2483: IF l_els_data.transaction_uom IS NOT NULL
2484: THEN
2485: DBMS_SQL.bind_variable(c, 'transaction_uom', l_els_data.transaction_uom);
2486: END IF;
2487:
2488: IF l_els_data.from_quantity IS NOT NULL
2489: THEN

Line 2490: DBMS_SQL.bind_variable(c, 'from_quantity', l_els_data.from_quantity);

2486: END IF;
2487:
2488: IF l_els_data.from_quantity IS NOT NULL
2489: THEN
2490: DBMS_SQL.bind_variable(c, 'from_quantity', l_els_data.from_quantity);
2491: END IF;
2492:
2493: IF l_els_data.to_quantity IS NOT NULL
2494: THEN

Line 2495: DBMS_SQL.bind_variable(c, 'to_quantity', l_els_data.to_quantity);

2491: END IF;
2492:
2493: IF l_els_data.to_quantity IS NOT NULL
2494: THEN
2495: DBMS_SQL.bind_variable(c, 'to_quantity', l_els_data.to_quantity);
2496: END IF;
2497:
2498: IF l_els_data.item_category_id IS NOT NULL
2499: THEN

Line 2500: DBMS_SQL.bind_variable(c, 'item_category_id', l_els_data.item_category_id);

2496: END IF;
2497:
2498: IF l_els_data.item_category_id IS NOT NULL
2499: THEN
2500: DBMS_SQL.bind_variable(c, 'item_category_id', l_els_data.item_category_id);
2501: END IF;
2502:
2503: IF l_els_data.operation_plan_id IS NOT NULL
2504: THEN

Line 2505: DBMS_SQL.bind_variable(c, 'operation_plan_id', l_els_data.operation_plan_id);

2501: END IF;
2502:
2503: IF l_els_data.operation_plan_id IS NOT NULL
2504: THEN
2505: DBMS_SQL.bind_variable(c, 'operation_plan_id', l_els_data.operation_plan_id);
2506: END IF;
2507:
2508: /*
2509: IF l_els_data.group_id IS NOT NULL

Line 2511: DBMS_SQL.bind_variable(c, 'group_id', l_els_data.group_id);

2507:
2508: /*
2509: IF l_els_data.group_id IS NOT NULL
2510: THEN
2511: DBMS_SQL.bind_variable(c, 'group_id', l_els_data.group_id);
2512: END IF;
2513: */
2514:
2515: IF g_debug=1 THEN

Line 2519: l_update_count := DBMS_SQL.EXECUTE(c);

2515: IF g_debug=1 THEN
2516: debug('All variables bound '|| l_sql,'MATCH_RATE_EXP_RESOURCE');
2517: END IF;
2518:
2519: l_update_count := DBMS_SQL.EXECUTE(c);
2520:
2521: IF g_debug=1 THEN
2522: debug('SQL executed Number of rows updated '|| l_update_count,'MATCH_RATE_EXP_RESOURCE');
2523: END IF;

Line 2530: DBMS_SQL.close_cursor(c);

2526: --get the row count
2527:
2528: l_total := l_update_count + NVL(l_els_data.num_trx_matched,0);
2529:
2530: DBMS_SQL.close_cursor(c);
2531:
2532: --update the count with newly matched transactions
2533:
2534: UPDATE wms_els_individual_tasks_b