[Home] [Help]
334:
335: PROCEDURE Insert_Resources(X_Wip_Entity_Id NUMBER,
336: X_Organization_Id NUMBER,
337: X_Operation_Seq_Num NUMBER,
338: X_Standard_Operation_Id NUMBER,
339: X_Repetitive_Schedule_Id NUMBER,
340: X_Last_Updated_By NUMBER,
341: X_Created_By NUMBER,
342: X_Last_Update_Login NUMBER,
357: RESOURCE_ID, UOM_CODE,
358: BASIS_TYPE, USAGE_RATE_OR_AMOUNT,
359: ACTIVITY_ID, SCHEDULED_FLAG,
360: ASSIGNED_UNITS, AUTOCHARGE_TYPE,
361: STANDARD_RATE_FLAG, APPLIED_RESOURCE_UNITS,
362: APPLIED_RESOURCE_VALUE, START_DATE,
363: COMPLETION_DATE, ATTRIBUTE_CATEGORY,
364: ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3,
365: ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6,
375: S.RESOURCE_ID, R.UNIT_OF_MEASURE,
376: S.BASIS_TYPE, S.USAGE_RATE_OR_AMOUNT,
377: S.ACTIVITY_ID, S.SCHEDULE_FLAG,
378: S.ASSIGNED_UNITS, S.AUTOCHARGE_TYPE,
379: S.STANDARD_RATE_FLAG, 0,
380: 0,
381: DECODE(X_Start_Date, NULL, SYSDATE, X_Start_Date),
382: DECODE(X_Completion_Date, NULL, SYSDATE, X_Completion_Date),
383: S.ATTRIBUTE_CATEGORY,
388: S.ATTRIBUTE13, S.ATTRIBUTE14, S.ATTRIBUTE15,
389: S.SUBSTITUTE_GROUP_NUM, S.RESOURCE_SEQ_NUM ,0 --/* Added : -- bug 7371859
390: FROM BOM_STD_OP_RESOURCES S,
391: BOM_RESOURCES R
392: WHERE S.STANDARD_OPERATION_ID = X_Standard_Operation_Id
393: AND R.RESOURCE_ID = S.RESOURCE_ID
394: AND NVL(R.DISABLE_DATE, SYSDATE + 1) > SYSDATE;
395:
396: /* Added : - bug 7371859 */
397: BEGIN
398: SELECT count(*)
399: INTO sub_res_count
400: FROM BOM_STD_SUB_OP_RESOURCES BSSOR
401: WHERE BSSOR.STANDARD_OPERATION_ID=X_Standard_Operation_Id;
402: EXCEPTION
403: WHEN no_data_found THEN
404: null;
405: END ;
436: scheduled_flag,
437: assigned_units,
438: maximum_assigned_units,
439: autocharge_type,
440: standard_rate_flag,
441: applied_resource_units,
442: applied_resource_value,
443: attribute_category,
444: attribute1,
480: BSSOR.schedule_flag,
481: BSSOR.assigned_units,
482: BSSOR.assigned_units,
483: BSSOR.autocharge_type,
484: BSSOR.standard_rate_flag,
485: 0, --WCOR.applied_resource_units,
486: 0, -- WCOR.applied_resource_value,
487: BSSOR.attribute_category,
488: BSSOR.attribute1,
507: BSSOR.replacement_group_num,
508: NULL --setup_id
509: FROM BOM_RESOURCES BR,
510: BOM_STD_SUB_OP_RESOURCES BSSOR
511: where bssor.standard_operation_id=X_Standard_Operation_Id
512: and BSSOR.RESOURCE_ID = BR.RESOURCE_ID;
513:
514: End IF;
515: /* End : -- bug 7371859 */
516:
517:
518: END Insert_Resources;
519:
520: -- Counts the number of resources per standard operation --
521: FUNCTION Num_Standard_Resources(X_Organization_Id NUMBER,
522: X_Standard_Operation_Id NUMBER)
523: RETURN NUMBER IS
524: P_Num_Resources NUMBER;
517:
518: END Insert_Resources;
519:
520: -- Counts the number of resources per standard operation --
521: FUNCTION Num_Standard_Resources(X_Organization_Id NUMBER,
522: X_Standard_Operation_Id NUMBER)
523: RETURN NUMBER IS
524: P_Num_Resources NUMBER;
525: BEGIN
518: END Insert_Resources;
519:
520: -- Counts the number of resources per standard operation --
521: FUNCTION Num_Standard_Resources(X_Organization_Id NUMBER,
522: X_Standard_Operation_Id NUMBER)
523: RETURN NUMBER IS
524: P_Num_Resources NUMBER;
525: BEGIN
526: SELECT COUNT(R.RESOURCE_ID)
526: SELECT COUNT(R.RESOURCE_ID)
527: INTO P_Num_Resources
528: FROM BOM_STD_OP_RESOURCES S,
529: BOM_RESOURCES R
530: WHERE S.STANDARD_OPERATION_ID = X_Standard_Operation_Id
531: AND R.ORGANIZATION_ID = X_Organization_Id
532: AND R.RESOURCE_ID = S.RESOURCE_ID
533: AND NVL(R.DISABLE_DATE, SYSDATE + 1) > SYSDATE;
534: RETURN P_Num_Resources;
531: AND R.ORGANIZATION_ID = X_Organization_Id
532: AND R.RESOURCE_ID = S.RESOURCE_ID
533: AND NVL(R.DISABLE_DATE, SYSDATE + 1) > SYSDATE;
534: RETURN P_Num_Resources;
535: END Num_Standard_Resources;
536:
537: /* Note: This routine is called from two places:
538: 1) When an Operation is Deleted
539: 2) When the routing of a job/schedule is updated