APPS.WIP_BATCH_MOVE dependencies on QA_SS_CONST

Line 1250: qa_ss_const.department||'='||p_move_tbl(i).fm_department_code||'@'||

1246:
1247: FOR i IN 1..l_total_row LOOP
1248: -- Build l_context_values to pass to quality API.
1249: l_context_values :=
1250: qa_ss_const.department||'='||p_move_tbl(i).fm_department_code||'@'||
1251: qa_ss_const.quantity||'='||p_move_tbl(i).transaction_quantity||'@'||
1252: qa_ss_const.item||'='||p_move_tbl(i).primary_item_name||'@'||
1253: -- Pass empty string to item category as Bryan suggested.
1254: qa_ss_const.item_category||'=@'||

Line 1251: qa_ss_const.quantity||'='||p_move_tbl(i).transaction_quantity||'@'||

1247: FOR i IN 1..l_total_row LOOP
1248: -- Build l_context_values to pass to quality API.
1249: l_context_values :=
1250: qa_ss_const.department||'='||p_move_tbl(i).fm_department_code||'@'||
1251: qa_ss_const.quantity||'='||p_move_tbl(i).transaction_quantity||'@'||
1252: qa_ss_const.item||'='||p_move_tbl(i).primary_item_name||'@'||
1253: -- Pass empty string to item category as Bryan suggested.
1254: qa_ss_const.item_category||'=@'||
1255: qa_ss_const.uom||'='||p_move_tbl(i).transaction_uom||'@'||

Line 1252: qa_ss_const.item||'='||p_move_tbl(i).primary_item_name||'@'||

1248: -- Build l_context_values to pass to quality API.
1249: l_context_values :=
1250: qa_ss_const.department||'='||p_move_tbl(i).fm_department_code||'@'||
1251: qa_ss_const.quantity||'='||p_move_tbl(i).transaction_quantity||'@'||
1252: qa_ss_const.item||'='||p_move_tbl(i).primary_item_name||'@'||
1253: -- Pass empty string to item category as Bryan suggested.
1254: qa_ss_const.item_category||'=@'||
1255: qa_ss_const.uom||'='||p_move_tbl(i).transaction_uom||'@'||
1256: qa_ss_const.reason_code||'=@'||

Line 1254: qa_ss_const.item_category||'=@'||

1250: qa_ss_const.department||'='||p_move_tbl(i).fm_department_code||'@'||
1251: qa_ss_const.quantity||'='||p_move_tbl(i).transaction_quantity||'@'||
1252: qa_ss_const.item||'='||p_move_tbl(i).primary_item_name||'@'||
1253: -- Pass empty string to item category as Bryan suggested.
1254: qa_ss_const.item_category||'=@'||
1255: qa_ss_const.uom||'='||p_move_tbl(i).transaction_uom||'@'||
1256: qa_ss_const.reason_code||'=@'||
1257: qa_ss_const.job_name||'='||p_move_tbl(i).wip_entity_name||'@'||
1258: qa_ss_const.production_line||'=@'||

Line 1255: qa_ss_const.uom||'='||p_move_tbl(i).transaction_uom||'@'||

1251: qa_ss_const.quantity||'='||p_move_tbl(i).transaction_quantity||'@'||
1252: qa_ss_const.item||'='||p_move_tbl(i).primary_item_name||'@'||
1253: -- Pass empty string to item category as Bryan suggested.
1254: qa_ss_const.item_category||'=@'||
1255: qa_ss_const.uom||'='||p_move_tbl(i).transaction_uom||'@'||
1256: qa_ss_const.reason_code||'=@'||
1257: qa_ss_const.job_name||'='||p_move_tbl(i).wip_entity_name||'@'||
1258: qa_ss_const.production_line||'=@'||
1259: qa_ss_const.to_op_seq_num||'='||p_move_tbl(i).to_operation_seq_num||'@'||

Line 1256: qa_ss_const.reason_code||'=@'||

1252: qa_ss_const.item||'='||p_move_tbl(i).primary_item_name||'@'||
1253: -- Pass empty string to item category as Bryan suggested.
1254: qa_ss_const.item_category||'=@'||
1255: qa_ss_const.uom||'='||p_move_tbl(i).transaction_uom||'@'||
1256: qa_ss_const.reason_code||'=@'||
1257: qa_ss_const.job_name||'='||p_move_tbl(i).wip_entity_name||'@'||
1258: qa_ss_const.production_line||'=@'||
1259: qa_ss_const.to_op_seq_num||'='||p_move_tbl(i).to_operation_seq_num||'@'||
1260: qa_ss_const.from_op_seq_num||'='||p_move_tbl(i).fm_operation_seq_num||'@'||

Line 1257: qa_ss_const.job_name||'='||p_move_tbl(i).wip_entity_name||'@'||

