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.MSC_X_NETTING_PKG dependencies on MSC_ITEM_EXCEPTIONS

Line 1883: --dbms_output.put_line('Update msc_item_exceptions');

1879: p_item_id IN Number,
1880: p_exception_type IN Number,
1881: p_exception_group IN Number) IS
1882: BEGIN
1883: --dbms_output.put_line('Update msc_item_exceptions');
1884: update msc_item_exceptions ex
1885: set ex.exception_count = ex.exception_count + 1,
1886: ex.last_update_date = sysdate
1887: where ex.plan_id = G_PLAN_ID

Line 1884: update msc_item_exceptions ex

1880: p_exception_type IN Number,
1881: p_exception_group IN Number) IS
1882: BEGIN
1883: --dbms_output.put_line('Update msc_item_exceptions');
1884: update msc_item_exceptions ex
1885: set ex.exception_count = ex.exception_count + 1,
1886: ex.last_update_date = sysdate
1887: where ex.plan_id = G_PLAN_ID
1888: and ex.company_id = p_company_id

Line 1912: insert into msc_item_exceptions( plan_id,

1908: p_exception_group IN Number) IS
1909: l_version Number := 0;
1910: BEGIN
1911: --dbms_output.put_line('Add item exception ');
1912: insert into msc_item_exceptions( plan_id,
1913: sr_instance_id,
1914: company_id,
1915: company_site_id,
1916: organization_id,

Line 1965: from msc_item_exceptions ex

1961:
1962: select 1 into l_ret_flag
1963: from dual
1964: where exists ( select 1
1965: from msc_item_exceptions ex
1966: where ex.plan_id = G_PLAN_ID
1967: and ex.company_id = p_company_id
1968: and ex.company_site_id = p_company_site_id
1969: and ex.inventory_item_id = p_item_id

Line 2332: update msc_item_exceptions

2328: l_row := SQL%ROWCOUNT;
2329: --dbms_output.put_line('archive detail exception ' || l_row);
2330:
2331: --dbms_output.put_line('---Maintaining item exceptions');
2332: update msc_item_exceptions
2333: set exception_count = exception_count - l_row,
2334: last_update_date = sysdate
2335: where plan_id = G_PLAN_ID
2336: and company_id = l_company_id

Line 2436: update msc_item_exceptions

2432: where exception_detail_id = l_exception_detail_id;
2433:
2434: l_row := SQL%ROWCOUNT;
2435:
2436: update msc_item_exceptions
2437: set exception_count = exception_count - l_row,
2438: last_update_date = sysdate
2439: where plan_id = G_PLAN_ID
2440: and company_id = l_company_id

Line 2576: update msc_item_exceptions ex

2572:
2573: l_row := SQL%ROWCOUNT;
2574: ----dbms_output.put_line('item row delete ' || l_row);
2575:
2576: update msc_item_exceptions ex
2577: set ex.exception_count = ex.exception_count - l_row,
2578: ex.last_update_date = sysdate
2579: where ex.plan_id = G_PLAN_ID
2580: and ex.company_id = p_company_id

Line 2609: update msc_item_exceptions ex

2605:
2606: l_row := SQL%ROWCOUNT;
2607: ----dbms_output.put_line('item row delete ' || l_row);
2608:
2609: update msc_item_exceptions ex
2610: set ex.exception_count = ex.exception_count - l_row,
2611: ex.last_update_date = sysdate
2612: where ex.plan_id = G_PLAN_ID
2613: and ex.company_id = p_company_id

Line 2640: update msc_item_exceptions ex

2636:
2637: l_row := SQL%ROWCOUNT;
2638: ----dbms_output.put_line('detail row delete ' || l_row);
2639:
2640: update msc_item_exceptions ex
2641: set ex.exception_count = ex.exception_count - l_row,
2642: ex.last_update_date = sysdate
2643: where ex.plan_id = G_PLAN_ID
2644: and ex.company_id = p_company_id

Line 2669: update msc_item_exceptions ex

2665:
2666: l_row := SQL%ROWCOUNT;
2667: ----dbms_output.put_line('detail row delete ' || l_row);
2668:
2669: update msc_item_exceptions ex
2670: set ex.exception_count = ex.exception_count - l_row,
2671: ex.last_update_date = sysdate
2672: where ex.plan_id = G_PLAN_ID
2673: and ex.company_id = p_company_id

Line 2700: update msc_item_exceptions ex

2696:
2697: l_row := SQL%ROWCOUNT;
2698: ----dbms_output.put_line('detail row delete ' || l_row);
2699:
2700: update msc_item_exceptions ex
2701: set ex.exception_count = ex.exception_count - l_row,
2702: ex.last_update_date = sysdate
2703: where ex.plan_id = G_PLAN_ID
2704: and ex.company_id = p_company_id

Line 2731: update msc_item_exceptions ex

2727:
2728: l_row := SQL%ROWCOUNT;
2729: ----dbms_output.put_line('detail row delete ' || l_row);
2730:
2731: update msc_item_exceptions ex
2732: set ex.exception_count = ex.exception_count - l_row,
2733: ex.last_update_date = sysdate
2734: where ex.plan_id = G_PLAN_ID
2735: and ex.company_id = p_company_id

Line 2767: update msc_item_exceptions ex

2763:
2764: --Update the last_update_login back to null to ensure accurate archival
2765: --when exceptions are generated in the next round
2766:
2767: update msc_item_exceptions ex
2768: set ex.last_update_login = null,
2769: ex.last_update_date = sysdate
2770: where ex.plan_id = G_PLAN_ID
2771: --and ex.version = 0

Line 2776: update msc_item_exceptions ex

2772: and exception_group in (1,2,3,4,5,6,7,8,9,10)
2773: and nvl(ex.last_update_login,-1) = G_MAGIC_NUMBER;
2774:
2775: --update the if the count is 0 to older version
2776: update msc_item_exceptions ex
2777: set ex.version = version + 1,
2778: ex.last_update_date = sysdate
2779: where ex.plan_id = G_PLAN_ID
2780: --and ex.version = 0

Line 2786: -- exception convergence; overtime or latency of a plan in msc_item_exceptions

2782: and ex.exception_count = 0;
2783:
2784: -- In prior release, we have kept a history of all the exceptions
2785: -- occuring during netting for intelligent analysis use such as
2786: -- exception convergence; overtime or latency of a plan in msc_item_exceptions
2787: -- table. The current usage is using the latest version of the data and
2788: -- not all the history data. If the table is maintaining all the history
2789: -- data, in the rolling of the netting engine run for a period of time,
2790: -- the table will grow quickly and create a performance problem. Therefore,

Line 2794: delete msc_item_exceptions ex

2790: -- the table will grow quickly and create a performance problem. Therefore,
2791: -- the table is arhived based on the user defined profile option and only keep
2792: -- certain number of version. Default verion = 20
2793:
2794: delete msc_item_exceptions ex
2795: where plan_id = G_PLAN_ID
2796: and exception_group in (1,2,3,4,5,6,7,8,9,10)
2797: and version > 20;
2798:

Line 3182: update msc_item_exceptions

3178: a_item_id(i),
3179: a_exception_type(i),
3180: a_exception_group(i));
3181: IF (l_exist = 1) THEN
3182: update msc_item_exceptions
3183: set exception_count = exception_count + 1,
3184: last_update_date = sysdate
3185: where plan_id = G_PLAN_ID
3186: and company_id = a_company_id(i)

Line 3195: insert into msc_item_exceptions( plan_id,

3191: and version = 0;
3192:
3193:
3194: ELSE
3195: insert into msc_item_exceptions( plan_id,
3196: sr_instance_id,
3197: company_id,
3198: company_site_id,
3199: organization_id,

Line 3380: update msc_item_exceptions ex

3376: --FND_FILE.PUT_LINE(FND_FILE.LOG,'delete trx ' || t_trxid1_list(i) || '-' || t_count1(i));
3377: END LOOP;
3378:
3379: FORALL i in 1..t_item_list.COUNT
3380: update msc_item_exceptions ex
3381: set ex.exception_count = ex.exception_count - t_count1(i),
3382: ex.last_update_date = sysdate
3383: where ex.plan_id = G_PLAN_ID
3384: and ex.company_id = t_company_list(i)

Line 3421: update msc_item_exceptions ex

3417: --FND_FILE.PUT_LINE(FND_FILE.LOG,'delete date ' || t_date1_list(i) || '-' || t_count2(i));
3418: END LOOP;
3419:
3420: FORALL i in 1..t_item_list.COUNT
3421: update msc_item_exceptions ex
3422: set ex.exception_count = ex.exception_count - t_count2(i),
3423: ex.last_update_date = sysdate
3424: where ex.plan_id = G_PLAN_ID
3425: and ex.company_id = t_company_list(i)

Line 3460: update msc_item_exceptions ex

3456: --FND_FILE.PUT_LINE(FND_FILE.LOG,'delete date ' || t_type_list(i) || '-' || t_count3(i));
3457: END LOOP;
3458:
3459: FORALL i in 1..t_item_list.COUNT
3460: update msc_item_exceptions ex
3461: set ex.exception_count = ex.exception_count - t_count3(i),
3462: ex.last_update_date = sysdate
3463: where ex.plan_id = G_PLAN_ID
3464: and ex.company_id = t_company_list(i)

Line 3497: update msc_item_exceptions ex

3493: --dbms_output.put_line('delete trx ex: ' || t_trxid1_list(i) || '-' || t_count1(i) || '-' || t_type_list(i));
3494: END LOOP;
3495:
3496: FORALL i in 1..t_item_list.COUNT
3497: update msc_item_exceptions ex
3498: set ex.exception_count = ex.exception_count - t_count1(i),
3499: ex.last_update_date = sysdate
3500: where ex.plan_id = G_PLAN_ID
3501: and ex.company_id = t_company_list(i)