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.QA_SOLUTION_DISPOSITION_PKG dependencies on STANDARD

Line 55: -- API name REWORK_NEW_NONSTANDARD_JOB

51: -------------------------------------------------------------------------------
52: -- Create a New Work Order API
53: -------------------------------------------------------------------------------
54: -- Start of Comments
55: -- API name REWORK_NEW_NONSTANDARD_JOB
56: -- Type Public
57: -- Function
58: --
59: -- Pre-reqs

Line 92: -- 2. Call REWORK_NEW_NONSTANDARD_JOB_INT() procedure for inserting into interface table

88: --
89: -- We are performing all the below activities here
90: --
91: -- 1. Get the different id values.
92: -- 2. Call REWORK_NEW_NONSTANDARD_JOB_INT() procedure for inserting into interface table
93: -- and spawn the WIP Mass Load Program (WICMLX).
94: -- 3. Wait for the Mass Load Program to get completed.
95: -- 4. Get the results and perform the handshaking. Call the procedure
96: -- WRITE_BACK() for performing the same.

Line 119: PROCEDURE REWORK_NEW_NONSTANDARD_JOB(

115: --
116: --
117:
118:
119: PROCEDURE REWORK_NEW_NONSTANDARD_JOB(
120: p_item IN VARCHAR2,
121: p_job_class IN VARCHAR2,
122: p_job_name IN VARCHAR2,
123: p_job_start IN VARCHAR2,

Line 255: l_request := REWORK_NEW_NONSTANDARD_JOB_INT(

251:
252: -- Bug 2720431. Added p_job_mrp_net_quantity. This parameter carries the value
253: -- for MRP Net Quantiy of the new rework Job. kabalakr.
254:
255: l_request := REWORK_NEW_NONSTANDARD_JOB_INT(
256: l_item_id,
257: l_group_id,
258: p_job_class,
259: p_job_name,

Line 369: END REWORK_NEW_NONSTANDARD_JOB;

365: );
366:
367: END IF; -- if complete.
368:
369: END REWORK_NEW_NONSTANDARD_JOB;
370:
371:
372: FUNCTION REWORK_NEW_NONSTANDARD_JOB_INT(
373: p_item_id NUMBER,

Line 372: FUNCTION REWORK_NEW_NONSTANDARD_JOB_INT(

368:
369: END REWORK_NEW_NONSTANDARD_JOB;
370:
371:
372: FUNCTION REWORK_NEW_NONSTANDARD_JOB_INT(
373: p_item_id NUMBER,
374: p_group_id NUMBER,
375: p_jclass VARCHAR2,
376: p_job_name VARCHAR2,

Line 488: END REWORK_NEW_NONSTANDARD_JOB_INT;

484: COMMIT;
485:
486: RETURN l_request_id;
487:
488: END REWORK_NEW_NONSTANDARD_JOB_INT;
489:
490:
491:
492: -------------------------------------------------------------------------------

Line 2777: -- p_department_code => Department Code for NON Standard Operation.

2773: -- Parameters
2774: -- p_job_name => Name of the Rework Job to be created
2775: -- p_op_seq_num => Rework Operation Sequence Number
2776: -- p_operation_code => Rework Operation Code
2777: -- p_department_code => Department Code for NON Standard Operation.
2778: -- p_res_seq_num => Resource Sequence Number to add resources to NON
2779: -- Standard Operations.
2780: -- p_resource_code => Resource Code to add resources to NON Standard Operations.
2781: -- p_assigned_units => Assigned units for the resource.

Line 2779: -- Standard Operations.

2775: -- p_op_seq_num => Rework Operation Sequence Number
2776: -- p_operation_code => Rework Operation Code
2777: -- p_department_code => Department Code for NON Standard Operation.
2778: -- p_res_seq_num => Resource Sequence Number to add resources to NON
2779: -- Standard Operations.
2780: -- p_resource_code => Resource Code to add resources to NON Standard Operations.
2781: -- p_assigned_units => Assigned units for the resource.
2782: -- p_usage_rate => Usage rate of resources.
2783: -- p_start_date => First Unit Start date and First unit completion date.

Line 2780: -- p_resource_code => Resource Code to add resources to NON Standard Operations.

2776: -- p_operation_code => Rework Operation Code
2777: -- p_department_code => Department Code for NON Standard Operation.
2778: -- p_res_seq_num => Resource Sequence Number to add resources to NON
2779: -- Standard Operations.
2780: -- p_resource_code => Resource Code to add resources to NON Standard Operations.
2781: -- p_assigned_units => Assigned units for the resource.
2782: -- p_usage_rate => Usage rate of resources.
2783: -- p_start_date => First Unit Start date and First unit completion date.
2784: -- p_end_date => Last Unit Start date and Last unit completion date.

Line 2803: -- and spawn the WIP Mass Load Program (WICMLX) for adding Standard and NON

2799: -- We are performing all the below activities here
2800: --
2801: -- 1. Get the different id values.
2802: -- 2. Call REWORK_OP_ADD_OP_INT() procedure for inserting into interface table
2803: -- and spawn the WIP Mass Load Program (WICMLX) for adding Standard and NON
2804: -- Standard operations.
2805: -- 3. Wait for the Mass Load Program to get completed.
2806: -- 4. Get the results and perform the handshaking. Call the procedure
2807: -- WRITE_BACK() for performing the same.

Line 2804: -- Standard operations.

2800: --
2801: -- 1. Get the different id values.
2802: -- 2. Call REWORK_OP_ADD_OP_INT() procedure for inserting into interface table
2803: -- and spawn the WIP Mass Load Program (WICMLX) for adding Standard and NON
2804: -- Standard operations.
2805: -- 3. Wait for the Mass Load Program to get completed.
2806: -- 4. Get the results and perform the handshaking. Call the procedure
2807: -- WRITE_BACK() for performing the same.
2808: -- 5. Call REWORK_OP_ADD_RES_INT() procedure for inserting into interface table

Line 2810: -- for Standard Operations and adding specified resources for specified NON

2806: -- 4. Get the results and perform the handshaking. Call the procedure
2807: -- WRITE_BACK() for performing the same.
2808: -- 5. Call REWORK_OP_ADD_RES_INT() procedure for inserting into interface table
2809: -- and spawn the WIP Mass Load Program (WICMLX) for automatic adding of resources
2810: -- for Standard Operations and adding specified resources for specified NON
2811: -- Standard operations.
2812: -- 6. Wait for the Mass Load Program to get completed.
2813: -- 7. Get the results and perform the handshaking. Call the procedure
2814: -- WRITE_BACK() for performing the same.

Line 2811: -- Standard operations.

2807: -- WRITE_BACK() for performing the same.
2808: -- 5. Call REWORK_OP_ADD_RES_INT() procedure for inserting into interface table
2809: -- and spawn the WIP Mass Load Program (WICMLX) for automatic adding of resources
2810: -- for Standard Operations and adding specified resources for specified NON
2811: -- Standard operations.
2812: -- 6. Wait for the Mass Load Program to get completed.
2813: -- 7. Get the results and perform the handshaking. Call the procedure
2814: -- WRITE_BACK() for performing the same.
2815: --

Line 2895: SELECT bsoav.standard_operation_id

2891: WHERE wip_entity_name = p_job_name
2892: AND organization_id = l_organization_id;
2893:
2894: CURSOR op_cur IS
2895: SELECT bsoav.standard_operation_id
2896: FROM bom_standard_operations_all_v bsoav, bom_departments_val_v bdvv
2897: WHERE bsoav.organization_id = l_organization_id
2898: AND bsoav.department_id = bdvv.department_id
2899: AND NVL (bsoav.operation_type, 1) = 1

Line 2896: FROM bom_standard_operations_all_v bsoav, bom_departments_val_v bdvv

2892: AND organization_id = l_organization_id;
2893:
2894: CURSOR op_cur IS
2895: SELECT bsoav.standard_operation_id
2896: FROM bom_standard_operations_all_v bsoav, bom_departments_val_v bdvv
2897: WHERE bsoav.organization_id = l_organization_id
2898: AND bsoav.department_id = bdvv.department_id
2899: AND NVL (bsoav.operation_type, 1) = 1
2900: AND bsoav.operation_code = p_operation_code;

Line 2998: -- its a standard Operation. If Operation Code is not mentioned, user is

2994: FETCH job_status INTO l_status_type;
2995: CLOSE job_status;
2996:
2997: -- Validate the Rework Operation Sequence Num. If Operation code is specified,
2998: -- its a standard Operation. If Operation Code is not mentioned, user is
2999: -- intending to add NON Standard Operation OR to add just resource to the
3000: -- existing Operation Sequence Number.
3001:
3002: OPEN op_seq_cur;

Line 2999: -- intending to add NON Standard Operation OR to add just resource to the

2995: CLOSE job_status;
2996:
2997: -- Validate the Rework Operation Sequence Num. If Operation code is specified,
2998: -- its a standard Operation. If Operation Code is not mentioned, user is
2999: -- intending to add NON Standard Operation OR to add just resource to the
3000: -- existing Operation Sequence Number.
3001:
3002: OPEN op_seq_cur;
3003: FETCH op_seq_cur INTO l_dup_op_seq;

Line 3008: -- specified, user is intending to add a standard Operation with Duplicate

3004: CLOSE op_seq_cur;
3005:
3006:
3007: -- If Operation Seq Num is already existing and the Operation code is
3008: -- specified, user is intending to add a standard Operation with Duplicate
3009: -- Operation Seq Num. So error out.
3010:
3011: IF (l_dup_op_seq IS NOT NULL) AND (p_operation_code IS NOT NULL) THEN
3012: l_result := g_int_err;

Line 3050: -- A value of 1 in l_op_type means, its standard operation.

3046: -- operation, otherwise just add the Operation Seq Num with Department details.
3047:
3048: IF (p_operation_code IS NOT NULL) THEN
3049:
3050: -- A value of 1 in l_op_type means, its standard operation.
3051: l_op_type := 1;
3052:
3053: OPEN op_cur;
3054: FETCH op_cur INTO l_operation_id;

Line 3185: -- of Resource. For Standard Operations. all the resources will be added

3181: END IF; -- l_dup_op_seq IS NULL.
3182:
3183: -- Call REWORK_OP_ADD_RES_INT procedure for Adding Resources. It returns the
3184: -- WIP Mass Load Concurrent Request Id launched for processing the Addition
3185: -- of Resource. For Standard Operations. all the resources will be added
3186: -- together. For Non Standard Operation, only one resource will be added at
3187: -- a time.
3188: -- The parameter p_op_type decides internally whether the resources are being
3189: -- added for s Standard Operation (1) or NON standard operation (2).

Line 3186: -- together. For Non Standard Operation, only one resource will be added at

3182:
3183: -- Call REWORK_OP_ADD_RES_INT procedure for Adding Resources. It returns the
3184: -- WIP Mass Load Concurrent Request Id launched for processing the Addition
3185: -- of Resource. For Standard Operations. all the resources will be added
3186: -- together. For Non Standard Operation, only one resource will be added at
3187: -- a time.
3188: -- The parameter p_op_type decides internally whether the resources are being
3189: -- added for s Standard Operation (1) or NON standard operation (2).
3190:

Line 3189: -- added for s Standard Operation (1) or NON standard operation (2).

3185: -- of Resource. For Standard Operations. all the resources will be added
3186: -- together. For Non Standard Operation, only one resource will be added at
3187: -- a time.
3188: -- The parameter p_op_type decides internally whether the resources are being
3189: -- added for s Standard Operation (1) or NON standard operation (2).
3190:
3191: -- Get the new group_id from the Sequence for Adding Resources.
3192: OPEN group_cur;
3193: FETCH group_cur INTO l_group_id;

Line 3332: FROM bom_departments bdp, bom_standard_operations bso

3328:
3329: CURSOR op_det IS
3330: SELECT bdp.department_id, nvl(bso.count_point_type, 1) count_point_type,
3331: bso.backflush_flag, nvl(bso.minimum_transfer_quantity, 0) minimum_transfer_quantity
3332: FROM bom_departments bdp, bom_standard_operations bso
3333: WHERE bso.organization_id = p_organization_id
3334: AND bso.line_id is null
3335: AND nvl(bso.operation_type,1) = 1
3336: AND bdp.organization_id = p_organization_id

Line 3339: AND bso.standard_operation_id = p_operation_id;

3335: AND nvl(bso.operation_type,1) = 1
3336: AND bdp.organization_id = p_organization_id
3337: AND bso.department_id = bdp.department_id
3338: AND nvl(bdp.disable_date, sysdate + 2) > sysdate
3339: AND bso.standard_operation_id = p_operation_id;
3340:
3341:
3342: BEGIN
3343:

Line 3423: STANDARD_OPERATION_ID,

3419: LAST_UPDATED_BY,
3420: CREATION_DATE,
3421: CREATED_BY,
3422: PARENT_HEADER_ID,
3423: STANDARD_OPERATION_ID,
3424: FIRST_UNIT_START_DATE,
3425: FIRST_UNIT_COMPLETION_DATE,
3426: LAST_UNIT_START_DATE,
3427: LAST_UNIT_COMPLETION_DATE,

Line 3524: bsor.standard_rate_flag, bsor.usage_rate_or_amount,

3520:
3521: CURSOR res_det IS
3522: SELECT bsor.resource_seq_num, bsor.resource_id, bsor.activity_id,
3523: bsor.assigned_units, bsor.basis_type, bsor.schedule_flag,
3524: bsor.standard_rate_flag, bsor.usage_rate_or_amount,
3525: bsor.autocharge_type, br.unit_of_measure
3526: FROM bom_std_op_resources bsor, bom_resources br
3527: WHERE bsor.resource_id = br.resource_id
3528: AND bsor.standard_operation_id = p_operation_id;

Line 3528: AND bsor.standard_operation_id = p_operation_id;

3524: bsor.standard_rate_flag, bsor.usage_rate_or_amount,
3525: bsor.autocharge_type, br.unit_of_measure
3526: FROM bom_std_op_resources bsor, bom_resources br
3527: WHERE bsor.resource_id = br.resource_id
3528: AND bsor.standard_operation_id = p_operation_id;
3529:
3530:
3531: CURSOR m_res_det IS
3532: SELECT res.unit_of_measure, nvl(res.default_basis_type,1) basis_type,

Line 3535: nvl(res.standard_rate_flag,1) standard_rate_flag

3531: CURSOR m_res_det IS
3532: SELECT res.unit_of_measure, nvl(res.default_basis_type,1) basis_type,
3533: 2 "scheduled_flag", res.default_activity_id,
3534: nvl(res.autocharge_type, 1) autocharge_type,
3535: nvl(res.standard_rate_flag,1) standard_rate_flag
3536: FROM bom_resources res, bom_department_resources bdr
3537: WHERE res.organization_id = p_organization_id
3538: AND nvl(res.disable_date, sysdate + 2) > sysdate
3539: AND res.resource_id = bdr.resource_id

Line 3621: STANDARD_RATE_FLAG,

3617: BASIS_TYPE,
3618: RESOURCE_ID_NEW,
3619: RESOURCE_SEQ_NUM,
3620: SCHEDULED_FLAG,
3621: STANDARD_RATE_FLAG,
3622: USAGE_RATE_OR_AMOUNT,
3623: UOM_CODE
3624: )
3625: VALUES

Line 3686: STANDARD_RATE_FLAG,

3682: BASIS_TYPE,
3683: RESOURCE_ID_NEW,
3684: RESOURCE_SEQ_NUM,
3685: SCHEDULED_FLAG,
3686: STANDARD_RATE_FLAG,
3687: USAGE_RATE_OR_AMOUNT,
3688: UOM_CODE
3689: )
3690: VALUES