1253: -- Pass empty string to item category as Bryan suggested.
1254: qa_ss_const.item_category||'=@'||
1255: qa_ss_const.uom||'='||p_move_tbl(i).transaction_uom||'@'||
1256: qa_ss_const.reason_code||'=@'||
1257: qa_ss_const.job_name||'='||p_move_tbl(i).wip_entity_name||'@'||
1258: qa_ss_const.production_line||'=@'||
1259: qa_ss_const.to_op_seq_num||'='||p_move_tbl(i).to_operation_seq_num||'@'||
1260: qa_ss_const.from_op_seq_num||'='||p_move_tbl(i).fm_operation_seq_num||'@'||
1261: qa_ss_const.to_intraoperation_step||'='||p_move_tbl(i).to_intraoperation_step||'@'||

Line 1258: qa_ss_const.production_line||'=@'||

1254: qa_ss_const.item_category||'=@'||
1255: qa_ss_const.uom||'='||p_move_tbl(i).transaction_uom||'@'||
1256: qa_ss_const.reason_code||'=@'||
1257: qa_ss_const.job_name||'='||p_move_tbl(i).wip_entity_name||'@'||
1258: qa_ss_const.production_line||'=@'||
1259: qa_ss_const.to_op_seq_num||'='||p_move_tbl(i).to_operation_seq_num||'@'||
1260: qa_ss_const.from_op_seq_num||'='||p_move_tbl(i).fm_operation_seq_num||'@'||
1261: qa_ss_const.to_intraoperation_step||'='||p_move_tbl(i).to_intraoperation_step||'@'||
1262: qa_ss_const.from_intraoperation_step||'='||p_move_tbl(i).fm_intraoperation_step||'@'||

Line 1259: qa_ss_const.to_op_seq_num||'='||p_move_tbl(i).to_operation_seq_num||'@'||

1255: qa_ss_const.uom||'='||p_move_tbl(i).transaction_uom||'@'||
1256: qa_ss_const.reason_code||'=@'||
1257: qa_ss_const.job_name||'='||p_move_tbl(i).wip_entity_name||'@'||
1258: qa_ss_const.production_line||'=@'||
1259: qa_ss_const.to_op_seq_num||'='||p_move_tbl(i).to_operation_seq_num||'@'||
1260: qa_ss_const.from_op_seq_num||'='||p_move_tbl(i).fm_operation_seq_num||'@'||
1261: qa_ss_const.to_intraoperation_step||'='||p_move_tbl(i).to_intraoperation_step||'@'||
1262: qa_ss_const.from_intraoperation_step||'='||p_move_tbl(i).fm_intraoperation_step||'@'||
1263: qa_ss_const.sales_order||'=@'||

Line 1260: qa_ss_const.from_op_seq_num||'='||p_move_tbl(i).fm_operation_seq_num||'@'||

1256: qa_ss_const.reason_code||'=@'||
1257: qa_ss_const.job_name||'='||p_move_tbl(i).wip_entity_name||'@'||
1258: qa_ss_const.production_line||'=@'||
1259: qa_ss_const.to_op_seq_num||'='||p_move_tbl(i).to_operation_seq_num||'@'||
1260: qa_ss_const.from_op_seq_num||'='||p_move_tbl(i).fm_operation_seq_num||'@'||
1261: qa_ss_const.to_intraoperation_step||'='||p_move_tbl(i).to_intraoperation_step||'@'||
1262: qa_ss_const.from_intraoperation_step||'='||p_move_tbl(i).fm_intraoperation_step||'@'||
1263: qa_ss_const.sales_order||'=@'||
1264: qa_ss_const.operation_code||'='||p_move_tbl(i).fm_operation_code||'@'||

Line 1261: qa_ss_const.to_intraoperation_step||'='||p_move_tbl(i).to_intraoperation_step||'@'||

1257: qa_ss_const.job_name||'='||p_move_tbl(i).wip_entity_name||'@'||
1258: qa_ss_const.production_line||'=@'||
1259: qa_ss_const.to_op_seq_num||'='||p_move_tbl(i).to_operation_seq_num||'@'||
1260: qa_ss_const.from_op_seq_num||'='||p_move_tbl(i).fm_operation_seq_num||'@'||
1261: qa_ss_const.to_intraoperation_step||'='||p_move_tbl(i).to_intraoperation_step||'@'||
1262: qa_ss_const.from_intraoperation_step||'='||p_move_tbl(i).fm_intraoperation_step||'@'||
1263: qa_ss_const.sales_order||'=@'||
1264: qa_ss_const.operation_code||'='||p_move_tbl(i).fm_operation_code||'@'||
1265: qa_ss_const.transaction_type||'='||move_txn_meaning||'=@'||

Line 1262: qa_ss_const.from_intraoperation_step||'='||p_move_tbl(i).fm_intraoperation_step||'@'||

