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 2793: -- p_department_code => Department Code for NON Standard Operation.

2789: -- Parameters
2790: -- p_job_name => Name of the Rework Job to be created
2791: -- p_op_seq_num => Rework Operation Sequence Number
2792: -- p_operation_code => Rework Operation Code
2793: -- p_department_code => Department Code for NON Standard Operation.
2794: -- p_res_seq_num => Resource Sequence Number to add resources to NON
2795: -- Standard Operations.
2796: -- p_resource_code => Resource Code to add resources to NON Standard Operations.
2797: -- p_assigned_units => Assigned units for the resource.

Line 2795: -- Standard Operations.

2791: -- p_op_seq_num => Rework Operation Sequence Number
2792: -- p_operation_code => Rework Operation Code
2793: -- p_department_code => Department Code for NON Standard Operation.
2794: -- p_res_seq_num => Resource Sequence Number to add resources to NON
2795: -- Standard Operations.
2796: -- p_resource_code => Resource Code to add resources to NON Standard Operations.
2797: -- p_assigned_units => Assigned units for the resource.
2798: -- p_usage_rate => Usage rate of resources.
2799: -- p_start_date => First Unit Start date and First unit completion date.

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

2792: -- p_operation_code => Rework Operation Code
2793: -- p_department_code => Department Code for NON Standard Operation.
2794: -- p_res_seq_num => Resource Sequence Number to add resources to NON
2795: -- Standard Operations.
2796: -- p_resource_code => Resource Code to add resources to NON Standard Operations.
2797: -- p_assigned_units => Assigned units for the resource.
2798: -- p_usage_rate => Usage rate of resources.
2799: -- p_start_date => First Unit Start date and First unit completion date.
2800: -- p_end_date => Last Unit Start date and Last unit completion date.

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

2815: -- We are performing all the below activities here
2816: --
2817: -- 1. Get the different id values.
2818: -- 2. Call REWORK_OP_ADD_OP_INT() procedure for inserting into interface table
2819: -- and spawn the WIP Mass Load Program (WICMLX) for adding Standard and NON
2820: -- Standard operations.
2821: -- 3. Wait for the Mass Load Program to get completed.
2822: -- 4. Get the results and perform the handshaking. Call the procedure
2823: -- WRITE_BACK() for performing the same.

Line 2820: -- Standard operations.

2816: --
2817: -- 1. Get the different id values.
2818: -- 2. Call REWORK_OP_ADD_OP_INT() procedure for inserting into interface table
2819: -- and spawn the WIP Mass Load Program (WICMLX) for adding Standard and NON
2820: -- Standard operations.
2821: -- 3. Wait for the Mass Load Program to get completed.
2822: -- 4. Get the results and perform the handshaking. Call the procedure
2823: -- WRITE_BACK() for performing the same.
2824: -- 5. Call REWORK_OP_ADD_RES_INT() procedure for inserting into interface table

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

2822: -- 4. Get the results and perform the handshaking. Call the procedure
2823: -- WRITE_BACK() for performing the same.
2824: -- 5. Call REWORK_OP_ADD_RES_INT() procedure for inserting into interface table
2825: -- and spawn the WIP Mass Load Program (WICMLX) for automatic adding of resources
2826: -- for Standard Operations and adding specified resources for specified NON
2827: -- Standard operations.
2828: -- 6. Wait for the Mass Load Program to get completed.
2829: -- 7. Get the results and perform the handshaking. Call the procedure
2830: -- WRITE_BACK() for performing the same.

Line 2827: -- Standard operations.

2823: -- WRITE_BACK() for performing the same.
2824: -- 5. Call REWORK_OP_ADD_RES_INT() procedure for inserting into interface table
2825: -- and spawn the WIP Mass Load Program (WICMLX) for automatic adding of resources
2826: -- for Standard Operations and adding specified resources for specified NON
2827: -- Standard operations.
2828: -- 6. Wait for the Mass Load Program to get completed.
2829: -- 7. Get the results and perform the handshaking. Call the procedure
2830: -- WRITE_BACK() for performing the same.
2831: --

Line 2911: SELECT bsoav.standard_operation_id

