[Home] [Help]
830:
831: l_stmt_num := 30;
832: -- This will be handled by the call to OPRNB.copy_mes procedure in the secondary_quantities procedure..
833: if p_wltx_header.transaction_type_id = WSMPCNST.BONUS then
834: --query bom_standard_operations child table and populate reason codes for the new op.;
835: l_counter := p_wltx_resulting_jobs_tbl.first;
836: insert into wsm_op_reason_codes
837: (Organization_id,
838: Wip_entity_id ,
859: sysdate,
860: fnd_global.login_id
861: from bom_std_op_bonus_codes bsobc
862: where sequence_number = p_wltx_resulting_jobs_tbl(l_counter).starting_operation_seq_num
863: and STANDARD_OPERATION_ID = p_wltx_resulting_jobs_tbl(l_counter).starting_std_op_id
864: );
865:
866: insert into wsm_op_reason_codes
867: (Organization_id,
889: sysdate,
890: fnd_global.login_id
891: from bom_std_op_scrap_codes bsosc
892: where sequence_num = p_wltx_resulting_jobs_tbl(l_counter).starting_operation_seq_num
893: and STANDARD_OPERATION_ID = p_wltx_resulting_jobs_tbl(l_counter).starting_std_op_id
894: );
895: end if;
896: x_return_status := FND_API.G_RET_STS_SUCCESS;
897:
1175:
1176: l_stmt_num := 20;
1177:
1178: SELECT operation_sequence_id,
1179: standard_operation_id,
1180: department_id,
1181: quantity_in_queue,
1182: quantity_running,
1183: quantity_waiting_to_move,
1329: program_application_id,
1330: program_id,
1331: program_update_date,
1332: operation_sequence_id,
1333: standard_operation_id,
1334: department_id,
1335: description,
1336: scheduled_quantity,
1337: quantity_in_queue,
1389: wo.program_application_id,
1390: wo.program_id,
1391: wo.program_update_date,
1392: wo.operation_sequence_id,
1393: wo.standard_operation_id,
1394: wo.department_id,
1395: wo.description,
1396: -- ST : Added for bug fix 4619823 (Found in UT)
1397: -- (Update Scheduled qty only in case of Current op + Queue)
1594: activity_ID,
1595: scheduled_flag,
1596: assigned_units,
1597: autocharge_type,
1598: standard_rate_flag,
1599: applied_resource_units,
1600: applied_resource_value,
1601: start_date,
1602: completion_date,
1649: wor.activity_id,
1650: wor.scheduled_flag,
1651: wor.assigned_units,
1652: wor.autocharge_type,
1653: wor.standard_rate_flag,
1654: 0, --applied_resource_units
1655: 0, --applied_resource_value
1656: wor.start_date,
1657: wor.completion_date,
1756: scheduled_flag,
1757: assigned_units,
1758: maximum_assigned_units, -- ST : Detailed Scheduling --
1759: autocharge_type,
1760: standard_rate_flag,
1761: applied_resource_units,
1762: applied_resource_value,
1763: start_date,
1764: completion_date,
1818: wsor.scheduled_flag,
1819: wsor.assigned_units,
1820: wsor.maximum_assigned_units, -- ST : Detailed Scheduling --
1821: wsor.autocharge_type,
1822: wsor.standard_rate_flag,
1823: 0, --applied_resource_units
1824: 0, --applied_resource_value
1825: wsor.start_date,
1826: wsor.completion_date,
2810: START_DATE,
2811: COMPLETION_DATE,
2812: RESOURCE_ID,
2813: ACTIVITY_ID,
2814: STANDARD_RATE_FLAG,
2815: ASSIGNED_UNITS,
2816: MAXIMUM_ASSIGNED_UNITS, -- ST : Detailed Scheduling --
2817: USAGE_RATE_OR_AMOUNT,
2818: UOM_CODE,
2866: wo.first_unit_start_date, --START_DATE
2867: wo.first_unit_completion_date, --COMPLETION_DATE
2868: bsor.RESOURCE_ID,
2869: bsor.ACTIVITY_ID,
2870: bsor.STANDARD_RATE_FLAG,
2871: bsor.ASSIGNED_UNITS,
2872: bsor.assigned_units, -- ST : Detailed Scheduling --
2873: bsor.USAGE_RATE_OR_AMOUNT,
2874: br.UNIT_OF_MEASURE,
4037: l_stmt_num := 20;
4038:
4039: l_rj_counter := p_wltx_resulting_jobs_tbl.first;
4040:
4041: if p_wltx_resulting_jobs_tbl(l_rj_counter).job_type = WIP_CONSTANTS.STANDARD then
4042: l_res_rtg_item_id := p_wltx_resulting_jobs_tbl(l_rj_counter).primary_item_id;
4043: l_res_bill_item_id := p_wltx_resulting_jobs_tbl(l_rj_counter).primary_item_id;
4044: else
4045: l_res_rtg_item_id := p_wltx_resulting_jobs_tbl(l_rj_counter).routing_reference_id;
4299:
4300: IF (p_copy_mode = 1) THEN -- Make copies after each transaction
4301: l_stmt_num := 110;
4302:
4303: if p_wltx_resulting_jobs_tbl(l_job_counter).job_type = WIP_CONSTANTS.STANDARD then
4304: l_res_rtg_item_id := p_wltx_resulting_jobs_tbl(l_job_counter).primary_item_id;
4305: l_res_bill_item_id := p_wltx_resulting_jobs_tbl(l_job_counter).primary_item_id;
4306: else
4307: l_res_rtg_item_id := p_wltx_resulting_jobs_tbl(l_job_counter).routing_reference_id;
4433:
4434: IF (p_copy_mode = 1) THEN -- Make copies after each transaction
4435: l_stmt_num := 140;
4436:
4437: if p_wltx_resulting_jobs_tbl(p_sj_as_rj_index).job_type = WIP_CONSTANTS.STANDARD then
4438: l_res_rtg_item_id := p_wltx_resulting_jobs_tbl(p_sj_as_rj_index).primary_item_id;
4439: l_res_bill_item_id := p_wltx_resulting_jobs_tbl(p_sj_as_rj_index).primary_item_id;
4440: else
4441: l_res_rtg_item_id := p_wltx_resulting_jobs_tbl(p_sj_as_rj_index).routing_reference_id;