1258: qa_ss_const.production_line||'=@'||
1259: qa_ss_const.to_op_seq_num||'='||p_move_tbl(i).to_operation_seq_num||'@'||
1260: qa_ss_const.from_op_seq_num||'='||p_move_tbl(i).fm_operation_seq_num||'@'||
1261: qa_ss_const.to_intraoperation_step||'='||p_move_tbl(i).to_intraoperation_step||'@'||
1262: qa_ss_const.from_intraoperation_step||'='||p_move_tbl(i).fm_intraoperation_step||'@'||
1263: qa_ss_const.sales_order||'=@'||
1264: qa_ss_const.operation_code||'='||p_move_tbl(i).fm_operation_code||'@'||
1265: qa_ss_const.transaction_type||'='||move_txn_meaning||'=@'||
1266: qa_ss_const.to_department||'='||p_move_tbl(i).to_department_code||'@'||

Line 1263: qa_ss_const.sales_order||'=@'||

1259: qa_ss_const.to_op_seq_num||'='||p_move_tbl(i).to_operation_seq_num||'@'||
1260: qa_ss_const.from_op_seq_num||'='||p_move_tbl(i).fm_operation_seq_num||'@'||
1261: qa_ss_const.to_intraoperation_step||'='||p_move_tbl(i).to_intraoperation_step||'@'||
1262: qa_ss_const.from_intraoperation_step||'='||p_move_tbl(i).fm_intraoperation_step||'@'||
1263: qa_ss_const.sales_order||'=@'||
1264: qa_ss_const.operation_code||'='||p_move_tbl(i).fm_operation_code||'@'||
1265: qa_ss_const.transaction_type||'='||move_txn_meaning||'=@'||
1266: qa_ss_const.to_department||'='||p_move_tbl(i).to_department_code||'@'||
1267: qa_ss_const.to_operation_code||'='||p_move_tbl(i).to_operation_code||'@'||

Line 1264: qa_ss_const.operation_code||'='||p_move_tbl(i).fm_operation_code||'@'||

1260: qa_ss_const.from_op_seq_num||'='||p_move_tbl(i).fm_operation_seq_num||'@'||
1261: qa_ss_const.to_intraoperation_step||'='||p_move_tbl(i).to_intraoperation_step||'@'||
1262: qa_ss_const.from_intraoperation_step||'='||p_move_tbl(i).fm_intraoperation_step||'@'||
1263: qa_ss_const.sales_order||'=@'||
1264: qa_ss_const.operation_code||'='||p_move_tbl(i).fm_operation_code||'@'||
1265: qa_ss_const.transaction_type||'='||move_txn_meaning||'=@'||
1266: qa_ss_const.to_department||'='||p_move_tbl(i).to_department_code||'@'||
1267: qa_ss_const.to_operation_code||'='||p_move_tbl(i).to_operation_code||'@'||
1268: qa_ss_const.serial_number||'='||p_assy_serial||'@'||

Line 1265: qa_ss_const.transaction_type||'='||move_txn_meaning||'=@'||

1261: qa_ss_const.to_intraoperation_step||'='||p_move_tbl(i).to_intraoperation_step||'@'||
1262: qa_ss_const.from_intraoperation_step||'='||p_move_tbl(i).fm_intraoperation_step||'@'||
1263: qa_ss_const.sales_order||'=@'||
1264: qa_ss_const.operation_code||'='||p_move_tbl(i).fm_operation_code||'@'||
1265: qa_ss_const.transaction_type||'='||move_txn_meaning||'=@'||
1266: qa_ss_const.to_department||'='||p_move_tbl(i).to_department_code||'@'||
1267: qa_ss_const.to_operation_code||'='||p_move_tbl(i).to_operation_code||'@'||
1268: qa_ss_const.serial_number||'='||p_assy_serial||'@'||
1269: qa_ss_const.transaction_date||'='||sysdate||'@'||

Line 1266: qa_ss_const.to_department||'='||p_move_tbl(i).to_department_code||'@'||

1262: qa_ss_const.from_intraoperation_step||'='||p_move_tbl(i).fm_intraoperation_step||'@'||
1263: qa_ss_const.sales_order||'=@'||
1264: qa_ss_const.operation_code||'='||p_move_tbl(i).fm_operation_code||'@'||
1265: qa_ss_const.transaction_type||'='||move_txn_meaning||'=@'||
1266: qa_ss_const.to_department||'='||p_move_tbl(i).to_department_code||'@'||
1267: qa_ss_const.to_operation_code||'='||p_move_tbl(i).to_operation_code||'@'||
1268: qa_ss_const.serial_number||'='||p_assy_serial||'@'||
1269: qa_ss_const.transaction_date||'='||sysdate||'@'||
1270: qa_ss_const.project_number||'='||p_move_tbl(i).project_number||'@'||

Line 1267: qa_ss_const.to_operation_code||'='||p_move_tbl(i).to_operation_code||'@'||

1263: qa_ss_const.sales_order||'=@'||
1264: qa_ss_const.operation_code||'='||p_move_tbl(i).fm_operation_code||'@'||
1265: qa_ss_const.transaction_type||'='||move_txn_meaning||'=@'||
1266: qa_ss_const.to_department||'='||p_move_tbl(i).to_department_code||'@'||
1267: qa_ss_const.to_operation_code||'='||p_move_tbl(i).to_operation_code||'@'||
1268: qa_ss_const.serial_number||'='||p_assy_serial||'@'||
1269: qa_ss_const.transaction_date||'='||sysdate||'@'||
1270: qa_ss_const.project_number||'='||p_move_tbl(i).project_number||'@'||
1271: qa_ss_const.task_number||'='||p_move_tbl(i).task_number||'@'||