2907: WHERE wip_entity_name = p_job_name
2908: AND organization_id = l_organization_id;
2909:
2910: CURSOR op_cur IS
2911: SELECT bsoav.standard_operation_id
2912: FROM bom_standard_operations_all_v bsoav, bom_departments_val_v bdvv
2913: WHERE bsoav.organization_id = l_organization_id
2914: AND bsoav.department_id = bdvv.department_id
2915: AND NVL (bsoav.operation_type, 1) = 1

Line 2912: FROM bom_standard_operations_all_v bsoav, bom_departments_val_v bdvv

2908: AND organization_id = l_organization_id;
2909:
2910: CURSOR op_cur IS
2911: SELECT bsoav.standard_operation_id
2912: FROM bom_standard_operations_all_v bsoav, bom_departments_val_v bdvv
2913: WHERE bsoav.organization_id = l_organization_id
2914: AND bsoav.department_id = bdvv.department_id
2915: AND NVL (bsoav.operation_type, 1) = 1
2916: AND bsoav.operation_code = p_operation_code;

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

3010: FETCH job_status INTO l_status_type;
3011: CLOSE job_status;
3012:
3013: -- Validate the Rework Operation Sequence Num. If Operation code is specified,
3014: -- its a standard Operation. If Operation Code is not mentioned, user is
3015: -- intending to add NON Standard Operation OR to add just resource to the
3016: -- existing Operation Sequence Number.
3017:
3018: OPEN op_seq_cur;

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

3011: CLOSE job_status;
3012:
3013: -- Validate the Rework Operation Sequence Num. If Operation code is specified,
3014: -- its a standard Operation. If Operation Code is not mentioned, user is
3015: -- intending to add NON Standard Operation OR to add just resource to the
3016: -- existing Operation Sequence Number.
3017:
3018: OPEN op_seq_cur;
3019: FETCH op_seq_cur INTO l_dup_op_seq;

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

3020: CLOSE op_seq_cur;
3021:
3022:
3023: -- If Operation Seq Num is already existing and the Operation code is
3024: -- specified, user is intending to add a standard Operation with Duplicate
3025: -- Operation Seq Num. So error out.
3026:
3027: IF (l_dup_op_seq IS NOT NULL) AND (p_operation_code IS NOT NULL) THEN
3028: l_result := g_int_err;

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

3062: -- operation, otherwise just add the Operation Seq Num with Department details.
3063:
3064: IF (p_operation_code IS NOT NULL) THEN
3065:
3066: -- A value of 1 in l_op_type means, its standard operation.
3067: l_op_type := 1;
3068:
3069: OPEN op_cur;
3070: FETCH op_cur INTO l_operation_id;

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

3197: END IF; -- l_dup_op_seq IS NULL.
3198:
3199: -- Call REWORK_OP_ADD_RES_INT procedure for Adding Resources. It returns the
3200: -- WIP Mass Load Concurrent Request Id launched for processing the Addition
3201: -- of Resource. For Standard Operations. all the resources will be added
3202: -- together. For Non Standard Operation, only one resource will be added at
3203: -- a time.
3204: -- The parameter p_op_type decides internally whether the resources are being
3205: -- added for s Standard Operation (1) or NON standard operation (2).

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

3198:
3199: -- Call REWORK_OP_ADD_RES_INT procedure for Adding Resources. It returns the
3200: -- WIP Mass Load Concurrent Request Id launched for processing the Addition
3201: -- of Resource. For Standard Operations. all the resources will be added
3202: -- together. For Non Standard Operation, only one resource will be added at
3203: -- a time.
3204: -- The parameter p_op_type decides internally whether the resources are being
3205: -- added for s Standard Operation (1) or NON standard operation (2).
3206:

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

3201: -- of Resource. For Standard Operations. all the resources will be added
3202: -- together. For Non Standard Operation, only one resource will be added at
3203: -- a time.
3204: -- The parameter p_op_type decides internally whether the resources are being
3205: -- added for s Standard Operation (1) or NON standard operation (2).
3206:
3207: -- Get the new group_id from the Sequence for Adding Resources.
3208: OPEN group_cur;
3209: FETCH group_cur INTO l_group_id;

