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 3170: INSERT INTO WIP_OPERATION_RESOURCES

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

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

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

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

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