Line 1268: qa_ss_const.serial_number||'='||p_assy_serial||'@'||

1264: qa_ss_const.operation_code||'='||p_move_tbl(i).fm_operation_code||'@'||
1265: qa_ss_const.transaction_type||'='||move_txn_meaning||'=@'||
1266: qa_ss_const.to_department||'='||p_move_tbl(i).to_department_code||'@'||
1267: qa_ss_const.to_operation_code||'='||p_move_tbl(i).to_operation_code||'@'||
1268: qa_ss_const.serial_number||'='||p_assy_serial||'@'||
1269: qa_ss_const.transaction_date||'='||sysdate||'@'||
1270: qa_ss_const.project_number||'='||p_move_tbl(i).project_number||'@'||
1271: qa_ss_const.task_number||'='||p_move_tbl(i).task_number||'@'||
1272: qa_ss_const.bom_revision||'='||p_move_tbl(i).bom_revision;

Line 1269: qa_ss_const.transaction_date||'='||sysdate||'@'||

1265: qa_ss_const.transaction_type||'='||move_txn_meaning||'=@'||
1266: qa_ss_const.to_department||'='||p_move_tbl(i).to_department_code||'@'||
1267: qa_ss_const.to_operation_code||'='||p_move_tbl(i).to_operation_code||'@'||
1268: qa_ss_const.serial_number||'='||p_assy_serial||'@'||
1269: qa_ss_const.transaction_date||'='||sysdate||'@'||
1270: qa_ss_const.project_number||'='||p_move_tbl(i).project_number||'@'||
1271: qa_ss_const.task_number||'='||p_move_tbl(i).task_number||'@'||
1272: qa_ss_const.bom_revision||'='||p_move_tbl(i).bom_revision;
1273:

Line 1270: qa_ss_const.project_number||'='||p_move_tbl(i).project_number||'@'||

1266: qa_ss_const.to_department||'='||p_move_tbl(i).to_department_code||'@'||
1267: qa_ss_const.to_operation_code||'='||p_move_tbl(i).to_operation_code||'@'||
1268: qa_ss_const.serial_number||'='||p_assy_serial||'@'||
1269: qa_ss_const.transaction_date||'='||sysdate||'@'||
1270: qa_ss_const.project_number||'='||p_move_tbl(i).project_number||'@'||
1271: qa_ss_const.task_number||'='||p_move_tbl(i).task_number||'@'||
1272: qa_ss_const.bom_revision||'='||p_move_tbl(i).bom_revision;
1273:
1274: --Fix bug 13336388

Line 1271: qa_ss_const.task_number||'='||p_move_tbl(i).task_number||'@'||

1267: qa_ss_const.to_operation_code||'='||p_move_tbl(i).to_operation_code||'@'||
1268: qa_ss_const.serial_number||'='||p_assy_serial||'@'||
1269: qa_ss_const.transaction_date||'='||sysdate||'@'||
1270: qa_ss_const.project_number||'='||p_move_tbl(i).project_number||'@'||
1271: qa_ss_const.task_number||'='||p_move_tbl(i).task_number||'@'||
1272: qa_ss_const.bom_revision||'='||p_move_tbl(i).bom_revision;
1273:
1274: --Fix bug 13336388
1275: l_context_ids :=

Line 1272: qa_ss_const.bom_revision||'='||p_move_tbl(i).bom_revision;

1268: qa_ss_const.serial_number||'='||p_assy_serial||'@'||
1269: qa_ss_const.transaction_date||'='||sysdate||'@'||
1270: qa_ss_const.project_number||'='||p_move_tbl(i).project_number||'@'||
1271: qa_ss_const.task_number||'='||p_move_tbl(i).task_number||'@'||
1272: qa_ss_const.bom_revision||'='||p_move_tbl(i).bom_revision;
1273:
1274: --Fix bug 13336388
1275: l_context_ids :=
1276: qa_ss_const.department||'='||p_move_tbl(i).fm_department_id||'@'||

Line 1276: qa_ss_const.department||'='||p_move_tbl(i).fm_department_id||'@'||

1272: qa_ss_const.bom_revision||'='||p_move_tbl(i).bom_revision;
1273:
1274: --Fix bug 13336388
1275: l_context_ids :=
1276: qa_ss_const.department||'='||p_move_tbl(i).fm_department_id||'@'||
1277: qa_ss_const.quantity||'='||p_move_tbl(i).transaction_quantity||'@'||
1278: qa_ss_const.item||'='||p_move_tbl(i).primary_item_id||'@'||
1279: -- Pass empty string to item category as Bryan suggested.
1280: qa_ss_const.item_category||'=@'||

