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_CL_DEMAND_ODS_LOAD dependencies on MSC_RESERVATIONS

Line 2779: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESERVATIONS', MSC_CL_COLLECTION.v_instance_id, -1);

2775:
2776: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
2777: -- We want to delete all HARD_RESERV related data and get new stuff.
2778:
2779: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESERVATIONS', MSC_CL_COLLECTION.v_instance_id, -1);
2780:
2781: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
2782: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESERVATIONS', MSC_CL_COLLECTION.v_instance_id, -1);
2783: ELSE

Line 2782: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESERVATIONS', MSC_CL_COLLECTION.v_instance_id, -1);

2778:
2779: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESERVATIONS', MSC_CL_COLLECTION.v_instance_id, -1);
2780:
2781: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
2782: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESERVATIONS', MSC_CL_COLLECTION.v_instance_id, -1);
2783: ELSE
2784: MSC_CL_COLLECTION.v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
2785: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESERVATIONS', MSC_CL_COLLECTION.v_instance_id, -1,MSC_CL_COLLECTION.v_sub_str);
2786: END IF;

Line 2785: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESERVATIONS', MSC_CL_COLLECTION.v_instance_id, -1,MSC_CL_COLLECTION.v_sub_str);

2781: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
2782: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESERVATIONS', MSC_CL_COLLECTION.v_instance_id, -1);
2783: ELSE
2784: MSC_CL_COLLECTION.v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
2785: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESERVATIONS', MSC_CL_COLLECTION.v_instance_id, -1,MSC_CL_COLLECTION.v_sub_str);
2786: END IF;
2787:
2788: END IF;
2789:

Line 2794: UPDATE MSC_RESERVATIONS

2790: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
2791:
2792: /* FOR c_rec IN c1_d LOOP
2793:
2794: UPDATE MSC_RESERVATIONS
2795: SET RESERVED_QUANTITY= 0,
2796: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
2797: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
2798: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

Line 2811: Delete from msc_reservations

2807:
2808: If c_rec.supply_source_type_id = 86 then
2809:
2810:
2811: Delete from msc_reservations
2812: Where
2813: ((reservation_type = 5 and organization_id = c_rec.organization_id) or reservation_type = 7)
2814: And sr_instance_id =c_rec.SR_INSTANCE_ID
2815: And plan_id =-1

Line 2820: Delete from msc_reservations

2816: And REPAIR_PO_HEADER_ID =c_rec.transaction_id ;
2817:
2818: Elsif c_rec.supply_source_type_id = 1 then
2819:
2820: Delete from msc_reservations
2821: Where sr_instance_id =c_rec.SR_INSTANCE_ID
2822: And plan_id =-1
2823: And ((disposition_id =c_rec.transaction_id and reservation_type = 5 and organization_id = c_rec.organization_id and disposition_type =1 )
2824: Or (transaction_id =c_rec.transaction_id and reservation_type = 7));

Line 2828: Delete from msc_reservations

2824: Or (transaction_id =c_rec.transaction_id and reservation_type = 7));
2825:
2826: Elsif c_rec.supply_source_type_id = 7 then
2827:
2828: Delete from msc_reservations
2829: Where sr_instance_id =c_rec.SR_INSTANCE_ID
2830: And plan_id =-1
2831: And transaction_id =c_rec.transaction_id
2832: And reservation_type = 4;

Line 2836: Delete from msc_reservations

2832: And reservation_type = 4;
2833:
2834: Elsif c_rec.supply_source_type_id = 200 then
2835:
2836: Delete from msc_reservations
2837: Where sr_instance_id =c_rec.SR_INSTANCE_ID
2838: And plan_id =-1
2839: And ((disposition_id =c_rec.transaction_id and reservation_type = 4 and disposition_type =200 and organization_id = c_rec.organization_id)
2840: Or (transaction_id =c_rec.transaction_id and reservation_type = 3));

Line 2846: Delete from msc_reservations

2842:
2843:
2844: Elsif c_rec.supply_source_type_id = 2 then
2845:
2846: Delete from msc_reservations
2847: Where sr_instance_id =c_rec.SR_INSTANCE_ID
2848: And plan_id =-1
2849: And disposition_id =c_rec.transaction_id
2850: And reservation_type in (7,3)

Line 2856: Delete from msc_reservations

2852: And organization_id = c_rec.organization_id ;
2853:
2854: Elsif c_rec.supply_source_type_id = 5 then
2855:
2856: Delete from msc_reservations
2857: Where sr_instance_id =c_rec.SR_INSTANCE_ID
2858: And plan_id =-1
2859: And transaction_id/2 = c_rec.transaction_id
2860: And reservation_type = 5 ;

Line 2866: UPDATE MSC_RESERVATIONS

2862: Else
2863:
2864: -- IF c_rec.supply_source_type_id IS NULL AND c_rec.reservation_type is NULL THEN
2865:
2866: UPDATE MSC_RESERVATIONS
2867: SET RESERVED_QUANTITY= 0,
2868: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
2869: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
2870: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

Line 2891: UPDATE MSC_RESERVATIONS

2887: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
2888:
2889:
2890:
2891: UPDATE MSC_RESERVATIONS
2892: SET
2893: INVENTORY_ITEM_ID= c_rec.INVENTORY_ITEM_ID,
2894: ORGANIZATION_ID= c_rec.ORGANIZATION_ID,
2895: DEMAND_CLASS= c_rec.DEMAND_CLASS,

Line 2923: insert into MSC_RESERVATIONS

2919: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN
2920:
2921:
2922:
2923: insert into MSC_RESERVATIONS
2924: ( TRANSACTION_ID,
2925: INVENTORY_ITEM_ID,
2926: ORGANIZATION_ID,
2927: PLAN_ID,

Line 2991: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESERVATIONS');

2987:
2988: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2989: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2990: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_HARD_RESERVATION');
2991: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESERVATIONS');
2992: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2993:
2994: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2995: RAISE;

Line 3004: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESERVATIONS');

3000:
3001: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3002: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3003: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_HARD_RESERVATION');
3004: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESERVATIONS');
3005: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3006:
3007: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3008: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');