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_WS_APS_DATA_SERVICES dependencies on MSC_PLANS

Line 53: -- 02098 - UPLOAD_PLANNED_SUPPLY/ check msc_plans.plan_completion_date

49: -- 02052 - UPLOAD_PLANNED_SUPPLY/ProcessPlannedSupply/ organization id
50: -- 02053 - UPLOAD_PLANNED_SUPPLY/ProcessPlannedSupply/ item id
51: -- 02054 - UPLOAD_PLANNED_SUPPLY/ProcessPlannedSupply/InsertPlannedSupply
52:
53: -- 02098 - UPLOAD_PLANNED_SUPPLY/ check msc_plans.plan_completion_date
54: -- 02099 - UPLOAD_SAFETY_STOCKS/ check msc_plans.plan_completion_date
55: -- =============================================================
56:
57:

Line 54: -- 02099 - UPLOAD_SAFETY_STOCKS/ check msc_plans.plan_completion_date

50: -- 02053 - UPLOAD_PLANNED_SUPPLY/ProcessPlannedSupply/ item id
51: -- 02054 - UPLOAD_PLANNED_SUPPLY/ProcessPlannedSupply/InsertPlannedSupply
52:
53: -- 02098 - UPLOAD_PLANNED_SUPPLY/ check msc_plans.plan_completion_date
54: -- 02099 - UPLOAD_SAFETY_STOCKS/ check msc_plans.plan_completion_date
55: -- =============================================================
56:
57:
58:

Line 1568: FROM msc_plans

1564: BEGIN
1565: BEGIN
1566: SELECT plan_id
1567: INTO PlanId
1568: FROM msc_plans
1569: WHERE
1570: organization_id = OwningOrgId AND
1571: compile_designator = PlanName AND
1572: sr_instance_id = SrInstanceId;

Line 2143: FROM msc_plans

2139: l_Dummy NUMBER;
2140: BEGIN
2141: BEGIN
2142: SELECT 1 INTO l_Dummy
2143: FROM msc_plans
2144: WHERE
2145: curr_plan_type IN (1, 2, 3) AND
2146: plan_id = PlanId;
2147: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 2671: -- PlanName Plan name, use this + OwningOrgId + SrInstanceId to guery plan_id from msc_plans.

2667: -- RespName Responsibility name.
2668: -- RespAppName Responsibility application name.
2669: -- SecurityGroupName Security group name.
2670: -- Language Language.
2671: -- PlanName Plan name, use this + OwningOrgId + SrInstanceId to guery plan_id from msc_plans.
2672: -- OwningOrgId Owning organization id for the plan.
2673: -- SrInstanceId Source instance id.
2674: -- PurgeAllFlag Allowed input is Y or N.
2675: -- If this parameter is set to Y, this operation will delete

Line 2764: Richard, I don't think we should check the msc_plans.plan_completion_date.

2760: RETURN;
2761: END IF;
2762:
2763: /*
2764: Richard, I don't think we should check the msc_plans.plan_completion_date.
2765: The plan_completion_date is always null for new plans until they are ran.
2766: We cannot detect any ASCP plan is running and using SS from this IO plan.
2767: BEGIN
2768: SELECT plan_completion_date INTO l_Date

Line 2769: FROM msc_plans

2765: The plan_completion_date is always null for new plans until they are ran.
2766: We cannot detect any ASCP plan is running and using SS from this IO plan.
2767: BEGIN
2768: SELECT plan_completion_date INTO l_Date
2769: FROM msc_plans
2770: WHERE plan_id = l_PlanId;
2771: EXCEPTION WHEN others THEN
2772: g_ErrorCode := 'ERROR_UNEXPECTED_02099';
2773: raise;

Line 2846: -- PlanName Plan name, use this + OwningOrgId + SrInstanceId to guery plan_id from msc_plans.

2842: -- RespName Responsibility name.
2843: -- RespAppName Responsibility application name.
2844: -- SecurityGroupName Security group name.
2845: -- Language Language.
2846: -- PlanName Plan name, use this + OwningOrgId + SrInstanceId to guery plan_id from msc_plans.
2847: -- OwningOrgId Owning organization id for the plan.
2848: -- SrInstanceId Source instance id.
2849: -- ItemIdList List of item Ids.
2850: -- OrganizationIdList List of organization Ids

Line 2951: -- PlanName Plan name, use this + OwningOrgId + SrInstanceId to guery plan_id from msc_plans.

2947: -- RespName Responsibility name.
2948: -- RespAppName Responsibility application name.
2949: -- SecurityGroupName Security group name.
2950: -- Language Language.
2951: -- PlanName Plan name, use this + OwningOrgId + SrInstanceId to guery plan_id from msc_plans.
2952: -- OwningOrgId Owning organization id for the plan.
2953: -- SrInstanceId Source instance id.
2954: -- PlannedSupplyTbl List of safety stocks to be uploaded to msc_supplies.
2955: -- OrganizationId Organization id.

Line 3033: Richard, I don't think we should check the msc_plans.plan_completion_date.

3029:
3030: -- No need to check SrInstanceId. GetPlanId should catch this.
3031:
3032: /*
3033: Richard, I don't think we should check the msc_plans.plan_completion_date.
3034: 1) The plan_completion_date is always null for new plans until they are ran.
3035: 2) Consultant will run the ASCP plan after the upload.
3036: BEGIN
3037: SELECT plan_completion_date INTO l_CompletionDate

Line 3038: FROM msc_plans

3034: 1) The plan_completion_date is always null for new plans until they are ran.
3035: 2) Consultant will run the ASCP plan after the upload.
3036: BEGIN
3037: SELECT plan_completion_date INTO l_CompletionDate
3038: FROM msc_plans
3039: WHERE plan_id = l_PlanId;
3040: EXCEPTION WHEN others THEN
3041: g_ErrorCode := 'ERROR_UNEXPECTED_02098';
3042: raise;

Line 3044: -- Richard, can callers re-set the msc_plans.plan_completion_date?

3040: EXCEPTION WHEN others THEN
3041: g_ErrorCode := 'ERROR_UNEXPECTED_02098';
3042: raise;
3043: END;
3044: -- Richard, can callers re-set the msc_plans.plan_completion_date?
3045: IF l_CompletionDate IS NULL THEN
3046: Status := 'PLAN_IS_NOT_READY';
3047: RETURN;
3048: END IF;