Line 1277: qa_ss_const.quantity||'='||p_move_tbl(i).transaction_quantity||'@'||

1273:
1274: --Fix bug 13336388
1275: l_context_ids :=
1276: qa_ss_const.department||'='||p_move_tbl(i).fm_department_id||'@'||
1277: qa_ss_const.quantity||'='||p_move_tbl(i).transaction_quantity||'@'||
1278: qa_ss_const.item||'='||p_move_tbl(i).primary_item_id||'@'||
1279: -- Pass empty string to item category as Bryan suggested.
1280: qa_ss_const.item_category||'=@'||
1281: qa_ss_const.uom||'='||p_move_tbl(i).transaction_uom||'@'||

Line 1278: qa_ss_const.item||'='||p_move_tbl(i).primary_item_id||'@'||

1274: --Fix bug 13336388
1275: l_context_ids :=
1276: qa_ss_const.department||'='||p_move_tbl(i).fm_department_id||'@'||
1277: qa_ss_const.quantity||'='||p_move_tbl(i).transaction_quantity||'@'||
1278: qa_ss_const.item||'='||p_move_tbl(i).primary_item_id||'@'||
1279: -- Pass empty string to item category as Bryan suggested.
1280: qa_ss_const.item_category||'=@'||
1281: qa_ss_const.uom||'='||p_move_tbl(i).transaction_uom||'@'||
1282: qa_ss_const.reason_code||'=@'||

Line 1280: qa_ss_const.item_category||'=@'||

1276: qa_ss_const.department||'='||p_move_tbl(i).fm_department_id||'@'||
1277: qa_ss_const.quantity||'='||p_move_tbl(i).transaction_quantity||'@'||
1278: qa_ss_const.item||'='||p_move_tbl(i).primary_item_id||'@'||
1279: -- Pass empty string to item category as Bryan suggested.
1280: qa_ss_const.item_category||'=@'||
1281: qa_ss_const.uom||'='||p_move_tbl(i).transaction_uom||'@'||
1282: qa_ss_const.reason_code||'=@'||
1283: qa_ss_const.job_name||'='||p_move_tbl(i).wip_entity_id||'@'||
1284: qa_ss_const.production_line||'=@'||

Line 1281: qa_ss_const.uom||'='||p_move_tbl(i).transaction_uom||'@'||

1277: qa_ss_const.quantity||'='||p_move_tbl(i).transaction_quantity||'@'||
1278: qa_ss_const.item||'='||p_move_tbl(i).primary_item_id||'@'||
1279: -- Pass empty string to item category as Bryan suggested.
1280: qa_ss_const.item_category||'=@'||
1281: qa_ss_const.uom||'='||p_move_tbl(i).transaction_uom||'@'||
1282: qa_ss_const.reason_code||'=@'||
1283: qa_ss_const.job_name||'='||p_move_tbl(i).wip_entity_id||'@'||
1284: qa_ss_const.production_line||'=@'||
1285: qa_ss_const.to_op_seq_num||'='||p_move_tbl(i).to_operation_seq_num||'@'||

Line 1282: qa_ss_const.reason_code||'=@'||

1278: qa_ss_const.item||'='||p_move_tbl(i).primary_item_id||'@'||
1279: -- Pass empty string to item category as Bryan suggested.
1280: qa_ss_const.item_category||'=@'||
1281: qa_ss_const.uom||'='||p_move_tbl(i).transaction_uom||'@'||
1282: qa_ss_const.reason_code||'=@'||
1283: qa_ss_const.job_name||'='||p_move_tbl(i).wip_entity_id||'@'||
1284: qa_ss_const.production_line||'=@'||
1285: qa_ss_const.to_op_seq_num||'='||p_move_tbl(i).to_operation_seq_num||'@'||
1286: qa_ss_const.from_op_seq_num||'='||p_move_tbl(i).fm_operation_seq_num||'@'||

Line 1283: qa_ss_const.job_name||'='||p_move_tbl(i).wip_entity_id||'@'||

1279: -- Pass empty string to item category as Bryan suggested.
1280: qa_ss_const.item_category||'=@'||
1281: qa_ss_const.uom||'='||p_move_tbl(i).transaction_uom||'@'||
1282: qa_ss_const.reason_code||'=@'||
1283: qa_ss_const.job_name||'='||p_move_tbl(i).wip_entity_id||'@'||
1284: qa_ss_const.production_line||'=@'||
1285: qa_ss_const.to_op_seq_num||'='||p_move_tbl(i).to_operation_seq_num||'@'||
1286: qa_ss_const.from_op_seq_num||'='||p_move_tbl(i).fm_operation_seq_num||'@'||
1287: qa_ss_const.to_intraoperation_step||'='||p_move_tbl(i).to_intraoperation_step||'@'||

Line 1284: qa_ss_const.production_line||'=@'||

1280: qa_ss_const.item_category||'=@'||
1281: qa_ss_const.uom||'='||p_move_tbl(i).transaction_uom||'@'||
1282: qa_ss_const.reason_code||'=@'||
1283: qa_ss_const.job_name||'='||p_move_tbl(i).wip_entity_id||'@'||
1284: qa_ss_const.production_line||'=@'||
1285: qa_ss_const.to_op_seq_num||'='||p_move_tbl(i).to_operation_seq_num||'@'||
1286: qa_ss_const.from_op_seq_num||'='||p_move_tbl(i).fm_operation_seq_num||'@'||
1287: qa_ss_const.to_intraoperation_step||'='||p_move_tbl(i).to_intraoperation_step||'@'||
1288: qa_ss_const.from_intraoperation_step||'='||p_move_tbl(i).fm_intraoperation_step||'@'||

Line 1285: qa_ss_const.to_op_seq_num||'='||p_move_tbl(i).to_operation_seq_num||'@'||

1281: qa_ss_const.uom||'='||p_move_tbl(i).transaction_uom||'@'||
1282: qa_ss_const.reason_code||'=@'||
1283: qa_ss_const.job_name||'='||p_move_tbl(i).wip_entity_id||'@'||
1284: qa_ss_const.production_line||'=@'||
1285: qa_ss_const.to_op_seq_num||'='||p_move_tbl(i).to_operation_seq_num||'@'||
1286: qa_ss_const.from_op_seq_num||'='||p_move_tbl(i).fm_operation_seq_num||'@'||
1287: qa_ss_const.to_intraoperation_step||'='||p_move_tbl(i).to_intraoperation_step||'@'||
1288: qa_ss_const.from_intraoperation_step||'='||p_move_tbl(i).fm_intraoperation_step||'@'||
1289: qa_ss_const.sales_order||'=@'||

Line 1286: qa_ss_const.from_op_seq_num||'='||p_move_tbl(i).fm_operation_seq_num||'@'||

1282: qa_ss_const.reason_code||'=@'||
1283: qa_ss_const.job_name||'='||p_move_tbl(i).wip_entity_id||'@'||
1284: qa_ss_const.production_line||'=@'||
1285: qa_ss_const.to_op_seq_num||'='||p_move_tbl(i).to_operation_seq_num||'@'||
1286: qa_ss_const.from_op_seq_num||'='||p_move_tbl(i).fm_operation_seq_num||'@'||
1287: qa_ss_const.to_intraoperation_step||'='||p_move_tbl(i).to_intraoperation_step||'@'||
1288: qa_ss_const.from_intraoperation_step||'='||p_move_tbl(i).fm_intraoperation_step||'@'||
1289: qa_ss_const.sales_order||'=@'||
1290: qa_ss_const.operation_code||'='||p_move_tbl(i).fm_operation_code||'@'||

Line 1287: qa_ss_const.to_intraoperation_step||'='||p_move_tbl(i).to_intraoperation_step||'@'||

1283: qa_ss_const.job_name||'='||p_move_tbl(i).wip_entity_id||'@'||
1284: qa_ss_const.production_line||'=@'||
1285: qa_ss_const.to_op_seq_num||'='||p_move_tbl(i).to_operation_seq_num||'@'||
1286: qa_ss_const.from_op_seq_num||'='||p_move_tbl(i).fm_operation_seq_num||'@'||
1287: qa_ss_const.to_intraoperation_step||'='||p_move_tbl(i).to_intraoperation_step||'@'||
1288: qa_ss_const.from_intraoperation_step||'='||p_move_tbl(i).fm_intraoperation_step||'@'||
1289: qa_ss_const.sales_order||'=@'||
1290: qa_ss_const.operation_code||'='||p_move_tbl(i).fm_operation_code||'@'||
1291: qa_ss_const.transaction_type||'='||move_txn_meaning||'=@'||

Line 1288: qa_ss_const.from_intraoperation_step||'='||p_move_tbl(i).fm_intraoperation_step||'@'||

1284: qa_ss_const.production_line||'=@'||
1285: qa_ss_const.to_op_seq_num||'='||p_move_tbl(i).to_operation_seq_num||'@'||
1286: qa_ss_const.from_op_seq_num||'='||p_move_tbl(i).fm_operation_seq_num||'@'||
1287: qa_ss_const.to_intraoperation_step||'='||p_move_tbl(i).to_intraoperation_step||'@'||
1288: qa_ss_const.from_intraoperation_step||'='||p_move_tbl(i).fm_intraoperation_step||'@'||
1289: qa_ss_const.sales_order||'=@'||
1290: qa_ss_const.operation_code||'='||p_move_tbl(i).fm_operation_code||'@'||
1291: qa_ss_const.transaction_type||'='||move_txn_meaning||'=@'||
1292: qa_ss_const.to_department||'='||p_move_tbl(i).to_department_id||'@'||

Line 1289: qa_ss_const.sales_order||'=@'||

1285: qa_ss_const.to_op_seq_num||'='||p_move_tbl(i).to_operation_seq_num||'@'||
1286: qa_ss_const.from_op_seq_num||'='||p_move_tbl(i).fm_operation_seq_num||'@'||
1287: qa_ss_const.to_intraoperation_step||'='||p_move_tbl(i).to_intraoperation_step||'@'||
1288: qa_ss_const.from_intraoperation_step||'='||p_move_tbl(i).fm_intraoperation_step||'@'||
1289: qa_ss_const.sales_order||'=@'||
1290: qa_ss_const.operation_code||'='||p_move_tbl(i).fm_operation_code||'@'||
1291: qa_ss_const.transaction_type||'='||move_txn_meaning||'=@'||
1292: qa_ss_const.to_department||'='||p_move_tbl(i).to_department_id||'@'||
1293: qa_ss_const.to_operation_code||'='||p_move_tbl(i).to_operation_code||'@'||

Line 1290: qa_ss_const.operation_code||'='||p_move_tbl(i).fm_operation_code||'@'||

1286: qa_ss_const.from_op_seq_num||'='||p_move_tbl(i).fm_operation_seq_num||'@'||
1287: qa_ss_const.to_intraoperation_step||'='||p_move_tbl(i).to_intraoperation_step||'@'||
1288: qa_ss_const.from_intraoperation_step||'='||p_move_tbl(i).fm_intraoperation_step||'@'||
1289: qa_ss_const.sales_order||'=@'||
1290: qa_ss_const.operation_code||'='||p_move_tbl(i).fm_operation_code||'@'||
1291: qa_ss_const.transaction_type||'='||move_txn_meaning||'=@'||
1292: qa_ss_const.to_department||'='||p_move_tbl(i).to_department_id||'@'||
1293: qa_ss_const.to_operation_code||'='||p_move_tbl(i).to_operation_code||'@'||
1294: qa_ss_const.serial_number||'='||p_assy_serial||'@'||

Line 1291: qa_ss_const.transaction_type||'='||move_txn_meaning||'=@'||

1287: qa_ss_const.to_intraoperation_step||'='||p_move_tbl(i).to_intraoperation_step||'@'||
1288: qa_ss_const.from_intraoperation_step||'='||p_move_tbl(i).fm_intraoperation_step||'@'||
1289: qa_ss_const.sales_order||'=@'||
1290: qa_ss_const.operation_code||'='||p_move_tbl(i).fm_operation_code||'@'||
1291: qa_ss_const.transaction_type||'='||move_txn_meaning||'=@'||
1292: qa_ss_const.to_department||'='||p_move_tbl(i).to_department_id||'@'||
1293: qa_ss_const.to_operation_code||'='||p_move_tbl(i).to_operation_code||'@'||
1294: qa_ss_const.serial_number||'='||p_assy_serial||'@'||
1295: qa_ss_const.transaction_date||'='||sysdate||'@'||

Line 1292: qa_ss_const.to_department||'='||p_move_tbl(i).to_department_id||'@'||

1288: qa_ss_const.from_intraoperation_step||'='||p_move_tbl(i).fm_intraoperation_step||'@'||
1289: qa_ss_const.sales_order||'=@'||
1290: qa_ss_const.operation_code||'='||p_move_tbl(i).fm_operation_code||'@'||
1291: qa_ss_const.transaction_type||'='||move_txn_meaning||'=@'||
1292: qa_ss_const.to_department||'='||p_move_tbl(i).to_department_id||'@'||
1293: qa_ss_const.to_operation_code||'='||p_move_tbl(i).to_operation_code||'@'||
1294: qa_ss_const.serial_number||'='||p_assy_serial||'@'||
1295: qa_ss_const.transaction_date||'='||sysdate||'@'||
1296: qa_ss_const.project_number||'='||p_move_tbl(i).project_id||'@'||

Line 1293: qa_ss_const.to_operation_code||'='||p_move_tbl(i).to_operation_code||'@'||

1289: qa_ss_const.sales_order||'=@'||
1290: qa_ss_const.operation_code||'='||p_move_tbl(i).fm_operation_code||'@'||
1291: qa_ss_const.transaction_type||'='||move_txn_meaning||'=@'||
1292: qa_ss_const.to_department||'='||p_move_tbl(i).to_department_id||'@'||
1293: qa_ss_const.to_operation_code||'='||p_move_tbl(i).to_operation_code||'@'||
1294: qa_ss_const.serial_number||'='||p_assy_serial||'@'||
1295: qa_ss_const.transaction_date||'='||sysdate||'@'||
1296: qa_ss_const.project_number||'='||p_move_tbl(i).project_id||'@'||
1297: qa_ss_const.task_number||'='||p_move_tbl(i).task_id;

Line 1294: qa_ss_const.serial_number||'='||p_assy_serial||'@'||

1290: qa_ss_const.operation_code||'='||p_move_tbl(i).fm_operation_code||'@'||
1291: qa_ss_const.transaction_type||'='||move_txn_meaning||'=@'||
1292: qa_ss_const.to_department||'='||p_move_tbl(i).to_department_id||'@'||
1293: qa_ss_const.to_operation_code||'='||p_move_tbl(i).to_operation_code||'@'||
1294: qa_ss_const.serial_number||'='||p_assy_serial||'@'||
1295: qa_ss_const.transaction_date||'='||sysdate||'@'||
1296: qa_ss_const.project_number||'='||p_move_tbl(i).project_id||'@'||
1297: qa_ss_const.task_number||'='||p_move_tbl(i).task_id;
1298:

Line 1295: qa_ss_const.transaction_date||'='||sysdate||'@'||

1291: qa_ss_const.transaction_type||'='||move_txn_meaning||'=@'||
1292: qa_ss_const.to_department||'='||p_move_tbl(i).to_department_id||'@'||
1293: qa_ss_const.to_operation_code||'='||p_move_tbl(i).to_operation_code||'@'||
1294: qa_ss_const.serial_number||'='||p_assy_serial||'@'||
1295: qa_ss_const.transaction_date||'='||sysdate||'@'||
1296: qa_ss_const.project_number||'='||p_move_tbl(i).project_id||'@'||
1297: qa_ss_const.task_number||'='||p_move_tbl(i).task_id;
1298:
1299: IF (l_log_level <= wip_constants.trace_logging) THEN

Line 1296: qa_ss_const.project_number||'='||p_move_tbl(i).project_id||'@'||

1292: qa_ss_const.to_department||'='||p_move_tbl(i).to_department_id||'@'||
1293: qa_ss_const.to_operation_code||'='||p_move_tbl(i).to_operation_code||'@'||
1294: qa_ss_const.serial_number||'='||p_assy_serial||'@'||
1295: qa_ss_const.transaction_date||'='||sysdate||'@'||
1296: qa_ss_const.project_number||'='||p_move_tbl(i).project_id||'@'||
1297: qa_ss_const.task_number||'='||p_move_tbl(i).task_id;
1298:
1299: IF (l_log_level <= wip_constants.trace_logging) THEN
1300: wip_logger.log(p_msg => 'l_context_values='||l_context_values,

Line 1297: qa_ss_const.task_number||'='||p_move_tbl(i).task_id;

1293: qa_ss_const.to_operation_code||'='||p_move_tbl(i).to_operation_code||'@'||
1294: qa_ss_const.serial_number||'='||p_assy_serial||'@'||
1295: qa_ss_const.transaction_date||'='||sysdate||'@'||
1296: qa_ss_const.project_number||'='||p_move_tbl(i).project_id||'@'||
1297: qa_ss_const.task_number||'='||p_move_tbl(i).task_id;
1298:
1299: IF (l_log_level <= wip_constants.trace_logging) THEN
1300: wip_logger.log(p_msg => 'l_context_values='||l_context_values,
1301: x_returnStatus => l_return_status);

Line 1307: p_txn_number => qa_ss_const.wip_move_txn,

1303:
1304: BEGIN
1305: -- Check whether qualtiy collection plan exist or not
1306: l_quality_plan_exist := qa_txn_grp.evaluate_triggers(
1307: p_txn_number => qa_ss_const.wip_move_txn,
1308: p_org_id => p_org_id,
1309: p_context_values => l_context_values,
1310: x_plan_txn_ids => l_plan_txn_ids);
1311: IF(l_quality_plan_exist = fnd_api.g_false)THEN

Line 1322: p_txn_number => qa_ss_const.wip_move_txn,

1318: -- Fixed bug 5335024.Call is_commit_allowed() instead of commit_allowed()
1319: -- because is_commit_allowed will also check child quality plan.
1320: -- Moreover, is_commit_allowed will also return quality plan name.
1321: l_commit_allow := qa_txn_grp.is_commit_allowed(
1322: p_txn_number => qa_ss_const.wip_move_txn,
1323: p_org_id => p_org_id,
1324: p_plan_txn_ids => l_plan_txn_ids,
1325: --Pass 0 as Bryan suggested.
1326: p_collection_id => 0,

Line 1335: l_qa_enabled := qa_txn_grp.qa_enabled(p_txn_number => qa_ss_const.wip_move_txn,

1331: x_quality_require := fnd_api.g_true;
1332: GOTO end_quality_check;
1333: --Start of Fix bug 13336388
1334: ELSE
1335: l_qa_enabled := qa_txn_grp.qa_enabled(p_txn_number => qa_ss_const.wip_move_txn,
1336: p_org_id => p_org_id);
1337: IF(l_qa_enabled = fnd_api.g_true)THEN
1338: l_collection_id := qa_txn_grp.get_collection_id();
1339: qa_txn_grp.post_background_results (

Line 1340: p_txn_number => qa_ss_const.wip_move_txn,

1336: p_org_id => p_org_id);
1337: IF(l_qa_enabled = fnd_api.g_true)THEN
1338: l_collection_id := qa_txn_grp.get_collection_id();
1339: qa_txn_grp.post_background_results (
1340: p_txn_number => qa_ss_const.wip_move_txn,
1341: p_org_id => p_org_id,
1342: p_plan_txn_ids => l_plan_txn_ids,
1343: p_context_values => l_context_ids,
1344: p_collection_id => l_collection_id);