Line 3348: FROM bom_departments bdp, bom_standard_operations bso

3344:
3345: CURSOR op_det IS
3346: SELECT bdp.department_id, nvl(bso.count_point_type, 1) count_point_type,
3347: bso.backflush_flag, nvl(bso.minimum_transfer_quantity, 0) minimum_transfer_quantity
3348: FROM bom_departments bdp, bom_standard_operations bso
3349: WHERE bso.organization_id = p_organization_id
3350: AND bso.line_id is null
3351: AND nvl(bso.operation_type,1) = 1
3352: AND bdp.organization_id = p_organization_id

Line 3355: AND bso.standard_operation_id = p_operation_id;

3351: AND nvl(bso.operation_type,1) = 1
3352: AND bdp.organization_id = p_organization_id
3353: AND bso.department_id = bdp.department_id
3354: AND nvl(bdp.disable_date, sysdate + 2) > sysdate
3355: AND bso.standard_operation_id = p_operation_id;
3356:
3357:
3358: BEGIN
3359:

Line 3439: STANDARD_OPERATION_ID,

3435: LAST_UPDATED_BY,
3436: CREATION_DATE,
3437: CREATED_BY,
3438: PARENT_HEADER_ID,
3439: STANDARD_OPERATION_ID,
3440: FIRST_UNIT_START_DATE,
3441: FIRST_UNIT_COMPLETION_DATE,
3442: LAST_UNIT_START_DATE,
3443: LAST_UNIT_COMPLETION_DATE,

Line 3540: bsor.standard_rate_flag, bsor.usage_rate_or_amount,

3536:
3537: CURSOR res_det IS
3538: SELECT bsor.resource_seq_num, bsor.resource_id, bsor.activity_id,
3539: bsor.assigned_units, bsor.basis_type, bsor.schedule_flag,
3540: bsor.standard_rate_flag, bsor.usage_rate_or_amount,
3541: bsor.autocharge_type, br.unit_of_measure
3542: FROM bom_std_op_resources bsor, bom_resources br
3543: WHERE bsor.resource_id = br.resource_id
3544: AND bsor.standard_operation_id = p_operation_id;

Line 3544: AND bsor.standard_operation_id = p_operation_id;

3540: bsor.standard_rate_flag, bsor.usage_rate_or_amount,
3541: bsor.autocharge_type, br.unit_of_measure
3542: FROM bom_std_op_resources bsor, bom_resources br
3543: WHERE bsor.resource_id = br.resource_id
3544: AND bsor.standard_operation_id = p_operation_id;
3545:
3546:
3547: CURSOR m_res_det IS
3548: SELECT res.unit_of_measure, nvl(res.default_basis_type,1) basis_type,

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

3547: CURSOR m_res_det IS
3548: SELECT res.unit_of_measure, nvl(res.default_basis_type,1) basis_type,
3549: 2 "scheduled_flag", res.default_activity_id,
3550: nvl(res.autocharge_type, 1) autocharge_type,
3551: nvl(res.standard_rate_flag,1) standard_rate_flag
3552: FROM bom_resources res, bom_department_resources bdr
3553: WHERE res.organization_id = p_organization_id
3554: AND nvl(res.disable_date, sysdate + 2) > sysdate
3555: AND res.resource_id = bdr.resource_id

Line 3637: STANDARD_RATE_FLAG,

3633: BASIS_TYPE,
3634: RESOURCE_ID_NEW,
3635: RESOURCE_SEQ_NUM,
3636: SCHEDULED_FLAG,
3637: STANDARD_RATE_FLAG,
3638: USAGE_RATE_OR_AMOUNT,
3639: UOM_CODE
3640: )
3641: VALUES

Line 3702: STANDARD_RATE_FLAG,

3698: BASIS_TYPE,
3699: RESOURCE_ID_NEW,
3700: RESOURCE_SEQ_NUM,
3701: SCHEDULED_FLAG,
3702: STANDARD_RATE_FLAG,
3703: USAGE_RATE_OR_AMOUNT,
3704: UOM_CODE
3705: )
3706: VALUES