APPS.WSMPOPRN dependencies on WIP_OPERATION_RESOURCES

Line 19: | into wip_operation_resources |

15: | 06/12/00 REDWIN First Check In |
16: | 09/29/00 GRATNAM Modified update_job_name()for |
17: | assy returns |
18: | 01/15/01 SBHASKAR Bugfix 1523334:Incase of Jump, insert |
19: | into wip_operation_resources |
20: | using bom_std_op_resources |
21: +============================================================================*/
22:
23: g_update_flag boolean:=TRUE;

Line 1172: UPDATE wip_operation_resources

1168: -- WHERE organization_id = x_organization_id ) ;
1169: -- ED: CZH.I_9999
1170:
1171: -- bug 3203505 change order of update WOR and WRO
1172: UPDATE wip_operation_resources
1173: SET autocharge_type = 2
1174: WHERE wip_entity_id = x_wip_entity_id
1175: AND operation_seq_num > x_from_op;
1176: -- BD: CZH.I_9999

Line 1247: DELETE FROM WIP_OPERATION_RESOURCES

1243: x_error_code,
1244: x_error_msg);
1245: ****************/
1246: l_stat_num := 30;
1247: DELETE FROM WIP_OPERATION_RESOURCES
1248: WHERE WIP_ENTITY_ID = X_Wip_Entity_id
1249: --AND OPERATION_SEQ_NUM > X_From_Op
1250: AND OPERATION_SEQ_NUM = X_To_Op
1251: AND PROGRAM_ID = -999

Line 1290: INSERT INTO WIP_OPERATION_RESOURCES

1286: l_stat_num NUMBER;
1287:
1288: BEGIN
1289: l_stat_num := 10;
1290: INSERT INTO WIP_OPERATION_RESOURCES
1291: (WIP_ENTITY_ID, OPERATION_SEQ_NUM, RESOURCE_SEQ_NUM,
1292: ORGANIZATION_ID, REPETITIVE_SCHEDULE_ID,
1293: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE,
1294: CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID,

Line 1347: INSERT INTO WIP_OPERATION_RESOURCES

1343: -- We will fetch the details from BOM_STD_OP_RESOURCES
1344:
1345: IF (sql%rowcount = 0) THEN
1346: l_stat_num := 15;
1347: INSERT INTO WIP_OPERATION_RESOURCES
1348: (WIP_ENTITY_ID, OPERATION_SEQ_NUM, RESOURCE_SEQ_NUM,
1349: ORGANIZATION_ID, REPETITIVE_SCHEDULE_ID,
1350: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE,
1351: CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID,

Line 3169: INSERT INTO WIP_OPERATION_RESOURCES

3165: end if;
3166:
3167: l_stmt_num := 80;
3168:
3169: INSERT INTO WIP_OPERATION_RESOURCES
3170: (WIP_ENTITY_ID, OPERATION_SEQ_NUM, RESOURCE_SEQ_NUM,
3171: ORGANIZATION_ID, REPETITIVE_SCHEDULE_ID,
3172: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE,
3173: CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID,

Line 3408: -- WIP_OPERATION_RESOURCES WOR Bug 5478658 join with WOR not required

3404: , WCORI.START_DATE
3405: , WCORI.COMPLETION_DATE
3406: , WCORI.BATCH_ID
3407: FROM WSM_COPY_OP_RESOURCE_INSTANCES WCORI
3408: -- WIP_OPERATION_RESOURCES WOR Bug 5478658 join with WOR not required
3409: WHERE WCORI.WIP_ENTITY_ID= p_wip_entity_id
3410: AND WCORI.Operation_seq_num = p_to_rtg_op_seq_num ;
3411:
3412: -- Bug 5478658 Join conditions with WOR removed

Line 3465: FROM -- WIP_OPERATION_RESOURCES WOR, Bug 5478658 join with WOR not required

3461: DECODE(p_program_id, 0, '', SYSDATE),
3462: WCORU.INSTANCE_ID,
3463: WCORU.SERIAL_NUMBER,
3464: WCORU.CUMULATIVE_PROCESSING_TIME
3465: FROM -- WIP_OPERATION_RESOURCES WOR, Bug 5478658 join with WOR not required
3466: WSM_COPY_OP_RESOURCE_USAGE WCORU
3467: WHERE WCORU.WIP_ENTITY_ID= p_wip_entity_id
3468: AND WCORU.Operation_seq_num = p_to_rtg_op_seq_num ;
3469: